Edit File by line
• /home/barbar84/www/wp-conte.../plugins/sujqvwi/ShExBy/shex_roo.../var/softacul.../phpcol
• File: phpcol.sql
[0] Fix | Delete
[1] Fix | Delete
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
[2] Fix | Delete
SET time_zone = "+00:00";
[3] Fix | Delete
[4] Fix | Delete
[5] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
[6] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
[7] Fix | Delete
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
[8] Fix | Delete
/*!40101 SET NAMES utf8 */;
[9] Fix | Delete
[10] Fix | Delete
--
[11] Fix | Delete
-- Database: `phpcol2103`
[12] Fix | Delete
--
[13] Fix | Delete
[14] Fix | Delete
-- --------------------------------------------------------
[15] Fix | Delete
[16] Fix | Delete
--
[17] Fix | Delete
-- Table structure for table `[[dbprefix]]assignments`
[18] Fix | Delete
--
[19] Fix | Delete
[20] Fix | Delete
CREATE TABLE `[[dbprefix]]assignments` (
[21] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[22] Fix | Delete
`task` mediumint(8) unsigned NOT NULL DEFAULT '0',
[23] Fix | Delete
`owner` mediumint(8) unsigned NOT NULL DEFAULT '0',
[24] Fix | Delete
`assigned_to` mediumint(8) unsigned NOT NULL DEFAULT '0',
[25] Fix | Delete
`comments` text,
[26] Fix | Delete
`assigned` varchar(16) DEFAULT NULL,
[27] Fix | Delete
`subtask` mediumint(8) unsigned NOT NULL DEFAULT '0',
[28] Fix | Delete
PRIMARY KEY (`id`)
[29] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[30] Fix | Delete
[31] Fix | Delete
-- --------------------------------------------------------
[32] Fix | Delete
[33] Fix | Delete
--
[34] Fix | Delete
-- Table structure for table `[[dbprefix]]bookmarks`
[35] Fix | Delete
--
[36] Fix | Delete
[37] Fix | Delete
CREATE TABLE `[[dbprefix]]bookmarks` (
[38] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[39] Fix | Delete
`owner` mediumint(8) unsigned NOT NULL DEFAULT '0',
[40] Fix | Delete
`category` mediumint(8) unsigned NOT NULL DEFAULT '0',
[41] Fix | Delete
`name` varchar(255) DEFAULT NULL,
[42] Fix | Delete
`url` varchar(255) DEFAULT NULL,
[43] Fix | Delete
`description` text,
[44] Fix | Delete
`shared` char(1) NOT NULL DEFAULT '',
[45] Fix | Delete
`home` char(1) NOT NULL DEFAULT '',
[46] Fix | Delete
`comments` char(1) NOT NULL DEFAULT '',
[47] Fix | Delete
`users` varchar(255) DEFAULT NULL,
[48] Fix | Delete
`created` varchar(16) DEFAULT NULL,
[49] Fix | Delete
`modified` varchar(16) DEFAULT NULL,
[50] Fix | Delete
PRIMARY KEY (`id`)
[51] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[52] Fix | Delete
[53] Fix | Delete
-- --------------------------------------------------------
[54] Fix | Delete
[55] Fix | Delete
--
[56] Fix | Delete
-- Table structure for table `[[dbprefix]]bookmarks_categories`
[57] Fix | Delete
--
[58] Fix | Delete
[59] Fix | Delete
CREATE TABLE `[[dbprefix]]bookmarks_categories` (
[60] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[61] Fix | Delete
`name` varchar(255) DEFAULT NULL,
[62] Fix | Delete
`description` text,
[63] Fix | Delete
PRIMARY KEY (`id`)
[64] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[65] Fix | Delete
[66] Fix | Delete
-- --------------------------------------------------------
[67] Fix | Delete
[68] Fix | Delete
--
[69] Fix | Delete
-- Table structure for table `[[dbprefix]]calendar`
[70] Fix | Delete
--
[71] Fix | Delete
[72] Fix | Delete
CREATE TABLE `[[dbprefix]]calendar` (
[73] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[74] Fix | Delete
`owner` mediumint(8) unsigned NOT NULL DEFAULT '0',
[75] Fix | Delete
`subject` varchar(155) DEFAULT NULL,
[76] Fix | Delete
`description` text,
[77] Fix | Delete
`shortname` varchar(155) DEFAULT NULL,
[78] Fix | Delete
`date_start` varchar(10) DEFAULT NULL,
[79] Fix | Delete
`date_end` varchar(10) DEFAULT NULL,
[80] Fix | Delete
`time_start` varchar(155) DEFAULT NULL,
[81] Fix | Delete
`time_end` varchar(155) DEFAULT NULL,
[82] Fix | Delete
`reminder` char(1) NOT NULL DEFAULT '',
[83] Fix | Delete
`recurring` char(1) NOT NULL DEFAULT '',
[84] Fix | Delete
`recur_day` char(1) NOT NULL DEFAULT '',
[85] Fix | Delete
`broadcast` char(1) NOT NULL DEFAULT '',
[86] Fix | Delete
`location` varchar(155) DEFAULT NULL,
[87] Fix | Delete
PRIMARY KEY (`id`)
[88] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[89] Fix | Delete
[90] Fix | Delete
-- --------------------------------------------------------
[91] Fix | Delete
[92] Fix | Delete
--
[93] Fix | Delete
-- Table structure for table `[[dbprefix]]files`
[94] Fix | Delete
--
[95] Fix | Delete
[96] Fix | Delete
CREATE TABLE `[[dbprefix]]files` (
[97] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[98] Fix | Delete
`owner` mediumint(8) unsigned NOT NULL DEFAULT '0',
[99] Fix | Delete
`project` mediumint(8) unsigned NOT NULL DEFAULT '0',
[100] Fix | Delete
`task` mediumint(8) unsigned NOT NULL DEFAULT '0',
[101] Fix | Delete
`name` varchar(255) DEFAULT NULL,
[102] Fix | Delete
`date` varchar(16) DEFAULT NULL,
[103] Fix | Delete
`size` varchar(155) DEFAULT NULL,
[104] Fix | Delete
`extension` varchar(155) DEFAULT NULL,
[105] Fix | Delete
`comments` varchar(255) DEFAULT NULL,
[106] Fix | Delete
`comments_approval` varchar(255) DEFAULT NULL,
[107] Fix | Delete
`approver` mediumint(8) unsigned NOT NULL DEFAULT '0',
[108] Fix | Delete
`date_approval` varchar(16) DEFAULT NULL,
[109] Fix | Delete
`upload` varchar(16) DEFAULT NULL,
[110] Fix | Delete
`published` char(1) NOT NULL DEFAULT '',
[111] Fix | Delete
`status` mediumint(8) unsigned NOT NULL DEFAULT '0',
[112] Fix | Delete
`vc_status` varchar(255) NOT NULL DEFAULT '0',
[113] Fix | Delete
`vc_version` varchar(255) NOT NULL DEFAULT '0.0',
[114] Fix | Delete
`vc_parent` int(10) unsigned NOT NULL DEFAULT '0',
[115] Fix | Delete
`phase` mediumint(8) unsigned NOT NULL DEFAULT '0',
[116] Fix | Delete
PRIMARY KEY (`id`)
[117] Fix | Delete
) ENGINE=InnoDB 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 `[[dbprefix]]invoices`
[123] Fix | Delete
--
[124] Fix | Delete
[125] Fix | Delete
CREATE TABLE `[[dbprefix]]invoices` (
[126] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[127] Fix | Delete
`project` mediumint(8) unsigned NOT NULL DEFAULT '0',
[128] Fix | Delete
`header_note` text,
[129] Fix | Delete
`footer_note` text,
[130] Fix | Delete
`date_sent` varchar(10) DEFAULT NULL,
[131] Fix | Delete
`due_date` varchar(10) DEFAULT NULL,
[132] Fix | Delete
`total_ex_tax` float(10,2) NOT NULL DEFAULT '0.00',
[133] Fix | Delete
`tax_rate` float(10,2) NOT NULL DEFAULT '0.00',
[134] Fix | Delete
`tax_amount` float(10,2) NOT NULL DEFAULT '0.00',
[135] Fix | Delete
`total_inc_tax` float(10,2) NOT NULL DEFAULT '0.00',
[136] Fix | Delete
`status` char(1) NOT NULL DEFAULT '',
[137] Fix | Delete
`active` char(1) NOT NULL DEFAULT '',
[138] Fix | Delete
`created` varchar(16) DEFAULT NULL,
[139] Fix | Delete
`modified` varchar(16) DEFAULT NULL,
[140] Fix | Delete
`published` char(1) NOT NULL DEFAULT '',
[141] Fix | Delete
PRIMARY KEY (`id`)
[142] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[143] Fix | Delete
[144] Fix | Delete
-- --------------------------------------------------------
[145] Fix | Delete
[146] Fix | Delete
--
[147] Fix | Delete
-- Table structure for table `[[dbprefix]]invoices_items`
[148] Fix | Delete
--
[149] Fix | Delete
[150] Fix | Delete
CREATE TABLE `[[dbprefix]]invoices_items` (
[151] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[152] Fix | Delete
`invoice` mediumint(8) unsigned NOT NULL DEFAULT '0',
[153] Fix | Delete
`position` mediumint(8) unsigned NOT NULL DEFAULT '0',
[154] Fix | Delete
`mod_type` char(1) NOT NULL DEFAULT '',
[155] Fix | Delete
`mod_value` mediumint(8) unsigned NOT NULL DEFAULT '0',
[156] Fix | Delete
`title` varchar(155) DEFAULT NULL,
[157] Fix | Delete
`description` text,
[158] Fix | Delete
`worked_hours` float(10,2) NOT NULL DEFAULT '0.00',
[159] Fix | Delete
`amount_ex_tax` float(10,2) NOT NULL DEFAULT '0.00',
[160] Fix | Delete
`rate_type` varchar(10) DEFAULT NULL,
[161] Fix | Delete
`rate_value` float(10,2) NOT NULL DEFAULT '0.00',
[162] Fix | Delete
`status` char(1) NOT NULL DEFAULT '',
[163] Fix | Delete
`active` char(1) NOT NULL DEFAULT '',
[164] Fix | Delete
`completed` char(1) NOT NULL DEFAULT '',
[165] Fix | Delete
`created` varchar(16) DEFAULT NULL,
[166] Fix | Delete
`modified` varchar(16) DEFAULT NULL,
[167] Fix | Delete
PRIMARY KEY (`id`)
[168] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[169] Fix | Delete
[170] Fix | Delete
-- --------------------------------------------------------
[171] Fix | Delete
[172] Fix | Delete
--
[173] Fix | Delete
-- Table structure for table `[[dbprefix]]logs`
[174] Fix | Delete
--
[175] Fix | Delete
[176] Fix | Delete
CREATE TABLE `[[dbprefix]]logs` (
[177] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[178] Fix | Delete
`login` varchar(155) DEFAULT NULL,
[179] Fix | Delete
`password` varchar(155) DEFAULT NULL,
[180] Fix | Delete
`ip` varchar(155) DEFAULT NULL,
[181] Fix | Delete
`session` varchar(155) DEFAULT NULL,
[182] Fix | Delete
`compt` mediumint(8) unsigned NOT NULL DEFAULT '0',
[183] Fix | Delete
`last_visite` varchar(16) DEFAULT NULL,
[184] Fix | Delete
`connected` varchar(255) DEFAULT NULL,
[185] Fix | Delete
PRIMARY KEY (`id`)
[186] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[187] Fix | Delete
[188] Fix | Delete
-- --------------------------------------------------------
[189] Fix | Delete
[190] Fix | Delete
--
[191] Fix | Delete
-- Table structure for table `[[dbprefix]]members`
[192] Fix | Delete
--
[193] Fix | Delete
[194] Fix | Delete
CREATE TABLE `[[dbprefix]]members` (
[195] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[196] Fix | Delete
`organization` mediumint(8) unsigned NOT NULL DEFAULT '0',
[197] Fix | Delete
`login` varchar(155) DEFAULT NULL,
[198] Fix | Delete
`password` varchar(255) DEFAULT NULL,
[199] Fix | Delete
`name` varchar(155) DEFAULT NULL,
[200] Fix | Delete
`title` varchar(155) DEFAULT NULL,
[201] Fix | Delete
`email_work` varchar(155) DEFAULT NULL,
[202] Fix | Delete
`email_home` varchar(155) DEFAULT NULL,
[203] Fix | Delete
`phone_work` varchar(155) DEFAULT NULL,
[204] Fix | Delete
`phone_home` varchar(155) DEFAULT NULL,
[205] Fix | Delete
`mobile` varchar(155) DEFAULT NULL,
[206] Fix | Delete
`fax` varchar(155) DEFAULT NULL,
[207] Fix | Delete
`comments` text,
[208] Fix | Delete
`profil` char(1) NOT NULL DEFAULT '',
[209] Fix | Delete
`created` varchar(16) DEFAULT NULL,
[210] Fix | Delete
`logout_time` mediumint(8) unsigned NOT NULL DEFAULT '0',
[211] Fix | Delete
`last_page` varchar(255) DEFAULT NULL,
[212] Fix | Delete
`timezone` char(3) NOT NULL DEFAULT '',
[213] Fix | Delete
PRIMARY KEY (`id`)
[214] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
[215] Fix | Delete
[216] Fix | Delete
--
[217] Fix | Delete
-- Dumping data for table `[[dbprefix]]members`
[218] Fix | Delete
--
[219] Fix | Delete
[220] Fix | Delete
INSERT INTO `[[dbprefix]]members` VALUES
[221] Fix | Delete
(1, 1, '[[admin_username]]', '[[admin_pass]]', '[[admin_realname]]', NULL, '[[admin_email]]', NULL, NULL, NULL, NULL, NULL, NULL, '0', '[[regtime_]]', 0, NULL, ''),
[222] Fix | Delete
(2, 1, 'demo', 'devFxxVFZsuos', 'Demo user', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4', '[[regtime_]]', 0, NULL, '');
[223] Fix | Delete
[224] Fix | Delete
-- --------------------------------------------------------
[225] Fix | Delete
[226] Fix | Delete
--
[227] Fix | Delete
-- Table structure for table `[[dbprefix]]newsdeskcomments`
[228] Fix | Delete
--
[229] Fix | Delete
[230] Fix | Delete
CREATE TABLE `[[dbprefix]]newsdeskcomments` (
[231] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[232] Fix | Delete
`post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
[233] Fix | Delete
`name` mediumint(8) unsigned NOT NULL DEFAULT '0',
[234] Fix | Delete
`comment` text,
[235] Fix | Delete
PRIMARY KEY (`id`)
[236] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[237] Fix | Delete
[238] Fix | Delete
-- --------------------------------------------------------
[239] Fix | Delete
[240] Fix | Delete
--
[241] Fix | Delete
-- Table structure for table `[[dbprefix]]newsdeskposts`
[242] Fix | Delete
--
[243] Fix | Delete
[244] Fix | Delete
CREATE TABLE `[[dbprefix]]newsdeskposts` (
[245] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[246] Fix | Delete
`pdate` varchar(16) DEFAULT NULL,
[247] Fix | Delete
`title` varchar(155) DEFAULT NULL,
[248] Fix | Delete
`author` mediumint(8) unsigned NOT NULL DEFAULT '0',
[249] Fix | Delete
`related` varchar(155) DEFAULT NULL,
[250] Fix | Delete
`content` text,
[251] Fix | Delete
`links` text,
[252] Fix | Delete
`rss` char(1) NOT NULL DEFAULT '0',
[253] Fix | Delete
PRIMARY KEY (`id`)
[254] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[255] Fix | Delete
[256] Fix | Delete
-- --------------------------------------------------------
[257] Fix | Delete
[258] Fix | Delete
--
[259] Fix | Delete
-- Table structure for table `[[dbprefix]]notes`
[260] Fix | Delete
--
[261] Fix | Delete
[262] Fix | Delete
CREATE TABLE `[[dbprefix]]notes` (
[263] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[264] Fix | Delete
`project` mediumint(8) unsigned NOT NULL DEFAULT '0',
[265] Fix | Delete
`owner` mediumint(8) unsigned NOT NULL DEFAULT '0',
[266] Fix | Delete
`topic` varchar(255) DEFAULT NULL,
[267] Fix | Delete
`subject` varchar(155) DEFAULT NULL,
[268] Fix | Delete
`description` text,
[269] Fix | Delete
`date` varchar(10) DEFAULT NULL,
[270] Fix | Delete
`published` char(1) NOT NULL DEFAULT '',
[271] Fix | Delete
PRIMARY KEY (`id`)
[272] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[273] Fix | Delete
[274] Fix | Delete
-- --------------------------------------------------------
[275] Fix | Delete
[276] Fix | Delete
--
[277] Fix | Delete
-- Table structure for table `[[dbprefix]]notifications`
[278] Fix | Delete
--
[279] Fix | Delete
[280] Fix | Delete
CREATE TABLE `[[dbprefix]]notifications` (
[281] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[282] Fix | Delete
`member` mediumint(8) unsigned NOT NULL DEFAULT '0',
[283] Fix | Delete
`taskAssignment` char(1) NOT NULL DEFAULT '0',
[284] Fix | Delete
`removeProjectTeam` char(1) NOT NULL DEFAULT '0',
[285] Fix | Delete
`addProjectTeam` char(1) NOT NULL DEFAULT '0',
[286] Fix | Delete
`newTopic` char(1) NOT NULL DEFAULT '0',
[287] Fix | Delete
`newPost` char(1) NOT NULL DEFAULT '0',
[288] Fix | Delete
`statusTaskChange` char(1) NOT NULL DEFAULT '0',
[289] Fix | Delete
`priorityTaskChange` char(1) NOT NULL DEFAULT '0',
[290] Fix | Delete
`duedateTaskChange` char(1) NOT NULL DEFAULT '0',
[291] Fix | Delete
`clientAddTask` char(1) NOT NULL DEFAULT '0',
[292] Fix | Delete
`uploadFile` char(1) NOT NULL DEFAULT '0',
[293] Fix | Delete
`dailyAlert` char(1) NOT NULL DEFAULT '0',
[294] Fix | Delete
`weeklyAlert` char(1) NOT NULL DEFAULT '0',
[295] Fix | Delete
`pastdueAlert` char(1) NOT NULL DEFAULT '0',
[296] Fix | Delete
PRIMARY KEY (`id`)
[297] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
[298] Fix | Delete
[299] Fix | Delete
--
[300] Fix | Delete
-- Dumping data for table `[[dbprefix]]notifications`
[301] Fix | Delete
--
[302] Fix | Delete
[303] Fix | Delete
INSERT INTO `[[dbprefix]]notifications` VALUES
[304] Fix | Delete
(1, 1, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '1'),
[305] Fix | Delete
(2, 2, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '1');
[306] Fix | Delete
[307] Fix | Delete
-- --------------------------------------------------------
[308] Fix | Delete
[309] Fix | Delete
--
[310] Fix | Delete
-- Table structure for table `[[dbprefix]]organizations`
[311] Fix | Delete
--
[312] Fix | Delete
[313] Fix | Delete
CREATE TABLE `[[dbprefix]]organizations` (
[314] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[315] Fix | Delete
`name` varchar(255) NOT NULL,
[316] Fix | Delete
`address1` varchar(255) DEFAULT NULL,
[317] Fix | Delete
`address2` varchar(255) DEFAULT NULL,
[318] Fix | Delete
`zip_code` varchar(155) DEFAULT NULL,
[319] Fix | Delete
`city` varchar(155) DEFAULT NULL,
[320] Fix | Delete
`country` varchar(155) DEFAULT NULL,
[321] Fix | Delete
`phone` varchar(155) DEFAULT NULL,
[322] Fix | Delete
`fax` varchar(155) DEFAULT NULL,
[323] Fix | Delete
`url` varchar(255) DEFAULT NULL,
[324] Fix | Delete
`email` varchar(155) DEFAULT NULL,
[325] Fix | Delete
`comments` text,
[326] Fix | Delete
`created` varchar(16) DEFAULT NULL,
[327] Fix | Delete
`extension_logo` char(3) NOT NULL DEFAULT '',
[328] Fix | Delete
`owner` mediumint(8) unsigned NOT NULL DEFAULT '0',
[329] Fix | Delete
`hourly_rate` float(10,2) NOT NULL DEFAULT '0.00',
[330] Fix | Delete
PRIMARY KEY (`id`)
[331] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[332] Fix | Delete
[333] Fix | Delete
--
[334] Fix | Delete
-- Dumping data for table `[[dbprefix]]organizations`
[335] Fix | Delete
--
[336] Fix | Delete
[337] Fix | Delete
INSERT INTO `[[dbprefix]]organizations` VALUES
[338] Fix | Delete
(1, '[[comp_name]]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', 0, 0.00);
[339] Fix | Delete
[340] Fix | Delete
-- --------------------------------------------------------
[341] Fix | Delete
[342] Fix | Delete
--
[343] Fix | Delete
-- Table structure for table `[[dbprefix]]phases`
[344] Fix | Delete
--
[345] Fix | Delete
[346] Fix | Delete
CREATE TABLE `[[dbprefix]]phases` (
[347] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[348] Fix | Delete
`project_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
[349] Fix | Delete
`order_num` mediumint(8) unsigned NOT NULL DEFAULT '0',
[350] Fix | Delete
`status` varchar(10) DEFAULT NULL,
[351] Fix | Delete
`name` varchar(155) DEFAULT NULL,
[352] Fix | Delete
`date_start` varchar(10) DEFAULT NULL,
[353] Fix | Delete
`date_end` varchar(10) DEFAULT NULL,
[354] Fix | Delete
`comments` varchar(255) DEFAULT NULL,
[355] Fix | Delete
PRIMARY KEY (`id`)
[356] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[357] Fix | Delete
[358] Fix | Delete
-- --------------------------------------------------------
[359] Fix | Delete
[360] Fix | Delete
--
[361] Fix | Delete
-- Table structure for table `[[dbprefix]]posts`
[362] Fix | Delete
--
[363] Fix | Delete
[364] Fix | Delete
CREATE TABLE `[[dbprefix]]posts` (
[365] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[366] Fix | Delete
`topic` mediumint(8) unsigned NOT NULL DEFAULT '0',
[367] Fix | Delete
`member` mediumint(8) unsigned NOT NULL DEFAULT '0',
[368] Fix | Delete
`created` varchar(16) DEFAULT NULL,
[369] Fix | Delete
`message` text,
[370] Fix | Delete
PRIMARY KEY (`id`)
[371] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[372] Fix | Delete
[373] Fix | Delete
-- --------------------------------------------------------
[374] Fix | Delete
[375] Fix | Delete
--
[376] Fix | Delete
-- Table structure for table `[[dbprefix]]projects`
[377] Fix | Delete
--
[378] Fix | Delete
[379] Fix | Delete
CREATE TABLE `[[dbprefix]]projects` (
[380] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[381] Fix | Delete
`organization` mediumint(8) unsigned NOT NULL DEFAULT '0',
[382] Fix | Delete
`owner` mediumint(8) unsigned NOT NULL DEFAULT '0',
[383] Fix | Delete
`priority` mediumint(8) unsigned NOT NULL DEFAULT '0',
[384] Fix | Delete
`status` mediumint(8) unsigned NOT NULL DEFAULT '0',
[385] Fix | Delete
`name` varchar(155) DEFAULT NULL,
[386] Fix | Delete
`description` text,
[387] Fix | Delete
`url_dev` varchar(255) DEFAULT NULL,
[388] Fix | Delete
`url_prod` varchar(255) DEFAULT NULL,
[389] Fix | Delete
`created` varchar(16) DEFAULT NULL,
[390] Fix | Delete
`modified` varchar(16) DEFAULT NULL,
[391] Fix | Delete
`published` char(1) NOT NULL DEFAULT '',
[392] Fix | Delete
`upload_max` varchar(155) DEFAULT NULL,
[393] Fix | Delete
`phase_set` mediumint(8) unsigned NOT NULL DEFAULT '0',
[394] Fix | Delete
`invoicing` char(1) NOT NULL DEFAULT '',
[395] Fix | Delete
`hourly_rate` float(10,2) NOT NULL DEFAULT '0.00',
[396] Fix | Delete
PRIMARY KEY (`id`)
[397] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[398] Fix | Delete
[399] Fix | Delete
-- --------------------------------------------------------
[400] Fix | Delete
[401] Fix | Delete
--
[402] Fix | Delete
-- Table structure for table `[[dbprefix]]reports`
[403] Fix | Delete
--
[404] Fix | Delete
[405] Fix | Delete
CREATE TABLE `[[dbprefix]]reports` (
[406] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[407] Fix | Delete
`owner` mediumint(8) unsigned NOT NULL DEFAULT '0',
[408] Fix | Delete
`name` varchar(155) DEFAULT NULL,
[409] Fix | Delete
`projects` varchar(255) DEFAULT NULL,
[410] Fix | Delete
`members` varchar(255) DEFAULT NULL,
[411] Fix | Delete
`priorities` varchar(255) DEFAULT NULL,
[412] Fix | Delete
`status` varchar(255) DEFAULT NULL,
[413] Fix | Delete
`date_due_start` varchar(10) DEFAULT NULL,
[414] Fix | Delete
`date_due_end` varchar(10) DEFAULT NULL,
[415] Fix | Delete
`created` varchar(16) DEFAULT NULL,
[416] Fix | Delete
`date_complete_start` varchar(10) DEFAULT NULL,
[417] Fix | Delete
`date_complete_end` varchar(10) DEFAULT NULL,
[418] Fix | Delete
`clients` varchar(255) DEFAULT NULL,
[419] Fix | Delete
PRIMARY KEY (`id`)
[420] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[421] Fix | Delete
[422] Fix | Delete
-- --------------------------------------------------------
[423] Fix | Delete
[424] Fix | Delete
--
[425] Fix | Delete
-- Table structure for table `[[dbprefix]]services`
[426] Fix | Delete
--
[427] Fix | Delete
[428] Fix | Delete
CREATE TABLE `[[dbprefix]]services` (
[429] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[430] Fix | Delete
`name` varchar(155) DEFAULT NULL,
[431] Fix | Delete
`name_print` varchar(155) DEFAULT NULL,
[432] Fix | Delete
`hourly_rate` float(10,2) NOT NULL DEFAULT '0.00',
[433] Fix | Delete
PRIMARY KEY (`id`)
[434] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[435] Fix | Delete
[436] Fix | Delete
-- --------------------------------------------------------
[437] Fix | Delete
[438] Fix | Delete
--
[439] Fix | Delete
-- Table structure for table `[[dbprefix]]sorting`
[440] Fix | Delete
--
[441] Fix | Delete
[442] Fix | Delete
CREATE TABLE `[[dbprefix]]sorting` (
[443] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[444] Fix | Delete
`member` mediumint(8) unsigned NOT NULL DEFAULT '0',
[445] Fix | Delete
`home_projects` varchar(155) DEFAULT NULL,
[446] Fix | Delete
`home_tasks` varchar(155) DEFAULT NULL,
[447] Fix | Delete
`home_discussions` varchar(155) DEFAULT NULL,
[448] Fix | Delete
`home_reports` varchar(155) DEFAULT NULL,
[449] Fix | Delete
`projects` varchar(155) DEFAULT NULL,
[450] Fix | Delete
`organizations` varchar(155) DEFAULT NULL,
[451] Fix | Delete
`project_tasks` varchar(155) DEFAULT NULL,
[452] Fix | Delete
`discussions` varchar(155) DEFAULT NULL,
[453] Fix | Delete
`project_discussions` varchar(155) DEFAULT NULL,
[454] Fix | Delete
`users` varchar(155) DEFAULT NULL,
[455] Fix | Delete
`team` varchar(155) DEFAULT NULL,
[456] Fix | Delete
`tasks` varchar(155) DEFAULT NULL,
[457] Fix | Delete
`report_tasks` varchar(155) DEFAULT NULL,
[458] Fix | Delete
`assignment` varchar(155) DEFAULT NULL,
[459] Fix | Delete
`reports` varchar(155) DEFAULT NULL,
[460] Fix | Delete
`files` varchar(155) DEFAULT NULL,
[461] Fix | Delete
`organization_projects` varchar(155) DEFAULT NULL,
[462] Fix | Delete
`notes` varchar(155) DEFAULT NULL,
[463] Fix | Delete
`calendar` varchar(155) DEFAULT NULL,
[464] Fix | Delete
`phases` varchar(155) DEFAULT NULL,
[465] Fix | Delete
`support_requests` varchar(155) DEFAULT NULL,
[466] Fix | Delete
`subtasks` varchar(155) DEFAULT NULL,
[467] Fix | Delete
`bookmarks` varchar(155) DEFAULT NULL,
[468] Fix | Delete
`invoices` varchar(155) DEFAULT NULL,
[469] Fix | Delete
`newsdesk` varchar(155) DEFAULT NULL,
[470] Fix | Delete
`home_subtasks` varchar(155) DEFAULT NULL,
[471] Fix | Delete
PRIMARY KEY (`id`)
[472] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
[473] Fix | Delete
[474] Fix | Delete
--
[475] Fix | Delete
-- Dumping data for table `[[dbprefix]]sorting`
[476] Fix | Delete
--
[477] Fix | Delete
[478] Fix | Delete
INSERT INTO `[[dbprefix]]sorting` VALUES
[479] Fix | Delete
(1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
[480] Fix | Delete
(2, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
[481] Fix | Delete
[482] Fix | Delete
-- --------------------------------------------------------
[483] Fix | Delete
[484] Fix | Delete
--
[485] Fix | Delete
-- Table structure for table `[[dbprefix]]subtasks`
[486] Fix | Delete
--
[487] Fix | Delete
[488] Fix | Delete
CREATE TABLE `[[dbprefix]]subtasks` (
[489] Fix | Delete
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
[490] Fix | Delete
`task` mediumint(8) unsigned NOT NULL DEFAULT '0',
[491] Fix | Delete
`priority` mediumint(8) unsigned NOT NULL DEFAULT '0',
[492] Fix | Delete
`status` mediumint(8) unsigned NOT NULL DEFAULT '0',
[493] Fix | Delete
`owner` mediumint(8) unsigned NOT NULL DEFAULT '0',
[494] Fix | Delete
`assigned_to` mediumint(8) unsigned NOT NULL DEFAULT '0',
[495] Fix | Delete
`name` varchar(155) DEFAULT NULL,
[496] Fix | Delete
`description` text,
[497] Fix | Delete
`start_date` varchar(10) DEFAULT NULL,
[498] Fix | Delete
`due_date` varchar(10) DEFAULT NULL,
[499] Fix | Delete
12
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function