-
Notifications
You must be signed in to change notification settings - Fork 0
/
insert.txt
19 lines (17 loc) · 4.08 KB
/
insert.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
DELETE FROM OLD_PHOTO;
DELETE FROM OLD_PUBLICATION;
DELETE FROM OLD_SYS_USER;
INSERT INTO OLD_SYS_USER(USERID, NAME, LASTNAME, EMAIL, PHONE, NICK, PASSWORD)VALUES(10000,'Agustin','Marseillan','[email protected]','4723-8376','marse','123456');
INSERT INTO OLD_SYS_USER(USERID, NAME, LASTNAME, EMAIL, PHONE, NICK, PASSWORD)VALUES(20000,'Máximo','Vidella','[email protected]','4939-8376','maxi','123456');
INSERT INTO OLD_SYS_USER(USERID, NAME, LASTNAME, EMAIL, PHONE, NICK, PASSWORD)VALUES(30000,'Axel','Wassington','[email protected]','4949-4211','axel','654321');
INSERT INTO OLD_SYS_USER(USERID, NAME, LASTNAME, EMAIL, PHONE, NICK, PASSWORD)VALUES(40000,'Kevin','Kenny','[email protected]','3939-4221','kevin','654321');
INSERT INTO OLD_PUBLICATION(publicationid, userid,type,operation_type,address,city,price,environments,covered,uncovered,age,cable,phone,pool,living,paddle,barbecue, description, active)VALUES('10009','10000','1','2','Murature 785','San Isidro','100000.0','6','400','300','25','1','1','1','1','1','1','Linda casa en zona cheta.','1');
INSERT INTO OLD_PUBLICATION(publicationid, userid,type,operation_type,address,city,price,environments,covered,uncovered,age,cable,phone,pool,living,paddle,barbecue, description, active)VALUES('10000', '20000','2','1','Cerrito 800','Buenos Aires','2000.0','3','200.0','0.0','15','1','1','0','0','0','0','Departamento chico pero con buena ubicación.','1');
INSERT INTO OLD_PUBLICATION(publicationid, userid,type,operation_type,address,city,price,environments,covered,uncovered,age,cable,phone,pool,living,paddle,barbecue, description, active)VALUES('10001', '30000','2','1','Cerrito 800','Buenos Aires','100000.0','3','200.0','0.0','15','1','1','0','0','0','0','Departamento chico pero con buena ubicación.','1');
INSERT INTO OLD_PUBLICATION(publicationid, userid,type,operation_type,address,city,price,environments,covered,uncovered,age,cable,phone,pool,living,paddle,barbecue, description, active)VALUES('10002', '30000','1','1','De las artes 300','Pinamar','300000.0','7','500.0','350.0','13','1','1','1','1','1','1','Casa de playa muy grande.','0');
INSERT INTO OLD_PUBLICATION(publicationid, userid,type,operation_type,address,city,price,environments,covered,uncovered,age,cable,phone,pool,living,paddle,barbecue, description, active)VALUES('10003', '30000','1','1','De las artes 300','Pinamar','500000.0','7','500.0','350.0','13','1','1','1','1','1','1','Casa de playa muy grande.','1');
INSERT INTO OLD_PUBLICATION(publicationid, userid,type,operation_type,address,city,price,environments,covered,uncovered,age,cable,phone,pool,living,paddle,barbecue, description, active)VALUES('10004', '30000','1','2','De las artes 300','Pinamar','21000.0','7','500.0','350.0','13','1','1','1','1','1','1','Casa de playa muy grande.','1');--
INSERT INTO OLD_PUBLICATION(publicationid, userid,type,operation_type,address,city,price,environments,covered,uncovered,age,cable,phone,pool,living,paddle,barbecue, description, active)VALUES('10005', '10000','1','1','Murature 785','San Isidro','1000000.0','6','400','300','25','1','1','1','1','1','1','Linda casa en zona cheta.','1');
INSERT INTO OLD_PUBLICATION(publicationid, userid,type,operation_type,address,city,price,environments,covered,uncovered,age,cable,phone,pool,living,paddle,barbecue, description, active)VALUES('10006', '20000','2','2','Alvear 574','Buenos Aires','3600.0','3','250.0','0.0','25','1','0','0','0','0','0','Excelente ubicaci—n en buenos aires.','1');
INSERT INTO OLD_PUBLICATION(publicationid, userid,type,operation_type,address,city,price,environments,covered,uncovered,age,cable,phone,pool,living,paddle,barbecue, description, active)VALUES('10007', '30000','1','1','Marquez 2340','San Isidro','123456.0','5','460.0','100.0','32','1','1','1','1','1','1','Linda casa cerca del hipódromo.','1');
INSERT INTO OLD_PUBLICATION(publicationid, userid,type,operation_type,address,city,price,environments,covered,uncovered,age,cable,phone,pool,living,paddle,barbecue, description, active)VALUES('10008', '10000','1','2','Gorlero 405','Punta del este','15000.0','5','500.0','350.0','13','1','1','1','1','1','1','Excelente casa cerca de la playa.','0');