創建表-14 · PHP應用開發記錄

``` CREATE TABLE `ims_ewei_shop_agentbouns` ( `id` int(11) NOT NULL AUTO_INCREMENT , `orderid` int(11) NULL DEFAULT 0 , `buymemberid` int(11) NULL DEFAULT 0 , `ceng` int(11) NULL DEFAULT 0 , `memberid` int(11) NULL DEFAULT 0 , `mcommission` decimal(11,2) NULL DEFAULT 0, `status` tinyint(2) NULL DEFAULT 0 , `addtime` int(11) NULL DEFAULT 0 , `note` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `type` tinyint(2) NULL DEFAULT 0 , PRIMARY KEY (`id`) ) ; CREATE TABLE `ims_ewei_shop_agentbouns_apply` ( `id` int(11) NOT NULL AUTO_INCREMENT , `memberid` int(11) NULL DEFAULT 0 , `mcommission` decimal(11,2) NULL DEFAULT 0 , `status` tinyint(2) NULL DEFAULT 0 , `note` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `subtime` int(11) NULL DEFAULT 0 , `paytime` int(11) NULL DEFAULT 0 , `paytype` tinyint(2) NULL DEFAULT 0 , `realname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `zfb` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `bankname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `bankcard` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `realmoney` decimal(10,2) NULL DEFAULT 0 , `charge` int(10) NULL DEFAULT 0 , `invalidtime` int(11) NULL DEFAULT 0 , PRIMARY KEY (`id`) ) ; //團隊訂單 CREATE TABLE `ims_ewei_shop_agentbouns_order` ( `id` int(11) NOT NULL AUTO_INCREMENT , `orderid` int(11) NULL DEFAULT 0 , `buymemberid` int(11) NULL DEFAULT 0 , `agentid` int(11) NULL DEFAULT 0 , `ceng` int(11) NULL DEFAULT 0 , `memberid` int(11) NULL DEFAULT 0 , `price` decimal(11,2) NULL DEFAULT 0, `goodsprice` decimal(11,2) NULL DEFAULT 0, `discountprice` decimal(11,2) NULL DEFAULT 0, `status` tinyint(2) NULL DEFAULT 0 , `addtime` int(11) NULL DEFAULT 0 , `note` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `type` tinyint(2) NULL DEFAULT 0 , PRIMARY KEY (`id`) ) ; CREATE TABLE `ims_ewei_shop_agentbouns_level` ( `id` int(11) NOT NULL AUTO_INCREMENT , `uniacid` int(5) NULL DEFAULT 0, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `tmprice` decimal(11,2) NULL DEFAULT 0 , `down` int(5) NULL DEFAULT 0 , `tmbi` decimal(11,2) NULL DEFAULT 0 , PRIMARY KEY (`id`) ) ; CREATE TABLE `ims_ewei_shop_agentbouns_credit` ( `id` int(11) NOT NULL AUTO_INCREMENT , `mid` int(11) NULL DEFAULT 0 , `credit` decimal(11,2) NULL DEFAULT 0 , `type` tinyint(2) NULL DEFAULT 0 , `note` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL , `addtime` int(11) NULL DEFAULT 0 , PRIMARY KEY (`id`) ) ; ```