aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/schema-sqlite.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources/schema-sqlite.sql')
-rw-r--r--src/main/resources/schema-sqlite.sql5
1 files changed, 0 insertions, 5 deletions
diff --git a/src/main/resources/schema-sqlite.sql b/src/main/resources/schema-sqlite.sql
index ea9ffe36..0e298cdf 100644
--- a/src/main/resources/schema-sqlite.sql
+++ b/src/main/resources/schema-sqlite.sql
@@ -229,11 +229,6 @@ CREATE TABLE users (
last_seen timestamp with time zone,
UNIQUE(nick)
);
-CREATE TABLE users_subscr (
- user_id INTEGER NOT NULL,
- cnt smallint DEFAULT (0) NOT NULL,
- FOREIGN KEY (user_id) REFERENCES users(id)
-);
CREATE TABLE usersinfo (
user_id INTEGER NOT NULL,
jid character varying(64),