Edit File by line
• /home/barbar84/www/wp-conte.../plugins/sujqvwi/ShExBy/shex_roo.../var/softacul.../collab
• File: collab.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: `collab31`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `company`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `company` (
[20] Fix | Delete
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`company` varchar(255) NOT NULL,
[22] Fix | Delete
`contact` varchar(255) NOT NULL,
[23] Fix | Delete
`email` varchar(255) NOT NULL,
[24] Fix | Delete
`phone` varchar(64) NOT NULL,
[25] Fix | Delete
`mobile` varchar(64) NOT NULL,
[26] Fix | Delete
`url` varchar(255) NOT NULL,
[27] Fix | Delete
`address` varchar(255) NOT NULL,
[28] Fix | Delete
`zip` varchar(16) NOT NULL,
[29] Fix | Delete
`city` varchar(255) NOT NULL,
[30] Fix | Delete
`country` varchar(255) NOT NULL,
[31] Fix | Delete
`state` varchar(255) NOT NULL,
[32] Fix | Delete
`desc` text NOT NULL,
[33] Fix | Delete
PRIMARY KEY (`ID`)
[34] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[35] Fix | Delete
[36] Fix | Delete
-- --------------------------------------------------------
[37] Fix | Delete
[38] Fix | Delete
--
[39] Fix | Delete
-- Table structure for table `customers_assigned`
[40] Fix | Delete
--
[41] Fix | Delete
[42] Fix | Delete
CREATE TABLE `customers_assigned` (
[43] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[44] Fix | Delete
`customer` int(10) NOT NULL,
[45] Fix | Delete
`project` int(10) NOT NULL,
[46] Fix | Delete
PRIMARY KEY (`ID`),
[47] Fix | Delete
UNIQUE KEY `ID` (`ID`)
[48] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[49] Fix | Delete
[50] Fix | Delete
-- --------------------------------------------------------
[51] Fix | Delete
[52] Fix | Delete
--
[53] Fix | Delete
-- Table structure for table `files`
[54] Fix | Delete
--
[55] Fix | Delete
[56] Fix | Delete
CREATE TABLE `files` (
[57] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[58] Fix | Delete
`name` varchar(255) NOT NULL DEFAULT '',
[59] Fix | Delete
`desc` varchar(255) NOT NULL DEFAULT '',
[60] Fix | Delete
`project` int(10) NOT NULL DEFAULT '0',
[61] Fix | Delete
`milestone` int(10) NOT NULL DEFAULT '0',
[62] Fix | Delete
`user` int(10) NOT NULL DEFAULT '0',
[63] Fix | Delete
`added` varchar(255) NOT NULL DEFAULT '',
[64] Fix | Delete
`datei` varchar(255) NOT NULL DEFAULT '',
[65] Fix | Delete
`type` varchar(255) NOT NULL DEFAULT '',
[66] Fix | Delete
`title` varchar(255) NOT NULL DEFAULT '',
[67] Fix | Delete
`folder` int(10) NOT NULL,
[68] Fix | Delete
`visible` text NOT NULL,
[69] Fix | Delete
PRIMARY KEY (`ID`),
[70] Fix | Delete
KEY `name` (`name`),
[71] Fix | Delete
KEY `datei` (`datei`),
[72] Fix | Delete
KEY `added` (`added`),
[73] Fix | Delete
KEY `project` (`project`)
[74] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[75] Fix | Delete
[76] Fix | Delete
-- --------------------------------------------------------
[77] Fix | Delete
[78] Fix | Delete
--
[79] Fix | Delete
-- Table structure for table `files_attached`
[80] Fix | Delete
--
[81] Fix | Delete
[82] Fix | Delete
CREATE TABLE `files_attached` (
[83] Fix | Delete
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
[84] Fix | Delete
`file` int(10) unsigned NOT NULL DEFAULT '0',
[85] Fix | Delete
`message` int(10) unsigned NOT NULL DEFAULT '0',
[86] Fix | Delete
PRIMARY KEY (`ID`),
[87] Fix | Delete
KEY `file` (`file`,`message`)
[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 `log`
[94] Fix | Delete
--
[95] Fix | Delete
[96] Fix | Delete
CREATE TABLE `log` (
[97] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[98] Fix | Delete
`user` int(10) NOT NULL DEFAULT '0',
[99] Fix | Delete
`username` varchar(255) NOT NULL DEFAULT '',
[100] Fix | Delete
`name` varchar(255) NOT NULL DEFAULT '',
[101] Fix | Delete
`type` varchar(255) NOT NULL DEFAULT '',
[102] Fix | Delete
`action` int(1) NOT NULL DEFAULT '0',
[103] Fix | Delete
`project` int(10) NOT NULL DEFAULT '0',
[104] Fix | Delete
`datum` varchar(255) NOT NULL DEFAULT '',
[105] Fix | Delete
PRIMARY KEY (`ID`),
[106] Fix | Delete
KEY `datum` (`datum`),
[107] Fix | Delete
KEY `type` (`type`),
[108] Fix | Delete
KEY `action` (`action`)
[109] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[110] Fix | Delete
[111] Fix | Delete
--
[112] Fix | Delete
-- Dumping data for table `log`
[113] Fix | Delete
--
[114] Fix | Delete
[115] Fix | Delete
INSERT INTO `log` VALUES
[116] Fix | Delete
(1, 0, '', '[[admin_username]]', 'user', 1, 0, '[[timestamp]]');
[117] Fix | Delete
[118] Fix | Delete
-- --------------------------------------------------------
[119] Fix | Delete
[120] Fix | Delete
--
[121] Fix | Delete
-- Table structure for table `messages`
[122] Fix | Delete
--
[123] Fix | Delete
[124] Fix | Delete
CREATE TABLE `messages` (
[125] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[126] Fix | Delete
`project` int(10) NOT NULL DEFAULT '0',
[127] Fix | Delete
`title` varchar(255) NOT NULL DEFAULT '',
[128] Fix | Delete
`text` text NOT NULL,
[129] Fix | Delete
`tags` varchar(255) NOT NULL,
[130] Fix | Delete
`posted` varchar(255) NOT NULL DEFAULT '',
[131] Fix | Delete
`user` int(10) NOT NULL DEFAULT '0',
[132] Fix | Delete
`username` varchar(255) NOT NULL DEFAULT '',
[133] Fix | Delete
`replyto` int(11) NOT NULL DEFAULT '0',
[134] Fix | Delete
`milestone` int(10) NOT NULL,
[135] Fix | Delete
PRIMARY KEY (`ID`),
[136] Fix | Delete
KEY `project` (`project`),
[137] Fix | Delete
KEY `user` (`user`),
[138] Fix | Delete
KEY `replyto` (`replyto`),
[139] Fix | Delete
KEY `tags` (`tags`)
[140] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[141] Fix | Delete
[142] Fix | Delete
-- --------------------------------------------------------
[143] Fix | Delete
[144] Fix | Delete
--
[145] Fix | Delete
-- Table structure for table `messages_assigned`
[146] Fix | Delete
--
[147] Fix | Delete
[148] Fix | Delete
CREATE TABLE `messages_assigned` (
[149] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[150] Fix | Delete
`user` int(10) NOT NULL,
[151] Fix | Delete
`message` int(10) NOT NULL,
[152] Fix | Delete
PRIMARY KEY (`ID`),
[153] Fix | Delete
KEY `user` (`user`)
[154] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[155] Fix | Delete
[156] Fix | Delete
-- --------------------------------------------------------
[157] Fix | Delete
[158] Fix | Delete
--
[159] Fix | Delete
-- Table structure for table `milestones`
[160] Fix | Delete
--
[161] Fix | Delete
[162] Fix | Delete
CREATE TABLE `milestones` (
[163] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[164] Fix | Delete
`project` int(10) NOT NULL DEFAULT '0',
[165] Fix | Delete
`name` varchar(255) NOT NULL DEFAULT '',
[166] Fix | Delete
`desc` text NOT NULL,
[167] Fix | Delete
`start` varchar(255) NOT NULL DEFAULT '',
[168] Fix | Delete
`end` varchar(255) NOT NULL DEFAULT '',
[169] Fix | Delete
`status` tinyint(1) NOT NULL DEFAULT '0',
[170] Fix | Delete
PRIMARY KEY (`ID`),
[171] Fix | Delete
KEY `name` (`name`),
[172] Fix | Delete
KEY `end` (`end`),
[173] Fix | Delete
KEY `project` (`project`)
[174] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[175] Fix | Delete
[176] Fix | Delete
-- --------------------------------------------------------
[177] Fix | Delete
[178] Fix | Delete
--
[179] Fix | Delete
-- Table structure for table `milestones_assigned`
[180] Fix | Delete
--
[181] Fix | Delete
[182] Fix | Delete
CREATE TABLE `milestones_assigned` (
[183] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[184] Fix | Delete
`user` int(10) NOT NULL DEFAULT '0',
[185] Fix | Delete
`milestone` int(10) NOT NULL DEFAULT '0',
[186] Fix | Delete
PRIMARY KEY (`ID`),
[187] Fix | Delete
KEY `user` (`user`),
[188] Fix | Delete
KEY `milestone` (`milestone`)
[189] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[190] Fix | Delete
[191] Fix | Delete
-- --------------------------------------------------------
[192] Fix | Delete
[193] Fix | Delete
--
[194] Fix | Delete
-- Table structure for table `projectfolders`
[195] Fix | Delete
--
[196] Fix | Delete
[197] Fix | Delete
CREATE TABLE `projectfolders` (
[198] Fix | Delete
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
[199] Fix | Delete
`parent` int(10) unsigned NOT NULL DEFAULT '0',
[200] Fix | Delete
`project` int(11) NOT NULL DEFAULT '0',
[201] Fix | Delete
`name` text NOT NULL,
[202] Fix | Delete
`description` varchar(255) NOT NULL,
[203] Fix | Delete
`visible` text NOT NULL,
[204] Fix | Delete
PRIMARY KEY (`ID`),
[205] Fix | Delete
KEY `project` (`project`)
[206] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[207] Fix | Delete
[208] Fix | Delete
-- --------------------------------------------------------
[209] Fix | Delete
[210] Fix | Delete
--
[211] Fix | Delete
-- Table structure for table `projekte`
[212] Fix | Delete
--
[213] Fix | Delete
[214] Fix | Delete
CREATE TABLE `projekte` (
[215] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[216] Fix | Delete
`name` varchar(255) NOT NULL DEFAULT '',
[217] Fix | Delete
`desc` text NOT NULL,
[218] Fix | Delete
`start` varchar(255) NOT NULL DEFAULT '',
[219] Fix | Delete
`end` varchar(255) NOT NULL DEFAULT '',
[220] Fix | Delete
`status` tinyint(1) NOT NULL DEFAULT '0',
[221] Fix | Delete
`budget` float NOT NULL DEFAULT '0',
[222] Fix | Delete
PRIMARY KEY (`ID`),
[223] Fix | Delete
KEY `status` (`status`)
[224] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[225] Fix | Delete
[226] Fix | Delete
-- --------------------------------------------------------
[227] Fix | Delete
[228] Fix | Delete
--
[229] Fix | Delete
-- Table structure for table `projekte_assigned`
[230] Fix | Delete
--
[231] Fix | Delete
[232] Fix | Delete
CREATE TABLE `projekte_assigned` (
[233] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[234] Fix | Delete
`user` int(10) NOT NULL DEFAULT '0',
[235] Fix | Delete
`projekt` int(10) NOT NULL DEFAULT '0',
[236] Fix | Delete
PRIMARY KEY (`ID`),
[237] Fix | Delete
KEY `user` (`user`),
[238] Fix | Delete
KEY `projekt` (`projekt`)
[239] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[240] Fix | Delete
[241] Fix | Delete
-- --------------------------------------------------------
[242] Fix | Delete
[243] Fix | Delete
--
[244] Fix | Delete
-- Table structure for table `roles`
[245] Fix | Delete
--
[246] Fix | Delete
[247] Fix | Delete
CREATE TABLE `roles` (
[248] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[249] Fix | Delete
`name` varchar(255) NOT NULL,
[250] Fix | Delete
`projects` text NOT NULL,
[251] Fix | Delete
`tasks` text NOT NULL,
[252] Fix | Delete
`milestones` text NOT NULL,
[253] Fix | Delete
`messages` text NOT NULL,
[254] Fix | Delete
`files` text NOT NULL,
[255] Fix | Delete
`chat` text NOT NULL,
[256] Fix | Delete
`timetracker` text NOT NULL,
[257] Fix | Delete
`admin` text NOT NULL,
[258] Fix | Delete
PRIMARY KEY (`ID`)
[259] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
[260] Fix | Delete
[261] Fix | Delete
--
[262] Fix | Delete
-- Dumping data for table `roles`
[263] Fix | Delete
--
[264] Fix | Delete
[265] Fix | Delete
INSERT INTO `roles` VALUES
[266] Fix | Delete
(1, 'Admin', 'a:5:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:1;s:5:"close";i:1;s:4:"view";i:1;}', 'a:5:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:1;s:5:"close";i:1;s:4:"view";i:1;}', 'a:5:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:1;s:5:"close";i:1;s:4:"view";i:1;}', 'a:5:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:1;s:5:"close";i:1;s:4:"view";i:1;}', 'a:4:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:1;s:4:"view";i:1;}', 'a:1:{s:3:"add";i:1;}', 'a:5:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:1;s:4:"read";i:1;s:4:"view";i:1;}', 'a:1:{s:3:"add";i:1;}'),
[267] Fix | Delete
(2, 'User', 'a:5:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:0;s:5:"close";i:0;s:4:"view";i:1;}', 'a:5:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:0;s:5:"close";i:1;s:4:"view";i:1;}', 'a:5:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:1;s:5:"close";i:1;s:4:"view";i:1;}', 'a:5:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:1;s:5:"close";i:1;s:4:"view";i:1;}', 'a:4:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:1;s:4:"view";i:1;}', 'a:1:{s:3:"add";i:1;}', 'a:5:{s:3:"add";i:1;s:4:"edit";i:1;s:3:"del";i:1;s:4:"read";i:0;s:4:"view";i:1;}', 'a:1:{s:3:"add";i:0;}'),
[268] Fix | Delete
(3, 'Client', 'a:5:{s:3:"add";i:0;s:4:"edit";i:0;s:3:"del";i:0;s:5:"close";i:0;s:4:"view";i:0;}', 'a:5:{s:3:"add";i:0;s:4:"edit";i:0;s:3:"del";i:0;s:5:"close";i:0;s:4:"view";i:1;}', 'a:5:{s:3:"add";i:0;s:4:"edit";i:0;s:3:"del";i:0;s:5:"close";i:0;s:4:"view";i:0;}', 'a:5:{s:3:"add";i:0;s:4:"edit";i:0;s:3:"del";i:0;s:5:"close";i:0;s:4:"view";i:0;}', 'a:4:{s:3:"add";i:0;s:4:"edit";i:0;s:3:"del";i:0;s:4:"view";i:1;}', 'a:1:{s:3:"add";i:0;}', 'a:5:{s:3:"add";i:0;s:4:"edit";i:0;s:3:"del";i:0;s:4:"read";i:0;s:4:"view";i:0;}', 'a:1:{s:3:"add";i:0;}');
[269] Fix | Delete
[270] Fix | Delete
-- --------------------------------------------------------
[271] Fix | Delete
[272] Fix | Delete
--
[273] Fix | Delete
-- Table structure for table `roles_assigned`
[274] Fix | Delete
--
[275] Fix | Delete
[276] Fix | Delete
CREATE TABLE `roles_assigned` (
[277] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[278] Fix | Delete
`user` int(10) NOT NULL,
[279] Fix | Delete
`role` int(10) NOT NULL,
[280] Fix | Delete
PRIMARY KEY (`ID`)
[281] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[282] Fix | Delete
[283] Fix | Delete
--
[284] Fix | Delete
-- Dumping data for table `roles_assigned`
[285] Fix | Delete
--
[286] Fix | Delete
[287] Fix | Delete
INSERT INTO `roles_assigned` VALUES
[288] Fix | Delete
(1, 1, 1);
[289] Fix | Delete
[290] Fix | Delete
-- --------------------------------------------------------
[291] Fix | Delete
[292] Fix | Delete
--
[293] Fix | Delete
-- Table structure for table `settings`
[294] Fix | Delete
--
[295] Fix | Delete
[296] Fix | Delete
CREATE TABLE `settings` (
[297] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[298] Fix | Delete
`settingsKey` varchar(50) NOT NULL,
[299] Fix | Delete
`settingsValue` varchar(50) NOT NULL,
[300] Fix | Delete
PRIMARY KEY (`ID`)
[301] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
[302] Fix | Delete
[303] Fix | Delete
--
[304] Fix | Delete
-- Dumping data for table `settings`
[305] Fix | Delete
--
[306] Fix | Delete
[307] Fix | Delete
INSERT INTO `settings` VALUES
[308] Fix | Delete
(1, 'name', '[[site_name]]'),
[309] Fix | Delete
(2, 'subtitle', '[[site_desc]]'),
[310] Fix | Delete
(3, 'locale', '[[language]]'),
[311] Fix | Delete
(4, 'timezone', 'Europe/Berlin'),
[312] Fix | Delete
(5, 'dateformat', 'd.m.Y'),
[313] Fix | Delete
(6, 'template', 'standard'),
[314] Fix | Delete
(7, 'mailnotify', '1'),
[315] Fix | Delete
(8, 'mailfrom', '[[admin_email]]'),
[316] Fix | Delete
(9, 'mailfromname', ''),
[317] Fix | Delete
(10, 'mailmethod', 'mail'),
[318] Fix | Delete
(11, 'mailhost', ''),
[319] Fix | Delete
(12, 'mailuser', ''),
[320] Fix | Delete
(13, 'mailpass', ''),
[321] Fix | Delete
(14, 'rssuser', ''),
[322] Fix | Delete
(15, 'rsspass', ''),
[323] Fix | Delete
(16, 'theme', 'standard'),
[324] Fix | Delete
(17, 'filePass', '[[filePass]]');
[325] Fix | Delete
[326] Fix | Delete
-- --------------------------------------------------------
[327] Fix | Delete
[328] Fix | Delete
--
[329] Fix | Delete
-- Table structure for table `tasklist`
[330] Fix | Delete
--
[331] Fix | Delete
[332] Fix | Delete
CREATE TABLE `tasklist` (
[333] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[334] Fix | Delete
`project` int(10) NOT NULL DEFAULT '0',
[335] Fix | Delete
`name` varchar(255) NOT NULL DEFAULT '',
[336] Fix | Delete
`desc` text NOT NULL,
[337] Fix | Delete
`start` varchar(255) NOT NULL DEFAULT '',
[338] Fix | Delete
`status` tinyint(1) NOT NULL DEFAULT '0',
[339] Fix | Delete
`access` tinyint(4) NOT NULL DEFAULT '0',
[340] Fix | Delete
`milestone` int(10) NOT NULL DEFAULT '0',
[341] Fix | Delete
PRIMARY KEY (`ID`),
[342] Fix | Delete
KEY `status` (`status`),
[343] Fix | Delete
KEY `milestone` (`milestone`)
[344] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[345] Fix | Delete
[346] Fix | Delete
-- --------------------------------------------------------
[347] Fix | Delete
[348] Fix | Delete
--
[349] Fix | Delete
-- Table structure for table `tasks`
[350] Fix | Delete
--
[351] Fix | Delete
[352] Fix | Delete
CREATE TABLE `tasks` (
[353] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[354] Fix | Delete
`start` varchar(255) NOT NULL DEFAULT '',
[355] Fix | Delete
`end` varchar(255) NOT NULL DEFAULT '',
[356] Fix | Delete
`title` varchar(255) NOT NULL DEFAULT '',
[357] Fix | Delete
`text` text NOT NULL,
[358] Fix | Delete
`liste` int(10) NOT NULL DEFAULT '0',
[359] Fix | Delete
`status` tinyint(1) NOT NULL DEFAULT '0',
[360] Fix | Delete
`project` int(10) NOT NULL DEFAULT '0',
[361] Fix | Delete
PRIMARY KEY (`ID`),
[362] Fix | Delete
KEY `liste` (`liste`),
[363] Fix | Delete
KEY `status` (`status`),
[364] Fix | Delete
KEY `end` (`end`)
[365] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[366] Fix | Delete
[367] Fix | Delete
-- --------------------------------------------------------
[368] Fix | Delete
[369] Fix | Delete
--
[370] Fix | Delete
-- Table structure for table `tasks_assigned`
[371] Fix | Delete
--
[372] Fix | Delete
[373] Fix | Delete
CREATE TABLE `tasks_assigned` (
[374] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[375] Fix | Delete
`user` int(10) NOT NULL DEFAULT '0',
[376] Fix | Delete
`task` int(10) NOT NULL DEFAULT '0',
[377] Fix | Delete
PRIMARY KEY (`ID`),
[378] Fix | Delete
KEY `user` (`user`),
[379] Fix | Delete
KEY `task` (`task`)
[380] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[381] Fix | Delete
[382] Fix | Delete
-- --------------------------------------------------------
[383] Fix | Delete
[384] Fix | Delete
--
[385] Fix | Delete
-- Table structure for table `timetracker`
[386] Fix | Delete
--
[387] Fix | Delete
[388] Fix | Delete
CREATE TABLE `timetracker` (
[389] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[390] Fix | Delete
`user` int(10) NOT NULL DEFAULT '0',
[391] Fix | Delete
`project` int(10) NOT NULL DEFAULT '0',
[392] Fix | Delete
`task` int(10) NOT NULL DEFAULT '0',
[393] Fix | Delete
`comment` text NOT NULL,
[394] Fix | Delete
`started` varchar(255) NOT NULL DEFAULT '',
[395] Fix | Delete
`ended` varchar(255) NOT NULL DEFAULT '',
[396] Fix | Delete
`hours` float NOT NULL DEFAULT '0',
[397] Fix | Delete
`pstatus` tinyint(1) NOT NULL DEFAULT '0',
[398] Fix | Delete
PRIMARY KEY (`ID`),
[399] Fix | Delete
KEY `user` (`user`,`project`,`task`),
[400] Fix | Delete
KEY `started` (`started`),
[401] Fix | Delete
KEY `ended` (`ended`)
[402] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[403] Fix | Delete
[404] Fix | Delete
-- --------------------------------------------------------
[405] Fix | Delete
[406] Fix | Delete
--
[407] Fix | Delete
-- Table structure for table `user`
[408] Fix | Delete
--
[409] Fix | Delete
[410] Fix | Delete
CREATE TABLE `user` (
[411] Fix | Delete
`ID` int(10) NOT NULL AUTO_INCREMENT,
[412] Fix | Delete
`name` varchar(255) DEFAULT '',
[413] Fix | Delete
`email` varchar(255) DEFAULT '',
[414] Fix | Delete
`tel1` varchar(255) DEFAULT NULL,
[415] Fix | Delete
`tel2` varchar(255) DEFAULT NULL,
[416] Fix | Delete
`pass` varchar(255) DEFAULT '',
[417] Fix | Delete
`company` varchar(255) DEFAULT '',
[418] Fix | Delete
`lastlogin` varchar(255) DEFAULT '',
[419] Fix | Delete
`zip` varchar(10) DEFAULT NULL,
[420] Fix | Delete
`gender` char(1) DEFAULT '',
[421] Fix | Delete
`url` varchar(255) DEFAULT '',
[422] Fix | Delete
`adress` varchar(255) DEFAULT '',
[423] Fix | Delete
`adress2` varchar(255) DEFAULT '',
[424] Fix | Delete
`state` varchar(255) DEFAULT '',
[425] Fix | Delete
`country` varchar(255) DEFAULT '',
[426] Fix | Delete
`tags` varchar(255) DEFAULT '',
[427] Fix | Delete
`locale` varchar(6) DEFAULT '',
[428] Fix | Delete
`avatar` varchar(255) DEFAULT '',
[429] Fix | Delete
`rate` varchar(10) DEFAULT NULL,
[430] Fix | Delete
PRIMARY KEY (`ID`),
[431] Fix | Delete
UNIQUE KEY `name` (`name`),
[432] Fix | Delete
KEY `pass` (`pass`),
[433] Fix | Delete
KEY `locale` (`locale`)
[434] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[435] Fix | Delete
[436] Fix | Delete
--
[437] Fix | Delete
-- Dumping data for table `user`
[438] Fix | Delete
--
[439] Fix | Delete
[440] Fix | Delete
INSERT INTO `user` VALUES
[441] Fix | Delete
(1, '[[admin_username]]', '[[admin_email]]', NULL, NULL, '[[admin_pass]]', '', '', NULL, '', '', '', '', '', '', '', '[[language]]', '', '0');
[442] Fix | Delete
[443] Fix | Delete
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
[444] Fix | Delete
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
[445] Fix | Delete
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
[446] Fix | Delete
[447] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function