schema-export-sys.sql

一段很有意义的源码,看了就知道,不信试一试啊!

drop table ACTION_RESOURCE;
drop table APP_NODE;
drop table APP_NODE_USER;
drop table CF_MODEL;
drop table CF_TIME;
drop table CF_WORK;
drop table CF_WORKSPACE;
drop table CODE_INFO;
drop table CODE_TYPE;
drop table CUSTOM_RESOURCE;
drop table DIR_RESOURCE;
drop table FILE_RESOURCE;
drop table MENU_RESOURCE;
drop table NODE_USER;
drop table ORGAN_MODEL;
drop table ORGAN_NODE;
drop table ORGAN_RELATION;
drop table ORG_DEPARTMENT;
drop table ORG_POSITIONS;
drop table ORG_POST_USER;
drop table ORG_TYPE;
drop table PORTLET_RESOURCE;
drop table RESOURCE_GROUP;
drop table SC_ACC_PERMISSION;
drop table SC_ACL_OPERATION;
drop table SC_ACL_PERMISSION;
drop table SC_ACL_RESOURCE;
drop table SC_ACL_RES_TYPE;
drop table SC_EXT_PROPERTY;
drop table SC_GROUP;
drop table SC_GROUP_ROLE;
drop table SC_PROXY_USER;
drop table SC_PUB_PERMISSION;
drop table SC_REV_PERMISSION;
drop table SC_ROLE;
drop table SC_USER;
drop table SC_USER_GROUP;
drop table SC_USER_ROLE;
drop table TREE_RESOURCE;
drop table URL_RESOURCE;
drop table WORKSPACE_ARCHIVE;
drop table WORKSPACE_PERSON;
create table ACTION_RESOURCE (ID bigint generated by default as identity, DESCRIPTION varchar(255), PARENT_RESOURCE_ID bigint, RESOURCE_NAME varchar(255), primary key (ID));
create table APP_NODE (ID bigint not null, COMPATABLE smallint, CENTRAL_NODE_ID bigint, APP_SERVER varchar(255), CODE varchar(100), DB_SERVER varchar(255), DESCRIPTION varchar(255), INDEX_URL varchar(255), IS_CUTE_SERIES smallint, NAME varchar(255), NODE_TYPE bigint not null, VENDOR varchar(255), VERSION varchar(255), ORGAN_ID bigint, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, primary key (ID));
create table APP_NODE_USER (APP_NODE_ID bigint not null, USER_ID bigint not null, primary key (USER_ID, APP_NODE_ID));
create table CF_MODEL (PROCESS_ID varchar(255) not null, DESCRIPTION varchar(255), MODEL_ID varchar(255), NAME varchar(255), PUBLISH_STATE varchar(255), VERSION bigint, primary key (PROCESS_ID));
create table CF_TIME (ID bigint generated by default as identity, ACTIIVTY_ID varchar(255), AINSTANCE_ID varchar(255), PINSTANCE_ID varchar(255), START_TIME bigint, EXPECT_TIME bigint, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, primary key (ID));
create table CF_WORK (ID varchar(255) not null, AINSTANCE_ID varchar(255), CINSTANCE_ID varchar(255), CONTAINER_ID varchar(255), CONTAINER_NAME varchar(255), PINSTANCE_ID varchar(255), TYPE bigint, WORKITEM_ID bigint, primary key (ID));
create table CF_WORKSPACE (WORKITEM_ID bigint generated by default as identity, ACTIVITY_ID varchar(255), ACTIVITY_NAME varchar(255), AINSTANCE_ID varchar(255), DEADLINE varchar(255), OUTER_ID varchar(255), PINSTANCE_ID varchar(255), PMODEL_ID varchar(255), WORK_DESC varchar(255), WORK_STATE bigint, primary key (WORKITEM_ID));
create table CODE_INFO (ID bigint not null, CODE_INFO_ID bigint, TYPE_ID bigint, DISP_ORDER integer, REMARK1 varchar(255), REMARK2 varchar(255), OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, CODE varchar(100), NAME varchar(255) not null, DESCRIPTION varchar(255), primary key (ID));
create table CODE_TYPE (ID bigint not null, SYSTEM_TYPE integer, DISP_ORDER integer, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, CODE varchar(100), NAME varchar(255) not null, DESCRIPTION varchar(255), primary key (ID));
create table CUSTOM_RESOURCE (ID bigint not null, CODE varchar(100), DESCRIPTION varchar(255), PARENT_RESOURCE_ID bigint, NAME varchar(255), ACL_RES_TYPE_ID bigint, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, primary key (ID));
create table DIR_RESOURCE (ID bigint generated by default as identity, PARENT_RESOURCE_ID bigint, RESOURCE_NAME varchar(255), DESCRIPTION varchar(255), primary key (ID));
create table FILE_RESOURCE (ID bigint generated by default as identity, DESCRIPTION varchar(255), RESOURCE_NAME varchar(255), PARENT_RESOURCE_ID bigint, primary key (ID));
create table MENU_RESOURCE (ID bigint not null, BIG_IMAGE bigint, DESCRIPTION varchar(255), DISP_ORDER integer, LINKPATH varchar(100), RESOURCE_NAME varchar(255), PARENT_RESOURCE_ID bigint, SMALL_IMAGE bigint, BACKUP_IMAGE varchar(100), BACKUP_IMAGE2 varchar(100), primary key (ID));
create table NODE_USER (ORGAN_NODE_ID bigint not null, SECURITY_USER_ID bigint not null, primary key (SECURITY_USER_ID, ORGAN_NODE_ID));
create table ORGAN_MODEL (ID bigint not null, CHILD_NODE_ID bigint, CREATE_TIME timestamp, NAME varchar(255) not null, PARENT_NODE_ID bigint, ORGAN_REALTION_ID bigint, DESCRIPTION varchar(255), OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, primary key (ID));
create table ORGAN_NODE (ID bigint not null, CREATE_TIME timestamp, ORG_TYPE bigint, RANK varchar(255), ICON bigint, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, CODE varchar(100), NAME varchar(255) not null, DESCRIPTION varchar(255), primary key (ID));
create table ORGAN_RELATION (ID bigint not null, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, CODE varchar(100), NAME varchar(255) not null, DESCRIPTION varchar(255), primary key (ID));
create table ORG_DEPARTMENT (ID bigint generated by default as identity, ADDRESS varchar(255), DESCRIPTION varchar(255), ENG_NAME varchar(255), NAME varchar(100) not null, PARENT_ID bigint, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, primary key (ID));
create table ORG_POSITIONS (ID bigint generated by default as identity, DEPT_ID bigint, DESCRIPTION varchar(255), ENG_NAME varchar(255), NAME varchar(255), PARENT_ID bigint, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, primary key (ID));
create table ORG_POST_USER (POST_ID bigint not null, USER_ID bigint not null, primary key (POST_ID, USER_ID));
create table ORG_TYPE (ID bigint not null, DOWN integer, IMAGE varchar(50), PEOPLE integer, IS_TOP integer, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, CODE varchar(100), NAME varchar(255) not null, DESCRIPTION varchar(255), primary key (ID));
create table PORTLET_RESOURCE (ID bigint generated by default as identity, PARENT_RESOURCE_ID bigint, RESOURCE_NAME varchar(255), DESCRIPTION varchar(255), primary key (ID));
create table RESOURCE_GROUP (ID bigint not null, ACL_RES_TYPE_ID bigint, CLASS_NAME varchar(255) not null, CODE varchar(100), DESCRIPTION varchar(255), NAME varchar(255), PROP_VALUES varchar(255), OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, primary key (ID));
create table SC_ACC_PERMISSION (ACL_PERMISSION_ID bigint not null, SECURITY_ROLE_ID bigint not null, primary key (SECURITY_ROLE_ID, ACL_PERMISSION_ID));
create table SC_ACL_OPERATION (ID bigint not null, CODE varchar(100), NAME varchar(255) not null, DESCRIPTION varchar(255), ACL_RES_TYPE_ID bigint, OPERATE_TIME bigint, OPERATOR varchar(50), REMOVED integer, primary key (ID));
create table SC_ACL_PERMISSION (ID bigint not null, ACL_OPERATION_ID bigint, ACL_RESOURCE_ID bigint, DUE_TIME timestamp, primary key (ID));