<?php
$sql="CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_advertising` (
`a_id` int(11) NOT NULL AUTO_INCREMENT,
`a_uniacid` int(11) NOT NULL,
`a_picture` varchar(100) NOT NULL,
`a_link` varchar(50) NOT NULL,
`a_uid` int(11) DEFAULT NULL,
PRIMARY KEY (`a_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_cat` (
`c_id` int(11) NOT NULL AUTO_INCREMENT,
`c_userid` int(11) DEFAULT NULL,
`c_openid` varchar(30) DEFAULT NULL,
`c_orderid` int(11) DEFAULT NULL,
`c_uniacid` int(11) DEFAULT NULL,
`c_goodsid` int(11) NOT NULL,
`c_goodscateid` int(11) DEFAULT NULL,
`c_goodscaseid` int(11) DEFAULT NULL,
`c_count` int(11) DEFAULT NULL,
`c_date` int(11) NOT NULL,
`c_status` tinyint(4) NOT NULL DEFAULT '0',
`c_uid` int(11) DEFAULT NULL,
`c_goodssizeid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_category` (
`c_id` int(11) NOT NULL AUTO_INCREMENT,
`c_uniacid` int(11) DEFAULT NULL,
`c_name` varchar(30) DEFAULT NULL,
`c_state` int(11) DEFAULT NULL,
`c_uid` int(11) DEFAULT NULL,
`c_num` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_categorydetial` (
`cd_id` int(11) NOT NULL AUTO_INCREMENT,
`cd_cid` int(11) DEFAULT NULL,
`cd_uniacid` int(11) DEFAULT NULL,
`cd_name` varchar(20) DEFAULT NULL,
`remark` varchar(20) DEFAULT NULL,
`indexPlay` tinyint(2) NOT NULL DEFAULT '0',
`sort` int(11) DEFAULT NULL,
`date` int(11) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
`logo` varchar(100) DEFAULT NULL,
`idkey` varchar(100) DEFAULT NULL,
PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_convention` (
`c_id` int(11) NOT NULL AUTO_INCREMENT,
`c_openid` varchar(30) DEFAULT NULL,
`c_uniacid` int(11) DEFAULT NULL,
`c_number` int(11) DEFAULT NULL,
`c_time` int(11) DEFAULT NULL,
`c_roomstatus` tinyint(4) NOT NULL DEFAULT '0',
`c_name` varchar(15) DEFAULT NULL,
`c_gender` tinyint(4) NOT NULL DEFAULT '1',
`c_mobile` varchar(15) DEFAULT NULL,
`c_note` varchar(20) DEFAULT NULL,
`c_order_no` varchar(20) DEFAULT NULL,
`c_userid` int(11) DEFAULT NULL,
`c_money` varchar(15) NOT NULL DEFAULT '0',
`c_status` tinyint(2) NOT NULL DEFAULT '0',
`c_deal` tinyint(2) NOT NULL DEFAULT '0',
`c_date` varchar(30) DEFAULT NULL,
`c_payway` tinyint(2) NOT NULL DEFAULT '0',
`c_audio` tinyint(2) NOT NULL DEFAULT '0',
`c_uid` int(11) DEFAULT NULL,
`c_time2` int(11) DEFAULT NULL,
`c_integralmoney` float NOT NULL DEFAULT '0',
`c_integral` float NOT NULL DEFAULT '0',
`c_couponsmoney` float NOT NULL DEFAULT '0',
`c_couponsid` float NOT NULL DEFAULT '0',
`c_formid` varchar(65) DEFAULT NULL,
PRIMARY KEY (`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_conventiondetail` (
`cd_id` int(11) NOT NULL AUTO_INCREMENT,
`cd_openid` varchar(30) DEFAULT NULL,
`cd_orderid` int(11) DEFAULT NULL,
`cd_order_no` varchar(30) DEFAULT NULL,
`cd_uniacid` int(11) DEFAULT NULL,
`cd_goodsid` int(11) DEFAULT NULL,
`cd_goodscateid` int(11) DEFAULT NULL,
`cd_count` int(11) DEFAULT NULL,
`cd_date` int(11) DEFAULT NULL,
`cd_goodsname` varchar(50) DEFAULT NULL,
`cd_status` tinyint(2) DEFAULT NULL,
`cd_price` float NOT NULL DEFAULT '0',
`cd_goodssizename` varchar(100) DEFAULT NULL,
PRIMARY KEY (`cd_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_coupons` (
`c_id` int(11) NOT NULL AUTO_INCREMENT,
`c_uniacid` int(11) DEFAULT NULL,
`c_name` varchar(50) NOT NULL,
`c_money` float NOT NULL,
`c_starttime` date DEFAULT NULL,
`c_endtime` date DEFAULT NULL,
`c_limitmoney` float DEFAULT NULL,
`c_uid` int(11) DEFAULT NULL,
`c_peoplenum` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_enabledebug` (
`e_id` int(11) NOT NULL AUTO_INCREMENT,
`e_uniacid` int(11) NOT NULL,
`e_status` tinyint(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`e_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_goods` (
`g_id` int(11) NOT NULL AUTO_INCREMENT,
`g_number` int(11) NOT NULL,
`g_uniacid` int(11) DEFAULT NULL,
`g_cid` int(11) DEFAULT NULL,
`g_name` varchar(50) DEFAULT NULL,
`g_price0` decimal(8,2) DEFAULT NULL,
`g_price` float DEFAULT NULL,
`g_sellCount` int(11) NOT NULL DEFAULT '0',
`g_stock` int(11) NOT NULL DEFAULT '0',
`g_discountType` tinyint(2) DEFAULT NULL,
`g_discountEnd` datetime DEFAULT NULL,
`g_status` int(11) NOT NULL DEFAULT '0',
`g_indexHot` int(2) NOT NULL DEFAULT '0',
`g_unit` varchar(10) DEFAULT NULL,
`g_sort` int(11) NOT NULL DEFAULT '0',
`g_picture` varchar(100) DEFAULT NULL,
`g_date` int(11) DEFAULT NULL,
`g_desc` text,
`g_features` tinyint(2) NOT NULL DEFAULT '0',
`g_uid` int(11) DEFAULT NULL,
PRIMARY KEY (`g_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_goodssize` (
`gs_id` int(11) NOT NULL AUTO_INCREMENT,
`gs_name` varchar(100) DEFAULT NULL,
`gs_money` float NOT NULL DEFAULT '0',
`gs_uniacid` int(11) DEFAULT NULL,
`gs_uid` int(11) DEFAULT NULL,
`gs_goodsid` int(11) DEFAULT NULL,
PRIMARY KEY (`gs_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_indexadvertising` (
`ia_id` int(11) NOT NULL AUTO_INCREMENT,
`ia_type` int(11) NOT NULL DEFAULT '0',
`ia_uniacid` int(11) DEFAULT NULL,
`ia_picture` varchar(100) DEFAULT NULL,
PRIMARY KEY (`ia_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_indexhidden` (
`ih_id` int(11) NOT NULL AUTO_INCREMENT,
`ih_uniacid` int(11) NOT NULL,
`ih_hiddenstatus` tinyint(2) NOT NULL DEFAULT '0',
`ih_uid` int(11) DEFAULT NULL,
PRIMARY KEY (`ih_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_indexicon` (
`i_diancan` tinyint(2) NOT NULL DEFAULT '1',
`i_waimai` tinyint(2) NOT NULL DEFAULT '1',
`i_yuyue` tinyint(2) NOT NULL DEFAULT '1',
`i_maidan` tinyint(2) DEFAULT '1',
`i_paidui` tinyint(2) NOT NULL DEFAULT '1',
`i_id` int(11) NOT NULL AUTO_INCREMENT,
`i_uniacid` int(11) NOT NULL,
`i_uid` int(11) DEFAULT NULL,
PRIMARY KEY (`i_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_integral` (
`i_id` int(11) NOT NULL AUTO_INCREMENT,
`i_uniacid` int(11) DEFAULT NULL,
`i_integral` float DEFAULT NULL,
`i_integralmoney` float DEFAULT NULL,
`i_integralcancel` float DEFAULT NULL,
`i_integraldeduction` float DEFAULT NULL,
PRIMARY KEY (`i_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_integraldetail` (
`id_id` int(11) NOT NULL AUTO_INCREMENT,
`id_uniacid` int(11) DEFAULT NULL,
`id_openid` varchar(50) DEFAULT NULL,
`id_time` int(11) DEFAULT NULL,
`id_type` tinyint(2) DEFAULT '0',
`id_user` varchar(50) DEFAULT NULL,
`id_nickname` varchar(100) DEFAULT NULL,
`id_headimg` varchar(500) DEFAULT NULL,
`id_money` float DEFAULT NULL,
`id_status` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_map` (
`m_id` int(11) NOT NULL AUTO_INCREMENT,
`m_uniacid` int(11) NOT NULL,
`m_wxaddress_key` varchar(100) DEFAULT NULL,
PRIMARY KEY (`m_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waimai_messagesopenid` (
`mo_id` int(11) NOT NULL AUTO_INCREMENT,
`mo_uniacid` int(11) NOT NULL,
`mo_uid` int(11) NOT NULL,
`mo_wxopenid` varchar(100) NOT NULL,
`mo_headimgurl` varchar(200) DEFAULT NULL,
`mo_nickname` varchar(200) DEFAULT NULL,
PRIMARY KEY (`mo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_azsk_waim