e_ttoa_init_sequence.sql

非常完整的Java开发的网络办公系统

--*****************************
--DROP TABLE
--*****************************
--
DROP TABLE  T_SEQUENCE 
;
--*****************************
--CREATE TABLE
--*****************************
--
CREATE TABLE T_SEQUENCE ( 
      SEQUENCE_NAME VARCHAR(40), 
      SEQUENCE_VALUE INT,
      CONSTRAINT PK_T_SEQUENCE124 PRIMARY KEY (SEQUENCE_NAME) )
;
--*****************************
--Intrializtion Data
--*****************************
--
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_BOARDROOM_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_CONFERENCE_ID',10000)
;
---************************************************************************
---Because of the  user "Administrator" as the 10000 account of this system,
---so the S_EMP_ID begin from 10001.
---*************************************************************************
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_EMP_ID', 10001)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_DIVISION_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_EQUIPMENT_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_WORKFLOW_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_WORKFLOW_FILE_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_RECEIVED_DOC_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_WORKFLOW_LOG_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_WORKFLOW_SUBTASK_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_WORKFLOW_EXECUTOR_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_TASK_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_ADDRESSLIST_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_ADDRESSLIST_EMPLOYE_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_DIRECTORY_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_PUBLICATION_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_REGULATION_ID', 10000)   
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_ADDRESS_GROUP_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_ATTACHFILE_SUBPATH_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_AUTOMOBILE_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_AUTOMOBILE_BOOKING_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_AUTOMOBILE_MAINTAIN_ID', 10000)     
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_BATCH_ID', 10000)    
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_PECCANCY_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_ACCIDENT_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_WORK_RECORD_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_DRIVING_FEE_ID', 10000)  
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_WORKFLOW_TEMPLATE_ID', 10000)       
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_SUBTASK_TEMPLATE_ID', 10000)  
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_EXECUTOR_TEMPLATE_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_HR_COMPONENT_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_HR_DD_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_HR_MEMBER_COR_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_HR_MEMBER_SCHOOL_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_HR_INNER_RESUME_ID', 10000)
;
--***********************************************
--The followed data not in SequenceConstant.java
--***********************************************
--
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_BOOK_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_EMPLOYEE_GROUP_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_RETURN_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_SENT_MSG_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_RECEIVED_MSG_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_LEAVE_WORD_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_MSG_ATTACHMENT_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_BORROW_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_ARCHIVE_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_ATTACHMENT_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_BULLETIN_ID', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_BUDGET', 10000)
;
INSERT INTO T_SEQUENCE(sequence_name,  sequence_value) VALUES('S_HR_TRAIN_ID', 10000)
--*****************************
--Intrializtion Data
--*****************************