databaseOTS.sql

/* Drop tables */
DROP TABLE person;
DROP TABLE flight;
DROP TABLE phone_contract;
DROP TABLE messages;
DROP TABLE account;
DROP TABLE bank_transaction;
/* Create tables */

CREATE TABLE person (id INTEGER PRIMARY KEY, name TEXT, residence TEXT, age INTEGER);

CREATE TABLE flight (id INTEGER PRIMARY KEY, person_id INTEGER, name TEXT, start_city TEXT, dest_city TEXT, date DATE, FOREIGN KEY (person_id) REFERENCES person(id));

CREATE TABLE phone_contract (id INTEGER PRIMARY KEY, person_id INTEGER, name TEXT, phone_number INTEGER, status TEXT, FOREIGN KEY (person_id) REFERENCES person(id));

CREATE TABLE messages (id INTEGER PRIMARY KEY, contract_sender_id INTEGER, contract_receiver_id INTEGER, message TEXT, sent DATE, FOREIGN KEY (contract_sender_id) REFERENCES phone_contract(id), FOREIGN KEY (contract_receiver_id) REFERENCES phone_contract(id));

CREATE TABLE bank_transaction (bank_transaction_pk INTEGER PRIMARY KEY, account_number_fk INTEGER,date DATE, description TEXT, amount REAL, FOREIGN KEY (account_number_fk) REFERENCES account (account_number_pk));

CREATE TABLE account (account_number_pk INTEGER PRIMARY KEY, name TEXT, city TEXT);

/*Insert data*/

INSERT INTO bank_transaction values (100, 203993, '2014-10-21 16:41:00', 'Shopping for Shoes', 39.99);
INSERT INTO bank_transaction values (110, 203993, '2014-10-21 17:39:00','ATM 1X9209', 100.00);
INSERT INTO bank_transaction values (122, 203993, '2014-10-22 08:25:00','Entrance Tour Eiffel', 15.00);
INSERT INTO bank_transaction values (133, 203993, '2014-10-22 22:08:00', 'ATM 1293YM ', 150.00);
INSERT INTO bank_transaction values (144, 203993, '2014-10-23 12:22:00', 'MM book store', 17.99);
INSERT INTO bank_transaction values (145, 203993, '2014-10-24 13:00:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (146, 203993, '2014-10-24 13:01:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (147, 203993, '2014-10-24 13:02:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (148, 203993, '2014-10-24 13:03:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (149, 203993, '2014-10-24 13:04:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (150, 203993, '2014-10-24 13:05:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (151, 203993, '2014-10-24 13:06:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (152, 203993, '2014-10-24 13:07:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (153, 203993, '2014-10-24 13:08:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (154, 203993, '2014-10-24 13:09:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (155, 203993, '2014-10-24 14:00:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (156, 203993, '2014-10-24 14:01:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (157, 203993, '2014-10-24 14:02:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (158, 203993, '2014-10-24 15:00:00', 'Artwork',  1000);
INSERT INTO bank_transaction values (245, 203987, '2014-10-24 13:00:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (246, 203987, '2014-10-24 13:01:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (247, 203987, '2014-10-24 13:02:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (248, 203987, '2014-10-24 13:03:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (249, 203987, '2014-10-24 13:04:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (250, 203987, '2014-10-24 13:05:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (251, 203987, '2014-10-24 13:06:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (252, 203987, '2014-10-24 13:07:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (253, 203987, '2014-10-24 13:08:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (254, 203987, '2014-10-24 13:09:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (255, 203987, '2014-10-24 14:00:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (256, 203987, '2014-10-24 14:01:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (257, 203987, '2014-10-24 14:02:00', 'Artwork', 1000);
INSERT INTO bank_transaction values (258, 203987, '2014-10-24 15:00:00', 'Artwork',  1000);
INSERT INTO bank_transaction values (300,6876381,'2014-10-24 07:12:37','Cash withdrawal',968.93);
INSERT INTO bank_transaction values (301,2978006,'2014-10-10 07:29:33','Cash withdrawal',457.88);
INSERT INTO bank_transaction values (302,1783543,'2014-10-13 08:30:28','Books Co.',152.85);
INSERT INTO bank_transaction values (303,5778735,'2014-10-31 07:47:14','Books Co.',159.65);
INSERT INTO bank_transaction values (304,1188263,'2014-10-27 08:26:55','Books Co.',476.79);
INSERT INTO bank_transaction values (305,8963866,'2014-10-29 07:11:21','Books Co.',257.57);
INSERT INTO bank_transaction values (306,475539,'2014-10-24 07:02:58','Cash withdrawal',638.71);
INSERT INTO bank_transaction values (307,952185,'2014-10-22 08:07:23','Books Co.',289.57);
INSERT INTO bank_transaction values (308,7311718,'2014-10-29 07:33:51','Cash withdrawal',1.93);
INSERT INTO bank_transaction values (309,457201,'2014-10-17 07:29:37','Cash withdrawal',249.43);
INSERT INTO bank_transaction values (310,3252981,'2014-10-24 07:32:42','Books Co.',39.07);
INSERT INTO bank_transaction values (311,4587016,'2014-11-01 07:14:10','Grocery Co.',815.84);
INSERT INTO bank_transaction values (312,4386567,'2014-10-18 08:39:46','Books Co.',124.46);
INSERT INTO bank_transaction values (313,567428,'2014-10-22 08:28:02','Grocery Co.',387.18);
INSERT INTO bank_transaction values (314,868072,'2014-10-31 08:30:03','Books Co.',629.92);
INSERT INTO bank_transaction values (315,1951959,'2014-10-23 08:19:27','Grocery Co.',33.87);
INSERT INTO bank_transaction values (316,5988905,'2014-10-31 08:30:59','Cash withdrawal',143.93);
INSERT INTO bank_transaction values (317,8618459,'2014-10-13 07:20:09','Books Co.',726.18);
INSERT INTO bank_transaction values (318,4898687,'2014-10-15 07:31:08','Cash withdrawal',881.06);
INSERT INTO bank_transaction values (319,5828345,'2014-10-31 07:23:11','Books Co.',747.9);
INSERT INTO bank_transaction values (320,2655480,'2014-11-01 07:09:00','Books Co.',237.49);
INSERT INTO bank_transaction values (321,5894821,'2014-10-28 07:52:31','Cash withdrawal',639.33);
INSERT INTO bank_transaction values (322,6598391,'2014-10-19 08:02:17','Books Co.',590.48);
INSERT INTO bank_transaction values (323,7311718,'2014-10-26 07:53:47','Books Co.',643.43);
INSERT INTO bank_transaction values (324,193488,'2014-10-29 07:56:16','Cash withdrawal',616.46);
INSERT INTO bank_transaction values (325,8798924,'2014-10-14 07:26:26','Grocery Co.',441.9);
INSERT INTO bank_transaction values (326,3252981,'2014-10-30 07:08:57','Cash withdrawal',402.4);
INSERT INTO bank_transaction values (327,9040806,null,'Books Co.',23.74);
INSERT INTO bank_transaction values (328,567428,'2014-10-27 08:38:57','Grocery Co.',89.16);
INSERT INTO bank_transaction values (329,7974023,'2014-10-20 07:01:35','Books Co.',27.57);
INSERT INTO bank_transaction values (330,6632848,'2014-10-29 08:32:26','Cash withdrawal',343.77);
INSERT INTO bank_transaction values (331,4776245,'2014-10-11 08:04:40','Cash withdrawal',71.94);
INSERT INTO bank_transaction values (332,680677,'2014-10-12 07:22:48','Grocery Co.',660.79);
INSERT INTO bank_transaction values (333,3340267,'2014-10-27 07:21:37','Books Co.',102.28);
INSERT INTO bank_transaction values (334,9040806,'2014-10-30 08:26:43','Books Co.',939.39);
INSERT INTO bank_transaction values (335,6698709,'2014-10-20 08:42:54','Books Co.',863.38);
INSERT INTO bank_transaction values (336,6632848,'2014-10-18 08:44:50','Books Co.',855.66);
INSERT INTO bank_transaction values (337,1113463,'2014-10-29 08:17:37','Books Co.',244.12);
INSERT INTO bank_transaction values (338,4320616,'2014-10-25 08:03:13','Books Co.',862.82);
INSERT INTO bank_transaction values (339,2978006,'2014-10-27 08:18:30','Grocery Co.',184.13);
INSERT INTO bank_transaction values (340,680677,'2014-10-10 07:36:07','Grocery Co.',252.86);
INSERT INTO bank_transaction values (341,9040806,'2014-10-22 07:35:37','Grocery Co.',260.06);
INSERT INTO bank_transaction values (342,1458741,'2014-10-21 07:54:50','Cash withdrawal',706.21);
INSERT INTO bank_transaction values (343,7260590,'2014-10-10 08:37:41','Cash withdrawal',683.7);
INSERT INTO bank_transaction values (344,6481571,'2014-10-10 08:17:27','Cash withdrawal',496.42);
INSERT INTO bank_transaction values (345,6698709,'2014-10-12 07:06:11','Cash withdrawal',658.57);
INSERT INTO bank_transaction values (346,6632848,'2014-10-17 07:46:55','Books Co.',331.43);
INSERT INTO bank_transaction values (347,7319459,'2014-10-28 08:19:22','Grocery Co.',988.08);
INSERT INTO bank_transaction values (348,4898687,'2014-10-13 08:09:19','Grocery Co.',181.42);
INSERT INTO bank_transaction values (349,8962515,'2014-10-24 08:03:00','Cash withdrawal',494.74);
INSERT INTO bank_transaction values (350,3818447,'2014-10-27 07:50:21','Books Co.',323.8);
INSERT INTO bank_transaction values (351,868072,'2014-10-19 07:33:36','Books Co.',949.17);
INSERT INTO bank_transaction values (352,4901394,'2014-10-15 07:07:09','Cash withdrawal',141.67);
INSERT INTO bank_transaction values (353,5778735,'2014-11-01 07:17:54','Grocery Co.',250.83);
INSERT INTO bank_transaction values (354,4999134,'2014-10-26 07:47:50','Cash withdrawal',5.11);
INSERT INTO bank_transaction values (355,3340267,'2014-10-21 07:40:40','Books Co.',135.69);
INSERT INTO bank_transaction values (356,8967995,'2014-10-18 07:53:48','Books Co.',31.3);
INSERT INTO bank_transaction values (357,343769,'2014-10-29 07:25:10','Cash withdrawal',254.71);
INSERT INTO bank_transaction values (358,8361166,'2014-10-29 07:22:15','Books Co.',825.29);
INSERT INTO bank_transaction values (359,7282653,'2014-10-30 07:58:33','Cash withdrawal',264.58);
INSERT INTO bank_transaction values (360,6395400,'2014-10-27 08:19:27','Grocery Co.',332.42);
INSERT INTO bank_transaction values (361,6419807,'2014-10-10 07:21:11','Grocery Co.',723.76);
INSERT INTO bank_transaction values (362,2688339,'2014-10-30 08:29:14','Cash withdrawal',368.64);
INSERT INTO bank_transaction values (363,6632848,'2014-10-22 08:23:09','Books Co.',523.93);
INSERT INTO bank_transaction values (364,343769,'2014-10-12 08:34:45','Books Co.',3.27);
INSERT INTO bank_transaction values (365,7319459,'2014-10-23 08:16:04','Grocery Co.',771.73);
INSERT INTO bank_transaction values (366,5778735,'2014-10-26 07:54:32','Books Co.',936.79);
INSERT INTO bank_transaction values (367,8587211,'2014-10-24 08:22:59','Grocery Co.',878.53);
INSERT INTO bank_transaction values (368,6012119,'2014-10-31 07:39:26','Grocery Co.',144.12);
INSERT INTO bank_transaction values (369,2688339,null,'Grocery Co.',959.44);
INSERT INTO bank_transaction values (370,6632848,'2014-10-29 07:43:21','Books Co.',505.23);
INSERT INTO bank_transaction values (371,6632848,'2014-10-20 07:48:58','Books Co.',927);
INSERT INTO bank_transaction values (372,9867888,'2014-10-10 07:08:30','Books Co.',51.4);
INSERT INTO bank_transaction values (373,8618459,'2014-10-31 08:25:23','Cash withdrawal',378.74);
INSERT INTO bank_transaction values (374,6698709,'2014-10-15 08:38:59','Grocery Co.',353.19);
INSERT INTO bank_transaction values (375,8016646,'2014-10-17 08:10:10','Books Co.',84.5);
INSERT INTO bank_transaction values (376,7775472,null,'Cash withdrawal',266.85);
INSERT INTO bank_transaction values (377,6419807,'2014-10-29 08:34:07','Books Co.',298.13);
INSERT INTO bank_transaction values (378,4898687,'2014-10-27 07:48:58','Cash withdrawal',224.02);
INSERT INTO bank_transaction values (379,9867888,null,'Grocery Co.',239.25);
INSERT INTO bank_transaction values (380,9933460,'2014-10-26 07:50:15','Books Co.',411.93);
INSERT INTO bank_transaction values (381,2948502,'2014-10-29 07:10:20','Books Co.',611.07);
INSERT INTO bank_transaction values (382,7260590,'2014-10-29 08:07:44','Books Co.',580.77);
INSERT INTO bank_transaction values (383,4802283,'2014-10-29 07:13:22','Grocery Co.',194.95);
INSERT INTO bank_transaction values (384,2949832,'2014-10-27 07:31:00','Books Co.',200.65);
INSERT INTO bank_transaction values (385,680677,null,'Books Co.',462.55);
INSERT INTO bank_transaction values (386,4999134,'2014-10-28 07:17:23','Books Co.',370.38);
INSERT INTO bank_transaction values (387,6012119,'2014-10-28 08:38:30','Cash withdrawal',591.01);
INSERT INTO bank_transaction values (388,2978006,'2014-10-21 08:16:31','Grocery Co.',485.61);
INSERT INTO bank_transaction values (389,526551,null,'Cash withdrawal',149.86);
INSERT INTO bank_transaction values (390,6928632,'2014-10-28 08:32:53','Grocery Co.',462.06);
INSERT INTO bank_transaction values (391,6481571,'2014-10-29 08:25:49','Cash withdrawal',104.47);
INSERT INTO bank_transaction values (392,680677,'2014-10-15 07:26:12','Cash withdrawal',166.25);
INSERT INTO bank_transaction values (393,6632848,'2014-10-28 08:35:28','Books Co.',9.32);
INSERT INTO bank_transaction values (394,4770149,'2014-10-22 07:36:38','Books Co.',854.68);
INSERT INTO bank_transaction values (395,3340267,'2014-10-16 08:42:06','Cash withdrawal',672.19);
INSERT INTO bank_transaction values (396,2655480,'2014-10-12 07:51:38','Books Co.',919.77);
INSERT INTO bank_transaction values (397,343769,'2014-10-12 08:37:34','Cash withdrawal',993.5);
INSERT INTO bank_transaction values (398,4802283,'2014-10-30 07:08:05','Grocery Co.',116.95);
INSERT INTO bank_transaction values (399,7260590,'2014-10-24 07:32:15','Cash withdrawal',892.26);
INSERT INTO bank_transaction values (400,9100006,null,'Books Co.',867.75);
INSERT INTO bank_transaction values (401,7302845,'2014-10-11 08:36:08','Grocery Co.',759.96);
INSERT INTO bank_transaction values (402,9867888,'2014-10-10 07:54:27','Books Co.',939.08);
INSERT INTO bank_transaction values (403,7302845,'2014-10-24 08:23:40','Grocery Co.',6.65);
INSERT INTO bank_transaction values (404,193488,'2014-10-29 07:52:40','Cash withdrawal',591.57);
INSERT INTO bank_transaction values (405,8052678,'2014-10-21 08:40:30','Books Co.',47.58);
INSERT INTO bank_transaction values (406,5707812,'2014-10-25 07:03:02','Cash withdrawal',388.74);
INSERT INTO bank_transaction values (407,7974023,'2014-10-20 08:35:59','Books Co.',562.93);
INSERT INTO bank_transaction values (408,8756837,'2014-10-18 07:47:20','Books Co.',662.55);
INSERT INTO bank_transaction values (409,8962515,'2014-10-24 07:03:54','Grocery Co.',929.69);
INSERT INTO bank_transaction values (410,8016646,'2014-10-25 08:31:52','Cash withdrawal',645.43);
INSERT INTO bank_transaction values (411,1458741,'2014-10-26 08:02:52','Cash withdrawal',826.83);
INSERT INTO bank_transaction values (412,9040806,'2014-10-21 08:11:24','Books Co.',777.75);
INSERT INTO bank_transaction values (413,9933460,'2014-10-12 07:26:31','Cash withdrawal',184.9);
INSERT INTO bank_transaction values (414,6395400,'2014-10-11 07:30:41','Books Co.',915.39);
INSERT INTO bank_transaction values (415,952185,'2014-10-13 07:03:16','Books Co.',367.26);
INSERT INTO bank_transaction values (416,6075710,'2014-11-01 07:37:59','Books Co.',530.77);
INSERT INTO bank_transaction values (417,6481571,'2014-10-29 08:30:07','Books Co.',746.05);
INSERT INTO bank_transaction values (418,8963866,'2014-10-13 08:44:52','Books Co.',174.17);
INSERT INTO bank_transaction values (419,5828345,'2014-10-30 08:27:43','Books Co.',167.75);
INSERT INTO bank_transaction values (420,4386567,'2014-10-26 08:15:30','Grocery Co.',675.84);
INSERT INTO bank_transaction values (421,7775472,'2014-10-25 07:53:44','Books Co.',660.13);
INSERT INTO bank_transaction values (422,8756837,'2014-10-12 07:28:59','Cash withdrawal',752.49);
INSERT INTO bank_transaction values (423,3575645,null,'Cash withdrawal',942.12);
INSERT INTO bank_transaction values (424,3340267,'2014-10-29 07:47:42','Books Co.',337.27);
INSERT INTO bank_transaction values (425,5590832,'2014-10-31 07:45:58','Books Co.',535.51);
INSERT INTO bank_transaction values (426,9107892,'2014-10-17 07:21:01','Books Co.',636.77);
INSERT INTO bank_transaction values (427,8361166,null,'Books Co.',763.15);
INSERT INTO bank_transaction values (428,9040806,'2014-10-27 07:51:40','Cash withdrawal',694.99);
INSERT INTO bank_transaction values (429,5284765,'2014-10-20 07:32:06','Grocery Co.',438.64);
INSERT INTO bank_transaction values (430,2655480,null,'Cash withdrawal',443.17);




INSERT INTO person values (100, 'Philipp', 'Hamburg', 42);
INSERT INTO person values (101, 'Philip', 'Mumbai',75);
INSERT INTO person values (102, 'Carlos', 'Paris', 21);
INSERT INTO person values (103, 'Wei', 'Paris', 36);
INSERT INTO person values (104, 'John', 'Sydney', 37);
INSERT INTO person values (105, 'Kesia', 'Ouagadougou',19 );
INSERT INTO person values (106, 'Sarah', 'Atlanta', 39);
INSERT INTO person VALUES (1,'Lawana','Shanghai',46);
INSERT INTO person VALUES (2,'Petronila','Karachi',57);
INSERT INTO person VALUES (3,'Mikki','Beijing',14);
INSERT INTO person VALUES (4,'Jaye','Delhi',57);
INSERT INTO person VALUES (5,'Gwyneth','Lagos',36);
INSERT INTO person VALUES (6,'Melvin','Istanbul',56);
INSERT INTO person VALUES (7,'Jaunita','Guangzhou',84);
INSERT INTO person VALUES (8,'Ophelia','Mumbai',81);
INSERT INTO person VALUES (9,'Bella','Moscow',30);
INSERT INTO person VALUES (10,'Missy','Dhaka',17);
INSERT INTO person VALUES (11,'Leonarda','Cairo',16);
INSERT INTO person VALUES (12,'Amparo'  ,'São Paulo',45);
INSERT INTO person VALUES (13,'Lu','Lahore',96);
INSERT INTO person VALUES (14,'Trisha','Shenzhen',30);
INSERT INTO person VALUES (15,'Iluminada','Seoul',95);
INSERT INTO person VALUES (16,'Sherril','Bangalore',87);
INSERT INTO person VALUES (17,'Michele','Jakarta',58);
INSERT INTO person VALUES (18,'Gwen','Kinshasa',19);
INSERT INTO person VALUES (19,'Voncile','Tianjin',87);
INSERT INTO person VALUES (20,'Cameron','Tokyo',61);
INSERT INTO person VALUES (21,'Beverly'  ,'Mexico City',27);
INSERT INTO person VALUES (22,'Georgeann','Hyderabad',49);
INSERT INTO person VALUES (23,'Anton','Lima',91);
INSERT INTO person VALUES (24,'Shella','London',37);
INSERT INTO person VALUES (25,'Renna'  ,'New York City',96);
INSERT INTO person VALUES (26,'Dania','Bangkok',44);
INSERT INTO person VALUES (130,'Leslie','Pune',96);
INSERT INTO person VALUES (131,'Kenisha','Dongguan',41);
INSERT INTO person VALUES (132,'Juana','Tehran',3);
INSERT INTO person VALUES (133,'Florance' ,'Bogotá',11);
INSERT INTO person VALUES (134,'Tawanda'  ,'Ho Chi Minh City',59);
INSERT INTO person VALUES (135,'Cheri'  ,'Hong Kong',32);
INSERT INTO person VALUES (136,'Melodie','Baghdad',83);
INSERT INTO person VALUES (137,'Kimber','Wuhan',17);
INSERT INTO person VALUES (138,'Zina','Hanoi',28);
INSERT INTO person VALUES (139,'Lonnie','Luanda',6);
INSERT INTO person VALUES (140,'Bradly'  ,'Rio de Janeiro',57);
INSERT INTO person VALUES (141,'Bethanie','Foshan',73);
INSERT INTO person VALUES (142,'Evie','Santiago',91);
INSERT INTO person VALUES (143,'Hedy','Riyadh',17);
INSERT INTO person VALUES (144,'Bettyann','Ahmedabad',30);
INSERT INTO person VALUES (145,'Hobert','Singapore',55);
INSERT INTO person VALUES (146,'Clorinda','Shantou',77);
INSERT INTO person VALUES (147,'Vilma'  ,'Saint Petersburg',15);
INSERT INTO person VALUES (148,'Naida','Chennai',51);
INSERT INTO person VALUES (149,'Leland','Abidjan',85);
INSERT INTO person VALUES (150,'Laronda','Chengdu',95);
INSERT INTO person VALUES (151,'Shonda','Yangon',17);
INSERT INTO person VALUES (152,'Richie','Alexandria',61);
INSERT INTO person VALUES (153,'Mathilde','Chongqing',38);
INSERT INTO person VALUES (154,'Elton','Kolkata',5);
INSERT INTO person VALUES (155,'Breann','Xian',2);
INSERT INTO person VALUES (156,'Artie','Surat',54);
INSERT INTO person VALUES (157,'Shiela','Johannesburg',26);
INSERT INTO person VALUES (201,'Viki','Nanjing',29);
INSERT INTO person VALUES (202,'Aurora'  ,'Dar es Salaam',42);
INSERT INTO person VALUES (203,'Manual','Ankara',40);
INSERT INTO person VALUES (204,'Alesia','Suzhou',4);
INSERT INTO person VALUES (205,'Zofia','Harbin',12);
INSERT INTO person VALUES (206,'Agustin','Giza',15);
INSERT INTO person VALUES (207,'Vivien','Zhengzhou',52);
INSERT INTO person VALUES (208,'Roslyn'  ,'New Taipei City',94);
INSERT INTO person VALUES (209,'Dalila'  ,'Los Angeles',37);
INSERT INTO person VALUES (210,'Lakita'  ,'Cape Town',20);
INSERT INTO person VALUES (211,'Rossana','Shenyang',84);
INSERT INTO person VALUES (212,'Dessie','Yokohama',52);
INSERT INTO person VALUES (213,'Jeana','Busan',79);
INSERT INTO person VALUES (214,'Cristobal','Hangzhou',25);
INSERT INTO person VALUES (215,'Yasmin','Xiamen',9);
INSERT INTO person VALUES (216,'Hong','Quanzhou',21);
INSERT INTO person VALUES (217,'Chan','Berlin',5);
INSERT INTO person VALUES (218,'Darwin','Jeddah',36);
INSERT INTO person VALUES (219,'Tereasa','Durban',55);
INSERT INTO person VALUES (220,'Dinorah','Kabul',55);
INSERT INTO person VALUES (221,'Jenna','Jaipur',89);
INSERT INTO person VALUES (222,'Mona','Hefei',10);
INSERT INTO person VALUES (223,'Shawana','Pyongyang',2);
INSERT INTO person VALUES (224,'Daysi','Madrid',42);
INSERT INTO person VALUES (225,'Thalia','Ekurhuleni',8);
INSERT INTO person VALUES (226,'Roseanne','Nairobi',83);
INSERT INTO person VALUES (227,'Jaimie'  ,'Addis Ababa',34);
INSERT INTO person VALUES (228,'Alden','Changsha',80);
INSERT INTO person VALUES (229,'Berneice','Wenzhou',65);
INSERT INTO person VALUES (230,'Gay','Baku',45);
INSERT INTO person VALUES (231,'Georgeann','Caracas',24);
INSERT INTO person VALUES (232,'Delois','Rabat',33);
INSERT INTO person VALUES (233,'Leanora','Vienna',24);
INSERT INTO person VALUES (234,'Shella','Khartoum',1);
INSERT INTO person VALUES (235,'Jacquelyn','Budapest',59);
INSERT INTO person VALUES (236,'Grisel','Warsaw',3);
INSERT INTO person VALUES (237,'Charmaine','Minsk',62);
INSERT INTO person VALUES (238,'Laquanda','Manila',62);
INSERT INTO person VALUES (239,'Candyce','Kampala',92);
INSERT INTO person VALUES (240,'Jenny','Accra',21);
INSERT INTO person VALUES (241,'Wei'  ,'Yaoundé',8);
INSERT INTO person VALUES (242,'Julietta','Antananarivo',3);
INSERT INTO person VALUES (243,'Nerissa','Beirut',62);
INSERT INTO person VALUES (244,'Fernande','Algiers',83);
INSERT INTO person VALUES (245,'Jeraldine','Quito',32);
INSERT INTO person VALUES (246,'Gerda','Doha',10);
INSERT INTO person VALUES (1005,'Philipp','Mumbai',88);


INSERT INTO flight values (100, 100, 'Philipp', 'Hamburg', 'Paris', '2014-10-20 08:00:00');
INSERT INTO flight values (101, 100, 'Philipp', 'Paris', 'Berlin', '2014-10-24 08:00:00');
INSERT INTO flight values (102, 105, 'Kesia', 'Ouagadougou', 'Paris', '2014-10-21 08:00:00');
INSERT INTO flight values (103, 105, 'Kesia', 'Paris', 'Moskow', '2014-10-25 08:00:00');
INSERT INTO flight values (104, 106, 'Sarah', 'Atlanta', 'Paris', '2014-10-21 08:00:00');
INSERT INTO flight values (105, 106, 'Sarah', 'Paris', 'Atlanta', '2014-10-24 08:00:00');
INSERT INTO flight VALUES (1,132,'Juana','Hangzhou','Warsaw','2014-07-05 00:00:00');
INSERT INTO flight VALUES (2,139,'Lonnie','Ahmedabad','Beirut','2014-07-08 00:00:00');
INSERT INTO flight VALUES (3,133,'Florance','Johannesburg','Minsk','2014-02-03 00:00:00');
INSERT INTO flight VALUES (4,3,'Mikki','Antananarivo','Minsk','2014-05-30 00:00:00');
INSERT INTO flight VALUES(5,147,'Vilma'  ,'Los Angeles','Saint Petersburg','2014-09-15 00:00:00');
INSERT INTO flight VALUES (6,11,'Leonarda','Hefei','Mumbai','2014-06-02 00:00:00');
INSERT INTO flight VALUES (7,10,'Missy','Xiamen','Changsha','2014-03-29 00:00:00');
INSERT INTO flight VALUES (8,137,'Kimber','Moscow','Yaoundé','2014-08-12 00:00:00');
INSERT INTO flight VALUES(9,143,'Hedy'  ,'Addis Ababa','Riyadh','2014-10-22 00:00:00');
INSERT INTO flight VALUES (10,18,'Gwen','Cairo','Bangalore','2014-10-21 00:00:00');
INSERT INTO flight VALUES (11,21,'Beverly','Riyadh','Lima','2014-06-09 00:00:00');
INSERT INTO flight VALUES (12,138,'Zina','Shenzhen','Antananarivo','2014-01-27 00:00:00');
INSERT INTO flight VALUES(13,9,'Bella'  ,'Yaoundé','Busan','2014-03-19 00:00:00');
INSERT INTO flight VALUES (150,14,'Trisha','Harbin','Algiers','2014-06-10 00:00:00');
INSERT INTO flight VALUES (151,144,'Bettyann','Lagos','Ahmedabad','2014-10-16 00:00:00');
INSERT INTO flight VALUES (152,135,'Cheri','Hanoi','Kampala','2014-05-19 00:00:00');
INSERT INTO flight VALUES (153,5,'Gwyneth','Kolkata','Beirut','2014-10-12 00:00:00');
INSERT INTO flight VALUES(154,24,'Shella'  ,'Cape Town','New Taipei City','2014-09-21 00:00:00');
INSERT INTO flight VALUES (155,131,'Kenisha','Vienna','Budapest','2014-10-09 00:00:00');
INSERT INTO flight VALUES (156,26,'Dania','Accra','Vienna','2014-09-22 00:00:00');
INSERT INTO flight VALUES (157,12,'Amparo','Doha','Baghdad','2014-10-18 00:00:00');
INSERT INTO flight VALUES (158,1,'Lawana','Tehran','Tokyo','2014-10-19 00:00:00');
INSERT INTO flight VALUES (159,22,'Georgeann','Yangon','Santiago','2014-10-20 00:00:00');
INSERT INTO flight VALUES (203,148,'Naida','Chongqing','Chennai','2014-09-02 00:00:00');
INSERT INTO flight VALUES (204,145,'Hobert','Jeddah','Singapore','2014-09-13 00:00:00');
INSERT INTO flight VALUES (205,6,'Melvin','Berlin','Wenzhou','2014-09-30 00:00:00');
INSERT INTO flight VALUES (206,2,'Petronila','Warsaw','Alexandria','2014-09-01 00:00:00');
INSERT INTO flight VALUES (207,4,'Jaye','Suzhou','Manila','2014-10-13 00:00:00');
INSERT INTO flight VALUES(208,140,'Bradly'  ,'Hong Kong','Algiers','2014-09-27 00:00:00');
INSERT INTO flight VALUES (209,17,'Michele','Giza','Abidjan','2014-09-19 00:00:00');
INSERT INTO flight VALUES(210,134,'Tawanda'  ,'Mexico City','Manila','2014-10-03 00:00:00');
INSERT INTO flight VALUES (492,20,'Cameron','Wuhan','Jaipur','2014-09-03 00:00:00');
INSERT INTO flight VALUES (493,141,'Bethanie','Quito','Paris','2014-10-27 00:00:00');
INSERT INTO flight VALUES (494,146,'Clorinda','London','Shantou','2014-10-09 00:00:00');
INSERT INTO flight VALUES (495,8,'Ophelia','Ekurhuleni','Shantou','2014-10-03 00:00:00');
INSERT INTO flight VALUES (496,136,'Melodie','Nanjing','Accra','2014-10-18 00:00:00');
INSERT INTO flight VALUES (497,7,'Jaunita','Luanda','Foshan','2014-09-09 00:00:00');
INSERT INTO flight VALUES (498,149,'Leland','Ankara','Abidjan','2014-10-21 00:00:00');
INSERT INTO flight VALUES(499,16,'Sherril'  ,'Saint Petersburg','Shenyang','2014-10-01 00:00:00');
INSERT INTO flight VALUES (500,19,'Voncile','Dhaka','Tianjin','2014-09-06 00:00:00');
INSERT INTO flight VALUES (501,23,'Anton','Kinshasa','Kampala','2014-10-18 00:00:00');
INSERT INTO flight VALUES (502,142,'Evie','Rabat','Doha','2014-09-02 00:00:00');
INSERT INTO flight VALUES (503,15,'Iluminada','Beijing','Guangzhou','2014-09-12 00:00:00');
INSERT INTO flight VALUES (504,141,'Bethanie','Paris','Frankfurt','2014-10-31 00:00:00');
INSERT INTO flight VALUES (343,150,'Laronda','Paris','Chengdu','2014-09-02 00:00:00');
INSERT INTO flight VALUES(344,13,'Lu'  ,'Bogotá','Nairobi','2014-10-04 00:00:00');
INSERT INTO flight VALUES (345,25,'Renna','Quanzhou','Rabat','2014-09-08 00:00:00');
INSERT INTO flight VALUES (346,130,'Leslie','Caracas','Khartoum','2014-09-30 00:00:00');


INSERT INTO phone_contract values (100,100, 'Philipp', '01034902','active');
INSERT INTO phone_contract values (101,101, 'Philipp', '01203939','active');
INSERT INTO phone_contract values (102,102, 'Carlos', '01723028','active');
INSERT INTO phone_contract values (103,103, 'Wei', '07020202','active');
INSERT INTO phone_contract values (104,104, 'John', '03020384','active');
INSERT INTO phone_contract values (105,105, 'Kesia', '02304853','active');
INSERT INTO phone_contract values (106,106, 'Sarah', '09302002','active');
INSERT INTO phone_contract VALUES (1,234,'Shella'  ,325683,'active');
INSERT INTO phone_contract VALUES (2,155,'Breann'  ,809480,'active');
INSERT INTO phone_contract VALUES (3,223,'Shawana'  ,554524,'active');
INSERT INTO phone_contract VALUES (4,132,'Juana'  ,180323,'active');
INSERT INTO phone_contract VALUES (5,236,'Grisel'  ,828839,'active');
INSERT INTO phone_contract VALUES (6,242,'Julietta'  ,615588,'active');
INSERT INTO phone_contract VALUES (7,204,'Alesia'  ,991723,'active');
INSERT INTO phone_contract VALUES (8,154,'Elton'  ,214497,'active');
INSERT INTO phone_contract VALUES (9,217,'Chan'  ,995104,'inactive');
INSERT INTO phone_contract VALUES (10,139,'Lonnie'  ,556617,'inactive');
INSERT INTO phone_contract VALUES (11,225,'Thalia'  ,468055,'active');
INSERT INTO phone_contract VALUES (12,241,'Wei'  ,516402,'active');
INSERT INTO phone_contract VALUES (13,215,'Yasmin'  ,590157,'inactive');
INSERT INTO phone_contract VALUES (14,222,'Mona'  ,349009,'inactive');
INSERT INTO phone_contract VALUES (15,246,'Gerda'  ,995801,'inactive');
INSERT INTO phone_contract VALUES (16,133,'Florance'  ,869651,'inactive');
INSERT INTO phone_contract VALUES (17,205,'Zofia'  ,991255,'inactive');
INSERT INTO phone_contract VALUES (18,3,'Mikki'  ,784015,'inactive');
INSERT INTO phone_contract VALUES (19,147,'Vilma'  ,809898,'inactive');
INSERT INTO phone_contract VALUES (20,206,'Agustin'  ,5687,'inactive');
INSERT INTO phone_contract VALUES (21,11,'Leonarda'  ,419752,'active');
INSERT INTO phone_contract VALUES (22,10,'Missy'  ,495047,'active');
INSERT INTO phone_contract VALUES (23,137,'Kimber'  ,670977,'active');
INSERT INTO phone_contract VALUES (24,143,'Hedy'  ,158882,'active');
INSERT INTO phone_contract VALUES (25,151,'Shonda'  ,798682,'inactive');
INSERT INTO phone_contract VALUES (26,18,'Gwen'  ,676466,'active');
INSERT INTO phone_contract VALUES (130,210,'Lakita'  ,183499,'inactive');
INSERT INTO phone_contract VALUES (131,216,'Hong'  ,759780,'inactive');
INSERT INTO phone_contract VALUES (132,240,'Jenny'  ,710178,'inactive');
INSERT INTO phone_contract VALUES (133,231,'Georgeann'  ,733249,'active');
INSERT INTO phone_contract VALUES (134,233,'Leanora'  ,401344,'active');
INSERT INTO phone_contract VALUES (135,214,'Cristobal'  ,808696,'active');
INSERT INTO phone_contract VALUES (136,157,'Shiela'  ,561657,'active');
INSERT INTO phone_contract VALUES (137,21,'Beverly'  ,328747,'inactive');
INSERT INTO phone_contract VALUES (138,138,'Zina'  ,672721,'active');
INSERT INTO phone_contract VALUES (139,201,'Viki'  ,341089,'active');
INSERT INTO phone_contract VALUES (140,9,'Bella'  ,269971,'active');
INSERT INTO phone_contract VALUES (141,14,'Trisha'  ,464071,'inactive');
INSERT INTO phone_contract VALUES (142,144,'Bettyann'  ,879856,'active');
INSERT INTO phone_contract VALUES (143,135,'Cheri'  ,49673,'inactive');
INSERT INTO phone_contract VALUES (144,245,'Jeraldine'  ,580347,'active');
INSERT INTO phone_contract VALUES (145,232,'Delois'  ,798784,'active');
INSERT INTO phone_contract VALUES (146,227,'Jaimie'  ,859403,'inactive');
INSERT INTO phone_contract VALUES (147,5,'Gwyneth'  ,17370,'active');
INSERT INTO phone_contract VALUES (148,218,'Darwin'  ,368965,'active');
INSERT INTO phone_contract VALUES (149,24,'Shella'  ,655632,'active');
INSERT INTO phone_contract VALUES (150,209,'Dalila'  ,454159,'active');
INSERT INTO phone_contract VALUES (151,153,'Mathilde'  ,582645,'inactive');
INSERT INTO phone_contract VALUES (152,203,'Manual'  ,546797,'active');
INSERT INTO phone_contract VALUES (153,131,'Kenisha'  ,785503,'active');
INSERT INTO phone_contract VALUES (154,202,'Aurora'  ,309880,'active');
INSERT INTO phone_contract VALUES (155,224,'Daysi'  ,610010,'inactive');
INSERT INTO phone_contract VALUES (156,26,'Dania'  ,503196,'active');
INSERT INTO phone_contract VALUES (157,12,'Amparo'  ,409629,'active');
INSERT INTO phone_contract VALUES (201,230,'Gay'  ,874272,'active');
INSERT INTO phone_contract VALUES (202,1,'Lawana'  ,584829,'inactive');
INSERT INTO phone_contract VALUES (203,22,'Georgeann'  ,840955,'active');
INSERT INTO phone_contract VALUES (204,148,'Naida'  ,122581,'inactive');
INSERT INTO phone_contract VALUES (205,207,'Vivien'  ,806729,'active');
INSERT INTO phone_contract VALUES (206,212,'Dessie'  ,420183,'active');
INSERT INTO phone_contract VALUES (207,156,'Artie'  ,418508,'inactive');
INSERT INTO phone_contract VALUES (208,145,'Hobert'  ,557178,'inactive');
INSERT INTO phone_contract VALUES (209,219,'Tereasa'  ,148640,'active');
INSERT INTO phone_contract VALUES (210,220,'Dinorah'  ,543409,'inactive');
INSERT INTO phone_contract VALUES (211,6,'Melvin'  ,659081,'active');
INSERT INTO phone_contract VALUES (212,2,'Petronila'  ,399792,'inactive');
INSERT INTO phone_contract VALUES (213,4,'Jaye'  ,79160,'active');
INSERT INTO phone_contract VALUES (214,140,'Bradly'  ,126271,'active');
INSERT INTO phone_contract VALUES (215,17,'Michele'  ,358159,'inactive');
INSERT INTO phone_contract VALUES (216,134,'Tawanda'  ,327830,'active');
INSERT INTO phone_contract VALUES (217,235,'Jacquelyn'  ,431851,'inactive');
INSERT INTO phone_contract VALUES (218,20,'Cameron'  ,470660,'active');
INSERT INTO phone_contract VALUES (219,152,'Richie'  ,801443,'inactive');
INSERT INTO phone_contract VALUES (220,237,'Charmaine'  ,803977,'inactive');
INSERT INTO phone_contract VALUES (221,238,'Laquanda'  ,660668,'inactive');
INSERT INTO phone_contract VALUES (222,243,'Nerissa'  ,654965,'inactive');
INSERT INTO phone_contract VALUES (223,229,'Berneice'  ,830894,'active');
INSERT INTO phone_contract VALUES (224,141,'Bethanie'  ,593100,'active');
INSERT INTO phone_contract VALUES (225,146,'Clorinda'  ,157497,'inactive');
INSERT INTO phone_contract VALUES (226,213,'Jeana'  ,760871,'inactive');
INSERT INTO phone_contract VALUES (227,228,'Alden'  ,974478,'inactive');
INSERT INTO phone_contract VALUES (228,8,'Ophelia'  ,675087,'inactive');
INSERT INTO phone_contract VALUES (229,136,'Melodie'  ,789232,'active');
INSERT INTO phone_contract VALUES (230,226,'Roseanne'  ,84447,'active');
INSERT INTO phone_contract VALUES (231,244,'Fernande'  ,819511,'inactive');
INSERT INTO phone_contract VALUES (232,7,'Jaunita'  ,991885,'active');
INSERT INTO phone_contract VALUES (233,211,'Rossana'  ,180127,'active');
INSERT INTO phone_contract VALUES (234,149,'Leland'  ,740347,'inactive');
INSERT INTO phone_contract VALUES (235,16,'Sherril'  ,470873,'inactive');
INSERT INTO phone_contract VALUES (236,19,'Voncile'  ,320008,'active');
INSERT INTO phone_contract VALUES (237,221,'Jenna'  ,875618,'active');
INSERT INTO phone_contract VALUES (238,23,'Anton'  ,947990,'active');
INSERT INTO phone_contract VALUES (239,142,'Evie'  ,878910,'inactive');
INSERT INTO phone_contract VALUES (240,239,'Candyce'  ,126635,'active');
INSERT INTO phone_contract VALUES (241,208,'Roslyn'  ,188687,'active');
INSERT INTO phone_contract VALUES (242,15,'Iluminada'  ,220916,'inactive');
INSERT INTO phone_contract VALUES (243,150,'Laronda'  ,635506,'inactive');
INSERT INTO phone_contract VALUES (244,13,'Lu'  ,884101,'inactive');
INSERT INTO phone_contract VALUES (245,25,'Renna'  ,897713,'inactive');
INSERT INTO phone_contract VALUES (246,130,'Leslie'  ,46774,'active');


INSERT INTO messages values ( 100, 100,106,'Hi, I just arrived in Paris', '2014-10-20 09:00:00');
INSERT INTO messages values (101, 106, 100, 'great!', '2014-10-21 10:10:00');
INSERT INTO messages values (102, 102,105,'Oh great! How was your flight? We could meet at 12 for lunch if you like', '2014-10-21 09:10:00');
INSERT INTO messages values (103, 105, 102,'Hi, I just arrived in Paris. I just go to my hotel. Then I can come somewhere.',  '2014-10-21 09:00:00');
INSERT INTO messages values (104, 100,106,'OK. cu', '2014-10-21 09:40:00');
INSERT INTO messages values (105, 102,105,'Fine, 12 at c.p.?', '2014-10-21 09:17:00');
INSERT INTO messages values (106, 106,100,'2 u too! Have a good time', '2014-10-24 09:12:00');
INSERT INTO messages values (107, 106,100,'Me now too. Let''s meet tognight 8pm at the tour eiffel and finalize 104, preparation', '2014-10-21 09:01:00');
INSERT INTO messages values (108, 105,102,'Yeah, sounds great. Where should I come? My hotel is close to centre pompidou.', '2014-10-21 09:15:00');
INSERT INTO messages values (109, 105,102,' Cool, I will be there', '2014-10-21 09:30:00');
INSERT INTO messages values (110, 100,106,'This was a coup! I have to say, would loved to keep ML to myselfe *g*. Good journey!', '2014-10-24 09:10:00');
INSERT INTO messages values (111, 100,106,'btw: good news, I found a buyer. 100.000 k :-) ', '2014-10-21 09:41:00');
INSERT INTO messages VALUES (1,31,28,'Thereto prickd on by a most emulate pride','2014-10-26 08:24:33');
INSERT INTO messages VALUES (2,30,28,'So frownd he once, when, in an angry parle','2014-10-24 07:19:21');
INSERT INTO messages VALUES (3,30,28,'When he the ambitious Norway combated','2014-10-24 07:12:37');
INSERT INTO messages VALUES (4,38,28,'Bernardo?','2014-10-10 07:29:33');
INSERT INTO messages VALUES (5,38,28,'Give you good night.','2014-10-13 08:30:28');
INSERT INTO messages VALUES (6,32,28,'Ill cross it, though it blast me. Stay, illusion!','2014-10-31 07:47:14');
INSERT INTO messages VALUES (7,31,28,'And carriage of the article designd','2014-10-27 08:26:55');
INSERT INTO messages VALUES (8,31,28,'And terms compulsatory, those foresaid lands','2014-10-29 07:11:21');
INSERT INTO messages VALUES (9,30,28,'As thou art to thyself:','2014-10-24 07:02:58');
INSERT INTO messages VALUES (10,20,28,'Tis gone, and will not answer.','2014-10-22 08:07:23');
INSERT INTO messages VALUES (11,31,28,'Of this post-haste and romage in the land.','2014-10-29 07:33:51');
INSERT INTO messages VALUES (12,29,28,'Tush, tush, twill not appear.','2014-10-17 07:29:37');
INSERT INTO messages VALUES (13,30,28,'Tis strange.','2014-10-24 07:32:42');
INSERT INTO messages VALUES (14,32,28,'Which, happily, foreknowing may avoid, O, speak!','2014-11-01 07:14:10');
INSERT INTO messages VALUES (15,11,28,'When yond same star thats westward from the pole','2014-10-18 08:39:46');
INSERT INTO messages VALUES (16,30,28,'Before my God, I might not this believe','2014-10-22 08:28:02');
INSERT INTO messages VALUES (17,32,28,'That may to thee do ease and grace to me','2014-10-31 08:30:03');
INSERT INTO messages VALUES (18,20,28,'Is it not like the king?','2014-10-23 08:19:27');
INSERT INTO messages VALUES (19,32,28,'Speak to me:','2014-10-31 08:30:59');
INSERT INTO messages VALUES (20,18,28,'Who hath relieved you?','2014-10-13 07:20:09');
INSERT INTO messages VALUES (21,11,28,'I have seen nothing.','2014-10-15 07:31:08');
INSERT INTO messages VALUES (22,32,28,'Unto our climatures and countrymen.--','2014-10-31 07:23:11');
INSERT INTO messages VALUES (55,32,28,'If thou art privy to thy countrys fate','2014-11-01 07:09:00');
INSERT INTO messages VALUES (56,31,28,'Hath in the skirts of Norway here and there','2014-10-28 07:52:31');
INSERT INTO messages VALUES (57,11,28,'The bell then beating one,--','2014-10-19 08:02:17');
INSERT INTO messages VALUES (58,21,28,'Who ist that can inform me?','2014-10-26 07:53:47');
INSERT INTO messages VALUES (59,31,28,'A mote it is to trouble the minds eye.','2014-10-29 07:56:16');
INSERT INTO messages VALUES (60,11,28,'Say','2014-10-14 07:26:26');
INSERT INTO messages VALUES (61,32,28,'Was sick almost to doomsday with eclipse:','2014-10-30 07:08:57');
INSERT INTO messages VALUES (62,19,28,'He may approve our eyes and speak to it.','2014-10-17 07:27:42');
INSERT INTO messages VALUES (63,31,28,'His fell to Hamlet. Now, sir, young Fortinbras','2014-10-27 08:38:57');
INSERT INTO messages VALUES (64,20,28,'Peace, break thee off  look, where it comes again!','2014-10-20 07:01:35');
INSERT INTO messages VALUES (65,32,28,'As stars with trains of fire and dews of blood','2014-10-29 08:32:26');
INSERT INTO messages VALUES (66,38,28,'And I am sick at heart.','2014-10-11 08:04:40');
INSERT INTO messages VALUES (67,10,28,'Well, good night.','2014-10-12 07:22:48');
INSERT INTO messages VALUES (68,31,28,'For so this side of our known world esteemd him--','2014-10-27 07:21:37');
INSERT INTO messages VALUES (69,32,28,'As harbingers preceding still the fates','2014-10-30 08:26:43');
INSERT INTO messages VALUES (70,30,28,'Most like: it harrows me with fear and wonder.','2014-10-20 08:42:54');
INSERT INTO messages VALUES (71,11,28,'Had made his course to illume that part of heaven','2014-10-18 08:44:50');
INSERT INTO messages VALUES (72,31,28,'A little ere the mightiest Julius fell','2014-10-29 08:17:37');
INSERT INTO messages VALUES (73,21,28,'And why such daily cast of brazen cannon','2014-10-25 08:03:13');
INSERT INTO messages VALUES (134,31,28,'To the inheritance of Fortinbras','2014-10-27 08:18:30');
INSERT INTO messages VALUES (135,10,28,'He.','2014-10-10 07:36:07');
INSERT INTO messages VALUES (136,20,28,'It is offended.','2014-10-22 07:35:37');
INSERT INTO messages VALUES (137,30,28,'What art thou that usurpst this time of night','2014-10-21 07:54:50');
INSERT INTO messages VALUES (1001,10,28,'Whos there?','2014-10-10 08:37:41');
INSERT INTO messages VALUES (138,10,28,'Tis now struck twelve get thee to bed, Francisco.','2014-10-10 08:17:27');
INSERT INTO messages VALUES (139,38,28,'Not a mouse stirring.','2014-10-12 07:06:11');
INSERT INTO messages VALUES (140,11,28,'Sit down awhile','2014-10-17 07:46:55');
INSERT INTO messages VALUES (141,31,28,'Sharkd up a list of lawless resolutes','2014-10-28 08:19:22');
INSERT INTO messages VALUES (142,38,28,'Bernardo has my place.','2014-10-13 08:09:19');
INSERT INTO messages VALUES (143,20,28,'Thus twice before, and jump at this dead hour','2014-10-24 08:03:00');
INSERT INTO messages VALUES (144,31,28,'Which he stood seized of, to the conqueror:','2014-10-27 07:50:21');
INSERT INTO messages VALUES (145,11,28,'Where now it burns, Marcellus and myself','2014-10-19 07:33:36');
INSERT INTO messages VALUES (146,11,28,'Welcome, Horatio: welcome, good Marcellus.','2014-10-15 07:07:09');
INSERT INTO messages VALUES (147,32,28,'Or if thou hast uphoarded in thy life','2014-11-01 07:17:54');
INSERT INTO messages VALUES (148,21,28,'Does not divide the Sunday from the week','2014-10-26 07:47:50');
INSERT INTO messages VALUES (149,20,28,'Question it, Horatio.','2014-10-21 07:40:40');
INSERT INTO messages VALUES (150,29,28,'And let us hear Bernardo speak of this.','2014-10-18 07:53:48');
INSERT INTO messages VALUES (151,31,28,'The source of this our watch and the chief head','2014-10-29 07:25:10');
INSERT INTO messages VALUES (152,31,28,'Is the main motive of our preparations','2014-10-29 07:22:15');
INSERT INTO messages VALUES (153,32,28,'And even the like precurse of fierce events','2014-10-30 07:58:33');
INSERT INTO messages VALUES (154,31,28,'Had he been vanquisher  as, by the same covenant','2014-10-27 08:19:27');
INSERT INTO messages VALUES (155,10,28,'Long live the king!','2014-10-10 07:21:11');
INSERT INTO messages VALUES (156,32,28,'Have heaven and earth together demonstrated','2014-10-30 08:29:14');
INSERT INTO messages VALUES (157,12,28,'Is not this something more than fantasy?','2014-10-22 08:23:09');
INSERT INTO messages VALUES (158,18,28,'And liegemen to the Dane.','2014-10-12 08:34:45');
INSERT INTO messages VALUES (159,30,28,'Of mine own eyes.','2014-10-23 08:16:04');
INSERT INTO messages VALUES (160,31,28,'That can I','2014-10-26 07:54:32');
INSERT INTO messages VALUES (161,30,28,'In what particular thought to work I know not','2014-10-24 08:22:59');
INSERT INTO messages VALUES (162,32,28,'But soft, behold! lo, where it comes again!','2014-10-31 07:39:26');
INSERT INTO messages VALUES (163,19,28,'And will not let belief take hold of him','2014-10-15 08:34:46');
INSERT INTO messages VALUES (164,13,28,'Well may it sort that this portentous figure','2014-10-29 07:43:21');
INSERT INTO messages VALUES (165,20,28,'Thou art a scholar  speak to it, Horatio','2014-10-20 07:48:58');
INSERT INTO messages VALUES (166,38,28,'Nay, answer me: stand, and unfold yourself.','2014-10-10 07:08:30');
INSERT INTO messages VALUES (167,32,28,'If there be any good thing to be done','2014-10-31 08:25:23');
INSERT INTO messages VALUES (168,19,28,'Touching this dreaded sight, twice seen of us:','2014-10-15 08:38:59');
INSERT INTO messages VALUES (198,11,28,'And let us once again assail your ears','2014-10-17 08:10:10');
INSERT INTO messages VALUES (199,19,28,'With us to watch the minutes of this night','2014-10-17 07:02:24');
INSERT INTO messages VALUES (200,32,28,'Disasters in the sun','2014-10-29 08:34:07');
INSERT INTO messages VALUES (201,31,28,'Well ratified by law and heraldry','2014-10-27 07:48:58');
INSERT INTO messages VALUES (202,31,28,'Was gaged by our king','2014-10-27 07:52:44');
INSERT INTO messages VALUES (203,21,28,'Doth make the night joint-labourer with the day:','2014-10-26 07:50:15');
INSERT INTO messages VALUES (204,31,28,'But to recover of us, by strong hand','2014-10-29 07:10:20');
INSERT INTO messages VALUES (205,31,28,'In the most high and palmy state of Rome','2014-10-29 08:07:44');
INSERT INTO messages VALUES (206,31,28,'So by his father lost: and this, I take it','2014-10-29 07:13:22');
INSERT INTO messages VALUES (207,31,28,'Did slay this Fortinbras  who by a seald compact','2014-10-27 07:31:00');
INSERT INTO messages VALUES (208,20,28,'Good now, sit down, and tell me, he that knows','2014-10-25 07:06:48');
INSERT INTO messages VALUES (209,31,28,'Of unimproved mettle hot and full','2014-10-28 07:17:23');
INSERT INTO messages VALUES (210,31,28,'As it doth well appear unto our state--','2014-10-28 08:38:30');
INSERT INTO messages VALUES (211,30,28,'In which the majesty of buried Denmark','2014-10-21 08:16:31');
INSERT INTO messages VALUES (212,12,28,'How now, Horatio! you tremble and look pale:','2014-10-22 08:09:55');
INSERT INTO messages VALUES (213,31,28,'For food and diet, to some enterprise','2014-10-28 08:32:53');
INSERT INTO messages VALUES (214,31,28,'The graves stood tenantless and the sheeted dead','2014-10-29 08:25:49');
INSERT INTO messages VALUES (215,19,28,'What, has this thing appeard again to-night?','2014-10-15 07:26:12');
INSERT INTO messages VALUES (216,31,28,'That hath a stomach int','2014-10-28 08:35:28');
INSERT INTO messages VALUES (217,12,28,'See, it stalks away!','2014-10-22 07:36:38');
INSERT INTO messages VALUES (218,19,28,'Therefore I have entreated him along','2014-10-16 08:42:06');
INSERT INTO messages VALUES (219,38,28,'I think I hear them. Stand, ho! Whos there?','2014-10-12 07:51:38');
INSERT INTO messages VALUES (220,38,28,'Give you good night.','2014-10-12 08:37:34');
INSERT INTO messages VALUES (221,32,28,'Upon whose influence Neptunes empire stands','2014-10-30 07:08:05');
INSERT INTO messages VALUES (222,30,28,'He smote the sledded Polacks on the ice.','2014-10-24 07:32:15');
INSERT INTO messages VALUES (223,12,28,'What think you ont?','2014-10-22 08:27:14');
INSERT INTO messages VALUES (224,10,28,'Have you had quiet guard?','2014-10-11 08:36:08');
INSERT INTO messages VALUES (225,38,28,'You come most carefully upon your hour.','2014-10-10 07:54:27');
INSERT INTO messages VALUES (226,30,28,'But in the gross and scope of my opinion','2014-10-24 08:23:40');
INSERT INTO messages VALUES (227,13,28,'That was and is the question of these wars.','2014-10-29 07:52:40');
INSERT INTO messages VALUES (228,30,28,'Did sometimes march? by heaven I charge thee, speak!','2014-10-21 08:40:30');
INSERT INTO messages VALUES (229,30,28,'This bodes some strange eruption to our state.','2014-10-25 07:03:02');
INSERT INTO messages VALUES (230,12,28,'Looks it not like the king? mark it, Horatio.','2014-10-20 08:35:59');
INSERT INTO messages VALUES (231,29,28,'Well, sit we down','2014-10-18 07:47:20');
INSERT INTO messages VALUES (232,30,28,'Such was the very armour he had on','2014-10-24 07:03:54');
INSERT INTO messages VALUES (233,21,28,'And foreign mart for implements of war','2014-10-25 08:31:52');
INSERT INTO messages VALUES (234,31,28,'At least, the whisper goes so. Our last king','2014-10-26 08:02:52');
INSERT INTO messages VALUES (235,30,28,'Together with that fair and warlike form','2014-10-21 08:11:24');
INSERT INTO messages VALUES (236,10,28,'If you do meet Horatio and Marcellus','2014-10-12 07:26:31');
INSERT INTO messages VALUES (237,38,28,'For this relief much thanks: tis bitter cold','2014-10-11 07:30:41');
INSERT INTO messages VALUES (238,18,28,'O, farewell, honest soldier:','2014-10-13 07:03:16');
INSERT INTO messages VALUES (239,32,28,'Extorted treasure in the womb of earth','2014-11-01 07:37:59');
INSERT INTO messages VALUES (240,31,28,'Did squeak and gibber in the Roman streets:','2014-10-29 08:30:07');
INSERT INTO messages VALUES (241,19,28,'Holla! Bernardo!','2014-10-13 08:44:52');
INSERT INTO messages VALUES (288,32,28,'And prologue to the omen coming on','2014-10-30 08:27:43');
INSERT INTO messages VALUES (289,31,28,'Whose image even but now appeard to us','2014-10-26 08:15:30');
INSERT INTO messages VALUES (290,20,28,'So nightly toils the subject of the land','2014-10-25 07:53:44');
INSERT INTO messages VALUES (291,10,28,'The rivals of my watch, bid them make haste.','2014-10-12 07:28:59');
INSERT INTO messages VALUES (292,29,28,'What, is Horatio there?','2014-10-14 07:44:29');
INSERT INTO messages VALUES (293,13,28,'Comes armed through our watch','2014-10-29 07:47:42');
INSERT INTO messages VALUES (294,32,28,'','2014-10-31 07:45:58');
INSERT INTO messages VALUES (295,19,28,'That if again this apparition come','2014-10-17 07:21:01');
INSERT INTO messages VALUES (296,28,28,'Friends to this ground.','2014-10-12 08:07:44');
INSERT INTO messages VALUES (297,31,28,'Against the which, a moiety competent','2014-10-27 07:51:40');
INSERT INTO messages VALUES (298,12,28,'In the same figure, like the king thats dead.','2014-10-20 07:32:06');
INSERT INTO messages VALUES (299,30,28,'Stay! speak, speak! I charge thee, speak!','2014-10-22 07:48:21');
INSERT INTO messages VALUES (300,20,28,'Why this same strict and most observant watch','2014-10-25 07:15:57');
INSERT INTO messages VALUES (301,21,28,'Why such impress of shipwrights, whose sore task','2014-10-25 08:43:47');
INSERT INTO messages VALUES (302,12,28,'It would be spoke to.','2014-10-21 07:31:38');
INSERT INTO messages VALUES (303,19,28,'Horatio says tis but our fantasy','2014-10-15 07:35:30');
INSERT INTO messages VALUES (304,32,28,'Speak to me:','2014-10-31 08:01:24');
INSERT INTO messages VALUES (305,32,28,'If thou hast any sound, or use of voice','2014-10-31 07:58:11');
INSERT INTO messages VALUES (306,32,28,'For which, they say, you spirits oft walk in death','2014-11-01 07:56:26');
INSERT INTO messages VALUES (307,31,28,'Did forfeit, with his life, all those his lands','2014-10-27 07:49:27');
INSERT INTO messages VALUES (308,11,28,'What we have two nights seen.','2014-10-18 07:37:23');
INSERT INTO messages VALUES (309,11,28,'Last night of all','2014-10-18 07:57:19');
INSERT INTO messages VALUES (310,29,28,'A piece of him.','2014-10-14 07:54:19');
INSERT INTO messages VALUES (311,31,28,'Dared to the combat','2014-10-26 08:34:21');
INSERT INTO messages VALUES (312,13,28,'I think it be no other but een so:','2014-10-29 07:39:58');
INSERT INTO messages VALUES (313,21,28,'What might be toward, that this sweaty haste','2014-10-26 07:49:50');
INSERT INTO messages VALUES (314,11,28,'That are so fortified against our story','2014-10-18 07:26:50');
INSERT INTO messages VALUES (315,30,28,'Without the sensible and true avouch','2014-10-23 07:17:06');
INSERT INTO messages VALUES (316,20,28,'With martial stalk hath he gone by our watch.','2014-10-24 08:18:16');
INSERT INTO messages VALUES (317,31,28,'Was, as you know, by Fortinbras of Norway','2014-10-26 08:19:42');



INSERT INTO account values (203993, 'Philip', 'Hamburg');
INSERT INTO account values (203987, 'Sarah', 'Atlanta');
INSERT INTO account VALUES (9995297,'Lawana','Shanghai');
INSERT INTO account VALUES (2594447,'Petronila','Karachi');
INSERT INTO account VALUES (8618459,'Mikki','Beijing');
INSERT INTO account VALUES (4776245,'Jaye','Delhi');
INSERT INTO account VALUES (5590832,'Gwyneth','Lagos');
INSERT INTO account VALUES (4999134,'Melvin','Istanbul');
INSERT INTO account VALUES (6214973,'Jaunita','Guangzhou');
INSERT INTO account VALUES (952185,'Ophelia','Mumbai');
INSERT INTO account VALUES (1141611,'Bella','Moscow');
INSERT INTO account VALUES (8052678,'Missy','Dhaka');
INSERT INTO account VALUES (8756837,'Leonarda','Cairo');
INSERT INTO account VALUES (1102973,'Amparo','São Paulo');
INSERT INTO account VALUES (6395400,'Lu','Lahore');
INSERT INTO account VALUES (6481571,'Trisha','Shenzhen');
INSERT INTO account VALUES (4320616,'Iluminada','Seoul');
INSERT INTO account VALUES (6419807,'Sherril','Bangalore');
INSERT INTO account VALUES (761216,'Michele','Jakarta');
INSERT INTO account VALUES (8361166,'Gwen','Kinshasa');
INSERT INTO account VALUES (1188263,'Voncile','Tianjin');
INSERT INTO account VALUES (343769,'Cameron','Tokyo');
INSERT INTO account VALUES (7282653,'Beverly','Mexico City');
INSERT INTO account VALUES (4587016,'Georgeann','Hyderabad');
INSERT INTO account VALUES (8963866,'Anton','Lima');
INSERT INTO account VALUES (5707812,'Shella','London');
INSERT INTO account VALUES (526551,'Renna','New York City');
INSERT INTO account VALUES (9867888,'Dania','Bangkok');
INSERT INTO account VALUES (4770149,'Leslie','Pune');
INSERT INTO account VALUES (3818447,'Kenisha','Dongguan');
INSERT INTO account VALUES (6928632,'Juana','Tehran');
INSERT INTO account VALUES (3252981,'Florance','Bogotá');
INSERT INTO account VALUES (8798924,'Tawanda','Ho Chi Minh City');
INSERT INTO account VALUES (3014868,'Cheri','Hong Kong');
INSERT INTO account VALUES (5988905,'Melodie','Baghdad');
INSERT INTO account VALUES (457201,'Kimber','Wuhan');
INSERT INTO account VALUES (7311718,'Zina','Hanoi');
INSERT INTO account VALUES (567428,'Lonnie','Luanda');
INSERT INTO account VALUES (6687259,'Bradly','Rio de Janeiro');
INSERT INTO account VALUES (6632848,'Bethanie','Foshan');
INSERT INTO account VALUES (9100006,'Evie','Santiago');
INSERT INTO account VALUES (680677,'Hedy','Riyadh');
INSERT INTO account VALUES (8962515,'Bettyann','Ahmedabad');
INSERT INTO account VALUES (2306186,'Hobert','Singapore');
INSERT INTO account VALUES (8587211,'Clorinda','Shantou');
INSERT INTO account VALUES (9040806,'Vilma','Saint Petersburg');
INSERT INTO account VALUES (2978006,'Naida','Chennai');
INSERT INTO account VALUES (2688339,'Leland','Abidjan');
INSERT INTO account VALUES (4386567,'Laronda','Chengdu');
INSERT INTO account VALUES (9933460,'Shonda','Yangon');
INSERT INTO account VALUES (25938,'Richie','Alexandria');
INSERT INTO account VALUES (6876381,'Mathilde','Chongqing');
INSERT INTO account VALUES (8967995,'Elton','Kolkata');
INSERT INTO account VALUES (3340267,'Breann','Xian');
INSERT INTO account VALUES (9759699,'Artie','Surat');
INSERT INTO account VALUES (3461719,'Shiela','Johannesburg');
INSERT INTO account VALUES (7705576,'Viki','Nanjing');
INSERT INTO account VALUES (7319459,'Aurora','Dar es Salaam');
INSERT INTO account VALUES (616609,'Manual','Ankara');
INSERT INTO account VALUES (7775472,'Alesia','Suzhou');
INSERT INTO account VALUES (6698709,'Zofia','Harbin');
INSERT INTO account VALUES (6075710,'Agustin','Giza');
INSERT INTO account VALUES (475539,'Vivien','Zhengzhou');
INSERT INTO account VALUES (2319232,'Roslyn','New Taipei City');
INSERT INTO account VALUES (1458741,'Dalila','Los Angeles');
INSERT INTO account VALUES (691829,'Lakita','Cape Town');
INSERT INTO account VALUES (4901394,'Rossana','Shenyang');
INSERT INTO account VALUES (9107892,'Dessie','Yokohama');
INSERT INTO account VALUES (5828345,'Jeana','Busan');
INSERT INTO account VALUES (2655480,'Cristobal','Hangzhou');
INSERT INTO account VALUES (1951959,'Yasmin','Xiamen');
INSERT INTO account VALUES (193488,'Hong','Quanzhou');
INSERT INTO account VALUES (5778735,'Chan','Berlin');
INSERT INTO account VALUES (5869514,'Darwin','Jeddah');
INSERT INTO account VALUES (7260590,'Tereasa','Durban');
INSERT INTO account VALUES (4802283,'Dinorah','Kabul');
INSERT INTO account VALUES (7058971,'Jenna','Jaipur');
INSERT INTO account VALUES (5143973,'Mona','Hefei');
INSERT INTO account VALUES (1113463,'Shawana','Pyongyang');
INSERT INTO account VALUES (3575645,'Daysi','Madrid');
INSERT INTO account VALUES (8016646,'Thalia','Ekurhuleni');
INSERT INTO account VALUES (868072,'Roseanne','Nairobi');
INSERT INTO account VALUES (7302845,'Jaimie','Addis Ababa');
INSERT INTO account VALUES (2948502,'Alden','Changsha');
INSERT INTO account VALUES (4898687,'Berneice','Wenzhou');
INSERT INTO account VALUES (6979000,'Gay','Baku');
INSERT INTO account VALUES (6012119,'Georgeann','Caracas');
INSERT INTO account VALUES (2949832,'Delois','Rabat');
INSERT INTO account VALUES (5284765,'Leanora','Vienna');
INSERT INTO account VALUES (7286179,'Shella','Khartoum');
INSERT INTO account VALUES (82091,'Jacquelyn','Budapest');
INSERT INTO account VALUES (3725563,'Grisel','Warsaw');
INSERT INTO account VALUES (1783543,'Charmaine','Minsk');
INSERT INTO account VALUES (5894821,'Laquanda','Manila');
INSERT INTO account VALUES (7104020,'Candyce','Kampala');
INSERT INTO account VALUES (1486378,'Jenny','Accra');
INSERT INTO account VALUES (6598391,'Wei','Yaoundé');
INSERT INTO account VALUES (3781180,'Julietta','Antananarivo');
INSERT INTO account VALUES (7974023,'Nerissa','Beirut');
INSERT INTO account VALUES (7226852,'Fernande','Algiers');
INSERT INTO account VALUES (6234347,'Jeraldine','Quito');
INSERT INTO account VALUES (4234504,'Gerda','Doha');