📄 mmei8.sql
字号:
# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# 主机: localhost
# 生成日期: 2006 年 02 月 17 日 15:16
# 服务器版本: 4.1.12
# PHP 版本: 4.3.9
#
# 数据库 : `mmei8`
#
# --------------------------------------------------------
#
# 表的结构 `admin`
#
CREATE TABLE `zhai` (
`id` int(12) NOT NULL auto_increment,
`userid` varchar(100) default NULL,
`title` varchar(100) NOT NULL default '',
`fromurl` varchar(255) default NULL,
`intro` text,
`tags` varchar(255) default NULL,
`rank` int(12) NOT NULL default '0',
`posttime` int(14) NOT NULL default '0',
`reads` int(12) NOT NULL default '0',
`ispub` smallint(1) NOT NULL default '0',
`isread` smallint(1) NOT NULL default '0',
`siteid` int(10) default '0',
`incount` int(10) default '0',
`typeid` int(10) NOT NULL default '0',
`tok` int(1) NOT NULL default '0',
`outcount` int(14) NOT NULL default '0',
`groupid` varchar(225) default NULL,
`picname` varchar(225) default NULL,
`kz` varchar(10) NOT NULL default 'n',
`isgood` int(12) NOT NULL default '0',
`huandeng` int(10) default '0',
`htm` varchar(10) default 'n',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
CREATE TABLE `userpic` (
`id` int(12) NOT NULL auto_increment,
`userid` varchar(50) NOT NULL default '',
`pic` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
CREATE TABLE `admin` (
`user` varchar(225) NOT NULL default '',
`pwd` varchar(225) NOT NULL default '',
`webname` varchar(255) NOT NULL default '',
`pagesize` int(10) NOT NULL default '0',
`email` varchar(255) default NULL,
`smtp` varchar(255) default NULL,
`mb` text NOT NULL,
`mb_table_bg` varchar(225) NOT NULL default '',
`mb_td_bg` varchar(225) NOT NULL default '',
`zxx` int(10) NOT NULL default '0',
`zd_tj` int(10) NOT NULL default '0',
`zd_tj_time` int(10) NOT NULL default '0',
`zd_pm` int(10) NOT NULL default '0',
`zd_pm_time` int(10) NOT NULL default '0',
`pb` varchar(225) default NULL,
`pb_zi` varchar(225) default NULL,
`pb_url` varchar(225) default NULL,
`u_web_size` varchar(225) NOT NULL default '10',
`u_txt_size` varchar(225) NOT NULL default '50',
`tjupdate` datetime NOT NULL default '0000-00-00 00:00:00',
`pmupdate` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# 导出表中的数据 `admin`
#
INSERT INTO `admin` VALUES ('wenwen', '821029', '第一娱乐排行榜', 29, '22499225@qq.com', '', '', '#cccccc', '#ffffff', 1, 1, 1, 1, 10, '', '色情|鸡吧｜自摸', 'cool168.com|.sex.com|.fuck.com｜pictop.com', '10', '50', '2006-02-16 22:37:07', '2005-10-27 16:19:42');
# --------------------------------------------------------
#
# 表的结构 `bookmark`
#
CREATE TABLE `bookmark` (
`id` int(14) NOT NULL auto_increment,
`userid` varchar(60) default NULL,
`url` varchar(255) default NULL,
`bookmark` varchar(255) default NULL,
`remark` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
#
# 导出表中的数据 `bookmark`
#
# --------------------------------------------------------
#
# 表的结构 `dingyue`
#
CREATE TABLE `dingyue` (
`id` int(12) NOT NULL auto_increment,
`userid` varchar(225) NOT NULL default '',
`suserid` varchar(225) default NULL,
`tags` varchar(225) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=187 ;
#
# 导出表中的数据 `dingyue`
#
# --------------------------------------------------------
#
# 表的结构 `friend`
#
# --------------------------------------------------------
#
# 表的结构 `groupuser`
#
#
# 导出表中的数据 `groupuser`
#
# --------------------------------------------------------
#
# 表的结构 `grp`
#
#
# 导出表中的数据 `grp`
#
# --------------------------------------------------------
#
# 表的结构 `ip`
#
CREATE TABLE `ip` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(255) NOT NULL default '',
`user` varchar(165) default NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
#
# 导出表中的数据 `ip`
#
# --------------------------------------------------------
#
# 表的结构 `links`
#
CREATE TABLE `links` (
`id` bigint(40) NOT NULL auto_increment,
`linkname` varchar(100) NOT NULL default '',
`linkurl` varchar(255) NOT NULL default '',
`incount` int(12) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
#
# 导出表中的数据 `links`
#
INSERT INTO `links` VALUES (6, '妹妹网摘', 'http://www.mmei8.com', 0);
# --------------------------------------------------------
#
# 表的结构 `myuser`
#
CREATE TABLE `myuser` (
`id` bigint(40) NOT NULL auto_increment,
`userid` varchar(50) NOT NULL default '',
`username` varchar(100) default NULL,
`psw` varchar(100) NOT NULL default '',
`email` varchar(100) default NULL,
`regtime` int(14) NOT NULL default '0',
`logontime` int(14) NOT NULL default '0',
`zhainum` int(10) NOT NULL default '0',
`state` varchar(100) default NULL,
`usertype` varchar(50) NOT NULL default 'simple',
PRIMARY KEY (`id`),
UNIQUE KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=758 ;
#
# 导出表中的数据 `myuser`
#
INSERT INTO `myuser` VALUES (1, 'wenwen', 'tianwen', '103621', '22499225@qq.com', 1129606385, 1129606385, 182, NULL, 'siteadmin');
# --------------------------------------------------------
#
# 表的结构 `site`
#
#
# 导出表中的数据 `site`
#
# --------------------------------------------------------
#
# 表的结构 `tags`
#
CREATE TABLE `tags` (
`id` int(12) NOT NULL auto_increment,
`userid` varchar(100) default NULL,
`tag` varchar(255) NOT NULL default '',
`num` int(12) NOT NULL default '0',
`typeid` int(12) default '0',
`ispass` varchar(13) NOT NULL default 'n',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=163 ;
#
# 导出表中的数据 `tags`
#
# --------------------------------------------------------
#
# 表的结构 `type`
#
CREATE TABLE `type` (
`id` int(10) NOT NULL auto_increment,
`typename` varchar(100) NOT NULL default '',
`tjupdate` datetime NOT NULL default '0000-00-00 00:00:00',
`pmupdate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
#
# 导出表中的数据 `type`
#
INSERT INTO `type` VALUES (4, '精彩图片', '2005-11-06 00:00:00', '2006-01-11 13:07:38');
INSERT INTO `type` VALUES (5, '影视音乐', '2005-10-31 00:00:00', '2005-11-01 14:42:15');
INSERT INTO `type` VALUES (6, '娱乐八卦', '2005-10-31 00:00:00', '2006-01-11 13:02:48');
INSERT INTO `type` VALUES (7, '幽默搞笑', '2005-10-30 00:00:00', '2005-11-01 14:42:26');
INSERT INTO `type` VALUES (8, '体育军事', '2005-10-30 00:00:00', '2005-11-01 14:42:29');
INSERT INTO `type` VALUES (9, '两性情感', '2005-10-30 00:00:00', '2005-11-01 14:42:35');
INSERT INTO `type` VALUES (10, '社会百态', '2005-10-30 00:00:00', '2005-11-01 14:42:39');
INSERT INTO `type` VALUES (11, ' 综合其他', '2005-10-30 00:00:00', '2005-11-01 14:42:43');
INSERT INTO `type` VALUES (13, '游戏动漫', '2005-10-30 00:00:00', '2005-11-01 14:42:49');
INSERT INTO `type` VALUES (15, '驴行掠影', '2005-10-30 00:00:00', '2005-11-01 14:42:58');
# --------------------------------------------------------
#
# 表的结构 `visit`
#
CREATE TABLE `visit` (
`id` bigint(40) NOT NULL auto_increment,
`zhaiid` int(14) default '0',
`userid` varchar(100) default NULL,
`visitip` varchar(50) default NULL,
`visiturl` varchar(255) default NULL,
`visittime` int(14) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
#
# 导出表中的数据 `visit`
#
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -