pg.sql 908 B

123456789101112131415161718192021
  1. -- 开始初始化数据 ;
  2. create sequence if not exists sys_role_role_id_seq;
  3. create sequence if not exists sys_user_user_id_seq;
  4. create sequence if not exists sys_post_post_id_seq;
  5. create sequence if not exists sys_menu_menu_id_seq;
  6. create sequence if not exists sys_dict_type_dict_id_seq;
  7. create sequence if not exists sys_dict_data_dict_code_seq;
  8. create sequence if not exists sys_dept_dept_id_seq;
  9. create sequence if not exists sys_config_config_id_seq;
  10. create sequence if not exists sys_job_id_seq;
  11. select setval('sys_role_role_id_seq',4);
  12. select setval('sys_user_user_id_seq',5);
  13. select setval('sys_post_post_id_seq',4);
  14. select setval('sys_menu_menu_id_seq',543);
  15. select setval('sys_dict_type_dict_id_seq',12);
  16. select setval('sys_dict_data_dict_code_seq',34);
  17. select setval('sys_dept_dept_id_seq',11);
  18. select setval('sys_config_config_id_seq',6);
  19. select setval('sys_job_id_seq',3);
  20. -- 数据完成 ;