|
CODE CREATE TABLE `kasseler_wb` (
`pid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`uid` int(11) default '0',
`uname` varchar(60) default NULL,
`title` varchar(60) NOT NULL default '',
`hometext` varchar(250) default NULL,
`bodytext` text,
`cost` int(11) default NULL,
`comment` text,
`email` varchar(60) NOT NULL default '',
`context` text,
`adress` text,
`img` varchar(255) default NULL,
`img2` varchar(255) default NULL,
`img3` varchar(255) default NULL,
`img4` varchar(255) default NULL,
`img5` varchar(255) default NULL,
`img6` varchar(255) default NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`todate` int(11) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`status` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`pid`),
KEY `uid` (`uid`),
KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE `kasseler_wb_categories` (
`cid` int(11) NOT NULL auto_increment,
`russian` varchar(60) default NULL,
`description` text NOT NULL,
`language` varchar(60) default NULL,
`postes` int(11) default '0',
`pid` int(11) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE `kasseler_wb_coments` (
`nid` int(11) NOT NULL auto_increment,
`unames` varchar(50) default NULL,
`nemail` varchar(50) default NULL,
`pid` int(11) default NULL,
`cid` int(11) NOT NULL,
`summa` varchar(50) default NULL,
`coments` text,
`comdata` datetime default '0000-00-00 00:00:00',
`dop` int(11) default '0',
PRIMARY KEY (`nid`),
KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
вот моя база, естественно без категорий
|