DROP TABLE IF EXISTS `ourphp_usershopadd`;
CREATE TABLE `ourphp_usershopadd` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Add` varchar(255) NOT NULL default '', /*地址*/
`OP_Addtel` varchar(255) NOT NULL default '', /*电话*/
`OP_Addname` varchar(255) NOT NULL default '', /*姓名*/
`OP_Adduser` varchar(255) NOT NULL default '', /*归属*/
`OP_Addindex` int(11) NOT NULL default '0', /*默认*/
`OP_Maplat` varchar(255) NOT NULL default '',
`OP_Maplng` varchar(255) NOT NULL default '',
`time` datetime, /*日期*/
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_coupon`;
CREATE TABLE `ourphp_coupon` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Title` varchar(255) NOT NULL default '', /*优惠券标题*/
`OP_Money` decimal(10,2) NOT NULL default '0', /*优惠券金额*/
`OP_Timewin` varchar(255) NOT NULL default '2015-01-01 12:00:00',  /*时间限制*/
`OP_Moneygo` decimal(10,2) NOT NULL default '0',  /*满金额使用*/
`OP_Content` text, /*描述*/
`OP_Type` int(11) NOT NULL default '0', /*类型 0=全部领取 1=向指定用户发放*/
`OP_Md` varchar(255) NOT NULL default '', /*MD5校验值*/
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_couponlist`;
CREATE TABLE `ourphp_couponlist` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Couponid` int(11) NOT NULL default '0', /*优惠券ID*/
`OP_Username` varchar(255) NOT NULL default '', /*领取的会员账户*/
`OP_Type` int(11) NOT NULL default '0', /*使用 0=未用 1=已用*/
`OP_Timewin` varchar(255) NOT NULL default '2015-01-01 12:00:00',  /*时间限制*/
`OP_Moneygo` decimal(10,2) NOT NULL default '0',  /*满金额使用*/
`OP_Md` varchar(255) NOT NULL default '', /*MD5校验值*/
`OP_Time` varchar(255) NOT NULL default '2015-01-01 12:00:00',  /*使用时间*/
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_orderslist`;
CREATE TABLE `ourphp_orderslist` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Ordersnum` varchar(255) NOT NULL default '', /*统一订单号*/
`OP_Ordersid` varchar(255) NOT NULL default '', /*订单ID集合*/
`OP_Ordersusername` varchar(255) NOT NULL default '', /*收件人姓名*/
`OP_Ordersusertel` varchar(255) NOT NULL default '', /*收件人电话*/
`OP_Ordersuseradd` varchar(255) NOT NULL default '', /*收件人地址*/
`OP_Orderscouponmoney` decimal(10,2) NOT NULL default '0',  /*优惠券金额*/
`OP_Orderscouponid` int(11) NOT NULL default '0', /*优惠券ID*/
`OP_Ordersuser` varchar(255) NOT NULL default '', /*订单归属者*/
`OP_Ordersimg` varchar(255) NOT NULL default '', /*产品图片*/
`OP_Look` int(11) NOT NULL default '0', /*已读订单*/
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_adminnav`;
CREATE TABLE `ourphp_adminnav` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Title` varchar(255) NOT NULL default '',
`OP_Soft` int(11) NOT NULL default '0',
`OP_Ourphp` int(11) NOT NULL default '0',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_adminnavlist`;
CREATE TABLE `ourphp_adminnavlist` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Title` varchar(255) NOT NULL default '',
`OP_Path` varchar(255) NOT NULL default '',
`OP_Soft` int(11) NOT NULL default '0',
`OP_Uid` int(11) NOT NULL default '0',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_userregreward`;
CREATE TABLE `ourphp_userregreward` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Useremail` varchar(255) NOT NULL default '',
`OP_Useremailto` varchar(255) NOT NULL default '',
`OP_Usermoney` decimal(10,2) NOT NULL default '0', /*奖励现金*/
`OP_Userintegral` decimal(10,2) NOT NULL default '0', /*奖励积分*/
`OP_Userid` int(11) NOT NULL default '0', /*被推荐人ID*/
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_usermoneyback`;
CREATE TABLE `ourphp_usermoneyback` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Useremail` varchar(255) NOT NULL default '', /*退款账户*/
`OP_Orderid` int(11) NOT NULL default '0', /*退款订单ID*/
`OP_Userposnum` varchar(255) NOT NULL default '',
`OP_Userposname` varchar(255) NOT NULL default '',
`OP_Admintime` varchar(255) NOT NULL default '',
`OP_Adminname` varchar(255) NOT NULL default '',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_usermoneyout`;
CREATE TABLE `ourphp_usermoneyout` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Useremail` varchar(255) NOT NULL default '', /*提现人*/
`OP_Useroutmoney` decimal(10,2) NOT NULL default '0', /*提现金额*/
`OP_Type` int(11) NOT NULL default '0',
`OP_User` varchar(255) NOT NULL default '',
`OP_Usertime` varchar(255) NOT NULL default '',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_tuan`;
CREATE TABLE `ourphp_tuan` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Tuanpid` int(11) NOT NULL default '0',
`OP_Tuanoid` int(11) NOT NULL default '0',
`OP_Tuanuser` varchar(255) NOT NULL default '',
`OP_Tuannum` int(11) NOT NULL default '0',
`OP_Tuanznum` int(11) NOT NULL default '0',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_tuanuserlist`;
CREATE TABLE `ourphp_tuanuserlist` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Tuanid` int(11) NOT NULL default '0',
`OP_Tuanpid` int(11) NOT NULL default '0',
`OP_Tuanoid` int(11) NOT NULL default '0',
`OP_Tuanuser` varchar(255) NOT NULL default '',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_logs`;
CREATE TABLE `ourphp_logs` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Logscontent` varchar(255) NOT NULL default '',
`OP_Logsaccount` varchar(255) NOT NULL default '',
`OP_Logsip` varchar(255) NOT NULL default '',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_usersaleinfo`;
CREATE TABLE `ourphp_usersaleinfo` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Productid` int(11) NOT NULL default '0',
`OP_Productmoney` decimal(10,2) NOT NULL default '0', 
`OP_Usermoney` decimal(10,2) NOT NULL default '0',
`OP_Buyuseremail` varchar(255) NOT NULL default '',
`OP_Incomeuseremail` varchar(255) NOT NULL default '',
`OP_Proportion` int(11) NOT NULL default '0',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ourphp_model`;
CREATE TABLE `ourphp_model` (
`id` int(10) unsigned NOT NULL auto_increment,
`OP_Modelclass` varchar(255) NOT NULL default '',
`OP_Modelname` varchar(255) NOT NULL default '',
`OP_Modelfield` varchar(255) NOT NULL default '',
`OP_Modeltype` varchar(255) NOT NULL default '',
`time` datetime,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;