aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--src/main/resources/db/migration/V1.40__drop_images.sql1
-rw-r--r--src/main/resources/db/migration/V1.41__drop_tags_synonyms.sql1
-rw-r--r--src/main/resources/schema-h2.sql14
-rw-r--r--src/main/resources/schema-mysql.sql32
-rw-r--r--src/main/resources/schema-sqlite.sql14
-rw-r--r--src/main/resources/schema-sqlserver.sql14
6 files changed, 2 insertions, 74 deletions
diff --git a/src/main/resources/db/migration/V1.40__drop_images.sql b/src/main/resources/db/migration/V1.40__drop_images.sql
new file mode 100644
index 00000000..69c762c1
--- /dev/null
+++ b/src/main/resources/db/migration/V1.40__drop_images.sql
@@ -0,0 +1 @@
+DROP TABLE images
diff --git a/src/main/resources/db/migration/V1.41__drop_tags_synonyms.sql b/src/main/resources/db/migration/V1.41__drop_tags_synonyms.sql
new file mode 100644
index 00000000..181fa48a
--- /dev/null
+++ b/src/main/resources/db/migration/V1.41__drop_tags_synonyms.sql
@@ -0,0 +1 @@
+DROP TABLE tags_synonyms
diff --git a/src/main/resources/schema-h2.sql b/src/main/resources/schema-h2.sql
index a02804d5..c2ecd4b7 100644
--- a/src/main/resources/schema-h2.sql
+++ b/src/main/resources/schema-h2.sql
@@ -34,16 +34,6 @@ CREATE MEMORY TABLE "PUBLIC"."AUTH"(
"AUTHCODE" CHARACTER(8) NOT NULL,
"TS" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL
);
-CREATE MEMORY TABLE "PUBLIC"."IMAGES"(
- "MID" INTEGER NOT NULL,
- "RID" INTEGER NOT NULL,
- "THUMB" INTEGER NOT NULL,
- "SMALL" INTEGER NOT NULL,
- "MEDIUM" INTEGER NOT NULL,
- "HEIGHT" INTEGER NOT NULL,
- "WIDTH" INTEGER NOT NULL
-);
-ALTER TABLE "PUBLIC"."IMAGES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_8" PRIMARY KEY("MID", "RID");
CREATE MEMORY TABLE "PUBLIC"."MESSAGES_PROPERTIES"(
"MESSAGE_ID" INTEGER NOT NULL,
"REPLY_ID" SMALLINT NOT NULL,
@@ -204,10 +194,6 @@ ALTER TABLE "PUBLIC"."TAGS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_27" PRIMARY KEY(
CREATE MEMORY TABLE "PUBLIC"."TAGS_IGNORE"(
"TAG_ID" INTEGER NOT NULL
);
-CREATE MEMORY TABLE "PUBLIC"."TAGS_SYNONYMS"(
- "NAME" CHARACTER(64) NOT NULL,
- "CHANGETO" CHARACTER(64) NOT NULL
-);
CREATE MEMORY TABLE "PUBLIC"."TELEGRAM"(
"USER_ID" INTEGER DEFAULT NULL,
"TG_ID" BIGINT NOT NULL,
diff --git a/src/main/resources/schema-mysql.sql b/src/main/resources/schema-mysql.sql
index 0f6321fd..58192261 100644
--- a/src/main/resources/schema-mysql.sql
+++ b/src/main/resources/schema-mysql.sql
@@ -132,25 +132,6 @@ CREATE TABLE `followers` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Table structure for table `images`
---
-
-DROP TABLE IF EXISTS `images`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `images` (
- `mid` int(10) unsigned NOT NULL,
- `rid` int(10) unsigned NOT NULL,
- `thumb` int(10) unsigned NOT NULL,
- `small` int(10) unsigned NOT NULL,
- `medium` int(10) unsigned NOT NULL,
- `height` int(10) unsigned NOT NULL,
- `width` int(10) unsigned NOT NULL,
- PRIMARY KEY (`mid`,`rid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
-- Table structure for table `jids`
--
@@ -539,19 +520,6 @@ CREATE TABLE `tags_ignore` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Table structure for table `tags_synonyms`
---
-
-DROP TABLE IF EXISTS `tags_synonyms`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tags_synonyms` (
- `name` char(64) NOT NULL,
- `changeto` char(64) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
-- Table structure for table `telegram`
--
diff --git a/src/main/resources/schema-sqlite.sql b/src/main/resources/schema-sqlite.sql
index 39895b2e..9037aef0 100644
--- a/src/main/resources/schema-sqlite.sql
+++ b/src/main/resources/schema-sqlite.sql
@@ -61,16 +61,6 @@ CREATE TABLE followers (
PRIMARY KEY (user_id)
FOREIGN KEY (user_id) REFERENCES users(id)
);
-CREATE TABLE images (
- mid bigint NOT NULL,
- rid bigint NOT NULL,
- thumb bigint NOT NULL,
- small bigint NOT NULL,
- medium bigint NOT NULL,
- height bigint NOT NULL,
- width bigint NOT NULL,
- PRIMARY KEY (mid, rid)
-);
CREATE TABLE jids (
user_id INTEGER,
jid character varying(64) NOT NULL,
@@ -213,10 +203,6 @@ CREATE TABLE tags_ignore (
tag_id bigint NOT NULL,
FOREIGN KEY (tag_id) REFERENCES tags(tag_id)
);
-CREATE TABLE tags_synonyms (
- name character varying(64) NOT NULL,
- changeto character varying(64) NOT NULL
-);
CREATE TABLE telegram (
user_id INTEGER,
tg_id numeric NOT NULL,
diff --git a/src/main/resources/schema-sqlserver.sql b/src/main/resources/schema-sqlserver.sql
index 71539577..aafc159d 100644
--- a/src/main/resources/schema-sqlserver.sql
+++ b/src/main/resources/schema-sqlserver.sql
@@ -87,16 +87,6 @@ CREATE TABLE followers (
PRIMARY KEY (user_id),
FOREIGN KEY (user_id) REFERENCES users(id)
);
-CREATE TABLE images (
- mid bigint NOT NULL,
- rid bigint NOT NULL,
- thumb bigint NOT NULL,
- small bigint NOT NULL,
- medium bigint NOT NULL,
- height bigint NOT NULL,
- width bigint NOT NULL,
- PRIMARY KEY (mid, rid)
-);
CREATE TABLE jids (
user_id bigint,
jid character varying(64) NOT NULL,
@@ -229,10 +219,6 @@ CREATE TABLE tags_ignore (
tag_id integer NOT NULL,
FOREIGN KEY (tag_id) REFERENCES tags(tag_id)
);
-CREATE TABLE tags_synonyms (
- name character varying(64) NOT NULL,
- changeto character varying(64) NOT NULL
-);
CREATE TABLE telegram (
user_id bigint,
tg_id numeric NOT NULL,