From bc354afd22433671cd250af86b787539b57fd6a8 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Fri, 27 Jan 2023 19:47:48 +0300
Subject: db: drop `version`

---
 src/main/resources/db/migration/V1.38__drop_version.sql |  1 +
 src/main/resources/schema-h2.sql                        |  3 ---
 src/main/resources/schema-mysql.sql                     | 12 ------------
 src/main/resources/schema-sqlite.sql                    |  3 ---
 src/main/resources/schema-sqlserver.sql                 |  3 ---
 5 files changed, 1 insertion(+), 21 deletions(-)
 create mode 100644 src/main/resources/db/migration/V1.38__drop_version.sql

(limited to 'src/main/resources')

diff --git a/src/main/resources/db/migration/V1.38__drop_version.sql b/src/main/resources/db/migration/V1.38__drop_version.sql
new file mode 100644
index 00000000..f5201bb7
--- /dev/null
+++ b/src/main/resources/db/migration/V1.38__drop_version.sql
@@ -0,0 +1 @@
+drop table version
diff --git a/src/main/resources/schema-h2.sql b/src/main/resources/schema-h2.sql
index 43320fb6..13799b9d 100644
--- a/src/main/resources/schema-h2.sql
+++ b/src/main/resources/schema-h2.sql
@@ -271,9 +271,6 @@ CREATE MEMORY TABLE "PUBLIC"."LOGINS"(
     "USER_ID" INTEGER NOT NULL,
     "HASH" CHARACTER(16) NOT NULL
 );
-CREATE MEMORY TABLE "PUBLIC"."VERSION"(
-    "VERSION" BIGINT NOT NULL
-);
 CREATE MEMORY TABLE "PUBLIC"."WL_USERS"(
     "USER_ID" INTEGER NOT NULL,
     "WL_USER_ID" INTEGER NOT NULL
diff --git a/src/main/resources/schema-mysql.sql b/src/main/resources/schema-mysql.sql
index 5ffaba3c..2f3f9bfa 100644
--- a/src/main/resources/schema-mysql.sql
+++ b/src/main/resources/schema-mysql.sql
@@ -697,18 +697,6 @@ CREATE TABLE `usersinfo` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
---
--- Table structure for table `version`
---
-
-DROP TABLE IF EXISTS `version`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `version` (
-  `version` bigint(20) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
 --
 -- Table structure for table `vk`
 --
diff --git a/src/main/resources/schema-sqlite.sql b/src/main/resources/schema-sqlite.sql
index 7ec33395..3c31381d 100644
--- a/src/main/resources/schema-sqlite.sql
+++ b/src/main/resources/schema-sqlite.sql
@@ -273,9 +273,6 @@ CREATE TABLE usersinfo (
     descr text,
     FOREIGN KEY (user_id) REFERENCES users(id)
 );
-CREATE TABLE version (
-    version numeric NOT NULL
-);
 CREATE TABLE vk (
     user_id bigint,
     vk_id numeric NULL,
diff --git a/src/main/resources/schema-sqlserver.sql b/src/main/resources/schema-sqlserver.sql
index ce6fc4df..7fb2d4e0 100644
--- a/src/main/resources/schema-sqlserver.sql
+++ b/src/main/resources/schema-sqlserver.sql
@@ -269,9 +269,6 @@ CREATE TABLE usersinfo (
     descr text,
     FOREIGN KEY (user_id) REFERENCES users(id)
 );
-CREATE TABLE version (
-    version numeric NOT NULL
-);
 CREATE TABLE vk (
     user_id bigint,
     vk_id numeric NULL,
-- 
cgit v1.2.3