1: 2:create domain D_CHAR1 CHAR(1) DEFAULT '' NOT NULL; 3:create domain D_CHARBOOL CHAR(1) DEFAULT '0' NOT NULL; 4:create domain D_DATE DATE DEFAULT '31-DEC-2099' NOT NULL; 5:create domain D_INTBOOL INTEGER DEFAULT '0' NOT NULL; 6:create domain D_INTEGER INTEGER DEFAULT 0 NOT NULL; 7:create domain D_LONGTEXT VARCHAR(4096) NOT NULL; 8:create domain D_PASSWORD VARCHAR(40) DEFAULT NULL; 9:create domain D_SHORTINT NUMERIC(5,0) DEFAULT 0 NOT NULL; 10:create domain D_TEXT VARCHAR(2048) NOT NULL; 11:create domain D_TIMESTAMP TIMESTAMP DEFAULT 'NOW' NOT NULL; 12:create domain D_VARCHAR12 VARCHAR(12) DEFAULT '' NOT NULL; 13:create domain D_VARCHAR20 VARCHAR(20) DEFAULT '' NOT NULL; 14:create domain D_VARCHAR30 VARCHAR(30) DEFAULT '' NOT NULL; 15:create domain D_VARCHAR50 VARCHAR(50) DEFAULT '' NOT NULL; 16:create domain D_VARCHAR100 VARCHAR(100) DEFAULT '' NOT NULL; 17:create domain D_VARCHAR150 VARCHAR(150) DEFAULT '' NOT NULL; 18:create domain D_VARCHAR255 VARCHAR(255) DEFAULT '' NOT NULL; 19: 20: 21:CREATE TABLE flyspray_admin_requests ( 22: request_id D_INTEGER, 23: project_id D_INTEGER, 24: task_id D_INTEGER, 25: submitted_by D_INTEGER, 26: request_type D_SHORTINT, 27: reason_given D_LONGTEXT, 28: time_submitted D_VARCHAR12, 29: resolved_by D_INTEGER, 30: time_resolved D_VARCHAR12, 31: deny_reason D_VARCHAR255, 32: PRIMARY KEY (request_id) 33:); 34:create sequence request_id_seq; 35:execute procedure autoinc_gen ('flyspray_admin_requests', 'request_id', 'request_id_seq'); 36:commit; 37: 38:COMMENT ON TABLE flyspray_admin_requests is 'Pending requests for admins and PMs to attend to'; 39: 40: 41:CREATE TABLE flyspray_assigned ( 42: assigned_id D_INTEGER, 43: task_id D_INTEGER, 44: assignee_id D_INTEGER, 45: user_or_group D_CHARBOOL, 46: PRIMARY KEY (assigned_id) 47:); 48:create sequence assigned_id_seq; 49:execute procedure autoinc_gen ('flyspray_assigned', 'assigned_id', 'assigned_id_seq'); 50:commit; 51: 52:COMMENT ON TABLE flyspray_assigned is 'Who is assigned what task'; 53: 54: 55:CREATE TABLE flyspray_attachments ( 56: attachment_id D_INTEGER, 57: task_id D_INTEGER, 58: comment_id D_INTEGER, 59: orig_name D_VARCHAR100, 60: file_name D_VARCHAR30, 61: file_desc D_VARCHAR100, 62: file_type D_VARCHAR50, 63: file_size D_INTEGER, 64: added_by D_INTEGER, 65: date_added D_VARCHAR12, 66: PRIMARY KEY (attachment_id) 67:); 68:create sequence attachment_id_seq; 69:execute procedure autoinc_gen ('flyspray_attachments', 'attachment_id', 'attachment_id_seq'); 70:commit; 71: 72:COMMENT ON TABLE flyspray_attachments is 'List the names and locations of files attached to tasks'; 73: 74: 75:CREATE TABLE flyspray_comments ( 76: comment_id D_INTEGER, 77: task_id D_INTEGER, 78: date_added D_VARCHAR12, 79: user_id D_INTEGER, 80: comment_text D_LONGTEXT, 81: PRIMARY KEY (comment_id) 82:); 83: 84:create sequence comment_id_seq; 85:execute procedure autoinc_gen ('flyspray_comments', 'comment_id', 'comment_id_seq'); 86:commit; 87: 88: 89:CREATE TABLE flyspray_dependencies ( 90: depend_id D_INTEGER, 91: task_id D_INTEGER, 92: dep_task_id D_INTEGER, 93: PRIMARY KEY (depend_id) 94:); 95:create sequence depend_id_seq; 96:execute procedure autoinc_gen ('flyspray_dependencies', 'depend_id', 'depend_id_seq'); 97:commit; 98: 99:COMMENT ON TABLE flyspray_dependencies is 'Task dependencies'; 100: 101: 102:CREATE TABLE flyspray_groups ( 103: group_id D_INTEGER, 104: group_name D_VARCHAR20, 105: group_desc D_VARCHAR150, 106: belongs_to_project D_INTEGER, 107: is_admin D_INTBOOL, 108: manage_project D_INTBOOL, 109: view_tasks D_INTBOOL, 110: open_new_tasks D_INTBOOL, 111: modify_own_tasks D_INTBOOL, 112: modify_all_tasks D_INTBOOL, 113: view_comments D_INTBOOL, 114: add_comments D_INTBOOL, 115: edit_comments D_INTBOOL, 116: delete_comments D_INTBOOL, 117: view_attachments D_INTBOOL, 118: create_attachments D_INTBOOL, 119: delete_attachments D_INTBOOL, 120: view_history D_INTBOOL, 121: close_own_tasks D_INTBOOL, 122: close_other_tasks D_INTBOOL, 123: assign_to_self D_INTBOOL, 124: assign_others_to_self D_INTBOOL, 125: view_reports D_INTBOOL, 126: group_open D_INTBOOL, 127: PRIMARY KEY (group_id) 128:); 129:create sequence group_id_seq; 130:execute procedure autoinc_gen ('flyspray_groups', 'group_id', 'group_id_seq'); 131:commit; 132: 133:COMMENT ON TABLE flyspray_groups is 'User Groups for the Flyspray bug killer'; 134: 135:INSERT INTO flyspray_groups VALUES (NEXT VALUE FOR group_id_seq, 'Admin', 'Members have unlimited access to all functionality.', 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1); 136:INSERT INTO flyspray_groups VALUES (NEXT VALUE FOR group_id_seq, 'Developers', 'Global Developers for all projects', 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1); 137:INSERT INTO flyspray_groups VALUES (NEXT VALUE FOR group_id_seq, 'Reporters', 'Open new tasks / add comments in all projects', 0, 0, 0, 1, 1, 0, 0, 1, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1); 138:INSERT INTO flyspray_groups VALUES (NEXT VALUE FOR group_id_seq, 'Basic', 'Members can login, relying upon Project permissions only', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1); 139:INSERT INTO flyspray_groups VALUES (NEXT VALUE FOR group_id_seq, 'Disabled', 'Users whose accounts are disabled.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); 140:INSERT INTO flyspray_groups VALUES (NEXT VALUE FOR group_id_seq, 'Project Managers', 'Permission to do anything related to the Default Project.', 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1); 141:commit; 142: 143: 144:CREATE TABLE flyspray_history ( 145: history_id D_INTEGER, 146: task_id D_INTEGER, 147: user_id D_INTEGER, 148: event_date D_TEXT, 149: event_type D_SHORTINT, 150: field_changed D_TEXT, 151: old_value D_TEXT, 152: new_value D_TEXT, 153: PRIMARY KEY (history_id) 154:); 155: 156:create sequence history_id_seq; 157:execute procedure autoinc_gen ('flyspray_history', 'history_id', 'history_id_seq'); 158:commit; 159: 160:INSERT INTO flyspray_history VALUES (NEXT VALUE FOR history_id_seq, 1, 1, '1122784578', 1, '', '', ''); 161:commit; 162: 163:CREATE TABLE flyspray_list_category ( 164: category_id D_INTEGER, 165: project_id D_INTEGER, 166: category_name D_VARCHAR30, 167: list_position D_INTEGER, 168: show_in_list D_INTBOOL, 169: category_owner D_INTEGER, 170: parent_id D_INTEGER, 171: PRIMARY KEY (category_id) 172:); 173: 174:create sequence category_id_seq; 175:execute procedure autoinc_gen ('flyspray_list_category', 'category_id', 'category_id_seq'); 176:commit; 177: 178:INSERT INTO flyspray_list_category VALUES (NEXT VALUE FOR category_id_seq, 1, 'Backend / Core', 1, 1, 0, 0); 179:commit; 180: 181:CREATE TABLE flyspray_list_os ( 182: os_id D_INTEGER, 183: project_id D_INTEGER, 184: os_name D_VARCHAR20, 185: list_position D_INTEGER, 186: show_in_list D_INTBOOL, 187: PRIMARY KEY (os_id) 188:); 189: 190:create sequence os_id_seq; 191:execute procedure autoinc_gen ('flyspray_list_os', 'os_id', 'os_id_seq'); 192:commit; 193: 194:COMMENT ON TABLE flyspray_list_os is 'Operating system list for the Flyspray bug killer'; 195: 196:INSERT INTO flyspray_list_os VALUES (NEXT VALUE FOR os_id_seq, 1, 'All', 1, 1); 197:INSERT INTO flyspray_list_os VALUES (NEXT VALUE FOR os_id_seq, 1, 'Windows', 2, 1); 198:INSERT INTO flyspray_list_os VALUES (NEXT VALUE FOR os_id_seq, 1, 'Linux', 3, 1); 199:INSERT INTO flyspray_list_os VALUES (NEXT VALUE FOR os_id_seq, 1, 'Mac OS', 4, 1); 200:commit; 201: 202:CREATE TABLE flyspray_list_resolution ( 203: resolution_id D_INTEGER, 204: resolution_name D_VARCHAR30, 205: list_position D_INTEGER, 206: show_in_list D_INTBOOL, 207: project_id D_INTEGER, 208: PRIMARY KEY (resolution_id) 209:); 210: 211:create sequence resolution_id_seq; 212:execute procedure autoinc_gen ('flyspray_list_resolution', 'resolution_id', 'resolution_id_seq'); 213:commit; 214: 215:INSERT INTO flyspray_list_resolution VALUES (NEXT VALUE FOR resolution_id_seq, 'Not a bug', 1, 1, 0); 216:INSERT INTO flyspray_list_resolution VALUES (NEXT VALUE FOR resolution_id_seq, 'Won''t fix', 2, 1, 0); 217:INSERT INTO flyspray_list_resolution VALUES (NEXT VALUE FOR resolution_id_seq, 'Won''t implement', 3, 1, 0); 218:INSERT INTO flyspray_list_resolution VALUES (NEXT VALUE FOR resolution_id_seq, 'Works for me', 4, 1, 0); 219:INSERT INTO flyspray_list_resolution VALUES (NEXT VALUE FOR resolution_id_seq, 'Duplicate', 5, 1, 0); 220:INSERT INTO flyspray_list_resolution VALUES (NEXT VALUE FOR resolution_id_seq, 'Deferred', 6, 1, 0); 221:INSERT INTO flyspray_list_resolution VALUES (NEXT VALUE FOR resolution_id_seq, 'Fixed', 7, 1, 0); 222:INSERT INTO flyspray_list_resolution VALUES (NEXT VALUE FOR resolution_id_seq, 'Implemented', 8, 1, 0); 223:commit; 224: 225: 226:CREATE TABLE flyspray_list_tasktype ( 227: tasktype_id D_INTEGER, 228: tasktype_name D_VARCHAR20, 229: list_position D_INTEGER, 230: show_in_list D_INTBOOL, 231: project_id D_INTEGER, 232: PRIMARY KEY (tasktype_id) 233:); 234: 235:create sequence tasktype_id_seq; 236:execute procedure autoinc_gen ('flyspray_list_tasktype', 'tasktype_id', 'tasktype_id_seq'); 237:commit; 238: 239:COMMENT ON TABLE flyspray_list_tasktype is 'List of task types for Flyspray the bug killer.'; 240: 241:INSERT INTO flyspray_list_tasktype VALUES (NEXT VALUE FOR tasktype_id_seq, 'Bug Report', 1, 1, 0); 242:INSERT INTO flyspray_list_tasktype VALUES (NEXT VALUE FOR tasktype_id_seq, 'Feature Request', 2, 1, 0); 243:commit; 244: 245: 246:CREATE TABLE flyspray_list_version ( 247: version_id D_INTEGER, 248: project_id D_INTEGER, 249: version_name D_VARCHAR20, 250: list_position D_INTEGER, 251: show_in_list D_INTBOOL, 252: version_tense D_INTBOOL, 253: PRIMARY KEY (version_id) 254:); 255: 256:create sequence version_id_seq; 257:execute procedure autoinc_gen ('flyspray_list_version', 'version_id', 'version_id_seq'); 258:commit; 259: 260:INSERT INTO flyspray_list_version VALUES (NEXT VALUE FOR version_id_seq, 1, 'Development', 1, 1, 2); 261:commit; 262: 263:CREATE TABLE flyspray_notification_messages ( 264: message_id D_INTEGER, 265: message_subject D_VARCHAR50, 266: message_body D_LONGTEXT, 267: time_created D_TIMESTAMP, 268: PRIMARY KEY (message_id) 269:); 270: 271:create sequence message_id_seq; 272:execute procedure autoinc_gen ('flyspray_notification_messages', 'message_id', 'message_id_seq'); 273:commit; 274: 275:COMMENT ON TABLE flyspray_notification_messages is 'Notification body and subject'; 276: 277:CREATE TABLE flyspray_notification_recipients ( 278: recipient_id D_INTEGER, 279: message_id D_INTEGER, 280: notify_method D_CHAR1, 281: notify_address D_VARCHAR100, 282: PRIMARY KEY (recipient_id) 283:); 284: 285:create sequence recipient_id_seq; 286:execute procedure autoinc_gen ('flyspray_notification_recipients', 'recipient_id', 'recipient_id_seq'); 287:commit; 288: 289:COMMENT ON TABLE flyspray_notification_recipients is 'Notification recipient list'; 290: 291:CREATE TABLE flyspray_notifications ( 292: notify_id D_INTEGER, 293: task_id D_INTEGER, 294: user_id D_INTEGER, 295: PRIMARY KEY (notify_id) 296:); 297: 298:create sequence notify_id_seq; 299:execute procedure autoinc_gen ('flyspray_notifications', 'notify_id', 'notify_id_seq'); 300:commit; 301: 302:COMMENT ON TABLE flyspray_notifications is 'Extra task notifications are stored here'; 303: 304:CREATE TABLE flyspray_prefs ( 305: pref_id D_INTEGER, 306: pref_name D_VARCHAR20, 307: pref_value D_VARCHAR255, 308: pref_desc D_VARCHAR100, 309: PRIMARY KEY (pref_id) 310:); 311: 312:create sequence pref_id_seq; 313:execute procedure autoinc_gen ('flyspray_prefs', 'pref_id', 'pref_id_seq'); 314:commit; 315: 316:COMMENT ON TABLE flyspray_prefs is 'Application preferences are set here'; 317: 318:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'fs_ver', '0.9.8', 'Current Flyspray version'); 319:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'jabber_server', '', 'Jabber server'); 320:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'jabber_port', '5222', 'Jabber server port'); 321:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'jabber_username', '', 'Jabber username'); 322:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'jabber_password', '', 'Jabber password'); 323:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'anon_group', '4', 'Group for anonymous registrations'); 324:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'user_notify', '1', 'Force task notifications as'); 325:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'admin_email', 'flyspray@example.com', 'Reply email address for notifications'); 326:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'assigned_groups', '1 2 3', 'Members of these groups can be assigned tasks'); 327:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'lang_code', 'en', 'Language'); 328:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'spam_proof', '1', 'Use confirmation codes for user registrations'); 329:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'default_project', '1', 'Default project id'); 330:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'dateformat', '', 'Default date format for new users and guests used in the task list'); 331:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'dateformat_extended', '', 'Default date format for new users and guests used in task details'); 332:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'anon_reg', '1', 'Allow new user registrations'); 333:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'global_theme', 'Bluey', 'Theme to use when viewing all projects'); 334:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'visible_columns', 'id project category tasktype severity summary status progress', 'Columns visible when viewing all projects'); 335:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'smtp_server', '', 'Remote mail server'); 336:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'smtp_user', '', 'Username to access the remote mail server'); 337:INSERT INTO flyspray_prefs VALUES (NEXT VALUE FOR pref_id_seq, 'smtp_pass', '', 'Password to access the remote mail server'); 338:commit; 339: 340:CREATE TABLE flyspray_projects ( 341: project_id D_INTEGER, 342: project_title D_VARCHAR100, 343: theme_style D_VARCHAR20 default '0', 344: show_logo D_INTBOOL, 345: inline_images D_INTBOOL, 346: default_cat_owner D_INTEGER, 347: intro_message D_LONGTEXT, 348: project_is_active D_INTBOOL, 349: visible_columns D_VARCHAR255, 350: others_view D_INTBOOL, 351: anon_open D_INTBOOL, 352: notify_email D_LONGTEXT, 353: notify_email_when D_INTBOOL, 354: notify_jabber D_LONGTEXT, 355: notify_jabber_when D_INTBOOL, 356: PRIMARY KEY (project_id) 357:); 358: 359:create sequence project_id_seq; 360:execute procedure autoinc_gen ('flyspray_projects', 'project_id', 'project_id_seq'); 361:commit; 362: 363:COMMENT ON TABLE flyspray_projects is 'Details on multiple Flyspray projects'; 364: 365:INSERT INTO flyspray_projects VALUES (NEXT VALUE FOR project_id_seq, 'Default Project', 'Bluey', 1, 0, 0, 'This message can be customised under the <b>Projects</b> admin menu...', 1, 'id category tasktype severity summary status progress', 1, 0, '', 0, '', 0); 366:commit; 367: 368:CREATE TABLE flyspray_registrations ( 369: reg_id D_INTEGER, 370: reg_time D_VARCHAR12, 371: confirm_code D_VARCHAR20, 372: user_name D_VARCHAR20, 373: real_name D_VARCHAR100, 374: email_address D_VARCHAR100, 375: jabber_id D_VARCHAR100, 376: notify_type D_INTBOOL, 377: magic_url D_VARCHAR50, 378: PRIMARY KEY (reg_id) 379:); 380: 381:create sequence reg_id_seq; 382:execute procedure autoinc_gen ('flyspray_registrations', 'reg_id', 'reg_id_seq'); 383:commit; 384: 385:COMMENT ON TABLE flyspray_registrations is 'Storage for new user registration confirmation codes'; 386: 387: 388:CREATE TABLE flyspray_related ( 389: related_id D_INTEGER, 390: this_task D_INTEGER, 391: related_task D_INTEGER, 392: PRIMARY KEY (related_id) 393:); 394: 395:create sequence related_id_seq; 396:execute procedure autoinc_gen ('flyspray_related', 'related_id', 'related_id_seq'); 397:commit; 398: 399:COMMENT ON TABLE flyspray_related is 'Related task entries'; 400: 401: 402:CREATE TABLE flyspray_reminders ( 403: reminder_id D_INTEGER, 404: task_id D_INTEGER, 405: to_user_id D_INTEGER, 406: from_user_id D_INTEGER, 407: start_time D_TIMESTAMP, 408: how_often D_INTEGER, 409: last_sent D_TIMESTAMP, 410: reminder_message D_LONGTEXT, 411: PRIMARY KEY (reminder_id) 412:); 413: 414:create sequence reminder_id_seq; 415:execute procedure autoinc_gen ('flyspray_reminders', 'reminder_id', 'reminder_id_seq'); 416:commit; 417: 418:COMMENT ON TABLE flyspray_reminders is 'Scheduled reminders about tasks'; 419: 420: 421:CREATE TABLE flyspray_tasks ( 422: task_id D_INTEGER, 423: attached_to_project D_INTEGER, 424: task_type D_INTEGER, 425: date_opened D_VARCHAR12, 426: opened_by D_INTEGER, 427: is_closed D_INTBOOL, 428: date_closed D_VARCHAR12, 429: closed_by D_INTEGER, 430: closure_comment D_LONGTEXT, 431: item_summary D_VARCHAR100, 432: detailed_desc D_LONGTEXT, 433: item_status D_INTEGER, 434: assigned_to D_INTEGER, 435: resolution_reason D_INTEGER default 1, 436: product_category D_INTEGER, 437: product_version D_INTEGER, 438: closedby_version D_INTEGER, 439: operating_system D_INTEGER, 440: task_severity D_INTEGER, 441: task_priority D_INTEGER, 442: last_edited_by D_INTEGER, 443: last_edited_time D_TIMESTAMP, 444: percent_complete D_INTEGER, 445: mark_private D_INTBOOL, 446: due_date D_DATE, 447: PRIMARY KEY (task_id) 448:); 449: 450:create sequence task_id_seq; 451:execute procedure autoinc_gen ('flyspray_tasks', 'task_id', 'task_id_seq'); 452:commit; 453: 454:COMMENT ON TABLE flyspray_tasks is 'Bugs and feature requests for the Flyspray bug killer'; 455: 456:INSERT INTO flyspray_tasks VALUES (NEXT VALUE FOR task_id_seq, 1, 1, '1122784578', 1, 0, '', 1, ' ', 'Sample Task', 'This isn''t a real task. You should close it and start opening some real tasks.', 2, 0, 1, 1, 1, 0, 1, 1, 2, 0, '', 0, 0, ''); 457:commit; 458: 459: 460:CREATE TABLE flyspray_users ( 461: user_id D_INTEGER, 462: user_name D_VARCHAR20, 463: user_pass D_PASSWORD, 464: real_name D_VARCHAR100, 465: jabber_id D_VARCHAR100, 466: email_address D_VARCHAR100, 467: notify_type D_INTBOOL, 468: account_enabled D_INTBOOL, 469: dateformat D_VARCHAR30, 470: dateformat_extended D_VARCHAR30, 471: magic_url D_VARCHAR50, 472: last_search D_LONGTEXT, 473: tasks_perpage D_INTEGER, 474: PRIMARY KEY (user_id) 475:); 476: 477:create sequence user_id_seq; 478:execute procedure autoinc_gen ('flyspray_users', 'user_id', 'user_id_seq'); 479:commit; 480: 481:COMMENT ON TABLE flyspray_users is 'Users for the Flyspray bug killer'; 482: 483:INSERT INTO flyspray_users VALUES (NEXT VALUE FOR user_id_seq, 'super', '4tuKHcjxpFYag', 'Mr Super User', 'super@example.com', 'super@example.com', 0, 1, '', '', '', '', 25); 484:commit; 485: 486: 487:CREATE TABLE flyspray_users_in_groups ( 488: record_id D_INTEGER, 489: user_id D_INTEGER, 490: group_id D_INTEGER, 491: PRIMARY KEY (record_id) 492:); 493: 494:create sequence record_id_seq; 495:execute procedure autoinc_gen ('flyspray_users_in_groups', 'record_id', 'record_id_seq'); 496:commit; 497: 498:COMMENT ON TABLE flyspray_users_in_groups is 'Which users are in which groups'; 499: 500:INSERT INTO flyspray_users_in_groups VALUES (NEXT VALUE FOR record_id_seq, 1, 1); 501:COMMIT; 502: 503: 504: