-
Notifications
You must be signed in to change notification settings - Fork 3
/
makeit_db.example
15 lines (15 loc) · 1.67 KB
/
makeit_db.example
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
BEGIN;
INSERT INTO "members" VALUES(1,'brad.goodman',"[email protected]","[email protected]",'Brad',"brad",'Goodman','6173201472','Hobbiest',1,NULL,1,'',NULL,'2019-01-07 19:14:26',NULL);
INSERT INTO "members" VALUES(2,'john.smith',"[email protected]","[email protected]",'John',"johnsmith",'Smith','1234567890','Hobbiest',1,NULL,0,'',NULL,'2019-01-07 19:17:26',NULL);
INSERT INTO "members" VALUES(3,'guy.smiley',"[email protected]","[email protected]",'Guy',"g.smi",'Smiley','5555551212','Pro',0,NULL,0,'',NULL,'2019-01-07 19:18:26',NULL);
INSERT INTO "resources" VALUES(1,'laser','rabbit','[email protected]',NULL);
INSERT INTO "resources" VALUES(2,'frontdoor','The Front Door','[email protected]',NULL);
INSERT INTO "resources" VALUES(3,'fullspectrum','Full Spectrum 40W Laser','[email protected]',NULL);
INSERT INTO "resources" VALUES(4,'autolift','The Auto Lift','[email protected]',NULL);
INSERT INTO "accessbymember" VALUES(1,1,1,1,'2019-01-07 19:11:05.291519','2019-01-07 19:11:05.291519',"Comment","","","Brad",0);
INSERT INTO "accessbymember" VALUES(2,1,2,1,'2019-01-07 19:11:05.291519','2019-01-07 19:11:05.291519',"Comment","","","Brad",0);
INSERT INTO "accessbymember" VALUES(3,1,3,1,'2019-01-07 19:11:05.291519','2019-01-07 19:11:05.291519',"Comment","","","Brad",0);
INSERT INTO "accessbymember" VALUES(4,2,1,1,'2019-01-07 19:11:05.291519','2019-01-07 19:11:05.291519',"Comment","","","Brad",0);
INSERT INTO "accessbymember" VALUES(5,2,2,1,'2019-01-07 19:11:05.291519','2019-01-07 19:11:05.291519',"Comment","","","Brad",0);
INSERT INTO "accessbymember" VALUES(6,3,1,1,'2019-01-07 19:11:05.291519','2019-01-07 19:11:05.291519',"Comment","","","Brad",0);
COMMIT;