aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/schema-h2.sql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2023-02-12 05:10:54 +0300
committerGravatar Vitaly Takmazov2023-02-12 05:10:54 +0300
commit75a631d48bc3e3fea8d35cddbe0e2c639c252796 (patch)
tree07a49ca5da227e74a18a8c8518e03eb7d0e65847 /src/main/resources/schema-h2.sql
parent32fb3f61e8ce90b30d7ba58c820c9be523e7ff3f (diff)
Drop `users_subscr` table
Diffstat (limited to 'src/main/resources/schema-h2.sql')
-rw-r--r--src/main/resources/schema-h2.sql5
1 files changed, 0 insertions, 5 deletions
diff --git a/src/main/resources/schema-h2.sql b/src/main/resources/schema-h2.sql
index 08a63839..ea979df1 100644
--- a/src/main/resources/schema-h2.sql
+++ b/src/main/resources/schema-h2.sql
@@ -216,11 +216,6 @@ CREATE MEMORY TABLE "PUBLIC"."TWITTER"(
"CROSSPOST" TINYINT DEFAULT '1' NOT NULL
);
ALTER TABLE "PUBLIC"."TWITTER" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_F" PRIMARY KEY("USER_ID");
-CREATE MEMORY TABLE "PUBLIC"."USERS_SUBSCR"(
- "USER_ID" INTEGER NOT NULL,
- "CNT" SMALLINT DEFAULT '0' NOT NULL
-);
-ALTER TABLE "PUBLIC"."USERS_SUBSCR" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_BB" PRIMARY KEY("USER_ID");
CREATE MEMORY TABLE "PUBLIC"."USERSINFO"(
"USER_ID" INTEGER NOT NULL,
"JID" CHARACTER(32) DEFAULT NULL,