diff --git a/src/main/resources/update/1_4.sql b/src/main/resources/update/1_4.sql new file mode 100644 index 0000000..a68ca43 --- /dev/null +++ b/src/main/resources/update/1_4.sql @@ -0,0 +1,10 @@ +CREATE TABLE GROUP_MEMBER( + GROUP_NAME VARCHAR(100) NOT NULL, + USER_NAME VARCHAR(100) NOT NULL +); + +ALTER TABLE GROUP_MEMBER ADD CONSTRAINT IDX_GROUP_MEMBER_PK PRIMARY KEY (GROUP_NAME, USER_NAME); +ALTER TABLE GROUP_MEMBER ADD CONSTRAINT IDX_GROUP_MEMBER_FK0 FOREIGN KEY (GROUP_NAME) REFERENCES ACCOUNT (USER_NAME); +ALTER TABLE GROUP_MEMBER ADD CONSTRAINT IDX_GROUP_MEMBER_FK1 FOREIGN KEY (USER_NAME) REFERENCES ACCOUNT (USER_NAME); + +ALTER TABLE ACCOUNT ADD COLUMN GROUP_ACCOUNT BOOLEAN NOT NULL DEFAULT FALSE; diff --git a/src/main/scala/servlet/AutoUpdateListener.scala b/src/main/scala/servlet/AutoUpdateListener.scala index 4614230..601af9b 100644 --- a/src/main/scala/servlet/AutoUpdateListener.scala +++ b/src/main/scala/servlet/AutoUpdateListener.scala @@ -49,6 +49,7 @@ * The history of versions. A head of this sequence is the current BitBucket version. */ val versions = Seq( + Version(1, 4), new Version(1, 3){ override def update(conn: Connection): Unit = { super.update(conn) @@ -128,6 +129,7 @@ } catch { case ex: Throwable => { logger.error("Failed to schema update", ex) + ex.printStackTrace() conn.rollback() } }