X-Git-Url: https://projects.mako.cc/source/yourule/blobdiff_plain/3c8ee8b6f81d892bffbc1a5f1e7af9a9adc9fd1d..9211bd24ddba657f00371a64f139da58fffa4a88:/ruler_gallery_db.sql

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)
 );