CREATE TABLE IF NOT EXISTS `qs_CommitteeDocument` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `committeeId` int(10) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `fileName` varchar(255) NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `committeeId` (`committeeId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `apw_Document`
--
ALTER TABLE `qs_CommitteeDocument`
  ADD CONSTRAINT `qs_Document_Committee` FOREIGN KEY (`committeeId`) REFERENCES `qs_Committee` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;



INSERT INTO  `qs_DPageItemType` (
`id` ,
`type` ,
`title` ,
`sorter`
)
VALUES (
NULL ,  'Committee\\',  'Committees',  '430'
);
