aboutsummaryrefslogtreecommitdiff
path: root/juick-common/src/main/resources/update.sql
blob: 13a62c3d4e3c28c6f6ef47f4203c452416900480 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
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;