通过人人开源生成代码

参考：https://gitee.com/renrenio

后台管理系统：https://gitee.com/renrenio/renren-fast
后台管理前端：https://gitee.com/renrenio/renren-fast-vue
代码生成器：https://gitee.com/renrenio/renren-generator

1、renren-fast

配置好pom.xml(root)

  1. <modules>
  2.     <module>gulimall-coupon</module>
  3.     <module>gulimall-member</module>
  4.     <module>gulimall-order</module>
  5.     <module>gulimall-product</module>
  6.     <module>gulimall-ware</module>
  8.     <module>renren-fast</module>
  9. </modules>

然后打开renren-fast/db/mysql.sql，复制全部，创建库gulimall_admin，粘贴以下的内容执行。

  1. -- 菜单
  2. CREATE TABLE `sys_menu` (
  3.   `menu_id` bigint NOT NULL AUTO_INCREMENT,
  4.   `parent_id` bigint COMMENT '父菜单ID，一级菜单为0',
  5.   `name` varchar(50) COMMENT '菜单名称',
  6.   `url` varchar(200) COMMENT '菜单URL',
  7.   `perms` varchar(500) COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  8.   `type` int COMMENT '类型   0：目录   1：菜单   2：按钮',
  9.   `icon` varchar(50) COMMENT '菜单图标',
  10.   `order_num` int COMMENT '排序',
  11.   PRIMARY KEY (`menu_id`)
  12. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='菜单管理';
  14. -- 系统用户
  15. CREATE TABLE `sys_user` (
  16.   `user_id` bigint NOT NULL AUTO_INCREMENT,
  17.   `username` varchar(50) NOT NULL COMMENT '用户名',
  18.   `password` varchar(100) COMMENT '密码',
  19.   `salt` varchar(20) COMMENT '盐',
  20.   `email` varchar(100) COMMENT '邮箱',
  21.   `mobile` varchar(100) COMMENT '手机号',
  22.   `status` tinyint COMMENT '状态  0：禁用   1：正常',
  23.   `create_user_id` bigint(20) COMMENT '创建者ID',
  24.   `create_time` datetime COMMENT '创建时间',
  25.   PRIMARY KEY (`user_id`),
  26.   UNIQUE INDEX (`username`)
  27. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='系统用户';
  29. -- 系统用户Token
  30. CREATE TABLE `sys_user_token` (
  31.   `user_id` bigint(20) NOT NULL,
  32.   `token` varchar(100) NOT NULL COMMENT 'token',
  33.   `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  34.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  35.   PRIMARY KEY (`user_id`),
  36.   UNIQUE KEY `token` (`token`)
  37. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='系统用户Token';
  39. -- 系统验证码
  40. CREATE TABLE `sys_captcha` (
  41.   `uuid` char(36) NOT NULL COMMENT 'uuid',
  42.   `code` varchar(6) NOT NULL COMMENT '验证码',
  43.   `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  44.   PRIMARY KEY (`uuid`)
  45. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='系统验证码';
  47. -- 角色
  48. CREATE TABLE `sys_role` (
  49.   `role_id` bigint NOT NULL AUTO_INCREMENT,
  50.   `role_name` varchar(100) COMMENT '角色名称',
  51.   `remark` varchar(100) COMMENT '备注',
  52.   `create_user_id` bigint(20) COMMENT '创建者ID',
  53.   `create_time` datetime COMMENT '创建时间',
  54.   PRIMARY KEY (`role_id`)
  55. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='角色';
  57. -- 用户与角色对应关系
  58. CREATE TABLE `sys_user_role` (
  59.   `id` bigint NOT NULL AUTO_INCREMENT,
  60.   `user_id` bigint COMMENT '用户ID',
  61.   `role_id` bigint COMMENT '角色ID',
  62.   PRIMARY KEY (`id`)
  63. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='用户与角色对应关系';
  65. -- 角色与菜单对应关系
  66. CREATE TABLE `sys_role_menu` (
  67.   `id` bigint NOT NULL AUTO_INCREMENT,
  68.   `role_id` bigint COMMENT '角色ID',
  69.   `menu_id` bigint COMMENT '菜单ID',
  70.   PRIMARY KEY (`id`)
  71. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='角色与菜单对应关系';
  73. -- 系统配置信息
  74. CREATE TABLE `sys_config` (
  75.     `id` bigint NOT NULL AUTO_INCREMENT,
  76.     `param_key` varchar(50) COMMENT 'key',
  77.     `param_value` varchar(2000) COMMENT 'value',
  78.     `status` tinyint DEFAULT 1 COMMENT '状态   0：隐藏   1：显示',
  79.     `remark` varchar(500) COMMENT '备注',
  80.     PRIMARY KEY (`id`),
  81.     UNIQUE INDEX (`param_key`)
  82. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='系统配置信息表';
  85. -- 系统日志
  86. CREATE TABLE `sys_log` (
  87.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  88.   `username` varchar(50) COMMENT '用户名',
  89.   `operation` varchar(50) COMMENT '用户操作',
  90.   `method` varchar(200) COMMENT '请求方法',
  91.   `params` varchar(5000) COMMENT '请求参数',
  92.   `time` bigint NOT NULL COMMENT '执行时长(毫秒)',
  93.   `ip` varchar(64) COMMENT 'IP地址',
  94.   `create_date` datetime COMMENT '创建时间',
  95.   PRIMARY KEY (`id`)
  96. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='系统日志';
  99. -- 文件上传
  100. CREATE TABLE `sys_oss` (
  101.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  102.   `url` varchar(200) COMMENT 'URL地址',
  103.   `create_date` datetime COMMENT '创建时间',
  104.   PRIMARY KEY (`id`)
  105. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='文件上传';
  108. -- 定时任务
  109. CREATE TABLE `schedule_job` (
  110.   `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
  111.   `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  112.   `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  113.   `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式',
  114.   `status` tinyint(4) DEFAULT NULL COMMENT '任务状态  0：正常  1：暂停',
  115.   `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  116.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  117.   PRIMARY KEY (`job_id`)
  118. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='定时任务';
  120. -- 定时任务日志
  121. CREATE TABLE `schedule_job_log` (
  122.   `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  123.   `job_id` bigint(20) NOT NULL COMMENT '任务id',
  124.   `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  125.   `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  126.   `status` tinyint(4) NOT NULL COMMENT '任务状态    0：成功    1：失败',
  127.   `error` varchar(2000) DEFAULT NULL COMMENT '失败信息',
  128.   `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)',
  129.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  130.   PRIMARY KEY (`log_id`),
  131.   KEY `job_id` (`job_id`)
  132. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='定时任务日志';
  136. -- 用户表
  137. CREATE TABLE `tb_user` (
  138.   `user_id` bigint NOT NULL AUTO_INCREMENT,
  139.   `username` varchar(50) NOT NULL COMMENT '用户名',
  140.   `mobile` varchar(20) NOT NULL COMMENT '手机号',
  141.   `password` varchar(64) COMMENT '密码',
  142.   `create_time` datetime COMMENT '创建时间',
  143.   PRIMARY KEY (`user_id`),
  144.   UNIQUE INDEX (`username`)
  145. ) ENGINE=`InnoDB` DEFAULT CHARACTER SET utf8mb4 COMMENT='用户';
  152. -- 初始数据 
  153. INSERT INTO `sys_user` (`user_id`, `username`, `password`, `salt`, `email`, `mobile`, `status`, `create_user_id`, `create_time`) VALUES ('1', 'admin', '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d', 'YzcmCZNvbXocrsz9dm8e', 'root@renren.io', '13612345678', '1', '1', '2016-11-11 11:11:11');
  155. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (1, 0, '系统管理', NULL, NULL, 0, 'system', 0);
  156. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (2, 1, '管理员列表', 'sys/user', NULL, 1, 'admin', 1);
  157. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (3, 1, '角色管理', 'sys/role', NULL, 1, 'role', 2);
  158. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (4, 1, '菜单管理', 'sys/menu', NULL, 1, 'menu', 3);
  159. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (5, 1, 'SQL监控', 'http://localhost:8080/renren-fast/druid/sql.html', NULL, 1, 'sql', 4);
  160. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (6, 1, '定时任务', 'job/schedule', NULL, 1, 'job', 5);
  161. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (7, 6, '查看', NULL, 'sys:schedule:list,sys:schedule:info', 2, NULL, 0);
  162. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (8, 6, '新增', NULL, 'sys:schedule:save', 2, NULL, 0);
  163. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (9, 6, '修改', NULL, 'sys:schedule:update', 2, NULL, 0);
  164. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (10, 6, '删除', NULL, 'sys:schedule:delete', 2, NULL, 0);
  165. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (11, 6, '暂停', NULL, 'sys:schedule:pause', 2, NULL, 0);
  166. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (12, 6, '恢复', NULL, 'sys:schedule:resume', 2, NULL, 0);
  167. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (13, 6, '立即执行', NULL, 'sys:schedule:run', 2, NULL, 0);
  168. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (14, 6, '日志列表', NULL, 'sys:schedule:log', 2, NULL, 0);
  169. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0);
  170. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0);
  171. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0);
  172. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0);
  173. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (19, 3, '查看', NULL, 'sys:role:list,sys:role:info', 2, NULL, 0);
  174. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (20, 3, '新增', NULL, 'sys:role:save,sys:menu:list', 2, NULL, 0);
  175. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (21, 3, '修改', NULL, 'sys:role:update,sys:menu:list', 2, NULL, 0);
  176. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (22, 3, '删除', NULL, 'sys:role:delete', 2, NULL, 0);
  177. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0);
  178. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0);
  179. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0);
  180. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0);
  181. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (27, 1, '参数管理', 'sys/config', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 'config', 6);
  182. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (29, 1, '系统日志', 'sys/log', 'sys:log:list', 1, 'log', 7);
  183. INSERT INTO `sys_menu`(`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`) VALUES (30, 1, '文件上传', 'oss/oss', 'sys:oss:all', 1, 'oss', 6);
  185. INSERT INTO `sys_config` (`param_key`, `param_value`, `status`, `remark`) VALUES ('CLOUD_STORAGE_CONFIG_KEY', '{\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"aliyunDomain\":\"\",\"aliyunEndPoint\":\"\",\"aliyunPrefix\":\"\",\"qcloudBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuBucketName\":\"ios-app\",\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"upload\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"type\":1}', '0', '云存储配置信息');
  186. INSERT INTO `schedule_job` (`bean_name`, `params`, `cron_expression`, `status`, `remark`, `create_time`) VALUES ('testTask', 'renren', '0 0/30 * * * ?', '0', '参数测试', now());
  189. -- 账号：13612345678  密码：admin
  190. INSERT INTO `tb_user` (`username`, `mobile`, `password`, `create_time`) VALUES ('mark', '13612345678', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '2017-03-23 22:37:41');
  194. --  quartz自带表结构
  195. CREATE TABLE QRTZ_JOB_DETAILS(
  196. SCHED_NAME VARCHAR(120) NOT NULL,
  197. JOB_NAME VARCHAR(200) NOT NULL,
  198. JOB_GROUP VARCHAR(200) NOT NULL,
  199. DESCRIPTION VARCHAR(250) NULL,
  200. JOB_CLASS_NAME VARCHAR(250) NOT NULL,
  201. IS_DURABLE VARCHAR(1) NOT NULL,
  202. IS_NONCONCURRENT VARCHAR(1) NOT NULL,
  203. IS_UPDATE_DATA VARCHAR(1) NOT NULL,
  204. REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
  205. JOB_DATA BLOB NULL,
  206. PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP))
  207. ENGINE=InnoDB DEFAULT CHARSET=utf8;
  209. CREATE TABLE QRTZ_TRIGGERS (
  210. SCHED_NAME VARCHAR(120) NOT NULL,
  211. TRIGGER_NAME VARCHAR(200) NOT NULL,
  212. TRIGGER_GROUP VARCHAR(200) NOT NULL,
  213. JOB_NAME VARCHAR(200) NOT NULL,
  214. JOB_GROUP VARCHAR(200) NOT NULL,
  215. DESCRIPTION VARCHAR(250) NULL,
  216. NEXT_FIRE_TIME BIGINT(13) NULL,
  217. PREV_FIRE_TIME BIGINT(13) NULL,
  218. PRIORITY INTEGER NULL,
  219. TRIGGER_STATE VARCHAR(16) NOT NULL,
  220. TRIGGER_TYPE VARCHAR(8) NOT NULL,
  221. START_TIME BIGINT(13) NOT NULL,
  222. END_TIME BIGINT(13) NULL,
  223. CALENDAR_NAME VARCHAR(200) NULL,
  224. MISFIRE_INSTR SMALLINT(2) NULL,
  225. JOB_DATA BLOB NULL,
  226. PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
  227. FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
  228. REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP))
  229. ENGINE=InnoDB DEFAULT CHARSET=utf8;
  231. CREATE TABLE QRTZ_SIMPLE_TRIGGERS (
  232. SCHED_NAME VARCHAR(120) NOT NULL,
  233. TRIGGER_NAME VARCHAR(200) NOT NULL,
  234. TRIGGER_GROUP VARCHAR(200) NOT NULL,
  235. REPEAT_COUNT BIGINT(7) NOT NULL,
  236. REPEAT_INTERVAL BIGINT(12) NOT NULL,
  237. TIMES_TRIGGERED BIGINT(10) NOT NULL,
  238. PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
  239. FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
  240. REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
  241. ENGINE=InnoDB DEFAULT CHARSET=utf8;
  243. CREATE TABLE QRTZ_CRON_TRIGGERS (
  244. SCHED_NAME VARCHAR(120) NOT NULL,
  245. TRIGGER_NAME VARCHAR(200) NOT NULL,
  246. TRIGGER_GROUP VARCHAR(200) NOT NULL,
  247. CRON_EXPRESSION VARCHAR(120) NOT NULL,
  248. TIME_ZONE_ID VARCHAR(80),
  249. PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
  250. FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
  251. REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
  252. ENGINE=InnoDB DEFAULT CHARSET=utf8;
  254. CREATE TABLE QRTZ_SIMPROP_TRIGGERS
  255.   (          
  256.     SCHED_NAME VARCHAR(120) NOT NULL,
  257.     TRIGGER_NAME VARCHAR(200) NOT NULL,
  258.     TRIGGER_GROUP VARCHAR(200) NOT NULL,
  259.     STR_PROP_1 VARCHAR(512) NULL,
  260.     STR_PROP_2 VARCHAR(512) NULL,
  261.     STR_PROP_3 VARCHAR(512) NULL,
  262.     INT_PROP_1 INT NULL,
  263.     INT_PROP_2 INT NULL,
  264.     LONG_PROP_1 BIGINT NULL,
  265.     LONG_PROP_2 BIGINT NULL,
  266.     DEC_PROP_1 NUMERIC(13,4) NULL,
  267.     DEC_PROP_2 NUMERIC(13,4) NULL,
  268.     BOOL_PROP_1 VARCHAR(1) NULL,
  269.     BOOL_PROP_2 VARCHAR(1) NULL,
  270.     PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
  271.     FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) 
  272.     REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
  273. ENGINE=InnoDB DEFAULT CHARSET=utf8;
  275. CREATE TABLE QRTZ_BLOB_TRIGGERS (
  276. SCHED_NAME VARCHAR(120) NOT NULL,
  277. TRIGGER_NAME VARCHAR(200) NOT NULL,
  278. TRIGGER_GROUP VARCHAR(200) NOT NULL,
  279. BLOB_DATA BLOB NULL,
  280. PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
  281. INDEX (SCHED_NAME,TRIGGER_NAME, TRIGGER_GROUP),
  282. FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
  283. REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
  284. ENGINE=InnoDB DEFAULT CHARSET=utf8;
  286. CREATE TABLE QRTZ_CALENDARS (
  287. SCHED_NAME VARCHAR(120) NOT NULL,
  288. CALENDAR_NAME VARCHAR(200) NOT NULL,
  289. CALENDAR BLOB NOT NULL,
  290. PRIMARY KEY (SCHED_NAME,CALENDAR_NAME))
  291. ENGINE=InnoDB DEFAULT CHARSET=utf8;
  293. CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS (
  294. SCHED_NAME VARCHAR(120) NOT NULL,
  295. TRIGGER_GROUP VARCHAR(200) NOT NULL,
  296. PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP))
  297. ENGINE=InnoDB DEFAULT CHARSET=utf8;
  299. CREATE TABLE QRTZ_FIRED_TRIGGERS (
  300. SCHED_NAME VARCHAR(120) NOT NULL,
  301. ENTRY_ID VARCHAR(95) NOT NULL,
  302. TRIGGER_NAME VARCHAR(200) NOT NULL,
  303. TRIGGER_GROUP VARCHAR(200) NOT NULL,
  304. INSTANCE_NAME VARCHAR(200) NOT NULL,
  305. FIRED_TIME BIGINT(13) NOT NULL,
  306. SCHED_TIME BIGINT(13) NOT NULL,
  307. PRIORITY INTEGER NOT NULL,
  308. STATE VARCHAR(16) NOT NULL,
  309. JOB_NAME VARCHAR(200) NULL,
  310. JOB_GROUP VARCHAR(200) NULL,
  311. IS_NONCONCURRENT VARCHAR(1) NULL,
  312. REQUESTS_RECOVERY VARCHAR(1) NULL,
  313. PRIMARY KEY (SCHED_NAME,ENTRY_ID))
  314. ENGINE=InnoDB DEFAULT CHARSET=utf8;
  316. CREATE TABLE QRTZ_SCHEDULER_STATE (
  317. SCHED_NAME VARCHAR(120) NOT NULL,
  318. INSTANCE_NAME VARCHAR(200) NOT NULL,
  319. LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
  320. CHECKIN_INTERVAL BIGINT(13) NOT NULL,
  321. PRIMARY KEY (SCHED_NAME,INSTANCE_NAME))
  322. ENGINE=InnoDB DEFAULT CHARSET=utf8;
  324. CREATE TABLE QRTZ_LOCKS (
  325. SCHED_NAME VARCHAR(120) NOT NULL,
  326. LOCK_NAME VARCHAR(40) NOT NULL,
  327. PRIMARY KEY (SCHED_NAME,LOCK_NAME))
  328. ENGINE=InnoDB DEFAULT CHARSET=utf8;
  330. CREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY);
  331. CREATE INDEX IDX_QRTZ_J_GRP ON QRTZ_JOB_DETAILS(SCHED_NAME,JOB_GROUP);
  333. CREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);
  334. CREATE INDEX IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP);
  335. CREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME);
  336. CREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);
  337. CREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE);
  338. CREATE INDEX IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);
  339. CREATE INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);
  340. CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME);
  341. CREATE INDEX IDX_QRTZ_T_NFT_ST ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME);
  342. CREATE INDEX IDX_QRTZ_T_NFT_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME);
  343. CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE);
  344. CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE_GRP ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE);
  346. CREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME);
  347. CREATE INDEX IDX_QRTZ_FT_INST_JOB_REQ_RCVRY ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY);
  348. CREATE INDEX IDX_QRTZ_FT_J_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);
  349. CREATE INDEX IDX_QRTZ_FT_JG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP);
  350. CREATE INDEX IDX_QRTZ_FT_T_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP);
  351. CREATE INDEX IDX_QRTZ_FT_TG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);

修改项目里renren-fast中的application.yml，修改application-dev.yml中的数据库连接

  1. url: jdbc:mysql://192.168.1.103:3306/mall_admin?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
  2. username: root
  3. password: root

执行java下的RenrenApplication
浏览器输入http://localhost:8080/renren-fast/
得到{“msg”:“invalid token”,“code”:401}就代表无误

2、renren-fast-vue

切换淘宝镜像
npm install -g cnpm --registry=https://registry.npm.taobao.org
设置权限(管理员打开cmd)
输入set-ExecutionPolicy RemoteSigned 选择A
image.png
安装依赖
注意： npm 有些可能下载不下来
用 cnpm install
启动
npm run dev

浏览器输入localhost:8001 就可以看到内容了，登录账号admin 密码admin

3、renren-generator

同样把里面的.git文件删除，然后移动到我们IDEA项目目录中

配置好pom.xml(root)

  1. <modules>
  2.         <module>gulimall-coupon</module>
  3.         <module>gulimall-member</module>
  4.         <module>gulimall-order</module>
  5.         <module>gulimall-product</module>
  6.         <module>gulimall-ware</module>
  7.         <module>renren-fast</module>
  8.         <module>renren-generator</module>
  9. </modules>

修改renren-generator的application.yml

  1. url: jdbc:mysql://192.168.1.103:3306/mall-pms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
  2. username: root
  3. password: root

修改generator.properties

  1. mainPath=com.ht # 主目录
  2. package=com.ht.mall # 包名
  3. moduleName=product   # 模块名
  4. author=  # 作者
  5. email=xxx@qq.com  # email
  6. tablePrefix=pms_   # 我们的pms数据库中的表的前缀都有pms

如果写了表前缀，每一张表对于的javaBean就不会添加前缀了

运行RenrenApplication
如果启动不成功，修改application中是port为80。
访问http://localhost:80 然后点击全部，点击生成代码。
下载并解压压缩包，把main放到mall-product的同级目录下。