db: drop `version`

5 files changed, 1 insertions, 21 deletions

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
@@ -698,18 +698,6 @@ CREATE TABLE `usersinfo` (
 /*!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,