From 4ccc095ed2efeda97805bdfb9473f62ed46220b7 Mon Sep 17 00:00:00 2001 From: Akshay Nair Date: Tue, 2 Jun 2026 11:51:17 +0530 Subject: Show pixels from db --- setup.sql | 45 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 45 insertions(+) create mode 100644 setup.sql (limited to 'setup.sql') 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); -- cgit v1.3.1