e_ttoa_drop_table.sql

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

ALTER TABLE T_TRAINING_ATTANDENCE DROP CONSTRAINT SYS_C005614
;
ALTER TABLE T_EQUIPMENT DROP CONSTRAINT T_EQUIPMENT_FK_C_I
;
ALTER TABLE T_EMP_X_DUTY DROP CONSTRAINT SYS_C005198
;
ALTER TABLE T_ADDRESSLIST_EMPLOYE DROP CONSTRAINT SYS_C005788
;
ALTER TABLE T_SALARY_ITEMS DROP CONSTRAINT SYS_C005611
;
ALTER TABLE T_SALARY_ITEMS DROP CONSTRAINT SYS_C005610
;
ALTER TABLE T_CATEGORY DROP CONSTRAINT T_CATEGORY_FK
;
ALTER TABLE T_PASS_READ_SENT_BOX DROP CONSTRAINT SYS_C005621
;
ALTER TABLE T_DOCUMENTATION DROP CONSTRAINT SYS_C005629
;
ALTER TABLE T_SUBTASK_X_FILE DROP CONSTRAINT SYS_C006353
;
ALTER TABLE T_CONTACT_TASK DROP CONSTRAINT SYS_C005627
;
ALTER TABLE T_AUTOMOBILE DROP CONSTRAINT FK_T_AUTOMOBILE109
;
ALTER TABLE T_PASS_READ_INBOX DROP CONSTRAINT SYS_C005620
;
ALTER TABLE T_PASS_READ_LOG DROP CONSTRAINT SYS_C005625
;
ALTER TABLE T_DRIVER_X_AUTOMOBILE DROP CONSTRAINT FK_T_DRIVER_X_AUTOMOBILE4
;
ALTER TABLE T_DRIVER_X_AUTOMOBILE DROP CONSTRAINT FK_T_DRIVER_X_AUTOMOBILE5
;
ALTER TABLE T_AUTOMOBILE_BOOKING DROP CONSTRAINT FK_T_AUTOMOBILE_BOOKING103
;
ALTER TABLE T_AUTOMOBILE_BOOKING DROP CONSTRAINT FK_T_AUTOMOBILE_BOOKING1
;
ALTER TABLE T_PASS_READ_RECYLE_BOX DROP CONSTRAINT SYS_C005624
;
ALTER TABLE HR_FORMAL DROP CONSTRAINT SYS_C005828
;
ALTER TABLE HR_FORMAL DROP CONSTRAINT SYS_C005827
;
ALTER TABLE T_EMP DROP CONSTRAINT SYS_C005812
--;
--ALTER TABLE T_EMP DROP CONSTRAINT SYS_C005813
;
ALTER TABLE T_CONTACT_X_GROUP DROP CONSTRAINT FK_T_X_CONTACT_GROUP102
;
ALTER TABLE T_CONTACT_X_GROUP DROP CONSTRAINT FK_T_X_CONTACT_GROUP103
;
ALTER TABLE T_DUTY_X_PRIVILEGE DROP CONSTRAINT SYS_C005189
;
ALTER TABLE T_DUTY_X_PRIVILEGE DROP CONSTRAINT SYS_C005188
;
ALTER TABLE T_PASS_READ_OVER_BOX DROP CONSTRAINT SYS_C005623
;
ALTER TABLE T_TASK_ATTACHMENT DROP CONSTRAINT SYS_C005286
;
ALTER TABLE T_DUTY DROP CONSTRAINT SYS_C005184
;
ALTER TABLE T_DIVISION DROP CONSTRAINT SYS_C005595
;
ALTER TABLE T_DIVISION DROP CONSTRAINT SYS_C005164
;
ALTER TABLE HR_CONTRACT DROP CONSTRAINT SYS_C005817
;
ALTER TABLE HR_CONTRACT DROP CONSTRAINT SYS_C005816
;
ALTER TABLE T_SUBTASK DROP CONSTRAINT FK_T_SUBTASK30
;
ALTER TABLE T_SUBTASK DROP CONSTRAINT FK_SUBTASKS0
;
ALTER TABLE T_SUBTASK DROP CONSTRAINT FK_T_SUBTASK25
;
ALTER TABLE T_ACCIDENT DROP CONSTRAINT FK_T_ACCIDENT105
;
ALTER TABLE T_ACCIDENT DROP CONSTRAINT FK_T_ACCIDENT3
;
ALTER TABLE T_SAFETY_DRIVING DROP CONSTRAINT FK_T_SAFTY_DRIVING1
;
ALTER TABLE T_SUBTASK_TEMPLATE DROP CONSTRAINT FK_T_SUBTASK_TEMPLATE32
;
ALTER TABLE T_SUBTASK_TEMPLATE DROP CONSTRAINT FK_T_SUBTASK_TEMPLATE36
;
ALTER TABLE T_CONTACT_PERSON_NOTES DROP CONSTRAINT SYS_C005628
;
ALTER TABLE T_WORKFLOW_TEMPLATE DROP CONSTRAINT FK_T_WORKFLOW_TEMPLATE33
;
ALTER TABLE T_EMPLOYEE_X_GROUP DROP CONSTRAINT FK_T_EMPLOYEE_X_GROUP102
;
ALTER TABLE T_AUTOMOBILE_MAINTAIN DROP CONSTRAINT FK_T_AUTOMOBILE_MAINTAIN102
;
ALTER TABLE T_CONFERENCE_X_FILES DROP CONSTRAINT FK_T_CONFERENCE_X_FILES117
;
ALTER TABLE T_EXECUTOR_TEMPLATE DROP CONSTRAINT FK_T_EXECUTOR_TEMPATE31
;
ALTER TABLE T_DOCRECEIVED_X_FILE DROP CONSTRAINT SYS_C006352
;
ALTER TABLE T_DOCRECEIVED_X_FILE DROP CONSTRAINT SYS_C006367
;
ALTER TABLE T_WORKFLOW_TEMPLATE_X_FILE DROP CONSTRAINT SYS_C006354
;
ALTER TABLE T_WORKFLOW DROP CONSTRAINT FK_T_WORKFLOW27
;
ALTER TABLE T_WORKFLOW DROP CONSTRAINT FK_T_WORKFLOW35
;
ALTER TABLE HR_MEMBER_EDUCATIONAL_INFO DROP CONSTRAINT SYS_C005607
;
ALTER TABLE T_EXECUTOR DROP CONSTRAINT FK_T_EXECUTOR24
;
ALTER TABLE T_EXECUTOR DROP CONSTRAINT FK_EXECUTOR1
;
ALTER TABLE HR_DEV_TRAIN DROP CONSTRAINT SYS_C005598
;
ALTER TABLE HR_MEMBER_SALARY DROP CONSTRAINT SYS_C005953
;
ALTER TABLE HR_MEMBER_SALARY DROP CONSTRAINT SYS_C005952
;
ALTER TABLE T_DOC_RECEIVED DROP CONSTRAINT FK_T_DOC_RECEIVED23
;
ALTER TABLE T_DOC_RECEIVED DROP CONSTRAINT FK_T_DOC_RECEIVED26
;
ALTER TABLE T_WORKFLOW_X_FILE DROP CONSTRAINT SYS_C006366
;
ALTER TABLE T_WORKFLOW_X_FILE DROP CONSTRAINT SYS_C006355
;
ALTER TABLE T_EMP_X_PRIVILEGE DROP CONSTRAINT SYS_C005178
;
ALTER TABLE T_DIRECTORIES_PERMISSION DROP CONSTRAINT FK_T_DIRECTORIES_PERMISSION9
;
ALTER TABLE T_CONFERENCE DROP CONSTRAINT FK_T_CONFERENCE112
;
ALTER TABLE T_MSG_RECEIVER DROP CONSTRAINT FK_T_MSG_RECEIVER3
;
ALTER TABLE T_WORK_RECORD DROP CONSTRAINT FK_T_WORK_RECORD107
;
ALTER TABLE T_WORK_RECORD DROP CONSTRAINT FK_T_WORK_RECORD106
;
ALTER TABLE T_PROJECT_CHANGE DROP CONSTRAINT SYS_C005630
;
ALTER TABLE T_DIRECTORIES DROP CONSTRAINT FK_T_DIRECTORIES5
;
ALTER TABLE T_PECCANCY DROP CONSTRAINT FK_T_PECCANCY2
;
ALTER TABLE T_PECCANCY DROP CONSTRAINT FK_T_PECCANCY104
;
ALTER TABLE T_SALARY_ITEMS_LOG DROP CONSTRAINT SYS_C05612
;
ALTER TABLE T_SALARY_ITEMS_LOG DROP CONSTRAINT SYS_C005613
;
ALTER TABLE T_SALARY_LOG DROP CONSTRAINT SYS_C005609
;
ALTER TABLE T_MSG_RECEIVERS DROP CONSTRAINT SYS_C005631
;
ALTER TABLE T_BUDGET_LIST DROP CONSTRAINT T_BUDGET_DIVISIONID
;
ALTER TABLE T_FILE DROP CONSTRAINT SYS_C006351
;
ALTER TABLE T_FILES DROP CONSTRAINT FK_T_FILES4
;
ALTER TABLE T_PASS_READ_PASSING_BOX DROP CONSTRAINT SYS_C005622
;
ALTER TABLE T_CONTACT_PERSON DROP CONSTRAINT SYS_C005626
;
ALTER TABLE HR_TRAIN DROP CONSTRAINT SYS_C005596
;
ALTER TABLE T_DRIVING_FEE DROP CONSTRAINT FK_T_DRIVING_FEE106
;
ALTER TABLE T_DRIVING_FEE DROP CONSTRAINT FK_T_DRIVING_FEE105
;
ALTER TABLE T_BOARDROOM DROP CONSTRAINT FK_T_BOARDROOM113
;
ALTER TABLE T_WORKFLOW_DISPATCH DROP CONSTRAINT FK_DISPATCH9
;
ALTER TABLE HR_MEMBER_PRIVATE_INFO DROP CONSTRAINT SYS_C005605
;
ALTER TABLE HR_SALARY_LIST DROP CONSTRAINT SYS_C005957
;
ALTER TABLE HR_SALARY_LIST DROP CONSTRAINT SYS_C005958
;
ALTER TABLE T_TOPIC_X_MEETING_ROOM DROP CONSTRAINT SYS_C005619
;
ALTER TABLE T_TOPIC_X_MEETING_ROOM DROP CONSTRAINT SYS_C005618
;
ALTER TABLE T_E_MEETING_MESSAGE DROP CONSTRAINT SYS_C005615
;
ALTER TABLE T_E_MEETING_MESSAGE DROP CONSTRAINT SYS_C005617
;
ALTER TABLE T_E_MEETING_MESSAGE DROP CONSTRAINT SYS_C005616
;
ALTER TABLE JIVEMESSAGEPROP DROP CONSTRAINT SYS_C006107
;
ALTER TABLE JIVEUSERPROP DROP CONSTRAINT SYS_C006129
;
ALTER TABLE JIVEGROUPUSER DROP CONSTRAINT SYS_C006094
;
ALTER TABLE JIVEFILTER DROP CONSTRAINT SYS_C006076
;
ALTER TABLE JIVEUSER DROP CONSTRAINT SYS_C006121
;
ALTER TABLE JIVEMESSAGE DROP CONSTRAINT SYS_C006100
;
ALTER TABLE JIVEFORUM DROP CONSTRAINT SYS_C006079
;
ALTER TABLE T_EMP DROP CONSTRAINT SYS_C005811
;
DROP TABLE T_PERSON_COMING_MSG
;
DROP TABLE T_PRIVILEGE
;
DROP TABLE T_TRAINING_ATTANDENCE
;
DROP TABLE T_EQUIPMENT
;
DROP TABLE T_EMP_X_DUTY
;
DROP TABLE T_ADDRESSLIST_EMPLOYE
;
DROP TABLE T_SALARY_ITEMS
;
DROP TABLE T_EMP_X_DUTY_REMOVE_LOG
;
DROP TABLE T_CATEGORY
;
DROP TABLE T_PASS_READ_SENT_BOX
;
DROP TABLE T_DOCUMENTATION
;
DROP TABLE T_SUBTASK_X_FILE
;
DROP TABLE T_EQUIPMENT_ALLOWED_EMP
;
DROP TABLE T_EQUIPMENT_APPOINTMENT
;
DROP TABLE T_DOC_RECEIVED_TYPE
;
DROP TABLE T_ADDRESSLIST
;
DROP TABLE T_PUBLICATION
;
DROP TABLE T_EMPLOYEE_GROUP
;
DROP TABLE T_ARCHIVE_TYPE_SPEC
;
DROP TABLE T_DIRECTORY
;
DROP TABLE T_CONTACT_TASK
;
DROP TABLE T_AUTOMOBILE
;
DROP TABLE T_PASS_READ_INBOX
;
DROP TABLE T_RECEIVED_MESSAGE
;
DROP TABLE T_WORKFLOW_TEMPLATE_TYPE_SPEC
;
DROP TABLE JIVEUSERPERM
;
DROP TABLE T_PASS_READ_LOG
;
DROP TABLE T_DRIVER_X_AUTOMOBILE
;
DROP TABLE T_SUBTASK_STATUS_SPEC
;
DROP TABLE T_AUTOMOBILE_BOOKING
;
DROP TABLE T_PASS_READ_RECYLE_BOX
;
DROP TABLE HR_FORMAL
;
DROP TABLE T_ARCHIVE_ATTACHMENT
;
DROP TABLE T_EMP
;
DROP TABLE T_SENT_MESSAGE
;
DROP TABLE JIVEFORUMPROP
;
DROP TABLE T_CONTACT_X_GROUP
;
DROP TABLE T_DUTY_X_PRIVILEGE
;
DROP TABLE T_ADDRESSLIST_GROUP
;
DROP TABLE HR_SALARY_COMPONENT
;
DROP TABLE T_PASS_READ_OVER_BOX
;
DROP TABLE T_TASK_ATTACHMENT
;
DROP TABLE T_DUTY
;
DROP TABLE T_DIVISION
;
DROP TABLE HR_CONTRACT
;
DROP TABLE T_SUBTASK
;
DROP TABLE T_ACCIDENT
;
DROP TABLE HR_TRAIN_FEEDBACK
;
DROP TABLE JIVEGROUPPERM
;
DROP TABLE T_LEAVE_WORD
;
DROP TABLE T_SAFETY_DRIVING
;
DROP TABLE T_SUBTASK_TEMPLATE
;
DROP TABLE T_CONTACT_PERSON_NOTES
;
DROP TABLE T_WORKFLOW_TEMPLATE
;
DROP TABLE HR_MEMBER_INNER_RESUME
;
DROP TABLE T_EMPLOYEE_X_GROUP
;
DROP TABLE T_AUTOMOBILE_MAINTAIN
;
DROP TABLE T_CONFERENCE_X_FILES
;
DROP TABLE T_CONFERENCE_STATUS
;
DROP TABLE T_EXECUTOR_TEMPLATE
;
DROP TABLE T_WORKFLOW_STATUS_SPEC
;
DROP TABLE T_DOCRECEIVED_X_FILE
;
DROP TABLE T_WORKFLOW_TEMPLATE_X_FILE
;
DROP TABLE T_WORKFLOW
;
DROP TABLE HR_MEMBER_EDUCATIONAL_INFO
;
DROP TABLE T_EXECUTOR
;
DROP TABLE HR_DEV_TRAIN
;
DROP TABLE HR_MEMBER_SALARY
;
DROP TABLE T_TRAINNING_PROJECT
;
DROP TABLE T_AUTOMOBILE_TYPE
;
DROP TABLE T_WORKFLOW_INSTANCY_TYPE
;
DROP TABLE HR_DD
;
DROP TABLE T_DOC_RECEIVED
;
DROP TABLE JIVEGROUP
;
DROP TABLE HR_MEMBER_RESUME_INFO
;
DROP TABLE T_CONTRACT
;
DROP TABLE T_SALARY_ITEMS_SPEC
;
DROP TABLE T_WORKFLOW_X_FILE
;
DROP TABLE T_ATTENDANCE_LOG
;
DROP TABLE T_REGULATION
;
DROP TABLE T_EQUIPMENT_ALLOWED_DEPT
;
DROP TABLE T_EMP_X_PRIVILEGE
;
DROP TABLE T_DIRECTORIES_PERMISSION
;
DROP TABLE T_DIVISION_TYPE
;
DROP TABLE T_DISCUSSION_TOPIC
;
DROP TABLE T_CONFERENCE
;
DROP TABLE T_MSG_RECEIVER
;
DROP TABLE T_WORK_RECORD
;
DROP TABLE T_TASK
;
DROP TABLE T_ARCHIVE
;
DROP TABLE T_SUBTASK_TYPE_SPEC
;
DROP TABLE T_PROJECT_CHANGE
;
DROP TABLE T_BUDGET
;
DROP TABLE T_DEPT_MSG
;
DROP TABLE T_PERSON_SENT_MSG
;
DROP TABLE T_FILE
;
DROP TABLE T_DIRECTORIES
;
DROP TABLE JIVETHREAD
;
DROP TABLE T_PERSON_MSG
;
DROP TABLE T_PECCANCY
;
DROP TABLE JIVEMESSAGETREE
;
DROP TABLE T_CONTACT_COMPANY
;
DROP TABLE T_SALARY_ITEMS_LOG
;
DROP TABLE T_EMP_CHECK
;
DROP TABLE T_WORKFLOW_SECURITY_TYPE
;
DROP TABLE T_EQUIPMENT_REPAIR_RECORD
;
DROP TABLE T_SALARY_LOG
;
DROP TABLE T_MSG_RECEIVERS
;
DROP TABLE T_EQUIPMENT_PERSON_CONF
;
DROP TABLE T_DRIVER
;
DROP TABLE T_EXECUTOR_STATUS_SPEC
;
DROP TABLE T_BULLETIN
;
DROP TABLE T_WORKFLOW_TYPE_SPEC
;
DROP TABLE JIVEMESSAGEPROP
;
DROP TABLE T_BUDGET_LIST
;
DROP TABLE T_EQUIPMENT_USE_RECORD
;
DROP TABLE T_BOARDROOM_STATUS
;
DROP TABLE T_E_MEETING_ROOM
;
DROP TABLE JIVEUSERPROP
;
DROP TABLE JIVEGROUPUSER
;
DROP TABLE T_FILES
;
DROP TABLE T_AUTOMOBILE_BOOKING_STATUS
;
DROP TABLE T_PROJECT
;
DROP TABLE T_SALARY_TEMPLATE
;
DROP TABLE JIVEFILTER
;
DROP TABLE JIVEUSER
;
DROP TABLE T_PASS_READ_PASSING_BOX
;
DROP TABLE T_BORROW_RECORD
;
DROP TABLE T_CONTACT_PERSON
;
DROP TABLE T_RETURN_RECORD
;
DROP TABLE JIVEMESSAGE
;
DROP TABLE T_PASS_READ_ARTICAL
;
DROP TABLE HR_TRAIN
;
DROP TABLE T_DRIVING_FEE
;
DROP TABLE T_BOARDROOM
;
DROP TABLE T_WORKFLOW_DISPATCH
;
DROP TABLE HR_MEMBER_PRIVATE_INFO
;
DROP TABLE HR_SALARY_LIST
;
DROP TABLE T_OFF_DUTY_LOG
;
DROP TABLE T_TOPIC_X_MEETING_ROOM
;
DROP TABLE JIVEFORUM
;
DROP TABLE T_E_MEETING_MESSAGE
;
DROP TABLE T_ADDRESSLIST_BOOK
;
DROP TABLE T_EQUIPMENT_GROUP
;
DROP TABLE T_MSG_ATTACHMENT
;
DROP TABLE T_MSG_X_REC_ATTACHMENT
;
DROP TABLE T_MSG_X_SEND_ATTACHMENT
;
DROP TABLE T_DIV_ATT_TIME
;
DROP TABLE T_DIV_ATT_MODE
;