SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS `nicaw_boards` (
`board_id` int(11) NOT NULL AUTO_INCREMENT,
`board_name` varchar(64) NOT NULL,
`board_description` longtext NOT NULL,
`board_position` int(11) NOT NULL DEFAULT '1',
`board_can_thread` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`board_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `nicaw_posts` (
`post_id` int(11) NOT NULL AUTO_INCREMENT,
`post_board_id` int(11) NOT NULL,
`post_thread_id` int(11) DEFAULT NULL,
`post_is_thread` tinyint(1) DEFAULT NULL,
`post_last_post` int(10) NOT NULL,
`post_is_locked` tinyint(1) DEFAULT NULL,
`post_is_sticky` tinyint(1) NOT NULL,
`post_title` varchar(64) DEFAULT NULL,
`post_content` longtext NOT NULL,
`post_date` int(11) NOT NULL,
`post_author_id` int(11) NOT NULL,
`post_author_name` varchar(100) NOT NULL,
`post_author_level` int(11) NOT NULL,
`post_author_magic_level` int(11) NOT NULL,
`post_author_vocation` int(11) NOT NULL,
PRIMARY KEY (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `nicaw_settings` (
`name` varchar(64) NOT NULL,
`value` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `nicaw_settings` (`name`, `value`) VALUES
('reply_max_length', '1000'),
('wait_between_posts', '15'),
('thread_min_length', '10'),
('thread_max_length', '2000'),
('thread_title_min_length', '3'),
('thread_title_max_length', '40'),
('reply_min_length', '2'),
('author_info_box_align', 'left'),
('show_statistics_box', 'yes');
ALTER TABLE `nicaw_accounts` ADD `last_post` INT( 10 ) NOT NULL