LJY_cash_draws
CREATE TABLE `ljy_cash_draws` (
`cashId` int(11) NOT NULL,
`cashNo` varchar(50) NOT NULL,
PRIMARY KEY (`cashId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LJY_cat_brands
CREATE TABLE `ljy_cat_brands` (
`id` int(11) NOT NULL COMMENT '自增ID',
`catId` int(11) DEFAULT NULL COMMENT '分类ID',
`brandId` int(11) DEFAULT NULL COMMENT '品牌ID',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LJY_cat_shops
CREATE TABLE `ljy_cat_shops` (
`id` int(11) NOT NULL COMMENT '自增ID',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LJY_charge_items
CREATE TABLE `ljy_charge_items` (
`id` int(11) NOT NULL COMMENT '自增ID',
`chargeMoney` int(11) DEFAULT NULL COMMENT '充值金额',
`giveMoney` decimal(11,1) DEFAULT NULL COMMENT '赠送金额',
`itemSort` int(11) DEFAULT NULL COMMENT '排序号',
`dataFlag` tinyint(4) DEFAULT NULL COMMENT '是否有效',
`createTime` time DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;