rendered paste bodyCREATE TABLE `projects` (
`project_id` int(11) NOT NULL auto_increment,
`project_name` varchar(255) collate latin1_general_ci NOT NULL,
`project_path` varchar(255) collate latin1_general_ci NOT NULL,
`project_admins` tinytext collate latin1_general_ci NOT NULL,
`project_users` tinytext collate latin1_general_ci NOT NULL,
`project_language` varchar(12) collate latin1_general_ci NOT NULL,
`project_description` mediumtext collate latin1_general_ci NOT NULL,
`project_added` int(11) NOT NULL,
`project_worktime` int(11) NOT NULL default '0',
PRIMARY KEY (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `projects`
--
INSERT INTO `projects` VALUES (1, 'name', 'c:\\\\project\\\\', '1,2,3', '1,2,3', 'PHP', 'This is a description', 2007, 0);
INSERT INTO `projects` VALUES (2, 'name', 'c:\\\\project\\\\', '1,2,3', '1,2,3', 'PHP', 'This is a description', 2007, 0);