diff options
| author |  Vitaly Takmazov | 2023-01-27 19:47:48 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2023-01-27 20:33:17 +0300 |
| commit | bc354afd22433671cd250af86b787539b57fd6a8 (patch) | |
| tree | b9c750f75f141aac17718f295abece7c0cfdb4e0 /src/main | |
| parent | c2fe259c1dc558945ea8beb82cdfe5891791564c (diff) | |
db: drop `version`
Diffstat (limited to 'src/main')
| -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, |