CREATE SCHEMA PUBLIC AUTHORIZATION DBA CREATE CACHED TABLE DELETED_BUILD_TYPES(BUILD_TYPE_ID VARCHAR(20) NOT NULL PRIMARY KEY,DELETE_TIME BIGINT) CREATE CACHED TABLE PROJECTS(PROJECT_ID VARCHAR(20) NOT NULL,BUILD_TYPE_ID VARCHAR(20) NOT NULL,PROJECT_NAME VARCHAR(1024),BUILD_TYPE_NAME VARCHAR(1024),PRIMARY KEY(PROJECT_ID,BUILD_TYPE_ID)) CREATE CACHED TABLE HISTORY(BUILD_ID BIGINT NOT NULL PRIMARY KEY,AGENT_NAME VARCHAR(80),BUILD_TYPE_ID VARCHAR(20),BUILD_START_TIME_SERVER BIGINT,BUILD_START_TIME_AGENT BIGINT,BUILD_FINISH_TIME_SERVER BIGINT,STATUS INTEGER,STATUS_TEXT VARCHAR(256),USER_STATUS_TEXT VARCHAR(256),PIN INTEGER,IS_PERSONAL INTEGER,IS_CANCELED INTEGER,BUILD_NUMBER VARCHAR(256),REQUESTOR VARCHAR(1024),QUEUED_TIME BIGINT,REMOVE_FROM_QUEUE_TIME BIGINT,BUILD_STATE_ID BIGINT) CREATE INDEX START_TIME_INDEX ON HISTORY(BUILD_START_TIME_SERVER) CREATE INDEX BUILD_TYPE_ID_INDEX ON HISTORY(BUILD_TYPE_ID) CREATE INDEX PINNED_INDEX ON HISTORY(PIN) CREATE INDEX STATUS_INDEX ON HISTORY(STATUS) CREATE INDEX HISTORY_STATE_ID ON HISTORY(BUILD_STATE_ID) CREATE CACHED TABLE LIGHT_HISTORY(BUILD_ID BIGINT NOT NULL PRIMARY KEY,AGENT_NAME VARCHAR(80),BUILD_TYPE_ID VARCHAR(20),BUILD_START_TIME_SERVER BIGINT,BUILD_START_TIME_AGENT BIGINT,BUILD_FINISH_TIME_SERVER BIGINT,STATUS INTEGER,STATUS_TEXT VARCHAR(256),USER_STATUS_TEXT VARCHAR(256),PIN INTEGER,IS_PERSONAL INTEGER,IS_CANCELED INTEGER,BUILD_NUMBER VARCHAR(256),REQUESTOR VARCHAR(1024),QUEUED_TIME BIGINT,REMOVE_FROM_QUEUE_TIME BIGINT,BUILD_STATE_ID BIGINT) CREATE INDEX START_TIME_INDEX_LIGHT ON LIGHT_HISTORY(BUILD_START_TIME_SERVER) CREATE INDEX BUILD_TYPE_ID_INDEX_LIGHT ON LIGHT_HISTORY(BUILD_TYPE_ID) CREATE INDEX PINNED_INDEX_LIGHT ON LIGHT_HISTORY(PIN) CREATE INDEX STATUS_INDEX_LIGHT ON LIGHT_HISTORY(STATUS) CREATE CACHED TABLE BUILD_DATA_STORAGE(BUILD_ID BIGINT NOT NULL,METRIC_ID BIGINT NOT NULL,METRIC_VALUE DECIMAL(19) NOT NULL,PRIMARY KEY(BUILD_ID,METRIC_ID)) CREATE CACHED TABLE CANCELED_INFO(BUILD_ID BIGINT NOT NULL PRIMARY KEY,USER_ID BIGINT,DESCRIPTION VARCHAR(256)) CREATE CACHED TABLE RUNNING(BUILD_ID BIGINT NOT NULL PRIMARY KEY,AGENT_ID BIGINT,BUILD_TYPE_ID VARCHAR(20),BUILD_START_TIME_AGENT BIGINT,BUILD_START_TIME_SERVER BIGINT,IS_PERSONAL INTEGER,BUILD_NUMBER VARCHAR(256),REQUESTOR VARCHAR(1024),ACCESS_CODE VARCHAR(60),QUEUED_AGENT_ID BIGINT,QUEUED_TIME BIGINT,REMOVE_FROM_QUEUE_TIME BIGINT,BUILD_STATE_ID BIGINT) CREATE INDEX RUNNING_STATE_ID ON RUNNING(BUILD_STATE_ID) CREATE CACHED TABLE BUILD_STATE(ID BIGINT NOT NULL PRIMARY KEY,BUILD_TYPE_ID VARCHAR(30),MODIFICATION_ID BIGINT,IS_PERSONAL INTEGER DEFAULT 0 NOT NULL,IS_CANCELED INTEGER DEFAULT 0 NOT NULL,BUILD_ID BIGINT) CREATE INDEX BUILD_STATE_MOD_ID ON BUILD_STATE(MODIFICATION_ID) CREATE INDEX BUILD_STATE_BUILD_TYPE_ID ON BUILD_STATE(BUILD_TYPE_ID) CREATE INDEX BUILD_STATE_BUILD_ID ON BUILD_STATE(BUILD_ID) CREATE CACHED TABLE BUILD_DEPENDENCY(BUILD_STATE_ID BIGINT,DEPENDS_ON BIGINT,DEPENDENCY_OPTIONS INTEGER,CONSTRAINT SYS_CT_63 UNIQUE(BUILD_STATE_ID,DEPENDS_ON)) CREATE CACHED TABLE AGENT_SOURCES_VERSION(BUILD_TYPE_ID VARCHAR(20) NOT NULL,VCS_ROOT_ID INTEGER NOT NULL,AGENT_ID INTEGER NOT NULL,VCS_SETTINGS_HASH VARCHAR(16) NOT NULL,CHECKOUT_DIR VARCHAR(2048),CURRENT_VERSION VARCHAR(80),PRIMARY KEY(BUILD_TYPE_ID,VCS_SETTINGS_HASH,VCS_ROOT_ID,AGENT_ID)) CREATE CACHED TABLE AGENT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80) NOT NULL,HOST_ADDR VARCHAR(80) NOT NULL,PORT INTEGER NOT NULL,STATUS INTEGER,AUTHORIZED INTEGER,STATUS_COMMENT_ID BIGINT,AUTHORIZED_COMMENT_ID BIGINT,REGISTERED INTEGER,REGISTRATION_TIMESTAMP BIGINT,LAST_BINDING_TIMESTAMP BIGINT,UNREGISTERED_REASON VARCHAR(256),AUTHORIZATION_TOKEN VARCHAR(32),STATUS_TO_RESTORE INTEGER,STATUS_RESTORING_TIMESTAMP BIGINT,CONSTRAINT SYS_CT_68 UNIQUE(NAME)) CREATE INDEX AGENT_AUTHORIZATION_TOKEN ON AGENT(AUTHORIZATION_TOKEN) CREATE INDEX AGENT_HOST_ADDRESS ON AGENT(HOST_ADDR) CREATE INDEX AGENT_STATUS_COMMENT_ID ON AGENT(STATUS_COMMENT_ID) CREATE INDEX AGENT_AUTHORIZED_COMMENT_ID ON AGENT(AUTHORIZED_COMMENT_ID) CREATE CACHED TABLE AGENT_BUILD_TYPE_ACCESS(AGENT_ID INTEGER NOT NULL,BUILD_TYPE_ID VARCHAR(20) NOT NULL,CONSTRAINT SYS_CT_72 UNIQUE(AGENT_ID,BUILD_TYPE_ID)) CREATE INDEX AGENT_BT_ACCESS_AGENT_ID ON AGENT_BUILD_TYPE_ACCESS(AGENT_ID) CREATE INDEX AGENT_BT_ACCESS_BT_ID ON AGENT_BUILD_TYPE_ACCESS(BUILD_TYPE_ID) CREATE CACHED TABLE RUN_CONFIGURATION_POLICY(AGENT_ID INTEGER NOT NULL PRIMARY KEY,POLICY INTEGER NOT NULL) CREATE CACHED TABLE VCS_HISTORY(MODIFICATION_ID BIGINT NOT NULL PRIMARY KEY,USER_NAME VARCHAR(255),DESCRIPTION VARCHAR(4000),CHANGE_DATE BIGINT,VCS_ROOT_ID INTEGER,VCS_ROOT_VERSION INTEGER,CHANGES_COUNT INTEGER,VERSION VARCHAR(2048),DISPLAY_VERSION VARCHAR(2048)) CREATE INDEX VCS_HISTORY_ROOT ON VCS_HISTORY(VCS_ROOT_ID) CREATE INDEX VCS_HISTORY_USER ON VCS_HISTORY(USER_NAME) CREATE CACHED TABLE BUILD_TYPE_VCS_CHANGE(MODIFICATION_ID BIGINT NOT NULL,BUILD_TYPE_ID VARCHAR(20) NOT NULL,CONSTRAINT SYS_CT_79 UNIQUE(MODIFICATION_ID,BUILD_TYPE_ID)) CREATE CACHED TABLE BUILD_CHECKOUT_RULES(BUILD_STATE_ID BIGINT NOT NULL,BUILD_TYPE_ID VARCHAR(20) NOT NULL,VCS_ROOT_ID INTEGER NOT NULL,CHECKOUT_RULES VARCHAR(2096),PRIMARY KEY(BUILD_STATE_ID,BUILD_TYPE_ID,VCS_ROOT_ID)) CREATE CACHED TABLE VCS_CHANGES(MODIFICATION_ID BIGINT,CHANGE_NAME VARCHAR(64),VCS_FILE_NAME VARCHAR(16000),RELATIVE_FILE_NAME VARCHAR(16000),CHANGE_TYPE INTEGER,BEFORE_REVISION VARCHAR(2048),AFTER_REVISION VARCHAR(2048)) CREATE INDEX VCS_CHANGES_INDEX ON VCS_CHANGES(MODIFICATION_ID) CREATE CACHED TABLE PERSONAL_VCS_CHANGES(MODIFICATION_ID BIGINT,CHANGE_NAME VARCHAR(64),VCS_FILE_NAME VARCHAR(16000),RELATIVE_FILE_NAME VARCHAR(16000),CHANGE_TYPE INTEGER,BEFORE_REVISION VARCHAR(2048),AFTER_REVISION VARCHAR(2048)) CREATE INDEX VCS_PERSONAL_CHANGES_INDEX ON PERSONAL_VCS_CHANGES(MODIFICATION_ID) CREATE CACHED TABLE PERSONAL_VCS_HISTORY(MODIFICATION_ID BIGINT NOT NULL PRIMARY KEY,USER_ID BIGINT,DESCRIPTION VARCHAR(4096),CHANGE_DATE BIGINT,CHANGES_COUNT INTEGER,COMMIT_CHANGES INTEGER,SCHEDULED_FOR_DELETION INTEGER,STATUS INTEGER) CREATE CACHED TABLE TEST_INFO(BUILD_ID BIGINT NOT NULL,TEST_ID INTEGER NOT NULL,TEST_NAME_ID BIGINT,STATUS INTEGER,DURATION INTEGER DEFAULT 0 NOT NULL,CONSTRAINT TEST_INFO_PK PRIMARY KEY(BUILD_ID,TEST_ID)) CREATE INDEX TEST_NAME_ID_IDX ON TEST_INFO(TEST_NAME_ID) CREATE CACHED TABLE TEST_INFO_TRUNK(BUILD_ID BIGINT NOT NULL,TEST_ID INTEGER NOT NULL,TEST_NAME_ID BIGINT,STATUS INTEGER,DURATION INTEGER DEFAULT 0 NOT NULL,CONSTRAINT TEST_INFO_TRUNK_PK PRIMARY KEY(BUILD_ID,TEST_ID)) CREATE INDEX TIT_NAME_ID_IDX ON TEST_INFO_TRUNK(TEST_NAME_ID) CREATE CACHED TABLE TEST_NAMES(ID BIGINT DEFAULT NULL NOT NULL,TEST_NAME VARCHAR(255) NOT NULL,CONSTRAINT TEST_NAMES_PK PRIMARY KEY(ID)) CREATE CACHED TABLE TEST_FAILURE_RATE(BUILD_TYPE_ID VARCHAR(20) NOT NULL,AGENT_ID INTEGER NOT NULL,TEST_NAME_ID BIGINT NOT NULL,SUCCESS_COUNT INTEGER,FAILURE_COUNT INTEGER,LAST_FAILURE_TIME BIGINT,PRIMARY KEY(BUILD_TYPE_ID,AGENT_ID,TEST_NAME_ID)) CREATE CACHED TABLE PAUSED_BUILD_TYPES(BUILD_TYPE_ID VARCHAR(20) NOT NULL PRIMARY KEY,WHO_USER_ID INTEGER,COMMENTARY VARCHAR(256),WHEN_PAUSED BIGINT) CREATE CACHED TABLE BUILD_QUEUE(BUILD_TYPE_ID VARCHAR(30),AGENT_ID BIGINT,REQUESTOR VARCHAR(1024),WHEN_QUEUED BIGINT,POS INTEGER,BUILD_STATE_ID BIGINT) CREATE INDEX BUILD_QUEUE_BUILD_STATE_ID ON BUILD_QUEUE(BUILD_STATE_ID) CREATE CACHED TABLE REMOTE_RUN_BUILD_TYPES(SOURCE_TYPE_ID VARCHAR(20),INSTANCE_ID BIGINT,CHANGE_ID BIGINT,ID BIGINT NOT NULL PRIMARY KEY,USER_ID BIGINT) CREATE INDEX REMOTE_DATA_INSTANCE_ID ON REMOTE_RUN_BUILD_TYPES(INSTANCE_ID) CREATE INDEX REMOTE_DATA_INSTANCE_USER_ID ON REMOTE_RUN_BUILD_TYPES(USER_ID) CREATE INDEX REMOTE_DATA_INSTANCE_CHANGE_ID ON REMOTE_RUN_BUILD_TYPES(CHANGE_ID) CREATE INDEX REMOTE_DATA_INSTANCE_BT_ID ON REMOTE_RUN_BUILD_TYPES(SOURCE_TYPE_ID) CREATE CACHED TABLE STATS(BUILD_ID BIGINT NOT NULL PRIMARY KEY,STATUS INTEGER,TEST_COUNT INTEGER,SIGNATURE INTEGER,STATUS_TEXT VARCHAR(256)) CREATE CACHED TABLE TC_BUILD_TAGS(TAG VARCHAR(255),BUILD_ID BIGINT) CREATE INDEX TC_TAGS_ID_INDEX ON TC_BUILD_TAGS(BUILD_ID) CREATE INDEX TC_TAGS_ID_TAG ON TC_BUILD_TAGS(TAG) CREATE CACHED TABLE FAILED_TESTS_OUTPUT(BUILD_ID BIGINT NOT NULL,TEST_ID INTEGER NOT NULL,PROBLEM_DESCRIPTION VARCHAR(256),STD_OUTPUT VARCHAR(40960),ERROR_OUTPUT VARCHAR(40960),STACKTRACE VARCHAR(40960),EXPECTED VARCHAR(40960),ACTUAL VARCHAR(40960),CONSTRAINT FTO_PK PRIMARY KEY(BUILD_ID,TEST_ID)) CREATE CACHED TABLE COMPILER_OUTPUT(BUILD_ID BIGINT,MESSAGE_ORDER INTEGER,MESSAGE VARCHAR(40960)) CREATE INDEX CO_BUILD_ID_INDEX ON COMPILER_OUTPUT(BUILD_ID) CREATE CACHED TABLE IGNORED_TESTS(BUILD_ID BIGINT,TEST_ID INTEGER,TEST_NAME VARCHAR(255),REASON VARCHAR(40960)) CREATE INDEX IGNORED_TESTS_BUILD_ID ON IGNORED_TESTS(BUILD_ID) CREATE CACHED TABLE DOWNLOADED_ARTIFACTS(TARGET_BUILD_ID BIGINT,SOURCE_BUILD_ID BIGINT,ARTIFACT_PATH VARCHAR(8192),DOWNLOAD_TIMESTAMP BIGINT) CREATE INDEX DOWNLOADED_ARTIFACTS_TARGET_ID ON DOWNLOADED_ARTIFACTS(TARGET_BUILD_ID) CREATE INDEX DOWNLOADED_ARTIFACTS_SOURCE_ID ON DOWNLOADED_ARTIFACTS(SOURCE_BUILD_ID) CREATE CACHED TABLE USERS(ID BIGINT NOT NULL PRIMARY KEY,AUTH_TYPE VARCHAR(80) NOT NULL,REALM VARCHAR(60),USERNAME VARCHAR(60) NOT NULL,NAME VARCHAR(256),EMAIL VARCHAR(256),LAST_LOGIN_TIMESTAMP BIGINT,PASSWORD VARCHAR(128),CONSTRAINT SYS_CT_105 UNIQUE(AUTH_TYPE,REALM,USERNAME)) CREATE CACHED TABLE USER_PROPERTY(USER_ID BIGINT NOT NULL,KEY1 VARCHAR(80) NOT NULL,VALUE VARCHAR(2048),CONSTRAINT SYS_CT_109 UNIQUE(USER_ID,KEY1)) CREATE CACHED TABLE USER_BLOCKS(USER_ID BIGINT NOT NULL,BLOCK_TYPE VARCHAR(80) NOT NULL,STATE VARCHAR(2048),CONSTRAINT SYS_CT_112 UNIQUE(USER_ID,BLOCK_TYPE)) CREATE CACHED TABLE USER_PROJECTS_VISIBILITY(USER_ID BIGINT NOT NULL,PROJECT_ID VARCHAR(80) NOT NULL,VISIBLE INTEGER NOT NULL,CONSTRAINT SYS_CT_115 UNIQUE(USER_ID,PROJECT_ID)) CREATE CACHED TABLE USER_PROJECTS_ORDER(USER_ID BIGINT NOT NULL,PROJECT_ID VARCHAR(80) NOT NULL,ORDERNUM INTEGER,CONSTRAINT SYS_CT_118 UNIQUE(USER_ID,PROJECT_ID)) CREATE CACHED TABLE USER_NOTIFICATION_EVENTS(ID BIGINT NOT NULL PRIMARY KEY,USER_ID BIGINT NOT NULL,NOTIFICATOR_TYPE VARCHAR(20) NOT NULL,EVENTS_MASK INTEGER NOT NULL) CREATE INDEX NOTIFICATION_EVENTS_NOTIFIER ON USER_NOTIFICATION_EVENTS(NOTIFICATOR_TYPE) CREATE INDEX NOTIFICATION_EVENTS_USER_ID ON USER_NOTIFICATION_EVENTS(USER_ID) CREATE CACHED TABLE USER_WATCH_TYPE(RULE_ID BIGINT NOT NULL,USER_ID BIGINT NOT NULL,NOTIFICATOR_TYPE VARCHAR(20) NOT NULL,WATCH_TYPE INTEGER NOT NULL,WATCH_VALUE VARCHAR(80) NOT NULL,ORDER_NUM BIGINT,CONSTRAINT SYS_CT_123 UNIQUE(USER_ID,NOTIFICATOR_TYPE,WATCH_TYPE,WATCH_VALUE)) CREATE INDEX WATCH_TYPE_RULE_ID ON USER_WATCH_TYPE(RULE_ID) CREATE CACHED TABLE USER_ROLES(USER_ID BIGINT NOT NULL,ROLE_ID VARCHAR(80) NOT NULL,PROJECT_ID VARCHAR(80),CONSTRAINT SYS_CT_126 UNIQUE(USER_ID,ROLE_ID,PROJECT_ID)) CREATE CACHED TABLE USERGROUPS(GROUP_ID VARCHAR(16) NOT NULL PRIMARY KEY,NAME VARCHAR(255) NOT NULL,DESCRIPTION VARCHAR(2000),CONSTRAINT SYS_CT_129 UNIQUE(NAME)) CREATE CACHED TABLE USERGROUP_USERS(GROUP_ID VARCHAR(16) NOT NULL,USER_ID BIGINT NOT NULL,CONSTRAINT SYS_CT_133 UNIQUE(GROUP_ID,USER_ID)) CREATE CACHED TABLE USERGROUP_SUBGROUPS(HOSTGROUP_ID VARCHAR(16) NOT NULL,SUBGROUP_ID VARCHAR(16) NOT NULL,CONSTRAINT SYS_CT_136 UNIQUE(HOSTGROUP_ID,SUBGROUP_ID)) CREATE CACHED TABLE USERGROUP_ROLES(GROUP_ID VARCHAR(16) NOT NULL,ROLE_ID VARCHAR(80) NOT NULL,PROJECT_ID VARCHAR(80),CONSTRAINT SYS_CT_139 UNIQUE(GROUP_ID,ROLE_ID,PROJECT_ID)) CREATE CACHED TABLE USERGROUP_NOTIFICATION_EVENTS(ID BIGINT NOT NULL PRIMARY KEY,GROUP_ID VARCHAR(16) NOT NULL,NOTIFICATOR_TYPE VARCHAR(20) NOT NULL,EVENTS_MASK INTEGER NOT NULL) CREATE INDEX USERGROUP_EVENTS_NOTIFIER ON USERGROUP_NOTIFICATION_EVENTS(NOTIFICATOR_TYPE) CREATE INDEX USERGROUP_EVENTS_GROUP_ID ON USERGROUP_NOTIFICATION_EVENTS(GROUP_ID) CREATE CACHED TABLE USERGROUP_WATCH_TYPE(RULE_ID BIGINT NOT NULL,GROUP_ID VARCHAR(16) NOT NULL,NOTIFICATOR_TYPE VARCHAR(20) NOT NULL,WATCH_TYPE INTEGER NOT NULL,WATCH_VALUE VARCHAR(80) NOT NULL,ORDER_NUM BIGINT,CONSTRAINT SYS_CT_144 UNIQUE(GROUP_ID,NOTIFICATOR_TYPE,WATCH_TYPE,WATCH_VALUE)) CREATE INDEX GROUP_WATCH_TYPE_RULE_ID ON USERGROUP_WATCH_TYPE(RULE_ID) CREATE CACHED TABLE SERVER_PROPERTY(PROP_NAME VARCHAR(80) NOT NULL,PROP_VALUE VARCHAR(256) NOT NULL,CONSTRAINT SYS_CT_147 UNIQUE(PROP_NAME)) CREATE CACHED TABLE BUILD_REVISIONS(BUILD_STATE_ID BIGINT,VCS_ROOT_ID BIGINT,VCS_ROOT_VERSION BIGINT,VCS_REVISION VARCHAR(80),VCS_REVISION_DISPLAY_NAME VARCHAR(80)) CREATE INDEX BUILD_REVISIONS_BUILD ON BUILD_REVISIONS(BUILD_STATE_ID) CREATE INDEX BUILD_REVISIONS_VCS_ROOT ON BUILD_REVISIONS(VCS_ROOT_ID) CREATE INDEX BUILD_REVISIONS_VCS_ROOT_VER ON BUILD_REVISIONS(VCS_ROOT_VERSION) CREATE CACHED TABLE USER_BUILD_PARAMETERS(BUILD_STATE_ID BIGINT,PARAM_NAME VARCHAR(2000),PARAM_VALUE VARCHAR(16000)) CREATE INDEX USER_BUILD_PARAMS_STATE_ID ON USER_BUILD_PARAMETERS(BUILD_STATE_ID) CREATE CACHED TABLE DEFAULT_BUILD_PARAMETERS(BUILD_STATE_ID BIGINT,PARAM_NAME VARCHAR(2000),PARAM_VALUE VARCHAR(16000)) CREATE INDEX DEF_BUILD_PARAMS_STATE_ID ON DEFAULT_BUILD_PARAMETERS(BUILD_STATE_ID) CREATE CACHED TABLE BUILD_LABELS(BUILD_ID BIGINT,VCS_ROOT_ID BIGINT,VCS_ROOT_VERSION BIGINT,LABEL VARCHAR(80),STATUS INTEGER DEFAULT 0,ERROR_MESSAGE VARCHAR(256)) CREATE INDEX BUILD_LABELS_BUILD ON BUILD_LABELS(BUILD_ID) CREATE INDEX BUILD_LABELS_VCS_ROOT ON BUILD_LABELS(VCS_ROOT_ID) CREATE CACHED TABLE PERSONAL_BUILD_RELATIVE_PATH(BUILD_ID BIGINT,ORIGINAL_PATH_HASH BIGINT,RELATIVE_PATH VARCHAR(16000),CONSTRAINT SYS_CT_154 UNIQUE(BUILD_ID,ORIGINAL_PATH_HASH)) CREATE CACHED TABLE ACTION_HISTORY(OBJECT_ID VARCHAR(20),COMMENT_ID BIGINT,ACTION INTEGER) CREATE INDEX ACTION_HISTORY_OBJECT ON ACTION_HISTORY(OBJECT_ID) CREATE INDEX ACTION_HISTORY_COMMENT ON ACTION_HISTORY(COMMENT_ID) CREATE INDEX ACTION_HISTORY_ACTION ON ACTION_HISTORY(ACTION) CREATE CACHED TABLE REMEMBER_ME(USER_KEY VARCHAR(65) NOT NULL,SECURE BIGINT NOT NULL) CREATE CACHED TABLE VCS_ROOT_VERSIONS(ID INTEGER NOT NULL,VERSION INTEGER NOT NULL,BODY VARCHAR(16384),PRIMARY KEY(ID,VERSION)) CREATE CACHED TABLE COMMENTS(ID BIGINT NOT NULL PRIMARY KEY,AUTHOR_ID BIGINT,WHEN_CHANGED BIGINT NOT NULL,COMMENTARY VARCHAR(4096)) CREATE CACHED TABLE BUILD_RUNTIME_INFO(BUILD_ID BIGINT NOT NULL,RKEY VARCHAR(64) NOT NULL,VALUE VARCHAR(4000),PRIMARY KEY(BUILD_ID,RKEY)) CREATE CACHED TABLE SERVER(SERVER_ID VARCHAR(80),BUILD_ID BIGINT) CREATE CACHED TABLE STATS_PUBLISHER_STATE(METRIC_ID BIGINT NOT NULL PRIMARY KEY,VALUE BIGINT NOT NULL) CREATE CACHED TABLE DUPLICATE_RESULTS(ID BIGINT NOT NULL PRIMARY KEY,BUILD_ID BIGINT,HASH INTEGER,COST INTEGER) CREATE INDEX DUPLICATE_RESULTS_BUILD_ID ON DUPLICATE_RESULTS(BUILD_ID) CREATE CACHED TABLE DUPLICATE_FRAGMENTS(ID BIGINT,FILE_ID BIGINT,START_OFFSET INTEGER,END_OFFSET INTEGER,LINE INTEGER) CREATE INDEX DUPLICATE_FRAGMENTS_INDEX ON DUPLICATE_FRAGMENTS(ID) CREATE INDEX DUPLICATE_FRAGMENTS_FILE_INDEX ON DUPLICATE_FRAGMENTS(FILE_ID) CREATE CACHED TABLE FRAGMENTS(HASH INTEGER,FILE_ID BIGINT,BUILD_TYPE_ID VARCHAR(20)) CREATE INDEX DUPLICATE_RESULTS_FILE_INDEX ON FRAGMENTS(FILE_ID) CREATE INDEX FRAGMENTS_HASH_INDEX ON FRAGMENTS(HASH) CREATE CACHED TABLE PROJECT_FILES(FILE_ID BIGINT NOT NULL PRIMARY KEY,FILE_NAME VARCHAR(255)) CREATE INDEX PROJECT_FILES_FILE_NAME_INDEX ON PROJECT_FILES(FILE_NAME) CREATE CACHED TABLE DUPLICATE_DIFF(BUILD_ID BIGINT NOT NULL,HASH BIGINT NOT NULL,PRIMARY KEY(BUILD_ID,HASH)) CREATE CACHED TABLE DUPLICATE_STATS(BUILD_ID BIGINT NOT NULL PRIMARY KEY,TOTAL INTEGER,NEW_TOTAL INTEGER,OLD_TOTAL INTEGER) CREATE CACHED TABLE INSPECTION_RESULTS(BUILD_ID BIGINT,HASH BIGINT,LINE INTEGER) CREATE INDEX INSPECTION_RESULTS_HASH_INDEX ON INSPECTION_RESULTS(HASH) CREATE CACHED TABLE INSPECTION_DATA(HASH BIGINT NOT NULL PRIMARY KEY,RESULT VARCHAR(4000),SEVERITY INTEGER,TYPE_PATTERN INTEGER,FQNAME VARCHAR(2000),FILE_NAME VARCHAR(255),PARENT_FQNAMES VARCHAR(4000),PARENT_TYPE_PATTERNS VARCHAR(20),MODULE_NAME VARCHAR(40),INSPECTION_ID BIGINT,IS_LOCAL INTEGER) CREATE INDEX INSPECTION_DATA_FILE_INDEX ON INSPECTION_DATA(FILE_NAME) CREATE INDEX INSPECTION_DATA_INSP_INDEX ON INSPECTION_DATA(INSPECTION_ID) CREATE CACHED TABLE INSPECTION_STATS(BUILD_ID BIGINT NOT NULL PRIMARY KEY,TOTAL INTEGER,NEW_TOTAL INTEGER,OLD_TOTAL INTEGER,ERRORS INTEGER,NEW_ERRORS INTEGER,OLD_ERRORS INTEGER) CREATE CACHED TABLE INSPECTION_INFO(ID BIGINT NOT NULL PRIMARY KEY,INSPECTION_ID VARCHAR(255),INSPECTION_NAME VARCHAR(255),INSPECTION_DESC VARCHAR(4000),GROUP_NAME VARCHAR(255)) CREATE CACHED TABLE INSPECTION_FIXES(HASH BIGINT,HINT VARCHAR(255)) CREATE INDEX INSPECTION_FIXES_HASH_INDEX ON INSPECTION_FIXES(HASH) CREATE CACHED TABLE INSPECTION_DIFF(BUILD_ID BIGINT NOT NULL,HASH BIGINT NOT NULL) CREATE INDEX INSPECTION_DIFF_HASH_INDEX ON INSPECTION_DIFF(HASH) SET TABLE DELETED_BUILD_TYPES INDEX'4 0' SET TABLE PROJECTS INDEX'35 0' SET TABLE HISTORY INDEX'4429 4429 1102 4429 325 4429 0' SET TABLE BUILD_DATA_STORAGE INDEX'10454 0' SET TABLE CANCELED_INFO INDEX'12962 0' SET TABLE BUILD_STATE INDEX'14885 14375 13445 14885 0' SET TABLE AGENT_SOURCES_VERSION INDEX'16130 0' SET TABLE AGENT INDEX'16154 16154 16154 16154 16154 16154 0' SET TABLE VCS_HISTORY INDEX'16742 16742 17120 0' SET TABLE BUILD_TYPE_VCS_CHANGE INDEX'18513 18107 0' SET TABLE BUILD_CHECKOUT_RULES INDEX'20255 0' SET TABLE VCS_CHANGES INDEX'28448 28032 0' SET TABLE TEST_INFO INDEX'109913 36194 0' SET TABLE TEST_NAMES INDEX'197874 0' SET TABLE TEST_FAILURE_RATE INDEX'203787 0' SET TABLE STATS INDEX'205607 0' SET TABLE COMPILER_OUTPUT INDEX'220498 217068 0' SET TABLE IGNORED_TESTS INDEX'232188 232188 0' SET TABLE USERS INDEX'232272 232272 0' SET TABLE USER_PROPERTY INDEX'232506 232563 0' SET TABLE USER_BLOCKS INDEX'232814 232766 0' SET TABLE USER_NOTIFICATION_EVENTS INDEX'232951 232951 232951 0' SET TABLE USER_WATCH_TYPE INDEX'232975 232975 232975 0' SET TABLE USER_ROLES INDEX'233015 233015 0' SET TABLE USERGROUPS INDEX'233039 233039 0' SET TABLE USERGROUP_USERS INDEX'233061 233061 0' SET TABLE USERGROUP_ROLES INDEX'233088 233088 0' SET TABLE USERGROUP_NOTIFICATION_EVENTS INDEX'233098 233098 233098 0' SET TABLE USERGROUP_WATCH_TYPE INDEX'233124 233124 233124 0' SET TABLE SERVER_PROPERTY INDEX'233161 233161 0' SET TABLE BUILD_REVISIONS INDEX'235340 233980 235085 234949 0' SET TABLE REMEMBER_ME INDEX'236791 0' SET TABLE VCS_ROOT_VERSIONS INDEX'236856 0' SET TABLE COMMENTS INDEX'237000 0' SET TABLE SERVER INDEX'237019 0' SET TABLE STATS_PUBLISHER_STATE INDEX'237040 0' SET TABLE INSPECTION_RESULTS INDEX'302603 237219 0' SET TABLE INSPECTION_DATA INDEX'396262 366522 366434 0' SET TABLE INSPECTION_STATS INDEX'449249 0' SET TABLE INSPECTION_INFO INDEX'451040 0' SET TABLE INSPECTION_DIFF INDEX'456331 452817 0' CREATE USER SA PASSWORD "" GRANT DBA TO SA SET WRITE_DELAY 10