Gam

??? 123123123123 .....................................................................................................................................??? 123123123123 ..................................................................................................................................... Gam

File manager - Edit - /var/softaculous/collab/collab.sql

Back
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8 /; -- -- Database: `collab31` -- -- -------------------------------------------------------- -- -- Table structure for table `company` -- CREATE TABLE `company` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `company` varchar(255) NOT NULL, `contact` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(64) NOT NULL, `mobile` varchar(64) NOT NULL, `url` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `zip` varchar(16) NOT NULL, `city` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `state` varchar(255) NOT NULL, `desc` text NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `customers_assigned` -- CREATE TABLE `customers_assigned` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `customer` int(10) NOT NULL, `project` int(10) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `ID` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `files` -- CREATE TABLE `files` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', `desc` varchar(255) NOT NULL DEFAULT '', `project` int(10) NOT NULL DEFAULT '0', `milestone` int(10) NOT NULL DEFAULT '0', `user` int(10) NOT NULL DEFAULT '0', `added` varchar(255) NOT NULL DEFAULT '', `datei` varchar(255) NOT NULL DEFAULT '', `type` varchar(255) NOT NULL DEFAULT '', `title` varchar(255) NOT NULL DEFAULT '', `folder` int(10) NOT NULL, `visible` text NOT NULL, PRIMARY KEY (`ID`), KEY `name` (`name`), KEY `datei` (`datei`), KEY `added` (`added`), KEY `project` (`project`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `files_attached` -- CREATE TABLE `files_attached` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `file` int(10) unsigned NOT NULL DEFAULT '0', `message` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `file` (`file`,`message`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `log` -- CREATE TABLE `log` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `user` int(10) NOT NULL DEFAULT '0', `username` varchar(255) NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `type` varchar(255) NOT NULL DEFAULT '', `action` int(1) NOT NULL DEFAULT '0', `project` int(10) NOT NULL DEFAULT '0', `datum` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`ID`), KEY `datum` (`datum`), KEY `type` (`type`), KEY `action` (`action`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `log` -- INSERT INTO `log` VALUES (1, 0, '', '[[admin_username]]', 'user', 1, 0, '[[timestamp]]'); -- -------------------------------------------------------- -- -- Table structure for table `messages` -- CREATE TABLE `messages` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `project` int(10) NOT NULL DEFAULT '0', `title` varchar(255) NOT NULL DEFAULT '', `text` text NOT NULL, `tags` varchar(255) NOT NULL, `posted` varchar(255) NOT NULL DEFAULT '', `user` int(10) NOT NULL DEFAULT '0', `username` varchar(255) NOT NULL DEFAULT '', `replyto` int(11) NOT NULL DEFAULT '0', `milestone` int(10) NOT NULL, PRIMARY KEY (`ID`), KEY `project` (`project`), KEY `user` (`user`), KEY `replyto` (`replyto`), KEY `tags` (`tags`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `messages_assigned` -- CREATE TABLE `messages_assigned` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `user` int(10) NOT NULL, `message` int(10) NOT NULL, PRIMARY KEY (`ID`), KEY `user` (`user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `milestones` -- CREATE TABLE `milestones` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `project` int(10) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `desc` text NOT NULL, `start` varchar(255) NOT NULL DEFAULT '', `end` varchar(255) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `name` (`name`), KEY `end` (`end`), KEY `project` (`project`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `milestones_assigned` -- CREATE TABLE `milestones_assigned` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `user` int(10) NOT NULL DEFAULT '0', `milestone` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `user` (`user`), KEY `milestone` (`milestone`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `projectfolders` -- CREATE TABLE `projectfolders` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `parent` int(10) unsigned NOT NULL DEFAULT '0', `project` int(11) NOT NULL DEFAULT '0', `name` text NOT NULL, `description` varchar(255) NOT NULL, `visible` text NOT NULL, PRIMARY KEY (`ID`), KEY `project` (`project`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `projekte` -- CREATE TABLE `projekte` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', `desc` text NOT NULL, `start` varchar(255) NOT NULL DEFAULT '', `end` varchar(255) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '0', `budget` float NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `projekte_assigned` -- CREATE TABLE `projekte_assigned` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `user` int(10) NOT NULL DEFAULT '0', `projekt` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `user` (`user`), KEY `projekt` (`projekt`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `projects` text NOT NULL, `tasks` text NOT NULL, `milestones` text NOT NULL, `messages` text NOT NULL, `files` text NOT NULL, `chat` text NOT NULL, `timetracker` text NOT NULL, `admin` text NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `roles` -- INSERT INTO `roles` VALUES (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;}'), (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;}'), (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;}'); -- -------------------------------------------------------- -- -- Table structure for table `roles_assigned` -- CREATE TABLE `roles_assigned` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `user` int(10) NOT NULL, `role` int(10) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `roles_assigned` -- INSERT INTO `roles_assigned` VALUES (1, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `settingsKey` varchar(50) NOT NULL, `settingsValue` varchar(50) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ; -- -- Dumping data for table `settings` -- INSERT INTO `settings` VALUES (1, 'name', '[[site_name]]'), (2, 'subtitle', '[[site_desc]]'), (3, 'locale', '[[language]]'), (4, 'timezone', 'Europe/Berlin'), (5, 'dateformat', 'd.m.Y'), (6, 'template', 'standard'), (7, 'mailnotify', '1'), (8, 'mailfrom', '[[admin_email]]'), (9, 'mailfromname', ''), (10, 'mailmethod', 'mail'), (11, 'mailhost', ''), (12, 'mailuser', ''), (13, 'mailpass', ''), (14, 'rssuser', ''), (15, 'rsspass', ''), (16, 'theme', 'standard'), (17, 'filePass', '[[filePass]]'); -- -------------------------------------------------------- -- -- Table structure for table `tasklist` -- CREATE TABLE `tasklist` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `project` int(10) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `desc` text NOT NULL, `start` varchar(255) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '0', `access` tinyint(4) NOT NULL DEFAULT '0', `milestone` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `status` (`status`), KEY `milestone` (`milestone`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tasks` -- CREATE TABLE `tasks` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `start` varchar(255) NOT NULL DEFAULT '', `end` varchar(255) NOT NULL DEFAULT '', `title` varchar(255) NOT NULL DEFAULT '', `text` text NOT NULL, `liste` int(10) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '0', `project` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `liste` (`liste`), KEY `status` (`status`), KEY `end` (`end`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tasks_assigned` -- CREATE TABLE `tasks_assigned` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `user` int(10) NOT NULL DEFAULT '0', `task` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `user` (`user`), KEY `task` (`task`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `timetracker` -- CREATE TABLE `timetracker` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `user` int(10) NOT NULL DEFAULT '0', `project` int(10) NOT NULL DEFAULT '0', `task` int(10) NOT NULL DEFAULT '0', `comment` text NOT NULL, `started` varchar(255) NOT NULL DEFAULT '', `ended` varchar(255) NOT NULL DEFAULT '', `hours` float NOT NULL DEFAULT '0', `pstatus` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), KEY `user` (`user`,`project`,`task`), KEY `started` (`started`), KEY `ended` (`ended`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT '', `email` varchar(255) DEFAULT '', `tel1` varchar(255) DEFAULT NULL, `tel2` varchar(255) DEFAULT NULL, `pass` varchar(255) DEFAULT '', `company` varchar(255) DEFAULT '', `lastlogin` varchar(255) DEFAULT '', `zip` varchar(10) DEFAULT NULL, `gender` char(1) DEFAULT '', `url` varchar(255) DEFAULT '', `adress` varchar(255) DEFAULT '', `adress2` varchar(255) DEFAULT '', `state` varchar(255) DEFAULT '', `country` varchar(255) DEFAULT '', `tags` varchar(255) DEFAULT '', `locale` varchar(6) DEFAULT '', `avatar` varchar(255) DEFAULT '', `rate` varchar(10) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `name` (`name`), KEY `pass` (`pass`), KEY `locale` (`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `user` -- INSERT INTO `user` VALUES (1, '[[admin_username]]', '[[admin_email]]', NULL, NULL, '[[admin_pass]]', '', '', NULL, '', '', '', '', '', '', '', '[[language]]', '', '0'); /!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;