红娘本地交友系统定制版源码 相亲婚恋交友小程序源码

-- ---------------------------- -- 日期：2019-03-13 01:18:52 -- 仅用于测试和学习,本程序不适合处理超大量数据 -- ---------------------------- -- ---------------------------- -- Table structure for `duoduo_ad` -- ---------------------------- DROP TABLE IF EXISTS `duoduo_ad`; CREATE TABLE `duoduo_ad` ( `id` int(11) NOT NULL AUTO_INCREMENT, `img` varchar(255) DEFAULT NULL, `link` text, `title` varchar(100) DEFAULT NULL, `height` varchar(5) DEFAULT NULL, `width` varchar(5) DEFAULT NULL, `content` text, `adtype` varchar(255) DEFAULT NULL, `addtime` int(11) NOT NULL DEFAULT '0', `sys` tinyint(1) NOT NULL DEFAULT '0', `edate` int(10) NOT NULL DEFAULT '0', `type` tinyint(1) NOT NULL DEFAULT '1', `tag` varchar(200) DEFAULT NULL, `bgcolor` varchar(200) DEFAULT NULL, `sort` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=170 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `duoduo_adminlog` -- ---------------------------- DROP TABLE IF EXISTS `duoduo_adminlog`; CREATE TABLE `duoduo_adminlog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_name` varchar(50) NOT NULL, `ip` varchar(15) NOT NULL, `mod` varchar(50) NOT NULL, `do` varchar(20) NOT NULL, `addtime` int(10) NOT NULL, PRIMARY KEY (`id`), KEY `admin_name` (`admin_name`), KEY `mod` (`mod`), KEY `addtime` (`addtime`) ) ENGINE=MyISAM AUTO_INCREMENT=900 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `duoduo_api` -- ---------------------------- DROP TABLE IF EXISTS `duoduo_api`; CREATE TABLE `duoduo_api` ( `id` int(5) NOT NULL AUTO_INCREMENT, `key` varchar(100) NOT NULL, `secret` varchar(100) NOT NULL, `title` varchar(50) NOT NULL, `code` varchar(10) NOT NULL, `open` int(1) NOT NULL DEFAULT '0', `sort` int(11) NOT NULL DEFAULT '0', `addtime` int(10) NOT NULL DEFAULT '0', `sys` tinyint(1) NOT NULL DEFAULT '0', `back_url` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `duoduo_apilogin` -- ---------------------------- DROP TABLE IF EXISTS `duoduo_apilogin`; CREATE TABLE `duoduo_apilogin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `webid` varchar(50) NOT NULL, `webname` varchar(50) NOT NULL, `web` varchar(20) NOT NULL, PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `webid` (`webid`), KEY `web` (`web`) ) ENGINE=MyISAM AUTO_INCREMENT=526 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `duoduo_article` -- ---------------------------- DROP TABLE IF EXISTS `duoduo_article`; CREATE TABLE `duoduo_article` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cid` int(11) DEFAULT NULL, `title` varchar(200) DEFAULT NULL, `img` varchar(200) DEFAULT NULL, `source` varchar(200) DEFAULT NULL, `content` text, `hits` int(11) DEFAULT '0', `sort` int(11) DEFAULT '0', `keyword` varchar(255) DEFAULT NULL, `desc` varchar(255) DEFAULT NULL, `addtime` int(10) NOT NULL DEFAULT '0', `del` tinyint(1) NOT NULL DEFAULT '0', `tag` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `cid` (`cid`), KEY `title` (`title`), KEY `sort` (`sort`), KEY `addtime` (`addtime`), KEY `del` (`del`) ) ENGINE=MyISAM AUTO_INCREMENT=1024 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `duoduo_bankuai` -- ---------------------------- DROP TABLE IF EXISTS `duoduo_bankuai`; CREATE TABLE `duoduo_bankuai` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `code` varchar(255) DEFAULT NULL, `banner_img` varchar(255) DEFAULT NULL, `banner_color` varchar(20) DEFAULT NULL, `bg_color` varchar(255) DEFAULT NULL, `bankuai_tpl` varchar(255) DEFAULT NULL, `fenlei` int(11) DEFAULT '0', `api_cid` int(11) DEFAULT '0', `baoming` tinyint(4) DEFAULT '1', `bankuai_img` varchar(255) DEFAULT NULL, `bankuai_desc` varchar(255) DEFAULT NULL, `tuijian` tinyint(1) DEFAULT '0', `addtime` int(11) DEFAULT NULL, `status` tinyint(1) DEFAULT '0', `web_cid` text, `sort` int(11) DEFAULT '0', `mobile_status` int(1) NOT NULL DEFAULT '0', `mobile_logo` varchar(250) NOT NULL, `mobile_title` varchar(100) NOT NULL, `del` tinyint(1) DEFAULT '0', `quanju` tinyint(1) DEFAULT '0', `yugao` tinyint(1) DEFAULT '0', `data_from` tinyint(1) DEFAULT '0', `dan_api` varchar(255) DEFAULT NULL, `yun_cid` text, `time_type` tinyint(1) DEFAULT '0', `zj_stime` int(11) DEFAULT '0', `gd_stime` tinyint(1) DEFAULT '0', `gd_minute` varchar(255) DEFAULT '0', `etime` int(11) DEFAULT '0', `yugao_time` varchar(255) DEFAULT NULL, `huodong_time` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `sys` tinyint(1) DEFAULT '0', `api_sort` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`), KEY `sort` (`sort`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `duoduo_baobei` -- ---------------------------- DROP TABLE IF EXISTS `duoduo_baobei`; CREATE TABLE `duoduo_baobei` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `tao_id` bigint(12) NOT NULL, `trade_id` int(11) NOT NULL DEFAULT '0', `img` varchar(255) DEFAULT NULL, `title` varchar(100) DEFAULT NULL, `nick` varchar(50) DEFAULT NULL, `price` double(10,2) NOT NULL DEFAULT '0.00', `commission` double(10,2) NOT NULL DEFAULT '0.00', `jifen` int(11) NOT NULL DEFAULT '0', `jifenbao` double(10,2) NOT NULL DEFAULT '0.00', `cid` int(2) NOT NULL DEFAULT '1', `click_url` text, `keywords` varchar(100) DEFAULT NULL, `content` text NOT NULL, `hart` int(10) NOT NULL DEFAULT '0', `hits` int(11) NOT NULL DEFAULT '0', `addtime` int(10) NOT NULL, `fabu_time` datetime DEFAULT NULL, `sort` int(11) NOT NULL DEFAULT '0', `shop_title` varchar(255) DEFAULT NULL, `logo` varchar(255) DEFAULT NULL, `user_id` bigint(20) NOT NULL DEFAULT '0', `del` tinyint(1) NOT NULL DEFAULT '0', `userimg` varchar(200) DEFAULT 'NULL', `status` int(1) DEFAULT '0', `reason` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `tao_id` (`tao_id`), KEY `trade_id` (`trade_id`), KEY `title` (`title`), KEY `cid` (`cid`), KEY `sort` (`sort`), KEY `del` (`del`), KEY `status` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `duoduo_baobei_comment` -- ---------------------------- DROP TABLE IF EXISTS `duoduo_baobei_comment`; CREATE TABLE `duoduo_baobei_comment` ( `id` int(10) NOT NULL AUTO_INCREMENT, `baobei_id` int(11) NOT NULL, `comment` varchar(140) NOT NULL, `addtime` int(10) NOT NULL DEFAULT '0', `uid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `baobei_id` (`baobei_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `duoduo_baobei_hart` -- ---------------------------- DROP TABLE IF EXISTS `duoduo_baobei_hart`; CREATE TABLE `duoduo_baobei_hart` ( `id` int(10) NOT NULL AUTO_INCREMENT, `baobei_id` int(11) NOT NULL DEFAULT '0', `addtime` int(10) NOT NULL DEFAULT '0', `uid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `baobei_id` (`baobei_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `duoduo_buy_log` -- ---------------------------- DROP TABLE IF EXISTS `duoduo_buy_log`; CREATE TABLE `duoduo_buy_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` bigint(15) NOT NULL DEFAULT '0', `iid` bigint(15) DEFAULT NULL, `day` datetime DEFAULT NULL, `keyword` varchar(200) DEFAULT NULL, `fxje` double(11,2) NOT NULL DEFAULT '0.00', `is_cf` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `iid` (`iid`), KEY `day` (`day`), KEY `keyword` (`keyword`) ) ENGINE=MyISAM AUTO_IN