diff options
Diffstat (limited to 'src/main/resources')
-rw-r--r-- | src/main/resources/db/migration/V1.38__drop_version.sql | 1 | ||||
-rw-r--r-- | src/main/resources/schema-h2.sql | 3 | ||||
-rw-r--r-- | src/main/resources/schema-mysql.sql | 12 | ||||
-rw-r--r-- | src/main/resources/schema-sqlite.sql | 3 | ||||
-rw-r--r-- | src/main/resources/schema-sqlserver.sql | 3 |
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, |