价值5000元码农网整站资源采集展示销售平台源码

CREATE TABLE IF NOT EXISTS `{dbprefix}space_access` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id', `uid` int(10) unsigned NOT NULL COMMENT '访客uid', `username` varchar(100) NOT NULL COMMENT '访客名', `spaceid` int(10) unsigned NOT NULL COMMENT '被访空间', `inputtime` int(10) unsigned NOT NULL COMMENT '访问时间', `content` text COMMENT '访问信息', PRIMARY KEY (`id`), UNIQUE KEY `my` (`uid`,`spaceid`,`inputtime`), KEY `uid` (`uid`,`username`,`spaceid`,`inputtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='空间访问统计表'; CREATE TABLE IF NOT EXISTS `{dbprefix}space_domain` ( `uid` int(10) NOT NULL, `domain` varchar(50) NOT NULL, UNIQUE KEY `uid` (`uid`), KEY `domain` (`domain`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='空间二级域名'; CREATE TABLE IF NOT EXISTS `{dbprefix}space_category_init` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `gid` mediumint(8) unsigned NOT NULL COMMENT '会员组id', `pid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '上级id', `pids` varchar(255) DEFAULT NULL COMMENT '所有上级id', `type` tinyint(1) unsigned NOT NULL COMMENT '0外链，1模型，2单页', `name` varchar(30) NOT NULL COMMENT '栏目名称', `link` varchar(255) DEFAULT NULL COMMENT '链接地址', `showid` tinyint(1) unsigned NOT NULL COMMENT '0不显示,1顶部,2底部,3都显示', `modelid` smallint(5) unsigned NOT NULL COMMENT '模型id', `child` tinyint(1) unsigned DEFAULT '0' COMMENT '是否有下级', `childids` text DEFAULT NULL COMMENT '下级所有id', PRIMARY KEY (`id`), KEY `uid` (`gid`), KEY `pid` (`pid`), KEY `showid` (`showid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='空间栏目表初始化表'; CREATE TABLE IF NOT EXISTS `{dbprefix}space_flag` ( `flag` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '标记id', `uid` mediumint(8) unsigned NOT NULL COMMENT '作者uid', KEY `flag` (`flag`,`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='标记表'; CREATE TABLE IF NOT EXISTS `{dbprefix}space_category` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `uid` mediumint(8) unsigned NOT NULL COMMENT '会员uid', `pid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '上级id', `pids` varchar(255) DEFAULT NULL COMMENT '所有上级id', `type` tinyint(1) unsigned NOT NULL COMMENT '0外链，1模型，2单页', `name` varchar(30) NOT NULL COMMENT '栏目名称', `link` varchar(255) DEFAULT NULL COMMENT '链接地址', `body` text DEFAULT NULL COMMENT '单页内容', `showid` tinyint(1) unsigned NOT NULL COMMENT '0不显示,1顶部,2底部,3都显示', `modelid` smallint(5) unsigned NOT NULL COMMENT '模型id', `child` tinyint(1) unsigned DEFAULT NULL DEFAULT '0' COMMENT '是否有下级', `childids` text DEFAULT NULL COMMENT '下级所有id', `title` varchar(255) NOT NULL COMMENT 'SEO标题', `keywords` varchar(255) NOT NULL COMMENT '关键字', `description` text NOT NULL COMMENT '描述信息', `displayorder` tinyint(3) DEFAULT NULL DEFAULT '0' COMMENT '排序值', PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `pid` (`pid`), KEY `showid` (`showid`), KEY `displayorder` (`displayorder`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='栏目表'; CREATE TABLE IF NOT EXISTS `{dbprefix}space_model` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL COMMENT '名称', `table` varchar(50) NOT NULL COMMENT '表名', `setting` text NOT NULL COMMENT '配置信息', PRIMARY KEY (`id`), UNIQUE KEY `table` (`table`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='会员模型表'; CREATE TABLE IF NOT EXISTS `{dbprefix}space` ( `uid` mediumint(8) unsigned NOT NULL, `name` varchar(255) NOT NULL COMMENT '空间名称', `logo` varchar(255) DEFAULT NULL COMMENT '空间logo', `style` varchar(30) DEFAULT NULL COMMENT '空间风格', `title` varchar(255) DEFAULT NULL COMMENT 'SEO标题', `keywords` varchar(255) DEFAULT NULL COMMENT 'SEO关键字', `description` text DEFAULT NULL COMMENT 'SEO描述', `introduction` text DEFAULT NULL COMMENT '空间简介', `code` text DEFAULT NULL COMMENT '第三方代码', `footer` text DEFAULT NULL COMMENT '底部信息', `hits` int(10) unsigned NOT NULL COMMENT '点击量', `status` tinyint(1) unsigned NOT NULL COMMENT '审核状态', `regtime` int(10) unsigned NOT NULL COMMENT '注册时间', `displayorder` tinyint(3) DEFAULT NULL DEFAULT '0' COMMENT '排序值', PRIMARY KEY (`uid`), KEY `hits` (`hits`), KEY `status` (`status`), KEY `displayorder` (`displayorder`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='会员空间表'; CREATE TABLE IF NOT EXISTS `{dbprefix}sns_comment` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `fid` int(10) unsigned NOT NULL COMMENT '动态表id', `uid` int(10) unsigned NOT NULL COMMENT '评论人id', `username` varchar(50) NOT NULL COMMENT '评论人', `comment` text NOT NULL COMMENT '评论内容', `inputip` varchar(50) NOT NULL COMMENT '录入ip', `inputtime` int(10) unsigned NOT NULL COMMENT '录入评论时间', PRIMARY KEY (`id`), KEY `fid` (`fid`,`uid`,`inputtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='动态评论'; CREATE TABLE IF NOT EXISTS `{dbprefix}sns_config` ( `uid` int(10) unsigned NOT NULL COMMENT '会员uid', `show_all` tinyint(1) unsigned DEFAULT NULL COMMENT '是否全部人可查看我的动态', `show_follow` tinyint(1) unsigned DEFAULT NULL COMMENT '是否允许关注我的人访问', `show_fans` tinyint(1) unsigned DEFAULT NULL COMMENT '是否允许我的粉丝访问', UNIQUE KEY `uid` (`uid`), KEY `show_all` (`show_all`), KEY `show_fans` (`show_fans`), KEY `show_follow` (`show_follow`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='会员互动配置'; CREATE TABLE IF NOT EXISTS `{dbprefix}sns_feed` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '动态ID', `uid` int(10) unsigned NOT NULL COMMENT '产生动态的用户UID', `username` varchar(100) NOT NULL COMMENT '会员名称', `comment` int(10) unsigned DEFAULT '0' COMMENT '评论数', `repost` int(10) unsigned DEFAULT '0' COMMENT '分享数', `digg` int(10) unsigned DEFAULT '0' COMMENT '赞数量', `content` text NOT NULL COMMENT '内容', `repost_id` int(10) unsigned NOT NULL COMMENT '转发id', `source` varchar(100) NOT NULL COMMENT '来源名称', `images` varchar(255) NOT NULL COMMENT '图片', `inputip` varchar(50) NOT NULL COMMENT '录入者ip', `inputtime` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `ctime` (`inputtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='会员动态表'; CREATE TABLE IF NOT EXISTS `{dbprefix}sns_feed_digg` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `uid` int(11) unsigned NOT NULL, `fid` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `fid` (`fid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='点赞表'; CREATE TABLE IF NOT EXISTS `{dbprefix}sns_feed_favorite` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `uid` int(11) unsigned NOT NULL, `fid` int(11) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `fid` (`fid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='收藏表'; CREATE TABLE IF NOT EXISTS `{dbprefix}sns_follow` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `uid` int(11) NOT NULL COMMENT '被关注者ID', `username` varchar(50) NOT NULL COMMENT '被关注者名称', `gid` int(11) unsigned NOT NULL COMMENT '分组表', `fid` int(11) NOT NULL COMMENT '关注者ID', `fusername` VARCHAR(50) NOT NULL COMMENT '关注者用户名', `isdouble` tinyint(1) unsigned NOT NULL COMMENT '是否互粉', `remark` varchar(50) NOT NULL COMMENT '备注', `ctime` int(11) NOT NULL COMMENT '关注时间', PRIMARY KEY (`id`), UNIQUE KEY `uid-fid` (`uid`,`fid`), UNIQUE KEY `fid-uid` (`fid`,`uid`), KEY `gi