관리-도구

편집 파일: taskfreak.sql

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: `taskfreak70` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]_country` -- CREATE TABLE `[[dbprefix]]_country` ( `countryId` char(2) NOT NULL DEFAULT '', `name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`countryId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]_country` -- INSERT INTO `[[dbprefix]]_country` VALUES('AF', 'Afghanistan'); INSERT INTO `[[dbprefix]]_country` VALUES('AL', 'Albania'); INSERT INTO `[[dbprefix]]_country` VALUES('DZ', 'Algeria'); INSERT INTO `[[dbprefix]]_country` VALUES('AS', 'American samoa'); INSERT INTO `[[dbprefix]]_country` VALUES('AD', 'Andorra'); INSERT INTO `[[dbprefix]]_country` VALUES('AO', 'Angola'); INSERT INTO `[[dbprefix]]_country` VALUES('AI', 'Anguilla'); INSERT INTO `[[dbprefix]]_country` VALUES('AQ', 'Antarctica'); INSERT INTO `[[dbprefix]]_country` VALUES('AG', 'Antigua and barbuda'); INSERT INTO `[[dbprefix]]_country` VALUES('AR', 'Argentina'); INSERT INTO `[[dbprefix]]_country` VALUES('AM', 'Armenia'); INSERT INTO `[[dbprefix]]_country` VALUES('AW', 'Aruba'); INSERT INTO `[[dbprefix]]_country` VALUES('AU', 'Australia'); INSERT INTO `[[dbprefix]]_country` VALUES('AT', 'Austria'); INSERT INTO `[[dbprefix]]_country` VALUES('AZ', 'Azerbaijan'); INSERT INTO `[[dbprefix]]_country` VALUES('BS', 'Bahamas'); INSERT INTO `[[dbprefix]]_country` VALUES('BH', 'Bahrain'); INSERT INTO `[[dbprefix]]_country` VALUES('BD', 'Bangladesh'); INSERT INTO `[[dbprefix]]_country` VALUES('BB', 'Barbados'); INSERT INTO `[[dbprefix]]_country` VALUES('BY', 'Belarus'); INSERT INTO `[[dbprefix]]_country` VALUES('BE', 'Belgium'); INSERT INTO `[[dbprefix]]_country` VALUES('BZ', 'Belize'); INSERT INTO `[[dbprefix]]_country` VALUES('BJ', 'Benin'); INSERT INTO `[[dbprefix]]_country` VALUES('BM', 'Bermuda'); INSERT INTO `[[dbprefix]]_country` VALUES('BT', 'Bhutan'); INSERT INTO `[[dbprefix]]_country` VALUES('BO', 'Bolivia'); INSERT INTO `[[dbprefix]]_country` VALUES('BA', 'Bosnia and herzegovina'); INSERT INTO `[[dbprefix]]_country` VALUES('BW', 'Botswana'); INSERT INTO `[[dbprefix]]_country` VALUES('BV', 'Bouvet island'); INSERT INTO `[[dbprefix]]_country` VALUES('BR', 'Brazil'); INSERT INTO `[[dbprefix]]_country` VALUES('IO', 'British indian ocean territory'); INSERT INTO `[[dbprefix]]_country` VALUES('BN', 'Brunei darussalam'); INSERT INTO `[[dbprefix]]_country` VALUES('BG', 'Bulgaria'); INSERT INTO `[[dbprefix]]_country` VALUES('BF', 'Burkina faso'); INSERT INTO `[[dbprefix]]_country` VALUES('BI', 'Burundi'); INSERT INTO `[[dbprefix]]_country` VALUES('KH', 'Cambodia'); INSERT INTO `[[dbprefix]]_country` VALUES('CM', 'Cameroon'); INSERT INTO `[[dbprefix]]_country` VALUES('CA', 'Canada'); INSERT INTO `[[dbprefix]]_country` VALUES('CV', 'Cape verde'); INSERT INTO `[[dbprefix]]_country` VALUES('KY', 'Cayman islands'); INSERT INTO `[[dbprefix]]_country` VALUES('CF', 'Central african republic'); INSERT INTO `[[dbprefix]]_country` VALUES('TD', 'Chad'); INSERT INTO `[[dbprefix]]_country` VALUES('CL', 'Chile'); INSERT INTO `[[dbprefix]]_country` VALUES('CN', 'China'); INSERT INTO `[[dbprefix]]_country` VALUES('CX', 'Christmas island'); INSERT INTO `[[dbprefix]]_country` VALUES('CC', 'Cocos (keeling) islands'); INSERT INTO `[[dbprefix]]_country` VALUES('CO', 'Colombia'); INSERT INTO `[[dbprefix]]_country` VALUES('KM', 'Comoros'); INSERT INTO `[[dbprefix]]_country` VALUES('CG', 'Congo'); INSERT INTO `[[dbprefix]]_country` VALUES('CD', 'Congo'); INSERT INTO `[[dbprefix]]_country` VALUES('CK', 'Cook islands'); INSERT INTO `[[dbprefix]]_country` VALUES('CR', 'Costa rica'); INSERT INTO `[[dbprefix]]_country` VALUES('CI', 'Cote d''ivoire'); INSERT INTO `[[dbprefix]]_country` VALUES('HR', 'Croatia'); INSERT INTO `[[dbprefix]]_country` VALUES('CU', 'Cuba'); INSERT INTO `[[dbprefix]]_country` VALUES('CY', 'Cyprus'); INSERT INTO `[[dbprefix]]_country` VALUES('CZ', 'Czech republic'); INSERT INTO `[[dbprefix]]_country` VALUES('DK', 'Denmark'); INSERT INTO `[[dbprefix]]_country` VALUES('DJ', 'Djibouti'); INSERT INTO `[[dbprefix]]_country` VALUES('DM', 'Dominica'); INSERT INTO `[[dbprefix]]_country` VALUES('DO', 'Dominican republic'); INSERT INTO `[[dbprefix]]_country` VALUES('TP', 'East timor'); INSERT INTO `[[dbprefix]]_country` VALUES('EC', 'Ecuador'); INSERT INTO `[[dbprefix]]_country` VALUES('EG', 'Egypt'); INSERT INTO `[[dbprefix]]_country` VALUES('SV', 'El salvador'); INSERT INTO `[[dbprefix]]_country` VALUES('GQ', 'Equatorial guinea'); INSERT INTO `[[dbprefix]]_country` VALUES('ER', 'Eritrea'); INSERT INTO `[[dbprefix]]_country` VALUES('EE', 'Estonia'); INSERT INTO `[[dbprefix]]_country` VALUES('ET', 'Ethiopia'); INSERT INTO `[[dbprefix]]_country` VALUES('FK', 'Falkland islands (malvinas)'); INSERT INTO `[[dbprefix]]_country` VALUES('FO', 'Faroe islands'); INSERT INTO `[[dbprefix]]_country` VALUES('FJ', 'Fiji'); INSERT INTO `[[dbprefix]]_country` VALUES('FI', 'Finland'); INSERT INTO `[[dbprefix]]_country` VALUES('FR', 'France'); INSERT INTO `[[dbprefix]]_country` VALUES('GF', 'French guiana'); INSERT INTO `[[dbprefix]]_country` VALUES('PF', 'French polynesia'); INSERT INTO `[[dbprefix]]_country` VALUES('TF', 'French southern territories'); INSERT INTO `[[dbprefix]]_country` VALUES('GA', 'Gabon'); INSERT INTO `[[dbprefix]]_country` VALUES('GM', 'Gambia'); INSERT INTO `[[dbprefix]]_country` VALUES('GE', 'Georgia'); INSERT INTO `[[dbprefix]]_country` VALUES('DE', 'Germany'); INSERT INTO `[[dbprefix]]_country` VALUES('GH', 'Ghana'); INSERT INTO `[[dbprefix]]_country` VALUES('GI', 'Gibraltar'); INSERT INTO `[[dbprefix]]_country` VALUES('GR', 'Greece'); INSERT INTO `[[dbprefix]]_country` VALUES('GL', 'Greenland'); INSERT INTO `[[dbprefix]]_country` VALUES('GD', 'Grenada'); INSERT INTO `[[dbprefix]]_country` VALUES('GP', 'Guadeloupe'); INSERT INTO `[[dbprefix]]_country` VALUES('GU', 'Guam'); INSERT INTO `[[dbprefix]]_country` VALUES('GT', 'Guatemala'); INSERT INTO `[[dbprefix]]_country` VALUES('GN', 'Guinea'); INSERT INTO `[[dbprefix]]_country` VALUES('GW', 'Guinea-bissau'); INSERT INTO `[[dbprefix]]_country` VALUES('GY', 'Guyana'); INSERT INTO `[[dbprefix]]_country` VALUES('HT', 'Haiti'); INSERT INTO `[[dbprefix]]_country` VALUES('HM', 'Heard and mcdonald islands'); INSERT INTO `[[dbprefix]]_country` VALUES('VA', 'Holy see (vatican city state)'); INSERT INTO `[[dbprefix]]_country` VALUES('HN', 'Honduras'); INSERT INTO `[[dbprefix]]_country` VALUES('HK', 'Hong kong'); INSERT INTO `[[dbprefix]]_country` VALUES('HU', 'Hungary'); INSERT INTO `[[dbprefix]]_country` VALUES('IS', 'Iceland'); INSERT INTO `[[dbprefix]]_country` VALUES('IN', 'India'); INSERT INTO `[[dbprefix]]_country` VALUES('ID', 'Indonesia'); INSERT INTO `[[dbprefix]]_country` VALUES('IR', 'Iran, islamic republic of'); INSERT INTO `[[dbprefix]]_country` VALUES('IQ', 'Iraq'); INSERT INTO `[[dbprefix]]_country` VALUES('IE', 'Ireland'); INSERT INTO `[[dbprefix]]_country` VALUES('IL', 'Israel'); INSERT INTO `[[dbprefix]]_country` VALUES('IT', 'Italy'); INSERT INTO `[[dbprefix]]_country` VALUES('JM', 'Jamaica'); INSERT INTO `[[dbprefix]]_country` VALUES('JP', 'Japan'); INSERT INTO `[[dbprefix]]_country` VALUES('JO', 'Jordan'); INSERT INTO `[[dbprefix]]_country` VALUES('KZ', 'Kazakstan'); INSERT INTO `[[dbprefix]]_country` VALUES('KE', 'Kenya'); INSERT INTO `[[dbprefix]]_country` VALUES('KI', 'Kiribati'); INSERT INTO `[[dbprefix]]_country` VALUES('KP', 'Korea, democratic'); INSERT INTO `[[dbprefix]]_country` VALUES('KR', 'Korea, republic of'); INSERT INTO `[[dbprefix]]_country` VALUES('KW', 'Kuwait'); INSERT INTO `[[dbprefix]]_country` VALUES('KG', 'Kyrgyzstan'); INSERT INTO `[[dbprefix]]_country` VALUES('LA', 'Laos'); INSERT INTO `[[dbprefix]]_country` VALUES('LV', 'Latvia'); INSERT INTO `[[dbprefix]]_country` VALUES('LB', 'Lebanon'); INSERT INTO `[[dbprefix]]_country` VALUES('LS', 'Lesotho'); INSERT INTO `[[dbprefix]]_country` VALUES('LR', 'Liberia'); INSERT INTO `[[dbprefix]]_country` VALUES('LY', 'Libyan arab jamahiriya'); INSERT INTO `[[dbprefix]]_country` VALUES('LI', 'Liechtenstein'); INSERT INTO `[[dbprefix]]_country` VALUES('LT', 'Lithuania'); INSERT INTO `[[dbprefix]]_country` VALUES('LU', 'Luxembourg'); INSERT INTO `[[dbprefix]]_country` VALUES('MO', 'Macau'); INSERT INTO `[[dbprefix]]_country` VALUES('MK', 'Macedonia'); INSERT INTO `[[dbprefix]]_country` VALUES('MG', 'Madagascar'); INSERT INTO `[[dbprefix]]_country` VALUES('MW', 'Malawi'); INSERT INTO `[[dbprefix]]_country` VALUES('MY', 'Malaysia'); INSERT INTO `[[dbprefix]]_country` VALUES('MV', 'Maldives'); INSERT INTO `[[dbprefix]]_country` VALUES('ML', 'Mali'); INSERT INTO `[[dbprefix]]_country` VALUES('MT', 'Malta'); INSERT INTO `[[dbprefix]]_country` VALUES('MH', 'Marshall islands'); INSERT INTO `[[dbprefix]]_country` VALUES('MQ', 'Martinique'); INSERT INTO `[[dbprefix]]_country` VALUES('MR', 'Mauritania'); INSERT INTO `[[dbprefix]]_country` VALUES('MU', 'Mauritius'); INSERT INTO `[[dbprefix]]_country` VALUES('YT', 'Mayotte'); INSERT INTO `[[dbprefix]]_country` VALUES('MX', 'Mexico'); INSERT INTO `[[dbprefix]]_country` VALUES('FM', 'Micronesia'); INSERT INTO `[[dbprefix]]_country` VALUES('MD', 'Moldova, republic of'); INSERT INTO `[[dbprefix]]_country` VALUES('MC', 'Monaco'); INSERT INTO `[[dbprefix]]_country` VALUES('MN', 'Mongolia'); INSERT INTO `[[dbprefix]]_country` VALUES('MS', 'Montserrat'); INSERT INTO `[[dbprefix]]_country` VALUES('MA', 'Morocco'); INSERT INTO `[[dbprefix]]_country` VALUES('MZ', 'Mozambique'); INSERT INTO `[[dbprefix]]_country` VALUES('MM', 'Myanmar'); INSERT INTO `[[dbprefix]]_country` VALUES('NA', 'Namibia'); INSERT INTO `[[dbprefix]]_country` VALUES('NR', 'Nauru'); INSERT INTO `[[dbprefix]]_country` VALUES('NP', 'Nepal'); INSERT INTO `[[dbprefix]]_country` VALUES('NL', 'Netherlands'); INSERT INTO `[[dbprefix]]_country` VALUES('AN', 'Netherlands antilles'); INSERT INTO `[[dbprefix]]_country` VALUES('NC', 'New caledonia'); INSERT INTO `[[dbprefix]]_country` VALUES('NZ', 'New zealand'); INSERT INTO `[[dbprefix]]_country` VALUES('NI', 'Nicaragua'); INSERT INTO `[[dbprefix]]_country` VALUES('NE', 'Niger'); INSERT INTO `[[dbprefix]]_country` VALUES('NG', 'Nigeria'); INSERT INTO `[[dbprefix]]_country` VALUES('NU', 'Niue'); INSERT INTO `[[dbprefix]]_country` VALUES('NF', 'Norfolk island'); INSERT INTO `[[dbprefix]]_country` VALUES('MP', 'Northern mariana islands'); INSERT INTO `[[dbprefix]]_country` VALUES('NO', 'Norway'); INSERT INTO `[[dbprefix]]_country` VALUES('OM', 'Oman'); INSERT INTO `[[dbprefix]]_country` VALUES('PK', 'Pakistan'); INSERT INTO `[[dbprefix]]_country` VALUES('PW', 'Palau'); INSERT INTO `[[dbprefix]]_country` VALUES('PS', 'Palestinian territory'); INSERT INTO `[[dbprefix]]_country` VALUES('PA', 'Panama'); INSERT INTO `[[dbprefix]]_country` VALUES('PG', 'Papua new guinea'); INSERT INTO `[[dbprefix]]_country` VALUES('PY', 'Paraguay'); INSERT INTO `[[dbprefix]]_country` VALUES('PE', 'Peru'); INSERT INTO `[[dbprefix]]_country` VALUES('PH', 'Philippines'); INSERT INTO `[[dbprefix]]_country` VALUES('PN', 'Pitcairn'); INSERT INTO `[[dbprefix]]_country` VALUES('PL', 'Poland'); INSERT INTO `[[dbprefix]]_country` VALUES('PT', 'Portugal'); INSERT INTO `[[dbprefix]]_country` VALUES('PR', 'Puerto rico'); INSERT INTO `[[dbprefix]]_country` VALUES('QA', 'Qatar'); INSERT INTO `[[dbprefix]]_country` VALUES('RE', 'Reunion'); INSERT INTO `[[dbprefix]]_country` VALUES('RO', 'Romania'); INSERT INTO `[[dbprefix]]_country` VALUES('RU', 'Russian federation'); INSERT INTO `[[dbprefix]]_country` VALUES('RW', 'Rwanda'); INSERT INTO `[[dbprefix]]_country` VALUES('SH', 'Saint helena'); INSERT INTO `[[dbprefix]]_country` VALUES('KN', 'Saint kitts and nevis'); INSERT INTO `[[dbprefix]]_country` VALUES('LC', 'Saint lucia'); INSERT INTO `[[dbprefix]]_country` VALUES('PM', 'Saint pierre and miquelon'); INSERT INTO `[[dbprefix]]_country` VALUES('VC', 'Saint vincent and the grenadines'); INSERT INTO `[[dbprefix]]_country` VALUES('WS', 'Samoa'); INSERT INTO `[[dbprefix]]_country` VALUES('SM', 'San marino'); INSERT INTO `[[dbprefix]]_country` VALUES('ST', 'Sao tome and principe'); INSERT INTO `[[dbprefix]]_country` VALUES('SA', 'Saudi arabia'); INSERT INTO `[[dbprefix]]_country` VALUES('SN', 'Senegal'); INSERT INTO `[[dbprefix]]_country` VALUES('SC', 'Seychelles'); INSERT INTO `[[dbprefix]]_country` VALUES('SL', 'Sierra leone'); INSERT INTO `[[dbprefix]]_country` VALUES('SG', 'Singapore'); INSERT INTO `[[dbprefix]]_country` VALUES('SK', 'Slovakia'); INSERT INTO `[[dbprefix]]_country` VALUES('SI', 'Slovenia'); INSERT INTO `[[dbprefix]]_country` VALUES('SB', 'Solomon islands'); INSERT INTO `[[dbprefix]]_country` VALUES('SO', 'Somalia'); INSERT INTO `[[dbprefix]]_country` VALUES('ZA', 'South africa'); INSERT INTO `[[dbprefix]]_country` VALUES('GS', 'South georgia'); INSERT INTO `[[dbprefix]]_country` VALUES('ES', 'Spain'); INSERT INTO `[[dbprefix]]_country` VALUES('LK', 'Sri lanka'); INSERT INTO `[[dbprefix]]_country` VALUES('SD', 'Sudan'); INSERT INTO `[[dbprefix]]_country` VALUES('SR', 'Suriname'); INSERT INTO `[[dbprefix]]_country` VALUES('SJ', 'Svalbard and jan mayen'); INSERT INTO `[[dbprefix]]_country` VALUES('SZ', 'Swaziland'); INSERT INTO `[[dbprefix]]_country` VALUES('SE', 'Sweden'); INSERT INTO `[[dbprefix]]_country` VALUES('CH', 'Switzerland'); INSERT INTO `[[dbprefix]]_country` VALUES('SY', 'Syrian arab republic'); INSERT INTO `[[dbprefix]]_country` VALUES('TW', 'Taiwan, province of china'); INSERT INTO `[[dbprefix]]_country` VALUES('TJ', 'Tajikistan'); INSERT INTO `[[dbprefix]]_country` VALUES('TZ', 'Tanzania, united republic of'); INSERT INTO `[[dbprefix]]_country` VALUES('TH', 'Thailand'); INSERT INTO `[[dbprefix]]_country` VALUES('TG', 'Togo'); INSERT INTO `[[dbprefix]]_country` VALUES('TK', 'Tokelau'); INSERT INTO `[[dbprefix]]_country` VALUES('TO', 'Tonga'); INSERT INTO `[[dbprefix]]_country` VALUES('TT', 'Trinidad and tobago'); INSERT INTO `[[dbprefix]]_country` VALUES('TN', 'Tunisia'); INSERT INTO `[[dbprefix]]_country` VALUES('TR', 'Turkey'); INSERT INTO `[[dbprefix]]_country` VALUES('TM', 'Turkmenistan'); INSERT INTO `[[dbprefix]]_country` VALUES('TC', 'Turks and caicos islands'); INSERT INTO `[[dbprefix]]_country` VALUES('TV', 'Tuvalu'); INSERT INTO `[[dbprefix]]_country` VALUES('UG', 'Uganda'); INSERT INTO `[[dbprefix]]_country` VALUES('UA', 'Ukraine'); INSERT INTO `[[dbprefix]]_country` VALUES('AE', 'United Arab Emirates'); INSERT INTO `[[dbprefix]]_country` VALUES('GB', 'United Kingdom'); INSERT INTO `[[dbprefix]]_country` VALUES('US', 'United States'); INSERT INTO `[[dbprefix]]_country` VALUES('UM', 'United States minor islands'); INSERT INTO `[[dbprefix]]_country` VALUES('UY', 'Uruguay'); INSERT INTO `[[dbprefix]]_country` VALUES('UZ', 'Uzbekistan'); INSERT INTO `[[dbprefix]]_country` VALUES('VU', 'Vanuatu'); INSERT INTO `[[dbprefix]]_country` VALUES('VE', 'Venezuela'); INSERT INTO `[[dbprefix]]_country` VALUES('VN', 'Viet nam'); INSERT INTO `[[dbprefix]]_country` VALUES('VG', 'Virgin islands, british'); INSERT INTO `[[dbprefix]]_country` VALUES('VI', 'Virgin islands, u.s.'); INSERT INTO `[[dbprefix]]_country` VALUES('WF', 'Wallis and futuna'); INSERT INTO `[[dbprefix]]_country` VALUES('EH', 'Western sahara'); INSERT INTO `[[dbprefix]]_country` VALUES('YE', 'Yemen'); INSERT INTO `[[dbprefix]]_country` VALUES('YU', 'Yugoslavia'); INSERT INTO `[[dbprefix]]_country` VALUES('ZM', 'Zambia'); INSERT INTO `[[dbprefix]]_country` VALUES('ZW', 'Zimbabwe'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]_item` -- CREATE TABLE `[[dbprefix]]_item` ( `itemId` int(10) unsigned NOT NULL AUTO_INCREMENT, `projectId` mediumint(8) unsigned NOT NULL DEFAULT '0', `itemParentId` int(10) unsigned NOT NULL DEFAULT '0', `priority` tinyint(3) unsigned NOT NULL DEFAULT '0', `context` varchar(80) NOT NULL DEFAULT '', `title` varchar(255) NOT NULL DEFAULT '', `description` text NOT NULL, `deadlineDate` date NOT NULL DEFAULT '0000-00-00', `expectedDuration` smallint(5) unsigned NOT NULL DEFAULT '0', `showInCalendar` tinyint(1) unsigned NOT NULL DEFAULT '0', `showPrivate` tinyint(1) unsigned NOT NULL DEFAULT '0', `memberId` mediumint(8) unsigned NOT NULL DEFAULT '0', `authorId` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemId`), KEY `projectId` (`projectId`), KEY `memberId` (`memberId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `[[dbprefix]]_item` -- INSERT INTO `[[dbprefix]]_item` VALUES(1, 1, 0, 3, '1', 'Congratulations! This is your first task', 'First of all, read the README.txt if you haven''t done it yet.\r\n\r\nLots of informations in there.', '9999-00-00', 0, 0, 0, 1, 1); INSERT INTO `[[dbprefix]]_item` VALUES(2, 1, 0, 5, '1', 'How to create a user', 'To create a new user, go to menu <i>manage > users</i> \r\n\r\nthen click on the <img src="skins/redfreak/images/b_new.png" /> button.', '9999-00-00', 0, 0, 2, 1, 1); INSERT INTO `[[dbprefix]]_item` VALUES(3, 1, 0, 7, '4', 'Send some feedback', 'To send some feedback to the author, go to\r\n<a href="http://forum.taskfreak.com" target="_blank">http://forum.taskfreak.com</a>\r\n\r\nPlease remember you can donate by paypal on\r\n<a href="http://www.taskfreak.com" target="_blank">http://www.taskfreak.com</a>', '9999-00-00', 0, 0, 1, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]_itemComment` -- CREATE TABLE `[[dbprefix]]_itemComment` ( `itemCommentId` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `itemId` int(10) unsigned NOT NULL DEFAULT '0', `memberId` mediumint(8) unsigned NOT NULL DEFAULT '0', `postDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `body` text NOT NULL, `lastChangeDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`itemCommentId`), KEY `taskId` (`itemId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]_itemFile` -- CREATE TABLE `[[dbprefix]]_itemFile` ( `itemFileId` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `itemId` int(10) unsigned NOT NULL DEFAULT '0', `memberId` mediumint(8) unsigned NOT NULL DEFAULT '0', `fileTitle` varchar(200) NOT NULL DEFAULT '', `filename` varchar(127) NOT NULL DEFAULT '', `filetype` varchar(30) NOT NULL DEFAULT '', `filesize` bigint(20) NOT NULL DEFAULT '0', `postDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `lastChangeDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `fileTags` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`itemFileId`), KEY `taskId` (`itemId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]_itemStatus` -- CREATE TABLE `[[dbprefix]]_itemStatus` ( `itemStatusId` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `itemId` int(10) unsigned NOT NULL DEFAULT '0', `statusDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `statusKey` tinyint(3) unsigned NOT NULL DEFAULT '0', `memberId` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemStatusId`), KEY `itemId` (`itemId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `[[dbprefix]]_itemStatus` -- INSERT INTO `[[dbprefix]]_itemStatus` VALUES(1, 1, '2006-06-01 00:00:00', 0, 1); INSERT INTO `[[dbprefix]]_itemStatus` VALUES(2, 2, '2006-06-01 00:00:00', 0, 1); INSERT INTO `[[dbprefix]]_itemStatus` VALUES(3, 3, '2006-06-01 00:00:00', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]_member` -- CREATE TABLE `[[dbprefix]]_member` ( `memberId` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(120) NOT NULL DEFAULT '', `title` varchar(20) NOT NULL DEFAULT '', `firstName` varchar(50) NOT NULL DEFAULT '', `middleName` varchar(50) NOT NULL DEFAULT '', `lastName` varchar(50) NOT NULL DEFAULT '', `zipCode` varchar(20) NOT NULL DEFAULT '', `city` varchar(60) NOT NULL DEFAULT '', `stateCode` char(2) NOT NULL DEFAULT '', `countryId` char(2) NOT NULL DEFAULT '', `phone` varchar(30) NOT NULL DEFAULT '', `mobile` varchar(30) NOT NULL DEFAULT '', `fax` varchar(30) NOT NULL DEFAULT '', `username` varchar(20) NOT NULL DEFAULT '', `password` varchar(60) NOT NULL DEFAULT '', `salt` varchar(8) NOT NULL DEFAULT '', `autoLogin` tinyint(1) NOT NULL DEFAULT '0', `timeZone` smallint(6) NOT NULL DEFAULT '0', `expirationDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `lastLoginDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `lastLoginAddress` varchar(60) NOT NULL DEFAULT '', `creationDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `lastChangeDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `visits` mediumint(8) unsigned NOT NULL DEFAULT '0', `badAccess` tinyint(3) unsigned NOT NULL DEFAULT '0', `level` tinyint(3) unsigned NOT NULL DEFAULT '0', `activation` varchar(16) NOT NULL DEFAULT '', `authorId` mediumint(8) unsigned NOT NULL DEFAULT '0', `enabled` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`memberId`), KEY `username` (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]_member` -- INSERT INTO `[[dbprefix]]_member` VALUES(1, '[[admin_email]]', 'Mr', 'System', '', 'Administrator', '', '', '', 'FR', '', '', '', '[[admin_username]]', '[[admin_pass]]', '12345678', 0, 19800, '0000-00-00 00:00:00', '[[regtime]]', '[[domhost]]', '2006-06-01 00:00:00', '[[regtime]]', 0, 0, 4, '', 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]_memberProject` -- CREATE TABLE `[[dbprefix]]_memberProject` ( `memberId` mediumint(8) unsigned NOT NULL DEFAULT '0', `projectId` mediumint(8) unsigned NOT NULL DEFAULT '0', `position` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`memberId`,`projectId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]_memberProject` -- INSERT INTO `[[dbprefix]]_memberProject` VALUES(1, 1, 5); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]_project` -- CREATE TABLE `[[dbprefix]]_project` ( `projectId` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(120) NOT NULL DEFAULT '', `description` text NOT NULL, PRIMARY KEY (`projectId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]_project` -- INSERT INTO `[[dbprefix]]_project` VALUES(1, 'Your first project', ''); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]_projectStatus` -- CREATE TABLE `[[dbprefix]]_projectStatus` ( `projectStatusId` int(10) unsigned NOT NULL AUTO_INCREMENT, `projectId` mediumint(10) unsigned NOT NULL DEFAULT '0', `statusDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `statusKey` tinyint(3) unsigned NOT NULL DEFAULT '0', `memberId` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`projectStatusId`), KEY `projectId` (`projectId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]_projectStatus` -- INSERT INTO `[[dbprefix]]_projectStatus` VALUES(1, 1, '2006-06-01 00:00:00', 0, 1); /*!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 */;