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

diff --git a/ruler_gallery_db.sql b/ruler_gallery_db.sql
index c151702..43079e6 100644
--- 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
 );