-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinitDB.sql
53 lines (53 loc) · 9.83 KB
/
initDB.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
INSERT INTO `GROUPS` (`GROUPNAME`) VALUES ('admin');
INSERT INTO `GROUPS` (`GROUPNAME`) VALUES ('moderator');
INSERT INTO `GROUPS` (`GROUPNAME`) VALUES ('standard');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('angelkiro', 'angelkiro@visit.ch', 'Neto da Silva', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'André');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto1', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto2', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto3', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto4', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto5', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto6', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto7', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto8', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto9', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto10', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto11', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto12', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USERS` (`USERNAME`, `EMAIL`, `NAME`, `PASSWORD`, `SURNAME`) VALUES ('toto13', 'toto@visit.ch', 'toto', '4b358ed84b7940619235a22328c584c7bc4508d4524e75231d6f450521d16a17', 'Toto');
INSERT INTO `USER_GROUP` (`username`, `groupName`) VALUES ('angelkiro', 'admin');
INSERT INTO `USER_GROUP` (`username`, `groupName`) VALUES ('angelkiro', 'moderator');
INSERT INTO `USER_GROUP` (`username`, `groupName`) VALUES ('toto1', 'moderator');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `ISVALIDATE`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma description', '1', '465.5', '98', '2018-03-25 00:00:00', 'Mallerayy', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `ISVALIDATE`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma description1', '1', '465.5', '98', '2018-04-16 00:00:00', 'Tavannes', 'toto3');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `ISVALIDATE`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma description2', '1', '465.5', '98', '2017-08-26 00:00:00', 'Tavanness', 'toto3');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `ISVALIDATE`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma description3', '1', '465.5', '98', '2016-04-16 00:00:00', 'Tavannessss', 'toto3');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison1', '47.2333', '7.2667', '2018-04-18 00:00:00', 'Malleray', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison2', '5245.3', '246.12', '2018-04-18 00:00:00', 'Totoland1', 'toto1');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison3', '52.53', '246.12', '2018-04-18 00:00:00', 'Totoland2', 'toto2');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison4', '52.33', '246.12', '2018-04-18 00:00:00', 'Totoland3', 'toto3');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison5', '522.3', '246.12', '2018-04-18 00:00:00', 'Totoland4', 'toto4');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison6', '52.233', '246.12', '2018-04-18 00:00:00', 'Totoland5', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison7', '52.323', '246.12', '2018-04-18 00:00:00', 'Totoland6', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison8', '52.3', '246.12', '2018-04-18 00:00:00', 'Totoland7', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison9', '52.3', '246.12', '2018-04-18 00:00:00', 'Totoland8', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison0', '572.3', '246.12', '2018-04-18 00:00:00', 'Totoland9', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison10', '852.3', '246.12', '2018-04-18 00:00:00', '1Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison11', '052.3', '246.12', '2018-04-18 00:00:00', '2Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison12', '524.3', '246.12', '2018-04-18 00:00:00', '3Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison13', '525.3', '246.12', '2018-04-18 00:00:00', '4Malleray', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison14', '526.3', '246.12', '2018-04-18 00:00:00', '5Totoland', 'toto1');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison15', '528.3', '246.12', '2018-04-18 00:00:00', '6Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison16', '529.3', '246.12', '2018-04-18 00:00:00', '7Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison17', '520.3', '246.12', '2018-04-18 00:00:00', '8Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison18', '52.3', '246.12', '2018-04-18 00:00:00', '9Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison19', '5123', '246.12', '2018-04-18 00:00:00', '0Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison20', '522.3', '246.12', '2018-04-18 00:00:00', 'Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison21', '532.3', '246.12', '2018-04-18 00:00:00', 'Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison22', '542.3', '246.12', '2018-04-18 00:00:00', 'Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison23', '552.3', '246.12', '2018-04-18 00:00:00', 'Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison24', '526.3', '246.12', '2018-04-18 00:00:00', 'Totoland', 'angelkiro');
INSERT INTO `PLACES` (`ID`, `DESCRIPTION`, `LATITUDE`, `LONGITUDE`, `PUBLISHED_DATE`, `TITLE`, `PUBLISHED_BY_USERNAME`) VALUES (NULL, 'Ma maison25', '527.3', '246.12', '2018-04-18 00:00:00', 'Totoland', 'angelkiro');
INSERT INTO `EVALUATION` (`ID`, `SCORE`, `EVALUATED_BY_USERNAME`, `PLACE_EVALUATED_ID`) VALUES (NULL, '25', 'angelkiro', '1');
INSERT INTO `EVALUATION` (`ID`, `SCORE`, `EVALUATED_BY_USERNAME`, `PLACE_EVALUATED_ID`) VALUES (NULL, '84', 'toto1', '1');
INSERT INTO `EVALUATION` (`ID`, `SCORE`, `EVALUATED_BY_USERNAME`, `PLACE_EVALUATED_ID`) VALUES (NULL, '44', 'toto1', '2');