Файл: newspaper/sql.sql
Строк: 25
CREATE TABLE IF NOT EXISTS `newspaper_kat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `newspaper_paper` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kat` int(11) NOT NULL, `name` varchar(255) NOT NULL, `text` mediumtext NOT NULL, `us` int(11) NOT NULL, `time` int(11) NOT NULL, `kolvo` int(11) NOT NULL DEFAULT '0', `scrin` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `newspaper_zaklad` ( `id` int(11) NOT NULL AUTO_INCREMENT, `paper` int(11) NOT NULL, `us` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;