/*
Data Transfer
Author: wemall
company:xxx
Date: 2015-03-03 15:01:33
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Create Table wemall_accessory
-- ----------------------------
DROP TABLE IF EXISTS `wemall_accessory`;
CREATE TABLE `wemall_accessory` (
`id` bigint(20) NOT NULL auto_increment,
`addTime` datetime default NULL,
`deleteStatus` bit(1) NOT NULL,
`ext` varchar(255) default NULL,
`height` int(11) NOT NULL,
`info` varchar(255) default NULL,
`name` varchar(255) default NULL,
`path` varchar(255) default NULL,
`size` float NOT NULL,
`width` int(11) NOT NULL,
`album_id` bigint(20) default NULL,
`user_id` bigint(20) default NULL,
`config_id` bigint(20) default NULL,
PRIMARY KEY (`id`),
KEY `FK9BF2D721537B6C51` (`user_id`),
KEY `FK9BF2D7218603E3C3` (`album_id`),
KEY `FK9BF2D721707C8F90` (`config_id`),
CONSTRAINT `FK9BF2D721537B6C51` FOREIGN KEY (`user_id`) REFERENCES `wemall_user` (`id`),
CONSTRAINT `FK9BF2D721707C8F90` FOREIGN KEY (`config_id`) REFERENCES `wemall_sysconfig` (`id`),
CONSTRAINT `FK9BF2D7218603E3C3` FOREIGN KEY (`album_id`) REFERENCES `wemall_album` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Create Table wemall_activity
-- ----------------------------
DROP TABLE IF EXISTS `wemall_activity`;
CREATE TABLE `wemall_activity` (
`id` bigint(20) NOT NULL auto_increment,
`addTime` datetime default NULL,
`deleteStatus` bit(1) NOT NULL,
`ac_begin_time` date default NULL,
`ac_content` longtext,
`ac_end_time` date default NULL,
`ac_sequence` int(11) NOT NULL,
`ac_status` int(11) NOT NULL,
`ac_title` varchar(255) default NULL,
`ac_acc_id` bigint(20) default NULL,
`ac_rebate` decimal(3,2) default NULL,
PRIMARY KEY (`id`),
KEY `FK11BFAD20D8BBB351` (`ac_acc_id`),
CONSTRAINT `FK11BFAD20D8BBB351` FOREIGN KEY (`ac_acc_id`) REFERENCES `wemall_accessory` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Create Table wemall_activity_goods
-- ----------------------------
DROP TABLE IF EXISTS `wemall_activity_goods`;
CREATE TABLE `wemall_activity_goods` (
`id` bigint(20) NOT NULL auto_increment,
`addTime` datetime default NULL,
`deleteStatus` bit(1) NOT NULL,
`ag_status` int(11) NOT NULL,
`act_id` bigint(20) default NULL,
`ag_admin_id` bigint(20) default NULL,
`ag_goods_id` bigint(20) default NULL,
`ag_price` decimal(12,2) default NULL,
PRIMARY KEY (`id`),
KEY `FK614D4F77DC166646` (`ag_admin_id`),
KEY `FK614D4F7787F8C9EE` (`act_id`),
KEY `FK614D4F77632F565C` (`ag_goods_id`),
CONSTRAINT `FK614D4F77632F565C` FOREIGN KEY (`ag_goods_id`) REFERENCES `wemall_goods` (`id`),
CONSTRAINT `FK614D4F7787F8C9EE` FOREIGN KEY (`act_id`) REFERENCES `wemall_activity` (`id`),
CONSTRAINT `FK614D4F77DC166646` FOREIGN KEY (`ag_admin_id`) REFERENCES `wemall_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Create Table wemall_address
-- ----------------------------
DROP TABLE IF EXISTS `wemall_address`;
CREATE TABLE `wemall_address` (
`id` bigint(20) NOT NULL auto_increment,
`addTime` datetime default NULL,
`deleteStatus` bit(1) NOT NULL,
`area_info` varchar(255) default NULL,
`mobile` varchar(255) default NULL,
`telephone` varchar(255) default NULL,
`trueName` varchar(255) default NULL,
`zip` varchar(255) default NULL,
`area_id` bigint(20) default NULL,
`user_id` bigint(20) default NULL,
PRIMARY KEY (`id`),
KEY `FK9ABDBC32FB91D11` (`area_id`),
KEY `FK9ABDBC3537B6C51` (`user_id`),
CONSTRAINT `FK9ABDBC32FB91D11` FOREIGN KEY (`area_id`) REFERENCES `wemall_area` (`id`),
CONSTRAINT `FK9ABDBC3537B6C51` FOREIGN KEY (`user_id`) REFERENCES `wemall_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Create Table wemall_adv_pos
-- ----------------------------
DROP TABLE IF EXISTS `wemall_adv_pos`;
CREATE TABLE `wemall_adv_pos` (
`id` bigint(20) NOT NULL auto_increment,
`addTime` datetime default NULL,
`deleteStatus` bit(1) NOT NULL,
`ap_acc_url` varchar(255) default NULL,
`ap_code` longtext,
`ap_content` longtext,
`ap_height` int(11) NOT NULL,
`ap_price` int(11) NOT NULL,
`ap_sale_type` int(11) NOT NULL,
`ap_show_type` int(11) NOT NULL,
`ap_status` int(11) NOT NULL,
`ap_sys_type` int(11) NOT NULL,
`ap_text` varchar(255) default NULL,
`ap_title` varchar(255) default NULL,
`ap_type` varchar(255) default NULL,
`ap_use_status` int(11) NOT NULL,
`ap_width` int(11) NOT NULL,
`ap_acc_id` bigint(20) default NULL,
PRIMARY KEY (`id`),
KEY `FKAA108971F2AFAA4` (`ap_acc_id`),
CONSTRAINT `FKAA108971F2AFAA4` FOREIGN KEY (`ap_acc_id`) REFERENCES `wemall_accessory` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Create Table wemall_advert
-- ----------------------------
DROP TABLE IF EXISTS `wemall_advert`;
CREATE TABLE `wemall_advert` (
`id` bigint(20) NOT NULL auto_increment,
`addTime` datetime default NULL,
`deleteStatus` bit(1) NOT NULL,
`ad_begin_time` date default NULL,
`ad_click_num` int(11) NOT NULL,
`ad_end_time` date default NULL,
`ad_gold` int(11) NOT NULL,
`ad_slide_sequence` int(11) NOT NULL,
`ad_status` int(11) NOT NULL,
`ad_text` varchar(255) default NULL,
`ad_title` varchar(255) default NULL,
`ad_url` varchar(255) default NULL,
`ad_acc_id` bigint(20) default NULL,
`ad_ap_id` bigint(20) default NULL,
`ad_user_id` bigint(20) default NULL,
PRIMARY KEY (`id`),
KEY `FKCECB7A255A9A4C35` (`ad_user_id`),
KEY `FKCECB7A25296B4EE3` (`ad_ap_id`),
KEY `FKCECB7A25409CE030` (`ad_acc_id`),
CONSTRAINT `FKCECB7A25296B4EE3` FOREIGN KEY (`ad_ap_id`) REFERENCES `wemall_adv_pos` (`id`),
CONSTRAINT `FKCECB7A25409CE030` FOREIGN KEY (`ad_acc_id`) REFERENCES `wemall_accessory` (`id`),
CONSTRAINT `FKCECB7A255A9A4C35` FOREIGN KEY (`ad_user_id`) REFERENCES `wemall_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Create Table wemall_album
-- ----------------------------
DROP TABLE IF EXISTS `wemall_album`;
CREATE TABLE `wemall_album` (
`id` bigint(20) NOT NULL auto_increment,
`addTime` datetime default NULL,
`deleteStatus` bit(1) NOT NULL,
`alblum_info` longtext,
`album_default` bit(1) NOT NULL,
`album_name` varchar(255) default NULL,
`album_sequence` int(11) NOT NULL,
`album_cover_id` bigint(20) default NULL,
`user_id` bigint(20) default NULL,
PRIMARY KEY (`id`),
KEY `FK2FF965FE537B6C51` (`user_id`),
KEY `FK2FF965FE58AB9D6E` (`album_cover_id`),
CONSTRAINT `FK2FF965FE537B6C51` FOREIGN KEY (`user_id`) REFERENCES `wemall_user` (`id`),
CONSTRAINT `FK2FF965FE58AB9D6E` FOREIGN KEY (`album_cover_id`) REFERENCES `wemall_accessory` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Create Table wemall_area
-- ----------------------------
DROP TABLE IF EXISTS `wemall_area`;
CREATE TABLE `wemall_area` (
`id` bigint(20) NOT NULL auto_increment,
`addTime` datetime default NULL,
`deleteStatus` bit(1) NOT NULL,
`areaName` varchar(255) default NULL,
`level` int(11) NOT NULL,
`sequence` int(11) NOT NULL,
`parent_id` bigint(20) default NULL,
`common` bit(1) default '\0',
PRIMARY KEY (`id`),
KEY `FK7D6B3B1ED79E13D4` (`parent_id`),
CONSTRAINT `FK7D6B3B1ED79E13D4` FOREIGN KEY (`parent_id`) REFERENCES `wemall_area` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Create Table wemall_article
-- ----------------------------
DROP TABLE IF EXISTS `wemall_article`;
CREATE TABLE `wemall_article` (
`id` bigint(20) NOT NULL auto_increment,
`addTime` datetime default NULL,
`deleteStatus` bit(1) NOT NULL,
`content` longtext,
`display` bit(1) NOT NULL,
`mark` varchar(255) default NULL,
`sequence` int(11) NOT NULL,
`title` varchar(255) default NULL,
`url` varchar(255) default NULL,
`articleClass_id` bigint(20) default NULL,
PRIMARY KEY (`id`),
KEY `FK226D0CC544ED
wemalls java 电商微商城 b2b2c多商户商城系统PC版+wap版
1星 需积分: 12 119 浏览量
2019-03-15
01:29:12
上传
评论 1
收藏 136.65MB 7Z 举报 
wemalls java 电商微商城 b2b2c多商户商城系统PC版+wap版 （5281个子文件） 
_o.cfs 993B _3.cfs 966B _p.cfs 928B _e.cfs 908B _8.cfs 777B CartViewAction.class 66KB GoodsSellerAction.class 51KB PayViewAction.class 51KB CommUtil.class 47KB OrderSellerAction.class 47KB IndexViewAction.class 39KB GoodsViewAction.class 38KB OrderBuyerAction.class 35KB StoreManageAction.class 30KB BaseManageAction.class 30KB StatManageAction.class 29KB IntegralViewAction.class 29KB SysConfig.class 28KB GoodsFloorManageAction.class 28KB PayTools.class 26KB StoreSellerAction.class 26KB AccountBuyerAction.class 26KB OperateImage.class 25KB User.class 24KB HomePageBuyerAction.class 23KB Goods.class 22KB IntegralGoodsManageAction.class 22KB CouponManageAction.class 22KB SpareGoodsFloorManageAction.class 21KB BaseBuyerAction.class 21KB BargainManageAction.class 20KB TaobaoSellerAction.class 20KB GoodsManageAction.class 20KB AdminManageAction.class 19KB Store.class 19KB StoreViewAction.class 18KB GroupSellerAction.class 18KB SpareGoodsManageAction.class 18KB GoodsClassManageAction.class 18KB AdvertManageAction.class 18KB SpareGoodsSellerAction.class 18KB UserManageAction.class 18KB WxCommonUtil.class 17KB AlbumSellerAction.class 17KB ComplaintBuyerAction.class 17KB CombinSellerAction.class 17KB ActivityManageAction.class 17KB GoodsBrandManageAction.class 17KB GoodsSpecificationManageAction.class 16KB AdvertSellerAction.class 16KB DeliverySellerAction.class 15KB GoodsTypeManageAction.class 15KB LuceneUtil.class 15KB SearchViewAction.class 15KB TransportSellerAction.class 15KB AreaManageAction.class 15KB GoldSellerAction.class 15KB GroupManageAction.class 14KB UCClient.class 14KB DatabaseTools.class 14KB TransAreaManageAction.class 14KB PredepositManageAction.class 14KB SubAccountSellerAction.class 14KB BargainSellerAction.class 13KB StoreClassManageAction.class 13KB ReportBuyerAction.class 13KB ArticleClassManageAction.class 13KB DatabaseManageAction.class 13KB ExpressCompanyManageAction.class 13KB MessageBuyerAction.class 13KB ZtcManageAction.class 12KB PredepositBuyerAction.class 12KB GroupClassManageAction.class 12KB NavigationManageAction.class 12KB TransportTools.class 12KB StringUtils.class 12KB GroupViewAction.class 12KB SpareGoodsViewAction.class 12KB ComplaintManageAction.class 12KB QQLoginPlug.class 12KB GoldRecordManageAction.class 12KB ZtcSellerAction.class 12KB ComplaintSellerAction.class 12KB GroupAreaManageAction.class 12KB SinaLoginPlug.class 12KB TemplateManageAction.class 11KB ArticleManageAction.class 11KB ActivitySellerAction.class 11KB AlipaySubmit.class 11KB OrderForm.class 11KB ChattingViewAction.class 11KB StoreGradeManageAction.class 11KB JobManageAction.class 11KB BrandViewAction.class 11KB StoreViewTools.class 11KB OrderManageAction.class 10KB LoginViewAction.class 10KB IpAddress.class 10KB DeliveryManageAction.class 10KB PartnerManageAction.class 10KB共 5281 条
- 1
- 2
- 3
- 4
- 5
- 6
- 53
评论1
最新资源