CREATE TABLE IF NOT EXISTS `projects` (
`idproject` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`date` datetime NOT NULL,
`status` enum('new','active','closed') NOT NULL,
`priority` enum('low','medium','high') NOT NULL,
PRIMARY KEY (`idproject`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20
CREATE TABLE IF NOT EXISTS `projects` (
`idpro