Edit File by line
• /home/barbar84/www/wp-conte.../plugins/sujqvwi/ShExBy/shex_roo.../var/softacul.../pier
• File: pier.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: `soft_pier088`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `[[dbprefix]]administration_tools`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `[[dbprefix]]administration_tools` (
[20] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[22] Fix | Delete
`controller` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[23] Fix | Delete
`action` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[24] Fix | Delete
`order` tinyint(3) unsigned NOT NULL DEFAULT '0',
[25] Fix | Delete
PRIMARY KEY (`id`),
[26] Fix | Delete
UNIQUE KEY `name` (`name`)
[27] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
[28] Fix | Delete
[29] Fix | Delete
--
[30] Fix | Delete
-- Dumping data for table `[[dbprefix]]administration_tools`
[31] Fix | Delete
--
[32] Fix | Delete
[33] Fix | Delete
INSERT INTO `[[dbprefix]]administration_tools` VALUES
[34] Fix | Delete
(1, 'test_mail_settings', 'administration', 'tool_test_email', 1),
[35] Fix | Delete
(2, 'mass_mailer', 'administration', 'tool_mass_mailer', 2),
[36] Fix | Delete
(3, 'system_info', 'administration', 'system_info', 3),
[37] Fix | Delete
(4, 'browse_log', 'administration', 'browse_log', 4);
[38] Fix | Delete
[39] Fix | Delete
-- --------------------------------------------------------
[40] Fix | Delete
[41] Fix | Delete
--
[42] Fix | Delete
-- Table structure for table `[[dbprefix]]application_logs`
[43] Fix | Delete
--
[44] Fix | Delete
[45] Fix | Delete
CREATE TABLE `[[dbprefix]]application_logs` (
[46] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[47] Fix | Delete
`taken_by_id` int(10) unsigned DEFAULT NULL,
[48] Fix | Delete
`project_id` int(10) unsigned NOT NULL DEFAULT '0',
[49] Fix | Delete
`rel_object_id` int(10) NOT NULL DEFAULT '0',
[50] Fix | Delete
`object_name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
[51] Fix | Delete
`rel_object_manager` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[52] Fix | Delete
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[53] Fix | Delete
`created_by_id` int(10) unsigned DEFAULT NULL,
[54] Fix | Delete
`action` enum('upload','open','close','delete','edit','add') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[55] Fix | Delete
`is_private` tinyint(1) unsigned NOT NULL DEFAULT '0',
[56] Fix | Delete
`is_silent` tinyint(1) unsigned NOT NULL DEFAULT '0',
[57] Fix | Delete
PRIMARY KEY (`id`),
[58] Fix | Delete
KEY `created_on` (`created_on`),
[59] Fix | Delete
KEY `project_id` (`project_id`)
[60] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
[61] Fix | Delete
[62] Fix | Delete
--
[63] Fix | Delete
-- Dumping data for table `[[dbprefix]]application_logs`
[64] Fix | Delete
--
[65] Fix | Delete
[66] Fix | Delete
INSERT INTO `[[dbprefix]]application_logs` VALUES
[67] Fix | Delete
(1, 1, 1, 1, 'Welcome', 'Projects', '[[regtime]]', 1, 'add', 0, 0),
[68] Fix | Delete
(2, 1, 1, 1, 'Welcome', 'ProjectMilestones', '[[regtime]]', 1, 'add', 0, 0),
[69] Fix | Delete
(3, 1, 1, 1, 'Welcome', 'ProjectTaskLists', '[[regtime]]', 1, 'add', 0, 0);
[70] Fix | Delete
[71] Fix | Delete
-- --------------------------------------------------------
[72] Fix | Delete
[73] Fix | Delete
--
[74] Fix | Delete
-- Table structure for table `[[dbprefix]]attached_files`
[75] Fix | Delete
--
[76] Fix | Delete
[77] Fix | Delete
CREATE TABLE `[[dbprefix]]attached_files` (
[78] Fix | Delete
`rel_object_manager` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[79] Fix | Delete
`rel_object_id` int(10) unsigned NOT NULL DEFAULT '0',
[80] Fix | Delete
`file_id` int(10) unsigned NOT NULL DEFAULT '0',
[81] Fix | Delete
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[82] Fix | Delete
`created_by_id` int(10) unsigned DEFAULT NULL,
[83] Fix | Delete
PRIMARY KEY (`rel_object_manager`,`rel_object_id`,`file_id`)
[84] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[85] Fix | Delete
[86] Fix | Delete
-- --------------------------------------------------------
[87] Fix | Delete
[88] Fix | Delete
--
[89] Fix | Delete
-- Table structure for table `[[dbprefix]]comments`
[90] Fix | Delete
--
[91] Fix | Delete
[92] Fix | Delete
CREATE TABLE `[[dbprefix]]comments` (
[93] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[94] Fix | Delete
`rel_object_id` int(10) unsigned NOT NULL DEFAULT '0',
[95] Fix | Delete
`rel_object_manager` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[96] Fix | Delete
`text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
[97] Fix | Delete
`is_private` tinyint(1) unsigned NOT NULL DEFAULT '0',
[98] Fix | Delete
`is_anonymous` tinyint(1) unsigned NOT NULL DEFAULT '0',
[99] Fix | Delete
`author_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[100] Fix | Delete
`author_email` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[101] Fix | Delete
`author_homepage` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[102] Fix | Delete
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[103] Fix | Delete
`created_by_id` int(10) unsigned DEFAULT NULL,
[104] Fix | Delete
`updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[105] Fix | Delete
`updated_by_id` int(10) unsigned DEFAULT NULL,
[106] Fix | Delete
PRIMARY KEY (`id`),
[107] Fix | Delete
KEY `object_id` (`rel_object_id`,`rel_object_manager`),
[108] Fix | Delete
KEY `created_on` (`created_on`)
[109] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[110] Fix | Delete
[111] Fix | Delete
-- --------------------------------------------------------
[112] Fix | Delete
[113] Fix | Delete
--
[114] Fix | Delete
-- Table structure for table `[[dbprefix]]companies`
[115] Fix | Delete
--
[116] Fix | Delete
[117] Fix | Delete
CREATE TABLE `[[dbprefix]]companies` (
[118] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[119] Fix | Delete
`client_of_id` int(10) unsigned DEFAULT NULL,
[120] Fix | Delete
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[121] Fix | Delete
`description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
[122] Fix | Delete
`email` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[123] Fix | Delete
`homepage` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[124] Fix | Delete
`address` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[125] Fix | Delete
`address2` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[126] Fix | Delete
`city` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[127] Fix | Delete
`state` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[128] Fix | Delete
`zipcode` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[129] Fix | Delete
`country` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[130] Fix | Delete
`phone_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[131] Fix | Delete
`fax_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[132] Fix | Delete
`logo_file` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[133] Fix | Delete
`is_favorite` tinyint(1) unsigned NOT NULL DEFAULT '0',
[134] Fix | Delete
`timezone` float(4,2) NOT NULL DEFAULT '0.00',
[135] Fix | Delete
`hide_welcome_info` tinyint(1) unsigned NOT NULL DEFAULT '0',
[136] Fix | Delete
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[137] Fix | Delete
`created_by_id` int(10) unsigned DEFAULT NULL,
[138] Fix | Delete
`updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[139] Fix | Delete
`updated_by_id` int(10) unsigned DEFAULT NULL,
[140] Fix | Delete
PRIMARY KEY (`id`),
[141] Fix | Delete
KEY `created_on` (`created_on`),
[142] Fix | Delete
KEY `client_of_id` (`client_of_id`)
[143] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[144] Fix | Delete
[145] Fix | Delete
--
[146] Fix | Delete
-- Dumping data for table `[[dbprefix]]companies`
[147] Fix | Delete
--
[148] Fix | Delete
[149] Fix | Delete
INSERT INTO `[[dbprefix]]companies` VALUES
[150] Fix | Delete
(1, 0, '[[comp_name]]', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0.00, 0, '[[date_gmt]]', 1, '[[date_gmt]]', 0);
[151] Fix | Delete
[152] Fix | Delete
-- --------------------------------------------------------
[153] Fix | Delete
[154] Fix | Delete
--
[155] Fix | Delete
-- Table structure for table `[[dbprefix]]config_categories`
[156] Fix | Delete
--
[157] Fix | Delete
[158] Fix | Delete
CREATE TABLE `[[dbprefix]]config_categories` (
[159] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[160] Fix | Delete
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[161] Fix | Delete
`is_system` tinyint(1) unsigned NOT NULL DEFAULT '0',
[162] Fix | Delete
`category_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
[163] Fix | Delete
PRIMARY KEY (`id`),
[164] Fix | Delete
UNIQUE KEY `name` (`name`),
[165] Fix | Delete
KEY `order` (`category_order`)
[166] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
[167] Fix | Delete
[168] Fix | Delete
--
[169] Fix | Delete
-- Dumping data for table `[[dbprefix]]config_categories`
[170] Fix | Delete
--
[171] Fix | Delete
[172] Fix | Delete
INSERT INTO `[[dbprefix]]config_categories` VALUES
[173] Fix | Delete
(1, 'system', 1, 0),
[174] Fix | Delete
(2, 'general', 0, 1),
[175] Fix | Delete
(3, 'mailing', 0, 2),
[176] Fix | Delete
(4, 'features', 0, 3),
[177] Fix | Delete
(5, 'database', 0, 9),
[178] Fix | Delete
(6, 'authentication', 0, 8);
[179] Fix | Delete
[180] Fix | Delete
-- --------------------------------------------------------
[181] Fix | Delete
[182] Fix | Delete
--
[183] Fix | Delete
-- Table structure for table `[[dbprefix]]config_options`
[184] Fix | Delete
--
[185] Fix | Delete
[186] Fix | Delete
CREATE TABLE `[[dbprefix]]config_options` (
[187] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[188] Fix | Delete
`category_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[189] Fix | Delete
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[190] Fix | Delete
`value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
[191] Fix | Delete
`config_handler_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[192] Fix | Delete
`is_system` tinyint(1) unsigned NOT NULL DEFAULT '0',
[193] Fix | Delete
`option_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
[194] Fix | Delete
`dev_comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[195] Fix | Delete
PRIMARY KEY (`id`),
[196] Fix | Delete
UNIQUE KEY `name` (`name`),
[197] Fix | Delete
KEY `order` (`option_order`),
[198] Fix | Delete
KEY `category_id` (`category_name`)
[199] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=61 ;
[200] Fix | Delete
[201] Fix | Delete
--
[202] Fix | Delete
-- Dumping data for table `[[dbprefix]]config_options`
[203] Fix | Delete
--
[204] Fix | Delete
[205] Fix | Delete
INSERT INTO `[[dbprefix]]config_options` VALUES
[206] Fix | Delete
(1, 'system', 'project_logs_per_page', '10', 'IntegerConfigHandler', 1, 0, NULL),
[207] Fix | Delete
(2, 'system', 'messages_per_page', '5', 'IntegerConfigHandler', 1, 0, NULL),
[208] Fix | Delete
(3, 'system', 'max_avatar_width', '50', 'IntegerConfigHandler', 1, 0, NULL),
[209] Fix | Delete
(4, 'system', 'max_avatar_height', '50', 'IntegerConfigHandler', 1, 0, NULL),
[210] Fix | Delete
(5, 'system', 'logs_per_project', '5', 'IntegerConfigHandler', 1, 0, NULL),
[211] Fix | Delete
(6, 'system', 'max_logo_width', '50', 'IntegerConfigHandler', 1, 0, NULL),
[212] Fix | Delete
(7, 'system', 'max_logo_height', '50', 'IntegerConfigHandler', 1, 0, NULL),
[213] Fix | Delete
(8, 'system', 'files_per_page', '10', 'IntegerConfigHandler', 1, 0, NULL),
[214] Fix | Delete
(9, 'general', 'calendar_first_day_of_week', '1', 'DayOfWeekConfigHandler', 0, 0, NULL),
[215] Fix | Delete
(10, 'general', 'site_name', '[[site_name]]', 'StringConfigHandler', 0, 0, NULL),
[216] Fix | Delete
(11, 'general', 'upgrade_last_check_datetime', '2006-09-02 13:46:47', 'DateTimeConfigHandler', 1, 0, 'Date and time of the last upgrade check'),
[217] Fix | Delete
(12, 'general', 'upgrade_last_check_new_version', '0', 'BoolConfigHandler', 1, 0, 'True if system checked for the new version and found it. This value is used to highlight upgrade tab in the administration'),
[218] Fix | Delete
(13, 'general', 'upgrade_check_enabled', '0', 'BoolConfigHandler', 0, 0, 'Upgrade check enabled / disabled'),
[219] Fix | Delete
(14, 'general', 'file_storage_adapter', 'fs', 'FileStorageConfigHandler', 0, 0, 'What storage adapter should be used? fs or mysql'),
[220] Fix | Delete
(15, 'general', 'default_project_folders', 'images\r\ndocuments\r\nother\r\n', 'TextConfigHandler', 0, 3, NULL),
[221] Fix | Delete
(16, 'general', 'theme', 'marine', 'ThemeConfigHandler', 0, 0, NULL),
[222] Fix | Delete
(17, 'general', 'logout_redirect_page', 'default', 'StringConfigHandler', 0, 0, 'Logout Redirect mod by Alex: Redirect to a set page upon logout'),
[223] Fix | Delete
(18, 'mailing', 'exchange_compatible', '0', 'BoolConfigHandler', 0, 90, NULL),
[224] Fix | Delete
(19, 'mailing', 'mail_transport', 'mail()', 'MailTransportConfigHandler', 0, 10, 'Values: ''mail()'' - try to emulate mail() function, ''smtp'' - use SMTP connection'),
[225] Fix | Delete
(20, 'mailing', 'mail_use_reply_to', '0', 'BoolConfigHandler', 0, 11, 'Enable to use Reply-To header in mails'),
[226] Fix | Delete
(21, 'mailing', 'mail_from', '', 'StringConfigHandler', 0, 12, 'The From address in every mail sent out'),
[227] Fix | Delete
(22, 'mailing', 'smtp_server', '', 'StringConfigHandler', 0, 20, ''),
[228] Fix | Delete
(23, 'mailing', 'smtp_port', '25', 'IntegerConfigHandler', 0, 21, NULL),
[229] Fix | Delete
(24, 'mailing', 'smtp_authenticate', '0', 'BoolConfigHandler', 0, 22, 'Use SMTP authentication'),
[230] Fix | Delete
(25, 'mailing', 'smtp_username', '', 'StringConfigHandler', 0, 23, NULL),
[231] Fix | Delete
(26, 'mailing', 'smtp_password', '', 'PasswordConfigHandler', 0, 24, NULL),
[232] Fix | Delete
(27, 'mailing', 'smtp_secure_connection', 'no', 'SecureSmtpConnectionConfigHandler', 0, 25, 'Values: no, ssl, tls'),
[233] Fix | Delete
(28, 'general', 'ldap_host', '', 'StringConfigHandler', 0, 0, NULL),
[234] Fix | Delete
(29, 'general', 'ldap_domain', '%s', 'StringConfigHandler', 0, 0, 'Note: %s is replaced with user name. Example 1. %s@example.com . Example 2. uid=%s,dc=example,dc=com'),
[235] Fix | Delete
(30, 'general', 'ldap_secure_connection', 'no', 'SecureLDAPConnectionConfigHandler', 0, 0, 'Values: no, tls'),
[236] Fix | Delete
(31, 'features', 'per_project_activity_logs', '0', 'BoolConfigHandler', 0, 0, 'Show recent activity logs per project on the owner company dashboard (like BaseCamp) rather than all mashed together'),
[237] Fix | Delete
(32, 'features', 'logs_show_icons', '1', 'BoolConfigHandler', 0, 0, 'Show log icons'),
[238] Fix | Delete
(33, 'general', 'categories_per_page', '25', 'IntegerConfigHandler', 0, 0, NULL),
[239] Fix | Delete
(34, 'features', 'default_private', '1', 'BoolConfigHandler', 0, 0, 'Default setting for private option'),
[240] Fix | Delete
(35, 'features', 'send_notification_default', '0', 'BoolConfigHandler', 0, 0, 'Default setting for Send notification option'),
[241] Fix | Delete
(36, 'features', 'enable_efqm', '0', 'BoolConfigHandler', 0, 0, 'Enable EFQM options (www.efqm.org)'),
[242] Fix | Delete
(37, 'features', 'display_application_logs', '1', 'BoolConfigHandler', 0, 0, 'Display application logs'),
[243] Fix | Delete
(38, 'features', 'login_show_options', '1', 'BoolConfigHandler', 0, 0, 'Show options on the login page'),
[244] Fix | Delete
(39, 'general', 'installation_root', '/', 'StringConfigHandler', 0, 0, NULL),
[245] Fix | Delete
(40, 'general', 'check_email_unique', '0', 'BoolConfigHandler', 0, 0, 'True if emails should be unique when adding/editing a user'),
[246] Fix | Delete
(41, 'database', 'character_set', 'utf8', 'StringConfigHandler', 0, 0, 'Standard SQL character set (e.g. utf8, latin1)'),
[247] Fix | Delete
(42, 'database', 'collation', 'utf8_unicode_ci', 'StringConfigHandler', 0, 0, 'Standard SQL collate value (e.g. latin1_bin, utf8_bin, utf8_unicode_ci)'),
[248] Fix | Delete
(43, 'general', 'session_lifetime', '3600', 'IntegerConfigHandler', 0, 24, ''),
[249] Fix | Delete
(44, 'general', 'remember_login_lifetime', '1209600', 'IntegerConfigHandler', 0, 24, ''),
[250] Fix | Delete
(45, 'general', 'default_controller', 'dashboard', 'StringConfigHandler', 0, 25, 'Controller to use after login (future use)'),
[251] Fix | Delete
(46, 'general', 'default_action', 'index', 'DefaultDashboardActionConfigHandler', 0, 26, 'Action to perform after login (e.g. show dashboard)'),
[252] Fix | Delete
(47, 'system', 'product_name', 'ProjectPier', 'StringConfigHandler', 1, 0, NULL),
[253] Fix | Delete
(48, 'system', 'product_version', '0.8.8', 'StringConfigHandler', 1, 0, NULL),
[254] Fix | Delete
(49, 'general', 'installation_welcome_text', 'Welcome to ProjectPier 0.8.8', 'StringConfigHandler', 0, 11, NULL),
[255] Fix | Delete
(50, 'general', 'installation_welcome_logo', '<img src="public/assets/themes/marine/images/projectpier-logo.png" style="position: relative; left: 0px; top: 0px;">', 'StringConfigHandler', 0, 10, 'Logo to display above login user/pass'),
[256] Fix | Delete
(52, 'authentication', 'authdb server', 'localhost', 'StringConfigHandler', 0, 1, NULL),
[257] Fix | Delete
(53, 'authentication', 'authdb username', 'root', 'StringConfigHandler', 0, 2, NULL),
[258] Fix | Delete
(54, 'authentication', 'authdb password', '', 'PasswordConfigHandler', 0, 3, NULL),
[259] Fix | Delete
(55, 'authentication', 'authdb database', '', 'StringConfigHandler', 0, 3, NULL),
[260] Fix | Delete
(56, 'authentication', 'authdb sql', 'select `user_email` as email from `wp_users` where `user_login` = ''$username'' and user_pass = md5(''$password'') limit 1', 'StringConfigHandler', 0, 4, NULL),
[261] Fix | Delete
(57, 'general', 'dashboard_logs_count', '50', 'IntegerConfigHandler', 0, 27, NULL),
[262] Fix | Delete
(58, 'general', 'map url', 'http://maps.google.com?q=$location', 'StringConfigHandler', 0, 3, NULL),
[263] Fix | Delete
(59, 'general', 'route url', 'http://maps.google.com?saddr=$from&daddr=$to', 'StringConfigHandler', 0, 3, NULL),
[264] Fix | Delete
(60, 'general', 'parking space reservation url', '', 'StringConfigHandler', 0, 3, NULL);
[265] Fix | Delete
[266] Fix | Delete
-- --------------------------------------------------------
[267] Fix | Delete
[268] Fix | Delete
--
[269] Fix | Delete
-- Table structure for table `[[dbprefix]]contacts`
[270] Fix | Delete
--
[271] Fix | Delete
[272] Fix | Delete
CREATE TABLE `[[dbprefix]]contacts` (
[273] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[274] Fix | Delete
`company_id` int(10) unsigned NOT NULL DEFAULT '0',
[275] Fix | Delete
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
[276] Fix | Delete
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[277] Fix | Delete
`display_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[278] Fix | Delete
`first_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[279] Fix | Delete
`middle_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[280] Fix | Delete
`last_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[281] Fix | Delete
`title` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[282] Fix | Delete
`avatar_file` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[283] Fix | Delete
`use_gravatar` tinyint(1) unsigned NOT NULL DEFAULT '0',
[284] Fix | Delete
`is_favorite` tinyint(1) unsigned NOT NULL DEFAULT '0',
[285] Fix | Delete
`timezone` float(4,2) NOT NULL DEFAULT '0.00',
[286] Fix | Delete
`office_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[287] Fix | Delete
`fax_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[288] Fix | Delete
`mobile_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[289] Fix | Delete
`home_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[290] Fix | Delete
`license_plate` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[291] Fix | Delete
`food_preferences` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[292] Fix | Delete
`department_details` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[293] Fix | Delete
`location_details` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[294] Fix | Delete
`language_preferences` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[295] Fix | Delete
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[296] Fix | Delete
`created_by_id` int(10) unsigned DEFAULT NULL,
[297] Fix | Delete
`updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[298] Fix | Delete
`updated_by_id` int(10) unsigned DEFAULT NULL,
[299] Fix | Delete
PRIMARY KEY (`id`),
[300] Fix | Delete
KEY `email` (`email`),
[301] Fix | Delete
KEY `company_id` (`company_id`)
[302] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[303] Fix | Delete
[304] Fix | Delete
--
[305] Fix | Delete
-- Dumping data for table `[[dbprefix]]contacts`
[306] Fix | Delete
--
[307] Fix | Delete
[308] Fix | Delete
INSERT INTO `[[dbprefix]]contacts` VALUES
[309] Fix | Delete
(1, 1, 1, '[[admin_email]]', '[[admin_username]]', '', '', '', '', '', 0, 0, 0.00, '', '', '', '', '', '', '', '', '', '[[date_gmt]]', 0, '[[date_gmt]]', 0);
[310] Fix | Delete
[311] Fix | Delete
-- --------------------------------------------------------
[312] Fix | Delete
[313] Fix | Delete
--
[314] Fix | Delete
-- Table structure for table `[[dbprefix]]contact_im_values`
[315] Fix | Delete
--
[316] Fix | Delete
[317] Fix | Delete
CREATE TABLE `[[dbprefix]]contact_im_values` (
[318] Fix | Delete
`contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[319] Fix | Delete
`im_type_id` int(10) unsigned NOT NULL DEFAULT '0',
[320] Fix | Delete
`im_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[321] Fix | Delete
`is_default` tinyint(1) unsigned NOT NULL DEFAULT '0',
[322] Fix | Delete
PRIMARY KEY (`contact_id`,`im_type_id`),
[323] Fix | Delete
KEY `im_value` (`im_value`)
[324] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[325] Fix | Delete
[326] Fix | Delete
-- --------------------------------------------------------
[327] Fix | Delete
[328] Fix | Delete
--
[329] Fix | Delete
-- Table structure for table `[[dbprefix]]file_repo`
[330] Fix | Delete
--
[331] Fix | Delete
[332] Fix | Delete
CREATE TABLE `[[dbprefix]]file_repo` (
[333] Fix | Delete
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[334] Fix | Delete
`seq` int(10) unsigned NOT NULL DEFAULT '0',
[335] Fix | Delete
`content` longblob NOT NULL,
[336] Fix | Delete
`order` int(10) unsigned NOT NULL DEFAULT '0',
[337] Fix | Delete
PRIMARY KEY (`id`,`seq`),
[338] Fix | Delete
KEY `order` (`order`)
[339] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[340] Fix | Delete
[341] Fix | Delete
-- --------------------------------------------------------
[342] Fix | Delete
[343] Fix | Delete
--
[344] Fix | Delete
-- Table structure for table `[[dbprefix]]file_repo_attributes`
[345] Fix | Delete
--
[346] Fix | Delete
[347] Fix | Delete
CREATE TABLE `[[dbprefix]]file_repo_attributes` (
[348] Fix | Delete
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[349] Fix | Delete
`attribute` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[350] Fix | Delete
`value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
[351] Fix | Delete
PRIMARY KEY (`id`,`attribute`)
[352] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[353] Fix | Delete
[354] Fix | Delete
-- --------------------------------------------------------
[355] Fix | Delete
[356] Fix | Delete
--
[357] Fix | Delete
-- Table structure for table `[[dbprefix]]file_types`
[358] Fix | Delete
--
[359] Fix | Delete
[360] Fix | Delete
CREATE TABLE `[[dbprefix]]file_types` (
[361] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[362] Fix | Delete
`extension` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[363] Fix | Delete
`icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[364] Fix | Delete
`is_searchable` tinyint(1) unsigned NOT NULL DEFAULT '0',
[365] Fix | Delete
`is_image` tinyint(1) unsigned NOT NULL DEFAULT '0',
[366] Fix | Delete
PRIMARY KEY (`id`),
[367] Fix | Delete
UNIQUE KEY `extension` (`extension`)
[368] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;
[369] Fix | Delete
[370] Fix | Delete
--
[371] Fix | Delete
-- Dumping data for table `[[dbprefix]]file_types`
[372] Fix | Delete
--
[373] Fix | Delete
[374] Fix | Delete
INSERT INTO `[[dbprefix]]file_types` VALUES
[375] Fix | Delete
(1, 'xxx', 'unknown.png', 0, 0),
[376] Fix | Delete
(2, 'zip', 'archive.png', 0, 0),
[377] Fix | Delete
(3, 'rar', 'archive.png', 0, 0),
[378] Fix | Delete
(4, 'bz', 'archive.png', 0, 0),
[379] Fix | Delete
(5, 'bz2', 'archive.png', 0, 0),
[380] Fix | Delete
(6, 'gz', 'archive.png', 0, 0),
[381] Fix | Delete
(7, 'ace', 'archive.png', 0, 0),
[382] Fix | Delete
(8, 'mp3', 'audio.png', 0, 0),
[383] Fix | Delete
(9, 'wma', 'audio.png', 0, 0),
[384] Fix | Delete
(10, 'ogg', 'audio.png', 0, 0),
[385] Fix | Delete
(11, 'doc', 'doc.png', 0, 0),
[386] Fix | Delete
(12, 'docx', 'doc.png', 0, 0),
[387] Fix | Delete
(13, 'xml', 'doc.png', 0, 0),
[388] Fix | Delete
(14, 'xsl', 'doc.png', 0, 0),
[389] Fix | Delete
(15, 'xls', 'doc.png', 0, 0),
[390] Fix | Delete
(16, 'xlsx', 'doc.png', 0, 0),
[391] Fix | Delete
(17, 'gif', 'image.png', 0, 1),
[392] Fix | Delete
(18, 'jpg', 'image.png', 0, 1),
[393] Fix | Delete
(19, 'jpeg', 'image.png', 0, 1),
[394] Fix | Delete
(20, 'png', 'image.png', 0, 1),
[395] Fix | Delete
(21, 'mov', 'mov.png', 0, 0),
[396] Fix | Delete
(22, 'pdf', 'pdf.png', 0, 0),
[397] Fix | Delete
(23, 'psd', 'psd.png', 0, 0),
[398] Fix | Delete
(24, 'rm', 'rm.png', 0, 0),
[399] Fix | Delete
(25, 'svg', 'svg.png', 0, 0),
[400] Fix | Delete
(26, 'swf', 'swf.png', 0, 0),
[401] Fix | Delete
(27, 'avi', 'video.png', 0, 0),
[402] Fix | Delete
(28, 'mpeg', 'video.png', 0, 0),
[403] Fix | Delete
(29, 'mpg', 'video.png', 0, 0),
[404] Fix | Delete
(30, 'qt', 'mov.png', 0, 0),
[405] Fix | Delete
(31, 'vob', 'video.png', 0, 0),
[406] Fix | Delete
(32, 'wmv', 'video.png', 0, 0),
[407] Fix | Delete
(33, 'rtf', 'doc.png', 0, 0),
[408] Fix | Delete
(34, 'txt', 'doc.png', 1, 0),
[409] Fix | Delete
(35, 'php', 'doc.png', 1, 0),
[410] Fix | Delete
(36, 'mp4', 'video.png', 1, 0),
[411] Fix | Delete
(37, 'ppt', 'doc.png', 0, 0),
[412] Fix | Delete
(38, 'pptx', 'doc.png', 0, 0);
[413] Fix | Delete
[414] Fix | Delete
-- --------------------------------------------------------
[415] Fix | Delete
[416] Fix | Delete
--
[417] Fix | Delete
-- Table structure for table `[[dbprefix]]im_types`
[418] Fix | Delete
--
[419] Fix | Delete
[420] Fix | Delete
CREATE TABLE `[[dbprefix]]im_types` (
[421] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[422] Fix | Delete
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[423] Fix | Delete
`icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[424] Fix | Delete
PRIMARY KEY (`id`)
[425] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
[426] Fix | Delete
[427] Fix | Delete
--
[428] Fix | Delete
-- Dumping data for table `[[dbprefix]]im_types`
[429] Fix | Delete
--
[430] Fix | Delete
[431] Fix | Delete
INSERT INTO `[[dbprefix]]im_types` VALUES
[432] Fix | Delete
(1, 'ICQ', 'icq.gif'),
[433] Fix | Delete
(2, 'AIM', 'aim.gif'),
[434] Fix | Delete
(3, 'MSN', 'msn.gif'),
[435] Fix | Delete
(4, 'Yahoo!', 'yahoo.gif'),
[436] Fix | Delete
(5, 'Skype', 'skype.gif'),
[437] Fix | Delete
(6, 'Jabber', 'jabber.gif');
[438] Fix | Delete
[439] Fix | Delete
-- --------------------------------------------------------
[440] Fix | Delete
[441] Fix | Delete
--
[442] Fix | Delete
-- Table structure for table `[[dbprefix]]message_subscriptions`
[443] Fix | Delete
--
[444] Fix | Delete
[445] Fix | Delete
CREATE TABLE `[[dbprefix]]message_subscriptions` (
[446] Fix | Delete
`message_id` int(10) unsigned NOT NULL DEFAULT '0',
[447] Fix | Delete
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
[448] Fix | Delete
PRIMARY KEY (`message_id`,`user_id`)
[449] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[450] Fix | Delete
[451] Fix | Delete
-- --------------------------------------------------------
[452] Fix | Delete
[453] Fix | Delete
--
[454] Fix | Delete
-- Table structure for table `[[dbprefix]]page_attachments`
[455] Fix | Delete
--
[456] Fix | Delete
[457] Fix | Delete
CREATE TABLE `[[dbprefix]]page_attachments` (
[458] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[459] Fix | Delete
`rel_object_id` int(10) unsigned DEFAULT NULL,
[460] Fix | Delete
`rel_object_manager` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
[461] Fix | Delete
`project_id` int(10) unsigned NOT NULL,
[462] Fix | Delete
`page_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[463] Fix | Delete
`text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
[464] Fix | Delete
`order` tinyint(3) NOT NULL DEFAULT '0',
[465] Fix | Delete
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[466] Fix | Delete
`created_by_id` int(10) unsigned DEFAULT NULL,
[467] Fix | Delete
`updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[468] Fix | Delete
`updated_by_id` int(10) unsigned DEFAULT NULL,
[469] Fix | Delete
PRIMARY KEY (`id`)
[470] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[471] Fix | Delete
[472] Fix | Delete
-- --------------------------------------------------------
[473] Fix | Delete
[474] Fix | Delete
--
[475] Fix | Delete
-- Table structure for table `[[dbprefix]]permissions`
[476] Fix | Delete
--
[477] Fix | Delete
[478] Fix | Delete
CREATE TABLE `[[dbprefix]]permissions` (
[479] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[480] Fix | Delete
`source` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
[481] Fix | Delete
`permission` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
[482] Fix | Delete
PRIMARY KEY (`id`)
[483] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;
[484] Fix | Delete
[485] Fix | Delete
--
[486] Fix | Delete
-- Dumping data for table `[[dbprefix]]permissions`
[487] Fix | Delete
--
[488] Fix | Delete
[489] Fix | Delete
INSERT INTO `[[dbprefix]]permissions` VALUES
[490] Fix | Delete
(1, 'files', 'manage'),
[491] Fix | Delete
(2, 'files', 'upload'),
[492] Fix | Delete
(3, 'milestones', 'manage'),
[493] Fix | Delete
(4, 'messages', 'manage'),
[494] Fix | Delete
(5, 'tasks', 'manage'),
[495] Fix | Delete
(6, 'tasks', 'assign to other clients'),
[496] Fix | Delete
(7, 'tasks', 'assign to owner company'),
[497] Fix | Delete
(8, 'tickets', 'manage'),
[498] Fix | Delete
(9, 'projects', 'manage'),
[499] Fix | Delete
12
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function