54# hao123789 - --
- -- 表的结构 `uchome_app_mimi`
- --
- CREATE TABLE IF NOT EXISTS `uchome_app_mimi` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(255) NOT NULL DEFAULT '',
- `typeid` smallint(4) NOT NULL DEFAULT '0',
- `uid` int(11) NOT NULL DEFAULT '0',
- `username` varchar(50) NOT NULL DEFAULT '',
- `content` text,
- `tag` varchar(250) DEFAULT NULL,
- `dateline` int(11) NOT NULL DEFAULT '0',
- `view_count` int(11) NOT NULL DEFAULT '0',
- `reply_count` int(11) NOT NULL DEFAULT '0',
- `status` smallint(1) NOT NULL DEFAULT '0',
- `msg` text,
- `anonymous` smallint(1) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `typeid` (`typeid`)
- ) TYPE=MyISAM ;
- -- --------------------------------------------------------
- --
- -- 表的结构 `uchome_app_mimi_reply`
- --
- CREATE TABLE IF NOT EXISTS `uchome_app_mimi_reply` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `mimi_id` int(11) NOT NULL DEFAULT '0',
- `content` text NOT NULL,
- `uid` int(11) NOT NULL DEFAULT '0',
- `username` varchar(50) NOT NULL DEFAULT '',
- `dateline` int(11) NOT NULL DEFAULT '0',
- `anonymous` tinyint(1) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `mimi_id` (`mimi_id`)
- ) TYPE=MyISAM ;
复制代码 试试这个sql吧... |