diff options
| author | Akshay Nair <phenax5@gmail.com> | 2026-06-02 11:51:17 +0530 |
|---|---|---|
| committer | Akshay Nair <phenax5@gmail.com> | 2026-06-02 11:51:17 +0530 |
| commit | 4ccc095ed2efeda97805bdfb9473f62ed46220b7 (patch) | |
| tree | d159a226caf7619d56252c58f354189926ef51c2 /setup.sql | |
| parent | 6cb596cafa71b8c8d3521deb0521c0969942fb3a (diff) | |
| download | sqlite-creative-coding-4ccc095ed2efeda97805bdfb9473f62ed46220b7.tar.gz sqlite-creative-coding-4ccc095ed2efeda97805bdfb9473f62ed46220b7.zip | |
Show pixels from db
Diffstat (limited to '')
| -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); |