-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtest.script
195 lines (195 loc) · 18.5 KB
/
test.script
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
SET DATABASE UNIQUE NAME HSQLDB3A0390C876
SET DATABASE GC 0
SET DATABASE DEFAULT RESULT MEMORY ROWS 0
SET DATABASE EVENT LOG LEVEL 0
SET DATABASE SQL NAMES FALSE
SET DATABASE SQL REGULAR NAMES TRUE
SET DATABASE SQL REFERENCES FALSE
SET DATABASE SQL SIZE FALSE
SET DATABASE SQL TYPES FALSE
SET DATABASE SQL TDC DELETE TRUE
SET DATABASE SQL TDC UPDATE TRUE
SET DATABASE SQL TRANSLATE TTI TYPES TRUE
SET DATABASE SQL CONCAT NULLS TRUE
SET DATABASE SQL NULLS FIRST TRUE
SET DATABASE SQL UNIQUE NULLS TRUE
SET DATABASE SQL CONVERT TRUNCATE TRUE
SET DATABASE SQL AVG SCALE 0
SET DATABASE SQL DOUBLE NAN TRUE
SET DATABASE SQL LONGVAR IS LOB FALSE
SET DATABASE TRANSACTION CONTROL LOCKS
SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED
SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE
SET DATABASE TEXT TABLE DEFAULTS ''
SET FILES WRITE DELAY 10
SET FILES BACKUP INCREMENT FALSE
SET FILES CACHE SIZE 10000
SET FILES CACHE ROWS 50000
SET FILES SCALE 1
SET FILES LOB SCALE 32
SET FILES DEFRAG 0
SET FILES NIO TRUE
SET FILES NIO SIZE 256
SET FILES LOG TRUE
SET FILES LOG SIZE 200
CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e'
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
SET SCHEMA PUBLIC
CREATE MEMORY TABLE PUBLIC.TAPPLICATIONS(APPLIEDTRIPS_ID BIGINT NOT NULL,APPLICANTS_ID BIGINT NOT NULL,PRIMARY KEY(APPLIEDTRIPS_ID,APPLICANTS_ID))
CREATE MEMORY TABLE PUBLIC.TRATINGS(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,COMMENT VARCHAR(255),VALUE INTEGER NOT NULL,ABOUT_TRIP_ID BIGINT NOT NULL,ABOUT_USER_ID BIGINT NOT NULL,FROM_TRIP_ID BIGINT NOT NULL,FROM_USER_ID BIGINT NOT NULL)
ALTER TABLE PUBLIC.TRATINGS ALTER COLUMN ID RESTART WITH 21
CREATE MEMORY TABLE PUBLIC.TSEATS(COMMENT VARCHAR(255),STATUS INTEGER NOT NULL,TRIP_ID BIGINT,USER_ID BIGINT,PRIMARY KEY(TRIP_ID,USER_ID))
CREATE MEMORY TABLE PUBLIC.TTRIPS(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,ARRIVALDATE TIMESTAMP NOT NULL,AVAILABLEPAX INTEGER NOT NULL,CLOSINGDATE TIMESTAMP NOT NULL,COMMENTS VARCHAR(255),DEPARTURE_ADDRESS VARCHAR(255) NOT NULL,DEPARTURE_CITY VARCHAR(255) NOT NULL,DEPARTURE_COUNTRY VARCHAR(255) NOT NULL,DEPARTURE_STATE VARCHAR(255) NOT NULL,DEPARTURE_WPT_LAT DOUBLE,DEPARTURE_WPT_LON DOUBLE,DEPARTURE_ZIPCODE VARCHAR(255) NOT NULL,DEPARTUREDATE TIMESTAMP NOT NULL,DESTINATION_ADDRESS VARCHAR(255) NOT NULL,DESTINATION_CITY VARCHAR(255) NOT NULL,DESTINATION_COUNTRY VARCHAR(255) NOT NULL,DESTINATION_STATE VARCHAR(255) NOT NULL,DESTINATION_WPT_LAT DOUBLE,DESTINATION_WPT_LON DOUBLE,DESTINATION_ZIPCODE VARCHAR(255) NOT NULL,ESTIMATEDCOST DOUBLE NOT NULL,MAXPAX INTEGER NOT NULL,STATUS INTEGER NOT NULL,PROMOTER_ID BIGINT NOT NULL,UNIQUE(ARRIVALDATE,PROMOTER_ID))
ALTER TABLE PUBLIC.TTRIPS ALTER COLUMN ID RESTART WITH 133
CREATE MEMORY TABLE PUBLIC.TUSERS(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,EMAIL VARCHAR(255) NOT NULL,LOGIN VARCHAR(255) NOT NULL,NAME VARCHAR(255),PASSWORD VARCHAR(255) NOT NULL,STATUS INTEGER NOT NULL,SURNAME VARCHAR(255))
ALTER TABLE PUBLIC.TUSERS ALTER COLUMN ID RESTART WITH 315
ALTER TABLE PUBLIC.TAPPLICATIONS ADD CONSTRAINT FK84A61B974DC647CB FOREIGN KEY(APPLIEDTRIPS_ID) REFERENCES PUBLIC.TTRIPS(ID)
ALTER TABLE PUBLIC.TAPPLICATIONS ADD CONSTRAINT FK84A61B97DAD05051 FOREIGN KEY(APPLICANTS_ID) REFERENCES PUBLIC.TUSERS(ID)
ALTER TABLE PUBLIC.TRATINGS ADD CONSTRAINT FKB3BBD382C91ED27C FOREIGN KEY(FROM_TRIP_ID,FROM_USER_ID) REFERENCES PUBLIC.TSEATS(TRIP_ID,USER_ID)
ALTER TABLE PUBLIC.TRATINGS ADD CONSTRAINT FKB3BBD3825CAFC442 FOREIGN KEY(ABOUT_TRIP_ID,ABOUT_USER_ID) REFERENCES PUBLIC.TSEATS(TRIP_ID,USER_ID)
ALTER TABLE PUBLIC.TSEATS ADD CONSTRAINT FK9418171AE18FA1B7 FOREIGN KEY(TRIP_ID) REFERENCES PUBLIC.TTRIPS(ID)
ALTER TABLE PUBLIC.TSEATS ADD CONSTRAINT FK9418171A17F3B7F7 FOREIGN KEY(USER_ID) REFERENCES PUBLIC.TUSERS(ID)
ALTER TABLE PUBLIC.TTRIPS ADD CONSTRAINT FK942C34FA4D91FDB0 FOREIGN KEY(PROMOTER_ID) REFERENCES PUBLIC.TUSERS(ID)
ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1
SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC
GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
GRANT DBA TO SA
SET SCHEMA PUBLIC
INSERT INTO TAPPLICATIONS VALUES(55,311)
INSERT INTO TAPPLICATIONS VALUES(55,312)
INSERT INTO TAPPLICATIONS VALUES(55,313)
INSERT INTO TAPPLICATIONS VALUES(55,314)
INSERT INTO TAPPLICATIONS VALUES(56,311)
INSERT INTO TAPPLICATIONS VALUES(56,313)
INSERT INTO TAPPLICATIONS VALUES(56,314)
INSERT INTO TAPPLICATIONS VALUES(57,314)
INSERT INTO TAPPLICATIONS VALUES(58,310)
INSERT INTO TAPPLICATIONS VALUES(58,313)
INSERT INTO TAPPLICATIONS VALUES(59,310)
INSERT INTO TAPPLICATIONS VALUES(59,311)
INSERT INTO TAPPLICATIONS VALUES(59,313)
INSERT INTO TAPPLICATIONS VALUES(60,313)
INSERT INTO TAPPLICATIONS VALUES(60,314)
INSERT INTO TAPPLICATIONS VALUES(61,310)
INSERT INTO TAPPLICATIONS VALUES(61,311)
INSERT INTO TAPPLICATIONS VALUES(61,313)
INSERT INTO TAPPLICATIONS VALUES(61,314)
INSERT INTO TAPPLICATIONS VALUES(62,310)
INSERT INTO TAPPLICATIONS VALUES(62,311)
INSERT INTO TAPPLICATIONS VALUES(62,314)
INSERT INTO TAPPLICATIONS VALUES(63,310)
INSERT INTO TAPPLICATIONS VALUES(63,311)
INSERT INTO TAPPLICATIONS VALUES(63,313)
INSERT INTO TAPPLICATIONS VALUES(64,312)
INSERT INTO TAPPLICATIONS VALUES(64,314)
INSERT INTO TAPPLICATIONS VALUES(65,310)
INSERT INTO TAPPLICATIONS VALUES(65,311)
INSERT INTO TAPPLICATIONS VALUES(65,312)
INSERT INTO TAPPLICATIONS VALUES(65,313)
INSERT INTO TAPPLICATIONS VALUES(70,311)
INSERT INTO TAPPLICATIONS VALUES(70,312)
INSERT INTO TAPPLICATIONS VALUES(74,311)
INSERT INTO TAPPLICATIONS VALUES(74,312)
INSERT INTO TAPPLICATIONS VALUES(113,314)
INSERT INTO TAPPLICATIONS VALUES(114,311)
INSERT INTO TAPPLICATIONS VALUES(115,313)
INSERT INTO TAPPLICATIONS VALUES(115,314)
INSERT INTO TAPPLICATIONS VALUES(116,311)
INSERT INTO TAPPLICATIONS VALUES(116,312)
INSERT INTO TAPPLICATIONS VALUES(116,313)
INSERT INTO TAPPLICATIONS VALUES(119,310)
INSERT INTO TAPPLICATIONS VALUES(122,313)
INSERT INTO TAPPLICATIONS VALUES(123,310)
INSERT INTO TAPPLICATIONS VALUES(123,311)
INSERT INTO TAPPLICATIONS VALUES(123,313)
INSERT INTO TAPPLICATIONS VALUES(123,314)
INSERT INTO TAPPLICATIONS VALUES(128,310)
INSERT INTO TAPPLICATIONS VALUES(128,314)
INSERT INTO TAPPLICATIONS VALUES(129,311)
INSERT INTO TAPPLICATIONS VALUES(129,312)
INSERT INTO TAPPLICATIONS VALUES(130,312)
INSERT INTO TRATINGS VALUES(14,'Buena compania',4,59,312,59,310)
INSERT INTO TRATINGS VALUES(15,'Buen trato',5,59,313,59,310)
INSERT INTO TRATINGS VALUES(16,'Experiencia fantastica',5,59,311,59,310)
INSERT INTO TRATINGS VALUES(17,'Un dia estupendo',3,58,313,58,310)
INSERT INTO TSEATS VALUES(' Se realizara una unica parada durante el viaje a las 2 horas transcurridas',0,55,310)
INSERT INTO TSEATS VALUES(NULL,0,55,311)
INSERT INTO TSEATS VALUES(NULL,0,55,312)
INSERT INTO TSEATS VALUES(' ',0,56,310)
INSERT INTO TSEATS VALUES(' Viaje largo. Se recomienda llevar comida o parar a cenar a lo largo del viaje',0,57,311)
INSERT INTO TSEATS VALUES(NULL,0,58,310)
INSERT INTO TSEATS VALUES(' ',0,58,311)
INSERT INTO TSEATS VALUES(NULL,0,58,313)
INSERT INTO TSEATS VALUES(NULL,0,59,310)
INSERT INTO TSEATS VALUES(NULL,0,59,311)
INSERT INTO TSEATS VALUES(' ',0,59,312)
INSERT INTO TSEATS VALUES(NULL,0,59,313)
INSERT INTO TSEATS VALUES(' Se precisa puntualidad (viaje de trabajo)',0,60,312)
INSERT INTO TSEATS VALUES(NULL,0,60,313)
INSERT INTO TSEATS VALUES(NULL,0,61,310)
INSERT INTO TSEATS VALUES(NULL,0,61,311)
INSERT INTO TSEATS VALUES(' ',0,61,312)
INSERT INTO TSEATS VALUES(NULL,1,62,311)
INSERT INTO TSEATS VALUES(' ',0,62,312)
INSERT INTO TSEATS VALUES(NULL,0,63,310)
INSERT INTO TSEATS VALUES(NULL,0,63,311)
INSERT INTO TSEATS VALUES(' No se contempla la opcion de hospedarse en un hotel para retomar el viaje al dia siguiente',0,63,312)
INSERT INTO TSEATS VALUES(NULL,0,63,313)
INSERT INTO TSEATS VALUES(' ',0,64,313)
INSERT INTO TSEATS VALUES(NULL,1,65,311)
INSERT INTO TSEATS VALUES(' ',0,65,314)
INSERT INTO TSEATS VALUES(NULL,0,70,311)
INSERT INTO TSEATS VALUES(NULL,0,70,312)
INSERT INTO TSEATS VALUES(NULL,0,115,313)
INSERT INTO TSEATS VALUES(NULL,0,115,314)
INSERT INTO TSEATS VALUES(NULL,0,116,311)
INSERT INTO TSEATS VALUES(NULL,0,119,310)
INSERT INTO TSEATS VALUES(NULL,1,123,310)
INSERT INTO TSEATS VALUES(NULL,1,123,311)
INSERT INTO TSEATS VALUES(NULL,0,123,313)
INSERT INTO TSEATS VALUES(NULL,1,123,314)
INSERT INTO TSEATS VALUES(NULL,0,128,310)
INSERT INTO TSEATS VALUES(NULL,0,128,314)
INSERT INTO TSEATS VALUES(NULL,0,129,311)
INSERT INTO TSEATS VALUES(NULL,1,129,312)
INSERT INTO TSEATS VALUES(NULL,0,130,312)
INSERT INTO TTRIPS VALUES(55,'2016-03-24 18:00:00.000000',0,'2016-03-22 00:00:00.000000',' Se realizara una unica parada durante el viaje a las 2 horas transcurridas','Uria','Oviedo','Espana','Asturias',33.0E0,54.0E0,'33400','2016-03-24 14:00:00.000000','Santa Apolonia','Salamanca','Espana','Castilla y Leon',44.0E0,31.0E0,'43100',90.0E0,2,3,310)
INSERT INTO TTRIPS VALUES(56,'2016-04-14 12:00:00.000000',2,'2016-03-13 00:00:00.000000',' ','Isabel la Catolica','Gijon','Espana','Asturias',44.0E0,12.0E0,'33213','2016-04-14 07:00:00.000000','Retiro','Madrid','Espana','Madrid',15.0E0,24.0E0,'20011',150.0E0,2,1,310)
INSERT INTO TTRIPS VALUES(57,'2016-03-30 01:00:00.000000',3,'2016-03-25 00:00:00.000000',' Viaje largo. Se recomienda llevar comida o parar a cenar a lo largo del viaje','Fernando Moran','Ourense','Espana','Galicia',29.0E0,30.0E0,'36081','2016-03-29 16:00:00.000000','Ramblas','Barcelona','Espana','Cataluna',41.0E0,13.0E0,'44101',300.0E0,3,3,311)
INSERT INTO TTRIPS VALUES(58,'2016-03-01 19:29:01.000000',0,'2016-03-01 19:29:01.000000',' ','La Fuente','Malaga','Espana','Andalucia',55.0E0,33.0E0,'42104','2016-03-01 19:29:01.000000','Cuba','Cordoba','Espana','Andalucia',52.0E0,42.0E0,'43205',100.0E0,3,3,311)
INSERT INTO TTRIPS VALUES(59,'2016-03-01 19:29:06.000000',1,'2016-03-01 19:29:06.000000',' ','Del Hierro','Murcia','Espana','Murcia',55.0E0,31.0E0,'36028','2016-03-01 19:29:06.000000','Hernandez Cortes','Sevilla','Espana','Andalucia',56.0E0,28.0E0,'43154',130.0E0,4,3,312)
INSERT INTO TTRIPS VALUES(60,'2016-05-06 09:00:00.000000',3,'2016-05-04 00:00:00.000000',' Se precisa puntualidad (viaje de trabajo)','Balsera','Caceres','Espana','Badajoz',41.0E0,35.0E0,'35212','2016-05-06 04:00:00.000000','Matalascanas','Huelva','Espana','Andalucia',46.0E0,34.0E0,'41263',250.0E0,4,1,312)
INSERT INTO TTRIPS VALUES(61,'2016-04-05 17:00:00.000000',2,'2016-04-04 00:00:00.000000',' ','Torre de Enol','Burgos','Espana','Castilla y Leon',23.0E0,43.0E0,'31267','2016-04-05 10:00:00.000000','Calvo Sotelo','Bilbao','Espana','Pais Vasco',24.0E0,34.0E0,'34087',230.0E0,4,1,312)
INSERT INTO TTRIPS VALUES(62,'2016-03-27 21:00:00.000000',4,'2016-03-23 00:00:00.000000',' ','EO','Zaragoza','Espana','Aragon',33.0E0,45.0E0,'32143','2016-03-27 15:00:00.000000','La Camara','Valencia','Espana','Comunidad Valenciana',43.0E0,21.0E0,'42153',190.0E0,4,3,312)
INSERT INTO TTRIPS VALUES(63,'2016-05-31 04:00:00.000000',1,'2016-05-28 00:00:00.000000',' No se contempla la opcion de hospedarse en un hotel para retomar el viaje al dia siguiente','Alamo','Madrid','Espana','Madrid',33.0E0,43.0E0,'35213','2016-05-30 12:00:00.000000','Notre Dame','Paris','Francia','Paris',66.0E0,53.0E0,'01948',600.0E0,4,0,312)
INSERT INTO TTRIPS VALUES(64,'2016-05-18 18:00:00.000000',5,'2016-05-11 00:00:00.000000',' ','Fuertes','Lugo','Espana','Galicia',33.0E0,21.0E0,'31241','2016-05-18 10:00:00.000000','Calzada','Leon','Espana','Castilla y Leon',35.0E0,29.0E0,'34311',220.0E0,5,1,313)
INSERT INTO TTRIPS VALUES(65,'2016-05-09 12:00:00.000000',6,'2016-05-07 00:00:00.000000',' ','Ramirez','Pontevedra','Espana','Galicia',21.0E0,44.0E0,'31201','2016-05-09 08:00:00.000000','Perez','Aviles','Espana','Asturias',32.0E0,23.0E0,'33213',240.0E0,6,1,314)
INSERT INTO TTRIPS VALUES(113,'2016-06-14 00:22:06.000000',2,'2016-06-12 00:22:06.000000','Trata de ser lo mas limpio posible','General Elorza','Oviedo','Espa\u00f1a','Asturias',23.4E0,43.45E0,'22006','2016-06-13 00:22:06.000000','Paseo de la castellana','Madrid','Espa\u00f1a','Madrid',23.4E0,43.45E0,'33778',70.0E0,2,0,310)
INSERT INTO TTRIPS VALUES(114,'2016-06-03 00:22:30.000000',3,'2016-06-01 00:22:30.000000','Trata de ser lo mas limpio posible','Avenida del Mar','Malaga','Espa\u00f1a','Andalucia',23.4E0,43.45E0,'50050','2016-06-02 00:22:30.000000','Canaletas','Barcelona','Espa\u00f1a','Catalu\u00f1a',23.4E0,43.45E0,'54235',70.0E0,3,0,310)
INSERT INTO TTRIPS VALUES(115,'2016-07-01 00:24:44.000000',2,'2016-05-31 00:12:44.000000','Trata de ser lo mas limpio posible','Rua Santiago','Santiago','Espa\u00f1a','Galicia',23.4E0,43.45E0,'22006','2016-05-31 00:24:44.000000','Calle General','Soria','Espa\u00f1a','Castilla Y Leon',23.4E0,43.45E0,'33778',70.0E0,4,0,310)
INSERT INTO TTRIPS VALUES(116,'2016-06-04 00:25:50.000000',2,'2016-06-02 00:25:50.000000','Trata de ser lo mas limpio posible','Pedro Perez','Aviles','Espa\u00f1a','Asturias',23.4E0,43.45E0,'22004','2016-06-03 00:25:50.000000','Paseo de los corintios','Cartagena','Espa\u00f1a','Murcia',23.4E0,43.45E0,'33775',70.0E0,3,0,310)
INSERT INTO TTRIPS VALUES(117,'2016-05-26 00:26:51.000000',3,'2016-05-24 00:26:51.000000','Try to be clean as posible','Oxford avenue','London','England','London',23.4E0,43.45E0,'89090','2016-05-25 00:26:51.000000','May 1st street','Leiciester','England','East Midlands',23.4E0,43.45E0,'89090',70.0E0,4,0,310)
INSERT INTO TTRIPS VALUES(118,'2016-06-01 13:27:41.000000',2,'2016-05-31 00:27:41.000000','Trata de ser lo mas limpio posible','General Rodrigo','Jaen','Espa\u00f1a','Andalucia',23.4E0,43.45E0,'22006','2016-06-01 00:27:41.000000','Paseo de la Gracia','Madrid','Espa\u00f1a','Madrid',23.4E0,43.45E0,'33778',70.0E0,2,0,311)
INSERT INTO TTRIPS VALUES(119,'2016-06-03 00:28:17.000000',1,'2016-06-01 00:28:17.000000','Trata de ser lo mas limpio posible','General Limpio','Tineo','Espa\u00f1a','Asturias',23.4E0,43.45E0,'22006','2016-06-02 00:28:17.000000','Picaporte ','Getafe','Espa\u00f1a','Madrid',23.4E0,43.45E0,'33778',70.0E0,2,0,311)
INSERT INTO TTRIPS VALUES(120,'2016-05-26 10:28:54.000000',2,'2016-05-24 00:28:54.000000','Trata de ser lo mas limpio posible','Calle verde','Lugo','Espa\u00f1a','Galicia',23.4E0,43.45E0,'22006','2016-05-26 00:28:54.000000','Calle gris','Alcobendas','Espa\u00f1a','Madrid',23.4E0,43.45E0,'33778',70.0E0,2,0,311)
INSERT INTO TTRIPS VALUES(121,'2016-06-08 00:30:00.000000',2,'2016-06-05 00:30:00.000000','Try to be clean as posible','Oxford avenue','Birmingham','England','London',23.4E0,43.45E0,'89090','2016-06-07 00:30:00.000000','May 1st street','Newcastle','England','East Midlands',23.4E0,43.45E0,'89090',70.0E0,2,0,311)
INSERT INTO TTRIPS VALUES(122,'2016-06-16 00:30:47.000000',2,'2016-06-14 00:30:47.000000','Trata de ser lo mas limpio posible','Calle tabla','Llanes','Espa\u00f1a','Asturias',23.4E0,43.45E0,'22006','2016-06-15 00:30:47.000000','Calle Pa\u00f1uelos','Ciudad Real','Espa\u00f1a','Ciudad Real',23.4E0,43.45E0,'33778',70.0E0,2,0,312)
INSERT INTO TTRIPS VALUES(123,'2016-05-29 04:31:30.000000',0,'2016-05-27 00:31:30.000000','Trata de ser lo mas limpio posible','Castellets','Girona','Espa\u00f1a','Girona',23.4E0,43.45E0,'22006','2016-05-29 00:31:30.000000','Paella plaza','Castellon','Espa\u00f1a','Castellon',23.4E0,43.45E0,'33778',70.0E0,2,0,312)
INSERT INTO TTRIPS VALUES(124,'2016-06-23 00:32:35.000000',4,'2016-06-21 00:32:35.000000','Trata de ser lo mas limpio posible','Catedratico Setienes','Mi\u00f1o','Espa\u00f1a','Galicia',23.4E0,43.45E0,'22006','2016-06-22 00:32:35.000000','Catedratico Villanueva','Bilbao','Espa\u00f1a','Pais Vasco',23.4E0,43.45E0,'33778',30.0E0,4,0,312)
INSERT INTO TTRIPS VALUES(125,'2016-06-01 00:34:11.000000',2,'2016-05-29 00:34:11.000000','Trata de ser lo mas limpio posible','General Tierra','Rosario','Argentina','Rosario',23.4E0,43.45E0,'22006','2016-05-31 00:34:11.000000','Paseo del Fuego','Buenos Aires','Argentina','Buenos Aires',23.4E0,43.45E0,'33778',70.0E0,2,0,313)
INSERT INTO TTRIPS VALUES(126,'2016-06-03 00:34:54.000000',2,'2016-06-02 00:34:54.000000','Trata de ser lo mas limpio posible','Tierra del Fuego','Vigo','Espa\u00f1a','Galicia',23.4E0,43.45E0,'42342','2016-06-02 00:34:54.000000','Calle Chile','Segovia','Espa\u00f1a','Castilla y Leon',23.4E0,43.45E0,'33778',70.0E0,2,0,313)
INSERT INTO TTRIPS VALUES(127,'2016-06-07 08:35:39.000000',2,'2016-06-06 00:35:39.000000','Trata de ser lo mas limpio posible','Calle Peru','Leon','Espa\u00f1a','Catalu\u00f1a',23.4E0,43.45E0,'52345','2016-06-07 00:35:39.000000','Calle General','Tarragona','Espa\u00f1a','Catalu\u00f1a',23.4E0,43.45E0,'33778',70.0E0,2,0,313)
INSERT INTO TTRIPS VALUES(128,'2016-06-14 00:36:31.000000',0,'2016-06-12 00:36:31.000000','Trata de ser lo mas limpio posible','Torreon Torreon','A Coru\u00f1a','Espa\u00f1a','Galicia',23.4E0,43.45E0,'22006','2016-06-13 00:36:31.000000','La platita','Cadiz','Espa\u00f1a','Cadiz',23.4E0,43.45E0,'33778',70.0E0,2,0,313)
INSERT INTO TTRIPS VALUES(129,'2016-06-15 00:37:40.000000',1,'2016-06-12 00:37:40.000000','Try to be clean as posible','Oxford avenue','Manchester','England','London',23.4E0,43.45E0,'89090','2016-06-14 00:37:40.000000','May 4st street','Essex','England','East Midlands',23.4E0,43.45E0,'89090',70.0E0,2,0,314)
INSERT INTO TTRIPS VALUES(130,'2016-06-01 00:38:13.000000',3,'2016-05-30 00:38:13.000000','Try to be clean as posible','Cambridge avenue','Sussex','England','London',23.4E0,43.45E0,'89090','2016-05-31 00:38:13.000000','October 1st street','Liverpool','England','East Midlands',23.4E0,43.45E0,'89090',70.0E0,4,0,314)
INSERT INTO TTRIPS VALUES(131,'2016-06-09 00:38:55.000000',2,'2016-06-07 00:38:55.000000','Try to be clean as posible','White Hart Lane','London','England','London',23.4E0,43.45E0,'89090','2016-06-08 00:38:55.000000','Boylen Ground','London','England','London',23.4E0,43.45E0,'89090',70.0E0,2,0,314)
INSERT INTO TTRIPS VALUES(132,'2016-06-04 09:39:53.000000',2,'2016-06-03 00:39:53.000000','Trata de ser lo mas limpio posible','Avenida de La Costa','Gijon','Espa\u00f1a','Asturias',23.4E0,43.45E0,'22006','2016-06-04 00:39:53.000000','Anfitetro Romano','Merida','Espa\u00f1a','Extremadura',23.4E0,43.45E0,'33778',70.0E0,2,0,314)
INSERT INTO TUSERS VALUES(310,'carlosrp@mail.com','usuario1','Carlos','usuario1',0,'Rodriguez Perez')
INSERT INTO TUSERS VALUES(311,'isabelgm@mail.com','usuario2','Isabel','usuario2',0,'Garcia Marques')
INSERT INTO TUSERS VALUES(312,'fernandoai@mail.com','usuario3','Fernando','usuario3',0,'Alvarez Iglesias')
INSERT INTO TUSERS VALUES(313,'fatimacb@mail.com','usuario4','Fatima','usuario4',0,'Castillo Blanco')
INSERT INTO TUSERS VALUES(314,'pablols@mail.com','usuario5','Pablo','usuario5',1,'Lopez Sastre')