aboutsummaryrefslogtreecommitdiff
path: root/setup.sql
diff options
context:
space:
mode:
Diffstat (limited to 'setup.sql')
-rw-r--r--setup.sql45
1 files changed, 45 insertions, 0 deletions
diff --git a/setup.sql b/setup.sql
new file mode 100644
index 0000000..164e63d
--- /dev/null
+++ b/setup.sql
@@ -0,0 +1,45 @@
+CREATE TABLE pixels (
+ x INTEGER,
+ y INTEGER,
+ r INTEGER,
+ g INTEGER,
+ b INTEGER,
+ UNIQUE(x, y)
+);
+
+INSERT INTO pixels (x, y, r, g, b) VALUES (1, 1, 0, 255, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (2, 1, 0, 255, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (3, 1, 0, 255, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (4, 1, 0, 255, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (5, 1, 0, 255, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (6, 1, 0, 255, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (1, 2, 0, 255, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (2, 2, 0, 255, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (3, 2, 0, 255, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (4, 2, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (5, 2, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (6, 2, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (1, 3, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (2, 3, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (3, 3, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (4, 3, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (5, 3, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (6, 3, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (1, 4, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (2, 4, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (3, 4, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (4, 4, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (5, 4, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (6, 4, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (1, 5, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (2, 5, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (3, 5, 255, 0, 0);
+INSERT INTO pixels (x, y, r, g, b) VALUES (4, 5, 0, 0, 255);
+INSERT INTO pixels (x, y, r, g, b) VALUES (5, 5, 0, 0, 255);
+INSERT INTO pixels (x, y, r, g, b) VALUES (6, 5, 0, 0, 255);
+INSERT INTO pixels (x, y, r, g, b) VALUES (1, 6, 0, 0, 255);
+INSERT INTO pixels (x, y, r, g, b) VALUES (2, 6, 0, 0, 255);
+INSERT INTO pixels (x, y, r, g, b) VALUES (3, 6, 0, 0, 255);
+INSERT INTO pixels (x, y, r, g, b) VALUES (4, 6, 0, 0, 255);
+INSERT INTO pixels (x, y, r, g, b) VALUES (5, 6, 0, 0, 255);
+INSERT INTO pixels (x, y, r, g, b) VALUES (6, 6, 0, 0, 255);