Edit File by line
• /home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../dotproj
• File: dotproj.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: `dotproj220`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `[[dbprefix]]billingcode`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `[[dbprefix]]billingcode` (
[20] Fix | Delete
`billingcode_id` bigint(20) NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`billingcode_name` varchar(25) NOT NULL DEFAULT '',
[22] Fix | Delete
`billingcode_value` float NOT NULL DEFAULT '0',
[23] Fix | Delete
`billingcode_desc` varchar(255) NOT NULL DEFAULT '',
[24] Fix | Delete
`billingcode_status` int(1) NOT NULL DEFAULT '0',
[25] Fix | Delete
`company_id` bigint(20) NOT NULL DEFAULT '0',
[26] Fix | Delete
PRIMARY KEY (`billingcode_id`)
[27] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[28] Fix | Delete
[29] Fix | Delete
-- --------------------------------------------------------
[30] Fix | Delete
[31] Fix | Delete
--
[32] Fix | Delete
-- Table structure for table `[[dbprefix]]common_notes`
[33] Fix | Delete
--
[34] Fix | Delete
[35] Fix | Delete
CREATE TABLE `[[dbprefix]]common_notes` (
[36] Fix | Delete
`note_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[37] Fix | Delete
`note_author` int(10) unsigned NOT NULL DEFAULT '0',
[38] Fix | Delete
`note_module` int(10) unsigned NOT NULL DEFAULT '0',
[39] Fix | Delete
`note_record_id` int(10) unsigned NOT NULL DEFAULT '0',
[40] Fix | Delete
`note_category` int(3) unsigned NOT NULL DEFAULT '0',
[41] Fix | Delete
`note_title` varchar(100) NOT NULL DEFAULT '',
[42] Fix | Delete
`note_body` text NOT NULL,
[43] Fix | Delete
`note_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[44] Fix | Delete
`note_hours` float NOT NULL DEFAULT '0',
[45] Fix | Delete
`note_code` varchar(8) NOT NULL DEFAULT '',
[46] Fix | Delete
`note_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[47] Fix | Delete
`note_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
[48] Fix | Delete
`note_modified_by` int(10) unsigned NOT NULL DEFAULT '0',
[49] Fix | Delete
PRIMARY KEY (`note_id`)
[50] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[51] Fix | Delete
[52] Fix | Delete
-- --------------------------------------------------------
[53] Fix | Delete
[54] Fix | Delete
--
[55] Fix | Delete
-- Table structure for table `[[dbprefix]]companies`
[56] Fix | Delete
--
[57] Fix | Delete
[58] Fix | Delete
CREATE TABLE `[[dbprefix]]companies` (
[59] Fix | Delete
`company_id` int(10) NOT NULL AUTO_INCREMENT,
[60] Fix | Delete
`company_module` int(10) NOT NULL DEFAULT '0',
[61] Fix | Delete
`company_name` varchar(100) DEFAULT '',
[62] Fix | Delete
`company_phone1` varchar(30) DEFAULT '',
[63] Fix | Delete
`company_phone2` varchar(30) DEFAULT '',
[64] Fix | Delete
`company_fax` varchar(30) DEFAULT '',
[65] Fix | Delete
`company_address1` varchar(50) DEFAULT '',
[66] Fix | Delete
`company_address2` varchar(50) DEFAULT '',
[67] Fix | Delete
`company_city` varchar(30) DEFAULT '',
[68] Fix | Delete
`company_state` varchar(30) DEFAULT '',
[69] Fix | Delete
`company_zip` varchar(11) DEFAULT '',
[70] Fix | Delete
`company_primary_url` varchar(255) DEFAULT '',
[71] Fix | Delete
`company_owner` int(11) NOT NULL DEFAULT '0',
[72] Fix | Delete
`company_description` text,
[73] Fix | Delete
`company_type` int(3) NOT NULL DEFAULT '0',
[74] Fix | Delete
`company_email` varchar(255) DEFAULT NULL,
[75] Fix | Delete
`company_custom` longtext,
[76] Fix | Delete
PRIMARY KEY (`company_id`),
[77] Fix | Delete
KEY `idx_cpy1` (`company_owner`)
[78] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[79] Fix | Delete
[80] Fix | Delete
-- --------------------------------------------------------
[81] Fix | Delete
[82] Fix | Delete
--
[83] Fix | Delete
-- Table structure for table `[[dbprefix]]config`
[84] Fix | Delete
--
[85] Fix | Delete
[86] Fix | Delete
CREATE TABLE `[[dbprefix]]config` (
[87] Fix | Delete
`config_id` int(11) NOT NULL AUTO_INCREMENT,
[88] Fix | Delete
`config_name` varchar(127) NOT NULL DEFAULT '',
[89] Fix | Delete
`config_value` varchar(255) NOT NULL DEFAULT '',
[90] Fix | Delete
`config_group` varchar(255) NOT NULL DEFAULT '',
[91] Fix | Delete
`config_type` varchar(255) NOT NULL DEFAULT '',
[92] Fix | Delete
PRIMARY KEY (`config_id`),
[93] Fix | Delete
UNIQUE KEY `config_name` (`config_name`)
[94] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=75 ;
[95] Fix | Delete
[96] Fix | Delete
--
[97] Fix | Delete
-- Dumping data for table `[[dbprefix]]config`
[98] Fix | Delete
--
[99] Fix | Delete
[100] Fix | Delete
INSERT INTO `[[dbprefix]]config` VALUES
[101] Fix | Delete
(1, 'host_locale', 'en', 'ui', 'text'),
[102] Fix | Delete
(2, 'check_overallocation', 'false', 'tasks', 'checkbox'),
[103] Fix | Delete
(3, 'currency_symbol', '$', 'ui', 'text'),
[104] Fix | Delete
(4, 'host_style', 'default', 'ui', 'text'),
[105] Fix | Delete
(5, 'company_name', '[[comp_name]]', 'ui', 'text'),
[106] Fix | Delete
(6, 'page_title', '[[site_name]]', 'ui', 'text'),
[107] Fix | Delete
(7, 'site_domain', 'example.com', 'ui', 'text'),
[108] Fix | Delete
(8, 'email_prefix', '[dotProject]', 'ui', 'text'),
[109] Fix | Delete
(9, 'admin_username', 'admin', 'ui', 'text'),
[110] Fix | Delete
(10, 'username_min_len', '4', 'auth', 'text'),
[111] Fix | Delete
(11, 'password_min_len', '4', 'auth', 'text'),
[112] Fix | Delete
(12, 'enable_gantt_charts', 'true', 'tasks', 'checkbox'),
[113] Fix | Delete
(13, 'log_changes', 'false', '', 'checkbox'),
[114] Fix | Delete
(14, 'check_task_dates', 'true', 'tasks', 'checkbox'),
[115] Fix | Delete
(15, 'check_task_empty_dynamic', 'false', 'tasks', 'checkbox'),
[116] Fix | Delete
(16, 'locale_warn', 'false', 'ui', 'checkbox'),
[117] Fix | Delete
(17, 'locale_alert', '^', 'ui', 'text'),
[118] Fix | Delete
(18, 'daily_working_hours', '8.0', 'tasks', 'text'),
[119] Fix | Delete
(19, 'display_debug', 'false', 'ui', 'checkbox'),
[120] Fix | Delete
(20, 'link_tickets_kludge', 'false', 'tasks', 'checkbox'),
[121] Fix | Delete
(21, 'show_all_task_assignees', 'false', 'tasks', 'checkbox'),
[122] Fix | Delete
(22, 'direct_edit_assignment', 'false', 'tasks', 'checkbox'),
[123] Fix | Delete
(23, 'restrict_color_selection', 'false', 'ui', 'checkbox'),
[124] Fix | Delete
(24, 'cal_day_view_show_minical', 'true', 'calendar', 'checkbox'),
[125] Fix | Delete
(25, 'cal_day_start', '8', 'calendar', 'text'),
[126] Fix | Delete
(26, 'cal_day_end', '17', 'calendar', 'text'),
[127] Fix | Delete
(27, 'cal_day_increment', '15', 'calendar', 'text'),
[128] Fix | Delete
(28, 'cal_working_days', '1,2,3,4,5', 'calendar', 'text'),
[129] Fix | Delete
(29, 'restrict_task_time_editing', 'false', 'tasks', 'checkbox'),
[130] Fix | Delete
(30, 'default_view_m', 'calendar', 'ui', 'text'),
[131] Fix | Delete
(31, 'default_view_a', 'day_view', 'ui', 'text'),
[132] Fix | Delete
(32, 'default_view_tab', '1', 'ui', 'text'),
[133] Fix | Delete
(33, 'index_max_file_size', '-1', 'file', 'text'),
[134] Fix | Delete
(34, 'session_handling', 'app', 'session', 'select'),
[135] Fix | Delete
(35, 'session_idle_time', '2d', 'session', 'text'),
[136] Fix | Delete
(36, 'session_max_lifetime', '1m', 'session', 'text'),
[137] Fix | Delete
(37, 'debug', '1', '', 'text'),
[138] Fix | Delete
(38, 'parser_default', '/usr/bin/strings', 'file', 'text'),
[139] Fix | Delete
(39, 'parser_application/msword', '/usr/bin/strings', 'file', 'text'),
[140] Fix | Delete
(40, 'parser_text/html', '/usr/bin/strings', 'file', 'text'),
[141] Fix | Delete
(41, 'parser_application/pdf', '/usr/bin/pdftotext', 'file', 'text'),
[142] Fix | Delete
(42, 'files_ci_preserve_attr', 'true', 'file', 'checkbox'),
[143] Fix | Delete
(43, 'files_show_versions_edit', 'false', 'file', 'checkbox'),
[144] Fix | Delete
(44, 'auth_method', 'sql', 'auth', 'select'),
[145] Fix | Delete
(45, 'ldap_host', 'localhost', 'ldap', 'text'),
[146] Fix | Delete
(46, 'ldap_port', '389', 'ldap', 'text'),
[147] Fix | Delete
(47, 'ldap_version', '3', 'ldap', 'text'),
[148] Fix | Delete
(48, 'ldap_base_dn', 'dc=saki,dc=com,dc=au', 'ldap', 'text'),
[149] Fix | Delete
(49, 'ldap_user_filter', '(uid=%USERNAME%)', 'ldap', 'text'),
[150] Fix | Delete
(50, 'postnuke_allow_login', 'true', 'auth', 'checkbox'),
[151] Fix | Delete
(51, 'reset_memory_limit', '32M', 'tasks', 'text'),
[152] Fix | Delete
(52, 'mail_transport', 'php', 'mail', 'select'),
[153] Fix | Delete
(53, 'mail_host', 'localhost', 'mail', 'text'),
[154] Fix | Delete
(54, 'mail_port', '25', 'mail', 'text'),
[155] Fix | Delete
(55, 'mail_auth', 'false', 'mail', 'checkbox'),
[156] Fix | Delete
(56, 'mail_user', '', 'mail', 'text'),
[157] Fix | Delete
(57, 'mail_pass', '', 'mail', 'password'),
[158] Fix | Delete
(58, 'mail_defer', 'false', 'mail', 'checkbox'),
[159] Fix | Delete
(59, 'mail_timeout', '30', 'mail', 'text'),
[160] Fix | Delete
(60, 'session_gc_scan_queue', 'false', 'session', 'checkbox'),
[161] Fix | Delete
(61, 'task_reminder_control', 'false', 'task_reminder', 'checkbox'),
[162] Fix | Delete
(62, 'task_reminder_days_before', '1', 'task_reminder', 'text'),
[163] Fix | Delete
(63, 'task_reminder_repeat', '100', 'task_reminder', 'text'),
[164] Fix | Delete
(64, 'gacl_cache', 'false', 'gacl', 'checkbox'),
[165] Fix | Delete
(65, 'gacl_expire', 'true', 'gacl', 'checkbox'),
[166] Fix | Delete
(66, 'gacl_cache_dir', '/tmp', 'gacl', 'text'),
[167] Fix | Delete
(67, 'gacl_timeout', '600', 'gacl', 'text'),
[168] Fix | Delete
(68, 'mail_smtp_tls', 'false', 'mail', 'checkbox'),
[169] Fix | Delete
(69, 'ldap_search_user', 'Manager', 'ldap', 'text'),
[170] Fix | Delete
(70, 'ldap_search_pass', 'secret', 'ldap', 'password'),
[171] Fix | Delete
(71, 'ldap_allow_login', 'true', 'ldap', 'checkbox'),
[172] Fix | Delete
(72, 'user_contact_inactivate', 'true', 'auth', 'checkbox'),
[173] Fix | Delete
(73, 'user_contact_activate', 'false', 'auth', 'checkbox'),
[174] Fix | Delete
(74, 'task_reminder_batch', 'false', 'task_reminder', 'checkbox');
[175] Fix | Delete
[176] Fix | Delete
-- --------------------------------------------------------
[177] Fix | Delete
[178] Fix | Delete
--
[179] Fix | Delete
-- Table structure for table `[[dbprefix]]config_list`
[180] Fix | Delete
--
[181] Fix | Delete
[182] Fix | Delete
CREATE TABLE `[[dbprefix]]config_list` (
[183] Fix | Delete
`config_list_id` int(11) NOT NULL AUTO_INCREMENT,
[184] Fix | Delete
`config_id` int(11) NOT NULL DEFAULT '0',
[185] Fix | Delete
`config_list_name` varchar(30) NOT NULL DEFAULT '',
[186] Fix | Delete
PRIMARY KEY (`config_list_id`),
[187] Fix | Delete
KEY `config_id` (`config_id`)
[188] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
[189] Fix | Delete
[190] Fix | Delete
--
[191] Fix | Delete
-- Dumping data for table `[[dbprefix]]config_list`
[192] Fix | Delete
--
[193] Fix | Delete
[194] Fix | Delete
INSERT INTO `[[dbprefix]]config_list` VALUES
[195] Fix | Delete
(1, 44, 'sql'),
[196] Fix | Delete
(2, 44, 'ldap'),
[197] Fix | Delete
(3, 44, 'pn'),
[198] Fix | Delete
(4, 34, 'app'),
[199] Fix | Delete
(5, 34, 'php'),
[200] Fix | Delete
(6, 52, 'php'),
[201] Fix | Delete
(7, 52, 'smtp');
[202] Fix | Delete
[203] Fix | Delete
-- --------------------------------------------------------
[204] Fix | Delete
[205] Fix | Delete
--
[206] Fix | Delete
-- Table structure for table `[[dbprefix]]contacts`
[207] Fix | Delete
--
[208] Fix | Delete
[209] Fix | Delete
CREATE TABLE `[[dbprefix]]contacts` (
[210] Fix | Delete
`contact_id` int(11) NOT NULL AUTO_INCREMENT,
[211] Fix | Delete
`contact_first_name` varchar(30) DEFAULT NULL,
[212] Fix | Delete
`contact_last_name` varchar(30) DEFAULT NULL,
[213] Fix | Delete
`contact_order_by` varchar(30) NOT NULL DEFAULT '',
[214] Fix | Delete
`contact_title` varchar(50) DEFAULT NULL,
[215] Fix | Delete
`contact_birthday` date DEFAULT NULL,
[216] Fix | Delete
`contact_job` varchar(255) DEFAULT NULL,
[217] Fix | Delete
`contact_company` varchar(100) NOT NULL DEFAULT '',
[218] Fix | Delete
`contact_department` tinytext,
[219] Fix | Delete
`contact_type` varchar(20) DEFAULT NULL,
[220] Fix | Delete
`contact_email` varchar(255) DEFAULT NULL,
[221] Fix | Delete
`contact_email2` varchar(255) DEFAULT NULL,
[222] Fix | Delete
`contact_url` varchar(255) DEFAULT NULL,
[223] Fix | Delete
`contact_phone` varchar(30) DEFAULT NULL,
[224] Fix | Delete
`contact_phone2` varchar(30) DEFAULT NULL,
[225] Fix | Delete
`contact_fax` varchar(30) DEFAULT NULL,
[226] Fix | Delete
`contact_mobile` varchar(30) DEFAULT NULL,
[227] Fix | Delete
`contact_address1` varchar(60) DEFAULT NULL,
[228] Fix | Delete
`contact_address2` varchar(60) DEFAULT NULL,
[229] Fix | Delete
`contact_city` varchar(30) DEFAULT NULL,
[230] Fix | Delete
`contact_state` varchar(30) DEFAULT NULL,
[231] Fix | Delete
`contact_zip` varchar(11) DEFAULT NULL,
[232] Fix | Delete
`contact_country` varchar(30) DEFAULT NULL,
[233] Fix | Delete
`contact_jabber` varchar(255) DEFAULT NULL,
[234] Fix | Delete
`contact_icq` varchar(20) DEFAULT NULL,
[235] Fix | Delete
`contact_msn` varchar(255) DEFAULT NULL,
[236] Fix | Delete
`contact_yahoo` varchar(255) DEFAULT NULL,
[237] Fix | Delete
`contact_aol` varchar(30) DEFAULT NULL,
[238] Fix | Delete
`contact_notes` text,
[239] Fix | Delete
`contact_project` int(11) NOT NULL DEFAULT '0',
[240] Fix | Delete
`contact_icon` varchar(20) DEFAULT 'obj/contact',
[241] Fix | Delete
`contact_owner` int(10) unsigned DEFAULT '0',
[242] Fix | Delete
`contact_private` tinyint(3) unsigned DEFAULT '0',
[243] Fix | Delete
PRIMARY KEY (`contact_id`),
[244] Fix | Delete
KEY `idx_oby` (`contact_order_by`),
[245] Fix | Delete
KEY `idx_co` (`contact_company`),
[246] Fix | Delete
KEY `idx_prp` (`contact_project`)
[247] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[248] Fix | Delete
[249] Fix | Delete
--
[250] Fix | Delete
-- Dumping data for table `[[dbprefix]]contacts`
[251] Fix | Delete
--
[252] Fix | Delete
[253] Fix | Delete
INSERT INTO `[[dbprefix]]contacts` VALUES
[254] Fix | Delete
(1, 'Admin', 'Person', '', NULL, NULL, NULL, '', NULL, NULL, '[[admin_email]]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'obj/contact', 0, 0);
[255] Fix | Delete
[256] Fix | Delete
-- --------------------------------------------------------
[257] Fix | Delete
[258] Fix | Delete
--
[259] Fix | Delete
-- Table structure for table `[[dbprefix]]custom_fields_lists`
[260] Fix | Delete
--
[261] Fix | Delete
[262] Fix | Delete
CREATE TABLE `[[dbprefix]]custom_fields_lists` (
[263] Fix | Delete
`field_id` int(11) DEFAULT NULL,
[264] Fix | Delete
`list_option_id` int(11) DEFAULT NULL,
[265] Fix | Delete
`list_value` varchar(250) DEFAULT NULL
[266] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[267] Fix | Delete
[268] Fix | Delete
-- --------------------------------------------------------
[269] Fix | Delete
[270] Fix | Delete
--
[271] Fix | Delete
-- Table structure for table `[[dbprefix]]custom_fields_struct`
[272] Fix | Delete
--
[273] Fix | Delete
[274] Fix | Delete
CREATE TABLE `[[dbprefix]]custom_fields_struct` (
[275] Fix | Delete
`field_id` int(11) NOT NULL,
[276] Fix | Delete
`field_module` varchar(30) DEFAULT NULL,
[277] Fix | Delete
`field_page` varchar(30) DEFAULT NULL,
[278] Fix | Delete
`field_htmltype` varchar(20) DEFAULT NULL,
[279] Fix | Delete
`field_datatype` varchar(20) DEFAULT NULL,
[280] Fix | Delete
`field_order` int(11) DEFAULT NULL,
[281] Fix | Delete
`field_name` varchar(100) DEFAULT NULL,
[282] Fix | Delete
`field_extratags` varchar(250) DEFAULT NULL,
[283] Fix | Delete
`field_description` varchar(250) DEFAULT NULL,
[284] Fix | Delete
PRIMARY KEY (`field_id`)
[285] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[286] Fix | Delete
[287] Fix | Delete
-- --------------------------------------------------------
[288] Fix | Delete
[289] Fix | Delete
--
[290] Fix | Delete
-- Table structure for table `[[dbprefix]]custom_fields_values`
[291] Fix | Delete
--
[292] Fix | Delete
[293] Fix | Delete
CREATE TABLE `[[dbprefix]]custom_fields_values` (
[294] Fix | Delete
`value_id` int(11) DEFAULT NULL,
[295] Fix | Delete
`value_module` varchar(30) DEFAULT NULL,
[296] Fix | Delete
`value_object_id` int(11) DEFAULT NULL,
[297] Fix | Delete
`value_field_id` int(11) DEFAULT NULL,
[298] Fix | Delete
`value_charvalue` varchar(250) DEFAULT NULL,
[299] Fix | Delete
`value_intvalue` int(11) DEFAULT NULL,
[300] Fix | Delete
KEY `idx_cfv_id` (`value_id`)
[301] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[302] Fix | Delete
[303] Fix | Delete
-- --------------------------------------------------------
[304] Fix | Delete
[305] Fix | Delete
--
[306] Fix | Delete
-- Table structure for table `[[dbprefix]]departments`
[307] Fix | Delete
--
[308] Fix | Delete
[309] Fix | Delete
CREATE TABLE `[[dbprefix]]departments` (
[310] Fix | Delete
`dept_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[311] Fix | Delete
`dept_parent` int(10) unsigned NOT NULL DEFAULT '0',
[312] Fix | Delete
`dept_company` int(10) unsigned NOT NULL DEFAULT '0',
[313] Fix | Delete
`dept_name` tinytext NOT NULL,
[314] Fix | Delete
`dept_phone` varchar(30) DEFAULT NULL,
[315] Fix | Delete
`dept_fax` varchar(30) DEFAULT NULL,
[316] Fix | Delete
`dept_address1` varchar(30) DEFAULT NULL,
[317] Fix | Delete
`dept_address2` varchar(30) DEFAULT NULL,
[318] Fix | Delete
`dept_city` varchar(30) DEFAULT NULL,
[319] Fix | Delete
`dept_state` varchar(30) DEFAULT NULL,
[320] Fix | Delete
`dept_zip` varchar(11) DEFAULT NULL,
[321] Fix | Delete
`dept_url` varchar(25) DEFAULT NULL,
[322] Fix | Delete
`dept_desc` text,
[323] Fix | Delete
`dept_owner` int(10) unsigned NOT NULL DEFAULT '0',
[324] Fix | Delete
PRIMARY KEY (`dept_id`)
[325] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Department heirarchy under a company' AUTO_INCREMENT=1 ;
[326] Fix | Delete
[327] Fix | Delete
-- --------------------------------------------------------
[328] Fix | Delete
[329] Fix | Delete
--
[330] Fix | Delete
-- Table structure for table `[[dbprefix]]dotpermissions`
[331] Fix | Delete
--
[332] Fix | Delete
[333] Fix | Delete
CREATE TABLE `[[dbprefix]]dotpermissions` (
[334] Fix | Delete
`acl_id` int(11) NOT NULL DEFAULT '0',
[335] Fix | Delete
`user_id` varchar(80) NOT NULL DEFAULT '',
[336] Fix | Delete
`section` varchar(80) NOT NULL DEFAULT '',
[337] Fix | Delete
`axo` varchar(80) NOT NULL DEFAULT '',
[338] Fix | Delete
`permission` varchar(80) NOT NULL DEFAULT '',
[339] Fix | Delete
`allow` int(11) NOT NULL DEFAULT '0',
[340] Fix | Delete
`priority` int(11) NOT NULL DEFAULT '0',
[341] Fix | Delete
`enabled` int(11) NOT NULL DEFAULT '0',
[342] Fix | Delete
KEY `user_id` (`user_id`,`section`,`permission`,`axo`)
[343] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[344] Fix | Delete
[345] Fix | Delete
--
[346] Fix | Delete
-- Dumping data for table `[[dbprefix]]dotpermissions`
[347] Fix | Delete
--
[348] Fix | Delete
[349] Fix | Delete
INSERT INTO `[[dbprefix]]dotpermissions` VALUES
[350] Fix | Delete
(12, '1', 'sys', 'acl', 'access', 1, 3, 1),
[351] Fix | Delete
(11, '1', 'app', 'admin', 'access', 1, 4, 1),
[352] Fix | Delete
(11, '1', 'app', 'calendar', 'access', 1, 4, 1),
[353] Fix | Delete
(11, '1', 'app', 'events', 'access', 1, 4, 1),
[354] Fix | Delete
(11, '1', 'app', 'companies', 'access', 1, 4, 1),
[355] Fix | Delete
(11, '1', 'app', 'contacts', 'access', 1, 4, 1),
[356] Fix | Delete
(11, '1', 'app', 'departments', 'access', 1, 4, 1),
[357] Fix | Delete
(11, '1', 'app', 'files', 'access', 1, 4, 1),
[358] Fix | Delete
(11, '1', 'app', 'file_folders', 'access', 1, 4, 1),
[359] Fix | Delete
(11, '1', 'app', 'forums', 'access', 1, 4, 1),
[360] Fix | Delete
(11, '1', 'app', 'help', 'access', 1, 4, 1),
[361] Fix | Delete
(11, '1', 'app', 'projects', 'access', 1, 4, 1),
[362] Fix | Delete
(11, '1', 'app', 'system', 'access', 1, 4, 1),
[363] Fix | Delete
(11, '1', 'app', 'tasks', 'access', 1, 4, 1),
[364] Fix | Delete
(11, '1', 'app', 'task_log', 'access', 1, 4, 1),
[365] Fix | Delete
(11, '1', 'app', 'ticketsmith', 'access', 1, 4, 1),
[366] Fix | Delete
(11, '1', 'app', 'public', 'access', 1, 4, 1),
[367] Fix | Delete
(11, '1', 'app', 'roles', 'access', 1, 4, 1),
[368] Fix | Delete
(11, '1', 'app', 'users', 'access', 1, 4, 1),
[369] Fix | Delete
(11, '1', 'app', 'admin', 'add', 1, 4, 1),
[370] Fix | Delete
(11, '1', 'app', 'calendar', 'add', 1, 4, 1),
[371] Fix | Delete
(11, '1', 'app', 'events', 'add', 1, 4, 1),
[372] Fix | Delete
(11, '1', 'app', 'companies', 'add', 1, 4, 1),
[373] Fix | Delete
(11, '1', 'app', 'contacts', 'add', 1, 4, 1),
[374] Fix | Delete
(11, '1', 'app', 'departments', 'add', 1, 4, 1),
[375] Fix | Delete
(11, '1', 'app', 'files', 'add', 1, 4, 1),
[376] Fix | Delete
(11, '1', 'app', 'file_folders', 'add', 1, 4, 1),
[377] Fix | Delete
(11, '1', 'app', 'forums', 'add', 1, 4, 1),
[378] Fix | Delete
(11, '1', 'app', 'help', 'add', 1, 4, 1),
[379] Fix | Delete
(11, '1', 'app', 'projects', 'add', 1, 4, 1),
[380] Fix | Delete
(11, '1', 'app', 'system', 'add', 1, 4, 1),
[381] Fix | Delete
(11, '1', 'app', 'tasks', 'add', 1, 4, 1),
[382] Fix | Delete
(11, '1', 'app', 'task_log', 'add', 1, 4, 1),
[383] Fix | Delete
(11, '1', 'app', 'ticketsmith', 'add', 1, 4, 1),
[384] Fix | Delete
(11, '1', 'app', 'public', 'add', 1, 4, 1),
[385] Fix | Delete
(11, '1', 'app', 'roles', 'add', 1, 4, 1),
[386] Fix | Delete
(11, '1', 'app', 'users', 'add', 1, 4, 1),
[387] Fix | Delete
(11, '1', 'app', 'admin', 'delete', 1, 4, 1),
[388] Fix | Delete
(11, '1', 'app', 'calendar', 'delete', 1, 4, 1),
[389] Fix | Delete
(11, '1', 'app', 'events', 'delete', 1, 4, 1),
[390] Fix | Delete
(11, '1', 'app', 'companies', 'delete', 1, 4, 1),
[391] Fix | Delete
(11, '1', 'app', 'contacts', 'delete', 1, 4, 1),
[392] Fix | Delete
(11, '1', 'app', 'departments', 'delete', 1, 4, 1),
[393] Fix | Delete
(11, '1', 'app', 'files', 'delete', 1, 4, 1),
[394] Fix | Delete
(11, '1', 'app', 'file_folders', 'delete', 1, 4, 1),
[395] Fix | Delete
(11, '1', 'app', 'forums', 'delete', 1, 4, 1),
[396] Fix | Delete
(11, '1', 'app', 'help', 'delete', 1, 4, 1),
[397] Fix | Delete
(11, '1', 'app', 'projects', 'delete', 1, 4, 1),
[398] Fix | Delete
(11, '1', 'app', 'system', 'delete', 1, 4, 1),
[399] Fix | Delete
(11, '1', 'app', 'tasks', 'delete', 1, 4, 1),
[400] Fix | Delete
(11, '1', 'app', 'task_log', 'delete', 1, 4, 1),
[401] Fix | Delete
(11, '1', 'app', 'ticketsmith', 'delete', 1, 4, 1),
[402] Fix | Delete
(11, '1', 'app', 'public', 'delete', 1, 4, 1),
[403] Fix | Delete
(11, '1', 'app', 'roles', 'delete', 1, 4, 1),
[404] Fix | Delete
(11, '1', 'app', 'users', 'delete', 1, 4, 1),
[405] Fix | Delete
(11, '1', 'app', 'admin', 'edit', 1, 4, 1),
[406] Fix | Delete
(11, '1', 'app', 'calendar', 'edit', 1, 4, 1),
[407] Fix | Delete
(11, '1', 'app', 'events', 'edit', 1, 4, 1),
[408] Fix | Delete
(11, '1', 'app', 'companies', 'edit', 1, 4, 1),
[409] Fix | Delete
(11, '1', 'app', 'contacts', 'edit', 1, 4, 1),
[410] Fix | Delete
(11, '1', 'app', 'departments', 'edit', 1, 4, 1),
[411] Fix | Delete
(11, '1', 'app', 'files', 'edit', 1, 4, 1),
[412] Fix | Delete
(11, '1', 'app', 'file_folders', 'edit', 1, 4, 1),
[413] Fix | Delete
(11, '1', 'app', 'forums', 'edit', 1, 4, 1),
[414] Fix | Delete
(11, '1', 'app', 'help', 'edit', 1, 4, 1),
[415] Fix | Delete
(11, '1', 'app', 'projects', 'edit', 1, 4, 1),
[416] Fix | Delete
(11, '1', 'app', 'system', 'edit', 1, 4, 1),
[417] Fix | Delete
(11, '1', 'app', 'tasks', 'edit', 1, 4, 1),
[418] Fix | Delete
(11, '1', 'app', 'task_log', 'edit', 1, 4, 1),
[419] Fix | Delete
(11, '1', 'app', 'ticketsmith', 'edit', 1, 4, 1),
[420] Fix | Delete
(11, '1', 'app', 'public', 'edit', 1, 4, 1),
[421] Fix | Delete
(11, '1', 'app', 'roles', 'edit', 1, 4, 1),
[422] Fix | Delete
(11, '1', 'app', 'users', 'edit', 1, 4, 1),
[423] Fix | Delete
(11, '1', 'app', 'admin', 'view', 1, 4, 1),
[424] Fix | Delete
(11, '1', 'app', 'calendar', 'view', 1, 4, 1),
[425] Fix | Delete
(11, '1', 'app', 'events', 'view', 1, 4, 1),
[426] Fix | Delete
(11, '1', 'app', 'companies', 'view', 1, 4, 1),
[427] Fix | Delete
(11, '1', 'app', 'contacts', 'view', 1, 4, 1),
[428] Fix | Delete
(11, '1', 'app', 'departments', 'view', 1, 4, 1),
[429] Fix | Delete
(11, '1', 'app', 'files', 'view', 1, 4, 1),
[430] Fix | Delete
(11, '1', 'app', 'file_folders', 'view', 1, 4, 1),
[431] Fix | Delete
(11, '1', 'app', 'forums', 'view', 1, 4, 1),
[432] Fix | Delete
(11, '1', 'app', 'help', 'view', 1, 4, 1),
[433] Fix | Delete
(11, '1', 'app', 'projects', 'view', 1, 4, 1),
[434] Fix | Delete
(11, '1', 'app', 'system', 'view', 1, 4, 1),
[435] Fix | Delete
(11, '1', 'app', 'tasks', 'view', 1, 4, 1),
[436] Fix | Delete
(11, '1', 'app', 'task_log', 'view', 1, 4, 1),
[437] Fix | Delete
(11, '1', 'app', 'ticketsmith', 'view', 1, 4, 1),
[438] Fix | Delete
(11, '1', 'app', 'public', 'view', 1, 4, 1),
[439] Fix | Delete
(11, '1', 'app', 'roles', 'view', 1, 4, 1),
[440] Fix | Delete
(11, '1', 'app', 'users', 'view', 1, 4, 1);
[441] Fix | Delete
[442] Fix | Delete
-- --------------------------------------------------------
[443] Fix | Delete
[444] Fix | Delete
--
[445] Fix | Delete
-- Table structure for table `[[dbprefix]]dpversion`
[446] Fix | Delete
--
[447] Fix | Delete
[448] Fix | Delete
CREATE TABLE `[[dbprefix]]dpversion` (
[449] Fix | Delete
`code_version` varchar(10) NOT NULL DEFAULT '',
[450] Fix | Delete
`db_version` int(11) NOT NULL DEFAULT '0',
[451] Fix | Delete
`last_db_update` date NOT NULL DEFAULT '0000-00-00',
[452] Fix | Delete
`last_code_update` date NOT NULL DEFAULT '0000-00-00'
[453] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[454] Fix | Delete
[455] Fix | Delete
--
[456] Fix | Delete
-- Dumping data for table `[[dbprefix]]dpversion`
[457] Fix | Delete
--
[458] Fix | Delete
[459] Fix | Delete
INSERT INTO `[[dbprefix]]dpversion` VALUES
[460] Fix | Delete
('2.2.0', 2, '2013-01-05', '2013-07-27');
[461] Fix | Delete
[462] Fix | Delete
-- --------------------------------------------------------
[463] Fix | Delete
[464] Fix | Delete
--
[465] Fix | Delete
-- Table structure for table `[[dbprefix]]events`
[466] Fix | Delete
--
[467] Fix | Delete
[468] Fix | Delete
CREATE TABLE `[[dbprefix]]events` (
[469] Fix | Delete
`event_id` int(11) NOT NULL AUTO_INCREMENT,
[470] Fix | Delete
`event_title` varchar(255) NOT NULL DEFAULT '',
[471] Fix | Delete
`event_start_date` datetime DEFAULT NULL,
[472] Fix | Delete
`event_end_date` datetime DEFAULT NULL,
[473] Fix | Delete
`event_parent` int(11) unsigned NOT NULL DEFAULT '0',
[474] Fix | Delete
`event_description` text,
[475] Fix | Delete
`event_times_recuring` int(11) unsigned NOT NULL DEFAULT '0',
[476] Fix | Delete
`event_recurs` int(11) unsigned NOT NULL DEFAULT '0',
[477] Fix | Delete
`event_remind` int(10) unsigned NOT NULL DEFAULT '0',
[478] Fix | Delete
`event_icon` varchar(20) DEFAULT 'obj/event',
[479] Fix | Delete
`event_owner` int(11) DEFAULT '0',
[480] Fix | Delete
`event_project` int(11) DEFAULT '0',
[481] Fix | Delete
`event_private` tinyint(3) DEFAULT '0',
[482] Fix | Delete
`event_type` tinyint(3) DEFAULT '0',
[483] Fix | Delete
`event_cwd` tinyint(3) DEFAULT '0',
[484] Fix | Delete
`event_notify` tinyint(3) NOT NULL DEFAULT '0',
[485] Fix | Delete
PRIMARY KEY (`event_id`),
[486] Fix | Delete
KEY `id_esd` (`event_start_date`),
[487] Fix | Delete
KEY `id_eed` (`event_end_date`),
[488] Fix | Delete
KEY `id_evp` (`event_parent`),
[489] Fix | Delete
KEY `idx_ev1` (`event_owner`),
[490] Fix | Delete
KEY `idx_ev2` (`event_project`)
[491] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[492] Fix | Delete
[493] Fix | Delete
-- --------------------------------------------------------
[494] Fix | Delete
[495] Fix | Delete
--
[496] Fix | Delete
-- Table structure for table `[[dbprefix]]event_queue`
[497] Fix | Delete
--
[498] Fix | Delete
[499] Fix | Delete
1234
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function