X-Git-Url: https://projects.mako.cc/source/yourule/blobdiff_plain/c61d6a6300242da86d532d34bb0506e04c9de658..e9647b2143c8c4ec343d66ad3083aabd77659b14:/ruler_gallery_db.sql?ds=sidebyside

diff --git a/ruler_gallery_db.sql b/ruler_gallery_db.sql
index 43079e6..863af50 100644
--- a/ruler_gallery_db.sql
+++ b/ruler_gallery_db.sql
@@ -1,11 +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,
-  show INTEGER NOT NULL DEFAULT 1
+  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)
 );