forked from CsharpDatabase/CsharpSQLite
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathPeople.sql
More file actions
executable file
·102 lines (101 loc) · 9.87 KB
/
People.sql
File metadata and controls
executable file
·102 lines (101 loc) · 9.87 KB
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
CREATE TABLE People (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255) NOT NULL, double DECIMAL NOT NULL, testtext VARCHAR(8000) NOT NULL, testguid GUID NOT NULL);
INSERT INTO People VALUES(null,'Singleton',-25,'PHU74JVF3MT','ccb52c4a-c96a-4b44-9c40-6faff8f2a04b');
INSERT INTO People VALUES(null,'Kaufman',-24.5,'ZEX20GFD7JI','4b0c0871-9ba4-447c-b802-7f266b73b2f0');
INSERT INTO People VALUES(null,'Malone',-24,'ENY71OOU8JO','c5793673-770b-49a7-bc55-c6e76f3b1d52');
INSERT INTO People VALUES(null,'Gallagher',-23.5,'SJN18HPW4MB','014e8c91-196a-43d4-a265-46f41d160807');
INSERT INTO People VALUES(null,'Jackson',-23,'SHP56YBV4AO','00e7daa6-969e-41ed-8956-094dd4484f5f');
INSERT INTO People VALUES(null,'Nelson',-22.5,'PCM44ATE3HH','6545b46a-66af-4b6b-918e-8b3ee12d287b');
INSERT INTO People VALUES(null,'Duke',-22,'OWC03EMC4BP','28763dcd-0090-44c9-81c5-a6069385af10');
INSERT INTO People VALUES(null,'Bullock',-21.5,'ZRY46MCG6PS','e3264e99-4c3b-4085-a1ed-a60779c5d1ca');
INSERT INTO People VALUES(null,'Blair',-21,'PMG97OGI4JI','6a97de53-b12b-4f78-9642-2d907bd1e5f4');
INSERT INTO People VALUES(null,'Rocha',-20.5,'NUW98LCV1AH','ded5e14e-0493-4234-ba9e-6461fef4c944');
INSERT INTO People VALUES(null,'Romero',-20,'NKB19TFP2MO','9be2de77-7a34-4532-a4ce-6123ac3a5210');
INSERT INTO People VALUES(null,'Wiggins',-19.5,'AVH41PGR3CQ','b581550f-1e58-4b92-b374-a4a7dafa1ddc');
INSERT INTO People VALUES(null,'Delacruz',-19,'OSB67JMH7NK','6491cb75-bde2-4c07-a0e5-3dfcf16578a8');
INSERT INTO People VALUES(null,'Price',-18.5,'GPI40XLD7SO','7764ab1a-481d-46fb-8423-87b3f4828457');
INSERT INTO People VALUES(null,'Stephens',-18,'IVO79EYM8AE','e8b2abe4-d70d-403e-8ab5-987d38bf30f1');
INSERT INTO People VALUES(null,'Moran',-17.5,'JQX11IWK9EX','127ae0f4-5eaa-42ca-999a-28e2ffcc3db2');
INSERT INTO People VALUES(null,'Armstrong',-17,'BID70SQJ5FB','aae888a3-dddb-4393-8834-eb0e3bc6b90e');
INSERT INTO People VALUES(null,'Huffman',-16.5,'JAY20CXJ7VM','28e0f74f-5b0d-4450-90aa-48b1d8a78c89');
INSERT INTO People VALUES(null,'Todd',-16,'DII05FCP5GJ','ec3d8837-0590-4a83-9ec2-2bfe4bc53353');
INSERT INTO People VALUES(null,'Mcintyre',-15.5,'YAZ42BYP0WW','5fe77bbd-bf01-4f44-8f88-a7aa84939b35');
INSERT INTO People VALUES(null,'Berger',-15,'ZUL76XQU2YW','b76fd4eb-dc62-4d31-89f2-1fea91779120');
INSERT INTO People VALUES(null,'Riddle',-14.5,'EZJ61SHD7HP','7b03da15-db47-406e-9c4c-a1116c829fae');
INSERT INTO People VALUES(null,'William',-14,'IOP34MLK2WD','1d415649-0e4a-4a66-9751-fe05ac252059');
INSERT INTO People VALUES(null,'Tillman',-13.5,'UTR07OVW5EO','3c85b675-c77a-480e-a148-a8270053eda9');
INSERT INTO People VALUES(null,'Parrish',-13,'XWV61LQL9FV','0b4d039e-c96b-474f-a014-22f3260bb450');
INSERT INTO People VALUES(null,'Hernandez',-12.5,'RHV91YVY7NZ','787cac74-6fb4-40d5-9dd4-31eae542d0cf');
INSERT INTO People VALUES(null,'Hobbs',-12,'BUH59WHW7DN','ece8debf-2467-45d4-899b-626c335c4934');
INSERT INTO People VALUES(null,'Stevenson',-11.5,'PEI53EZA4UZ','eed79550-f8de-48d4-b162-550a86fba808');
INSERT INTO People VALUES(null,'Mcguire',-11,'TUO43NWK3EZ','20b2e792-26d1-4223-b3b2-3d7414e84ccf');
INSERT INTO People VALUES(null,'Freeman',-10.5,'BGE73SRY8ZN','94385e2d-8f5e-4906-b4d4-d279898b4ae4');
INSERT INTO People VALUES(null,'Dickerson',-10,'ENH63GFB0TN','84362c52-0770-44d1-913e-64bb31b55e69');
INSERT INTO People VALUES(null,'Graham',-9.5,'HKT65SYQ9DK','bf17e30f-3cb2-4b4b-8449-45c6ee68ec65');
INSERT INTO People VALUES(null,'Fulton',-9,'VCG70UYG2FW','79714a0c-5145-4e46-ac55-a9b651ba9220');
INSERT INTO People VALUES(null,'Mcmillan',-8.5,'LBR48EWC5PS','c6d2a267-889b-4c26-b955-af73d434409d');
INSERT INTO People VALUES(null,'Chavez',-8,'HQU27FOP3VH','e320ec8b-cd1d-43c2-a194-b8f433235ce6');
INSERT INTO People VALUES(null,'Harrell',-7.5,'QGQ94MNX5FK','7cfc4a54-88f3-446b-ab7c-156a5e9ae471');
INSERT INTO People VALUES(null,'Green',-7,'JGL98DDD7YK','0de25bb4-2fb9-42b9-9744-776c770de268');
INSERT INTO People VALUES(null,'Knowles',-6.5,'EZC48JWL6MJ','29b83f99-ad08-4cba-9bd0-eae1e513afe2');
INSERT INTO People VALUES(null,'Bonner',-6,'ZXA50KXM6JL','37c4c82b-2e9c-4d29-8136-949c8e677c33');
INSERT INTO People VALUES(null,'Larson',-5.5,'MOR25CUR0WD','da49d4b5-3388-45fd-bffb-ea9f817b636f');
INSERT INTO People VALUES(null,'Strickland',-5,'GZI84RYM5YA','227b8545-c5d1-40e7-a72f-d7b81bb73eb7');
INSERT INTO People VALUES(null,'Myers',-4.5,'JYD02OOU1FB','58b9b156-443f-453b-83b7-50b8d134f52a');
INSERT INTO People VALUES(null,'Mendez',-4,'HVH36KGX4OU','fcdb78c2-239f-446e-bf37-53f164eda6b0');
INSERT INTO People VALUES(null,'Tillman',-3.5,'GSJ86KMA3PA','753d6086-30ea-4b09-ae9d-a45ccd01aa87');
INSERT INTO People VALUES(null,'Meyers',-3,'EOK27LXC2EL','f01b2b20-c7ef-47c2-b83b-5f25548302fb');
INSERT INTO People VALUES(null,'Wade',-2.5,'PSV92PXN3HI','dc038c13-4528-477b-bb89-75e8dc1a4186');
INSERT INTO People VALUES(null,'Wiley',-2,'RVZ04ZQP5BW','8a382fbd-8606-4b09-8e14-e8e22bb754fb');
INSERT INTO People VALUES(null,'Gomez',-1.5,'MTL79XRN5NN','f31a0b0f-d83e-4276-a916-1d77c7371f79');
INSERT INTO People VALUES(null,'Snow',-1,'DKJ46SLJ5KJ','2855db17-8710-46e7-9206-a6b96b950283');
INSERT INTO People VALUES(null,'Woodward',-0.5,'KAP90LHO2TI','21752826-0ede-4d65-aed2-6917faaba337');
INSERT INTO People VALUES(null,'Carey',0,'QZR25ECR5LD','128180c0-e473-4758-9513-6ff831662bce');
INSERT INTO People VALUES(null,'Cox',0.5,'EOO79YSJ9HH','74072a23-c0e2-4476-95c8-694f5f6cf7d5');
INSERT INTO People VALUES(null,'Atkinson',1,'TPP93XCZ9TF','f482baea-995a-47ba-9bdf-2e895d7c8465');
INSERT INTO People VALUES(null,'Hobbs',1.5,'XHC47FRY7FR','7f955ec8-5a56-4e8c-b588-dd6ee4607425');
INSERT INTO People VALUES(null,'Patton',2,'DJB06JDL9SK','1e58a484-07c1-44cd-97f9-8076cee5b4cd');
INSERT INTO People VALUES(null,'Gilbert',2.5,'PNI52OYF8AR','986d5253-2712-4ddf-91e3-de10fb708f56');
INSERT INTO People VALUES(null,'Mcintosh',3,'GIN95ESS5TU','e85c1a2a-c2f3-4d5c-9ecf-d1fe74369a8a');
INSERT INTO People VALUES(null,'Dickson',3.5,'DXR16BLG5UT','42361bb7-0a91-4022-a354-bb2e60d924c8');
INSERT INTO People VALUES(null,'Silva',4,'ISA17STZ0HZ','aae445c1-9b4e-47cb-8465-6db0f223e101');
INSERT INTO People VALUES(null,'Mays',4.5,'MRH04CHO9YR','ad613da9-e501-45e4-b350-0f0598ac2bb3');
INSERT INTO People VALUES(null,'Miller',5,'ADW59QLF3MK','7646dbc6-6846-47ea-924b-ab663d59134a');
INSERT INTO People VALUES(null,'Bird',5.5,'EEB14ATY6BZ','d92ebaa1-b61a-4716-9386-a0e1d0ef99e2');
INSERT INTO People VALUES(null,'Britt',6,'DGR12ITG4QV','3f538ea3-f694-4546-b63a-932d5ef5ccad');
INSERT INTO People VALUES(null,'Guerrero',6.5,'GGP57ZRX1SC','a0ed40d0-99f5-4914-b31a-11b7bfb3ab2d');
INSERT INTO People VALUES(null,'Mcpherson',7,'SWO39NMB7DE','0293fb02-1095-4778-8665-fface4ed39e6');
INSERT INTO People VALUES(null,'Arnold',7.5,'MYG95CIV3YK','dcd72c72-bff4-4027-a4c8-1279919f4e44');
INSERT INTO People VALUES(null,'Bradshaw',8,'XBA07CRM9GW','b6133673-a55b-4236-bf2c-f40658507a8f');
INSERT INTO People VALUES(null,'Stewart',8.5,'TJX55CPA0VZ','8f6aabad-b7e8-41e8-8485-b641207fc8a8');
INSERT INTO People VALUES(null,'May',9,'YHK22UKD8KF','1512b356-aa0d-44c5-a1be-24a0c31880b8');
INSERT INTO People VALUES(null,'Morrow',9.5,'MXD41AIX3GM','73d22926-d406-4859-8ffa-05933538c945');
INSERT INTO People VALUES(null,'Stafford',10,'IBW39VYV1ID','3179672a-a614-4985-8ef8-69a8fa85f2ce');
INSERT INTO People VALUES(null,'Gray',10.5,'CNN99TQK6TV','0eb8113a-ce70-4f3b-b217-c93c998b67a0');
INSERT INTO People VALUES(null,'Salas',11,'TES14FZT2WC','fc5dec77-4227-41e4-b8d2-b7a6369d9fd4');
INSERT INTO People VALUES(null,'Cline',11.5,'RAA83EEL6RL','38dc69b4-88fb-436b-a5fa-38080177f2bc');
INSERT INTO People VALUES(null,'Mckee',12,'LBZ08VXO0QR','f24ee6be-b413-409c-a6cb-76c5eeb5de55');
INSERT INTO People VALUES(null,'Hendrix',12.5,'VRD05GHF2HB','7cba0c60-d3d1-4fae-9f69-d365ff3a42b7');
INSERT INTO People VALUES(null,'Mendez',13,'MFB19MTI5TL','9e83c6d3-e08b-4bb1-b88c-420420ea70cb');
INSERT INTO People VALUES(null,'Goff',13.5,'PIX59PAT2DW','f30f1d12-ce81-40d3-b56d-dfcf42f6eddc');
INSERT INTO People VALUES(null,'Sanchez',14,'KDA64BHX2JB','bd060e27-e4fc-43d8-a20a-8c5aff6ceb67');
INSERT INTO People VALUES(null,'Cruz',14.5,'WVO35ZTE3RT','b326c710-532d-4cba-b439-170a21dd841c');
INSERT INTO People VALUES(null,'Duncan',15,'GTA59WJI0JZ','0d9ce7c5-ac75-4efc-be07-9e20e40ac366');
INSERT INTO People VALUES(null,'Hutchinson',15.5,'LHJ76LZM2NW','2f7dfe12-c0bd-455b-a5be-b81d6ec32f27');
INSERT INTO People VALUES(null,'Serrano',16,'NQZ82TCN5CB','883bec43-ee66-4491-a073-6d4268d0eff8');
INSERT INTO People VALUES(null,'Hester',16.5,'ZKS08SMG9WA','20e98bc6-4410-4053-a704-31115a748dbc');
INSERT INTO People VALUES(null,'Molina',17,'HZD55AJA6JW','5f504ba0-7b8e-4b34-9650-e9e3b28aae73');
INSERT INTO People VALUES(null,'Tran',17.5,'DYL60NBA9UB','660e0b3e-58b0-4dcf-9995-5b2f8a9485af');
INSERT INTO People VALUES(null,'Poole',18,'MNZ43ZCR9GF','0bbb1a8d-e0c9-4009-9092-ee54e8fc7c7d');
INSERT INTO People VALUES(null,'Jimenez',18.5,'GPM89IUB2FS','27241683-8700-455a-aa4b-337f893a6293');
INSERT INTO People VALUES(null,'Fulton',19,'STJ65KJZ9JM','87fd2bc2-98d6-4af8-9c4c-232eeff926df');
INSERT INTO People VALUES(null,'Frye',19.5,'JPZ38EVB7IX','27aade0e-220e-4ae2-a82e-7bba8f61032b');
INSERT INTO People VALUES(null,'Phelps',20,'RRU98MGP2PG','4c8931d9-d18b-427c-9100-9a80151ba971');
INSERT INTO People VALUES(null,'Pickett',20.5,'AQS90EGK7GT','c7181b8e-91ac-47e9-b162-1e1ec6d7f866');
INSERT INTO People VALUES(null,'Mccall',21,'LOQ28OYN2TL','d94bec02-7352-425c-91e1-9e5dcad19027');
INSERT INTO People VALUES(null,'Burnett',21.5,'FST43AEI6WH','dbc09f9c-a2ec-4122-b3a9-46f0b7613ec0');
INSERT INTO People VALUES(null,'Nolan',22,'BOB88UKG3BL','19c8f252-9b5a-48c8-bd6e-ffaa3c38833a');
INSERT INTO People VALUES(null,'Dawson',22.5,'PKT81FYJ9RU','3fbfc79c-e310-44e4-a15c-d077c93a9bc7');
INSERT INTO People VALUES(null,'Dotson',23,'RYP38WZX4BT','1d8f14ee-fcab-43f3-934c-d44d2ce4deae');
INSERT INTO People VALUES(null,'David',23.5,'WEM22YLU3FP','a5855bbf-acb1-4c17-a111-fea25a75c927');
INSERT INTO People VALUES(null,'Humphrey',24,'KOU32PPW5EF','98e390fc-10ab-4511-8cdc-68cf09a121eb');
INSERT INTO People VALUES(null,'Hamilton',24.5,'BFH42ARD1EJ','9def76e1-e37e-49cf-aa69-4b408574d1e5');