minor typo fixes

[yourule] / ruler_gallery_db.sql

diff --git a/ruler_gallery_db.sql b/ruler_gallery_db.sql
index c151702492e9da479f3cbdfcae6f35ab1a889a56..863af503e39aae2278c9bc656a6339de288df77f 100644 (file)
--- 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)
 );