From 75a631d48bc3e3fea8d35cddbe0e2c639c252796 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Sun, 12 Feb 2023 05:10:54 +0300
Subject: Drop `users_subscr` table

---
 src/main/resources/schema-h2.sql | 5 -----
 1 file changed, 5 deletions(-)

(limited to 'src/main/resources/schema-h2.sql')

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,
-- 
cgit v1.2.3

