USE peter;

begin tran fbtsetup;

-- saved color codes needed as of Version 5.17
CREATE TABLE FBT_COLORCODE_DEF (
    FBT_COLORCODE_ID NUMBER PRIMARY KEY,
    FBT_COLORCODE_FIELD VARCHAR(255),
    FBT_COLORCODE_INFO LONG
);

-- history changes needed as of Version 6.0
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_SUBJECT VARCHAR(255);
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_PRIORITY INT;
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_PROJECT VARCHAR(255);
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_AREA VARCHAR(255);
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_ENVIRONMENT VARCHAR(255);
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_VERSION VARCHAR(255);
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_NOTIFYLIST VARCHAR(255);
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_PARENT_ID NUMBER;
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_REQUESTED_DUE_DATE DATE;
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_ACTUAL_COMPLETION_DATE DATE;
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_ESTIMATED_HOURS NUMBER;
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_ACTUAL_HOURS NUMBER;
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_PERCENT_COMPLETE NUMBER;
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_ATTACHMENTS VARCHAR(255);
ALTER TABLE FBT_BUG_STRUCT_ENTRY ADD FBT_NOTES VARCHAR(255);

commit tran fbtsetup;