Edit File by line

[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