diff options
Diffstat (limited to 'bin/serve.fnl')
| -rw-r--r-- | bin/serve.fnl | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/bin/serve.fnl b/bin/serve.fnl index a76de08..327060d 100644 --- a/bin/serve.fnl +++ b/bin/serve.fnl @@ -52,13 +52,17 @@ CREATE TABLE IF NOT EXISTS products( name TEXT PRIMARY KEY, creation_time TEXT NOT NULL, + position INTEGER NOT NULL DEFAULT 0, + published BOOLEAN NOT NULL DEFAULT false, title TEXT NOT NULL, type TEXT NOT NULL, packaging TEXT NOT NULL, description TEXT, short_description TEXT NOT NULL, - position INTEGER NOT NULL DEFAULT 0, - published BOOLEAN NOT NULL DEFAULT false, + year INTEGER, + season TEXT, + region TEXT, + recommendations TEXT, price_per REAL, stock REAL, vendor TEXT, |