You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
116 lines
2.5 KiB
116 lines
2.5 KiB
CREATE SEQUENCE notice_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_notice ALTER COLUMN notice_id |
|
SET DEFAULT nextval('notice_id_seq'); |
|
|
|
CREATE SEQUENCE config_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_config ALTER COLUMN config_id |
|
SET DEFAULT nextval('config_id_seq'); |
|
|
|
CREATE SEQUENCE dept_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_dept ALTER COLUMN dept_id |
|
SET DEFAULT nextval('dept_id_seq'); |
|
|
|
CREATE SEQUENCE dict_code_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_dict_data ALTER COLUMN dict_code |
|
SET DEFAULT nextval('dict_code_seq'); |
|
|
|
CREATE SEQUENCE dict_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_dict_type ALTER COLUMN dict_id |
|
SET DEFAULT nextval('dict_id_seq'); |
|
|
|
CREATE SEQUENCE info_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_logininfor ALTER COLUMN info_id |
|
SET DEFAULT nextval('info_id_seq'); |
|
|
|
CREATE SEQUENCE menu_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_menu ALTER COLUMN menu_id |
|
SET DEFAULT nextval('menu_id_seq'); |
|
|
|
CREATE SEQUENCE oper_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_oper_log ALTER COLUMN oper_id |
|
SET DEFAULT nextval('oper_id_seq'); |
|
|
|
CREATE SEQUENCE post_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_post ALTER COLUMN post_id |
|
SET DEFAULT nextval('post_id_seq'); |
|
|
|
CREATE SEQUENCE role_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_role ALTER COLUMN role_id |
|
SET DEFAULT nextval('role_id_seq'); |
|
|
|
CREATE SEQUENCE user_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_user ALTER COLUMN user_id |
|
SET DEFAULT nextval('user_id_seq'); |
|
|
|
CREATE SEQUENCE sys_job_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_job ALTER COLUMN job_id |
|
SET DEFAULT nextval('sys_job_id_seq'); |
|
|
|
CREATE SEQUENCE sys_job_log_id_seq |
|
START WITH 10000 |
|
INCREMENT BY 1 |
|
NO MINVALUE |
|
NO MAXVALUE |
|
CACHE 1; |
|
ALTER TABLE sys_job_log ALTER COLUMN job_log_id |
|
SET DEFAULT nextval('sys_job_log_id_seq');
|
|
|