RENAME TABLE `bs_News` TO `bs_Association`;

CREATE TABLE IF NOT EXISTS `bs_News` (
`id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `metaDescription` text NOT NULL,
  `metaKeywords` text NOT NULL,
  `date` date NOT NULL,
  `introduction` text NOT NULL,
  `content` mediumtext NOT NULL,
  `searchContent` text NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `linkType` enum('none','url','cms','file') NOT NULL,
  `idPage` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `file` varchar(255) DEFAULT NULL,
  `featured` enum('n','y') NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


ALTER TABLE `bs_News`
 ADD PRIMARY KEY (`id`), ADD KEY `type` (`date`);


ALTER TABLE `bs_News`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;


INSERT INTO `bs_zz_DPageItemType` (`type`, `title`, `sorter`) VALUES
('Association_', 'Associations', 375),
('Search_Association_', 'Search Associations', 380),
('News_', 'News List', 460),
('Search_News_', 'Search News', 470);