diff options
| author |  Vitaly Takmazov | 2023-02-12 05:10:54 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2023-02-12 05:10:54 +0300 |
| commit | 75a631d48bc3e3fea8d35cddbe0e2c639c252796 (patch) | |
| tree | 07a49ca5da227e74a18a8c8518e03eb7d0e65847 /src/main/resources/schema-sqlite.sql | |
| parent | 32fb3f61e8ce90b30d7ba58c820c9be523e7ff3f (diff) | |
Drop `users_subscr` table
Diffstat (limited to 'src/main/resources/schema-sqlite.sql')
| -rw-r--r-- | src/main/resources/schema-sqlite.sql | 5 |
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), |