复制//拆分前 CREATETABLE `product` ( `id` int(11) unsigned NOTNULL AUTO_INCREMENT,分库分表分水分 `title` varchar(524) DEFAULTNULL COMMENT 视频标题, `cover_img` varchar(524) DEFAULTNULL COMMENT 封面图, `price` int(11) DEFAULTNULL COMMENT 价格,分, `total` int(10) DEFAULT0 COMMENT 总库存, `left_num` int(10) DEFAULT0 COMMENT 剩余, `learn_base` text COMMENT 课前须知，学习基础,直切
`learn_result` text COMMENT 达到水平, `summary` varchar(1026) DEFAULTNULL COMMENT 概述, `detail` text COMMENT 视频商品详情, PRIMARYKEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; //拆分后 CREATETABLE `product` ( `id` int(11) unsigned NOTNULL AUTO_INCREMENT, `title` varchar(524) DEFAULTNULL COMMENT 视频标题, `cover_img` varchar(524) DEFAULTNULL COMMENT 封面图, `price` int(11) DEFAULTNULL COMMENT 价格,分, `total` int(10) DEFAULT0 COMMENT 总库存, `left_num` int(10) DEFAULT0 COMMENT 剩余, PRIMARYKEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; CREATETABLE `product_detail` ( `id` int(11) unsigned NOTNULL AUTO_INCREMENT, `product_id` int(11) DEFAULTNULL COMMENT 产品主键, `learn_base` text COMMENT 课前须知，
云南idc服务商学习基础,平切篇够
`learn_result` text COMMENT 达到水平, `summary` varchar(1026) DEFAULTNULL COMMENT 概述, `detail` text COMMENT 视频商品详情, PRIMARYKEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.
免费源码下载