Created
September 6, 2020 18:46
-
-
Save dylanwh/206f26ad0665efb0f8a2dbac246e0870 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- 5.0 2020-09-06 14:44:12.000000000 -0400 | |
+++ harmony 2020-09-06 14:44:04.000000000 -0400 | |
@@ -1,5 +1,64 @@ | |
json = {}; | |
json.abstract_schema = {}; | |
+json.abstract_schema.antispam_comment_blocklist = {}; | |
+json.abstract_schema.antispam_comment_blocklist.FIELDS = []; | |
+json.abstract_schema.antispam_comment_blocklist.FIELDS[0] = "id"; | |
+json.abstract_schema.antispam_comment_blocklist.FIELDS[1] = {}; | |
+json.abstract_schema.antispam_comment_blocklist.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.antispam_comment_blocklist.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.antispam_comment_blocklist.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.antispam_comment_blocklist.FIELDS[2] = "word"; | |
+json.abstract_schema.antispam_comment_blocklist.FIELDS[3] = {}; | |
+json.abstract_schema.antispam_comment_blocklist.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.antispam_comment_blocklist.FIELDS[3].TYPE = "VARCHAR(255)"; | |
+json.abstract_schema.antispam_comment_blocklist.INDEXES = []; | |
+json.abstract_schema.antispam_comment_blocklist.INDEXES[0] = "antispam_comment_blocklist_idx"; | |
+json.abstract_schema.antispam_comment_blocklist.INDEXES[1] = {}; | |
+json.abstract_schema.antispam_comment_blocklist.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.antispam_comment_blocklist.INDEXES[1].FIELDS[0] = "word"; | |
+json.abstract_schema.antispam_comment_blocklist.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.antispam_domain_blocklist = {}; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS = []; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[0] = "id"; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[1] = {}; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[2] = "domain"; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[3] = {}; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[3].TYPE = "VARCHAR(255)"; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[4] = "comment"; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[5] = {}; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.antispam_domain_blocklist.FIELDS[5].TYPE = "VARCHAR(255)"; | |
+json.abstract_schema.antispam_domain_blocklist.INDEXES = []; | |
+json.abstract_schema.antispam_domain_blocklist.INDEXES[0] = "antispam_domain_blocklist_idx"; | |
+json.abstract_schema.antispam_domain_blocklist.INDEXES[1] = {}; | |
+json.abstract_schema.antispam_domain_blocklist.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.antispam_domain_blocklist.INDEXES[1].FIELDS[0] = "domain"; | |
+json.abstract_schema.antispam_domain_blocklist.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.antispam_ip_blocklist = {}; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS = []; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[0] = "id"; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[1] = {}; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[2] = "ip_address"; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[3] = {}; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[3].TYPE = "VARCHAR(15)"; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[4] = "comment"; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[5] = {}; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.antispam_ip_blocklist.FIELDS[5].TYPE = "VARCHAR(255)"; | |
+json.abstract_schema.antispam_ip_blocklist.INDEXES = []; | |
+json.abstract_schema.antispam_ip_blocklist.INDEXES[0] = "antispam_ip_blocklist_idx"; | |
+json.abstract_schema.antispam_ip_blocklist.INDEXES[1] = {}; | |
+json.abstract_schema.antispam_ip_blocklist.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.antispam_ip_blocklist.INDEXES[1].FIELDS[0] = "ip_address"; | |
+json.abstract_schema.antispam_ip_blocklist.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.attach_data = {}; | |
json.abstract_schema.attach_data.FIELDS = []; | |
json.abstract_schema.attach_data.FIELDS[0] = "id"; | |
@@ -10,18 +69,36 @@ | |
json.abstract_schema.attach_data.FIELDS[1].REFERENCES.COLUMN = "attach_id"; | |
json.abstract_schema.attach_data.FIELDS[1].REFERENCES.DELETE = "CASCADE"; | |
json.abstract_schema.attach_data.FIELDS[1].REFERENCES.TABLE = "attachments"; | |
-json.abstract_schema.attach_data.FIELDS[1].TYPE = "INT3"; | |
+json.abstract_schema.attach_data.FIELDS[1].TYPE = "INT5"; | |
json.abstract_schema.attach_data.FIELDS[2] = "thedata"; | |
json.abstract_schema.attach_data.FIELDS[3] = {}; | |
json.abstract_schema.attach_data.FIELDS[3].NOTNULL = 1; | |
json.abstract_schema.attach_data.FIELDS[3].TYPE = "LONGBLOB"; | |
+json.abstract_schema.attachment_storage_class = {}; | |
+json.abstract_schema.attachment_storage_class.FIELDS = []; | |
+json.abstract_schema.attachment_storage_class.FIELDS[0] = "id"; | |
+json.abstract_schema.attachment_storage_class.FIELDS[1] = {}; | |
+json.abstract_schema.attachment_storage_class.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.attachment_storage_class.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.attachment_storage_class.FIELDS[1].REFERENCES = {}; | |
+json.abstract_schema.attachment_storage_class.FIELDS[1].REFERENCES.COLUMN = "attach_id"; | |
+json.abstract_schema.attachment_storage_class.FIELDS[1].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.attachment_storage_class.FIELDS[1].REFERENCES.TABLE = "attachments"; | |
+json.abstract_schema.attachment_storage_class.FIELDS[1].TYPE = "INT5"; | |
+json.abstract_schema.attachment_storage_class.FIELDS[2] = "storage_class"; | |
+json.abstract_schema.attachment_storage_class.FIELDS[3] = {}; | |
+json.abstract_schema.attachment_storage_class.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.attachment_storage_class.FIELDS[3].TYPE = "varchar(64)"; | |
+json.abstract_schema.attachment_storage_class.FIELDS[4] = "extra_data"; | |
+json.abstract_schema.attachment_storage_class.FIELDS[5] = {}; | |
+json.abstract_schema.attachment_storage_class.FIELDS[5].TYPE = "MEDIUMTEXT"; | |
json.abstract_schema.attachments = {}; | |
json.abstract_schema.attachments.FIELDS = []; | |
json.abstract_schema.attachments.FIELDS[0] = "attach_id"; | |
json.abstract_schema.attachments.FIELDS[1] = {}; | |
json.abstract_schema.attachments.FIELDS[1].NOTNULL = 1; | |
json.abstract_schema.attachments.FIELDS[1].PRIMARYKEY = 1; | |
-json.abstract_schema.attachments.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.attachments.FIELDS[1].TYPE = "BIGSERIAL"; | |
json.abstract_schema.attachments.FIELDS[2] = "bug_id"; | |
json.abstract_schema.attachments.FIELDS[3] = {}; | |
json.abstract_schema.attachments.FIELDS[3].NOTNULL = 1; | |
@@ -54,7 +131,7 @@ | |
json.abstract_schema.attachments.FIELDS[14] = "filename"; | |
json.abstract_schema.attachments.FIELDS[15] = {}; | |
json.abstract_schema.attachments.FIELDS[15].NOTNULL = 1; | |
-json.abstract_schema.attachments.FIELDS[15].TYPE = "varchar(255)"; | |
+json.abstract_schema.attachments.FIELDS[15].TYPE = "varchar(100)"; | |
json.abstract_schema.attachments.FIELDS[16] = "submitter_id"; | |
json.abstract_schema.attachments.FIELDS[17] = {}; | |
json.abstract_schema.attachments.FIELDS[17].NOTNULL = 1; | |
@@ -72,6 +149,11 @@ | |
json.abstract_schema.attachments.FIELDS[21].DEFAULT = "FALSE"; | |
json.abstract_schema.attachments.FIELDS[21].NOTNULL = 1; | |
json.abstract_schema.attachments.FIELDS[21].TYPE = "BOOLEAN"; | |
+json.abstract_schema.attachments.FIELDS[22] = "attach_size"; | |
+json.abstract_schema.attachments.FIELDS[23] = {}; | |
+json.abstract_schema.attachments.FIELDS[23].DEFAULT = 0; | |
+json.abstract_schema.attachments.FIELDS[23].NOTNULL = 1; | |
+json.abstract_schema.attachments.FIELDS[23].TYPE = "INT4"; | |
json.abstract_schema.attachments.INDEXES = []; | |
json.abstract_schema.attachments.INDEXES[0] = "attachments_bug_id_idx"; | |
json.abstract_schema.attachments.INDEXES[1] = []; | |
@@ -86,6 +168,9 @@ | |
json.abstract_schema.attachments.INDEXES[7] = []; | |
json.abstract_schema.attachments.INDEXES[7][0] = "submitter_id"; | |
json.abstract_schema.attachments.INDEXES[7][1] = "bug_id"; | |
+json.abstract_schema.attachments.INDEXES[8] = "attachments_ispatch_idx"; | |
+json.abstract_schema.attachments.INDEXES[9] = []; | |
+json.abstract_schema.attachments.INDEXES[9][0] = "ispatch"; | |
json.abstract_schema.audit_log = {}; | |
json.abstract_schema.audit_log.FIELDS = []; | |
json.abstract_schema.audit_log.FIELDS[0] = "user_id"; | |
@@ -150,6 +235,70 @@ | |
json.abstract_schema.bug_group_map.INDEXES[2] = "bug_group_map_group_id_idx"; | |
json.abstract_schema.bug_group_map.INDEXES[3] = []; | |
json.abstract_schema.bug_group_map.INDEXES[3][0] = "group_id"; | |
+json.abstract_schema.bug_interest = {}; | |
+json.abstract_schema.bug_interest.FIELDS = []; | |
+json.abstract_schema.bug_interest.FIELDS[0] = "id"; | |
+json.abstract_schema.bug_interest.FIELDS[1] = {}; | |
+json.abstract_schema.bug_interest.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.bug_interest.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.bug_interest.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.bug_interest.FIELDS[2] = "bug_id"; | |
+json.abstract_schema.bug_interest.FIELDS[3] = {}; | |
+json.abstract_schema.bug_interest.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.bug_interest.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.bug_interest.FIELDS[3].REFERENCES.COLUMN = "bug_id"; | |
+json.abstract_schema.bug_interest.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.bug_interest.FIELDS[3].REFERENCES.TABLE = "bugs"; | |
+json.abstract_schema.bug_interest.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.bug_interest.FIELDS[4] = "user_id"; | |
+json.abstract_schema.bug_interest.FIELDS[5] = {}; | |
+json.abstract_schema.bug_interest.FIELDS[5].NOTNOLL = 1; | |
+json.abstract_schema.bug_interest.FIELDS[5].REFERENCES = {}; | |
+json.abstract_schema.bug_interest.FIELDS[5].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.bug_interest.FIELDS[5].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.bug_interest.FIELDS[5].TYPE = "INT3"; | |
+json.abstract_schema.bug_interest.FIELDS[6] = "modification_time"; | |
+json.abstract_schema.bug_interest.FIELDS[7] = {}; | |
+json.abstract_schema.bug_interest.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.bug_interest.FIELDS[7].TYPE = "DATETIME"; | |
+json.abstract_schema.bug_interest.INDEXES = []; | |
+json.abstract_schema.bug_interest.INDEXES[0] = "bug_interest_idx"; | |
+json.abstract_schema.bug_interest.INDEXES[1] = {}; | |
+json.abstract_schema.bug_interest.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.bug_interest.INDEXES[1].FIELDS[0] = "bug_id"; | |
+json.abstract_schema.bug_interest.INDEXES[1].FIELDS[1] = "user_id"; | |
+json.abstract_schema.bug_interest.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.bug_interest.INDEXES[2] = "bug_interest_user_id_idx"; | |
+json.abstract_schema.bug_interest.INDEXES[3] = []; | |
+json.abstract_schema.bug_interest.INDEXES[3][0] = "user_id"; | |
+json.abstract_schema.bug_mentors = {}; | |
+json.abstract_schema.bug_mentors.FIELDS = []; | |
+json.abstract_schema.bug_mentors.FIELDS[0] = "bug_id"; | |
+json.abstract_schema.bug_mentors.FIELDS[1] = {}; | |
+json.abstract_schema.bug_mentors.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.bug_mentors.FIELDS[1].REFERENCES = {}; | |
+json.abstract_schema.bug_mentors.FIELDS[1].REFERENCES.COLUMN = "bug_id"; | |
+json.abstract_schema.bug_mentors.FIELDS[1].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.bug_mentors.FIELDS[1].REFERENCES.TABLE = "bugs"; | |
+json.abstract_schema.bug_mentors.FIELDS[1].TYPE = "INT3"; | |
+json.abstract_schema.bug_mentors.FIELDS[2] = "user_id"; | |
+json.abstract_schema.bug_mentors.FIELDS[3] = {}; | |
+json.abstract_schema.bug_mentors.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.bug_mentors.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.bug_mentors.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.bug_mentors.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.bug_mentors.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.bug_mentors.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.bug_mentors.INDEXES = []; | |
+json.abstract_schema.bug_mentors.INDEXES[0] = "bug_mentors_idx"; | |
+json.abstract_schema.bug_mentors.INDEXES[1] = {}; | |
+json.abstract_schema.bug_mentors.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.bug_mentors.INDEXES[1].FIELDS[0] = "bug_id"; | |
+json.abstract_schema.bug_mentors.INDEXES[1].FIELDS[1] = "user_id"; | |
+json.abstract_schema.bug_mentors.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.bug_mentors.INDEXES[2] = "bug_mentors_bug_id_idx"; | |
+json.abstract_schema.bug_mentors.INDEXES[3] = []; | |
+json.abstract_schema.bug_mentors.INDEXES[3][0] = "bug_id"; | |
json.abstract_schema.bug_see_also = {}; | |
json.abstract_schema.bug_see_also.FIELDS = []; | |
json.abstract_schema.bug_see_also.FIELDS[0] = "id"; | |
@@ -285,6 +434,68 @@ | |
json.abstract_schema.bug_tag.INDEXES[1].FIELDS[0] = "bug_id"; | |
json.abstract_schema.bug_tag.INDEXES[1].FIELDS[1] = "tag_id"; | |
json.abstract_schema.bug_tag.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.bug_type = {}; | |
+json.abstract_schema.bug_type.FIELDS = []; | |
+json.abstract_schema.bug_type.FIELDS[0] = "id"; | |
+json.abstract_schema.bug_type.FIELDS[1] = {}; | |
+json.abstract_schema.bug_type.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.bug_type.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.bug_type.FIELDS[1].TYPE = "SMALLSERIAL"; | |
+json.abstract_schema.bug_type.FIELDS[2] = "value"; | |
+json.abstract_schema.bug_type.FIELDS[3] = {}; | |
+json.abstract_schema.bug_type.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.bug_type.FIELDS[3].TYPE = "varchar(64)"; | |
+json.abstract_schema.bug_type.FIELDS[4] = "sortkey"; | |
+json.abstract_schema.bug_type.FIELDS[5] = {}; | |
+json.abstract_schema.bug_type.FIELDS[5].DEFAULT = 0; | |
+json.abstract_schema.bug_type.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.bug_type.FIELDS[5].TYPE = "INT2"; | |
+json.abstract_schema.bug_type.FIELDS[6] = "isactive"; | |
+json.abstract_schema.bug_type.FIELDS[7] = {}; | |
+json.abstract_schema.bug_type.FIELDS[7].DEFAULT = "TRUE"; | |
+json.abstract_schema.bug_type.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.bug_type.FIELDS[7].TYPE = "BOOLEAN"; | |
+json.abstract_schema.bug_type.FIELDS[8] = "visibility_value_id"; | |
+json.abstract_schema.bug_type.FIELDS[9] = {}; | |
+json.abstract_schema.bug_type.FIELDS[9].TYPE = "INT2"; | |
+json.abstract_schema.bug_type.INDEXES = []; | |
+json.abstract_schema.bug_type.INDEXES[0] = "bug_type_value_idx"; | |
+json.abstract_schema.bug_type.INDEXES[1] = {}; | |
+json.abstract_schema.bug_type.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.bug_type.INDEXES[1].FIELDS[0] = "value"; | |
+json.abstract_schema.bug_type.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.bug_type.INDEXES[2] = "bug_type_sortkey_idx"; | |
+json.abstract_schema.bug_type.INDEXES[3] = []; | |
+json.abstract_schema.bug_type.INDEXES[3][0] = "sortkey"; | |
+json.abstract_schema.bug_type.INDEXES[3][1] = "value"; | |
+json.abstract_schema.bug_type.INDEXES[4] = "bug_type_visibility_value_id_idx"; | |
+json.abstract_schema.bug_type.INDEXES[5] = []; | |
+json.abstract_schema.bug_type.INDEXES[5][0] = "visibility_value_id"; | |
+json.abstract_schema.bug_user_agent = {}; | |
+json.abstract_schema.bug_user_agent.FIELDS = []; | |
+json.abstract_schema.bug_user_agent.FIELDS[0] = "id"; | |
+json.abstract_schema.bug_user_agent.FIELDS[1] = {}; | |
+json.abstract_schema.bug_user_agent.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.bug_user_agent.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.bug_user_agent.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.bug_user_agent.FIELDS[2] = "bug_id"; | |
+json.abstract_schema.bug_user_agent.FIELDS[3] = {}; | |
+json.abstract_schema.bug_user_agent.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.bug_user_agent.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.bug_user_agent.FIELDS[3].REFERENCES.COLUMN = "bug_id"; | |
+json.abstract_schema.bug_user_agent.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.bug_user_agent.FIELDS[3].REFERENCES.TABLE = "bugs"; | |
+json.abstract_schema.bug_user_agent.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.bug_user_agent.FIELDS[4] = "user_agent"; | |
+json.abstract_schema.bug_user_agent.FIELDS[5] = {}; | |
+json.abstract_schema.bug_user_agent.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.bug_user_agent.FIELDS[5].TYPE = "MEDIUMTEXT"; | |
+json.abstract_schema.bug_user_agent.INDEXES = []; | |
+json.abstract_schema.bug_user_agent.INDEXES[0] = "bug_user_agent_idx"; | |
+json.abstract_schema.bug_user_agent.INDEXES[1] = {}; | |
+json.abstract_schema.bug_user_agent.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.bug_user_agent.INDEXES[1].FIELDS[0] = "bug_id"; | |
+json.abstract_schema.bug_user_agent.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.bug_user_last_visit = {}; | |
json.abstract_schema.bug_user_last_visit.FIELDS = []; | |
json.abstract_schema.bug_user_last_visit.FIELDS[0] = "id"; | |
@@ -322,6 +533,70 @@ | |
json.abstract_schema.bug_user_last_visit.INDEXES[2] = "bug_user_last_visit_last_visit_ts_idx"; | |
json.abstract_schema.bug_user_last_visit.INDEXES[3] = []; | |
json.abstract_schema.bug_user_last_visit.INDEXES[3][0] = "last_visit_ts"; | |
+json.abstract_schema.bugmail_filters = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS = []; | |
+json.abstract_schema.bugmail_filters.FIELDS[0] = "id"; | |
+json.abstract_schema.bugmail_filters.FIELDS[1] = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.bugmail_filters.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.bugmail_filters.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.bugmail_filters.FIELDS[2] = "user_id"; | |
+json.abstract_schema.bugmail_filters.FIELDS[3] = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.bugmail_filters.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.bugmail_filters.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.bugmail_filters.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.bugmail_filters.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.bugmail_filters.FIELDS[4] = "field_name"; | |
+json.abstract_schema.bugmail_filters.FIELDS[5] = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[5].NOTNULL = 0; | |
+json.abstract_schema.bugmail_filters.FIELDS[5].TYPE = "VARCHAR(64)"; | |
+json.abstract_schema.bugmail_filters.FIELDS[6] = "product_id"; | |
+json.abstract_schema.bugmail_filters.FIELDS[7] = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[7].NOTNULL = 0; | |
+json.abstract_schema.bugmail_filters.FIELDS[7].REFERENCES = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[7].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.bugmail_filters.FIELDS[7].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.bugmail_filters.FIELDS[7].REFERENCES.TABLE = "products"; | |
+json.abstract_schema.bugmail_filters.FIELDS[7].TYPE = "INT2"; | |
+json.abstract_schema.bugmail_filters.FIELDS[8] = "component_id"; | |
+json.abstract_schema.bugmail_filters.FIELDS[9] = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[9].NOTNULL = 0; | |
+json.abstract_schema.bugmail_filters.FIELDS[9].REFERENCES = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[9].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.bugmail_filters.FIELDS[9].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.bugmail_filters.FIELDS[9].REFERENCES.TABLE = "components"; | |
+json.abstract_schema.bugmail_filters.FIELDS[9].TYPE = "INT2"; | |
+json.abstract_schema.bugmail_filters.FIELDS[10] = "changer_id"; | |
+json.abstract_schema.bugmail_filters.FIELDS[11] = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[11].NOTNULL = 0; | |
+json.abstract_schema.bugmail_filters.FIELDS[11].REFERENCES = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[11].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.bugmail_filters.FIELDS[11].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.bugmail_filters.FIELDS[11].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.bugmail_filters.FIELDS[11].TYPE = "INT3"; | |
+json.abstract_schema.bugmail_filters.FIELDS[12] = "relationship"; | |
+json.abstract_schema.bugmail_filters.FIELDS[13] = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[13].NOTNULL = 0; | |
+json.abstract_schema.bugmail_filters.FIELDS[13].TYPE = "INT2"; | |
+json.abstract_schema.bugmail_filters.FIELDS[14] = "action"; | |
+json.abstract_schema.bugmail_filters.FIELDS[15] = {}; | |
+json.abstract_schema.bugmail_filters.FIELDS[15].NOTNULL = 1; | |
+json.abstract_schema.bugmail_filters.FIELDS[15].TYPE = "INT1"; | |
+json.abstract_schema.bugmail_filters.INDEXES = []; | |
+json.abstract_schema.bugmail_filters.INDEXES[0] = "bugmail_filters_unique_idx"; | |
+json.abstract_schema.bugmail_filters.INDEXES[1] = {}; | |
+json.abstract_schema.bugmail_filters.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.bugmail_filters.INDEXES[1].FIELDS[0] = "user_id"; | |
+json.abstract_schema.bugmail_filters.INDEXES[1].FIELDS[1] = "field_name"; | |
+json.abstract_schema.bugmail_filters.INDEXES[1].FIELDS[2] = "product_id"; | |
+json.abstract_schema.bugmail_filters.INDEXES[1].FIELDS[3] = "component_id"; | |
+json.abstract_schema.bugmail_filters.INDEXES[1].FIELDS[4] = "relationship"; | |
+json.abstract_schema.bugmail_filters.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.bugmail_filters.INDEXES[2] = "bugmail_filters_user_idx"; | |
+json.abstract_schema.bugmail_filters.INDEXES[3] = []; | |
+json.abstract_schema.bugmail_filters.INDEXES[3][0] = "user_id"; | |
json.abstract_schema.bugs = {}; | |
json.abstract_schema.bugs.FIELDS = []; | |
json.abstract_schema.bugs.FIELDS[0] = "bug_id"; | |
@@ -349,148 +624,168 @@ | |
json.abstract_schema.bugs.FIELDS[9] = {}; | |
json.abstract_schema.bugs.FIELDS[9].NOTNULL = 1; | |
json.abstract_schema.bugs.FIELDS[9].TYPE = "varchar(64)"; | |
-json.abstract_schema.bugs.FIELDS[10] = "creation_ts"; | |
+json.abstract_schema.bugs.FIELDS[10] = "bug_type"; | |
json.abstract_schema.bugs.FIELDS[11] = {}; | |
-json.abstract_schema.bugs.FIELDS[11].TYPE = "DATETIME"; | |
-json.abstract_schema.bugs.FIELDS[12] = "delta_ts"; | |
+json.abstract_schema.bugs.FIELDS[11].NOTNULL = 1; | |
+json.abstract_schema.bugs.FIELDS[11].TYPE = "varchar(20)"; | |
+json.abstract_schema.bugs.FIELDS[12] = "filed_via"; | |
json.abstract_schema.bugs.FIELDS[13] = {}; | |
+json.abstract_schema.bugs.FIELDS[13].DEFAULT = "'unknown'"; | |
json.abstract_schema.bugs.FIELDS[13].NOTNULL = 1; | |
-json.abstract_schema.bugs.FIELDS[13].TYPE = "DATETIME"; | |
-json.abstract_schema.bugs.FIELDS[14] = "short_desc"; | |
+json.abstract_schema.bugs.FIELDS[13].TYPE = "varchar(40)"; | |
+json.abstract_schema.bugs.FIELDS[14] = "creation_ts"; | |
json.abstract_schema.bugs.FIELDS[15] = {}; | |
-json.abstract_schema.bugs.FIELDS[15].NOTNULL = 1; | |
-json.abstract_schema.bugs.FIELDS[15].TYPE = "varchar(255)"; | |
-json.abstract_schema.bugs.FIELDS[16] = "op_sys"; | |
+json.abstract_schema.bugs.FIELDS[15].TYPE = "DATETIME"; | |
+json.abstract_schema.bugs.FIELDS[16] = "delta_ts"; | |
json.abstract_schema.bugs.FIELDS[17] = {}; | |
json.abstract_schema.bugs.FIELDS[17].NOTNULL = 1; | |
-json.abstract_schema.bugs.FIELDS[17].TYPE = "varchar(64)"; | |
-json.abstract_schema.bugs.FIELDS[18] = "priority"; | |
+json.abstract_schema.bugs.FIELDS[17].TYPE = "DATETIME"; | |
+json.abstract_schema.bugs.FIELDS[18] = "short_desc"; | |
json.abstract_schema.bugs.FIELDS[19] = {}; | |
json.abstract_schema.bugs.FIELDS[19].NOTNULL = 1; | |
-json.abstract_schema.bugs.FIELDS[19].TYPE = "varchar(64)"; | |
-json.abstract_schema.bugs.FIELDS[20] = "product_id"; | |
+json.abstract_schema.bugs.FIELDS[19].TYPE = "varchar(255)"; | |
+json.abstract_schema.bugs.FIELDS[20] = "op_sys"; | |
json.abstract_schema.bugs.FIELDS[21] = {}; | |
json.abstract_schema.bugs.FIELDS[21].NOTNULL = 1; | |
-json.abstract_schema.bugs.FIELDS[21].REFERENCES = {}; | |
-json.abstract_schema.bugs.FIELDS[21].REFERENCES.COLUMN = "id"; | |
-json.abstract_schema.bugs.FIELDS[21].REFERENCES.TABLE = "products"; | |
-json.abstract_schema.bugs.FIELDS[21].TYPE = "INT2"; | |
-json.abstract_schema.bugs.FIELDS[22] = "rep_platform"; | |
+json.abstract_schema.bugs.FIELDS[21].TYPE = "varchar(64)"; | |
+json.abstract_schema.bugs.FIELDS[22] = "priority"; | |
json.abstract_schema.bugs.FIELDS[23] = {}; | |
json.abstract_schema.bugs.FIELDS[23].NOTNULL = 1; | |
json.abstract_schema.bugs.FIELDS[23].TYPE = "varchar(64)"; | |
-json.abstract_schema.bugs.FIELDS[24] = "reporter"; | |
+json.abstract_schema.bugs.FIELDS[24] = "product_id"; | |
json.abstract_schema.bugs.FIELDS[25] = {}; | |
json.abstract_schema.bugs.FIELDS[25].NOTNULL = 1; | |
json.abstract_schema.bugs.FIELDS[25].REFERENCES = {}; | |
-json.abstract_schema.bugs.FIELDS[25].REFERENCES.COLUMN = "userid"; | |
-json.abstract_schema.bugs.FIELDS[25].REFERENCES.TABLE = "profiles"; | |
-json.abstract_schema.bugs.FIELDS[25].TYPE = "INT3"; | |
-json.abstract_schema.bugs.FIELDS[26] = "version"; | |
+json.abstract_schema.bugs.FIELDS[25].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.bugs.FIELDS[25].REFERENCES.TABLE = "products"; | |
+json.abstract_schema.bugs.FIELDS[25].TYPE = "INT2"; | |
+json.abstract_schema.bugs.FIELDS[26] = "rep_platform"; | |
json.abstract_schema.bugs.FIELDS[27] = {}; | |
json.abstract_schema.bugs.FIELDS[27].NOTNULL = 1; | |
json.abstract_schema.bugs.FIELDS[27].TYPE = "varchar(64)"; | |
-json.abstract_schema.bugs.FIELDS[28] = "component_id"; | |
+json.abstract_schema.bugs.FIELDS[28] = "reporter"; | |
json.abstract_schema.bugs.FIELDS[29] = {}; | |
json.abstract_schema.bugs.FIELDS[29].NOTNULL = 1; | |
json.abstract_schema.bugs.FIELDS[29].REFERENCES = {}; | |
-json.abstract_schema.bugs.FIELDS[29].REFERENCES.COLUMN = "id"; | |
-json.abstract_schema.bugs.FIELDS[29].REFERENCES.TABLE = "components"; | |
+json.abstract_schema.bugs.FIELDS[29].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.bugs.FIELDS[29].REFERENCES.TABLE = "profiles"; | |
json.abstract_schema.bugs.FIELDS[29].TYPE = "INT3"; | |
-json.abstract_schema.bugs.FIELDS[30] = "resolution"; | |
+json.abstract_schema.bugs.FIELDS[30] = "version"; | |
json.abstract_schema.bugs.FIELDS[31] = {}; | |
-json.abstract_schema.bugs.FIELDS[31].DEFAULT = "''"; | |
json.abstract_schema.bugs.FIELDS[31].NOTNULL = 1; | |
json.abstract_schema.bugs.FIELDS[31].TYPE = "varchar(64)"; | |
-json.abstract_schema.bugs.FIELDS[32] = "target_milestone"; | |
+json.abstract_schema.bugs.FIELDS[32] = "component_id"; | |
json.abstract_schema.bugs.FIELDS[33] = {}; | |
-json.abstract_schema.bugs.FIELDS[33].DEFAULT = "'---'"; | |
json.abstract_schema.bugs.FIELDS[33].NOTNULL = 1; | |
-json.abstract_schema.bugs.FIELDS[33].TYPE = "varchar(64)"; | |
-json.abstract_schema.bugs.FIELDS[34] = "qa_contact"; | |
+json.abstract_schema.bugs.FIELDS[33].REFERENCES = {}; | |
+json.abstract_schema.bugs.FIELDS[33].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.bugs.FIELDS[33].REFERENCES.TABLE = "components"; | |
+json.abstract_schema.bugs.FIELDS[33].TYPE = "INT2"; | |
+json.abstract_schema.bugs.FIELDS[34] = "resolution"; | |
json.abstract_schema.bugs.FIELDS[35] = {}; | |
-json.abstract_schema.bugs.FIELDS[35].REFERENCES = {}; | |
-json.abstract_schema.bugs.FIELDS[35].REFERENCES.COLUMN = "userid"; | |
-json.abstract_schema.bugs.FIELDS[35].REFERENCES.TABLE = "profiles"; | |
-json.abstract_schema.bugs.FIELDS[35].TYPE = "INT3"; | |
-json.abstract_schema.bugs.FIELDS[36] = "status_whiteboard"; | |
+json.abstract_schema.bugs.FIELDS[35].DEFAULT = "''"; | |
+json.abstract_schema.bugs.FIELDS[35].NOTNULL = 1; | |
+json.abstract_schema.bugs.FIELDS[35].TYPE = "varchar(64)"; | |
+json.abstract_schema.bugs.FIELDS[36] = "target_milestone"; | |
json.abstract_schema.bugs.FIELDS[37] = {}; | |
-json.abstract_schema.bugs.FIELDS[37].DEFAULT = "''"; | |
+json.abstract_schema.bugs.FIELDS[37].DEFAULT = "'---'"; | |
json.abstract_schema.bugs.FIELDS[37].NOTNULL = 1; | |
-json.abstract_schema.bugs.FIELDS[37].TYPE = "MEDIUMTEXT"; | |
-json.abstract_schema.bugs.FIELDS[38] = "lastdiffed"; | |
+json.abstract_schema.bugs.FIELDS[37].TYPE = "varchar(20)"; | |
+json.abstract_schema.bugs.FIELDS[38] = "qa_contact"; | |
json.abstract_schema.bugs.FIELDS[39] = {}; | |
-json.abstract_schema.bugs.FIELDS[39].TYPE = "DATETIME"; | |
-json.abstract_schema.bugs.FIELDS[40] = "everconfirmed"; | |
+json.abstract_schema.bugs.FIELDS[39].REFERENCES = {}; | |
+json.abstract_schema.bugs.FIELDS[39].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.bugs.FIELDS[39].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.bugs.FIELDS[39].TYPE = "INT3"; | |
+json.abstract_schema.bugs.FIELDS[40] = "status_whiteboard"; | |
json.abstract_schema.bugs.FIELDS[41] = {}; | |
+json.abstract_schema.bugs.FIELDS[41].DEFAULT = "''"; | |
json.abstract_schema.bugs.FIELDS[41].NOTNULL = 1; | |
-json.abstract_schema.bugs.FIELDS[41].TYPE = "BOOLEAN"; | |
-json.abstract_schema.bugs.FIELDS[42] = "reporter_accessible"; | |
+json.abstract_schema.bugs.FIELDS[41].TYPE = "MEDIUMTEXT"; | |
+json.abstract_schema.bugs.FIELDS[42] = "lastdiffed"; | |
json.abstract_schema.bugs.FIELDS[43] = {}; | |
-json.abstract_schema.bugs.FIELDS[43].DEFAULT = "TRUE"; | |
-json.abstract_schema.bugs.FIELDS[43].NOTNULL = 1; | |
-json.abstract_schema.bugs.FIELDS[43].TYPE = "BOOLEAN"; | |
-json.abstract_schema.bugs.FIELDS[44] = "cclist_accessible"; | |
+json.abstract_schema.bugs.FIELDS[43].TYPE = "DATETIME"; | |
+json.abstract_schema.bugs.FIELDS[44] = "everconfirmed"; | |
json.abstract_schema.bugs.FIELDS[45] = {}; | |
-json.abstract_schema.bugs.FIELDS[45].DEFAULT = "TRUE"; | |
json.abstract_schema.bugs.FIELDS[45].NOTNULL = 1; | |
json.abstract_schema.bugs.FIELDS[45].TYPE = "BOOLEAN"; | |
-json.abstract_schema.bugs.FIELDS[46] = "estimated_time"; | |
+json.abstract_schema.bugs.FIELDS[46] = "reporter_accessible"; | |
json.abstract_schema.bugs.FIELDS[47] = {}; | |
-json.abstract_schema.bugs.FIELDS[47].DEFAULT = "0"; | |
+json.abstract_schema.bugs.FIELDS[47].DEFAULT = "TRUE"; | |
json.abstract_schema.bugs.FIELDS[47].NOTNULL = 1; | |
-json.abstract_schema.bugs.FIELDS[47].TYPE = "decimal(7,2)"; | |
-json.abstract_schema.bugs.FIELDS[48] = "remaining_time"; | |
+json.abstract_schema.bugs.FIELDS[47].TYPE = "BOOLEAN"; | |
+json.abstract_schema.bugs.FIELDS[48] = "cclist_accessible"; | |
json.abstract_schema.bugs.FIELDS[49] = {}; | |
-json.abstract_schema.bugs.FIELDS[49].DEFAULT = "0"; | |
+json.abstract_schema.bugs.FIELDS[49].DEFAULT = "TRUE"; | |
json.abstract_schema.bugs.FIELDS[49].NOTNULL = 1; | |
-json.abstract_schema.bugs.FIELDS[49].TYPE = "decimal(7,2)"; | |
-json.abstract_schema.bugs.FIELDS[50] = "deadline"; | |
+json.abstract_schema.bugs.FIELDS[49].TYPE = "BOOLEAN"; | |
+json.abstract_schema.bugs.FIELDS[50] = "estimated_time"; | |
json.abstract_schema.bugs.FIELDS[51] = {}; | |
-json.abstract_schema.bugs.FIELDS[51].TYPE = "DATETIME"; | |
+json.abstract_schema.bugs.FIELDS[51].DEFAULT = "0"; | |
+json.abstract_schema.bugs.FIELDS[51].NOTNULL = 1; | |
+json.abstract_schema.bugs.FIELDS[51].TYPE = "decimal(7,2)"; | |
+json.abstract_schema.bugs.FIELDS[52] = "remaining_time"; | |
+json.abstract_schema.bugs.FIELDS[53] = {}; | |
+json.abstract_schema.bugs.FIELDS[53].DEFAULT = "0"; | |
+json.abstract_schema.bugs.FIELDS[53].NOTNULL = 1; | |
+json.abstract_schema.bugs.FIELDS[53].TYPE = "decimal(7,2)"; | |
+json.abstract_schema.bugs.FIELDS[54] = "deadline"; | |
+json.abstract_schema.bugs.FIELDS[55] = {}; | |
+json.abstract_schema.bugs.FIELDS[55].TYPE = "DATETIME"; | |
+json.abstract_schema.bugs.FIELDS[56] = "alias"; | |
+json.abstract_schema.bugs.FIELDS[57] = {}; | |
+json.abstract_schema.bugs.FIELDS[57].TYPE = "varchar(40)"; | |
json.abstract_schema.bugs.INDEXES = []; | |
-json.abstract_schema.bugs.INDEXES[0] = "bugs_assigned_to_idx"; | |
-json.abstract_schema.bugs.INDEXES[1] = []; | |
-json.abstract_schema.bugs.INDEXES[1][0] = "assigned_to"; | |
-json.abstract_schema.bugs.INDEXES[2] = "bugs_creation_ts_idx"; | |
+json.abstract_schema.bugs.INDEXES[0] = "bugs_alias_idx"; | |
+json.abstract_schema.bugs.INDEXES[1] = {}; | |
+json.abstract_schema.bugs.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.bugs.INDEXES[1].FIELDS[0] = "alias"; | |
+json.abstract_schema.bugs.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.bugs.INDEXES[2] = "bugs_assigned_to_idx"; | |
json.abstract_schema.bugs.INDEXES[3] = []; | |
-json.abstract_schema.bugs.INDEXES[3][0] = "creation_ts"; | |
-json.abstract_schema.bugs.INDEXES[4] = "bugs_delta_ts_idx"; | |
+json.abstract_schema.bugs.INDEXES[3][0] = "assigned_to"; | |
+json.abstract_schema.bugs.INDEXES[4] = "bugs_creation_ts_idx"; | |
json.abstract_schema.bugs.INDEXES[5] = []; | |
-json.abstract_schema.bugs.INDEXES[5][0] = "delta_ts"; | |
-json.abstract_schema.bugs.INDEXES[6] = "bugs_bug_severity_idx"; | |
+json.abstract_schema.bugs.INDEXES[5][0] = "creation_ts"; | |
+json.abstract_schema.bugs.INDEXES[6] = "bugs_delta_ts_idx"; | |
json.abstract_schema.bugs.INDEXES[7] = []; | |
-json.abstract_schema.bugs.INDEXES[7][0] = "bug_severity"; | |
-json.abstract_schema.bugs.INDEXES[8] = "bugs_bug_status_idx"; | |
+json.abstract_schema.bugs.INDEXES[7][0] = "delta_ts"; | |
+json.abstract_schema.bugs.INDEXES[8] = "bugs_bug_severity_idx"; | |
json.abstract_schema.bugs.INDEXES[9] = []; | |
-json.abstract_schema.bugs.INDEXES[9][0] = "bug_status"; | |
-json.abstract_schema.bugs.INDEXES[10] = "bugs_op_sys_idx"; | |
+json.abstract_schema.bugs.INDEXES[9][0] = "bug_severity"; | |
+json.abstract_schema.bugs.INDEXES[10] = "bugs_bug_status_idx"; | |
json.abstract_schema.bugs.INDEXES[11] = []; | |
-json.abstract_schema.bugs.INDEXES[11][0] = "op_sys"; | |
-json.abstract_schema.bugs.INDEXES[12] = "bugs_priority_idx"; | |
+json.abstract_schema.bugs.INDEXES[11][0] = "bug_status"; | |
+json.abstract_schema.bugs.INDEXES[12] = "bugs_but_type_idx"; | |
json.abstract_schema.bugs.INDEXES[13] = []; | |
-json.abstract_schema.bugs.INDEXES[13][0] = "priority"; | |
-json.abstract_schema.bugs.INDEXES[14] = "bugs_product_id_idx"; | |
+json.abstract_schema.bugs.INDEXES[13][0] = "bug_type"; | |
+json.abstract_schema.bugs.INDEXES[14] = "bugs_op_sys_idx"; | |
json.abstract_schema.bugs.INDEXES[15] = []; | |
-json.abstract_schema.bugs.INDEXES[15][0] = "product_id"; | |
-json.abstract_schema.bugs.INDEXES[16] = "bugs_reporter_idx"; | |
+json.abstract_schema.bugs.INDEXES[15][0] = "op_sys"; | |
+json.abstract_schema.bugs.INDEXES[16] = "bugs_priority_idx"; | |
json.abstract_schema.bugs.INDEXES[17] = []; | |
-json.abstract_schema.bugs.INDEXES[17][0] = "reporter"; | |
-json.abstract_schema.bugs.INDEXES[18] = "bugs_version_idx"; | |
+json.abstract_schema.bugs.INDEXES[17][0] = "priority"; | |
+json.abstract_schema.bugs.INDEXES[18] = "bugs_product_id_idx"; | |
json.abstract_schema.bugs.INDEXES[19] = []; | |
-json.abstract_schema.bugs.INDEXES[19][0] = "version"; | |
-json.abstract_schema.bugs.INDEXES[20] = "bugs_component_id_idx"; | |
+json.abstract_schema.bugs.INDEXES[19][0] = "product_id"; | |
+json.abstract_schema.bugs.INDEXES[20] = "bugs_reporter_idx"; | |
json.abstract_schema.bugs.INDEXES[21] = []; | |
-json.abstract_schema.bugs.INDEXES[21][0] = "component_id"; | |
-json.abstract_schema.bugs.INDEXES[22] = "bugs_resolution_idx"; | |
+json.abstract_schema.bugs.INDEXES[21][0] = "reporter"; | |
+json.abstract_schema.bugs.INDEXES[22] = "bugs_version_idx"; | |
json.abstract_schema.bugs.INDEXES[23] = []; | |
-json.abstract_schema.bugs.INDEXES[23][0] = "resolution"; | |
-json.abstract_schema.bugs.INDEXES[24] = "bugs_target_milestone_idx"; | |
+json.abstract_schema.bugs.INDEXES[23][0] = "version"; | |
+json.abstract_schema.bugs.INDEXES[24] = "bugs_component_id_idx"; | |
json.abstract_schema.bugs.INDEXES[25] = []; | |
-json.abstract_schema.bugs.INDEXES[25][0] = "target_milestone"; | |
-json.abstract_schema.bugs.INDEXES[26] = "bugs_qa_contact_idx"; | |
+json.abstract_schema.bugs.INDEXES[25][0] = "component_id"; | |
+json.abstract_schema.bugs.INDEXES[26] = "bugs_resolution_idx"; | |
json.abstract_schema.bugs.INDEXES[27] = []; | |
-json.abstract_schema.bugs.INDEXES[27][0] = "qa_contact"; | |
+json.abstract_schema.bugs.INDEXES[27][0] = "resolution"; | |
+json.abstract_schema.bugs.INDEXES[28] = "bugs_target_milestone_idx"; | |
+json.abstract_schema.bugs.INDEXES[29] = []; | |
+json.abstract_schema.bugs.INDEXES[29][0] = "target_milestone"; | |
+json.abstract_schema.bugs.INDEXES[30] = "bugs_qa_contact_idx"; | |
+json.abstract_schema.bugs.INDEXES[31] = []; | |
+json.abstract_schema.bugs.INDEXES[31][0] = "qa_contact"; | |
json.abstract_schema.bugs_activity = {}; | |
json.abstract_schema.bugs_activity.FIELDS = []; | |
json.abstract_schema.bugs_activity.FIELDS[0] = "id"; | |
@@ -512,7 +807,7 @@ | |
json.abstract_schema.bugs_activity.FIELDS[5].REFERENCES.COLUMN = "attach_id"; | |
json.abstract_schema.bugs_activity.FIELDS[5].REFERENCES.DELETE = "CASCADE"; | |
json.abstract_schema.bugs_activity.FIELDS[5].REFERENCES.TABLE = "attachments"; | |
-json.abstract_schema.bugs_activity.FIELDS[5].TYPE = "INT3"; | |
+json.abstract_schema.bugs_activity.FIELDS[5].TYPE = "INT5"; | |
json.abstract_schema.bugs_activity.FIELDS[6] = "who"; | |
json.abstract_schema.bugs_activity.FIELDS[7] = {}; | |
json.abstract_schema.bugs_activity.FIELDS[7].NOTNULL = 1; | |
@@ -563,28 +858,6 @@ | |
json.abstract_schema.bugs_activity.INDEXES[10] = "bugs_activity_removed_idx"; | |
json.abstract_schema.bugs_activity.INDEXES[11] = []; | |
json.abstract_schema.bugs_activity.INDEXES[11][0] = "removed"; | |
-json.abstract_schema.bugs_aliases = {}; | |
-json.abstract_schema.bugs_aliases.FIELDS = []; | |
-json.abstract_schema.bugs_aliases.FIELDS[0] = "alias"; | |
-json.abstract_schema.bugs_aliases.FIELDS[1] = {}; | |
-json.abstract_schema.bugs_aliases.FIELDS[1].NOTNULL = 1; | |
-json.abstract_schema.bugs_aliases.FIELDS[1].TYPE = "varchar(40)"; | |
-json.abstract_schema.bugs_aliases.FIELDS[2] = "bug_id"; | |
-json.abstract_schema.bugs_aliases.FIELDS[3] = {}; | |
-json.abstract_schema.bugs_aliases.FIELDS[3].REFERENCES = {}; | |
-json.abstract_schema.bugs_aliases.FIELDS[3].REFERENCES.COLUMN = "bug_id"; | |
-json.abstract_schema.bugs_aliases.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
-json.abstract_schema.bugs_aliases.FIELDS[3].REFERENCES.TABLE = "bugs"; | |
-json.abstract_schema.bugs_aliases.FIELDS[3].TYPE = "INT3"; | |
-json.abstract_schema.bugs_aliases.INDEXES = []; | |
-json.abstract_schema.bugs_aliases.INDEXES[0] = "bugs_aliases_bug_id_idx"; | |
-json.abstract_schema.bugs_aliases.INDEXES[1] = []; | |
-json.abstract_schema.bugs_aliases.INDEXES[1][0] = "bug_id"; | |
-json.abstract_schema.bugs_aliases.INDEXES[2] = "bugs_aliases_alias_idx"; | |
-json.abstract_schema.bugs_aliases.INDEXES[3] = {}; | |
-json.abstract_schema.bugs_aliases.INDEXES[3].FIELDS = []; | |
-json.abstract_schema.bugs_aliases.INDEXES[3].FIELDS[0] = "alias"; | |
-json.abstract_schema.bugs_aliases.INDEXES[3].TYPE = "UNIQUE"; | |
json.abstract_schema.bugs_fulltext = {}; | |
json.abstract_schema.bugs_fulltext.FIELDS = []; | |
json.abstract_schema.bugs_fulltext.FIELDS[0] = "bug_id"; | |
@@ -727,7 +1000,7 @@ | |
json.abstract_schema.component_cc.FIELDS[3].REFERENCES.COLUMN = "id"; | |
json.abstract_schema.component_cc.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
json.abstract_schema.component_cc.FIELDS[3].REFERENCES.TABLE = "components"; | |
-json.abstract_schema.component_cc.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.component_cc.FIELDS[3].TYPE = "INT2"; | |
json.abstract_schema.component_cc.INDEXES = []; | |
json.abstract_schema.component_cc.INDEXES[0] = "component_cc_user_id_idx"; | |
json.abstract_schema.component_cc.INDEXES[1] = {}; | |
@@ -735,13 +1008,86 @@ | |
json.abstract_schema.component_cc.INDEXES[1].FIELDS[0] = "component_id"; | |
json.abstract_schema.component_cc.INDEXES[1].FIELDS[1] = "user_id"; | |
json.abstract_schema.component_cc.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.component_reviewers = {}; | |
+json.abstract_schema.component_reviewers.FIELDS = []; | |
+json.abstract_schema.component_reviewers.FIELDS[0] = "id"; | |
+json.abstract_schema.component_reviewers.FIELDS[1] = {}; | |
+json.abstract_schema.component_reviewers.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.component_reviewers.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.component_reviewers.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.component_reviewers.FIELDS[2] = "user_id"; | |
+json.abstract_schema.component_reviewers.FIELDS[3] = {}; | |
+json.abstract_schema.component_reviewers.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.component_reviewers.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.component_reviewers.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.component_reviewers.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.component_reviewers.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.component_reviewers.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.component_reviewers.FIELDS[4] = "display_name"; | |
+json.abstract_schema.component_reviewers.FIELDS[5] = {}; | |
+json.abstract_schema.component_reviewers.FIELDS[5].TYPE = "VARCHAR(64)"; | |
+json.abstract_schema.component_reviewers.FIELDS[6] = "component_id"; | |
+json.abstract_schema.component_reviewers.FIELDS[7] = {}; | |
+json.abstract_schema.component_reviewers.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.component_reviewers.FIELDS[7].REFERENCES = {}; | |
+json.abstract_schema.component_reviewers.FIELDS[7].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.component_reviewers.FIELDS[7].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.component_reviewers.FIELDS[7].REFERENCES.TABLE = "components"; | |
+json.abstract_schema.component_reviewers.FIELDS[7].TYPE = "INT2"; | |
+json.abstract_schema.component_reviewers.FIELDS[8] = "sortkey"; | |
+json.abstract_schema.component_reviewers.FIELDS[9] = {}; | |
+json.abstract_schema.component_reviewers.FIELDS[9].DEFAULT = 0; | |
+json.abstract_schema.component_reviewers.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.component_reviewers.FIELDS[9].TYPE = "INT2"; | |
+json.abstract_schema.component_reviewers.INDEXES = []; | |
+json.abstract_schema.component_reviewers.INDEXES[0] = "component_reviewers_idx"; | |
+json.abstract_schema.component_reviewers.INDEXES[1] = {}; | |
+json.abstract_schema.component_reviewers.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.component_reviewers.INDEXES[1].FIELDS[0] = "user_id"; | |
+json.abstract_schema.component_reviewers.INDEXES[1].FIELDS[1] = "component_id"; | |
+json.abstract_schema.component_reviewers.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.component_watch = {}; | |
+json.abstract_schema.component_watch.FIELDS = []; | |
+json.abstract_schema.component_watch.FIELDS[0] = "id"; | |
+json.abstract_schema.component_watch.FIELDS[1] = {}; | |
+json.abstract_schema.component_watch.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.component_watch.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.component_watch.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.component_watch.FIELDS[2] = "user_id"; | |
+json.abstract_schema.component_watch.FIELDS[3] = {}; | |
+json.abstract_schema.component_watch.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.component_watch.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.component_watch.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.component_watch.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.component_watch.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.component_watch.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.component_watch.FIELDS[4] = "component_id"; | |
+json.abstract_schema.component_watch.FIELDS[5] = {}; | |
+json.abstract_schema.component_watch.FIELDS[5].NOTNULL = 0; | |
+json.abstract_schema.component_watch.FIELDS[5].REFERENCES = {}; | |
+json.abstract_schema.component_watch.FIELDS[5].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.component_watch.FIELDS[5].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.component_watch.FIELDS[5].REFERENCES.TABLE = "components"; | |
+json.abstract_schema.component_watch.FIELDS[5].TYPE = "INT2"; | |
+json.abstract_schema.component_watch.FIELDS[6] = "product_id"; | |
+json.abstract_schema.component_watch.FIELDS[7] = {}; | |
+json.abstract_schema.component_watch.FIELDS[7].NOTNULL = 0; | |
+json.abstract_schema.component_watch.FIELDS[7].REFERENCES = {}; | |
+json.abstract_schema.component_watch.FIELDS[7].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.component_watch.FIELDS[7].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.component_watch.FIELDS[7].REFERENCES.TABLE = "products"; | |
+json.abstract_schema.component_watch.FIELDS[7].TYPE = "INT2"; | |
+json.abstract_schema.component_watch.FIELDS[8] = "component_prefix"; | |
+json.abstract_schema.component_watch.FIELDS[9] = {}; | |
+json.abstract_schema.component_watch.FIELDS[9].NOTNULL = 0; | |
+json.abstract_schema.component_watch.FIELDS[9].TYPE = "VARCHAR(64)"; | |
json.abstract_schema.components = {}; | |
json.abstract_schema.components.FIELDS = []; | |
json.abstract_schema.components.FIELDS[0] = "id"; | |
json.abstract_schema.components.FIELDS[1] = {}; | |
json.abstract_schema.components.FIELDS[1].NOTNULL = 1; | |
json.abstract_schema.components.FIELDS[1].PRIMARYKEY = 1; | |
-json.abstract_schema.components.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.components.FIELDS[1].TYPE = "SMALLSERIAL"; | |
json.abstract_schema.components.FIELDS[2] = "name"; | |
json.abstract_schema.components.FIELDS[3] = {}; | |
json.abstract_schema.components.FIELDS[3].NOTNULL = 1; | |
@@ -777,6 +1123,19 @@ | |
json.abstract_schema.components.FIELDS[13].DEFAULT = "TRUE"; | |
json.abstract_schema.components.FIELDS[13].NOTNULL = 1; | |
json.abstract_schema.components.FIELDS[13].TYPE = "BOOLEAN"; | |
+json.abstract_schema.components.FIELDS[14] = "triage_owner_id"; | |
+json.abstract_schema.components.FIELDS[15] = {}; | |
+json.abstract_schema.components.FIELDS[15].REFERENCES = {}; | |
+json.abstract_schema.components.FIELDS[15].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.components.FIELDS[15].REFERENCES.DELETE = "SET NULL"; | |
+json.abstract_schema.components.FIELDS[15].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.components.FIELDS[15].TYPE = "INT3"; | |
+json.abstract_schema.components.FIELDS[16] = "bug_description_template"; | |
+json.abstract_schema.components.FIELDS[17] = {}; | |
+json.abstract_schema.components.FIELDS[17].TYPE = "MEDIUMTEXT"; | |
+json.abstract_schema.components.FIELDS[18] = "default_bug_type"; | |
+json.abstract_schema.components.FIELDS[19] = {}; | |
+json.abstract_schema.components.FIELDS[19].TYPE = "varchar(20)"; | |
json.abstract_schema.components.INDEXES = []; | |
json.abstract_schema.components.INDEXES[0] = "components_product_id_idx"; | |
json.abstract_schema.components.INDEXES[1] = {}; | |
@@ -859,6 +1218,29 @@ | |
json.abstract_schema.email_bug_ignore.INDEXES[1].FIELDS[0] = "user_id"; | |
json.abstract_schema.email_bug_ignore.INDEXES[1].FIELDS[1] = "bug_id"; | |
json.abstract_schema.email_bug_ignore.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.email_rates = {}; | |
+json.abstract_schema.email_rates.FIELDS = []; | |
+json.abstract_schema.email_rates.FIELDS[0] = "id"; | |
+json.abstract_schema.email_rates.FIELDS[1] = {}; | |
+json.abstract_schema.email_rates.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.email_rates.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.email_rates.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.email_rates.FIELDS[2] = "recipient"; | |
+json.abstract_schema.email_rates.FIELDS[3] = {}; | |
+json.abstract_schema.email_rates.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.email_rates.FIELDS[3].TYPE = "varchar(255)"; | |
+json.abstract_schema.email_rates.FIELDS[4] = "message_ts"; | |
+json.abstract_schema.email_rates.FIELDS[5] = {}; | |
+json.abstract_schema.email_rates.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.email_rates.FIELDS[5].TYPE = "DATETIME"; | |
+json.abstract_schema.email_rates.INDEXES = []; | |
+json.abstract_schema.email_rates.INDEXES[0] = "email_rates_idx"; | |
+json.abstract_schema.email_rates.INDEXES[1] = []; | |
+json.abstract_schema.email_rates.INDEXES[1][0] = "recipient"; | |
+json.abstract_schema.email_rates.INDEXES[1][1] = "message_ts"; | |
+json.abstract_schema.email_rates.INDEXES[2] = "email_rates_message_ts_idx"; | |
+json.abstract_schema.email_rates.INDEXES[3] = []; | |
+json.abstract_schema.email_rates.INDEXES[3][0] = "message_ts"; | |
json.abstract_schema.email_setting = {}; | |
json.abstract_schema.email_setting.FIELDS = []; | |
json.abstract_schema.email_setting.FIELDS[0] = "user_id"; | |
@@ -930,60 +1312,55 @@ | |
json.abstract_schema.fielddefs.FIELDS[9] = {}; | |
json.abstract_schema.fielddefs.FIELDS[9].NOTNULL = 1; | |
json.abstract_schema.fielddefs.FIELDS[9].TYPE = "TINYTEXT"; | |
-json.abstract_schema.fielddefs.FIELDS[10] = "long_desc"; | |
+json.abstract_schema.fielddefs.FIELDS[10] = "mailhead"; | |
json.abstract_schema.fielddefs.FIELDS[11] = {}; | |
-json.abstract_schema.fielddefs.FIELDS[11].DEFAULT = "''"; | |
+json.abstract_schema.fielddefs.FIELDS[11].DEFAULT = "FALSE"; | |
json.abstract_schema.fielddefs.FIELDS[11].NOTNULL = 1; | |
-json.abstract_schema.fielddefs.FIELDS[11].TYPE = "varchar(255)"; | |
-json.abstract_schema.fielddefs.FIELDS[12] = "mailhead"; | |
+json.abstract_schema.fielddefs.FIELDS[11].TYPE = "BOOLEAN"; | |
+json.abstract_schema.fielddefs.FIELDS[12] = "sortkey"; | |
json.abstract_schema.fielddefs.FIELDS[13] = {}; | |
-json.abstract_schema.fielddefs.FIELDS[13].DEFAULT = "FALSE"; | |
json.abstract_schema.fielddefs.FIELDS[13].NOTNULL = 1; | |
-json.abstract_schema.fielddefs.FIELDS[13].TYPE = "BOOLEAN"; | |
-json.abstract_schema.fielddefs.FIELDS[14] = "sortkey"; | |
+json.abstract_schema.fielddefs.FIELDS[13].TYPE = "INT2"; | |
+json.abstract_schema.fielddefs.FIELDS[14] = "obsolete"; | |
json.abstract_schema.fielddefs.FIELDS[15] = {}; | |
+json.abstract_schema.fielddefs.FIELDS[15].DEFAULT = "FALSE"; | |
json.abstract_schema.fielddefs.FIELDS[15].NOTNULL = 1; | |
-json.abstract_schema.fielddefs.FIELDS[15].TYPE = "INT2"; | |
-json.abstract_schema.fielddefs.FIELDS[16] = "obsolete"; | |
+json.abstract_schema.fielddefs.FIELDS[15].TYPE = "BOOLEAN"; | |
+json.abstract_schema.fielddefs.FIELDS[16] = "enter_bug"; | |
json.abstract_schema.fielddefs.FIELDS[17] = {}; | |
json.abstract_schema.fielddefs.FIELDS[17].DEFAULT = "FALSE"; | |
json.abstract_schema.fielddefs.FIELDS[17].NOTNULL = 1; | |
json.abstract_schema.fielddefs.FIELDS[17].TYPE = "BOOLEAN"; | |
-json.abstract_schema.fielddefs.FIELDS[18] = "enter_bug"; | |
+json.abstract_schema.fielddefs.FIELDS[18] = "buglist"; | |
json.abstract_schema.fielddefs.FIELDS[19] = {}; | |
json.abstract_schema.fielddefs.FIELDS[19].DEFAULT = "FALSE"; | |
json.abstract_schema.fielddefs.FIELDS[19].NOTNULL = 1; | |
json.abstract_schema.fielddefs.FIELDS[19].TYPE = "BOOLEAN"; | |
-json.abstract_schema.fielddefs.FIELDS[20] = "buglist"; | |
+json.abstract_schema.fielddefs.FIELDS[20] = "visibility_field_id"; | |
json.abstract_schema.fielddefs.FIELDS[21] = {}; | |
-json.abstract_schema.fielddefs.FIELDS[21].DEFAULT = "FALSE"; | |
-json.abstract_schema.fielddefs.FIELDS[21].NOTNULL = 1; | |
-json.abstract_schema.fielddefs.FIELDS[21].TYPE = "BOOLEAN"; | |
-json.abstract_schema.fielddefs.FIELDS[22] = "visibility_field_id"; | |
+json.abstract_schema.fielddefs.FIELDS[21].REFERENCES = {}; | |
+json.abstract_schema.fielddefs.FIELDS[21].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.fielddefs.FIELDS[21].REFERENCES.TABLE = "fielddefs"; | |
+json.abstract_schema.fielddefs.FIELDS[21].TYPE = "INT3"; | |
+json.abstract_schema.fielddefs.FIELDS[22] = "value_field_id"; | |
json.abstract_schema.fielddefs.FIELDS[23] = {}; | |
json.abstract_schema.fielddefs.FIELDS[23].REFERENCES = {}; | |
json.abstract_schema.fielddefs.FIELDS[23].REFERENCES.COLUMN = "id"; | |
json.abstract_schema.fielddefs.FIELDS[23].REFERENCES.TABLE = "fielddefs"; | |
json.abstract_schema.fielddefs.FIELDS[23].TYPE = "INT3"; | |
-json.abstract_schema.fielddefs.FIELDS[24] = "value_field_id"; | |
+json.abstract_schema.fielddefs.FIELDS[24] = "reverse_desc"; | |
json.abstract_schema.fielddefs.FIELDS[25] = {}; | |
-json.abstract_schema.fielddefs.FIELDS[25].REFERENCES = {}; | |
-json.abstract_schema.fielddefs.FIELDS[25].REFERENCES.COLUMN = "id"; | |
-json.abstract_schema.fielddefs.FIELDS[25].REFERENCES.TABLE = "fielddefs"; | |
-json.abstract_schema.fielddefs.FIELDS[25].TYPE = "INT3"; | |
-json.abstract_schema.fielddefs.FIELDS[26] = "reverse_desc"; | |
+json.abstract_schema.fielddefs.FIELDS[25].TYPE = "TINYTEXT"; | |
+json.abstract_schema.fielddefs.FIELDS[26] = "is_mandatory"; | |
json.abstract_schema.fielddefs.FIELDS[27] = {}; | |
-json.abstract_schema.fielddefs.FIELDS[27].TYPE = "TINYTEXT"; | |
-json.abstract_schema.fielddefs.FIELDS[28] = "is_mandatory"; | |
+json.abstract_schema.fielddefs.FIELDS[27].DEFAULT = "FALSE"; | |
+json.abstract_schema.fielddefs.FIELDS[27].NOTNULL = 1; | |
+json.abstract_schema.fielddefs.FIELDS[27].TYPE = "BOOLEAN"; | |
+json.abstract_schema.fielddefs.FIELDS[28] = "is_numeric"; | |
json.abstract_schema.fielddefs.FIELDS[29] = {}; | |
json.abstract_schema.fielddefs.FIELDS[29].DEFAULT = "FALSE"; | |
json.abstract_schema.fielddefs.FIELDS[29].NOTNULL = 1; | |
json.abstract_schema.fielddefs.FIELDS[29].TYPE = "BOOLEAN"; | |
-json.abstract_schema.fielddefs.FIELDS[30] = "is_numeric"; | |
-json.abstract_schema.fielddefs.FIELDS[31] = {}; | |
-json.abstract_schema.fielddefs.FIELDS[31].DEFAULT = "FALSE"; | |
-json.abstract_schema.fielddefs.FIELDS[31].NOTNULL = 1; | |
-json.abstract_schema.fielddefs.FIELDS[31].TYPE = "BOOLEAN"; | |
json.abstract_schema.fielddefs.INDEXES = []; | |
json.abstract_schema.fielddefs.INDEXES[0] = "fielddefs_name_idx"; | |
json.abstract_schema.fielddefs.INDEXES[1] = {}; | |
@@ -999,6 +1376,61 @@ | |
json.abstract_schema.fielddefs.INDEXES[6] = "fielddefs_is_mandatory_idx"; | |
json.abstract_schema.fielddefs.INDEXES[7] = []; | |
json.abstract_schema.fielddefs.INDEXES[7][0] = "is_mandatory"; | |
+json.abstract_schema.flag_state_activity = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS = []; | |
+json.abstract_schema.flag_state_activity.FIELDS[0] = "id"; | |
+json.abstract_schema.flag_state_activity.FIELDS[1] = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.flag_state_activity.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.flag_state_activity.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.flag_state_activity.FIELDS[2] = "flag_when"; | |
+json.abstract_schema.flag_state_activity.FIELDS[3] = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.flag_state_activity.FIELDS[3].TYPE = "DATETIME"; | |
+json.abstract_schema.flag_state_activity.FIELDS[4] = "type_id"; | |
+json.abstract_schema.flag_state_activity.FIELDS[5] = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.flag_state_activity.FIELDS[5].REFERENCES = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[5].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.flag_state_activity.FIELDS[5].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.flag_state_activity.FIELDS[5].REFERENCES.TABLE = "flagtypes"; | |
+json.abstract_schema.flag_state_activity.FIELDS[5].TYPE = "INT2"; | |
+json.abstract_schema.flag_state_activity.FIELDS[6] = "flag_id"; | |
+json.abstract_schema.flag_state_activity.FIELDS[7] = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.flag_state_activity.FIELDS[7].TYPE = "INT3"; | |
+json.abstract_schema.flag_state_activity.FIELDS[8] = "setter_id"; | |
+json.abstract_schema.flag_state_activity.FIELDS[9] = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.flag_state_activity.FIELDS[9].REFERENCES = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[9].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.flag_state_activity.FIELDS[9].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.flag_state_activity.FIELDS[9].TYPE = "INT3"; | |
+json.abstract_schema.flag_state_activity.FIELDS[10] = "requestee_id"; | |
+json.abstract_schema.flag_state_activity.FIELDS[11] = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[11].REFERENCES = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[11].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.flag_state_activity.FIELDS[11].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.flag_state_activity.FIELDS[11].TYPE = "INT3"; | |
+json.abstract_schema.flag_state_activity.FIELDS[12] = "bug_id"; | |
+json.abstract_schema.flag_state_activity.FIELDS[13] = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[13].NOTNULL = 1; | |
+json.abstract_schema.flag_state_activity.FIELDS[13].REFERENCES = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[13].REFERENCES.COLUMN = "bug_id"; | |
+json.abstract_schema.flag_state_activity.FIELDS[13].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.flag_state_activity.FIELDS[13].REFERENCES.TABLE = "bugs"; | |
+json.abstract_schema.flag_state_activity.FIELDS[13].TYPE = "INT3"; | |
+json.abstract_schema.flag_state_activity.FIELDS[14] = "attachment_id"; | |
+json.abstract_schema.flag_state_activity.FIELDS[15] = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[15].REFERENCES = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[15].REFERENCES.COLUMN = "attach_id"; | |
+json.abstract_schema.flag_state_activity.FIELDS[15].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.flag_state_activity.FIELDS[15].REFERENCES.TABLE = "attachments"; | |
+json.abstract_schema.flag_state_activity.FIELDS[15].TYPE = "INT5"; | |
+json.abstract_schema.flag_state_activity.FIELDS[16] = "status"; | |
+json.abstract_schema.flag_state_activity.FIELDS[17] = {}; | |
+json.abstract_schema.flag_state_activity.FIELDS[17].NOTNULL = 1; | |
+json.abstract_schema.flag_state_activity.FIELDS[17].TYPE = "CHAR(1)"; | |
json.abstract_schema.flagexclusions = {}; | |
json.abstract_schema.flagexclusions.FIELDS = []; | |
json.abstract_schema.flagexclusions.FIELDS[0] = "type_id"; | |
@@ -1008,7 +1440,7 @@ | |
json.abstract_schema.flagexclusions.FIELDS[1].REFERENCES.COLUMN = "id"; | |
json.abstract_schema.flagexclusions.FIELDS[1].REFERENCES.DELETE = "CASCADE"; | |
json.abstract_schema.flagexclusions.FIELDS[1].REFERENCES.TABLE = "flagtypes"; | |
-json.abstract_schema.flagexclusions.FIELDS[1].TYPE = "INT3"; | |
+json.abstract_schema.flagexclusions.FIELDS[1].TYPE = "INT2"; | |
json.abstract_schema.flagexclusions.FIELDS[2] = "product_id"; | |
json.abstract_schema.flagexclusions.FIELDS[3] = {}; | |
json.abstract_schema.flagexclusions.FIELDS[3].REFERENCES = {}; | |
@@ -1022,7 +1454,7 @@ | |
json.abstract_schema.flagexclusions.FIELDS[5].REFERENCES.COLUMN = "id"; | |
json.abstract_schema.flagexclusions.FIELDS[5].REFERENCES.DELETE = "CASCADE"; | |
json.abstract_schema.flagexclusions.FIELDS[5].REFERENCES.TABLE = "components"; | |
-json.abstract_schema.flagexclusions.FIELDS[5].TYPE = "INT3"; | |
+json.abstract_schema.flagexclusions.FIELDS[5].TYPE = "INT2"; | |
json.abstract_schema.flagexclusions.INDEXES = []; | |
json.abstract_schema.flagexclusions.INDEXES[0] = "flagexclusions_type_id_idx"; | |
json.abstract_schema.flagexclusions.INDEXES[1] = {}; | |
@@ -1040,7 +1472,7 @@ | |
json.abstract_schema.flaginclusions.FIELDS[1].REFERENCES.COLUMN = "id"; | |
json.abstract_schema.flaginclusions.FIELDS[1].REFERENCES.DELETE = "CASCADE"; | |
json.abstract_schema.flaginclusions.FIELDS[1].REFERENCES.TABLE = "flagtypes"; | |
-json.abstract_schema.flaginclusions.FIELDS[1].TYPE = "INT3"; | |
+json.abstract_schema.flaginclusions.FIELDS[1].TYPE = "INT2"; | |
json.abstract_schema.flaginclusions.FIELDS[2] = "product_id"; | |
json.abstract_schema.flaginclusions.FIELDS[3] = {}; | |
json.abstract_schema.flaginclusions.FIELDS[3].REFERENCES = {}; | |
@@ -1054,7 +1486,7 @@ | |
json.abstract_schema.flaginclusions.FIELDS[5].REFERENCES.COLUMN = "id"; | |
json.abstract_schema.flaginclusions.FIELDS[5].REFERENCES.DELETE = "CASCADE"; | |
json.abstract_schema.flaginclusions.FIELDS[5].REFERENCES.TABLE = "components"; | |
-json.abstract_schema.flaginclusions.FIELDS[5].TYPE = "INT3"; | |
+json.abstract_schema.flaginclusions.FIELDS[5].TYPE = "INT2"; | |
json.abstract_schema.flaginclusions.INDEXES = []; | |
json.abstract_schema.flaginclusions.INDEXES[0] = "flaginclusions_type_id_idx"; | |
json.abstract_schema.flaginclusions.INDEXES[1] = {}; | |
@@ -1077,7 +1509,7 @@ | |
json.abstract_schema.flags.FIELDS[3].REFERENCES.COLUMN = "id"; | |
json.abstract_schema.flags.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
json.abstract_schema.flags.FIELDS[3].REFERENCES.TABLE = "flagtypes"; | |
-json.abstract_schema.flags.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.flags.FIELDS[3].TYPE = "INT2"; | |
json.abstract_schema.flags.FIELDS[4] = "status"; | |
json.abstract_schema.flags.FIELDS[5] = {}; | |
json.abstract_schema.flags.FIELDS[5].NOTNULL = 1; | |
@@ -1096,7 +1528,7 @@ | |
json.abstract_schema.flags.FIELDS[9].REFERENCES.COLUMN = "attach_id"; | |
json.abstract_schema.flags.FIELDS[9].REFERENCES.DELETE = "CASCADE"; | |
json.abstract_schema.flags.FIELDS[9].REFERENCES.TABLE = "attachments"; | |
-json.abstract_schema.flags.FIELDS[9].TYPE = "INT3"; | |
+json.abstract_schema.flags.FIELDS[9].TYPE = "INT5"; | |
json.abstract_schema.flags.FIELDS[10] = "creation_date"; | |
json.abstract_schema.flags.FIELDS[11] = {}; | |
json.abstract_schema.flags.FIELDS[11].NOTNULL = 1; | |
@@ -1131,13 +1563,35 @@ | |
json.abstract_schema.flags.INDEXES[6] = "flags_type_id_idx"; | |
json.abstract_schema.flags.INDEXES[7] = []; | |
json.abstract_schema.flags.INDEXES[7][0] = "type_id"; | |
+json.abstract_schema.flagtype_comments = {}; | |
+json.abstract_schema.flagtype_comments.FIELDS = []; | |
+json.abstract_schema.flagtype_comments.FIELDS[0] = "type_id"; | |
+json.abstract_schema.flagtype_comments.FIELDS[1] = {}; | |
+json.abstract_schema.flagtype_comments.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.flagtype_comments.FIELDS[1].REFERENCES = {}; | |
+json.abstract_schema.flagtype_comments.FIELDS[1].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.flagtype_comments.FIELDS[1].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.flagtype_comments.FIELDS[1].REFERENCES.TABLE = "flagtypes"; | |
+json.abstract_schema.flagtype_comments.FIELDS[1].TYPE = "SMALLINT(6)"; | |
+json.abstract_schema.flagtype_comments.FIELDS[2] = "on_status"; | |
+json.abstract_schema.flagtype_comments.FIELDS[3] = {}; | |
+json.abstract_schema.flagtype_comments.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.flagtype_comments.FIELDS[3].TYPE = "CHAR(1)"; | |
+json.abstract_schema.flagtype_comments.FIELDS[4] = "comment"; | |
+json.abstract_schema.flagtype_comments.FIELDS[5] = {}; | |
+json.abstract_schema.flagtype_comments.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.flagtype_comments.FIELDS[5].TYPE = "MEDIUMTEXT"; | |
+json.abstract_schema.flagtype_comments.INDEXES = []; | |
+json.abstract_schema.flagtype_comments.INDEXES[0] = "flagtype_comments_idx"; | |
+json.abstract_schema.flagtype_comments.INDEXES[1] = []; | |
+json.abstract_schema.flagtype_comments.INDEXES[1][0] = "type_id"; | |
json.abstract_schema.flagtypes = {}; | |
json.abstract_schema.flagtypes.FIELDS = []; | |
json.abstract_schema.flagtypes.FIELDS[0] = "id"; | |
json.abstract_schema.flagtypes.FIELDS[1] = {}; | |
json.abstract_schema.flagtypes.FIELDS[1].NOTNULL = 1; | |
json.abstract_schema.flagtypes.FIELDS[1].PRIMARYKEY = 1; | |
-json.abstract_schema.flagtypes.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.flagtypes.FIELDS[1].TYPE = "SMALLSERIAL"; | |
json.abstract_schema.flagtypes.FIELDS[2] = "name"; | |
json.abstract_schema.flagtypes.FIELDS[3] = {}; | |
json.abstract_schema.flagtypes.FIELDS[3].NOTNULL = 1; | |
@@ -1319,12 +1773,44 @@ | |
json.abstract_schema.groups.FIELDS[12] = "icon_url"; | |
json.abstract_schema.groups.FIELDS[13] = {}; | |
json.abstract_schema.groups.FIELDS[13].TYPE = "TINYTEXT"; | |
+json.abstract_schema.groups.FIELDS[14] = "owner_user_id"; | |
+json.abstract_schema.groups.FIELDS[15] = {}; | |
+json.abstract_schema.groups.FIELDS[15].REFERENCES = {}; | |
+json.abstract_schema.groups.FIELDS[15].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.groups.FIELDS[15].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.groups.FIELDS[15].TYPE = "INT3"; | |
+json.abstract_schema.groups.FIELDS[16] = "idle_member_removal"; | |
+json.abstract_schema.groups.FIELDS[17] = {}; | |
+json.abstract_schema.groups.FIELDS[17].DEFAULT = "0"; | |
+json.abstract_schema.groups.FIELDS[17].NOTNULL = 1; | |
+json.abstract_schema.groups.FIELDS[17].TYPE = "INT2"; | |
json.abstract_schema.groups.INDEXES = []; | |
json.abstract_schema.groups.INDEXES[0] = "groups_name_idx"; | |
json.abstract_schema.groups.INDEXES[1] = {}; | |
json.abstract_schema.groups.INDEXES[1].FIELDS = []; | |
json.abstract_schema.groups.INDEXES[1].FIELDS[0] = "name"; | |
json.abstract_schema.groups.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.job_last_run = {}; | |
+json.abstract_schema.job_last_run.FIELDS = []; | |
+json.abstract_schema.job_last_run.FIELDS[0] = "id"; | |
+json.abstract_schema.job_last_run.FIELDS[1] = {}; | |
+json.abstract_schema.job_last_run.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.job_last_run.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.job_last_run.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.job_last_run.FIELDS[2] = "name"; | |
+json.abstract_schema.job_last_run.FIELDS[3] = {}; | |
+json.abstract_schema.job_last_run.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.job_last_run.FIELDS[3].TYPE = "VARCHAR(100)"; | |
+json.abstract_schema.job_last_run.FIELDS[4] = "last_run"; | |
+json.abstract_schema.job_last_run.FIELDS[5] = {}; | |
+json.abstract_schema.job_last_run.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.job_last_run.FIELDS[5].TYPE = "DATETIME"; | |
+json.abstract_schema.job_last_run.INDEXES = []; | |
+json.abstract_schema.job_last_run.INDEXES[0] = "job_last_run_name_idx"; | |
+json.abstract_schema.job_last_run.INDEXES[1] = {}; | |
+json.abstract_schema.job_last_run.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.job_last_run.INDEXES[1].FIELDS[0] = "name"; | |
+json.abstract_schema.job_last_run.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.keyworddefs = {}; | |
json.abstract_schema.keyworddefs.FIELDS = []; | |
json.abstract_schema.keyworddefs.FIELDS[0] = "id"; | |
@@ -1340,6 +1826,11 @@ | |
json.abstract_schema.keyworddefs.FIELDS[5] = {}; | |
json.abstract_schema.keyworddefs.FIELDS[5].NOTNULL = 1; | |
json.abstract_schema.keyworddefs.FIELDS[5].TYPE = "MEDIUMTEXT"; | |
+json.abstract_schema.keyworddefs.FIELDS[6] = "is_active"; | |
+json.abstract_schema.keyworddefs.FIELDS[7] = {}; | |
+json.abstract_schema.keyworddefs.FIELDS[7].DEFAULT = "TRUE"; | |
+json.abstract_schema.keyworddefs.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.keyworddefs.FIELDS[7].TYPE = "BOOLEAN"; | |
json.abstract_schema.keyworddefs.INDEXES = []; | |
json.abstract_schema.keyworddefs.INDEXES[0] = "keyworddefs_name_idx"; | |
json.abstract_schema.keyworddefs.INDEXES[1] = {}; | |
@@ -1401,8 +1892,7 @@ | |
json.abstract_schema.logincookies.FIELDS[0] = "cookie"; | |
json.abstract_schema.logincookies.FIELDS[1] = {}; | |
json.abstract_schema.logincookies.FIELDS[1].NOTNULL = 1; | |
-json.abstract_schema.logincookies.FIELDS[1].PRIMARYKEY = 1; | |
-json.abstract_schema.logincookies.FIELDS[1].TYPE = "varchar(16)"; | |
+json.abstract_schema.logincookies.FIELDS[1].TYPE = "varchar(22)"; | |
json.abstract_schema.logincookies.FIELDS[2] = "userid"; | |
json.abstract_schema.logincookies.FIELDS[3] = {}; | |
json.abstract_schema.logincookies.FIELDS[3].NOTNULL = 1; | |
@@ -1418,10 +1908,25 @@ | |
json.abstract_schema.logincookies.FIELDS[7] = {}; | |
json.abstract_schema.logincookies.FIELDS[7].NOTNULL = 1; | |
json.abstract_schema.logincookies.FIELDS[7].TYPE = "DATETIME"; | |
+json.abstract_schema.logincookies.FIELDS[8] = "id"; | |
+json.abstract_schema.logincookies.FIELDS[9] = {}; | |
+json.abstract_schema.logincookies.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.logincookies.FIELDS[9].PRIMARYKEY = 1; | |
+json.abstract_schema.logincookies.FIELDS[9].TYPE = "INTSERIAL"; | |
+json.abstract_schema.logincookies.FIELDS[10] = "restrict_ipaddr"; | |
+json.abstract_schema.logincookies.FIELDS[11] = {}; | |
+json.abstract_schema.logincookies.FIELDS[11].DEFAULT = 0; | |
+json.abstract_schema.logincookies.FIELDS[11].NOTNULL = 1; | |
+json.abstract_schema.logincookies.FIELDS[11].TYPE = "BOOLEAN"; | |
json.abstract_schema.logincookies.INDEXES = []; | |
json.abstract_schema.logincookies.INDEXES[0] = "logincookies_lastused_idx"; | |
json.abstract_schema.logincookies.INDEXES[1] = []; | |
json.abstract_schema.logincookies.INDEXES[1][0] = "lastused"; | |
+json.abstract_schema.logincookies.INDEXES[2] = "logincookies_cookie_idx"; | |
+json.abstract_schema.logincookies.INDEXES[3] = {}; | |
+json.abstract_schema.logincookies.INDEXES[3].FIELDS = []; | |
+json.abstract_schema.logincookies.INDEXES[3].FIELDS[0] = "cookie"; | |
+json.abstract_schema.logincookies.INDEXES[3].TYPE = "UNIQUE"; | |
json.abstract_schema.longdescs = {}; | |
json.abstract_schema.longdescs.FIELDS = []; | |
json.abstract_schema.longdescs.FIELDS[0] = "comment_id"; | |
@@ -1475,11 +1980,15 @@ | |
json.abstract_schema.longdescs.FIELDS[18] = "extra_data"; | |
json.abstract_schema.longdescs.FIELDS[19] = {}; | |
json.abstract_schema.longdescs.FIELDS[19].TYPE = "varchar(255)"; | |
+json.abstract_schema.longdescs.FIELDS[20] = "is_markdown"; | |
+json.abstract_schema.longdescs.FIELDS[21] = {}; | |
+json.abstract_schema.longdescs.FIELDS[21].DEFAULT = "FALSE"; | |
+json.abstract_schema.longdescs.FIELDS[21].NOTNULL = 1; | |
+json.abstract_schema.longdescs.FIELDS[21].TYPE = "BOOLEAN"; | |
json.abstract_schema.longdescs.INDEXES = []; | |
json.abstract_schema.longdescs.INDEXES[0] = "longdescs_bug_id_idx"; | |
json.abstract_schema.longdescs.INDEXES[1] = []; | |
json.abstract_schema.longdescs.INDEXES[1][0] = "bug_id"; | |
-json.abstract_schema.longdescs.INDEXES[1][1] = "work_time"; | |
json.abstract_schema.longdescs.INDEXES[2] = "longdescs_who_idx"; | |
json.abstract_schema.longdescs.INDEXES[3] = []; | |
json.abstract_schema.longdescs.INDEXES[3][0] = "who"; | |
@@ -1487,6 +1996,48 @@ | |
json.abstract_schema.longdescs.INDEXES[4] = "longdescs_bug_when_idx"; | |
json.abstract_schema.longdescs.INDEXES[5] = []; | |
json.abstract_schema.longdescs.INDEXES[5][0] = "bug_when"; | |
+json.abstract_schema.longdescs_activity = {}; | |
+json.abstract_schema.longdescs_activity.FIELDS = []; | |
+json.abstract_schema.longdescs_activity.FIELDS[0] = "comment_id"; | |
+json.abstract_schema.longdescs_activity.FIELDS[1] = {}; | |
+json.abstract_schema.longdescs_activity.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.longdescs_activity.FIELDS[1].REFERENCES = {}; | |
+json.abstract_schema.longdescs_activity.FIELDS[1].REFERENCES.COLUMN = "comment_id"; | |
+json.abstract_schema.longdescs_activity.FIELDS[1].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.longdescs_activity.FIELDS[1].REFERENCES.TABLE = "longdescs"; | |
+json.abstract_schema.longdescs_activity.FIELDS[1].TYPE = "INT"; | |
+json.abstract_schema.longdescs_activity.FIELDS[2] = "who"; | |
+json.abstract_schema.longdescs_activity.FIELDS[3] = {}; | |
+json.abstract_schema.longdescs_activity.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.longdescs_activity.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.longdescs_activity.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.longdescs_activity.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.longdescs_activity.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.longdescs_activity.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.longdescs_activity.FIELDS[4] = "change_when"; | |
+json.abstract_schema.longdescs_activity.FIELDS[5] = {}; | |
+json.abstract_schema.longdescs_activity.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.longdescs_activity.FIELDS[5].TYPE = "DATETIME"; | |
+json.abstract_schema.longdescs_activity.FIELDS[6] = "old_comment"; | |
+json.abstract_schema.longdescs_activity.FIELDS[7] = {}; | |
+json.abstract_schema.longdescs_activity.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.longdescs_activity.FIELDS[7].TYPE = "LONGTEXT"; | |
+json.abstract_schema.longdescs_activity.FIELDS[8] = "is_hidden"; | |
+json.abstract_schema.longdescs_activity.FIELDS[9] = {}; | |
+json.abstract_schema.longdescs_activity.FIELDS[9].DEFAULT = 0; | |
+json.abstract_schema.longdescs_activity.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.longdescs_activity.FIELDS[9].TYPE = "BOOLEAN"; | |
+json.abstract_schema.longdescs_activity.INDEXES = []; | |
+json.abstract_schema.longdescs_activity.INDEXES[0] = "longdescs_activity_comment_id_idx"; | |
+json.abstract_schema.longdescs_activity.INDEXES[1] = []; | |
+json.abstract_schema.longdescs_activity.INDEXES[1][0] = "comment_id"; | |
+json.abstract_schema.longdescs_activity.INDEXES[2] = "longdescs_activity_change_when_idx"; | |
+json.abstract_schema.longdescs_activity.INDEXES[3] = []; | |
+json.abstract_schema.longdescs_activity.INDEXES[3][0] = "change_when"; | |
+json.abstract_schema.longdescs_activity.INDEXES[4] = "longdescs_activity_comment_id_change_when_idx"; | |
+json.abstract_schema.longdescs_activity.INDEXES[5] = []; | |
+json.abstract_schema.longdescs_activity.INDEXES[5][0] = "comment_id"; | |
+json.abstract_schema.longdescs_activity.INDEXES[5][1] = "change_when"; | |
json.abstract_schema.longdescs_tags = {}; | |
json.abstract_schema.longdescs_tags.FIELDS = []; | |
json.abstract_schema.longdescs_tags.FIELDS[0] = "id"; | |
@@ -1576,17 +2127,6 @@ | |
json.abstract_schema.longdescs_tags_weights.INDEXES[1].FIELDS = []; | |
json.abstract_schema.longdescs_tags_weights.INDEXES[1].FIELDS[0] = "tag"; | |
json.abstract_schema.longdescs_tags_weights.INDEXES[1].TYPE = "UNIQUE"; | |
-json.abstract_schema.mail_staging = {}; | |
-json.abstract_schema.mail_staging.FIELDS = []; | |
-json.abstract_schema.mail_staging.FIELDS[0] = "id"; | |
-json.abstract_schema.mail_staging.FIELDS[1] = {}; | |
-json.abstract_schema.mail_staging.FIELDS[1].NOTNULL = 1; | |
-json.abstract_schema.mail_staging.FIELDS[1].PRIMARYKEY = 1; | |
-json.abstract_schema.mail_staging.FIELDS[1].TYPE = "INTSERIAL"; | |
-json.abstract_schema.mail_staging.FIELDS[2] = "message"; | |
-json.abstract_schema.mail_staging.FIELDS[3] = {}; | |
-json.abstract_schema.mail_staging.FIELDS[3].NOTNULL = 1; | |
-json.abstract_schema.mail_staging.FIELDS[3].TYPE = "LONGBLOB"; | |
json.abstract_schema.milestones = {}; | |
json.abstract_schema.milestones.FIELDS = []; | |
json.abstract_schema.milestones.FIELDS[0] = "id"; | |
@@ -1605,7 +2145,7 @@ | |
json.abstract_schema.milestones.FIELDS[4] = "value"; | |
json.abstract_schema.milestones.FIELDS[5] = {}; | |
json.abstract_schema.milestones.FIELDS[5].NOTNULL = 1; | |
-json.abstract_schema.milestones.FIELDS[5].TYPE = "varchar(64)"; | |
+json.abstract_schema.milestones.FIELDS[5].TYPE = "varchar(20)"; | |
json.abstract_schema.milestones.FIELDS[6] = "sortkey"; | |
json.abstract_schema.milestones.FIELDS[7] = {}; | |
json.abstract_schema.milestones.FIELDS[7].DEFAULT = 0; | |
@@ -1623,6 +2163,119 @@ | |
json.abstract_schema.milestones.INDEXES[1].FIELDS[0] = "product_id"; | |
json.abstract_schema.milestones.INDEXES[1].FIELDS[1] = "value"; | |
json.abstract_schema.milestones.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.mydashboard = {}; | |
+json.abstract_schema.mydashboard.FIELDS = []; | |
+json.abstract_schema.mydashboard.FIELDS[0] = "namedquery_id"; | |
+json.abstract_schema.mydashboard.FIELDS[1] = {}; | |
+json.abstract_schema.mydashboard.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.mydashboard.FIELDS[1].REFERENCES = {}; | |
+json.abstract_schema.mydashboard.FIELDS[1].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.mydashboard.FIELDS[1].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.mydashboard.FIELDS[1].REFERENCES.TABLE = "namedqueries"; | |
+json.abstract_schema.mydashboard.FIELDS[1].TYPE = "INT3"; | |
+json.abstract_schema.mydashboard.FIELDS[2] = "user_id"; | |
+json.abstract_schema.mydashboard.FIELDS[3] = {}; | |
+json.abstract_schema.mydashboard.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.mydashboard.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.mydashboard.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.mydashboard.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.mydashboard.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.mydashboard.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.mydashboard.INDEXES = []; | |
+json.abstract_schema.mydashboard.INDEXES[0] = "mydashboard_namedquery_id_idx"; | |
+json.abstract_schema.mydashboard.INDEXES[1] = {}; | |
+json.abstract_schema.mydashboard.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.mydashboard.INDEXES[1].FIELDS[0] = "namedquery_id"; | |
+json.abstract_schema.mydashboard.INDEXES[1].FIELDS[1] = "user_id"; | |
+json.abstract_schema.mydashboard.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.mydashboard.INDEXES[2] = "mydashboard_user_id_idx"; | |
+json.abstract_schema.mydashboard.INDEXES[3] = []; | |
+json.abstract_schema.mydashboard.INDEXES[3][0] = "user_id"; | |
+json.abstract_schema.nag_defer = {}; | |
+json.abstract_schema.nag_defer.FIELDS = []; | |
+json.abstract_schema.nag_defer.FIELDS[0] = "id"; | |
+json.abstract_schema.nag_defer.FIELDS[1] = {}; | |
+json.abstract_schema.nag_defer.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.nag_defer.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.nag_defer.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.nag_defer.FIELDS[2] = "flag_id"; | |
+json.abstract_schema.nag_defer.FIELDS[3] = {}; | |
+json.abstract_schema.nag_defer.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.nag_defer.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.nag_defer.FIELDS[3].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.nag_defer.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.nag_defer.FIELDS[3].REFERENCES.TABLE = "flags"; | |
+json.abstract_schema.nag_defer.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.nag_defer.FIELDS[4] = "defer_until"; | |
+json.abstract_schema.nag_defer.FIELDS[5] = {}; | |
+json.abstract_schema.nag_defer.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.nag_defer.FIELDS[5].TYPE = "DATETIME"; | |
+json.abstract_schema.nag_defer.INDEXES = []; | |
+json.abstract_schema.nag_defer.INDEXES[0] = "nag_defer_idx"; | |
+json.abstract_schema.nag_defer.INDEXES[1] = {}; | |
+json.abstract_schema.nag_defer.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.nag_defer.INDEXES[1].FIELDS[0] = "flag_id"; | |
+json.abstract_schema.nag_defer.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.nag_settings = {}; | |
+json.abstract_schema.nag_settings.FIELDS = []; | |
+json.abstract_schema.nag_settings.FIELDS[0] = "id"; | |
+json.abstract_schema.nag_settings.FIELDS[1] = {}; | |
+json.abstract_schema.nag_settings.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.nag_settings.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.nag_settings.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.nag_settings.FIELDS[2] = "user_id"; | |
+json.abstract_schema.nag_settings.FIELDS[3] = {}; | |
+json.abstract_schema.nag_settings.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.nag_settings.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.nag_settings.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.nag_settings.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.nag_settings.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.nag_settings.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.nag_settings.FIELDS[4] = "setting_name"; | |
+json.abstract_schema.nag_settings.FIELDS[5] = {}; | |
+json.abstract_schema.nag_settings.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.nag_settings.FIELDS[5].TYPE = "VARCHAR(16)"; | |
+json.abstract_schema.nag_settings.FIELDS[6] = "setting_value"; | |
+json.abstract_schema.nag_settings.FIELDS[7] = {}; | |
+json.abstract_schema.nag_settings.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.nag_settings.FIELDS[7].TYPE = "VARCHAR(16)"; | |
+json.abstract_schema.nag_settings.INDEXES = []; | |
+json.abstract_schema.nag_settings.INDEXES[0] = "nag_setting_idx"; | |
+json.abstract_schema.nag_settings.INDEXES[1] = {}; | |
+json.abstract_schema.nag_settings.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.nag_settings.INDEXES[1].FIELDS[0] = "user_id"; | |
+json.abstract_schema.nag_settings.INDEXES[1].FIELDS[1] = "setting_name"; | |
+json.abstract_schema.nag_settings.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.nag_watch = {}; | |
+json.abstract_schema.nag_watch.FIELDS = []; | |
+json.abstract_schema.nag_watch.FIELDS[0] = "id"; | |
+json.abstract_schema.nag_watch.FIELDS[1] = {}; | |
+json.abstract_schema.nag_watch.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.nag_watch.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.nag_watch.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.nag_watch.FIELDS[2] = "nagged_id"; | |
+json.abstract_schema.nag_watch.FIELDS[3] = {}; | |
+json.abstract_schema.nag_watch.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.nag_watch.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.nag_watch.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.nag_watch.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.nag_watch.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.nag_watch.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.nag_watch.FIELDS[4] = "watcher_id"; | |
+json.abstract_schema.nag_watch.FIELDS[5] = {}; | |
+json.abstract_schema.nag_watch.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.nag_watch.FIELDS[5].REFERENCES = {}; | |
+json.abstract_schema.nag_watch.FIELDS[5].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.nag_watch.FIELDS[5].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.nag_watch.FIELDS[5].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.nag_watch.FIELDS[5].TYPE = "INT3"; | |
+json.abstract_schema.nag_watch.INDEXES = []; | |
+json.abstract_schema.nag_watch.INDEXES[0] = "nag_watch_idx"; | |
+json.abstract_schema.nag_watch.INDEXES[1] = {}; | |
+json.abstract_schema.nag_watch.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.nag_watch.INDEXES[1].FIELDS[0] = "nagged_id"; | |
+json.abstract_schema.nag_watch.INDEXES[1].FIELDS[1] = "watcher_id"; | |
+json.abstract_schema.nag_watch.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.namedqueries = {}; | |
json.abstract_schema.namedqueries.FIELDS = []; | |
json.abstract_schema.namedqueries.FIELDS[0] = "id"; | |
@@ -1708,6 +2361,129 @@ | |
json.abstract_schema.namedquery_group_map.INDEXES[2] = "namedquery_group_map_group_id_idx"; | |
json.abstract_schema.namedquery_group_map.INDEXES[3] = []; | |
json.abstract_schema.namedquery_group_map.INDEXES[3][0] = "group_id"; | |
+json.abstract_schema.oauth2_client = {}; | |
+json.abstract_schema.oauth2_client.FIELDS = []; | |
+json.abstract_schema.oauth2_client.FIELDS[0] = "id"; | |
+json.abstract_schema.oauth2_client.FIELDS[1] = {}; | |
+json.abstract_schema.oauth2_client.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.oauth2_client.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.oauth2_client.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.oauth2_client.FIELDS[2] = "client_id"; | |
+json.abstract_schema.oauth2_client.FIELDS[3] = {}; | |
+json.abstract_schema.oauth2_client.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.oauth2_client.FIELDS[3].TYPE = "varchar(255)"; | |
+json.abstract_schema.oauth2_client.FIELDS[4] = "description"; | |
+json.abstract_schema.oauth2_client.FIELDS[5] = {}; | |
+json.abstract_schema.oauth2_client.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.oauth2_client.FIELDS[5].TYPE = "varchar(255)"; | |
+json.abstract_schema.oauth2_client.FIELDS[6] = "secret"; | |
+json.abstract_schema.oauth2_client.FIELDS[7] = {}; | |
+json.abstract_schema.oauth2_client.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.oauth2_client.FIELDS[7].TYPE = "varchar(255)"; | |
+json.abstract_schema.oauth2_client.FIELDS[8] = "active"; | |
+json.abstract_schema.oauth2_client.FIELDS[9] = {}; | |
+json.abstract_schema.oauth2_client.FIELDS[9].DEFAULT = "TRUE"; | |
+json.abstract_schema.oauth2_client.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.oauth2_client.FIELDS[9].TYPE = "BOOLEAN"; | |
+json.abstract_schema.oauth2_client.FIELDS[10] = "last_modified"; | |
+json.abstract_schema.oauth2_client.FIELDS[11] = {}; | |
+json.abstract_schema.oauth2_client.FIELDS[11].TYPE = "DATETIME"; | |
+json.abstract_schema.oauth2_client_scope = {}; | |
+json.abstract_schema.oauth2_client_scope.FIELDS = []; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[0] = "id"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[1] = {}; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[2] = "client_id"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[3] = {}; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[3].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[3].REFERENCES.TABLE = "oauth2_client"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[3].REFERENCES.UPDATE = "CASCADE"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[3].TYPE = "INT4"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[4] = "scope_id"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[5] = {}; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[5].REFERENCES = {}; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[5].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[5].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[5].REFERENCES.TABLE = "oauth2_scope"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[5].REFERENCES.UPDATE = "CASCADE"; | |
+json.abstract_schema.oauth2_client_scope.FIELDS[5].TYPE = "INT4"; | |
+json.abstract_schema.oauth2_client_scope.INDEXES = []; | |
+json.abstract_schema.oauth2_client_scope.INDEXES[0] = "oauth2_client_scope_idx"; | |
+json.abstract_schema.oauth2_client_scope.INDEXES[1] = {}; | |
+json.abstract_schema.oauth2_client_scope.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.oauth2_client_scope.INDEXES[1].FIELDS[0] = "client_id"; | |
+json.abstract_schema.oauth2_client_scope.INDEXES[1].FIELDS[1] = "scope_id"; | |
+json.abstract_schema.oauth2_client_scope.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.oauth2_jwt = {}; | |
+json.abstract_schema.oauth2_jwt.FIELDS = []; | |
+json.abstract_schema.oauth2_jwt.FIELDS[0] = "id"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[1] = {}; | |
+json.abstract_schema.oauth2_jwt.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.oauth2_jwt.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.oauth2_jwt.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[2] = "jti"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[3] = {}; | |
+json.abstract_schema.oauth2_jwt.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.oauth2_jwt.FIELDS[3].TYPE = "varchar(255)"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[4] = "type"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[5] = {}; | |
+json.abstract_schema.oauth2_jwt.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.oauth2_jwt.FIELDS[5].TYPE = "INT2"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[6] = "client_id"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[7] = {}; | |
+json.abstract_schema.oauth2_jwt.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.oauth2_jwt.FIELDS[7].REFERENCES = {}; | |
+json.abstract_schema.oauth2_jwt.FIELDS[7].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[7].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[7].REFERENCES.TABLE = "oauth2_client"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[7].REFERENCES.UPDATE = "CASCADE"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[7].TYPE = "INT4"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[8] = "user_id"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[9] = {}; | |
+json.abstract_schema.oauth2_jwt.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.oauth2_jwt.FIELDS[9].REFERENCES = {}; | |
+json.abstract_schema.oauth2_jwt.FIELDS[9].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[9].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[9].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[9].REFERENCES.UPDATE = "CASCADE"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[9].TYPE = "INT3"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[10] = "expires"; | |
+json.abstract_schema.oauth2_jwt.FIELDS[11] = {}; | |
+json.abstract_schema.oauth2_jwt.FIELDS[11].TYPE = "DATETIME"; | |
+json.abstract_schema.oauth2_jwt.INDEXES = []; | |
+json.abstract_schema.oauth2_jwt.INDEXES[0] = "oauth2_jwt_jti_type_idx"; | |
+json.abstract_schema.oauth2_jwt.INDEXES[1] = {}; | |
+json.abstract_schema.oauth2_jwt.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.oauth2_jwt.INDEXES[1].FIELDS[0] = "jti"; | |
+json.abstract_schema.oauth2_jwt.INDEXES[1].FIELDS[1] = "type"; | |
+json.abstract_schema.oauth2_jwt.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.oauth2_scope = {}; | |
+json.abstract_schema.oauth2_scope.FIELDS = []; | |
+json.abstract_schema.oauth2_scope.FIELDS[0] = "id"; | |
+json.abstract_schema.oauth2_scope.FIELDS[1] = {}; | |
+json.abstract_schema.oauth2_scope.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.oauth2_scope.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.oauth2_scope.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.oauth2_scope.FIELDS[2] = "name"; | |
+json.abstract_schema.oauth2_scope.FIELDS[3] = {}; | |
+json.abstract_schema.oauth2_scope.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.oauth2_scope.FIELDS[3].TYPE = "varchar(255)"; | |
+json.abstract_schema.oauth2_scope.FIELDS[4] = "description"; | |
+json.abstract_schema.oauth2_scope.FIELDS[5] = {}; | |
+json.abstract_schema.oauth2_scope.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.oauth2_scope.FIELDS[5].TYPE = "TINYTEXT"; | |
+json.abstract_schema.oauth2_scope.INDEXES = []; | |
+json.abstract_schema.oauth2_scope.INDEXES[0] = "oauth2_scope_idx"; | |
+json.abstract_schema.oauth2_scope.INDEXES[1] = {}; | |
+json.abstract_schema.oauth2_scope.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.oauth2_scope.INDEXES[1].FIELDS[0] = "name"; | |
+json.abstract_schema.oauth2_scope.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.op_sys = {}; | |
json.abstract_schema.op_sys.FIELDS = []; | |
json.abstract_schema.op_sys.FIELDS[0] = "id"; | |
@@ -1745,6 +2521,27 @@ | |
json.abstract_schema.op_sys.INDEXES[4] = "op_sys_visibility_value_id_idx"; | |
json.abstract_schema.op_sys.INDEXES[5] = []; | |
json.abstract_schema.op_sys.INDEXES[5][0] = "visibility_value_id"; | |
+json.abstract_schema.phabbugz = {}; | |
+json.abstract_schema.phabbugz.FIELDS = []; | |
+json.abstract_schema.phabbugz.FIELDS[0] = "id"; | |
+json.abstract_schema.phabbugz.FIELDS[1] = {}; | |
+json.abstract_schema.phabbugz.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.phabbugz.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.phabbugz.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.phabbugz.FIELDS[2] = "name"; | |
+json.abstract_schema.phabbugz.FIELDS[3] = {}; | |
+json.abstract_schema.phabbugz.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.phabbugz.FIELDS[3].TYPE = "VARCHAR(255)"; | |
+json.abstract_schema.phabbugz.FIELDS[4] = "value"; | |
+json.abstract_schema.phabbugz.FIELDS[5] = {}; | |
+json.abstract_schema.phabbugz.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.phabbugz.FIELDS[5].TYPE = "MEDIUMTEXT"; | |
+json.abstract_schema.phabbugz.INDEXES = []; | |
+json.abstract_schema.phabbugz.INDEXES[0] = "phabbugz_idx"; | |
+json.abstract_schema.phabbugz.INDEXES[1] = {}; | |
+json.abstract_schema.phabbugz.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.phabbugz.INDEXES[1].FIELDS[0] = "name"; | |
+json.abstract_schema.phabbugz.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.priority = {}; | |
json.abstract_schema.priority.FIELDS = []; | |
json.abstract_schema.priority.FIELDS[0] = "id"; | |
@@ -1782,6 +2579,44 @@ | |
json.abstract_schema.priority.INDEXES[4] = "priority_visibility_value_id_idx"; | |
json.abstract_schema.priority.INDEXES[5] = []; | |
json.abstract_schema.priority.INDEXES[5][0] = "visibility_value_id"; | |
+json.abstract_schema.product_reviewers = {}; | |
+json.abstract_schema.product_reviewers.FIELDS = []; | |
+json.abstract_schema.product_reviewers.FIELDS[0] = "id"; | |
+json.abstract_schema.product_reviewers.FIELDS[1] = {}; | |
+json.abstract_schema.product_reviewers.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.product_reviewers.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.product_reviewers.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.product_reviewers.FIELDS[2] = "user_id"; | |
+json.abstract_schema.product_reviewers.FIELDS[3] = {}; | |
+json.abstract_schema.product_reviewers.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.product_reviewers.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.product_reviewers.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.product_reviewers.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.product_reviewers.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.product_reviewers.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.product_reviewers.FIELDS[4] = "display_name"; | |
+json.abstract_schema.product_reviewers.FIELDS[5] = {}; | |
+json.abstract_schema.product_reviewers.FIELDS[5].TYPE = "VARCHAR(64)"; | |
+json.abstract_schema.product_reviewers.FIELDS[6] = "product_id"; | |
+json.abstract_schema.product_reviewers.FIELDS[7] = {}; | |
+json.abstract_schema.product_reviewers.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.product_reviewers.FIELDS[7].REFERENCES = {}; | |
+json.abstract_schema.product_reviewers.FIELDS[7].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.product_reviewers.FIELDS[7].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.product_reviewers.FIELDS[7].REFERENCES.TABLE = "products"; | |
+json.abstract_schema.product_reviewers.FIELDS[7].TYPE = "INT2"; | |
+json.abstract_schema.product_reviewers.FIELDS[8] = "sortkey"; | |
+json.abstract_schema.product_reviewers.FIELDS[9] = {}; | |
+json.abstract_schema.product_reviewers.FIELDS[9].DEFAULT = 0; | |
+json.abstract_schema.product_reviewers.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.product_reviewers.FIELDS[9].TYPE = "INT2"; | |
+json.abstract_schema.product_reviewers.INDEXES = []; | |
+json.abstract_schema.product_reviewers.INDEXES[0] = "product_reviewers_idx"; | |
+json.abstract_schema.product_reviewers.INDEXES[1] = {}; | |
+json.abstract_schema.product_reviewers.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.product_reviewers.INDEXES[1].FIELDS[0] = "user_id"; | |
+json.abstract_schema.product_reviewers.INDEXES[1].FIELDS[1] = "product_id"; | |
+json.abstract_schema.product_reviewers.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.products = {}; | |
json.abstract_schema.products.FIELDS = []; | |
json.abstract_schema.products.FIELDS[0] = "id"; | |
@@ -1815,18 +2650,53 @@ | |
json.abstract_schema.products.FIELDS[11] = {}; | |
json.abstract_schema.products.FIELDS[11].DEFAULT = "'---'"; | |
json.abstract_schema.products.FIELDS[11].NOTNULL = 1; | |
-json.abstract_schema.products.FIELDS[11].TYPE = "varchar(64)"; | |
+json.abstract_schema.products.FIELDS[11].TYPE = "varchar(20)"; | |
json.abstract_schema.products.FIELDS[12] = "allows_unconfirmed"; | |
json.abstract_schema.products.FIELDS[13] = {}; | |
json.abstract_schema.products.FIELDS[13].DEFAULT = "TRUE"; | |
json.abstract_schema.products.FIELDS[13].NOTNULL = 1; | |
json.abstract_schema.products.FIELDS[13].TYPE = "BOOLEAN"; | |
+json.abstract_schema.products.FIELDS[14] = "bug_description_template"; | |
+json.abstract_schema.products.FIELDS[15] = {}; | |
+json.abstract_schema.products.FIELDS[15].TYPE = "MEDIUMTEXT"; | |
+json.abstract_schema.products.FIELDS[16] = "default_bug_type"; | |
+json.abstract_schema.products.FIELDS[17] = {}; | |
+json.abstract_schema.products.FIELDS[17].TYPE = "varchar(20)"; | |
json.abstract_schema.products.INDEXES = []; | |
json.abstract_schema.products.INDEXES[0] = "products_name_idx"; | |
json.abstract_schema.products.INDEXES[1] = {}; | |
json.abstract_schema.products.INDEXES[1].FIELDS = []; | |
json.abstract_schema.products.INDEXES[1].FIELDS[0] = "name"; | |
json.abstract_schema.products.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.profile_mfa = {}; | |
+json.abstract_schema.profile_mfa.FIELDS = []; | |
+json.abstract_schema.profile_mfa.FIELDS[0] = "id"; | |
+json.abstract_schema.profile_mfa.FIELDS[1] = {}; | |
+json.abstract_schema.profile_mfa.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.profile_mfa.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.profile_mfa.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.profile_mfa.FIELDS[2] = "user_id"; | |
+json.abstract_schema.profile_mfa.FIELDS[3] = {}; | |
+json.abstract_schema.profile_mfa.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.profile_mfa.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.profile_mfa.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.profile_mfa.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.profile_mfa.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.profile_mfa.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.profile_mfa.FIELDS[4] = "name"; | |
+json.abstract_schema.profile_mfa.FIELDS[5] = {}; | |
+json.abstract_schema.profile_mfa.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.profile_mfa.FIELDS[5].TYPE = "varchar(16)"; | |
+json.abstract_schema.profile_mfa.FIELDS[6] = "value"; | |
+json.abstract_schema.profile_mfa.FIELDS[7] = {}; | |
+json.abstract_schema.profile_mfa.FIELDS[7].TYPE = "varchar(255)"; | |
+json.abstract_schema.profile_mfa.INDEXES = []; | |
+json.abstract_schema.profile_mfa.INDEXES[0] = "profile_mfa_userid_name_idx"; | |
+json.abstract_schema.profile_mfa.INDEXES[1] = {}; | |
+json.abstract_schema.profile_mfa.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.profile_mfa.INDEXES[1].FIELDS[0] = "user_id"; | |
+json.abstract_schema.profile_mfa.INDEXES[1].FIELDS[1] = "name"; | |
+json.abstract_schema.profile_mfa.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.profile_search = {}; | |
json.abstract_schema.profile_search.FIELDS = []; | |
json.abstract_schema.profile_search.FIELDS[0] = "id"; | |
@@ -1901,32 +2771,60 @@ | |
json.abstract_schema.profiles.FIELDS[7].DEFAULT = "''"; | |
json.abstract_schema.profiles.FIELDS[7].NOTNULL = 1; | |
json.abstract_schema.profiles.FIELDS[7].TYPE = "varchar(255)"; | |
-json.abstract_schema.profiles.FIELDS[8] = "disabledtext"; | |
+json.abstract_schema.profiles.FIELDS[8] = "nickname"; | |
json.abstract_schema.profiles.FIELDS[9] = {}; | |
json.abstract_schema.profiles.FIELDS[9].DEFAULT = "''"; | |
json.abstract_schema.profiles.FIELDS[9].NOTNULL = 1; | |
-json.abstract_schema.profiles.FIELDS[9].TYPE = "MEDIUMTEXT"; | |
-json.abstract_schema.profiles.FIELDS[10] = "disable_mail"; | |
+json.abstract_schema.profiles.FIELDS[9].TYPE = "varchar(255)"; | |
+json.abstract_schema.profiles.FIELDS[10] = "disabledtext"; | |
json.abstract_schema.profiles.FIELDS[11] = {}; | |
-json.abstract_schema.profiles.FIELDS[11].DEFAULT = "FALSE"; | |
+json.abstract_schema.profiles.FIELDS[11].DEFAULT = "''"; | |
json.abstract_schema.profiles.FIELDS[11].NOTNULL = 1; | |
-json.abstract_schema.profiles.FIELDS[11].TYPE = "BOOLEAN"; | |
-json.abstract_schema.profiles.FIELDS[12] = "mybugslink"; | |
+json.abstract_schema.profiles.FIELDS[11].TYPE = "MEDIUMTEXT"; | |
+json.abstract_schema.profiles.FIELDS[12] = "disable_mail"; | |
json.abstract_schema.profiles.FIELDS[13] = {}; | |
-json.abstract_schema.profiles.FIELDS[13].DEFAULT = "TRUE"; | |
+json.abstract_schema.profiles.FIELDS[13].DEFAULT = "FALSE"; | |
json.abstract_schema.profiles.FIELDS[13].NOTNULL = 1; | |
json.abstract_schema.profiles.FIELDS[13].TYPE = "BOOLEAN"; | |
-json.abstract_schema.profiles.FIELDS[14] = "extern_id"; | |
+json.abstract_schema.profiles.FIELDS[14] = "mybugslink"; | |
json.abstract_schema.profiles.FIELDS[15] = {}; | |
-json.abstract_schema.profiles.FIELDS[15].TYPE = "varchar(64)"; | |
-json.abstract_schema.profiles.FIELDS[16] = "is_enabled"; | |
+json.abstract_schema.profiles.FIELDS[15].DEFAULT = "TRUE"; | |
+json.abstract_schema.profiles.FIELDS[15].NOTNULL = 1; | |
+json.abstract_schema.profiles.FIELDS[15].TYPE = "BOOLEAN"; | |
+json.abstract_schema.profiles.FIELDS[16] = "extern_id"; | |
json.abstract_schema.profiles.FIELDS[17] = {}; | |
-json.abstract_schema.profiles.FIELDS[17].DEFAULT = "TRUE"; | |
-json.abstract_schema.profiles.FIELDS[17].NOTNULL = 1; | |
-json.abstract_schema.profiles.FIELDS[17].TYPE = "BOOLEAN"; | |
-json.abstract_schema.profiles.FIELDS[18] = "last_seen_date"; | |
+json.abstract_schema.profiles.FIELDS[17].TYPE = "varchar(64)"; | |
+json.abstract_schema.profiles.FIELDS[18] = "is_enabled"; | |
json.abstract_schema.profiles.FIELDS[19] = {}; | |
-json.abstract_schema.profiles.FIELDS[19].TYPE = "DATETIME"; | |
+json.abstract_schema.profiles.FIELDS[19].DEFAULT = "TRUE"; | |
+json.abstract_schema.profiles.FIELDS[19].NOTNULL = 1; | |
+json.abstract_schema.profiles.FIELDS[19].TYPE = "BOOLEAN"; | |
+json.abstract_schema.profiles.FIELDS[20] = "last_seen_date"; | |
+json.abstract_schema.profiles.FIELDS[21] = {}; | |
+json.abstract_schema.profiles.FIELDS[21].TYPE = "DATETIME"; | |
+json.abstract_schema.profiles.FIELDS[22] = "password_change_required"; | |
+json.abstract_schema.profiles.FIELDS[23] = {}; | |
+json.abstract_schema.profiles.FIELDS[23].DEFAULT = "FALSE"; | |
+json.abstract_schema.profiles.FIELDS[23].NOTNULL = 1; | |
+json.abstract_schema.profiles.FIELDS[23].TYPE = "BOOLEAN"; | |
+json.abstract_schema.profiles.FIELDS[24] = "password_change_reason"; | |
+json.abstract_schema.profiles.FIELDS[25] = {}; | |
+json.abstract_schema.profiles.FIELDS[25].TYPE = "varchar(64)"; | |
+json.abstract_schema.profiles.FIELDS[26] = "mfa"; | |
+json.abstract_schema.profiles.FIELDS[27] = {}; | |
+json.abstract_schema.profiles.FIELDS[27].DEFAULT = "''"; | |
+json.abstract_schema.profiles.FIELDS[27].TYPE = "varchar(8)"; | |
+json.abstract_schema.profiles.FIELDS[28] = "mfa_required_date"; | |
+json.abstract_schema.profiles.FIELDS[29] = {}; | |
+json.abstract_schema.profiles.FIELDS[29].TYPE = "DATETIME"; | |
+json.abstract_schema.profiles.FIELDS[30] = "forget_after_date"; | |
+json.abstract_schema.profiles.FIELDS[31] = {}; | |
+json.abstract_schema.profiles.FIELDS[31].TYPE = "DATETIME"; | |
+json.abstract_schema.profiles.FIELDS[32] = "bounce_count"; | |
+json.abstract_schema.profiles.FIELDS[33] = {}; | |
+json.abstract_schema.profiles.FIELDS[33].DEFAULT = 0; | |
+json.abstract_schema.profiles.FIELDS[33].NOTNULL = 1; | |
+json.abstract_schema.profiles.FIELDS[33].TYPE = "INT1"; | |
json.abstract_schema.profiles.INDEXES = []; | |
json.abstract_schema.profiles.INDEXES[0] = "profiles_login_name_idx"; | |
json.abstract_schema.profiles.INDEXES[1] = {}; | |
@@ -1938,6 +2836,14 @@ | |
json.abstract_schema.profiles.INDEXES[3].FIELDS = []; | |
json.abstract_schema.profiles.INDEXES[3].FIELDS[0] = "extern_id"; | |
json.abstract_schema.profiles.INDEXES[3].TYPE = "UNIQUE"; | |
+json.abstract_schema.profiles.INDEXES[4] = "profiles_nickname_idx"; | |
+json.abstract_schema.profiles.INDEXES[5] = []; | |
+json.abstract_schema.profiles.INDEXES[5][0] = "nickname"; | |
+json.abstract_schema.profiles.INDEXES[6] = "profiles_realname_ft_idx"; | |
+json.abstract_schema.profiles.INDEXES[7] = {}; | |
+json.abstract_schema.profiles.INDEXES[7].FIELDS = []; | |
+json.abstract_schema.profiles.INDEXES[7].FIELDS[0] = "realname"; | |
+json.abstract_schema.profiles.INDEXES[7].TYPE = "FULLTEXT"; | |
json.abstract_schema.profiles_activity = {}; | |
json.abstract_schema.profiles_activity.FIELDS = []; | |
json.abstract_schema.profiles_activity.FIELDS[0] = "id"; | |
@@ -1987,6 +2893,296 @@ | |
json.abstract_schema.profiles_activity.INDEXES[4] = "profiles_activity_fieldid_idx"; | |
json.abstract_schema.profiles_activity.INDEXES[5] = []; | |
json.abstract_schema.profiles_activity.INDEXES[5][0] = "fieldid"; | |
+json.abstract_schema.profiles_statistics = {}; | |
+json.abstract_schema.profiles_statistics.FIELDS = []; | |
+json.abstract_schema.profiles_statistics.FIELDS[0] = "id"; | |
+json.abstract_schema.profiles_statistics.FIELDS[1] = {}; | |
+json.abstract_schema.profiles_statistics.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.profiles_statistics.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.profiles_statistics.FIELDS[2] = "user_id"; | |
+json.abstract_schema.profiles_statistics.FIELDS[3] = {}; | |
+json.abstract_schema.profiles_statistics.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.profiles_statistics.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.profiles_statistics.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.profiles_statistics.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.profiles_statistics.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.profiles_statistics.FIELDS[4] = "name"; | |
+json.abstract_schema.profiles_statistics.FIELDS[5] = {}; | |
+json.abstract_schema.profiles_statistics.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics.FIELDS[5].TYPE = "VARCHAR(30)"; | |
+json.abstract_schema.profiles_statistics.FIELDS[6] = "count"; | |
+json.abstract_schema.profiles_statistics.FIELDS[7] = {}; | |
+json.abstract_schema.profiles_statistics.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics.FIELDS[7].TYPE = "INT"; | |
+json.abstract_schema.profiles_statistics.INDEXES = []; | |
+json.abstract_schema.profiles_statistics.INDEXES[0] = "profiles_statistics_name_idx"; | |
+json.abstract_schema.profiles_statistics.INDEXES[1] = {}; | |
+json.abstract_schema.profiles_statistics.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.profiles_statistics.INDEXES[1].FIELDS[0] = "user_id"; | |
+json.abstract_schema.profiles_statistics.INDEXES[1].FIELDS[1] = "name"; | |
+json.abstract_schema.profiles_statistics.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.profiles_statistics_products = {}; | |
+json.abstract_schema.profiles_statistics_products.FIELDS = []; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[0] = "id"; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[1] = {}; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[2] = "user_id"; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[3] = {}; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[4] = "product"; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[5] = {}; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[5].TYPE = "VARCHAR(64)"; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[6] = "count"; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[7] = {}; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics_products.FIELDS[7].TYPE = "INT"; | |
+json.abstract_schema.profiles_statistics_products.INDEXES = []; | |
+json.abstract_schema.profiles_statistics_products.INDEXES[0] = "profiles_statistics_products_idx"; | |
+json.abstract_schema.profiles_statistics_products.INDEXES[1] = {}; | |
+json.abstract_schema.profiles_statistics_products.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.profiles_statistics_products.INDEXES[1].FIELDS[0] = "user_id"; | |
+json.abstract_schema.profiles_statistics_products.INDEXES[1].FIELDS[1] = "product"; | |
+json.abstract_schema.profiles_statistics_products.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.profiles_statistics_recalc = {}; | |
+json.abstract_schema.profiles_statistics_recalc.FIELDS = []; | |
+json.abstract_schema.profiles_statistics_recalc.FIELDS[0] = "user_id"; | |
+json.abstract_schema.profiles_statistics_recalc.FIELDS[1] = {}; | |
+json.abstract_schema.profiles_statistics_recalc.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics_recalc.FIELDS[1].REFERENCES = {}; | |
+json.abstract_schema.profiles_statistics_recalc.FIELDS[1].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.profiles_statistics_recalc.FIELDS[1].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.profiles_statistics_recalc.FIELDS[1].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.profiles_statistics_recalc.FIELDS[1].TYPE = "INT3"; | |
+json.abstract_schema.profiles_statistics_recalc.INDEXES = []; | |
+json.abstract_schema.profiles_statistics_recalc.INDEXES[0] = "profiles_statistics_recalc_idx"; | |
+json.abstract_schema.profiles_statistics_recalc.INDEXES[1] = {}; | |
+json.abstract_schema.profiles_statistics_recalc.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.profiles_statistics_recalc.INDEXES[1].FIELDS[0] = "user_id"; | |
+json.abstract_schema.profiles_statistics_recalc.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.profiles_statistics_status = {}; | |
+json.abstract_schema.profiles_statistics_status.FIELDS = []; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[0] = "id"; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[1] = {}; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[2] = "user_id"; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[3] = {}; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[4] = "status"; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[5] = {}; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[5].TYPE = "VARCHAR(64)"; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[6] = "count"; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[7] = {}; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.profiles_statistics_status.FIELDS[7].TYPE = "INT"; | |
+json.abstract_schema.profiles_statistics_status.INDEXES = []; | |
+json.abstract_schema.profiles_statistics_status.INDEXES[0] = "profiles_statistics_status_idx"; | |
+json.abstract_schema.profiles_statistics_status.INDEXES[1] = {}; | |
+json.abstract_schema.profiles_statistics_status.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.profiles_statistics_status.INDEXES[1].FIELDS[0] = "user_id"; | |
+json.abstract_schema.profiles_statistics_status.INDEXES[1].FIELDS[1] = "status"; | |
+json.abstract_schema.profiles_statistics_status.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.push = {}; | |
+json.abstract_schema.push.FIELDS = []; | |
+json.abstract_schema.push.FIELDS[0] = "id"; | |
+json.abstract_schema.push.FIELDS[1] = {}; | |
+json.abstract_schema.push.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.push.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.push.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.push.FIELDS[2] = "push_ts"; | |
+json.abstract_schema.push.FIELDS[3] = {}; | |
+json.abstract_schema.push.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.push.FIELDS[3].TYPE = "DATETIME"; | |
+json.abstract_schema.push.FIELDS[4] = "payload"; | |
+json.abstract_schema.push.FIELDS[5] = {}; | |
+json.abstract_schema.push.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.push.FIELDS[5].TYPE = "LONGTEXT"; | |
+json.abstract_schema.push.FIELDS[6] = "change_set"; | |
+json.abstract_schema.push.FIELDS[7] = {}; | |
+json.abstract_schema.push.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.push.FIELDS[7].TYPE = "VARCHAR(32)"; | |
+json.abstract_schema.push.FIELDS[8] = "routing_key"; | |
+json.abstract_schema.push.FIELDS[9] = {}; | |
+json.abstract_schema.push.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.push.FIELDS[9].TYPE = "VARCHAR(64)"; | |
+json.abstract_schema.push_backlog = {}; | |
+json.abstract_schema.push_backlog.FIELDS = []; | |
+json.abstract_schema.push_backlog.FIELDS[0] = "id"; | |
+json.abstract_schema.push_backlog.FIELDS[1] = {}; | |
+json.abstract_schema.push_backlog.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.push_backlog.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.push_backlog.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.push_backlog.FIELDS[2] = "message_id"; | |
+json.abstract_schema.push_backlog.FIELDS[3] = {}; | |
+json.abstract_schema.push_backlog.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.push_backlog.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.push_backlog.FIELDS[4] = "push_ts"; | |
+json.abstract_schema.push_backlog.FIELDS[5] = {}; | |
+json.abstract_schema.push_backlog.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.push_backlog.FIELDS[5].TYPE = "DATETIME"; | |
+json.abstract_schema.push_backlog.FIELDS[6] = "payload"; | |
+json.abstract_schema.push_backlog.FIELDS[7] = {}; | |
+json.abstract_schema.push_backlog.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.push_backlog.FIELDS[7].TYPE = "LONGTEXT"; | |
+json.abstract_schema.push_backlog.FIELDS[8] = "change_set"; | |
+json.abstract_schema.push_backlog.FIELDS[9] = {}; | |
+json.abstract_schema.push_backlog.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.push_backlog.FIELDS[9].TYPE = "VARCHAR(32)"; | |
+json.abstract_schema.push_backlog.FIELDS[10] = "routing_key"; | |
+json.abstract_schema.push_backlog.FIELDS[11] = {}; | |
+json.abstract_schema.push_backlog.FIELDS[11].NOTNULL = 1; | |
+json.abstract_schema.push_backlog.FIELDS[11].TYPE = "VARCHAR(64)"; | |
+json.abstract_schema.push_backlog.FIELDS[12] = "connector"; | |
+json.abstract_schema.push_backlog.FIELDS[13] = {}; | |
+json.abstract_schema.push_backlog.FIELDS[13].NOTNULL = 1; | |
+json.abstract_schema.push_backlog.FIELDS[13].TYPE = "VARCHAR(32)"; | |
+json.abstract_schema.push_backlog.FIELDS[14] = "attempt_ts"; | |
+json.abstract_schema.push_backlog.FIELDS[15] = {}; | |
+json.abstract_schema.push_backlog.FIELDS[15].TYPE = "DATETIME"; | |
+json.abstract_schema.push_backlog.FIELDS[16] = "attempts"; | |
+json.abstract_schema.push_backlog.FIELDS[17] = {}; | |
+json.abstract_schema.push_backlog.FIELDS[17].NOTNULL = 1; | |
+json.abstract_schema.push_backlog.FIELDS[17].TYPE = "INT2"; | |
+json.abstract_schema.push_backlog.FIELDS[18] = "last_error"; | |
+json.abstract_schema.push_backlog.FIELDS[19] = {}; | |
+json.abstract_schema.push_backlog.FIELDS[19].TYPE = "MEDIUMTEXT"; | |
+json.abstract_schema.push_backlog.INDEXES = []; | |
+json.abstract_schema.push_backlog.INDEXES[0] = "push_backlog_idx"; | |
+json.abstract_schema.push_backlog.INDEXES[1] = {}; | |
+json.abstract_schema.push_backlog.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.push_backlog.INDEXES[1].FIELDS[0] = "message_id"; | |
+json.abstract_schema.push_backlog.INDEXES[1].FIELDS[1] = "connector"; | |
+json.abstract_schema.push_backlog.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.push_backoff = {}; | |
+json.abstract_schema.push_backoff.FIELDS = []; | |
+json.abstract_schema.push_backoff.FIELDS[0] = "id"; | |
+json.abstract_schema.push_backoff.FIELDS[1] = {}; | |
+json.abstract_schema.push_backoff.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.push_backoff.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.push_backoff.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.push_backoff.FIELDS[2] = "connector"; | |
+json.abstract_schema.push_backoff.FIELDS[3] = {}; | |
+json.abstract_schema.push_backoff.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.push_backoff.FIELDS[3].TYPE = "VARCHAR(32)"; | |
+json.abstract_schema.push_backoff.FIELDS[4] = "next_attempt_ts"; | |
+json.abstract_schema.push_backoff.FIELDS[5] = {}; | |
+json.abstract_schema.push_backoff.FIELDS[5].TYPE = "DATETIME"; | |
+json.abstract_schema.push_backoff.FIELDS[6] = "attempts"; | |
+json.abstract_schema.push_backoff.FIELDS[7] = {}; | |
+json.abstract_schema.push_backoff.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.push_backoff.FIELDS[7].TYPE = "INT2"; | |
+json.abstract_schema.push_backoff.INDEXES = []; | |
+json.abstract_schema.push_backoff.INDEXES[0] = "push_backoff_idx"; | |
+json.abstract_schema.push_backoff.INDEXES[1] = {}; | |
+json.abstract_schema.push_backoff.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.push_backoff.INDEXES[1].FIELDS[0] = "connector"; | |
+json.abstract_schema.push_backoff.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.push_log = {}; | |
+json.abstract_schema.push_log.FIELDS = []; | |
+json.abstract_schema.push_log.FIELDS[0] = "id"; | |
+json.abstract_schema.push_log.FIELDS[1] = {}; | |
+json.abstract_schema.push_log.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.push_log.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.push_log.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.push_log.FIELDS[2] = "message_id"; | |
+json.abstract_schema.push_log.FIELDS[3] = {}; | |
+json.abstract_schema.push_log.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.push_log.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.push_log.FIELDS[4] = "change_set"; | |
+json.abstract_schema.push_log.FIELDS[5] = {}; | |
+json.abstract_schema.push_log.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.push_log.FIELDS[5].TYPE = "VARCHAR(32)"; | |
+json.abstract_schema.push_log.FIELDS[6] = "routing_key"; | |
+json.abstract_schema.push_log.FIELDS[7] = {}; | |
+json.abstract_schema.push_log.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.push_log.FIELDS[7].TYPE = "VARCHAR(64)"; | |
+json.abstract_schema.push_log.FIELDS[8] = "connector"; | |
+json.abstract_schema.push_log.FIELDS[9] = {}; | |
+json.abstract_schema.push_log.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.push_log.FIELDS[9].TYPE = "VARCHAR(32)"; | |
+json.abstract_schema.push_log.FIELDS[10] = "push_ts"; | |
+json.abstract_schema.push_log.FIELDS[11] = {}; | |
+json.abstract_schema.push_log.FIELDS[11].NOTNULL = 1; | |
+json.abstract_schema.push_log.FIELDS[11].TYPE = "DATETIME"; | |
+json.abstract_schema.push_log.FIELDS[12] = "processed_ts"; | |
+json.abstract_schema.push_log.FIELDS[13] = {}; | |
+json.abstract_schema.push_log.FIELDS[13].NOTNULL = 1; | |
+json.abstract_schema.push_log.FIELDS[13].TYPE = "DATETIME"; | |
+json.abstract_schema.push_log.FIELDS[14] = "result"; | |
+json.abstract_schema.push_log.FIELDS[15] = {}; | |
+json.abstract_schema.push_log.FIELDS[15].NOTNULL = 1; | |
+json.abstract_schema.push_log.FIELDS[15].TYPE = "INT1"; | |
+json.abstract_schema.push_log.FIELDS[16] = "data"; | |
+json.abstract_schema.push_log.FIELDS[17] = {}; | |
+json.abstract_schema.push_log.FIELDS[17].TYPE = "MEDIUMTEXT"; | |
+json.abstract_schema.push_notify = {}; | |
+json.abstract_schema.push_notify.FIELDS = []; | |
+json.abstract_schema.push_notify.FIELDS[0] = "id"; | |
+json.abstract_schema.push_notify.FIELDS[1] = {}; | |
+json.abstract_schema.push_notify.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.push_notify.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.push_notify.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.push_notify.FIELDS[2] = "bug_id"; | |
+json.abstract_schema.push_notify.FIELDS[3] = {}; | |
+json.abstract_schema.push_notify.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.push_notify.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.push_notify.FIELDS[3].REFERENCES.COLUMN = "bug_id"; | |
+json.abstract_schema.push_notify.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.push_notify.FIELDS[3].REFERENCES.TABLE = "bugs"; | |
+json.abstract_schema.push_notify.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.push_notify.FIELDS[4] = "delta_ts"; | |
+json.abstract_schema.push_notify.FIELDS[5] = {}; | |
+json.abstract_schema.push_notify.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.push_notify.FIELDS[5].TYPE = "DATETIME"; | |
+json.abstract_schema.push_notify.INDEXES = []; | |
+json.abstract_schema.push_notify.INDEXES[0] = "push_notify_idx"; | |
+json.abstract_schema.push_notify.INDEXES[1] = {}; | |
+json.abstract_schema.push_notify.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.push_notify.INDEXES[1].FIELDS[0] = "bug_id"; | |
+json.abstract_schema.push_notify.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.push_options = {}; | |
+json.abstract_schema.push_options.FIELDS = []; | |
+json.abstract_schema.push_options.FIELDS[0] = "id"; | |
+json.abstract_schema.push_options.FIELDS[1] = {}; | |
+json.abstract_schema.push_options.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.push_options.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.push_options.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.push_options.FIELDS[2] = "connector"; | |
+json.abstract_schema.push_options.FIELDS[3] = {}; | |
+json.abstract_schema.push_options.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.push_options.FIELDS[3].TYPE = "VARCHAR(32)"; | |
+json.abstract_schema.push_options.FIELDS[4] = "option_name"; | |
+json.abstract_schema.push_options.FIELDS[5] = {}; | |
+json.abstract_schema.push_options.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.push_options.FIELDS[5].TYPE = "VARCHAR(32)"; | |
+json.abstract_schema.push_options.FIELDS[6] = "option_value"; | |
+json.abstract_schema.push_options.FIELDS[7] = {}; | |
+json.abstract_schema.push_options.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.push_options.FIELDS[7].TYPE = "VARCHAR(255)"; | |
+json.abstract_schema.push_options.INDEXES = []; | |
+json.abstract_schema.push_options.INDEXES[0] = "push_options_idx"; | |
+json.abstract_schema.push_options.INDEXES[1] = {}; | |
+json.abstract_schema.push_options.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.push_options.INDEXES[1].FIELDS[0] = "connector"; | |
+json.abstract_schema.push_options.INDEXES[1].FIELDS[1] = "option_name"; | |
+json.abstract_schema.push_options.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.quips = {}; | |
json.abstract_schema.quips.FIELDS = []; | |
json.abstract_schema.quips.FIELDS[0] = "quipid"; | |
@@ -2004,12 +3200,40 @@ | |
json.abstract_schema.quips.FIELDS[4] = "quip"; | |
json.abstract_schema.quips.FIELDS[5] = {}; | |
json.abstract_schema.quips.FIELDS[5].NOTNULL = 1; | |
-json.abstract_schema.quips.FIELDS[5].TYPE = "varchar(512)"; | |
+json.abstract_schema.quips.FIELDS[5].TYPE = "MEDIUMTEXT"; | |
json.abstract_schema.quips.FIELDS[6] = "approved"; | |
json.abstract_schema.quips.FIELDS[7] = {}; | |
json.abstract_schema.quips.FIELDS[7].DEFAULT = "TRUE"; | |
json.abstract_schema.quips.FIELDS[7].NOTNULL = 1; | |
json.abstract_schema.quips.FIELDS[7].TYPE = "BOOLEAN"; | |
+json.abstract_schema.regressions = {}; | |
+json.abstract_schema.regressions.FIELDS = []; | |
+json.abstract_schema.regressions.FIELDS[0] = "regressed_by"; | |
+json.abstract_schema.regressions.FIELDS[1] = {}; | |
+json.abstract_schema.regressions.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.regressions.FIELDS[1].REFERENCES = {}; | |
+json.abstract_schema.regressions.FIELDS[1].REFERENCES.COLUMN = "bug_id"; | |
+json.abstract_schema.regressions.FIELDS[1].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.regressions.FIELDS[1].REFERENCES.TABLE = "bugs"; | |
+json.abstract_schema.regressions.FIELDS[1].TYPE = "INT3"; | |
+json.abstract_schema.regressions.FIELDS[2] = "regresses"; | |
+json.abstract_schema.regressions.FIELDS[3] = {}; | |
+json.abstract_schema.regressions.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.regressions.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.regressions.FIELDS[3].REFERENCES.COLUMN = "bug_id"; | |
+json.abstract_schema.regressions.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.regressions.FIELDS[3].REFERENCES.TABLE = "bugs"; | |
+json.abstract_schema.regressions.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.regressions.INDEXES = []; | |
+json.abstract_schema.regressions.INDEXES[0] = "regressions_regresses_idx"; | |
+json.abstract_schema.regressions.INDEXES[1] = {}; | |
+json.abstract_schema.regressions.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.regressions.INDEXES[1].FIELDS[0] = "regresses"; | |
+json.abstract_schema.regressions.INDEXES[1].FIELDS[1] = "regressed_by"; | |
+json.abstract_schema.regressions.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.regressions.INDEXES[2] = "regressions_regressed_by_idx"; | |
+json.abstract_schema.regressions.INDEXES[3] = []; | |
+json.abstract_schema.regressions.INDEXES[3][0] = "regressed_by"; | |
json.abstract_schema.rep_platform = {}; | |
json.abstract_schema.rep_platform.FIELDS = []; | |
json.abstract_schema.rep_platform.FIELDS[0] = "id"; | |
@@ -2047,36 +3271,21 @@ | |
json.abstract_schema.rep_platform.INDEXES[4] = "rep_platform_visibility_value_id_idx"; | |
json.abstract_schema.rep_platform.INDEXES[5] = []; | |
json.abstract_schema.rep_platform.INDEXES[5][0] = "visibility_value_id"; | |
-json.abstract_schema.reports = {}; | |
-json.abstract_schema.reports.FIELDS = []; | |
-json.abstract_schema.reports.FIELDS[0] = "id"; | |
-json.abstract_schema.reports.FIELDS[1] = {}; | |
-json.abstract_schema.reports.FIELDS[1].NOTNULL = 1; | |
-json.abstract_schema.reports.FIELDS[1].PRIMARYKEY = 1; | |
-json.abstract_schema.reports.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
-json.abstract_schema.reports.FIELDS[2] = "user_id"; | |
-json.abstract_schema.reports.FIELDS[3] = {}; | |
-json.abstract_schema.reports.FIELDS[3].NOTNULL = 1; | |
-json.abstract_schema.reports.FIELDS[3].REFERENCES = {}; | |
-json.abstract_schema.reports.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
-json.abstract_schema.reports.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
-json.abstract_schema.reports.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
-json.abstract_schema.reports.FIELDS[3].TYPE = "INT3"; | |
-json.abstract_schema.reports.FIELDS[4] = "name"; | |
-json.abstract_schema.reports.FIELDS[5] = {}; | |
-json.abstract_schema.reports.FIELDS[5].NOTNULL = 1; | |
-json.abstract_schema.reports.FIELDS[5].TYPE = "varchar(64)"; | |
-json.abstract_schema.reports.FIELDS[6] = "query"; | |
-json.abstract_schema.reports.FIELDS[7] = {}; | |
-json.abstract_schema.reports.FIELDS[7].NOTNULL = 1; | |
-json.abstract_schema.reports.FIELDS[7].TYPE = "LONGTEXT"; | |
-json.abstract_schema.reports.INDEXES = []; | |
-json.abstract_schema.reports.INDEXES[0] = "reports_user_id_idx"; | |
-json.abstract_schema.reports.INDEXES[1] = {}; | |
-json.abstract_schema.reports.INDEXES[1].FIELDS = []; | |
-json.abstract_schema.reports.INDEXES[1].FIELDS[0] = "user_id"; | |
-json.abstract_schema.reports.INDEXES[1].FIELDS[1] = "name"; | |
-json.abstract_schema.reports.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.report_ping = {}; | |
+json.abstract_schema.report_ping.FIELDS = []; | |
+json.abstract_schema.report_ping.FIELDS[0] = "id"; | |
+json.abstract_schema.report_ping.FIELDS[1] = {}; | |
+json.abstract_schema.report_ping.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.report_ping.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.report_ping.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.report_ping.FIELDS[2] = "class"; | |
+json.abstract_schema.report_ping.FIELDS[3] = {}; | |
+json.abstract_schema.report_ping.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.report_ping.FIELDS[3].TYPE = "varchar(255)"; | |
+json.abstract_schema.report_ping.FIELDS[4] = "last_ping_ts"; | |
+json.abstract_schema.report_ping.FIELDS[5] = {}; | |
+json.abstract_schema.report_ping.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.report_ping.FIELDS[5].TYPE = "DATETIME"; | |
json.abstract_schema.resolution = {}; | |
json.abstract_schema.resolution.FIELDS = []; | |
json.abstract_schema.resolution.FIELDS[0] = "id"; | |
@@ -2233,6 +3442,11 @@ | |
json.abstract_schema.setting.FIELDS[6] = "subclass"; | |
json.abstract_schema.setting.FIELDS[7] = {}; | |
json.abstract_schema.setting.FIELDS[7].TYPE = "varchar(32)"; | |
+json.abstract_schema.setting.FIELDS[8] = "category"; | |
+json.abstract_schema.setting.FIELDS[9] = {}; | |
+json.abstract_schema.setting.FIELDS[9].DEFAULT = "'General'"; | |
+json.abstract_schema.setting.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.setting.FIELDS[9].TYPE = "varchar(64)"; | |
json.abstract_schema.setting_value = {}; | |
json.abstract_schema.setting_value.FIELDS = []; | |
json.abstract_schema.setting_value.FIELDS[0] = "name"; | |
@@ -2319,6 +3533,31 @@ | |
json.abstract_schema.tag.INDEXES[1].FIELDS[0] = "user_id"; | |
json.abstract_schema.tag.INDEXES[1].FIELDS[1] = "name"; | |
json.abstract_schema.tag.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.token_data = {}; | |
+json.abstract_schema.token_data.FIELDS = []; | |
+json.abstract_schema.token_data.FIELDS[0] = "id"; | |
+json.abstract_schema.token_data.FIELDS[1] = {}; | |
+json.abstract_schema.token_data.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.token_data.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.token_data.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.token_data.FIELDS[2] = "token"; | |
+json.abstract_schema.token_data.FIELDS[3] = {}; | |
+json.abstract_schema.token_data.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.token_data.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.token_data.FIELDS[3].REFERENCES.COLUMN = "token"; | |
+json.abstract_schema.token_data.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.token_data.FIELDS[3].REFERENCES.TABLE = "tokens"; | |
+json.abstract_schema.token_data.FIELDS[3].TYPE = "varchar(22)"; | |
+json.abstract_schema.token_data.FIELDS[4] = "extra_data"; | |
+json.abstract_schema.token_data.FIELDS[5] = {}; | |
+json.abstract_schema.token_data.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.token_data.FIELDS[5].TYPE = "MEDIUMTEXT"; | |
+json.abstract_schema.token_data.INDEXES = []; | |
+json.abstract_schema.token_data.INDEXES[0] = "token_data_idx"; | |
+json.abstract_schema.token_data.INDEXES[1] = {}; | |
+json.abstract_schema.token_data.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.token_data.INDEXES[1].FIELDS[0] = "token"; | |
+json.abstract_schema.token_data.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.tokens = {}; | |
json.abstract_schema.tokens.FIELDS = []; | |
json.abstract_schema.tokens.FIELDS[0] = "userid"; | |
@@ -2336,7 +3575,7 @@ | |
json.abstract_schema.tokens.FIELDS[5] = {}; | |
json.abstract_schema.tokens.FIELDS[5].NOTNULL = 1; | |
json.abstract_schema.tokens.FIELDS[5].PRIMARYKEY = 1; | |
-json.abstract_schema.tokens.FIELDS[5].TYPE = "varchar(16)"; | |
+json.abstract_schema.tokens.FIELDS[5].TYPE = "varchar(22)"; | |
json.abstract_schema.tokens.FIELDS[6] = "tokentype"; | |
json.abstract_schema.tokens.FIELDS[7] = {}; | |
json.abstract_schema.tokens.FIELDS[7].NOTNULL = 1; | |
@@ -2348,6 +3587,180 @@ | |
json.abstract_schema.tokens.INDEXES[0] = "tokens_userid_idx"; | |
json.abstract_schema.tokens.INDEXES[1] = []; | |
json.abstract_schema.tokens.INDEXES[1][0] = "userid"; | |
+json.abstract_schema.tracking_flags = {}; | |
+json.abstract_schema.tracking_flags.FIELDS = []; | |
+json.abstract_schema.tracking_flags.FIELDS[0] = "id"; | |
+json.abstract_schema.tracking_flags.FIELDS[1] = {}; | |
+json.abstract_schema.tracking_flags.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.tracking_flags.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.tracking_flags.FIELDS[2] = "field_id"; | |
+json.abstract_schema.tracking_flags.FIELDS[3] = {}; | |
+json.abstract_schema.tracking_flags.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.tracking_flags.FIELDS[3].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.tracking_flags.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.tracking_flags.FIELDS[3].REFERENCES.TABLE = "fielddefs"; | |
+json.abstract_schema.tracking_flags.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.tracking_flags.FIELDS[4] = "name"; | |
+json.abstract_schema.tracking_flags.FIELDS[5] = {}; | |
+json.abstract_schema.tracking_flags.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags.FIELDS[5].TYPE = "varchar(64)"; | |
+json.abstract_schema.tracking_flags.FIELDS[6] = "description"; | |
+json.abstract_schema.tracking_flags.FIELDS[7] = {}; | |
+json.abstract_schema.tracking_flags.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags.FIELDS[7].TYPE = "varchar(64)"; | |
+json.abstract_schema.tracking_flags.FIELDS[8] = "type"; | |
+json.abstract_schema.tracking_flags.FIELDS[9] = {}; | |
+json.abstract_schema.tracking_flags.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags.FIELDS[9].TYPE = "varchar(64)"; | |
+json.abstract_schema.tracking_flags.FIELDS[10] = "sortkey"; | |
+json.abstract_schema.tracking_flags.FIELDS[11] = {}; | |
+json.abstract_schema.tracking_flags.FIELDS[11].DEFAULT = "0"; | |
+json.abstract_schema.tracking_flags.FIELDS[11].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags.FIELDS[11].TYPE = "INT2"; | |
+json.abstract_schema.tracking_flags.FIELDS[12] = "enter_bug"; | |
+json.abstract_schema.tracking_flags.FIELDS[13] = {}; | |
+json.abstract_schema.tracking_flags.FIELDS[13].DEFAULT = "TRUE"; | |
+json.abstract_schema.tracking_flags.FIELDS[13].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags.FIELDS[13].TYPE = "BOOLEAN"; | |
+json.abstract_schema.tracking_flags.FIELDS[14] = "is_active"; | |
+json.abstract_schema.tracking_flags.FIELDS[15] = {}; | |
+json.abstract_schema.tracking_flags.FIELDS[15].DEFAULT = "TRUE"; | |
+json.abstract_schema.tracking_flags.FIELDS[15].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags.FIELDS[15].TYPE = "BOOLEAN"; | |
+json.abstract_schema.tracking_flags.INDEXES = []; | |
+json.abstract_schema.tracking_flags.INDEXES[0] = "tracking_flags_idx"; | |
+json.abstract_schema.tracking_flags.INDEXES[1] = {}; | |
+json.abstract_schema.tracking_flags.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.tracking_flags.INDEXES[1].FIELDS[0] = "name"; | |
+json.abstract_schema.tracking_flags.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.tracking_flags_bugs = {}; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS = []; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[0] = "id"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[1] = {}; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[2] = "tracking_flag_id"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[3] = {}; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[3].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[3].REFERENCES.TABLE = "tracking_flags"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[4] = "bug_id"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[5] = {}; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[5].REFERENCES = {}; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[5].REFERENCES.COLUMN = "bug_id"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[5].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[5].REFERENCES.TABLE = "bugs"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[5].TYPE = "INT3"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[6] = "value"; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[7] = {}; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_bugs.FIELDS[7].TYPE = "varchar(64)"; | |
+json.abstract_schema.tracking_flags_bugs.INDEXES = []; | |
+json.abstract_schema.tracking_flags_bugs.INDEXES[0] = "tracking_flags_bugs_idx"; | |
+json.abstract_schema.tracking_flags_bugs.INDEXES[1] = {}; | |
+json.abstract_schema.tracking_flags_bugs.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.tracking_flags_bugs.INDEXES[1].FIELDS[0] = "tracking_flag_id"; | |
+json.abstract_schema.tracking_flags_bugs.INDEXES[1].FIELDS[1] = "bug_id"; | |
+json.abstract_schema.tracking_flags_bugs.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.tracking_flags_values = {}; | |
+json.abstract_schema.tracking_flags_values.FIELDS = []; | |
+json.abstract_schema.tracking_flags_values.FIELDS[0] = "id"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[1] = {}; | |
+json.abstract_schema.tracking_flags_values.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_values.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.tracking_flags_values.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[2] = "tracking_flag_id"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[3] = {}; | |
+json.abstract_schema.tracking_flags_values.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_values.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.tracking_flags_values.FIELDS[3].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[3].REFERENCES.TABLE = "tracking_flags"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[4] = "setter_group_id"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[5] = {}; | |
+json.abstract_schema.tracking_flags_values.FIELDS[5].NOTNULL = 0; | |
+json.abstract_schema.tracking_flags_values.FIELDS[5].REFERENCES = {}; | |
+json.abstract_schema.tracking_flags_values.FIELDS[5].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[5].REFERENCES.DELETE = "SET NULL"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[5].REFERENCES.TABLE = "groups"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[5].TYPE = "INT3"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[6] = "value"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[7] = {}; | |
+json.abstract_schema.tracking_flags_values.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_values.FIELDS[7].TYPE = "varchar(64)"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[8] = "sortkey"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[9] = {}; | |
+json.abstract_schema.tracking_flags_values.FIELDS[9].DEFAULT = "0"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_values.FIELDS[9].TYPE = "INT2"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[10] = "enter_bug"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[11] = {}; | |
+json.abstract_schema.tracking_flags_values.FIELDS[11].DEFAULT = "TRUE"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[11].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_values.FIELDS[11].TYPE = "BOOLEAN"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[12] = "is_active"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[13] = {}; | |
+json.abstract_schema.tracking_flags_values.FIELDS[13].DEFAULT = "TRUE"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[13].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_values.FIELDS[13].TYPE = "BOOLEAN"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[14] = "comment"; | |
+json.abstract_schema.tracking_flags_values.FIELDS[15] = {}; | |
+json.abstract_schema.tracking_flags_values.FIELDS[15].NOTNULL = 0; | |
+json.abstract_schema.tracking_flags_values.FIELDS[15].TYPE = "TEXT"; | |
+json.abstract_schema.tracking_flags_values.INDEXES = []; | |
+json.abstract_schema.tracking_flags_values.INDEXES[0] = "tracking_flags_values_idx"; | |
+json.abstract_schema.tracking_flags_values.INDEXES[1] = {}; | |
+json.abstract_schema.tracking_flags_values.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.tracking_flags_values.INDEXES[1].FIELDS[0] = "tracking_flag_id"; | |
+json.abstract_schema.tracking_flags_values.INDEXES[1].FIELDS[1] = "value"; | |
+json.abstract_schema.tracking_flags_values.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.tracking_flags_visibility = {}; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS = []; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[0] = "id"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[1] = {}; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[1].TYPE = "MEDIUMSERIAL"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[2] = "tracking_flag_id"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[3] = {}; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[3].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[3].REFERENCES.TABLE = "tracking_flags"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[4] = "product_id"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[5] = {}; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[5].REFERENCES = {}; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[5].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[5].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[5].REFERENCES.TABLE = "products"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[5].TYPE = "INT2"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[6] = "component_id"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[7] = {}; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[7].NOTNULL = 0; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[7].REFERENCES = {}; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[7].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[7].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[7].REFERENCES.TABLE = "components"; | |
+json.abstract_schema.tracking_flags_visibility.FIELDS[7].TYPE = "INT2"; | |
+json.abstract_schema.tracking_flags_visibility.INDEXES = []; | |
+json.abstract_schema.tracking_flags_visibility.INDEXES[0] = "tracking_flags_visibility_idx"; | |
+json.abstract_schema.tracking_flags_visibility.INDEXES[1] = {}; | |
+json.abstract_schema.tracking_flags_visibility.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.tracking_flags_visibility.INDEXES[1].FIELDS[0] = "tracking_flag_id"; | |
+json.abstract_schema.tracking_flags_visibility.INDEXES[1].FIELDS[1] = "product_id"; | |
+json.abstract_schema.tracking_flags_visibility.INDEXES[1].FIELDS[2] = "component_id"; | |
+json.abstract_schema.tracking_flags_visibility.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.ts_error = {}; | |
json.abstract_schema.ts_error.FIELDS = []; | |
json.abstract_schema.ts_error.FIELDS[0] = "error_time"; | |
@@ -2509,18 +3922,33 @@ | |
json.abstract_schema.user_api_keys.FIELDS[4] = "api_key"; | |
json.abstract_schema.user_api_keys.FIELDS[5] = {}; | |
json.abstract_schema.user_api_keys.FIELDS[5].NOTNULL = 1; | |
-json.abstract_schema.user_api_keys.FIELDS[5].TYPE = "VARCHAR(40)"; | |
+json.abstract_schema.user_api_keys.FIELDS[5].TYPE = "varchar(40)"; | |
json.abstract_schema.user_api_keys.FIELDS[6] = "description"; | |
json.abstract_schema.user_api_keys.FIELDS[7] = {}; | |
-json.abstract_schema.user_api_keys.FIELDS[7].TYPE = "VARCHAR(255)"; | |
+json.abstract_schema.user_api_keys.FIELDS[7].TYPE = "varchar(255)"; | |
json.abstract_schema.user_api_keys.FIELDS[8] = "revoked"; | |
json.abstract_schema.user_api_keys.FIELDS[9] = {}; | |
json.abstract_schema.user_api_keys.FIELDS[9].DEFAULT = "FALSE"; | |
json.abstract_schema.user_api_keys.FIELDS[9].NOTNULL = 1; | |
json.abstract_schema.user_api_keys.FIELDS[9].TYPE = "BOOLEAN"; | |
-json.abstract_schema.user_api_keys.FIELDS[10] = "last_used"; | |
+json.abstract_schema.user_api_keys.FIELDS[10] = "creation_ts"; | |
json.abstract_schema.user_api_keys.FIELDS[11] = {}; | |
+json.abstract_schema.user_api_keys.FIELDS[11].NOTNULL = 1; | |
json.abstract_schema.user_api_keys.FIELDS[11].TYPE = "DATETIME"; | |
+json.abstract_schema.user_api_keys.FIELDS[12] = "last_used"; | |
+json.abstract_schema.user_api_keys.FIELDS[13] = {}; | |
+json.abstract_schema.user_api_keys.FIELDS[13].TYPE = "DATETIME"; | |
+json.abstract_schema.user_api_keys.FIELDS[14] = "last_used_ip"; | |
+json.abstract_schema.user_api_keys.FIELDS[15] = {}; | |
+json.abstract_schema.user_api_keys.FIELDS[15].TYPE = "varchar(40)"; | |
+json.abstract_schema.user_api_keys.FIELDS[16] = "app_id"; | |
+json.abstract_schema.user_api_keys.FIELDS[17] = {}; | |
+json.abstract_schema.user_api_keys.FIELDS[17].TYPE = "varchar(64)"; | |
+json.abstract_schema.user_api_keys.FIELDS[18] = "sticky"; | |
+json.abstract_schema.user_api_keys.FIELDS[19] = {}; | |
+json.abstract_schema.user_api_keys.FIELDS[19].DEFAULT = "FALSE"; | |
+json.abstract_schema.user_api_keys.FIELDS[19].NOTNULL = 1; | |
+json.abstract_schema.user_api_keys.FIELDS[19].TYPE = "BOOLEAN"; | |
json.abstract_schema.user_api_keys.INDEXES = []; | |
json.abstract_schema.user_api_keys.INDEXES[0] = "user_api_keys_api_key_idx"; | |
json.abstract_schema.user_api_keys.INDEXES[1] = {}; | |
@@ -2530,6 +3958,10 @@ | |
json.abstract_schema.user_api_keys.INDEXES[2] = "user_api_keys_user_id_idx"; | |
json.abstract_schema.user_api_keys.INDEXES[3] = []; | |
json.abstract_schema.user_api_keys.INDEXES[3][0] = "user_id"; | |
+json.abstract_schema.user_api_keys.INDEXES[4] = "user_api_keys_user_id_app_id_idx"; | |
+json.abstract_schema.user_api_keys.INDEXES[5] = []; | |
+json.abstract_schema.user_api_keys.INDEXES[5][0] = "user_id"; | |
+json.abstract_schema.user_api_keys.INDEXES[5][1] = "app_id"; | |
json.abstract_schema.user_group_map = {}; | |
json.abstract_schema.user_group_map.FIELDS = []; | |
json.abstract_schema.user_group_map.FIELDS[0] = "user_id"; | |
@@ -2567,6 +3999,57 @@ | |
json.abstract_schema.user_group_map.INDEXES[1].FIELDS[2] = "grant_type"; | |
json.abstract_schema.user_group_map.INDEXES[1].FIELDS[3] = "isbless"; | |
json.abstract_schema.user_group_map.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.user_request_log = {}; | |
+json.abstract_schema.user_request_log.FIELDS = []; | |
+json.abstract_schema.user_request_log.FIELDS[0] = "id"; | |
+json.abstract_schema.user_request_log.FIELDS[1] = {}; | |
+json.abstract_schema.user_request_log.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.user_request_log.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.user_request_log.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.user_request_log.FIELDS[2] = "user_id"; | |
+json.abstract_schema.user_request_log.FIELDS[3] = {}; | |
+json.abstract_schema.user_request_log.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.user_request_log.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.user_request_log.FIELDS[4] = "ip_address"; | |
+json.abstract_schema.user_request_log.FIELDS[5] = {}; | |
+json.abstract_schema.user_request_log.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.user_request_log.FIELDS[5].TYPE = "varchar(40)"; | |
+json.abstract_schema.user_request_log.FIELDS[6] = "user_agent"; | |
+json.abstract_schema.user_request_log.FIELDS[7] = {}; | |
+json.abstract_schema.user_request_log.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.user_request_log.FIELDS[7].TYPE = "TINYTEXT"; | |
+json.abstract_schema.user_request_log.FIELDS[8] = "timestamp"; | |
+json.abstract_schema.user_request_log.FIELDS[9] = {}; | |
+json.abstract_schema.user_request_log.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.user_request_log.FIELDS[9].TYPE = "DATETIME"; | |
+json.abstract_schema.user_request_log.FIELDS[10] = "bug_id"; | |
+json.abstract_schema.user_request_log.FIELDS[11] = {}; | |
+json.abstract_schema.user_request_log.FIELDS[11].NOTNULL = 0; | |
+json.abstract_schema.user_request_log.FIELDS[11].TYPE = "INT3"; | |
+json.abstract_schema.user_request_log.FIELDS[12] = "attach_id"; | |
+json.abstract_schema.user_request_log.FIELDS[13] = {}; | |
+json.abstract_schema.user_request_log.FIELDS[13].NOTNULL = 0; | |
+json.abstract_schema.user_request_log.FIELDS[13].TYPE = "INT5"; | |
+json.abstract_schema.user_request_log.FIELDS[14] = "request_url"; | |
+json.abstract_schema.user_request_log.FIELDS[15] = {}; | |
+json.abstract_schema.user_request_log.FIELDS[15].NOTNULL = 1; | |
+json.abstract_schema.user_request_log.FIELDS[15].TYPE = "TINYTEXT"; | |
+json.abstract_schema.user_request_log.FIELDS[16] = "method"; | |
+json.abstract_schema.user_request_log.FIELDS[17] = {}; | |
+json.abstract_schema.user_request_log.FIELDS[17].NOTNULL = 1; | |
+json.abstract_schema.user_request_log.FIELDS[17].TYPE = "TINYTEXT"; | |
+json.abstract_schema.user_request_log.FIELDS[18] = "action"; | |
+json.abstract_schema.user_request_log.FIELDS[19] = {}; | |
+json.abstract_schema.user_request_log.FIELDS[19].NOTNULL = 1; | |
+json.abstract_schema.user_request_log.FIELDS[19].TYPE = "varchar(20)"; | |
+json.abstract_schema.user_request_log.FIELDS[20] = "server"; | |
+json.abstract_schema.user_request_log.FIELDS[21] = {}; | |
+json.abstract_schema.user_request_log.FIELDS[21].NOTNULL = 1; | |
+json.abstract_schema.user_request_log.FIELDS[21].TYPE = "varchar(7)"; | |
+json.abstract_schema.user_request_log.INDEXES = []; | |
+json.abstract_schema.user_request_log.INDEXES[0] = "user_user_request_log_user_id_idx"; | |
+json.abstract_schema.user_request_log.INDEXES[1] = []; | |
+json.abstract_schema.user_request_log.INDEXES[1][0] = "user_id"; | |
json.abstract_schema.versions = {}; | |
json.abstract_schema.versions.FIELDS = []; | |
json.abstract_schema.versions.FIELDS[0] = "id"; | |
@@ -2598,6 +4081,35 @@ | |
json.abstract_schema.versions.INDEXES[1].FIELDS[0] = "product_id"; | |
json.abstract_schema.versions.INDEXES[1].FIELDS[1] = "value"; | |
json.abstract_schema.versions.INDEXES[1].TYPE = "UNIQUE"; | |
+json.abstract_schema.votes = {}; | |
+json.abstract_schema.votes.FIELDS = []; | |
+json.abstract_schema.votes.FIELDS[0] = "who"; | |
+json.abstract_schema.votes.FIELDS[1] = {}; | |
+json.abstract_schema.votes.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.votes.FIELDS[1].REFERENCES = {}; | |
+json.abstract_schema.votes.FIELDS[1].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.votes.FIELDS[1].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.votes.FIELDS[1].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.votes.FIELDS[1].TYPE = "INT3"; | |
+json.abstract_schema.votes.FIELDS[2] = "bug_id"; | |
+json.abstract_schema.votes.FIELDS[3] = {}; | |
+json.abstract_schema.votes.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.votes.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.votes.FIELDS[3].REFERENCES.COLUMN = "bug_id"; | |
+json.abstract_schema.votes.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.votes.FIELDS[3].REFERENCES.TABLE = "bugs"; | |
+json.abstract_schema.votes.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.votes.FIELDS[4] = "vote_count"; | |
+json.abstract_schema.votes.FIELDS[5] = {}; | |
+json.abstract_schema.votes.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.votes.FIELDS[5].TYPE = "INT2"; | |
+json.abstract_schema.votes.INDEXES = []; | |
+json.abstract_schema.votes.INDEXES[0] = "votes_who_idx"; | |
+json.abstract_schema.votes.INDEXES[1] = []; | |
+json.abstract_schema.votes.INDEXES[1][0] = "who"; | |
+json.abstract_schema.votes.INDEXES[2] = "votes_bug_id_idx"; | |
+json.abstract_schema.votes.INDEXES[3] = []; | |
+json.abstract_schema.votes.INDEXES[3][0] = "bug_id"; | |
json.abstract_schema.watch = {}; | |
json.abstract_schema.watch.FIELDS = []; | |
json.abstract_schema.watch.FIELDS[0] = "watcher"; | |
@@ -2626,6 +4138,56 @@ | |
json.abstract_schema.watch.INDEXES[2] = "watch_watched_idx"; | |
json.abstract_schema.watch.INDEXES[3] = []; | |
json.abstract_schema.watch.INDEXES[3][0] = "watched"; | |
+json.abstract_schema.webhooks = {}; | |
+json.abstract_schema.webhooks.FIELDS = []; | |
+json.abstract_schema.webhooks.FIELDS[0] = "id"; | |
+json.abstract_schema.webhooks.FIELDS[1] = {}; | |
+json.abstract_schema.webhooks.FIELDS[1].NOTNULL = 1; | |
+json.abstract_schema.webhooks.FIELDS[1].PRIMARYKEY = 1; | |
+json.abstract_schema.webhooks.FIELDS[1].TYPE = "INTSERIAL"; | |
+json.abstract_schema.webhooks.FIELDS[2] = "user_id"; | |
+json.abstract_schema.webhooks.FIELDS[3] = {}; | |
+json.abstract_schema.webhooks.FIELDS[3].NOTNULL = 1; | |
+json.abstract_schema.webhooks.FIELDS[3].REFERENCES = {}; | |
+json.abstract_schema.webhooks.FIELDS[3].REFERENCES.COLUMN = "userid"; | |
+json.abstract_schema.webhooks.FIELDS[3].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.webhooks.FIELDS[3].REFERENCES.TABLE = "profiles"; | |
+json.abstract_schema.webhooks.FIELDS[3].TYPE = "INT3"; | |
+json.abstract_schema.webhooks.FIELDS[4] = "name"; | |
+json.abstract_schema.webhooks.FIELDS[5] = {}; | |
+json.abstract_schema.webhooks.FIELDS[5].NOTNULL = 1; | |
+json.abstract_schema.webhooks.FIELDS[5].TYPE = "VARCHAR(64)"; | |
+json.abstract_schema.webhooks.FIELDS[6] = "url"; | |
+json.abstract_schema.webhooks.FIELDS[7] = {}; | |
+json.abstract_schema.webhooks.FIELDS[7].NOTNULL = 1; | |
+json.abstract_schema.webhooks.FIELDS[7].TYPE = "VARCHAR(64)"; | |
+json.abstract_schema.webhooks.FIELDS[8] = "event"; | |
+json.abstract_schema.webhooks.FIELDS[9] = {}; | |
+json.abstract_schema.webhooks.FIELDS[9].NOTNULL = 1; | |
+json.abstract_schema.webhooks.FIELDS[9].TYPE = "VARCHAR(64)"; | |
+json.abstract_schema.webhooks.FIELDS[10] = "product_id"; | |
+json.abstract_schema.webhooks.FIELDS[11] = {}; | |
+json.abstract_schema.webhooks.FIELDS[11].NOTNULL = 1; | |
+json.abstract_schema.webhooks.FIELDS[11].REFERENCES = {}; | |
+json.abstract_schema.webhooks.FIELDS[11].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.webhooks.FIELDS[11].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.webhooks.FIELDS[11].REFERENCES.TABLE = "products"; | |
+json.abstract_schema.webhooks.FIELDS[11].TYPE = "INT2"; | |
+json.abstract_schema.webhooks.FIELDS[12] = "component_id"; | |
+json.abstract_schema.webhooks.FIELDS[13] = {}; | |
+json.abstract_schema.webhooks.FIELDS[13].NOTNULL = 0; | |
+json.abstract_schema.webhooks.FIELDS[13].REFERENCES = {}; | |
+json.abstract_schema.webhooks.FIELDS[13].REFERENCES.COLUMN = "id"; | |
+json.abstract_schema.webhooks.FIELDS[13].REFERENCES.DELETE = "CASCADE"; | |
+json.abstract_schema.webhooks.FIELDS[13].REFERENCES.TABLE = "components"; | |
+json.abstract_schema.webhooks.FIELDS[13].TYPE = "INT2"; | |
+json.abstract_schema.webhooks.INDEXES = []; | |
+json.abstract_schema.webhooks.INDEXES[0] = "webhooks_userid_name_idx"; | |
+json.abstract_schema.webhooks.INDEXES[1] = {}; | |
+json.abstract_schema.webhooks.INDEXES[1].FIELDS = []; | |
+json.abstract_schema.webhooks.INDEXES[1].FIELDS[0] = "user_id"; | |
+json.abstract_schema.webhooks.INDEXES[1].FIELDS[1] = "name"; | |
+json.abstract_schema.webhooks.INDEXES[1].TYPE = "UNIQUE"; | |
json.abstract_schema.whine_events = {}; | |
json.abstract_schema.whine_events.FIELDS = []; | |
json.abstract_schema.whine_events.FIELDS[0] = "id"; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment