php

File Content: `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 */;
File Content: taskfreak.sql

File Content: `taskfreak.sql`
