doortts
commented
10 years ago 이론상(?) mysql 등의 DB에서 사용가능합니다만 테스트 해 본적은 아직 없습니다.
주석만 풀어서는 안되고 의존 라이브러리도 추가되어야 합니다. 진행방법은 아래 링크에 나와있습니다. http://www.playframework.com/documentation/2.1.1/JavaDatabase
Closed jkoh11 closed 10 years ago
doortts
commented
10 years ago 이론상(?) mysql 등의 DB에서 사용가능합니다만 테스트 해 본적은 아직 없습니다.
주석만 풀어서는 안되고 의존 라이브러리도 추가되어야 합니다. 진행방법은 아래 링크에 나와있습니다. http://www.playframework.com/documentation/2.1.1/JavaDatabase
jkoh11
commented
10 years ago 네 답변 감사합니다 의존 라이브러리 도 추가하였는데요
기존에 file db로 사용을 한뒤 mysql로 db를 변경 할 수 있나요?
doortts
commented
10 years ago DB스크립트로 dump를 떠써 mysql에서 실행해 주어야 합니다.
play framework 2.1.0 기준으로 프로젝트 home 에서 아래 명령어를 실행해 주세요. (프로젝트 home에는 nforge.h2.db 파일이 존재 합니다)
\ 주의! 단 embedded mode로 사용하고 있을때는 애플리케이션이 떠 있으면 접근이 불가능합니다 **
java -cp PLAY2설치경로/repository/local/com.h2database/h2/1.3.168/jars/h2.jar org.h2.tools.Script -url jdbc:h2:file:nforge -user ""java -cp PLAY2설치경로/repository/local/com.h2database/h2/1.3.168/jars/h2.jar org.h2.tools.Backup -url jdbc:h2:file:nforge -user ""java -cp PLAY2설치경로/repository/local/com.h2database/h2/1.3.168/jars/h2.jar org.h2.tools.Shell -url jdbc:h2:file:nforge -user ""java -cp PLAY2설치경로/play2/repository/local/com.h2database/h2/1.3.168/jars/h2.jar org.h2.tools.ConsoleDB스크립트로 dump를 뜨는거 까진 되었는데요 mysql에 넣어서 스크립트를 돌리니까 에러가 뜨는데요.. dump후에 한번더 가공을 해줘야 하는건지요??
doortts
commented
10 years ago 에러 메시지를 알 수 있을까요?
jkoh11
commented
10 years ago 쿼리 첨부해서 보내드릴게요 아래 쿼리가 덤프한 쿼리고요 회사라서..보안때문에 파일첨부가 안되서.. 메일로 보내드려요.. 에러메세지는 sql오류 (1064):you have an error in your SQL syntax; check the manual that corresponds to your MYSQL server version for the right syntax to use near 'IF NOT EXISTS "" SALT " HASH " ADMIN' at line 1 CREATE USER IF NOT EXISTS "" SALT '' HASH '' ADMIN; CREATE SEQUENCE PUBLIC.UNWATCH_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.NOTIFICATION_EVENT_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.N4USER_SEQ START WITH 33; CREATE SEQUENCE PUBLIC.SITE_ADMIN_SEQ START WITH 33; CREATE SEQUENCE PUBLIC.PROJECT_USER_SEQ START WITH 33; CREATE SEQUENCE PUBLIC.ISSUE_LABEL_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.USER_PROJECT_NOTIFICATION_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.ITEM_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.PULL_REQUEST_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.ROLE_SEQ START WITH 33; CREATE SEQUENCE PUBLIC.PROJECT_PUSHED_BRANCH_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.PULL_REQUEST_COMMENT_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.EMAIL_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.WATCH_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.MILESTONE_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.CODE_COMMENT_SEQ START WITH 33; CREATE SEQUENCE PUBLIC.ISSUE_COMMENT_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.POSTING_SEQ START WITH 0; CREATE SEQUENCE PUBLIC.LABEL_SEQ START WITH 155; CREATE SEQUENCE PUBLIC.PROJECT_SEQ START WITH 33; CREATE SEQUENCE PUBLIC.COMMIT_COMMENT_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.ASSIGNEE_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.PULL_REQUEST_EVENT_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.LINE_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.NOTIFICATION_MAIL_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.PULL_REQUEST_COMMIT_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.ISSUE_EVENT_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.ATTACHMENT_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.ISSUE_SEQ START WITH 1; CREATE SEQUENCE PUBLIC.POSTING_COMMENT_SEQ START WITH 0; CREATE CACHED TABLE PUBLIC.PLAY_EVOLUTIONS( ID INT NOT NULL, HASH VARCHAR(255) NOT NULL, APPLIED_AT TIMESTAMP NOT NULL, APPLY_SCRIPT TEXT, REVERT_SCRIPT TEXT, STATE VARCHAR(255), LAST_PROBLEM TEXT ); ALTER TABLE PUBLIC.PLAY_EVOLUTIONS ADD CONSTRAINT PUBLIC.CONSTRAINT_9 PRIMARY KEY(ID); -- 61 +/- SELECT COUNT(*) FROM PUBLIC.PLAY_EVOLUTIONS; CREATE TABLE IF NOT EXISTS SYSTEM_LOB_STREAM(ID INT NOT NULL, PART INT NOT NULL, CDATA VARCHAR, BDATA BINARY); CREATE PRIMARY KEY SYSTEM_LOB_STREAM_PRIMARY_KEY ON SYSTEM_LOB_STREAM(ID, PART); CREATE ALIAS IF NOT EXISTS SYSTEM_COMBINE_CLOB FOR "org.h2.command.dml.ScriptCommand.combineClob"; CREATE ALIAS IF NOT EXISTS SYSTEM_COMBINE_BLOB FOR "org.h2.command.dml.ScriptCommand.combineBlob"; INSERT INTO SYSTEM_LOB_STREAM VALUES(0, 0, STRINGDECODE('create table assignee (\nid bigint not null,\nuser_id bigint,\nproject_id bigint,\nconstraint pk_assignee primary key (id))\n;\n\ncreate table attachment (\nid bigint not null,\nname varchar(255),\nhash varchar(255),\nproject_id bigint,\ncontainer_type varchar(15),\nmime_type varchar(255),\nsize bigint,\ncontainer_id bigint,\nconstraint ck_attachment_container_type check (container_type in (''ISSUE_POST'',''ISSUE_COMMENT'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_NOTICE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_COMMENT'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'')),\nconstraint pk_attachment primary key (id))\n;\n\ncreate table card (\nid bigint not null,\ntitle varchar(255),\nchecklist_id bigint,\nline_id bigint,\nstory_point integer,\nbody varchar(255),\ndue_date timestamp,\nconstraint pk_card primary key (id))\n;\n\ncreate table card_assignee (\nid bigint not null,\ncard_id bigint,\nproject_user_id bigint,\nconstraint pk_card_assignee primary key (id))\n;\n\ncreate table card_label (\nid bigint not null,\ncard_id bigint,\nlabel_id bigint,\nconstraint pk_card_label primary key (id))\n;\n\ncreate table checklist (\nid bigint not null,\ntitle varchar(255),\nconstraint pk_checklist primary key (id))\n;\n\ncreate table comment (\nid bigint not null,\ncontents varchar(4000),\ndate timestamp,\nfile_path varchar(255),\nauthor_id bigint,\nauthor_login_id varchar(255),\nauthor_name varchar(255),\npost_id bigint,\nconstraint pk_comment primary key (id))\n;\n\ncreate table issue (\nid bigint not null,\ntitle varchar(255),\nbody clob,\ndate timestamp,\nnum_of_comments integer,\nmilestone_id bigint,\nauthor_id bigint,\nauthor_login_id varchar(255),\nauthor_name varchar(255),\nstate integer,\nproject_id bigint,\nassignee_id bigint,\nconstraint ck_issue_state check (state in (0,1,2)),\nconstraint pk_issue primary key (id))\n;\n\ncreate table issue_comment (\nid bigint not null,\ncontents varchar(4000),\ndate timestamp,\nauthor_id bigint,\nauthor_login_id varchar(255),\nauthor_name varchar(255),\nfile_path varchar(255),\nissue_id bigint,\nconstraint pk_issue_comment primary key (id))\n;\n\ncreate table issue_label (\nid bigint not null,\ncategory varchar(255),\ncolor varchar(255),\nname varchar(255),\nproject_id bigint,\nconstraint pk_issue_label primary key (id))\n;\n\ncreate table item (\nid bigint not null,\nstate boolean,\nbody varchar(255),\nchecklist_id bigint,\nconstraint pk_item primary key (id))\n;\n\ncreate table label (\nid bigint not null,\nname varchar(255),\ncolor varchar(255),\ntask_board_id bigint,\nconstraint pk_label primary key (id))\n;\n\ncreate table line (\nid bigint not null,\ntitle varchar(255),\ntask_board_id bigint,\nconstraint pk_line primary key (id))\n;\n\ncreate table milestone (\nid bigint not null,\ntitle varchar(255),\ndue_date time'), NULL); INSERT INTO SYSTEM_LOB_STREAM VALUES(0, 1, STRINGDECODE('stamp,\ncontents clob,\nstate integer,\nproject_id bigint,\nconstraint ck_milestone_state check (state in (0,1,2)),\nconstraint pk_milestone primary key (id))\n;\n\ncreate table post (\nid bigint not null,\ntitle varchar(255),\ncontents clob,\ndate timestamp,\ncomment_count integer,\nfile_path varchar(255),\nauthor_id bigint,\nauthor_login_id varchar(255),\nauthor_name varchar(255),\nproject_id bigint,\nconstraint pk_post primary key (id))\n;\n\ncreate table project (\nid bigint not null,\nname varchar(255),\noverview varchar(255),\nvcs varchar(255),\nsiteurl varchar(255),\nlogo_path varchar(255),\nowner varchar(255),\nshare_option boolean,\nis_author_editable boolean,\ndate timestamp,\nconstraint pk_project primary key (id))\n;\n\ncreate table project_user (\nid bigint not null,\nuser_id bigint,\nproject_id bigint,\nrole_id bigint,\nconstraint pk_project_user primary key (id))\n;\n\ncreate table role (\nid bigint not null,\nname varchar(255),\nactive boolean,\nconstraint pk_role primary key (id))\n;\n\ncreate table site_admin (\nid bigint not null,\nadmin_id bigint,\nconstraint pk_site_admin primary key (id))\n;\n\ncreate table task_board (\nid bigint not null,\nproject_id bigint,\nconstraint pk_task_board primary key (id))\n;\n\ncreate table task_comment (\nid bigint not null,\nbody varchar(255),\ncard_id bigint,\nconstraint pk_task_comment primary key (id))\n;\n\ncreate table n4user (\nid bigint not null,\nname varchar(255),\nlogin_id varchar(255),\npassword varchar(255),\npassword_salt varchar(255),\nemail varchar(255),\navatar_url varchar(255),\nremember_me boolean,\ndate timestamp,\nconstraint pk_n4user primary key (id))\n;\n\n\ncreate table issue_issue_label (\nissue_id bigint not null,\nissue_label_id bigint not null,\nconstraint pk_issue_issue_label primary key (issue_id, issue_label_id))\n;\ncreate sequence assignee_seq;\n\ncreate sequence attachment_seq;\n\ncreate sequence card_seq;\n\ncreate sequence card_assignee_seq;\n\ncreate sequence card_label_seq;\n\ncreate sequence checklist_seq;\n\ncreate sequence comment_seq;\n\ncreate sequence issue_seq;\n\ncreate sequence issue_comment_seq;\n\ncreate sequence issue_label_seq;\n\ncreate sequence item_seq;\n\ncreate sequence label_seq;\n\ncreate sequence line_seq;\n\ncreate sequence milestone_seq;\n\ncreate sequence post_seq;\n\ncreate sequence project_seq;\n\ncreate sequence project_user_seq;\n\ncreate sequence role_seq;\n\ncreate sequence site_admin_seq;\n\ncreate sequence task_board_seq;\n\ncreate sequence task_comment_seq;\n\ncreate sequence n4user_seq;\n\nalter table assignee add constraint fk_assignee_user_1 foreign key (user_id) references n4user (id) on delete restrict on update restrict;\ncreate index ix_assignee_user_1 on assignee (user_id);\nalter table assignee add constraint fk_assignee_project_2 foreign key (project_id) references project (id) on delete restrict on update restrict;\ncreate index ix_assignee_project_2 on assignee (project_id);\nalter table card add constraint fk_card_checklist_3 foreign key (checklist_id) references checklist (id) on delete restrict on update restrict;\ncreate index ix_card_checklist_3 on card (checklist_id);\nalter table card add constraint fk_card_line_4 foreign key (line_id) references line (id) on delete restrict on update restrict;\ncreate index ix_card_line_4 on card (line_id);\nalter table card_assig'), NULL); INSERT INTO SYSTEM_LOB_STREAM VALUES(0, 2, STRINGDECODE('nee add constraint fk_card_assignee_card_5 foreign key (card_id) references card (id) on delete restrict on update restrict;\ncreate index ix_card_assignee_card_5 on card_assignee (card_id);\nalter table card_assignee add constraint fk_card_assignee_projectUser_6 foreign key (project_user_id) references project_user (id) on delete restrict on update restrict;\ncreate index ix_card_assignee_projectUser_6 on card_assignee (project_user_id);\nalter table card_label add constraint fk_card_label_card_7 foreign key (card_id) references card (id) on delete restrict on update restrict;\ncreate index ix_card_label_card_7 on card_label (card_id);\nalter table card_label add constraint fk_card_label_label_8 foreign key (label_id) references label (id) on delete restrict on update restrict;\ncreate index ix_card_label_label_8 on card_label (label_id);\nalter table comment add constraint fk_comment_post_9 foreign key (post_id) references post (id) on delete restrict on update restrict;\ncreate index ix_comment_post_9 on comment (post_id);\nalter table issue add constraint fk_issue_project_10 foreign key (project_id) references project (id) on delete restrict on update restrict;\ncreate index ix_issue_project_10 on issue (project_id);\nalter table issue add constraint fk_issue_assignee_11 foreign key (assignee_id) references assignee (id) on delete restrict on update restrict;\ncreate index ix_issue_assignee_11 on issue (assignee_id);\nalter table issue_comment add constraint fk_issue_comment_issue_12 foreign key (issue_id) references issue (id) on delete restrict on update restrict;\ncreate index ix_issue_comment_issue_12 on issue_comment (issue_id);\nalter table issue_label add constraint fk_issue_label_project_13 foreign key (project_id) references project (id) on delete restrict on update restrict;\ncreate index ix_issue_label_project_13 on issue_label (project_id);\nalter table item add constraint fk_item_checklist_14 foreign key (checklist_id) references checklist (id) on delete restrict on update restrict;\ncreate index ix_item_checklist_14 on item (checklist_id);\nalter table label add constraint fk_label_taskBoard_15 foreign key (task_board_id) references task_board (id) on delete restrict on update restrict;\ncreate index ix_label_taskBoard_15 on label (task_board_id);\nalter table line add constraint fk_line_taskBoard_16 foreign key (task_board_id) references task_board (id) on delete restrict on update restrict;\ncreate index ix_line_taskBoard_16 on line (task_board_id);\nalter table milestone add constraint fk_milestone_project_17 foreign key (project_id) references project (id) on delete restrict on update restrict;\ncreate index ix_milestone_project_17 on milestone (project_id);\nalter table post add constraint fk_post_project_18 foreign key (project_id) references project (id) on delete restrict on update restrict;\ncreate index ix_post_project_18 on post (project_id);\nalter table project_user add constraint fk_project_user_user_19 foreign key (user_id) references n4user (id) on delete restrict on update restrict;\ncreate index ix_project_user_user_19 on project_user (user_id);\nalter table project_user add constraint fk_project_user_project_20 foreign key (project_id) references project (id) on delete restrict on update restrict;\ncreate index ix_project_user_project_20 on project_user (project_id);\nalter table project_user add constraint fk_project_user_role_21 foreign key (role_id) references role (id) on delete restrict on update restrict;\ncreate index ix_project_user_role_21 on project_user (role_id);\nalter table site_admin add constraint fk_site_admin_admin_22 foreign key (admin_id) references n4user (id) on delete restrict on update restrict;\ncreate index ix_site_admin_admin_22 on site_admin (admin_id);\nalter table task_board add constraint fk_task_board_project_23 foreign key (project_id) references project (id) on delete restrict on update restrict;\ncreate index ix_task_board_project_23 on task_board (project_id);\nalter table task_comment add constraint fk_task_comment_card_24 foreign key (card_id) references card (id) on delete restrict o'), NULL); INSERT INTO SYSTEM_LOB_STREAM VALUES(0, 3, STRINGDECODE('n update restrict;\ncreate index ix_task_comment_card_24 on task_comment (card_id);\n\n\n\nalter table issue_issue_label add constraint fk_issue_issue_label_issue_01 foreign key (issue_id) references issue (id) on delete restrict on update restrict;\n\nalter table issue_issue_label add constraint fk_issue_issue_label_issue_la_02 foreign key (issue_label_id) references issue_label (id) on delete restrict on update restrict;'), NULL); INSERT INTO PUBLIC.PLAY_EVOLUTIONS(ID, HASH, APPLIED_AT, APPLY_SCRIPT, REVERT_SCRIPT, STATE, LAST_PROBLEM) VALUES (1, '5eb7f489ebb636db7b934d26137d70aaf046e381', TIMESTAMP '2014-02-21 00:00:00.0', SYSTEM_COMBINE_CLOB(0), STRINGDECODE('SET REFERENTIAL_INTEGRITY FALSE;\n\ndrop table if exists assignee;\n\ndrop table if exists attachment;\n\ndrop table if exists card;\n\ndrop table if exists card_assignee;\n\ndrop table if exists card_label;\n\ndrop table if exists checklist;\n\ndrop table if exists comment;\n\ndrop table if exists issue;\n\ndrop table if exists issue_issue_label;\n\ndrop table if exists issue_comment;\n\ndrop table if exists issue_label;\n\ndrop table if exists item;\n\ndrop table if exists label;\n\ndrop table if exists line;\n\ndrop table if exists milestone;\n\ndrop table if exists post;\n\ndrop table if exists project;\n\ndrop table if exists project_user;\n\ndrop table if exists role;\n\ndrop table if exists site_admin;\n\ndrop table if exists task_board;\n\ndrop table if exists task_comment;\n\ndrop table if exists n4user;\n\nSET REFERENTIAL_INTEGRITY TRUE;\n\ndrop sequence if exists assignee_seq;\n\ndrop sequence if exists attachment_seq;\n\ndrop sequence if exists card_seq;\n\ndrop sequence if exists card_assignee_seq;\n\ndrop sequence if exists card_label_seq;\n\ndrop sequence if exists checklist_seq;\n\ndrop sequence if exists comment_seq;\n\ndrop sequence if exists issue_seq;\n\ndrop sequence if exists issue_comment_seq;\n\ndrop sequence if exists issue_label_seq;\n\ndrop sequence if exists item_seq;\n\ndrop sequence if exists label_seq;\n\ndrop sequence if exists line_seq;\n\ndrop sequence if exists milestone_seq;\n\ndrop sequence if exists post_seq;\n\ndrop sequence if exists project_seq;\n\ndrop sequence if exists project_user_seq;\n\ndrop sequence if exists role_seq;\n\ndrop sequence if exists site_admin_seq;\n\ndrop sequence if exists task_board_seq;\n\ndrop sequence if exists task_comment_seq;\n\ndrop sequence if exists n4user_seq;'), 'applied', ''), (2, '1316c85df067cd5677deea34931e571b2f9d5e92', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE attachment ALTER container_type TYPE varchar(16);\nALTER TABLE attachment DROP CONSTRAINT ck_attachment_container_type;\nALTER TABLE attachment ADD CONSTRAINT ck_attachment_container_type check (container_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT''));\n\nALTER TABLE comment DROP file_path;\nALTER TABLE comment DROP CONSTRAINT pk_comment;\nALTER TABLE comment ADD CONSTRAINT pk_posting_comment primary key (id);\nALTER TABLE comment ALTER COLUMN post_id RENAME TO posting_id;\nALTER TABLE comment RENAME TO posting_comment;\n\nALTER TABLE issue_comment DROP file_path;\n\nALTER TABLE post DROP file_path;\nALTER TABLE post ALTER COLUMN contents RENAME TO body;\nALTER TABLE post ALTER COLUMN comment_count RENAME TO num_of_comments;\nALTER TABLE post DROP CONSTRAINT pk_post;\nALTER TABLE post ADD CONSTRAINT pk_posting primary key (id);\nALTER TABLE post RENAME TO posting;\n\nCREATE SEQUENCE posting_seq START WITH post_seq.currval;\nDROP SEQUENCE IF EXISTS post_seq;\n\nCREATE SEQUENCE posting_comment_seq START WITH comment_seq.currval;\nDROP SEQUENCE IF EXISTS comment_seq;'), STRINGDECODE('ALTER TABLE attachment ALTER container_type TYPE varchar(15);\nALTER TABLE attachment DROP CONSTRAINT ck_attachment_container_type;\nALTER TABLE attachment ADD CONSTRAINT ck_attachment_container_type check (container_type in (''ISSUE_POST'';''ISSUE_COMMENT'';''ISSUE_ASSIGNEE'';''ISSUE_STATE'';''ISSUE_CATEGORY'';''ISSUE_MILESTONE'';''ISSUE_NOTICE'';''ISSUE_LABEL'';''BOARD_POST'';''BOARD_COMMENT'';''BOARD_CATEGORY'';''BOARD_NOTICE'';''CODE'';''MILESTONE'';''WIKI_PAGE'';''PROJECT_SETTING'';''SITE_SETTING'';''USER'';''USER_AVATAR'';''PROJECT'';''ATTACHMENT''));\n\nALTER TABLE posting_comment ADD file_path;\nALTER TABLE posting_comment DROP CONSTRAINT pk_posting_comment;\nALTER TABLE posting_comment ADD CONSTRAINT pk_comment primary key (id);\nALTER TABLE posting_comment RENAME TO comment;\n\nALTER TABLE issue_comment ADD file_path;\n\nALTER TABLE posting ALTER COLUMN body RENAME TO contents;\nALTER TABLE posting ALTER COLUMN num_of_comments RENAME TO comment_count;\nALTER TABLE posting DROP CONSTRAINT pk_posting;\nALTER TABLE posting ADD CONSTRAINT pk_post primary key (id));\nALTER TABLE posting RENAME TO post;\n\nCREATE SEQUENCE post_seq START WITH posting_seq.currval;\nDROP SEQUENCE IF EXISTS posting_seq;\n\nCREATE SEQUENCE comment_seq START WITH posting_comment_seq.currval;\nDROP SEQUENCE IF EXISTS posting_comment_seq;'), 'applied', ''); INSERT INTO PUBLIC.PLAY_EVOLUTIONS(ID, HASH, APPLIED_AT, APPLY_SCRIPT, REVERT_SCRIPT, STATE, LAST_PROBLEM) VALUES (3, '968d72047c0f17671a288094e2029160fab4cc12', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE issue ALTER COLUMN date RENAME TO created_date;\nALTER TABLE issue_comment ALTER COLUMN date RENAME TO created_date;\nALTER TABLE posting ALTER COLUMN date RENAME TO created_date;\nALTER TABLE posting_comment ALTER COLUMN date RENAME TO created_date;\nALTER TABLE project ALTER COLUMN date RENAME TO created_date;\nALTER TABLE n4user ALTER COLUMN date RENAME TO created_date;'), STRINGDECODE('ALTER TABLE issue ALTER COLUMN created_date RENAME TO date;\nALTER TABLE issue_comment ALTER COLUMN created_date RENAME TO date;\nALTER TABLE posting ALTER COLUMN created_date RENAME TO date;\nALTER TABLE posting_comment ALTER COLUMN created_date RENAME TO date;\nALTER TABLE project ALTER COLUMN created_date RENAME TO date;\nALTER TABLE n4user ALTER COLUMN created_date RENAME TO date;'), 'applied', ''), (4, 'e51405bb105a151c3afe6864c5042d340d413caa', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('DROP TABLE IF EXISTS task_board;\nDROP TABLE IF EXISTS task_comment;\nDROP TABLE IF EXISTS card;\nDROP TABLE IF EXISTS card_assignee;\nDROP TABLE IF EXISTS card_label;\nDROP TABLE IF EXISTS checklist;\n\nDROP SEQUENCE IF EXISTS task_board_seq;\nDROP SEQUENCE IF EXISTS task_comment_seq;\nDROP SEQUENCE IF EXISTS card_seq;\nDROP SEQUENCE IF EXISTS card_assignee_seq;\nDROP SEQUENCE IF EXISTS card_label_seq;\nDROP SEQUENCE IF EXISTS checklist_seq;'), STRINGDECODE('CREATE TABLE task_board (\nid BIGINT NOT NULL,\nproject_id BIGINT,\nCONSTRAINT pk_task_board PRIMARY KEY (id))\n;\n\nCREATE TABLE task_comment (\nid BIGINT NOT NULL,\nbody VARCHAR(255),\ncard_id BIGINT,\nCONSTRAINT pk_task_comment PRIMARY KEY (id))\n;\n\nCREATE TABLE task_board (\nid BIGINT NOT NULL,\nproject_id BIGINT,\nCONSTRAINT pk_task_board PRIMARY KEY (id))\n;\n\nCREATE TABLE task_comment (\nid BIGINT NOT NULL,\nbody VARCHAR(255),\ncard_id BIGINT,\nCONSTRAINT pk_task_comment PRIMARY KEY (id))\n;\n\nCREATE TABLE checklist (\nid BIGINT NOT NULL,\ntitle VARCHAR(255),\nCONSTRAINT pk_checklist PRIMARY KEY (id))\n;\n\nCREATE TABLE card_assignee (\nid BIGINT NOT NULL,\ncard_id BIGINT,\nproject_user_id BIGINT,\nCONSTRAINT pk_card_assignee PRIMARY KEY (id))\n;\n\nCREATE SEQUENCE IF NOT EXISTS task_board_seq;\nCREATE SEQUENCE IF NOT EXISTS task_comment_seq;\nCREATE SEQUENCE IF NOT EXISTS card_seq;\nCREATE SEQUENCE IF NOT EXISTS card_assignee_seq;\nCREATE SEQUENCE IF NOT EXISTS card_label_seq;\nCREATE SEQUENCE IF NOT EXISTS checklist_seq;'), 'applied', ''), (5, '5cf584847efb8f66b90ad41cfa62557a641a36d7', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE project ADD COLUMN last_issue_number BIGINT;\nALTER TABLE project ADD COLUMN last_posting_number BIGINT;\nALTER TABLE issue ADD COLUMN number BIGINT;\nALTER TABLE posting ADD COLUMN number BIGINT;\nALTER TABLE issue ADD CONSTRAINT uq_posting_1 UNIQUE (project_id,number);\nALTER TABLE posting ADD CONSTRAINT uq_issue_1 UNIQUE (project_id,number);'), STRINGDECODE('ALTER TABLE project DROP COLUMN last_issue_number;\nALTER TABLE project DROP COLUMN last_posting_number;\nALTER TABLE issue DROP COLUMN number;\nALTER TABLE posting DROP COLUMN number;\nALTER TABLE issue DROP CONSTRAINT uq_posting_1;\nALTER TABLE posting DROP CONSTRAINT uq_issue_1;'), 'applied', ''), (6, 'af45cef0f40704257884f02e7c5210210428652c', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('UPDATE project SET last_issue_number = 0 WHERE last_issue_number IS NULL;\nUPDATE project SET last_posting_number = 0 WHERE last_posting_number IS NULL;'), '', 'applied', ''), (7, '5340702e8a583ee7bcf003ef031d029d9500a3e4', TIMESTAMP '2014-02-21 00:00:00.0', 'ALTER TABLE milestone ADD CONSTRAINT uq_milestone_title UNIQUE (title, project_id);', 'ALTER TABLE milestone DROP CONSTRAINT uq_milestone_title;', 'applied', ''); INSERT INTO SYSTEM_LOB_STREAM VALUES(1, 0, STRINGDECODE('ALTER TABLE tag DROP COLUMN IF EXISTS category;\nALTER TABLE tag ADD COLUMN category VARCHAR(255);\nUPDATE tag SET category=''Tag'';\nALTER TABLE tag ALTER COLUMN category SET NOT NULL;\nALTER TABLE tag DROP CONSTRAINT IF EXISTS uq_tag_name;\nALTER TABLE tag DROP CONSTRAINT IF EXISTS uq_tag_category_name;\nALTER TABLE tag ADD CONSTRAINT uq_tag_category_name UNIQUE (category, name);\n\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''ALGOL 58'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''ALGOL 60'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''ALGOL 68'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''APL'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''ASP.NET'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''AWK'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''ActionScript'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Ada'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''AppleScript'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''AspectJ'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Assembly language'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''AutoLISP / Visual LISP'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''B'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''BASIC'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''BCPL'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''BREW'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Bash'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Batch (Windows/Dos)'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Bourne shell'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''C#'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''C'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''C++'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''COBOL'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Clipper'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Clojure'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''CobolScript'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''CoffeeScript'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''ColdFusion'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Common Lisp'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Component Pascal'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Curl'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''D'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Dart'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Delphi'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''ECMAScript'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Eiffel'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Emacs Lisp'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Erlang'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''F#'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''F'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tagseq''), ''Language'', ''Forth'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag'), NULL); INSERT INTO SYSTEM_LOB_STREAM VALUES(1, 1, STRINGDECODE('seq''), ''Language'', ''Fortran'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''FoxBase'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''FoxPro'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Go!'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Go'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Groovy'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Haskell'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Io'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''J'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''JScript'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Java'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''JavaFX Script'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''JavaScript'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''LaTeX'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Lisp'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Logo'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Lua'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''MATLAB'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''MDL'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''ML'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Machine code'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Mathematica'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Maya'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Microcode'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Microsoft Visual C++'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Modula'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Modula-2'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Modula-3'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''OCaml'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Object Lisp'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Object Pascal'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Objective-C'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Opa'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Orc'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PHP'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PL-11'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PL/0'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PL/B'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PL/C'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PL/I'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PL/M'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PL/P'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PL/SQL'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''POP-11'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Pascal'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Perl'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PostScript'');\nINSERT INT'), NULL); INSERT INTO SYSTEM_LOB_STREAM VALUES(1, 2, STRINGDECODE('O tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PowerBuilder'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''PowerShell'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Processing.js'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Prolog'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Python'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''QBasic'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''QuakeC'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''R'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''R++'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''REXX'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Ruby'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Rust'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Scala'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Scheme'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Script.NET'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Sed'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Self'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Simula'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Simulink'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Small Basic'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Smalltalk'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Snowball'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Squeak'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''TEX'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Tcl'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''TeX'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''UNITY'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Unix shell'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''UnrealScript'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''VBA'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''VBScript'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''VHDL'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Vala'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Verilog'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Visual Basic .NET'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Visual Basic'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Visual C#'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Visual DataFlex'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Visual DialogScript'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Visual Fortran'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Visual FoxPro'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Visual J#'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Visual J++'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Visual LISP'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''Visual Prolog'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq'), NULL); INSERT INTO SYSTEM_LOB_STREAM VALUES(1, 3, STRINGDECODE('''), ''Language'', ''Windows PowerShell'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''XQuery'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''XSLT'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''bc'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''csh'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''dBase'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''ksh'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''Language'', ''make'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''License'', ''Apache'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''License'', ''BSD'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''License'', ''EPL'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''License'', ''GPL'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''License'', ''ISC'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''License'', ''LGPL'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''License'', ''MIT'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''License'', ''MPL v1.1'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''License'', ''MPL v2.0'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''License'', ''Public Domain'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''OS'', ''Linux'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''OS'', ''OSX'');\nINSERT INTO tag (id, category, name) VALUES (nextval(''tag_seq''), ''OS'', ''Windows'');'), NULL); INSERT INTO PUBLIC.PLAY_EVOLUTIONS(ID, HASH, APPLIED_AT, APPLY_SCRIPT, REVERT_SCRIPT, STATE, LAST_PROBLEM) VALUES (8, '1ccef885f3be8e93641b0070f301c69129b24675', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('CREATE TABLE project_tag (\nproject_id BIGINT NOT NULL,\ntag_id BIGINT NOT NULL,\nCONSTRAINT pk_project_tag PRIMARY KEY (project_id, tag_id));\n\nCREATE TABLE tag (\nid BIGINT NOT NULL,\nname VARCHAR(255),\nCONSTRAINT uq_tag_name UNIQUE (NAME),\nCONSTRAINT pk_tag PRIMARY KEY (ID));\n\nCREATE SEQUENCE tag_seq;'), STRINGDECODE('DROP SEQUENCE IF EXISTS tag_seq;\nDROP TABLE IF EXISTS project_tag;\nDROP TABLE IF EXISTS tag;'), 'applied', ''), (9, '9cb8e91431e8848b15d4a69a58ec8ed5997a7463', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE posting ADD COLUMN notice BOOLEAN DEFAULT FALSE;\nUPDATE posting SET notice = FALSE WHERE notice IS NULL;'), 'ALTER TABLE posting DROP COLUMN notice;', 'applied', ''), (10, '63bf48dc3aada8502842fc0f30513905e32fd827', TIMESTAMP '2014-02-21 00:00:00.0', 'ALTER TABLE N4USER ADD COLUMN is_locked boolean default false;', 'ALTER TABLE N4USER DROP COLUMN is_locked;', 'applied', ''), (11, '250218cdb709efbc20721ab7f4de6a82193a9376', TIMESTAMP '2014-02-21 00:00:00.0', SYSTEM_COMBINE_CLOB(1), STRINGDECODE('ALTER TABLE tag DROP CONSTRAINT IF EXISTS uq_tag_name;\nUPDATE tag SET name=category || '' - '' || name WHERE category <> ''Tag'';\nDELETE FROM tag WHERE id NOT IN (SELECT min(id) FROM tag GROUP BY name);\nALTER TABLE tag DROP CONSTRAINT IF EXISTS uq_tag_category_name;\nALTER TABLE tag DROP COLUMN IF EXISTS category;\nALTER TABLE tag ADD CONSTRAINT uq_tag_name UNIQUE (name);'), 'applied', ''), (12, 'b316f0a3f8f5f0175d483101912e5f66eb67d438', TIMESTAMP '2014-02-21 00:00:00.0', 'ALTER TABLE project ALTER COLUMN share_option RENAME TO is_public;', 'ALTER TABLE project ALTER COLUMN is_public RENAME TO share_option;', 'applied', ''), (13, '3fabfcec9e222d1e6a59a70e70ce23ce0c299881', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE project ADD COLUMN original_project_id varchar(255);\n\ncreate table pull_request (\nid bigint not null,\ntitle varchar(255),\nbody clob,\nto_project_id bigint,\nfrom_project_id bigint,\nto_branch varchar(255),\nfrom_branch varchar(255),\ncontributor_id bigint,\nreceiver_id bigint,\ncreated timestamp,\nupdated timestamp,\nreceived timestamp,\nstate integer,\nconstraint pk_pull_request primary key (id));\n\ncreate sequence pull_request_seq;'), STRINGDECODE('DROP SEQUENCE IF EXISTS pull_request_seq;\n\nDROP TABLE IF EXISTS pull_request;\n\nALTER TABLE project DROP COLUMN original_project_id;'), 'applied', ''), (14, '827fd24ae0a3d42cdd3cc7de203a2437dc6f21e5', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE project ADD COLUMN watching_count BIGINT;\nUPDATE project SET watching_count = 0 WHERE watching_count IS NULL;\n\ncreate table user_watching_project (\nuser_id bigint not null,\nproject_id bigint not null,\nconstraint pk_user_watching_project primary key (user_id, project_id));'), STRINGDECODE('DROP TABLE IF EXISTS user_watching_project;\n\nALTER TABLE project DROP COLUMN watching_count;'), 'applied', ''), (15, '1aecc72cf831c26c14d8ada98509f8fdf25df5de', TIMESTAMP '2014-02-21 00:00:00.0', 'DROP TABLE IF EXISTS label;', STRINGDECODE('CREATE TABLE label (\nid bigint not null,\nname varchar(255),\ncolor varchar(255),\ntask_board_id bigint,\nconstraint pk_label primary key (id))\n;'), 'applied', ''), (16, 'a38d45833da004337e676e3349582367a7376a4c', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE tag DROP CONSTRAINT IF EXISTS uq_tag_category_name;\nALTER TABLE tag DROP CONSTRAINT IF EXISTS uq_label_category_name;\nALTER TABLE tag ADD CONSTRAINT uq_label_category_name UNIQUE (category, name);\nALTER TABLE tag DROP CONSTRAINT IF EXISTS pk_tag;\nALTER TABLE tag DROP CONSTRAINT IF EXISTS pk_label;\nALTER TABLE tag ADD CONSTRAINT pk_label PRIMARY KEY (ID);\nALTER TABLE tag RENAME TO label;\n\nALTER TABLE project_tag ALTER COLUMN tag_id RENAME TO label_id;\nALTER TABLE project_tag RENAME TO project_label;\n\nDROP SEQUENCE IF EXISTS label_seq;\nCREATE SEQUENCE label_seq START WITH tag_seq.nextval;\nDROP SEQUENCE IF EXISTS tag_seq;'), STRINGDECODE('ALTER TABLE label DROP CONSTRAINT IF EXISTS uq_label_category_name;\nALTER TABLE label DROP CONSTRAINT IF EXISTS uq_tag_category_name;\nALTER TABLE label ADD CONSTRAINT uq_tag_category_name UNIQUE (category, name);\nALTER TABLE label DROP CONSTRAINT IF EXISTS pk_label;\nALTER TABLE label DROP CONSTRAINT IF EXISTS pk_tag;\nALTER TABLE label ADD CONSTRAINT pk_tag PRIMARY KEY (ID);\nALTER TABLE label RENAME TO tag;\n\nALTER TABLE project_label ALTER COLUMN label_id RENAME TO tag_id;\nALTER TABLE project_label RENAME TO project_tag;\n\nDROP SEQUENCE IF EXISTS tag_seq;\nCREATE SEQUENCE tag_seq START WITH label_seq.nextval;\nDROP SEQUENCE IF EXISTS label_seq;'), 'applied', ''); INSERT INTO PUBLIC.PLAY_EVOLUTIONS(ID, HASH, APPLIED_AT, APPLY_SCRIPT, REVERT_SCRIPT, STATE, LAST_PROBLEM) VALUES (17, 'ba33c3a7a3e28ce252ba561c7676da7d420a7991', TIMESTAMP '2014-02-21 00:00:00.0', 'ALTER TABLE project ADD COLUMN last_pushed_date timestamp;', 'ALTER TABLE project DROP COLUMN last_pushed_date;', 'applied', ''), (18, '293e0dfe9dc510061c64e84bb615c3c5f301e3eb', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('CREATE TABLE ISSUE_EXPLICIT_WATCHER (\nissue_id bigint,\nn4user_id bigint,\n);\n\nCREATE TABLE ISSUE_EXPLICIT_UNWATCHER (\nissue_id bigint,\nn4user_id bigint,\n);\n\nCREATE TABLE POSTING_EXPLICIT_WATCHER (\nposting_id bigint,\nn4user_id bigint,\n);\n\nCREATE TABLE POSTING_EXPLICIT_UNWATCHER (\nposting_id bigint,\nn4user_id bigint,\n);'), STRINGDECODE('DROP TABLE IF EXISTS ISSUE_EXPLICIT_WATCHER;\nDROP TABLE IF EXISTS ISSUE_EXPLICIT_UNWATCHER;\nDROP TABLE IF EXISTS POSTING_EXPLICIT_WATCHER;\nDROP TABLE IF EXISTS POSTING_EXPLICIT_UNWATCHER;'), 'applied', ''), (19, '11e264a76f693ae1b2cee82bbea11e44632eb525', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('create table code_comment (\nid bigint not null,\nproject_id bigint,\ncommit_id varchar(255),\npath varchar(255),\nline bigint,\nside varchar(255),\ncontents varchar(4000),\ncreated_date timestamp,\nauthor_id bigint,\nauthor_login_id varchar(255),\nauthor_name varchar(255),\nconstraint pk_code_comment primary key (id))\n;\n\ncreate sequence code_comment_seq;\n\nalter table code_comment add constraint fk_code_comment_project_3 foreign key (project_id) references project (id) on delete restrict on update restrict;\n\ncreate index ix_code_comment_project_3 on code_comment (project_id);\n\nALTER TABLE attachment DROP CONSTRAINT IF EXISTS ck_attachment_container_type;\nALTER TABLE attachment ADD CONSTRAINT ck_attachment_container_type check (container_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT'',''CODE_COMMENT''));'), STRINGDECODE('drop table if exists code_comment;\ndrop sequence if exists code_comment_seq;\n\nDELETE FROM attachment WHERE container_type=''CODE_COMMENT'';\n\nALTER TABLE attachment DROP CONSTRAINT IF EXISTS ck_attachment_container_type;\nALTER TABLE attachment ADD CONSTRAINT ck_attachment_container_type check (container_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT''));'), 'applied', ''), (20, '171ffb984de467d263f4d52126b086059f4af088', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('CREATE TABLE simple_comment (\nid bigint not null,\ncontents varchar(4000),\ncreated_date timestamp,\nauthor_id bigint,\nauthor_login_id varchar(255),\nauthor_name varchar(255),\nresource_key varchar(255),\nconstraint pk_simple_comment primary key (id)\n);\n\nCREATE SEQUENCE simple_comment_seq;'), STRINGDECODE('DROP SEQUENCE IF EXISTS simple_comment_seq;\n\nDROP TABLE IF EXISTS simple_comment;'), 'applied', ''), (21, 'bf1d1c1fad8d7acdb75dceaecc91dbd0587b55e4', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('create table user_enrolled_project (\nuser_id bigint not null,\nproject_id bigint not null,\nconstraint pk_user_enrolled_project primary key (user_id, project_id));'), 'drop table if exists user_enrolled_project;', 'applied', ''); INSERT INTO PUBLIC.PLAY_EVOLUTIONS(ID, HASH, APPLIED_AT, APPLY_SCRIPT, REVERT_SCRIPT, STATE, LAST_PROBLEM) VALUES (22, 'c5c65900c659453ac1e949578bfe5b800ff0e52c', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('create table notification_event (\nid bigint not null,\ntitle varchar(255),\nmessage clob,\nsender_id bigint,\ncreated timestamp,\nurl_to_view varchar(255),\nresource_type varchar(16),\nresource_id bigint,\ntype varchar(255),\nold_value clob,\nnew_value clob,\nconstraint ck_notification_event_resource_type check (resource_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT'',''LABEL'',''PROJECT_LABELS'',''FORK'')),\nconstraint pk_notification_event primary key (id));\n\ncreate table notification_event_n4user (\nnotification_event_id bigint not null,\nn4user_id bigint not null,\nconstraint pk_notification_event_n4user primary key (notification_event_id, n4user_id));\n\ncreate table notification_mail (\nid bigint not null,\nnotification_event_id bigint,\nconstraint pk_notification_mail primary key (id))\n;\n\ncreate sequence notification_event_seq;\n\nalter table notification_event_n4user add constraint fk_notification_event_n4user01 foreign key (notification_event_id) references notification_event (id) on delete restrict on update restrict;\n\nalter table notification_event_n4user add constraint fk_notification_event_n4user02 foreign key (n4user_id) references n4user (id) on delete restrict on update restrict;\n\ncreate sequence notification_mail_seq;\n\nalter table notification_mail add constraint fk_notification_mail_notificat_9 foreign key (notification_event_id) references notification_event (id) on delete restrict on update restrict;\n\ncreate index ix_notification_mail_notificat_9 on notification_mail (notification_event_id);'), STRINGDECODE('drop table if exists notification_event;\n\ndrop table if exists notification_event_n4user;\n\ndrop sequence if exists notification_event_seq;\n\ndrop table if exists notification_mail;\n\ndrop sequence if exists notification_mail_seq;'), 'applied', ''), (23, 'c7a906cd199d52896cf51aa19dcff0e76ab17c4f', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('create table commit_explicit_watching (\nid bigint not null,\nproject_id bigint,\ncommit_id varchar(255),\nconstraint pk_commit_explicit_watching primary key (id))\n;\n\ncreate table commit_explicit_watcher (\ncommit_explicit_watching_id bigint not null,\nn4user_id bigint not null,\nconstraint pk_commit_explicit_watcher primary key (commit_explicit_watching_id, n4user_id))\n;\n\ncreate table commit_explicit_unwatcher (\ncommit_explicit_watching_id bigint not null,\nn4user_id bigint not null,\nconstraint pk_commit_explicit_unwatcher primary key (commit_explicit_watching_id, n4user_id))\n;\n\ncreate sequence commit_explicit_watching_seq;\n\nalter table commit_explicit_watching add constraint fk_commit_explicit_watching_pr_4 foreign key (project_id) references project (id) on delete restrict on update restrict;\n\ncreate index ix_commit_explicit_watching_pr_4 on commit_explicit_watching (project_id);\n\nalter table commit_explicit_watcher add constraint fk_commit_explicit_watcher_co_01 foreign key (commit_explicit_watching_id) references commit_explicit_watching (id) on delete restrict on update restrict;\n\nalter table commit_explicit_watcher add constraint fk_commit_explicit_watcher_n4_02 foreign key (n4user_id) references n4user (id) on delete restrict on update restrict;\n\nalter table commit_explicit_unwatcher add constraint fk_commit_explicit_unwatcher01 foreign key (commit_explicit_watching_id) references commit_explicit_watching (id) on delete restrict on update restrict;\n\nalter table commit_explicit_unwatcher add constraint fk_commit_explicit_unwatcher02 foreign key (n4user_id) references n4user (id) on delete restrict on update restrict;\n\nALTER TABLE notification_event DROP CONSTRAINT IF EXISTS ck_notification_event_resource_type;\n\nALTER TABLE notification_event ADD CONSTRAINT ck_notification_event_resource_type check (resource_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT'',''LABEL'',''PROJECT_LABELS'',''FORK'', ''CODE_COMMENT''));'), STRINGDECODE('drop table if exists commit_explicit_watching;\n\ndrop table if exists commit_explicit_watcher;\n\ndrop table if exists commit_explicit_unwatcher;\n\ndrop sequence if exists commit_explicit_watching_seq;\n\nALTER TABLE notification_event DROP CONSTRAINT IF EXISTS ck_notification_event_resource_type;\n\nALTER TABLE notification_event ADD CONSTRAINT ck_notification_event_resource_type check (resource_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT'',''LABEL'',''PROJECT_LABELS'',''FORK''));'), 'applied', ''); INSERT INTO PUBLIC.PLAY_EVOLUTIONS(ID, HASH, APPLIED_AT, APPLY_SCRIPT, REVERT_SCRIPT, STATE, LAST_PROBLEM) VALUES (24, '55cd6804a99fc93de32928f17403720d88b46828', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE attachment DROP CONSTRAINT IF EXISTS ck_attachment_container_type;\nALTER TABLE attachment ADD CONSTRAINT ck_attachment_container_type check (container_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT'',''CODE_COMMENT'', ''PULL_REQUEST''));'), STRINGDECODE('ALTER TABLE attachment DROP CONSTRAINT IF EXISTS ck_attachment_container_type;\nALTER TABLE attachment ADD CONSTRAINT ck_attachment_container_type check (container_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT'',''CODE_COMMENT''));'), 'applied', ''), (25, '6a618b6a30954627fb264ac3006e46682b13fa22', TIMESTAMP '2014-02-21 00:00:00.0', 'ALTER TABLE pull_request ADD COLUMN last_commit_id varchar(255);', 'ALTER TABLE pull_request DROP COLUMN last_commit_id;', 'applied', ''), (26, '07b8ae427333e42b74527cc5411b6ee541082860', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE pull_request ADD COLUMN merged_commit_id_from varchar(255);\nALTER TABLE pull_request ADD COLUMN merged_commit_id_to varchar(255);'), STRINGDECODE('ALTER TABLE pull_request DROP COLUMN merged_commit_id_from;\nALTER TABLE pull_request DROP COLUMN merged_commit_id_to;'), 'applied', ''), (27, 'c9d4f26d9e2e0c1c90b0d0349f280c857a2492ed', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('create table watch (\nid bigint not null,\nuser_id bigint,\nresource_type varchar(16),\nresource_id varchar(255),\nconstraint ck_watch_resource_type check (resource_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT'',''LABEL'',''PROJECT_LABELS'',''FORK'',''CODE_COMMENT'',''PULL_REQUEST'',''SIMPLE_COMMENT'', ''COMMIT'')),\nconstraint pk_watch primary key (id))\n;\n\ncreate table unwatch (\nid bigint not null,\nuser_id bigint,\nresource_type varchar(16),\nresource_id varchar(255),\nconstraint ck_unwatch_resource_type check (resource_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT'',''LABEL'',''PROJECT_LABELS'',''FORK'',''CODE_COMMENT'',''PULL_REQUEST'',''SIMPLE_COMMENT'', ''COMMIT'')),\nconstraint pk_unwatch primary key (id))\n;\n\ncreate sequence watch_seq;\n\ncreate sequence unwatch_seq;\n\nalter table unwatch add constraint fk_unwatch_unwatcher_23 foreign key (user_id) references n4user (id) on delete restrict on update restrict;\n\ncreate index ix_unwatch_unwatcher_23 on unwatch (user_id);\n\nalter table watch add constraint fk_watch_watcher_24 foreign key (user_id) references n4user (id) on delete restrict on update restrict;\n\ncreate index ix_watch_watcher_24 on watch (user_id);\n\ndrop table if exists user_watching_project;\n\ndrop table if exists commit_explicit_watching;\n\ndrop table if exists commit_explicit_watcher;\n\ndrop table if exists commit_explicit_unwatcher;\n\ndrop sequence if exists commit_explicit_watching_seq;\n\nALTER TABLE attachment ALTER COLUMN container_id TYPE varchar(255);'), STRINGDECODE('drop table if exists unwatch;\n\ndrop table if exists watch;\n\ndrop sequence if exists unwatch_seq;\n\ndrop sequence if exists watch_seq;\n\nALTER TABLE attachment ALTER COLUMN container_id TYPE bigint;'), 'applied', ''); INSERT INTO PUBLIC.PLAY_EVOLUTIONS(ID, HASH, APPLIED_AT, APPLY_SCRIPT, REVERT_SCRIPT, STATE, LAST_PROBLEM) VALUES (28, '18596d70ac7dbe3104286025a5fe4b41fc1c49d3', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE n4user ADD COLUMN state VARCHAR(15);\nALTER TABLE n4user ADD COLUMN last_state_modified_date TIMESTAMP;\nUPDATE n4user SET state=''LOCKED'' WHERE is_locked=true;\nUPDATE n4user SET state=''ACTIVE'' WHERE is_locked=false;\nALTER TABLE n4user DROP COLUMN is_locked;\nALTER TABLE n4user ADD CONSTRAINT ck_n4user_state check (state in (''ACTIVE'', ''LOCKED'', ''DELETED''));'), STRINGDECODE('ALTER TABLE n4user DROP CONSTRAINT IF EXISTS ck_n4user_state;\nALTER TABLE n4user ADD COLUMN is_locked BOOLEAN DEFAULT FALSE;\nUPDATE n4user SET is_locked=true WHERE state=''LOCKED'';\nUPDATE n4user SET is_locked=false WHERE state=''ACTIVE'';\nALTER TABLE n4user DROP COLUMN state;\nALTER TABLE n4user DROP COLUMN last_state_modified_date;'), 'applied', ''), (29, 'e223f24846e0caffbef3d04cdad0809ea19d04e7', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE notification_event DROP CONSTRAINT IF EXISTS ck_notification_event_resource_type;\nALTER TABLE notification_event ADD constraint ck_notification_event_resource_type check (resource_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT'',''LABEL'',''PROJECT_LABELS'',''FORK'',''CODE_COMMENT'',''PULL_REQUEST'',''SIMPLE_COMMENT''));'), STRINGDECODE('ALTER TABLE notification_event DROP CONSTRAINT IF EXISTS ck_notification_event_resource_type;\nALTER TABLE notification_event ADD CONSTRAINT ck_notification_event_resource_type check (resource_type in (''ISSUE_POST'',''ISSUE_ASSIGNEE'',''ISSUE_STATE'',''ISSUE_CATEGORY'',''ISSUE_MILESTONE'',''ISSUE_LABEL'',''BOARD_POST'',''BOARD_CATEGORY'',''BOARD_NOTICE'',''CODE'',''MILESTONE'',''WIKI_PAGE'',''PROJECT_SETTING'',''SITE_SETTING'',''USER'',''USER_AVATAR'',''PROJECT'',''ATTACHMENT'',''ISSUE_COMMENT'',''NONISSUE_COMMENT'',''LABEL'',''PROJECT_LABELS'',''FORK''));'), 'applied', ''), (30, '4b30ab96541772c8ae9ca83c474f071ff900b371', TIMESTAMP '2014-02-21 00:00:00.0', 'ALTER TABLE notification_event ALTER COLUMN type RENAME TO notification_type;', 'ALTER TABLE notification_event ALTER COLUMN notification_type RENAME TO type;', 'applied', ''), (31, 'ef6920f9b6e130f7e5b8fe951f838817a9ff54d1', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('ALTER TABLE pull_request ADD COLUMN number BIGINT;\nALTER TABLE pull_request ADD CONSTRAINT uq_pull_request_1 UNIQUE (to_project_id,number);'), STRINGDECODE('ALTER TABLE pull_request DROP CONSTRAINT uq_pull_request_1;\nALTER TABLE pull_request DROP COLUMN number;'), 'applied', ''), (32, '1cbfa6b102caf85472b1c3233e95ae66c89a8c3f', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('create table user_project_notification (\nid bigint not null,\nuser_id bigint,\nproject_id bigint,\nnotification_type varchar(255),\nallowed boolean,\n\nconstraint pk_user_project_notification primary key (id))\n;\n\ncreate sequence user_project_notification_seq;\n\nalter table user_project_notification add constraint fk_user_project_notification_user_25 foreign key (user_id) references n4user (id) on delete restrict on update restrict;\n\ncreate index ix_user_project_notification_user_25 on user_project_notification (user_id);\n\nalter table user_project_notification add constraint fk_user_project_notification_project_26 foreign key (project_id) references project (id) on delete restrict on update restrict;\n\ncreate index ix_user_project_notification_project_26 on user_project_notification (project_id);'), STRINGDECODE('drop table if exists user_project_notification;\n\ndrop sequence if exists user_project_notification_seq;'), 'applied', ''), (33, 'cf405823c7aea8f9d7ca445907907a6c88f31718', TIMESTAMP '2014-02-21 00:00:00.0', 'ALTER TABLE notification_event ALTER COLUMN notification_type RENAME TO event_type;', 'ALTER TABLE notification_event ALTER COLUMN event_type RENAME TO notification_type;', 'applied', ''); INSERT INTO PUBLIC.PLAY_EVOLUTIONS(ID, HASH, APPLIED_AT, APPLY_SCRIPT, REVERT_SCRIPT, STATE, LAST_PROBLEM) VALUES (34, '62618e032268168234534003471d021b123c3a5d', TIMESTAMP '2014-02-21 00:00:00.0', STRINGDECODE('create table issue_event (\nid bigint not null,\ncreated timestamp,\nsender_login_id varchar(255),\nissue_id bigint,\nevent_type varchar(26),\nold_value varchar(255),\nnew_value varchar(255),\nconstraint ck_issue_event_event_type check (event_type in (''NEW_ISSUE'',''NEW_POSTING'',''ISSUE_ASSIGNEE_CHANGED'',''ISSUE_STATE_CHANGED'',''NEW_COMMENT'',''NEW_PULL_REQUEST'',''NEW_SIMPLE_COMMENT'',''PULL_REQUEST_STATE_CHANGED'')),\nconstraint pk_issue_event
jkoh11
commented
10 years ago 쿼리가 길어서..메일로 보낸다고 보냈는데.. 메일로 보내도 여기에 써지는군요...
Q1) conf 파일에서 file db말고 mysql 관련 설정 주석을 풀고 사용을 한다면 mysql로 사용가능 한가요?
Q2) 기존에 file db로 사용을 한뒤 mysql로 db를 변경 할 수 있나요?
위에 두질문이 기존에 418이슈에 질문이였는데요.. conf파일에서 mysql설정 주석을 풀고 실행하였더니.. 역시나 실행이 안되더라고요.. 위에 이슈? 질문?에 대해서는 개선된 점이 있는지요..??