diff options
Diffstat (limited to 'setup.sql')
| -rw-r--r-- | setup.sql | 45 |
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); |
