fixed up the database and some other minor bugs

[yourule] / ruler_gallery_db.sql

diff --git a/ruler_gallery_db.sql b/ruler_gallery_db.sql
index c151702492e9da479f3cbdfcae6f35ab1a889a56..43079e67d2ccd43de6d8f1ddf8aeeb949c0ed35b 100644 (file)
--- a/ruler_gallery_db.sql
+++ b/ruler_gallery_db.sql
@@ -1,9 +1,11 @@
+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
+  model VARCHAR(255) NOT NULL,
+  show INTEGER NOT NULL DEFAULT 1
 );