Initial import

[zanchey/dispense2.git] / sql-edition / schema / populate.sql

diff --git a/sql-edition/schema/populate.sql b/sql-edition/schema/populate.sql
new file mode 100644 (file)
index 0000000..3f9b1b3
--- /dev/null
+++ b/sql-edition/schema/populate.sql
@@ -0,0 +1,50 @@
+DELETE FROM cokecontrollers;
+DELETE FROM doorcontrollers;
+
+COPY cokecontrollers (user_name, reason) FROM stdin;
+root   automatic
+bers   19990421
+mjdawson       19990421
+mtearle        19990421
+nick   19990421
+japester       19990421
+maset  19990421
+djinn  19990519
+grahame        19990714
+maelstrm       19991208
+trs80  20000822
+tieryn 20010328
+dayta  20010328
+ack    20010510
+colm   20010510
+davidb 20010510
+nikita 20010510
+fitz   20010510
+omailes        20010712
+matt   20020412
+susie  20020809
+griffin        20020809
+tpope  20021018
+maelkann       20021031
+dagobah        20030401
+thebmw 20030401
+coxy   20031010
+\.
+
+COPY doorcontrollers (user_name, reason) FROM stdin;
+root   by default
+trs80  meeting 2000-05-18 cos he\'s cool
+chas   meeting 2000-05-18 he\'s always in
+matt   the not meeting of 2002-01-04
+thebmw the meeting of 2002-08-09
+susie  the sgm of 2002-10-18
+velithya       blah
+coxy   meeting 2003-03-07
+dagobah        meeting 2003-03-07
+davyd  meeting 2003-03-07
+grahame        cos
+falstaff       some time
+griffin        foo
+vegeta shrug
+\.
+