localprojects/Change-By-Us — Issue #10: broken models.sql
Author: cheluskin
Created: 2011-12-10 16:27:49+00:00
State: open

CREATE TABLE `project_need` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(10) DEFAULT NULL,
`subtype` varchar(10) DEFAULT NULL,
`request` varchar(64) DEFAULT NULL,
`quantity` int(11) DEFAULT NULL,
`description` text,
`project_id` int(11) NOT NULL,
`date` date DEFAULT NULL,
`time` varchar(32) DEFAULT NULL,
`duration` varchar(64) DEFAULT NULL,
`address` varchar(256) DEFAULT NULL,
`event_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `project_id` (`project_id`),
KEY `event_id` (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

need string

`subtype` varchar(10) DEFAULT NULL,