<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>
          

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>
          

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>
          

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>
                <ruby id="bdb3f"></ruby>
                
    


                
  
                                            
                                                                                    
        
                
          合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。
          廣告
        
                        
                
  

                

                
    
                
        
                
                            # SQL
```
-- 生活服務分類表
CREATE TABLE `o2o_category`(
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` VARCHAR(50) NOT NULL default '' ,
  `parent_id` int(10) unsigned NOT NULL default 0,
  `listorder` int(8) unsigned NOT NULL default 0,
  `status` tinyint(1) NOT NULL default 0,
  `create_time` int(11) unsigned NOT NULL default 0,
  `update_time` int(11) unsigned NOT NULL default 0,
  PRIMARY KEY (`id`),
  KEY parent_id(`parent_id`)
)ENGINE=InnoDB AUTO_INCREMENT=1 default  CHARSET=utf8;

-- 城市表
CREATE TABLE `o2o_city`(
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` VARCHAR(50) NOT NULL default '' ,
  `uname` VARCHAR(50) NOT NULL default '' ,
  `parent_id` int(10) unsigned NOT NULL default 0,
  `listorder` int(8) unsigned NOT NULL default 0,
  `status` tinyint(1) NOT NULL default 0,
  `create_time` int(11) unsigned NOT NULL default 0,
  `update_time` int(11) unsigned NOT NULL default 0,
  PRIMARY KEY (`id`),
  KEY parent_id(`parent_id`),
  UNIQUE KEY uname(`uname`)
)ENGINE=InnoDB AUTO_INCREMENT=1 default  CHARSET=utf8;

-- 商圈表
CREATE TABLE `o2o_area`(
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` VARCHAR(50) NOT NULL default '' ,
  `city_id` int(11) unsigned NOT NULL default 0,
  `parent_id` int(10) unsigned NOT NULL default 0,
  `listorder` int(8) unsigned NOT NULL default 0,
  `status` tinyint(1) NOT NULL default 0,
  `create_time` int(11) unsigned NOT NULL default 0,
  `update_time` int(11) unsigned NOT NULL default 0,
  PRIMARY KEY (`id`),
  KEY parent_id(`parent_id`),
  KEY city_id(`city_id`)
)ENGINE=InnoDB AUTO_INCREMENT=1 default  CHARSET=utf8;

-- 商戶表
CREATE TABLE `o2o_bis`(
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` VARCHAR(50) NOT NULL default '' ,
  `email` VARCHAR(50) NOT NULL default '' ,
  `logo` VARCHAR(255) NOT NULL default '' ,
  `licence_logo` VARCHAR(255) NOT NULL default '' ,
  `description` text NOT NULL,
  `city_id` int(11) unsigned NOT NULL default 0,
  `city_path` varchar(50) NOT NULL default '' ,
  `bank_info` varchar(50) NOT NULL default '' ,
  `money` decimal(20,2) NOT NULL default '0.00',
  `bank_name` varchar(50) NOT NULL default '' ,
  `bank_user` varchar(50) NOT NULL default '' ,
  `faren` varchar(20) NOT NULL default '' ,
  `faren_tel` varchar(20) NOT NULL default '' ,
  `listorder` int(8) unsigned NOT NULL default 0,
  `status` tinyint(1) NOT NULL default 0,
  `create_time` int(11) unsigned NOT NULL default 0,
  `update_time` int(11) unsigned NOT NULL default 0,
  PRIMARY KEY (`id`),
  KEY city_id(`city_id`),
  KEY name(`name`)
)ENGINE=InnoDB AUTO_INCREMENT=1 default  CHARSET=utf8;

-- 商戶賬號表
CREATE TABLE `o2o_bis_account`(
  `id` int(11) unsigned NOT NULL auto_increment,
  `username` VARCHAR(50) NOT NULL default '' ,
  `password` char(32) NOT NULL default '' ,
  `code` varchar(10) NOT NULL default '' ,
  `bis_id` int(11) unsigned NOT NULL default 0,
  `last_login_ip` VARCHAR(20) NOT NULL default '',
  `last_login_time` int(11) unsigned NOT NULL default 0,
  `is_main` tinyint(1)  unsigned NOT NULL default 0,
  `listorder` int(8) unsigned NOT NULL default 0,
  `status` tinyint(1) NOT NULL default 0,
  `create_time` int(11) unsigned NOT NULL default 0,
  `update_time` int(11) unsigned NOT NULL default 0,
  PRIMARY KEY (`id`),
  KEY bis_id(`bis_id`),
  KEY username(`username`)
)ENGINE=InnoDB AUTO_INCREMENT=1 default  CHARSET=utf8;

-- 商戶門店表
CREATE TABLE `o2o_bis_location`(
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` VARCHAR(50) NOT NULL default '' ,
  `logo` VARCHAR(255) NOT NULL default '' ,
  `address` VARCHAR(255) NOT NULL default '' ,
  `tel` VARCHAR(20) NOT NULL default '' ,
  `contact` VARCHAR(20) NOT NULL default '' ,
  `xpoint` VARCHAR(20) NOT NULL default '',
  `ypoint` VARCHAR(20) NOT NULL default '',
  `bis_id` int(11) unsigned NOT NULL default 0,
  `open_time` int(11) unsigned NOT NULL default 0,
  `content` text NOT NULL ,
  `is_main` tinyint(1)  unsigned NOT NULL default 0,
  `api_address` VARCHAR(255) NOT NULL default '' ,
  `city_id` int(11) unsigned NOT NULL default 0,
  `city_path` varchar(50) NOT NULL default '' ,
  `category_id` int(11 ) unsigned NOT NULL default 0,
  `category_path` VARCHAR(50) NOT NULL default '',
  `bank_info` varchar(50) NOT NULL default '' ,
  `listorder` int(8) unsigned NOT NULL default 0,
  `status` tinyint(1) NOT NULL default 0,
  `create_time` int(11) unsigned NOT NULL default 0,
  `update_time` int(11) unsigned NOT NULL default 0,
  PRIMARY KEY (`id`),
  KEY city_id(`city_id`),
  KEY bis_id(`bis_id`),
  KEY category_id(`category_id`),
  KEY name(`name`)
)ENGINE=InnoDB AUTO_INCREMENT=1 default  CHARSET=utf8;


-- 團購商品表
CREATE TABLE `o2o_deal`(
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `category_id` int(11) NOT NULL default  0,
  `se_category_id` int(11) NOT NULL default  0,
  `bis_id` int(11) NOT NULL default  0,
  `location_ids` VARCHAR(100) NOT NULL default '',
  `image` VARCHAR(200) NOT NULL default '',
  `description` text NOT  NULL ,
  `start_time` int(11) NOT NULL default  0,
  `end_time` int(11) NOT NULL default  0,
  `origin_price` decimal(20,2) NOT NULL default '0.00',
  `current_price` decimal(20,2) NOT NULL default '0.00',
  `city_id` int(11 ) NOT NULL default  0,
  `buy_count` int(11 ) NOT NULL default  0,
  `total_count` int(11 ) NOT NULL default  0,
  `coupons_begin_time` int(11) NOT NULL default  0,
  `coupons_end_time` int(11) NOT NULL default  0,
  `xpoint` VARCHAR(20) NOT NULL default '',
  `ypoint` VARCHAR(20) NOT NULL default '',
  `bis_account_id` int(10) NOT  NULL  default 0,
  `balance_price` decimal(20,2) NOT NULL default '0.00',
  `notes` text not NULL ,
  `listorder` int(8) unsigned NOT NULL default 0,
  `status` tinyint(1) NOT NULL default 0,
  `create_time` int(11) unsigned NOT NULL default 0,
  `update_time` int(11) unsigned NOT NULL default 0,
  PRIMARY KEY (`id`),
  KEY category_id(`category_id`),
  KEY se_category_id(`se_category_id`),
  KEY city_id(`city_id`),
  KEY start_time(`start_time`),
  KEY end_time(`end_time`)
)ENGINE=InnoDB AUTO_INCREMENT=1 default  CHARSET=utf8;


-- 用戶表
CREATE TABLE `o2o_user`(
  `id` int(11) unsigned NOT NULL auto_increment,
  `username` VARCHAR(20) NOT NULL  default '',
  `password` char(32) NOT NULL default '' ,
  `code` varchar(10) NOT NULL default '' ,
  `last_login_ip` VARCHAR(20) NOT NULL default '',
  `last_login_time` int(11) unsigned NOT NULL default 0,
  `email` varchar(30) NOT NULL default '',
  `mobile` varchar(20) NOT NULL default '',
  `listorder` int(8) unsigned NOT NULL default 0,
  `status` tinyint(1) NOT NULL default 0,
  `create_time` int(11) unsigned NOT NULL default 0,
  `update_time` int(11) unsigned NOT NULL default 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY username(`username`),
  UNIQUE KEY email(`email`)
)ENGINE=InnoDB AUTO_INCREMENT=1 default  CHARSET=utf8;

-- 推薦位表
CREATE TABLE `o2o_featured`(
  `id` int(11) unsigned NOT NULL auto_increment,
  `type` tinyint(1) NOT NULL default 0,
  `title` VARCHAR(30) NOT NULL default '',
  `image` VARCHAR(255) NOT NULL default '',
  `url` VARCHAR(255) NOT NULL default '',
  `description` VARCHAR(255) NOT NULL default '',
  `listorder` int(8) unsigned NOT NULL default 0,
  `status` tinyint(1) NOT NULL default 0,
  `create_time` int(11) unsigned NOT NULL default 0,
  `update_time` int(11) unsigned NOT NULL default 0,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB AUTO_INCREMENT=1 default  CHARSET=utf8;

-- 訂單表
CREATE TABLE `o2o_order`(
  `id` int(11) unsigned NOT NULL auto_increment,
  `out_trade_no` VARCHAR(100)  NOT NULL DEFAULT '',
  `transaction_id` VARCHAR(100)  NOT NULL DEFAULT '',
  `user_id` int(11) NOT NULL DEFAULT 0,
  `username` VARCHAR(50) NOT NULL  DEFAULT '',
  `pay_time` VARCHAR(20) NOT NULL  DEFAULT '',
  `payment_id` tinyint(1) NOT NULL DEFAULT 1,
  `deal_id` int(11) NOT NULL default 0,
  `deal_count` int(11) NOT NULL default 0,
  `pay_status` tinyint(1) NOT NULL DEFAULT 0,
  `total_price` decimal(20,2) NOT NULL DEFAULT '0.00',
  `pay_amount` decimal(20,2) NOT NULL DEFAULT '0.00',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `referer` VARCHAR(255) NOT NULL  DEFAULT '',
  `create_time` int(11) unsigned NOT NULL default 0,
  `update_time` int(11) unsigned NOT NULL default 0,
  PRIMARY KEY (`id`),
  UNIQUE `out_trade_no`(`out_trade_no`),
  key user_id(`user_id`),
  key create_time(`create_time` )
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT  CHARSET=utf8;
```
                    
                
        
                
            
        
                
    
                
    
                
        
                
    
                

                







                  <ruby id="bdb3f"></ruby>
                  <p id="bdb3f"><cite id="bdb3f"></cite></p>
                    

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>
                        

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>
                        

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>
                        

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>
                              <ruby id="bdb3f"></ruby>
                              

哎呀哎呀视频在线观看