diff options
author | 2018-04-11 20:52:23 +0300 | |
---|---|---|
committer | 2018-04-11 20:52:23 +0300 | |
commit | 47254ab8555162bc121c7b618fff42fc64b9454c (patch) | |
tree | d92ab61df0194e254df2dcdc1d4bc6744a618e86 /juick-server-jdbc/src/main/resources/update.sql | |
parent | bd05298faca4bd7f128281fa3261fb1b2c94d791 (diff) |
move db schemas to jdbc project, drop outdated config example
Diffstat (limited to 'juick-server-jdbc/src/main/resources/update.sql')
-rw-r--r-- | juick-server-jdbc/src/main/resources/update.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/juick-server-jdbc/src/main/resources/update.sql b/juick-server-jdbc/src/main/resources/update.sql new file mode 100644 index 00000000..13a62c3d --- /dev/null +++ b/juick-server-jdbc/src/main/resources/update.sql @@ -0,0 +1,12 @@ +-- if version table not exists set up version = 0; +update version set version = 0; + +DROP TABLE IF EXISTS `version`; + +CREATE TABLE `version` ( + `version` bigint NOT NULL +); + +insert into version values (0); + +update version set version = 1;
\ No newline at end of file |