X-Git-Url: https://projects.mako.cc/source/yourule/blobdiff_plain/769e51f5d2f06c6e40a09378b9c127d21d65c8f5..60fb976b999db8adb5bd7a1b0f1e53d6e2daa301:/ruler_gallery_db.sql

diff --git a/ruler_gallery_db.sql b/ruler_gallery_db.sql
index c151702..863af50 100644
--- a/ruler_gallery_db.sql
+++ b/ruler_gallery_db.sql
@@ -1,9 +1,12 @@
+DROP TABLE IF EXISTS gallery;
 CREATE TABLE gallery (
-  id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-  pixel_width REAL NOT NULL,
-  unit_width REAL NOT NULL,
-  units VARCHAR(100) NOT NULL,
-  model VARCHAR(255) NOT NULL
+  id integer not null auto_increment,
+  pixel_width float not null,
+  unit_width float not null,
+  units VARCHAR(100) not null,
+  model VARCHAR(255) not null,
+  visible tinyint not null default 1,
+  primary key (id)
 );