INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (12, 'MODULE', 1, '', '', 2, '', 'Module', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (13, 'CUSTOMER', 1, '', '', 2, '', 'Customer', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (14, 'PRIORITY', 1, '', '', 2, '', 'Priority', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (15, 'IMPLVER', 1, '', '', 2, '', 'Implement in version', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (16, 'EFFORTE', 8, '0,00', '9999,00', 2, '', 'Estimated effort', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (17, 'EFFORTA', 8, '0,00', '9999,00', 2, '', 'Actual effort', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (18, 'RSTATUS', 1, '0,00', '0,00', 2, '', 'Status', 'Status of requirement', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (19, 'DONEVER', 1, '0,00', '0,00', 2, '', 'Implemented in version', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (20, 'FSTATUS', 1, '0,00', '0,00', 2, '', 'Status', 'Status of new feature', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (21, 'RESPONSIBLE', 2, '0,00', '0,00', 2, '', 'Responsible', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (23, 'FOUNDVER', 1, '0,00', '0,00', 2, '', 'Found in version', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (22, 'FKIND', 1, '0,00', '0,00', 2, '', 'Kind', 'Kind of new feature', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (24, 'BSTATUS', 1, '0,00', '0,00', 2, '', 'Status', 'Status of bug', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (25, 'SEVERITY', 1, '0,00', '0,00', 2, '', 'Severity', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (26, 'VERSION', 1, '0,00', '0,00', 2, '', 'Version', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (27, 'TSTATUS', 1, '0,00', '0,00', 2, '', 'Status', 'Test status', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (28, 'RESULT', 1, '0,00', '0,00', 2, '', 'Test result', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (29, 'STARTED', 32, '0,00', '0,00', 2, '', 'Started at', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (30, 'DURATION', 8, '-999999,00', '9999999,00', 2, '', 'Duration', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (31, 'MODULE1', 64, '-2147483648', '2147483647', 2, '', 'Has module1', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (32, 'MODULE2', 64, '-2147483648', '2147483647', 2, '', 'Has module2', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (33, 'PRICE', 8, '0,00', '9999999,00', 2, '', 'Price', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (34, 'PAID', 64, '0,00', '0,00', 2, '', 'Paid', '', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (35, 'PHASE', 1, '0,00', '0,00', 2, '', 'Phase', 'Sale phase', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (36, 'SKIND', 1, '0,00', '0,00', 2, '', 'Kind', 'Kind of support', 0, 0, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (37, 'EXPLANATION', 4, '0,00', '0,00', 2, '', 'Explanation', '', 0, 150, '', NULL); INSERT INTO ISSUEFIELD (ID, NAME, TYPEID, FROMRANGE, TORANGE, REQUIREDAT, INPUTMASK, LABEL, HINT, ROFIELD, LEN, REGEX, PARENTID) VALUES (38, 'ISSUETYPE', 1, '0,00', '0,00', 2, '', '', '', 0, 0, '', NULL); UPDATE GENERATORS SET VAL = 38 WHERE GENNAME='ISSUEFIELDGEN'; INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (15, 100, 'Submited', 18, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (16, 200, 'Analyzing', 18, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (17, 300, 'Passed', 18, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (18, 400, 'Deferred', 18, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (7, 100, 'Customer1', 13, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (8, 200, 'Customer2', 13, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (13, 100, 'Version1', 15, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (14, 200, 'Version2', 15, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (5, 100, 'Module1', 12, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (6, 200, 'Module2', 12, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (19, 100, 'Version1', 19, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (20, 200, 'Version2', 19, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (47, 100, 'Version1', 26, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (9, 100, 'Very high', 14, 255, 1); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (10, 200, 'High', 14, 0, 1); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (11, 300, 'Middle', 14, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (12, 400, 'Low', 14, 32768, 1); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (28, 100, 'Documentation', 22, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (78, 150, 'Functionality', 22, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (29, 200, 'Performance', 22, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (30, 300, 'Translation', 22, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (31, 400, 'Visual', 22, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (48, 200, 'Version2', 26, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (21, 100, 'Submitted', 20, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (22, 200, 'Analyzing', 20, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (23, 300, 'Programming', 20, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (24, 400, 'Solved', 20, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (25, 500, 'Testing', 20, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (26, 600, 'Closed', 20, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (27, 700, 'Reopened', 20, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (32, 100, 'Version1', 23, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (33, 200, 'Version2', 23, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (34, 100, 'Submitted', 24, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (35, 200, 'Analyzing', 24, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (36, 300, 'Programming', 24, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (37, 400, 'Solved', 24, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (38, 500, 'Testing', 24, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (39, 600, 'Closed', 24, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (40, 700, 'Reopened', 24, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (41, 800, 'Not a bug', 24, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (42, 100, 'Show Stopper', 25, 255, 1); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (43, 200, 'Highly visible problem', 25, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (44, 300, 'Commonly encountered problem', 25, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (45, 400, 'Infrequently encountered problem', 25, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (46, 500, 'Extreme corner cased problem', 25, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (49, 100, 'Submitted', 27, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (50, 200, 'Planning', 27, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (51, 300, 'Testing', 27, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (52, 400, 'Closed', 27, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (53, 100, 'Passed', 28, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (54, 200, 'Minor problems', 28, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (55, 300, 'Major problems', 28, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (56, 400, 'Show stopper', 28, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (57, 100, 'Pre-Sale', 35, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (58, 200, 'Analysis', 35, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (59, 300, 'Offer', 35, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (60, 400, 'Development', 35, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (61, 500, 'Deployment', 35, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (62, 600, 'Testing', 35, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (63, 700, 'Production', 35, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (64, 800, 'Not bought', 35, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (65, 100, 'Bug', 36, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (66, 200, 'Configuration', 36, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (67, 300, 'Explanation', 36, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (68, 400, 'Request', 36, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (69, 500, 'Setup', 36, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (70, 600, 'User error', 36, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (71, 100, 'Requirement', 38, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (72, 200, 'New feature', 38, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (73, 300, 'Enhancement', 38, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (74, 400, 'Bug', 38, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (75, 500, 'Test', 38, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (76, 600, 'Sold release', 38, 0, 0); INSERT INTO CHOICEFIELD (ID, POS, NAME, ISSUEFIELD, FONTCOLOR, FONTPROP) VALUES (77, 700, 'Support', 38, 0, 0); UPDATE GENERATORS SET VAL = 78 WHERE GENNAME='CHOICEFIELDGEN'; alter table issue add MODULE SMALLINT, add CUSTOMER SMALLINT, add PRIORITY SMALLINT, add IMPLVER SMALLINT, add EFFORTE DOUBLE PRECISION, add EFFORTA DOUBLE PRECISION, add RSTATUS SMALLINT, add DONEVER SMALLINT, add FSTATUS SMALLINT, add RESPONSIBLE SMALLINT, add FKIND SMALLINT, add FOUNDVER SMALLINT, add BSTATUS SMALLINT, add SEVERITY SMALLINT, add VERSION SMALLINT, add TSTATUS SMALLINT, add RESULT SMALLINT, add STARTED TIMESTAMP, add DURATION DOUBLE PRECISION, add MODULE1 SMALLINT, add MODULE2 SMALLINT, add PRICE DOUBLE PRECISION, add PAID SMALLINT, add PHASE SMALLINT, add SKIND SMALLINT, add EXPLANATION VARCHAR(150), add ISSUETYPE SMALLINT;