Create a Test Database - rsanchez-wsu/fa15-ceg3120 GitHub Wiki

1. Make sure you have derby installed though Eclipse.
2. Go to the database development perspective in Eclipse
3. In the Database Source Explorer, right click Database Connections and select New...
4. Select Derby from the list that appears and name it ConConDB.
5. On the next Specify a Driver and Connection Details click the New Drivers Definition button next to the disabled Drivers dropdown list.
6. Pick Derby Embedded JDBC version 10.2
7. Go to the JAR List tab.
8. Remove the derby.jar and click Add JAR/Zip...
9. Navigate to the project and select the derby jar in modules/customer_client/lib
10. Create database and test connection.
11. It should now be listed in your Data Source Explorer> Database Connections.
12. Right-click the ConConDB and select open SQL scrapbook
13. At the top of the new panel select your MyDB from the Database: dropdown.
14. Paste this into your scrapbook:

---

` --

DROP IF EXISTS INDEX SYSDEPENDS_INDEX2;

DROP IF EXISTS INDEX SYSCOLUMNS_INDEX1;

DROP IF EXISTS INDEX SYSSTATEMENTS_INDEX2;

DROP IF EXISTS INDEX SYSCONSTRAINTS_INDEX1;

DROP IF EXISTS INDEX SYSTABLEPERMS_INDEX2;

DROP IF EXISTS INDEX SYSFILES_INDEX2;

DROP IF EXISTS INDEX SYSSCHEMAS_INDEX2;

DROP IF EXISTS INDEX SYSSTATEMENTS_INDEX1;

DROP IF EXISTS INDEX SYSCHECKS_INDEX1;

DROP IF EXISTS INDEX SYSCONGLOMERATES_INDEX3;

DROP IF EXISTS INDEX SYSCONGLOMERATES_INDEX1;

DROP IF EXISTS INDEX SYSVIEWS_INDEX1;

DROP IF EXISTS INDEX SYSPERMS_INDEX1;

DROP IF EXISTS INDEX SYSROLES_INDEX2;

DROP IF EXISTS INDEX SYSTRIGGERS_INDEX3;

DROP IF EXISTS INDEX SYSCOLUMNS_INDEX2;

DROP IF EXISTS INDEX SYSFOREIGNKEYS_INDEX1;

DROP IF EXISTS INDEX SYSTABLEPERMS_INDEX3;

DROP IF EXISTS INDEX SYSPERMS_INDEX2;

DROP IF EXISTS INDEX SYSDEPENDS_INDEX1;

DROP IF EXISTS INDEX SYSTABLEPERMS_INDEX1;

DROP IF EXISTS INDEX SYSCONGLOMERATES_INDEX2;

DROP IF EXISTS INDEX SYSTRIGGERS_INDEX1;

DROP IF EXISTS INDEX SYSKEYS_INDEX1;

DROP IF EXISTS INDEX SYSCONSTRAINTS_INDEX2;

DROP IF EXISTS INDEX SYSSCHEMAS_INDEX1;

DROP IF EXISTS INDEX SYSALIASES_INDEX2;

DROP IF EXISTS INDEX SYSCOLPERMS_INDEX1;

DROP IF EXISTS INDEX SYSUSERS_INDEX1;

DROP IF EXISTS INDEX SYSROUTINEPERMS_INDEX1;

DROP IF EXISTS INDEX SYSSEQUENCES_INDEX2;

DROP IF EXISTS INDEX SYSROUTINEPERMS_INDEX3;

DROP IF EXISTS INDEX SYSROUTINEPERMS_INDEX2;

DROP IF EXISTS INDEX SYSSEQUENCES_INDEX1;

DROP IF EXISTS INDEX SYSCOLPERMS_INDEX2;

DROP IF EXISTS INDEX SYSTABLES_INDEX1;

DROP IF EXISTS INDEX SYSALIASES_INDEX1;

DROP IF EXISTS INDEX SYSALIASES_INDEX3;

DROP IF EXISTS INDEX SYSPERMS_INDEX3;

DROP IF EXISTS INDEX SYSCONSTRAINTS_INDEX3;

DROP IF EXISTS INDEX SYSFILES_INDEX1;

DROP IF EXISTS INDEX SYSTABLES_INDEX2;

DROP IF EXISTS INDEX SYSFOREIGNKEYS_INDEX2;

DROP IF EXISTS INDEX SYSTRIGGERS_INDEX2;

DROP IF EXISTS INDEX SYSROLES_INDEX3;

DROP IF EXISTS INDEX SYSCOLPERMS_INDEX3;

DROP IF EXISTS INDEX SYSROLES_INDEX1;

DROP IF EXISTS INDEX SYSSTATISTICS_INDEX1;

DROP IF EXISTS TABLE SYSDEPENDS;

DROP IF EXISTS TABLE SYSSTATISTICS;

DROP IF EXISTS TABLE OPEN_JOBS;

DROP IF EXISTS TABLE SYSCONSTRAINTS;

DROP IF EXISTS TABLE REVIEWS;

DROP IF EXISTS TABLE REFUNDS;

DROP IF EXISTS TABLE SYSSCHEMAS;

DROP IF EXISTS TABLE SYSROLES;

DROP IF EXISTS TABLE SYSCOLUMNS;

DROP IF EXISTS TABLE SYSSTATEMENTS;

DROP IF EXISTS TABLE CONTRACTOR_REVIEWS;

DROP IF EXISTS TABLE PAYMENT_ACCOUNTS;

DROP IF EXISTS TABLE SYSCHECKS;

DROP IF EXISTS TABLE PLACED_BIDS;

DROP IF EXISTS TABLE SYSVIEWS;

DROP IF EXISTS TABLE SYSTRIGGERS;

DROP IF EXISTS TABLE FINISHED_PLANS;

DROP IF EXISTS TABLE TEST;

DROP IF EXISTS TABLE SYSCONGLOMERATES;

DROP IF EXISTS TABLE COMPLETED_BIDS;

DROP IF EXISTS TABLE SYSTABLES;

DROP IF EXISTS TABLE OPEN_BIDS;

DROP IF EXISTS TABLE HOMEOWNER_PAYMENT_ACCOUNTS;

DROP IF EXISTS TABLE FINISHED_REFUND_PLANS;

DROP IF EXISTS TABLE REFUND_PLANS;

DROP IF EXISTS TABLE PLANS;

DROP IF EXISTS TABLE PAYMENTS;

DROP IF EXISTS TABLE SYSROUTINEPERMS;

DROP IF EXISTS TABLE JOB_REVIEWS;

DROP IF EXISTS TABLE ENDING_JOBS;

DROP IF EXISTS TABLE SYSDUMMY1;

DROP IF EXISTS TABLE FINISHED_PAYMENT_PLANS;

DROP IF EXISTS TABLE HOMEOWNER_REVIEWS;

DROP IF EXISTS TABLE SYSPERMS;

DROP IF EXISTS TABLE PAYMENT_PLANS;

DROP IF EXISTS TABLE SYSUSERS;

DROP IF EXISTS TABLE SYSSEQUENCES;

DROP IF EXISTS TABLE SERVER_ADMIN_ACCOUNTS;

DROP IF EXISTS TABLE HOMEOWNER_ACCOUNTS;

DROP IF EXISTS TABLE SYSTABLEPERMS;

DROP IF EXISTS TABLE SYSKEYS;

DROP IF EXISTS TABLE COMPLETED_JOBS;

DROP IF EXISTS TABLE BIDS;

DROP IF EXISTS TABLE SYSFILES;

DROP IF EXISTS TABLE CONTRACTOR_ACCOUNTS;

DROP IF EXISTS TABLE SYSCOLPERMS;

DROP IF EXISTS TABLE SYSALIASES;

DROP IF EXISTS TABLE PLANS_IN_PROGRESS;

DROP IF EXISTS TABLE SYSFOREIGNKEYS;

CREATE TABLE SYSDEPENDS ( DEPENDENTID CHAR(36) NOT NULL, DEPENDENTFINDER null NOT NULL, PROVIDERID CHAR(36) NOT NULL, PROVIDERFINDER null NOT NULL );

CREATE TABLE SYSSTATISTICS ( STATID CHAR(36) NOT NULL, REFERENCEID CHAR(36) NOT NULL, TABLEID CHAR(36) NOT NULL, CREATIONTIMESTAMP TIMESTAMP NOT NULL, TYPE CHAR(1) NOT NULL, VALID null NOT NULL, COLCOUNT INTEGER NOT NULL, STATISTICS null NOT NULL );

CREATE TABLE OPEN_JOBS ( UID INTEGER, HOMEOWNER_ID INTEGER, DATE_OPEN DATE );

CREATE TABLE SYSCONSTRAINTS ( CONSTRAINTID CHAR(36) NOT NULL, TABLEID CHAR(36) NOT NULL, CONSTRAINTNAME VARCHAR(128) NOT NULL, TYPE CHAR(1) NOT NULL, SCHEMAID CHAR(36) NOT NULL, STATE CHAR(1) NOT NULL, REFERENCECOUNT INTEGER NOT NULL );

CREATE TABLE REVIEWS ( UID INTEGER, POSTED_DATE DATE, REVIEW_TYPE VARCHAR(255), POSTER_ACCOUNT_TYPE VARCHAR(255), POSTED_ACCOUNT_TYPE VARCHAR(255), REVIEWER_ID INTEGER, REVIEWED_ID INTEGER );

CREATE TABLE REFUNDS ( UID INTEGER, JOB_ID INTEGER, HOMEOWNER_ID INTEGER, CONTRACTOR_ID INTEGER, TRANSACTION_TYPE VARCHAR(255), REFUND_AMOUNT DOUBLE, REFUND_DATE DATE );

CREATE TABLE SYSSCHEMAS ( SCHEMAID CHAR(36) NOT NULL, SCHEMANAME VARCHAR(128) NOT NULL, AUTHORIZATIONID VARCHAR(128) NOT NULL );

CREATE TABLE SYSROLES ( UUID CHAR(36) NOT NULL, ROLEID VARCHAR(128) NOT NULL, GRANTEE VARCHAR(128) NOT NULL, GRANTOR VARCHAR(128) NOT NULL, WITHADMINOPTION CHAR(1) NOT NULL, ISDEF CHAR(1) NOT NULL );

CREATE TABLE SYSCOLUMNS ( REFERENCEID CHAR(36) NOT NULL, COLUMNNAME VARCHAR(128) NOT NULL, COLUMNNUMBER INTEGER NOT NULL, COLUMNDATATYPE null NOT NULL, COLUMNDEFAULT null, COLUMNDEFAULTID CHAR(36), AUTOINCREMENTVALUE BIGINT, AUTOINCREMENTSTART BIGINT, AUTOINCREMENTINC BIGINT );

CREATE TABLE SYSSTATEMENTS ( STMTID CHAR(36) NOT NULL, STMTNAME VARCHAR(128) NOT NULL, SCHEMAID CHAR(36) NOT NULL, TYPE CHAR(1) NOT NULL, VALID null NOT NULL, TEXT LONG VARCHAR NOT NULL, LASTCOMPILED TIMESTAMP, COMPILATIONSCHEMAID CHAR(36), USINGTEXT LONG VARCHAR );

CREATE TABLE CONTRACTOR_REVIEWS ( UID INTEGER, POSTED_DATE DATE, REVIEWER_ID INTEGER, REVIEWED_ID INTEGER, NUM_HARD_HATS INTEGER, REVIEW_DESCRIPTION VARCHAR(255), REVIEW_POST VARCHAR(255) );

CREATE TABLE PAYMENT_ACCOUNTS ( UID INTEGER, USER_ID INTEGER, ACCOUNT_TYPE VARCHAR(255) );

CREATE TABLE SYSCHECKS ( CONSTRAINTID CHAR(36) NOT NULL, CHECKDEFINITION LONG VARCHAR NOT NULL, REFERENCEDCOLUMNS null NOT NULL );

CREATE TABLE PLACED_BIDS ( UID INTEGER, JOB_ID INTEGER, HOMEOWNER_ID INTEGER, CONTRACTOR_ID INTEGER, BID_AMOUNT DOUBLE, DATE_PLACED DATE );

CREATE TABLE SYSVIEWS ( TABLEID CHAR(36) NOT NULL, VIEWDEFINITION LONG VARCHAR NOT NULL, CHECKOPTION CHAR(1) NOT NULL, COMPILATIONSCHEMAID CHAR(36) );

CREATE TABLE SYSTRIGGERS ( TRIGGERID CHAR(36) NOT NULL, TRIGGERNAME VARCHAR(128) NOT NULL, SCHEMAID CHAR(36) NOT NULL, CREATIONTIMESTAMP TIMESTAMP NOT NULL, EVENT CHAR(1) NOT NULL, FIRINGTIME CHAR(1) NOT NULL, TYPE CHAR(1) NOT NULL, STATE CHAR(1) NOT NULL, TABLEID CHAR(36) NOT NULL, WHENSTMTID CHAR(36), ACTIONSTMTID CHAR(36), REFERENCEDCOLUMNS null, TRIGGERDEFINITION LONG VARCHAR, REFERENCINGOLD null, REFERENCINGNEW null, OLDREFERENCINGNAME VARCHAR(128), NEWREFERENCINGNAME VARCHAR(128), WHENCLAUSETEXT LONG VARCHAR );

CREATE TABLE FINISHED_PLANS ( UID INTEGER, JOB_ID INTEGER, PLAN_TYPE VARCHAR(255), START_DATE DATE, END_DATE DATE );

CREATE TABLE TEST ( UID INTEGER );

CREATE TABLE SYSCONGLOMERATES ( SCHEMAID CHAR(36) NOT NULL, TABLEID CHAR(36) NOT NULL, CONGLOMERATENUMBER BIGINT NOT NULL, CONGLOMERATENAME VARCHAR(128), ISINDEX null NOT NULL, DESCRIPTOR null, ISCONSTRAINT null, CONGLOMERATEID CHAR(36) NOT NULL );

CREATE TABLE COMPLETED_BIDS ( UID INTEGER, JOB_ID INTEGER, HOMEOWNER_ID INTEGER, HIGHEST_BIDDER_ID INTEGER, HIGHEST_BID_AMOUNT DOUBLE, DATE_OPEN DATE, DATE_CLOSE DATE );

CREATE TABLE SYSTABLES ( TABLEID CHAR(36) NOT NULL, TABLENAME VARCHAR(128) NOT NULL, TABLETYPE CHAR(1) NOT NULL, SCHEMAID CHAR(36) NOT NULL, LOCKGRANULARITY CHAR(1) NOT NULL );

CREATE TABLE OPEN_BIDS ( UID INTEGER, JOB_ID INTEGER, HOMEOWNER_ID INTEGER, HIGHEST_BIDDER_ID INTEGER, HIGHEST_BID_AMOUNT DOUBLE, DATE_OPEN DATE, DATE_CLOSE DATE );

CREATE TABLE HOMEOWNER_PAYMENT_ACCOUNTS ( UID INTEGER, HOMEOWNER_ID INTEGER, ACCOUNT_TYPE VARCHAR(255), ACCOUNT_AMOUNT DOUBLE );

CREATE TABLE FINISHED_REFUND_PLANS ( UID INTEGER, JOB_ID INTEGER, HOMEOWNER_ID INTEGER, CONTRACTOR_ID INTEGER, PLAN_TYPE VARCHAR(255), PAYMENTS_MADE INTEGER, TOTAL_AMOUNT_PAID DOUBLE, START_DATE DATE, END_DATE DATE );

CREATE TABLE REFUND_PLANS ( UID INTEGER, JOB_ID INTEGER, HOMEOWNER_ID INTEGER, CONTRACTOR_ID INTEGER, PLAN_TYPE VARCHAR(255), AMOUNT_DUE DOUBLE, PAYMENTS_SCHEDULED INTEGER, START_DATE DATE, END_DATE DATE );

CREATE TABLE PLANS ( UID INTEGER, JOB_ID INTEGER, PLAN_TYPE VARCHAR(255), START_DATE DATE, END_DATE DATE );

CREATE TABLE PAYMENTS ( UID INTEGER, JOB_ID INTEGER, HOMEOWNER_ID INTEGER, CONTRACTOR_ID INTEGER, TRANSACTION_TYPE VARCHAR(255), PAYMENT_AMOUNT DOUBLE, PAYMENT_DATE DATE );

CREATE TABLE SYSROUTINEPERMS ( ROUTINEPERMSID CHAR(36) NOT NULL, GRANTEE VARCHAR(128) NOT NULL, GRANTOR VARCHAR(128) NOT NULL, ALIASID CHAR(36) NOT NULL, GRANTOPTION CHAR(1) NOT NULL );

CREATE TABLE JOB_REVIEWS ( UID INTEGER, POSTED_DATE DATE, JOB_ID INTEGER, REVIEWER_ID INTEGER, REVIEWED_ID INTEGER, NUM_HARD_HATS INTEGER, REVIEW_DESCRIPTION VARCHAR(255), REVIEW_POST VARCHAR(255) );

CREATE TABLE ENDING_JOBS ( UID INTEGER, HOMEOWNER_ID INTEGER, CONTRACTOR_ID INTEGER, DATE_OPEN DATE );

CREATE TABLE SYSDUMMY1 ( IBMREQD CHAR(1) );

CREATE TABLE FINISHED_PAYMENT_PLANS ( UID INTEGER, JOB_ID INTEGER, HOMEOWNER_ID INTEGER, CONTRACTOR_ID INTEGER, PLAN_TYPE VARCHAR(255), PAYMENTS_MADE INTEGER, TOTAL_AMOUNT_PAID DOUBLE, START_DATE DATE, END_DATE DATE );

CREATE TABLE HOMEOWNER_REVIEWS ( UID INTEGER, POSTED_DATE DATE, REVIEWER_ID INTEGER, REVIEWED_ID INTEGER, NUM_HARD_HATS INTEGER, REVIEW_DESCRIPTION VARCHAR(255), REVIEW_POST VARCHAR(255) );

CREATE TABLE SYSPERMS ( UUID CHAR(36) NOT NULL, OBJECTTYPE VARCHAR(36) NOT NULL, OBJECTID CHAR(36) NOT NULL, PERMISSION CHAR(36) NOT NULL, GRANTOR VARCHAR(128) NOT NULL, GRANTEE VARCHAR(128) NOT NULL, ISGRANTABLE CHAR(1) NOT NULL );

CREATE TABLE PAYMENT_PLANS ( UID INTEGER, JOB_ID INTEGER, HOMEOWNER_ID INTEGER, CONTRACTOR_ID INTEGER, PLAN_TYPE VARCHAR(255), AMOUNT_DUE DOUBLE, PAYMENTS_SCHEDULED INTEGER, START_DATE DATE, END_DATE DATE );

CREATE TABLE SYSUSERS ( USERNAME VARCHAR(128) NOT NULL, HASHINGSCHEME VARCHAR(32672) NOT NULL, PASSWORD VARCHAR(32672) NOT NULL, LASTMODIFIED TIMESTAMP NOT NULL );

CREATE TABLE SYSSEQUENCES ( SEQUENCEID CHAR(36) NOT NULL, SEQUENCENAME VARCHAR(128) NOT NULL, SCHEMAID CHAR(36) NOT NULL, SEQUENCEDATATYPE null NOT NULL, CURRENTVALUE BIGINT, STARTVALUE BIGINT NOT NULL, MINIMUMVALUE BIGINT NOT NULL, MAXIMUMVALUE BIGINT NOT NULL, INCREMENT BIGINT NOT NULL, CYCLEOPTION CHAR(1) NOT NULL );

CREATE TABLE SERVER_ADMIN_ACCOUNTS ( UID INTEGER, USERNAME VARCHAR(255), ACCOUNT_CREATED DATE, PROFILE_IMAGE BLOB(2147483647), FIRST_NAME VARCHAR(255), LAST_NAME VARCHAR(255), PHONE_NUMBER VARCHAR(255), EMAIL VARCHAR(255) );

CREATE TABLE HOMEOWNER_ACCOUNTS ( UID INTEGER, USERNAME VARCHAR(255), ACCOUNT_CREATED DATE, NUM_JOBS_POSTED INTEGER, PROFILE_IMAGE BLOB(2147483647), FIRST_NAME VARCHAR(255), LAST_NAME VARCHAR(255), STREET_ADDRESS_1 VARCHAR(255), STREET_ADDRESS_2 VARCHAR(255), CITY VARCHAR(255), STATE VARCHAR(255), ZIPCODE INTEGER, PHONE_NUMBER VARCHAR(255), EMAIL VARCHAR(255) );

CREATE TABLE SYSTABLEPERMS ( TABLEPERMSID CHAR(36) NOT NULL, GRANTEE VARCHAR(128) NOT NULL, GRANTOR VARCHAR(128) NOT NULL, TABLEID CHAR(36) NOT NULL, SELECTPRIV CHAR(1) NOT NULL, DELETEPRIV CHAR(1) NOT NULL, INSERTPRIV CHAR(1) NOT NULL, UPDATEPRIV CHAR(1) NOT NULL, REFERENCESPRIV CHAR(1) NOT NULL, TRIGGERPRIV CHAR(1) NOT NULL );

CREATE TABLE SYSKEYS ( CONSTRAINTID CHAR(36) NOT NULL, CONGLOMERATEID CHAR(36) NOT NULL );

CREATE TABLE COMPLETED_JOBS ( UID INTEGER, HOMEOWNER_ID INTEGER, CONTRACTOR_ID INTEGER, DATE_OPEN DATE, DATE_CLOSE DATE );

CREATE TABLE BIDS ( UID INTEGER, JOB_ID INTEGER, HOMEOWNER_ID INTEGER, DATE_OPEN DATE, DATE_CLOSE DATE );

CREATE TABLE SYSFILES ( FILEID CHAR(36) NOT NULL, SCHEMAID CHAR(36) NOT NULL, FILENAME VARCHAR(128) NOT NULL, GENERATIONID BIGINT NOT NULL );

CREATE TABLE CONTRACTOR_ACCOUNTS ( UID INTEGER, USERNAME VARCHAR(255), ACCOUNT_CREATED DATE, NUM_JOBS_COMPLETED INTEGER, PROFILE_IMAGE BLOB(2147483647), FIRST_NAME VARCHAR(255), LAST_NAME VARCHAR(255), STREET_ADDRESS_1 VARCHAR(255), STREET_ADDRESS_2 VARCHAR(255), CITY VARCHAR(255), STATE VARCHAR(255), ZIPCODE INTEGER, PHONE_NUMBER VARCHAR(255), EMAIL VARCHAR(255) );

CREATE TABLE SYSCOLPERMS ( COLPERMSID CHAR(36) NOT NULL, GRANTEE VARCHAR(128) NOT NULL, GRANTOR VARCHAR(128) NOT NULL, TABLEID CHAR(36) NOT NULL, TYPE CHAR(1) NOT NULL, COLUMNS null NOT NULL );

CREATE TABLE SYSALIASES ( ALIASID CHAR(36) NOT NULL, ALIAS VARCHAR(128) NOT NULL, SCHEMAID CHAR(36), JAVACLASSNAME LONG VARCHAR NOT NULL, ALIASTYPE CHAR(1) NOT NULL, NAMESPACE CHAR(1) NOT NULL, SYSTEMALIAS null NOT NULL, ALIASINFO null, SPECIFICNAME VARCHAR(128) NOT NULL );

CREATE TABLE PLANS_IN_PROGRESS ( UID INTEGER, JOB_ID INTEGER, HOMEOWNER_ID INTEGER, CONTRACTOR_ID INTEGER, PLAN_TYPE VARCHAR(255), AMOUNT_PAID DOUBLE, AMOUNT_REMAINING DOUBLE, PAYMENTS_PAID INTEGER, PAYMENTS_REMAINING INTEGER, START_DATE DATE, END_DATE DATE );

CREATE TABLE SYSFOREIGNKEYS ( CONSTRAINTID CHAR(36) NOT NULL, CONGLOMERATEID CHAR(36) NOT NULL, KEYCONSTRAINTID CHAR(36) NOT NULL, DELETERULE CHAR(1) NOT NULL, UPDATERULE CHAR(1) NOT NULL );

CREATE INDEX SYSDEPENDS_INDEX2 ON SYSDEPENDS (PROVIDERID ASC);

CREATE UNIQUE INDEX SYSCOLUMNS_INDEX1 ON SYSCOLUMNS (REFERENCEID ASC, COLUMNNAME ASC);

CREATE UNIQUE INDEX SYSSTATEMENTS_INDEX2 ON SYSSTATEMENTS (STMTNAME ASC, SCHEMAID ASC);

CREATE UNIQUE INDEX SYSCONSTRAINTS_INDEX1 ON SYSCONSTRAINTS (CONSTRAINTID ASC);

CREATE UNIQUE INDEX SYSTABLEPERMS_INDEX2 ON SYSTABLEPERMS (TABLEPERMSID ASC);

CREATE UNIQUE INDEX SYSFILES_INDEX2 ON SYSFILES (FILEID ASC);

CREATE UNIQUE INDEX SYSSCHEMAS_INDEX2 ON SYSSCHEMAS (SCHEMAID ASC);

CREATE UNIQUE INDEX SYSSTATEMENTS_INDEX1 ON SYSSTATEMENTS (STMTID ASC);

CREATE UNIQUE INDEX SYSCHECKS_INDEX1 ON SYSCHECKS (CONSTRAINTID ASC);

CREATE INDEX SYSCONGLOMERATES_INDEX3 ON SYSCONGLOMERATES (TABLEID ASC);

CREATE INDEX SYSCONGLOMERATES_INDEX1 ON SYSCONGLOMERATES (CONGLOMERATEID ASC);

CREATE UNIQUE INDEX SYSVIEWS_INDEX1 ON SYSVIEWS (TABLEID ASC);

CREATE UNIQUE INDEX SYSPERMS_INDEX1 ON SYSPERMS (UUID ASC);

CREATE INDEX SYSROLES_INDEX2 ON SYSROLES (ROLEID ASC, ISDEF ASC);

CREATE INDEX SYSTRIGGERS_INDEX3 ON SYSTRIGGERS (TABLEID ASC, CREATIONTIMESTAMP ASC);

CREATE INDEX SYSCOLUMNS_INDEX2 ON SYSCOLUMNS (COLUMNDEFAULTID ASC);

CREATE UNIQUE INDEX SYSFOREIGNKEYS_INDEX1 ON SYSFOREIGNKEYS (CONSTRAINTID ASC);

CREATE INDEX SYSTABLEPERMS_INDEX3 ON SYSTABLEPERMS (TABLEID ASC);

CREATE INDEX SYSPERMS_INDEX2 ON SYSPERMS (OBJECTID ASC);

CREATE INDEX SYSDEPENDS_INDEX1 ON SYSDEPENDS (DEPENDENTID ASC);

CREATE UNIQUE INDEX SYSTABLEPERMS_INDEX1 ON SYSTABLEPERMS (GRANTEE ASC, TABLEID ASC, GRANTOR ASC);

CREATE UNIQUE INDEX SYSCONGLOMERATES_INDEX2 ON SYSCONGLOMERATES (CONGLOMERATENAME ASC, SCHEMAID ASC);

CREATE UNIQUE INDEX SYSTRIGGERS_INDEX1 ON SYSTRIGGERS (TRIGGERID ASC);

CREATE UNIQUE INDEX SYSKEYS_INDEX1 ON SYSKEYS (CONSTRAINTID ASC);

CREATE UNIQUE INDEX SYSCONSTRAINTS_INDEX2 ON SYSCONSTRAINTS (CONSTRAINTNAME ASC, SCHEMAID ASC);

CREATE UNIQUE INDEX SYSSCHEMAS_INDEX1 ON SYSSCHEMAS (SCHEMANAME ASC);

CREATE UNIQUE INDEX SYSALIASES_INDEX2 ON SYSALIASES (ALIASID ASC);

CREATE UNIQUE INDEX SYSCOLPERMS_INDEX1 ON SYSCOLPERMS (GRANTEE ASC, TABLEID ASC, TYPE ASC, GRANTOR ASC);

CREATE UNIQUE INDEX SYSUSERS_INDEX1 ON SYSUSERS (USERNAME ASC);

CREATE UNIQUE INDEX SYSROUTINEPERMS_INDEX1 ON SYSROUTINEPERMS (GRANTEE ASC, ALIASID ASC, GRANTOR ASC);

CREATE UNIQUE INDEX SYSSEQUENCES_INDEX2 ON SYSSEQUENCES (SCHEMAID ASC, SEQUENCENAME ASC);

CREATE INDEX SYSROUTINEPERMS_INDEX3 ON SYSROUTINEPERMS (ALIASID ASC);

CREATE UNIQUE INDEX SYSROUTINEPERMS_INDEX2 ON SYSROUTINEPERMS (ROUTINEPERMSID ASC);

CREATE UNIQUE INDEX SYSSEQUENCES_INDEX1 ON SYSSEQUENCES (SEQUENCEID ASC);

CREATE UNIQUE INDEX SYSCOLPERMS_INDEX2 ON SYSCOLPERMS (COLPERMSID ASC);

CREATE UNIQUE INDEX SYSTABLES_INDEX1 ON SYSTABLES (TABLENAME ASC, SCHEMAID ASC);

CREATE UNIQUE INDEX SYSALIASES_INDEX1 ON SYSALIASES (SCHEMAID ASC, ALIAS ASC, NAMESPACE ASC);

CREATE UNIQUE INDEX SYSALIASES_INDEX3 ON SYSALIASES (SCHEMAID ASC, SPECIFICNAME ASC);

CREATE UNIQUE INDEX SYSPERMS_INDEX3 ON SYSPERMS (GRANTEE ASC, OBJECTID ASC, GRANTOR ASC);

CREATE INDEX SYSCONSTRAINTS_INDEX3 ON SYSCONSTRAINTS (TABLEID ASC);

CREATE UNIQUE INDEX SYSFILES_INDEX1 ON SYSFILES (FILENAME ASC, SCHEMAID ASC);

CREATE UNIQUE INDEX SYSTABLES_INDEX2 ON SYSTABLES (TABLEID ASC);

CREATE INDEX SYSFOREIGNKEYS_INDEX2 ON SYSFOREIGNKEYS (KEYCONSTRAINTID ASC);

CREATE UNIQUE INDEX SYSTRIGGERS_INDEX2 ON SYSTRIGGERS (TRIGGERNAME ASC, SCHEMAID ASC);

CREATE UNIQUE INDEX SYSROLES_INDEX3 ON SYSROLES (UUID ASC);

CREATE INDEX SYSCOLPERMS_INDEX3 ON SYSCOLPERMS (TABLEID ASC);

CREATE UNIQUE INDEX SYSROLES_INDEX1 ON SYSROLES (ROLEID ASC, GRANTEE ASC, GRANTOR ASC);

CREATE INDEX SYSSTATISTICS_INDEX1 ON SYSSTATISTICS (TABLEID ASC, REFERENCEID ASC); `

Right click the text and select Execute All

Congratulations. if there were no errors your test database is ready to go``