summaryrefslogtreecommitdiff
path: root/util/sql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r--util/sql/schema.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 5d4a801e..57f33efc 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -462,7 +462,7 @@ CREATE TABLE sessions (
CREATE TABLE shop_denpa (
id text NOT NULL PRIMARY KEY,
lastfetch timestamptz,
- found boolean NOT NULL DEFAULT false,
+ deadsince timestamptz,
sku text NOT NULL DEFAULT '',
price text NOT NULL DEFAULT ''
);
@@ -471,7 +471,7 @@ CREATE TABLE shop_denpa (
CREATE TABLE shop_dlsite (
id text NOT NULL PRIMARY KEY,
lastfetch timestamptz,
- found boolean NOT NULL DEFAULT false,
+ deadsince timestamptz,
shop text NOT NULL DEFAULT '',
price text NOT NULL DEFAULT ''
);
@@ -480,7 +480,7 @@ CREATE TABLE shop_dlsite (
CREATE TABLE shop_jlist (
id text NOT NULL PRIMARY KEY,
lastfetch timestamptz,
- found boolean NOT NULL DEFAULT false,
+ deadsince timestamptz,
jbox boolean NOT NULL DEFAULT false,
price text NOT NULL DEFAULT '' -- empty when unknown or not in stock
);
@@ -489,7 +489,7 @@ CREATE TABLE shop_jlist (
CREATE TABLE shop_mg (
id integer NOT NULL PRIMARY KEY,
lastfetch timestamptz,
- found boolean NOT NULL DEFAULT false,
+ deadsince timestamptz,
r18 boolean NOT NULL DEFAULT true,
price text NOT NULL DEFAULT ''
);