Edit File by line
/home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../eventum
File: eventum.sql
[0] Fix | Delete
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
[1] Fix | Delete
SET time_zone = "+00:00";
[2] Fix | Delete
[3] Fix | Delete
[4] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
[5] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
[6] Fix | Delete
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
[7] Fix | Delete
/*!40101 SET NAMES utf8 */;
[8] Fix | Delete
[9] Fix | Delete
--
[10] Fix | Delete
-- Database: `eventum367`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `api_token`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `api_token` (
[20] Fix | Delete
`apt_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`apt_usr_id` int(10) unsigned NOT NULL,
[22] Fix | Delete
`apt_created` datetime NOT NULL,
[23] Fix | Delete
`apt_status` varchar(10) NOT NULL DEFAULT 'active',
[24] Fix | Delete
`apt_token` varchar(32) NOT NULL,
[25] Fix | Delete
PRIMARY KEY (`apt_id`),
[26] Fix | Delete
KEY `apt_usr_id` (`apt_usr_id`,`apt_status`),
[27] Fix | Delete
KEY `apt_token` (`apt_token`)
[28] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[29] Fix | Delete
[30] Fix | Delete
-- --------------------------------------------------------
[31] Fix | Delete
[32] Fix | Delete
--
[33] Fix | Delete
-- Table structure for table `attachment_chunk`
[34] Fix | Delete
--
[35] Fix | Delete
[36] Fix | Delete
CREATE TABLE `attachment_chunk` (
[37] Fix | Delete
`path_id` mediumint(8) unsigned NOT NULL,
[38] Fix | Delete
`chunk_no` smallint(6) unsigned NOT NULL,
[39] Fix | Delete
`content` mediumblob NOT NULL,
[40] Fix | Delete
PRIMARY KEY (`path_id`,`chunk_no`)
[41] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[42] Fix | Delete
[43] Fix | Delete
-- --------------------------------------------------------
[44] Fix | Delete
[45] Fix | Delete
--
[46] Fix | Delete
-- Table structure for table `attachment_path`
[47] Fix | Delete
--
[48] Fix | Delete
[49] Fix | Delete
CREATE TABLE `attachment_path` (
[50] Fix | Delete
`path_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[51] Fix | Delete
`type` enum('dir','file') NOT NULL,
[52] Fix | Delete
`path` varchar(255) NOT NULL,
[53] Fix | Delete
`mimetype` varchar(255) CHARACTER SET ascii DEFAULT NULL,
[54] Fix | Delete
`visibility` varchar(25) DEFAULT '',
[55] Fix | Delete
`size` int(11) unsigned DEFAULT NULL,
[56] Fix | Delete
`is_compressed` tinyint(4) NOT NULL DEFAULT '1',
[57] Fix | Delete
`update_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
[58] Fix | Delete
PRIMARY KEY (`path_id`)
[59] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[60] Fix | Delete
[61] Fix | Delete
-- --------------------------------------------------------
[62] Fix | Delete
[63] Fix | Delete
--
[64] Fix | Delete
-- Table structure for table `columns_to_display`
[65] Fix | Delete
--
[66] Fix | Delete
[67] Fix | Delete
CREATE TABLE `columns_to_display` (
[68] Fix | Delete
`ctd_prj_id` int(11) unsigned NOT NULL,
[69] Fix | Delete
`ctd_page` varchar(20) NOT NULL,
[70] Fix | Delete
`ctd_field` varchar(30) NOT NULL,
[71] Fix | Delete
`ctd_min_role` tinyint(1) NOT NULL DEFAULT '0',
[72] Fix | Delete
`ctd_rank` tinyint(4) NOT NULL DEFAULT '0',
[73] Fix | Delete
PRIMARY KEY (`ctd_prj_id`,`ctd_page`,`ctd_field`),
[74] Fix | Delete
KEY `ctd_prj_id` (`ctd_prj_id`,`ctd_page`)
[75] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[76] Fix | Delete
[77] Fix | Delete
--
[78] Fix | Delete
-- Dumping data for table `columns_to_display`
[79] Fix | Delete
--
[80] Fix | Delete
[81] Fix | Delete
INSERT INTO `columns_to_display` VALUES
[82] Fix | Delete
(1, 'list_issues', 'pri_rank', 1, 1),
[83] Fix | Delete
(1, 'list_issues', 'iss_id', 1, 2),
[84] Fix | Delete
(1, 'list_issues', 'usr_full_name', 1, 3),
[85] Fix | Delete
(1, 'list_issues', 'grp_name', 1, 4),
[86] Fix | Delete
(1, 'list_issues', 'assigned', 1, 5),
[87] Fix | Delete
(1, 'list_issues', 'time_spent', 1, 6),
[88] Fix | Delete
(1, 'list_issues', 'prc_title', 1, 7),
[89] Fix | Delete
(1, 'list_issues', 'pre_title', 1, 8),
[90] Fix | Delete
(1, 'list_issues', 'iss_customer_id', 1, 9),
[91] Fix | Delete
(1, 'list_issues', 'sta_rank', 1, 10),
[92] Fix | Delete
(1, 'list_issues', 'status_action_date', 1, 11),
[93] Fix | Delete
(1, 'list_issues', 'last_action_date', 1, 12),
[94] Fix | Delete
(1, 'list_issues', 'custom_fields', 1, 13),
[95] Fix | Delete
(1, 'list_issues', 'iss_summary', 1, 14),
[96] Fix | Delete
(1, 'list_issues', 'iss_dev_time', 9, 15),
[97] Fix | Delete
(1, 'list_issues', 'iss_percent_complete', 9, 16);
[98] Fix | Delete
[99] Fix | Delete
-- --------------------------------------------------------
[100] Fix | Delete
[101] Fix | Delete
--
[102] Fix | Delete
-- Table structure for table `commit`
[103] Fix | Delete
--
[104] Fix | Delete
[105] Fix | Delete
CREATE TABLE `commit` (
[106] Fix | Delete
`com_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[107] Fix | Delete
`com_scm_name` varchar(255) NOT NULL DEFAULT 'default',
[108] Fix | Delete
`com_project_name` varchar(255) DEFAULT NULL,
[109] Fix | Delete
`com_changeset` varchar(40) NOT NULL,
[110] Fix | Delete
`com_branch` varchar(255) DEFAULT NULL,
[111] Fix | Delete
`com_author_email` varchar(255) DEFAULT NULL,
[112] Fix | Delete
`com_author_name` varchar(255) DEFAULT NULL,
[113] Fix | Delete
`com_usr_id` int(11) DEFAULT NULL,
[114] Fix | Delete
`com_commit_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[115] Fix | Delete
`com_message` mediumtext,
[116] Fix | Delete
PRIMARY KEY (`com_id`)
[117] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[118] Fix | Delete
[119] Fix | Delete
-- --------------------------------------------------------
[120] Fix | Delete
[121] Fix | Delete
--
[122] Fix | Delete
-- Table structure for table `commit_file`
[123] Fix | Delete
--
[124] Fix | Delete
[125] Fix | Delete
CREATE TABLE `commit_file` (
[126] Fix | Delete
`cof_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[127] Fix | Delete
`cof_com_id` int(10) unsigned NOT NULL,
[128] Fix | Delete
`cof_filename` varchar(255) NOT NULL DEFAULT '',
[129] Fix | Delete
`cof_added` tinyint(1) NOT NULL DEFAULT '0',
[130] Fix | Delete
`cof_modified` tinyint(1) NOT NULL DEFAULT '0',
[131] Fix | Delete
`cof_removed` tinyint(1) NOT NULL DEFAULT '0',
[132] Fix | Delete
`cof_old_version` varchar(40) DEFAULT NULL,
[133] Fix | Delete
`cof_new_version` varchar(40) DEFAULT NULL,
[134] Fix | Delete
PRIMARY KEY (`cof_id`)
[135] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[136] Fix | Delete
[137] Fix | Delete
-- --------------------------------------------------------
[138] Fix | Delete
[139] Fix | Delete
--
[140] Fix | Delete
-- Table structure for table `customer_account_manager`
[141] Fix | Delete
--
[142] Fix | Delete
[143] Fix | Delete
CREATE TABLE `customer_account_manager` (
[144] Fix | Delete
`cam_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[145] Fix | Delete
`cam_prj_id` int(11) unsigned NOT NULL,
[146] Fix | Delete
`cam_customer_id` varchar(128) NOT NULL,
[147] Fix | Delete
`cam_usr_id` int(11) unsigned NOT NULL,
[148] Fix | Delete
`cam_type` varchar(7) NOT NULL,
[149] Fix | Delete
PRIMARY KEY (`cam_id`),
[150] Fix | Delete
UNIQUE KEY `cam_manager` (`cam_prj_id`,`cam_customer_id`,`cam_usr_id`),
[151] Fix | Delete
KEY `cam_customer_id` (`cam_customer_id`)
[152] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[153] Fix | Delete
[154] Fix | Delete
-- --------------------------------------------------------
[155] Fix | Delete
[156] Fix | Delete
--
[157] Fix | Delete
-- Table structure for table `customer_note`
[158] Fix | Delete
--
[159] Fix | Delete
[160] Fix | Delete
CREATE TABLE `customer_note` (
[161] Fix | Delete
`cno_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[162] Fix | Delete
`cno_prj_id` int(11) unsigned NOT NULL,
[163] Fix | Delete
`cno_customer_id` varchar(128) NOT NULL,
[164] Fix | Delete
`cno_created_date` datetime NOT NULL,
[165] Fix | Delete
`cno_updated_date` datetime DEFAULT NULL,
[166] Fix | Delete
`cno_note` text,
[167] Fix | Delete
PRIMARY KEY (`cno_id`),
[168] Fix | Delete
UNIQUE KEY `cno_prj_id` (`cno_prj_id`,`cno_customer_id`)
[169] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[170] Fix | Delete
[171] Fix | Delete
-- --------------------------------------------------------
[172] Fix | Delete
[173] Fix | Delete
--
[174] Fix | Delete
-- Table structure for table `custom_field`
[175] Fix | Delete
--
[176] Fix | Delete
[177] Fix | Delete
CREATE TABLE `custom_field` (
[178] Fix | Delete
`fld_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[179] Fix | Delete
`fld_title` varchar(32) NOT NULL DEFAULT '',
[180] Fix | Delete
`fld_description` varchar(64) DEFAULT NULL,
[181] Fix | Delete
`fld_type` varchar(8) NOT NULL DEFAULT 'text',
[182] Fix | Delete
`fld_report_form` int(1) NOT NULL DEFAULT '1',
[183] Fix | Delete
`fld_report_form_required` int(1) NOT NULL DEFAULT '0',
[184] Fix | Delete
`fld_anonymous_form` int(1) NOT NULL DEFAULT '1',
[185] Fix | Delete
`fld_anonymous_form_required` int(1) NOT NULL DEFAULT '0',
[186] Fix | Delete
`fld_close_form` tinyint(1) NOT NULL DEFAULT '0',
[187] Fix | Delete
`fld_close_form_required` tinyint(1) NOT NULL DEFAULT '0',
[188] Fix | Delete
`fld_edit_form_required` tinyint(1) NOT NULL DEFAULT '0',
[189] Fix | Delete
`fld_list_display` tinyint(1) NOT NULL DEFAULT '0',
[190] Fix | Delete
`fld_min_role` tinyint(1) NOT NULL DEFAULT '0',
[191] Fix | Delete
`fld_min_role_edit` tinyint(1) NOT NULL DEFAULT '0',
[192] Fix | Delete
`fld_rank` smallint(6) NOT NULL DEFAULT '0',
[193] Fix | Delete
`fld_backend` varchar(255) CHARACTER SET ascii DEFAULT NULL,
[194] Fix | Delete
`fld_order_by` varchar(20) NOT NULL DEFAULT 'cfo_id ASC',
[195] Fix | Delete
PRIMARY KEY (`fld_id`)
[196] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[197] Fix | Delete
[198] Fix | Delete
-- --------------------------------------------------------
[199] Fix | Delete
[200] Fix | Delete
--
[201] Fix | Delete
-- Table structure for table `custom_field_option`
[202] Fix | Delete
--
[203] Fix | Delete
[204] Fix | Delete
CREATE TABLE `custom_field_option` (
[205] Fix | Delete
`cfo_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[206] Fix | Delete
`cfo_fld_id` int(10) unsigned NOT NULL DEFAULT '0',
[207] Fix | Delete
`cfo_rank` int(10) unsigned NOT NULL DEFAULT '0',
[208] Fix | Delete
`cfo_value` varchar(128) NOT NULL DEFAULT '',
[209] Fix | Delete
PRIMARY KEY (`cfo_id`),
[210] Fix | Delete
KEY `icf_fld_id` (`cfo_fld_id`)
[211] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[212] Fix | Delete
[213] Fix | Delete
-- --------------------------------------------------------
[214] Fix | Delete
[215] Fix | Delete
--
[216] Fix | Delete
-- Table structure for table `custom_filter`
[217] Fix | Delete
--
[218] Fix | Delete
[219] Fix | Delete
CREATE TABLE `custom_filter` (
[220] Fix | Delete
`cst_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[221] Fix | Delete
`cst_usr_id` int(10) unsigned NOT NULL DEFAULT '0',
[222] Fix | Delete
`cst_prj_id` int(10) unsigned NOT NULL DEFAULT '0',
[223] Fix | Delete
`cst_title` varchar(64) NOT NULL DEFAULT '',
[224] Fix | Delete
`cst_priorities` varchar(255) DEFAULT NULL,
[225] Fix | Delete
`cst_severities` varchar(255) DEFAULT NULL,
[226] Fix | Delete
`cst_keywords` varchar(64) DEFAULT NULL,
[227] Fix | Delete
`cst_users` varchar(255) DEFAULT NULL,
[228] Fix | Delete
`cst_reporters` varchar(255) DEFAULT NULL,
[229] Fix | Delete
`cst_categories` varchar(255) DEFAULT NULL,
[230] Fix | Delete
`cst_statuses` varchar(255) DEFAULT NULL,
[231] Fix | Delete
`cst_releases` varchar(255) DEFAULT NULL,
[232] Fix | Delete
`cst_products` varchar(255) DEFAULT NULL,
[233] Fix | Delete
`cst_show_authorized` char(3) DEFAULT '',
[234] Fix | Delete
`cst_show_notification_list` char(3) DEFAULT '',
[235] Fix | Delete
`cst_created_date` date DEFAULT NULL,
[236] Fix | Delete
`cst_created_date_filter_type` varchar(7) DEFAULT NULL,
[237] Fix | Delete
`cst_created_date_time_period` smallint(6) DEFAULT NULL,
[238] Fix | Delete
`cst_created_date_end` date DEFAULT NULL,
[239] Fix | Delete
`cst_updated_date` date DEFAULT NULL,
[240] Fix | Delete
`cst_updated_date_filter_type` varchar(7) DEFAULT NULL,
[241] Fix | Delete
`cst_updated_date_time_period` smallint(6) DEFAULT NULL,
[242] Fix | Delete
`cst_updated_date_end` date DEFAULT NULL,
[243] Fix | Delete
`cst_last_response_date` date DEFAULT NULL,
[244] Fix | Delete
`cst_last_response_date_filter_type` varchar(7) DEFAULT NULL,
[245] Fix | Delete
`cst_last_response_date_time_period` smallint(6) DEFAULT NULL,
[246] Fix | Delete
`cst_last_response_date_end` date DEFAULT NULL,
[247] Fix | Delete
`cst_first_response_date` date DEFAULT NULL,
[248] Fix | Delete
`cst_first_response_date_filter_type` varchar(7) DEFAULT NULL,
[249] Fix | Delete
`cst_first_response_date_time_period` smallint(6) DEFAULT NULL,
[250] Fix | Delete
`cst_first_response_date_end` date DEFAULT NULL,
[251] Fix | Delete
`cst_closed_date` date DEFAULT NULL,
[252] Fix | Delete
`cst_closed_date_filter_type` varchar(7) DEFAULT NULL,
[253] Fix | Delete
`cst_closed_date_time_period` smallint(6) DEFAULT NULL,
[254] Fix | Delete
`cst_closed_date_end` date DEFAULT NULL,
[255] Fix | Delete
`cst_rows` char(3) DEFAULT NULL,
[256] Fix | Delete
`cst_sort_by` varchar(32) DEFAULT NULL,
[257] Fix | Delete
`cst_sort_order` varchar(4) DEFAULT NULL,
[258] Fix | Delete
`cst_hide_closed` int(1) DEFAULT NULL,
[259] Fix | Delete
`cst_is_global` int(1) DEFAULT '0',
[260] Fix | Delete
`cst_search_type` varchar(15) NOT NULL DEFAULT 'customer',
[261] Fix | Delete
`cst_custom_field` text,
[262] Fix | Delete
PRIMARY KEY (`cst_id`),
[263] Fix | Delete
KEY `cst_usr_id` (`cst_usr_id`,`cst_prj_id`)
[264] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[265] Fix | Delete
[266] Fix | Delete
-- --------------------------------------------------------
[267] Fix | Delete
[268] Fix | Delete
--
[269] Fix | Delete
-- Table structure for table `email_account`
[270] Fix | Delete
--
[271] Fix | Delete
[272] Fix | Delete
CREATE TABLE `email_account` (
[273] Fix | Delete
`ema_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[274] Fix | Delete
`ema_prj_id` int(10) unsigned NOT NULL DEFAULT '0',
[275] Fix | Delete
`ema_type` varchar(32) NOT NULL DEFAULT '',
[276] Fix | Delete
`ema_folder` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
[277] Fix | Delete
`ema_hostname` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
[278] Fix | Delete
`ema_port` varchar(5) NOT NULL DEFAULT '',
[279] Fix | Delete
`ema_username` varchar(64) NOT NULL DEFAULT '',
[280] Fix | Delete
`ema_password` varchar(255) NOT NULL DEFAULT '',
[281] Fix | Delete
`ema_get_only_new` int(1) NOT NULL DEFAULT '0',
[282] Fix | Delete
`ema_leave_copy` int(1) NOT NULL DEFAULT '0',
[283] Fix | Delete
`ema_issue_auto_creation` varchar(8) NOT NULL DEFAULT 'disabled',
[284] Fix | Delete
`ema_issue_auto_creation_options` text,
[285] Fix | Delete
`ema_use_routing` tinyint(1) DEFAULT '0',
[286] Fix | Delete
PRIMARY KEY (`ema_id`),
[287] Fix | Delete
UNIQUE KEY `ema_username` (`ema_username`,`ema_hostname`,`ema_folder`),
[288] Fix | Delete
KEY `ema_prj_id` (`ema_prj_id`)
[289] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[290] Fix | Delete
[291] Fix | Delete
-- --------------------------------------------------------
[292] Fix | Delete
[293] Fix | Delete
--
[294] Fix | Delete
-- Table structure for table `email_draft`
[295] Fix | Delete
--
[296] Fix | Delete
[297] Fix | Delete
CREATE TABLE `email_draft` (
[298] Fix | Delete
`emd_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[299] Fix | Delete
`emd_usr_id` int(11) unsigned NOT NULL,
[300] Fix | Delete
`emd_iss_id` int(11) unsigned NOT NULL,
[301] Fix | Delete
`emd_sup_id` int(11) unsigned DEFAULT NULL,
[302] Fix | Delete
`emd_status` enum('pending','edited','sent') NOT NULL DEFAULT 'pending',
[303] Fix | Delete
`emd_updated_date` datetime NOT NULL,
[304] Fix | Delete
`emd_subject` varchar(255) NOT NULL,
[305] Fix | Delete
`emd_body` longtext NOT NULL,
[306] Fix | Delete
`emd_unknown_user` varchar(255) DEFAULT NULL,
[307] Fix | Delete
PRIMARY KEY (`emd_id`)
[308] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[309] Fix | Delete
[310] Fix | Delete
-- --------------------------------------------------------
[311] Fix | Delete
[312] Fix | Delete
--
[313] Fix | Delete
-- Table structure for table `email_draft_recipient`
[314] Fix | Delete
--
[315] Fix | Delete
[316] Fix | Delete
CREATE TABLE `email_draft_recipient` (
[317] Fix | Delete
`edr_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[318] Fix | Delete
`edr_emd_id` int(11) unsigned NOT NULL,
[319] Fix | Delete
`edr_is_cc` tinyint(1) unsigned NOT NULL DEFAULT '0',
[320] Fix | Delete
`edr_email` varchar(255) NOT NULL,
[321] Fix | Delete
PRIMARY KEY (`edr_id`)
[322] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[323] Fix | Delete
[324] Fix | Delete
-- --------------------------------------------------------
[325] Fix | Delete
[326] Fix | Delete
--
[327] Fix | Delete
-- Table structure for table `email_response`
[328] Fix | Delete
--
[329] Fix | Delete
[330] Fix | Delete
CREATE TABLE `email_response` (
[331] Fix | Delete
`ere_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[332] Fix | Delete
`ere_title` varchar(64) NOT NULL,
[333] Fix | Delete
`ere_response_body` text NOT NULL,
[334] Fix | Delete
PRIMARY KEY (`ere_id`),
[335] Fix | Delete
UNIQUE KEY `ere_title` (`ere_title`)
[336] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[337] Fix | Delete
[338] Fix | Delete
-- --------------------------------------------------------
[339] Fix | Delete
[340] Fix | Delete
--
[341] Fix | Delete
-- Table structure for table `faq`
[342] Fix | Delete
--
[343] Fix | Delete
[344] Fix | Delete
CREATE TABLE `faq` (
[345] Fix | Delete
`faq_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[346] Fix | Delete
`faq_prj_id` int(11) unsigned NOT NULL,
[347] Fix | Delete
`faq_usr_id` int(11) unsigned NOT NULL,
[348] Fix | Delete
`faq_created_date` datetime NOT NULL,
[349] Fix | Delete
`faq_updated_date` datetime DEFAULT NULL,
[350] Fix | Delete
`faq_title` varchar(255) NOT NULL,
[351] Fix | Delete
`faq_message` longtext NOT NULL,
[352] Fix | Delete
`faq_rank` tinyint(3) unsigned NOT NULL,
[353] Fix | Delete
PRIMARY KEY (`faq_id`),
[354] Fix | Delete
UNIQUE KEY `faq_title` (`faq_title`)
[355] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[356] Fix | Delete
[357] Fix | Delete
-- --------------------------------------------------------
[358] Fix | Delete
[359] Fix | Delete
--
[360] Fix | Delete
-- Table structure for table `faq_support_level`
[361] Fix | Delete
--
[362] Fix | Delete
[363] Fix | Delete
CREATE TABLE `faq_support_level` (
[364] Fix | Delete
`fsl_faq_id` int(11) unsigned NOT NULL,
[365] Fix | Delete
`fsl_support_level_id` varchar(50) NOT NULL,
[366] Fix | Delete
PRIMARY KEY (`fsl_faq_id`,`fsl_support_level_id`)
[367] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[368] Fix | Delete
[369] Fix | Delete
-- --------------------------------------------------------
[370] Fix | Delete
[371] Fix | Delete
--
[372] Fix | Delete
-- Table structure for table `group`
[373] Fix | Delete
--
[374] Fix | Delete
[375] Fix | Delete
CREATE TABLE `group` (
[376] Fix | Delete
`grp_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[377] Fix | Delete
`grp_name` varchar(100) NOT NULL,
[378] Fix | Delete
`grp_description` varchar(255) DEFAULT NULL,
[379] Fix | Delete
`grp_manager_usr_id` int(11) unsigned NOT NULL,
[380] Fix | Delete
PRIMARY KEY (`grp_id`),
[381] Fix | Delete
UNIQUE KEY `grp_name` (`grp_name`)
[382] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[383] Fix | Delete
[384] Fix | Delete
-- --------------------------------------------------------
[385] Fix | Delete
[386] Fix | Delete
--
[387] Fix | Delete
-- Table structure for table `history_type`
[388] Fix | Delete
--
[389] Fix | Delete
[390] Fix | Delete
CREATE TABLE `history_type` (
[391] Fix | Delete
`htt_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
[392] Fix | Delete
`htt_name` varchar(25) NOT NULL,
[393] Fix | Delete
`htt_role` tinyint(1) DEFAULT '0',
[394] Fix | Delete
PRIMARY KEY (`htt_id`),
[395] Fix | Delete
UNIQUE KEY `htt_name` (`htt_name`)
[396] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=71 ;
[397] Fix | Delete
[398] Fix | Delete
--
[399] Fix | Delete
-- Dumping data for table `history_type`
[400] Fix | Delete
--
[401] Fix | Delete
[402] Fix | Delete
INSERT INTO `history_type` VALUES
[403] Fix | Delete
(1, 'attachment_removed', 0),
[404] Fix | Delete
(2, 'attachment_added', 0),
[405] Fix | Delete
(3, 'custom_field_updated', 0),
[406] Fix | Delete
(4, 'draft_added', 4),
[407] Fix | Delete
(5, 'draft_updated', 4),
[408] Fix | Delete
(9, 'status_changed', 0),
[409] Fix | Delete
(10, 'remote_status_change', 0),
[410] Fix | Delete
(11, 'remote_assigned', 0),
[411] Fix | Delete
(12, 'remote_replier_added', 0),
[412] Fix | Delete
(13, 'details_updated', 0),
[413] Fix | Delete
(14, 'customer_details_updated', 0),
[414] Fix | Delete
(15, 'issue_opened', 0),
[415] Fix | Delete
(16, 'issue_auto_assigned', 0),
[416] Fix | Delete
(17, 'rr_issue_assigned', 0),
[417] Fix | Delete
(18, 'duplicate_update', 0),
[418] Fix | Delete
(19, 'duplicate_removed', 0),
[419] Fix | Delete
(20, 'duplicate_added', 0),
[420] Fix | Delete
(21, 'issue_opened_anon', 0),
[421] Fix | Delete
(22, 'remote_issue_created', 0),
[422] Fix | Delete
(23, 'issue_closed', 0),
[423] Fix | Delete
(24, 'issue_updated', 0),
[424] Fix | Delete
(25, 'user_associated', 0),
[425] Fix | Delete
(26, 'user_all_unassociated', 0),
[426] Fix | Delete
(27, 'replier_added', 0),
[427] Fix | Delete
(28, 'remote_note_added', 0),
[428] Fix | Delete
(29, 'note_added', 4),
[429] Fix | Delete
(30, 'note_removed', 4),
[430] Fix | Delete
(31, 'note_converted_draft', 4),
[431] Fix | Delete
(32, 'note_converted_email', 4),
[432] Fix | Delete
(33, 'notification_removed', 0),
[433] Fix | Delete
(34, 'notification_added', 0),
[434] Fix | Delete
(35, 'notification_updated', 0),
[435] Fix | Delete
(36, 'phone_entry_added', 4),
[436] Fix | Delete
(37, 'phone_entry_removed', 4),
[437] Fix | Delete
(38, 'scm_checkin_removed', 0),
[438] Fix | Delete
(39, 'email_associated', 0),
[439] Fix | Delete
(40, 'email_disassociated', 0),
[440] Fix | Delete
(41, 'email_sent', 0),
[441] Fix | Delete
(42, 'time_added', 4),
[442] Fix | Delete
(43, 'time_removed', 4),
[443] Fix | Delete
(44, 'remote_time_added', 4),
[444] Fix | Delete
(45, 'email_blocked', 4),
[445] Fix | Delete
(46, 'email_routed', 0),
[446] Fix | Delete
(47, 'note_routed', 4),
[447] Fix | Delete
(48, 'replier_removed', 0),
[448] Fix | Delete
(49, 'replier_other_added', 0),
[449] Fix | Delete
(50, 'issue_associated', 0),
[450] Fix | Delete
(51, 'issue_all_unassociated', 0),
[451] Fix | Delete
(52, 'user_unassociated', 0),
[452] Fix | Delete
(53, 'issue_unassociated', 0),
[453] Fix | Delete
(54, 'group_changed', 4),
[454] Fix | Delete
(55, 'status_auto_changed', 4),
[455] Fix | Delete
(56, 'incident_redeemed', 4),
[456] Fix | Delete
(57, 'incident_unredeemed', 4),
[457] Fix | Delete
(58, 'scm_checkin_associated', 0),
[458] Fix | Delete
(59, 'issue_bulk_updated', 0),
[459] Fix | Delete
(60, 'draft_routed', 4),
[460] Fix | Delete
(61, 'version_details_updated', 4),
[461] Fix | Delete
(62, 'partner_added', 4),
[462] Fix | Delete
(63, 'partner_removed', 4),
[463] Fix | Delete
(64, 'issue_cloned_from', 4),
[464] Fix | Delete
(65, 'issue_cloned_to', 4),
[465] Fix | Delete
(66, 'access_level_changed', 4),
[466] Fix | Delete
(67, 'access_list_added', 4),
[467] Fix | Delete
(68, 'access_list_removed', 4),
[468] Fix | Delete
(69, 'time_update', 4),
[469] Fix | Delete
(70, 'issue_moved', 4);
[470] Fix | Delete
[471] Fix | Delete
-- --------------------------------------------------------
[472] Fix | Delete
[473] Fix | Delete
--
[474] Fix | Delete
-- Table structure for table `irc_notice`
[475] Fix | Delete
--
[476] Fix | Delete
[477] Fix | Delete
CREATE TABLE `irc_notice` (
[478] Fix | Delete
`ino_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[479] Fix | Delete
`ino_prj_id` int(11) NOT NULL,
[480] Fix | Delete
`ino_iss_id` int(11) unsigned NOT NULL,
[481] Fix | Delete
`ino_created_date` datetime NOT NULL,
[482] Fix | Delete
`ino_message` varchar(255) NOT NULL,
[483] Fix | Delete
`ino_status` varchar(8) NOT NULL DEFAULT 'pending',
[484] Fix | Delete
`ino_target_usr_id` int(11) unsigned DEFAULT NULL,
[485] Fix | Delete
`ino_category` varchar(25) DEFAULT NULL,
[486] Fix | Delete
PRIMARY KEY (`ino_id`),
[487] Fix | Delete
KEY `ino_status` (`ino_status`,`ino_prj_id`)
[488] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[489] Fix | Delete
[490] Fix | Delete
-- --------------------------------------------------------
[491] Fix | Delete
[492] Fix | Delete
--
[493] Fix | Delete
-- Table structure for table `issue`
[494] Fix | Delete
--
[495] Fix | Delete
[496] Fix | Delete
CREATE TABLE `issue` (
[497] Fix | Delete
`iss_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[498] Fix | Delete
`iss_customer_id` varchar(128) DEFAULT NULL,
[499] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function