All pastes #348531 Raw Edit

Someone

public text v1 · immutable
·published 2007-02-10 05:55 UTC
rendered paste body
CREATE 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);