-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathbdd.sql
More file actions
16 lines (12 loc) · 3.29 KB
/
bdd.sql
File metadata and controls
16 lines (12 loc) · 3.29 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
INSERT INTO `spot` (`id`, `nom`, `description`, `photo`, `typePlage`, `interdiction`, `famille`, `frequentation`, `danger`, `accesParking`, `longitude`, `latitude`, `valider`, `user_id`, `created_at`, `updated_at`) VALUES ('0', 'Coudalère', 'spot de vague par tram forte', 'photo.png', 'beton', 'aucune', '0', 'moyen', 'digue, rocher', 'facile, 500mètres de la 2x2 voie', '3.017967', '42.815422', 'ok', '1', '2018-01-14 00:00:00', '2018-01-14 00:00:00');
INSERT INTO `spot` (`id`, `nom`, `description`, `photo`, `typePlage`, `interdiction`, `famille`, `frequentation`, `danger`, `accesParking`, `longitude`, `latitude`, `valider`, `user_id`, `created_at`, `updated_at`) VALUES ('1', 'Lac de vaivre', 'beau lac mais un peut petit', 'lacVesoul.png', 'herbe', 'Bouée au îles aux oiseaux demande à la base nautique', '1', 'moyen', 'aucun sauf peut être îles aux oiseaux', 'A coté de la base nautique', '6.1', '47.6333', 'ok', '1', '2018-01-18 00:00:00', NULL);
INSERT INTO `spot` (`id`, `nom`, `description`, `photo`, `typePlage`, `interdiction`, `famille`, `frequentation`, `danger`, `accesParking`, `longitude`, `latitude`, `valider`, `user_id`, `created_at`, `updated_at`) VALUES ('3', 'Gruissan', 'Super spot souvent du vent fort', 'gruissan.png', 'sable', 'Aucune', '0', 'beaucoup', 'Tramontane qui envoie au large + banc de sable', 'parking prés du surfshop', '3.0862', '43.1071', 'ok', '1', '2018-01-18 00:00:00', NULL);
INSERT INTO `sport` (`id`, `nom`, `description`, `created_at`, `updated_at`) VALUES ('3', 'planche a voile', 'sport trop bien !!', '2018-01-14 00:00:00', '2018-01-14 00:00:00');
INSERT INTO `sport` (`id`, `nom`, `description`, `created_at`, `updated_at`) VALUES ('0', 'kitesurf', 'Sport avec un aile', '2018-01-18 00:00:00', NULL);
INSERT INTO `sport` (`id`, `nom`, `description`, `created_at`, `updated_at`) VALUES ('1', 'padle', 'tranquille', '2018-01-18 00:00:00', NULL);
INSERT INTO `disciplines` (`id`, `nom`, `description`, `created_at`, `updated_at`) VALUES ('0', 'Vague', 'Avec des vague et tu vent ', '2018-01-14 00:00:00', '2018-01-14 00:00:00');
INSERT INTO `disciplines` (`id`, `nom`, `description`, `created_at`, `updated_at`) VALUES ('1', 'Freeride', 'vitesse ', '2018-01-15 00:00:00', '2018-01-14 00:00:00');
INSERT INTO `disciplines` (`id`, `nom`, `description`, `created_at`, `updated_at`) VALUES ('3', 'Salom', 'vitesse + manoeuvre ', '2018-01-15 00:00:00', '2018-01-14 00:00:00');
INSERT INTO `post` (`id`, `bestWindForceMinus`, `bestWindDirection`, `levelMini`, `danger`, `user_id`, `sport_id`, `spot_id`, `discipline_id`, `created_at`, `updated_at`, `bestWindForceMax`) VALUES ('0', '25', 'NO', '3', 'digues, rochers', '1', '1', '1', '1', '2018-01-14 00:00:00', '2018-01-14 00:00:00', '30');
INSERT INTO `post` (`id`, `bestWindForceMinus`, `bestWindDirection`, `levelMini`, `danger`, `user_id`, `sport_id`, `spot_id`, `discipline_id`, `created_at`, `updated_at`, `bestWindForceMax`) VALUES ('1', '0', 'NE', '3', 'digues, rochers', '2', '2', '2', '2', '2018-01-14 00:00:00', '2018-01-14 00:00:00', '5');
INSERT INTO `post` (`id`, `bestWindForceMinus`, `bestWindDirection`, `levelMini`, `danger`, `user_id`, `sport_id`, `spot_id`, `discipline_id`, `created_at`, `updated_at`, `bestWindForceMax`) VALUES ('2', '25', 'NO', '3', 'digues, rochers', '3', '3', '3', '3', '2018-01-14 00:00:00', '2018-01-14 00:00:00', '30');