CREATE TABLE IF NOT EXISTS `posts` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) default NULL,
`icon` int(5) default NULL,
`date` varchar(45) default NULL,
`time` varchar(30) default NULL,
`author` varchar(30) default NULL,
`board` int(5) default NULL,
`thread` int(20) default NULL,
`post` text,
`signature` int(5) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `threads` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`icon` int(5) default NULL,
`closed` int(5) default NULL,
`stick` int(5) NOT NULL,
`date` varchar(45) default NULL,
`time` varchar(30) default NULL,
`author` varchar(30) default NULL,
`board` int(5) default NULL,
`views` int(20) default NULL,
`last` int(40) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `forums` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255),
`description` text,
`closed` int(5) default NULL,
`access` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Zrzut danych tabeli `forums`
--
INSERT INTO `forums` (`id`, `name`, `description`, `closed`, `access`) VALUES
(2, 'First forum.', 'This is your first forum.', 0, 0);