text: CREATE TABLE WB_BBS_FILE
  (
    FILE_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    CREATE_DATE {#DATETIME#} NOT NULL,
    FILE_NAME {#NVARCHAR#}(200) NOT NULL,
    FILE_SIZE {#NUMERIC#}(11) NOT NULL,
    FILE_CONTENT {#BLOB#}
  );
  CREATE TABLE WB_BBS_POST
  (
    POST_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    TITLE_ID {#VARCHAR#}(13) NOT NULL,
    POST_DATE {#DATETIME#} NOT NULL,
    POST_USER {#VARCHAR#}(13) NOT NULL,
    CONTENT {#NCLOB#}
  );
  CREATE INDEX WB_BBS_POST_TITLE_ID ON WB_BBS_POST(TITLE_ID);
  CREATE INDEX WB_BBS_POST_POST_DATE ON WB_BBS_POST(POST_DATE);
  CREATE TABLE WB_BBS_TITLE
  (
    TITLE_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    TITLE {#NVARCHAR#}(200) NOT NULL,
    SET_TOP {#NUMERIC#}(1) NOT NULL,
    CREATE_DATE {#DATETIME#} NOT NULL,
    MODIFY_DATE {#DATETIME#} NOT NULL,
    CREATE_USER {#VARCHAR#}(13) NOT NULL,
    REPLY_USER {#VARCHAR#}(13) NOT NULL,
    VIEW_COUNT {#NUMERIC#}(8) NOT NULL,
    REPLY_COUNT {#NUMERIC#}(8) NOT NULL,
    CONTENT {#NCLOB#}
  );
  CREATE INDEX WB_BBS_TITLE_KEY1 ON WB_BBS_TITLE(SET_TOP, MODIFY_DATE);
  CREATE INDEX WB_BBS_TITLE_CREATE_DATE ON WB_BBS_TITLE(CREATE_DATE);
  CREATE TABLE WB_COMPANY
  (
    COMPANY_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    COMPANY_NAME {#NVARCHAR#}(50),
    ADDR {#NVARCHAR#}(50),
    COUNTRY {#NVARCHAR#}(20),
    REMARK {#NCLOB#}
  );
  CREATE TABLE WB_DBM
  (
    S_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    OBJECT_NAME {#VARCHAR#}(100) NOT NULL,
    ROLE_NAME {#VARCHAR#}(13) NOT NULL,
    PERM_TYPE {#NUMERIC#}(1) NOT NULL
  );
  CREATE INDEX WB_DBM_OBJECT_NAME ON WB_DBM(OBJECT_NAME);
  CREATE TABLE WB_DEPT
  (
    DEPT_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    DEPT_NAME {#NVARCHAR#}(50) NOT NULL,
    PARENT_DEPT {#VARCHAR#}(13) NOT NULL,
    ORDER_INDEX {#NUMERIC#}(8) NOT NULL
  );
  CREATE INDEX WB_DEPT_PARENT_DEPT ON WB_DEPT(PARENT_DEPT);
  CREATE TABLE WB_DICT
  (
    FIELD_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    TABLE_NAME {#VARCHAR#}(50) NOT NULL,
    FIELD_NAME {#VARCHAR#}(50) NOT NULL,
    DISP_TEXT {#NVARCHAR#}(50),
    LINK_TO {#VARCHAR#}(100),
    DISP_WIDTH {#NUMERIC#}(5),
    DISP_FORMAT {#VARCHAR#}(20),
    KEY_NAME {#VARCHAR#}(50),
    FIELD_SIZE {#NUMERIC#}(8),
    DECIMAL_PRECISION {#NUMERIC#}(2),
    NO_LIST {#NUMERIC#}(1) NOT NULL,
    NO_EDIT {#NUMERIC#}(1) NOT NULL,
    AUTO_WRAP {#NUMERIC#}(1) NOT NULL,
    NO_BLANK {#NUMERIC#}(1) NOT NULL,
    READ_ONLY {#NUMERIC#}(1) NOT NULL,
    VALIDATOR {#NCLOB#},
    RENDERER {#NCLOB#}
  );
  CREATE UNIQUE INDEX WB_DICT_TABLE_NAME ON WB_DICT(TABLE_NAME,FIELD_NAME);
  CREATE TABLE WB_DUAL
  (
    DMY {#NUMERIC#}(1) NOT NULL
  );
  CREATE TABLE WB_EMPLOYEE
  (
    EMPLOYEE_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    EMPLOYEE_CODE {#VARCHAR#}(5) NOT NULL,
    REAL_NAME {#NVARCHAR#}(50) NOT NULL,
    BIRTH_DATE {#DATETIME#} NOT NULL,
    SEX {#VARCHAR#}(1) NOT NULL,
    DEPT_ID {#VARCHAR#}(13) NOT NULL,
    NATION {#VARCHAR#}(2),
    EMAIL {#VARCHAR#}(50),
    VACATION_HOURS {#NUMERIC#}(5),
    COMPANY_ID {#VARCHAR#}(13),
    REMARK {#NCLOB#}
  );
  CREATE UNIQUE INDEX WB_EMPLOYEE_EMPLOYEE_CODE ON WB_EMPLOYEE(EMPLOYEE_CODE);
  CREATE INDEX WB_EMPLOYEE_DEPT_ID ON WB_EMPLOYEE(DEPT_ID);
  CREATE TABLE WB_EMPLOYEE_DEPT
  (
    DEPT_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    DEPT_NAME {#NVARCHAR#}(50) NOT NULL,
    PARENT_DEPT {#VARCHAR#}(13) NOT NULL,
    ORDER_INDEX {#NUMERIC#}(5) NOT NULL
  );
  CREATE INDEX WB_EMPLOYEE_DEPT_PARENT_DEPT ON WB_EMPLOYEE_DEPT(PARENT_DEPT);
  CREATE TABLE WB_FLOW
  (
    FLOW_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    FLOW_DATA {#NCLOB#} NOT NULL
  );
  CREATE TABLE WB_FLOW_DEMO
  (
    S_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    REC_DATE {#DATETIME#} NOT NULL,
    USER_ID {#VARCHAR#}(13) NOT NULL,
    FEE1 {#NUMERIC#}(8,2) NOT NULL,
    FEE2 {#NUMERIC#}(8,2) NOT NULL,
    FEE3 {#NUMERIC#}(8,2) NOT NULL,
    REMARK {#NVARCHAR#}(255)
  );
  CREATE TABLE WB_FLOW_LIST
  (
    LIST_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    FLOW_ID {#VARCHAR#}(13) NOT NULL,
    NODE_NAME {#NVARCHAR#}(100) NOT NULL,
    TITLE {#NVARCHAR#}(255) NOT NULL,
    START_DATE {#DATETIME#} NOT NULL,
    START_USER_ID {#VARCHAR#}(13) NOT NULL,
    START_USER_DISP_NAME {#NVARCHAR#}(50) NOT NULL, 
    LAST_MODIFY_DATE {#DATETIME#} NOT NULL,
    LAST_USER_ID {#VARCHAR#}(13) NOT NULL,
    LAST_USER_DISP_NAME {#NVARCHAR#}(50) NOT NULL, 
    FLOW_NAME {#NVARCHAR#}(255) NOT NULL,
    STATUS {#NUMERIC#}(2) NOT NULL
  );
  CREATE INDEX WB_FLOW_LIST_FLOW_ID ON WB_FLOW_LIST(FLOW_ID);
  CREATE INDEX WB_FLOW_LIST_LMD ON WB_FLOW_LIST(LAST_MODIFY_DATE);
  CREATE TABLE WB_FLOW_USER
  (
    S_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    FLOW_ID {#VARCHAR#}(13) NOT NULL,
    USER_ID {#VARCHAR#}(13) NOT NULL,
    NEED_PROCESS {#NUMERIC#}(1) NOT NULL,
    IS_PROCESSED {#NUMERIC#}(1) NOT NULL,
    IS_CC {#NUMERIC#}(1) NOT NULL
  );
  CREATE INDEX WB_FLOW_USER_FLOW_ID ON WB_FLOW_USER(FLOW_ID);
  CREATE INDEX WB_FLOW_USER_USER_ID ON WB_FLOW_USER(USER_ID);
  CREATE TABLE WB_IM
  (
    IM_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    SEND_DATE {#DATETIME#} NOT NULL,
    FROM_USER {#VARCHAR#}(13) NOT NULL,
    TO_USER {#VARCHAR#}(13) NOT NULL,
    NOT_READ {#NUMERIC#}(1) NOT NULL,
    FILE_NAME {#NVARCHAR#}(255),
    FILE_SIZE {#NUMERIC#}(12),
    TEXT_CONTENT {#NCLOB#},
    BLOB_CONTENT {#BLOB#}
  );
  CREATE INDEX WB_IM_FROM_USER ON WB_IM(FROM_USER);
  CREATE INDEX WB_IM_TO_USER ON WB_IM(TO_USER);
  CREATE INDEX WB_IM_NOT_READ ON WB_IM(NOT_READ);
  CREATE TABLE WB_KEY
  (
    R_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    KEY_ID {#VARCHAR#}(13) NOT NULL,
    K {#VARCHAR#}(50) NOT NULL,
    V {#NVARCHAR#}(200) NOT NULL
  );
  CREATE UNIQUE INDEX WB_KEY_KEY_NAME ON WB_KEY(KEY_ID,K);
  CREATE TABLE WB_KEY_TREE
  (
    KEY_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    KEY_NAME {#NVARCHAR#}(50) NOT NULL,
    TYPE {#NUMERIC#}(1) NOT NULL,
    PARENT_ID {#VARCHAR#}(13) NOT NULL
  );
  CREATE UNIQUE INDEX WB_KEY_TREE_UNQ1 ON WB_KEY_TREE(PARENT_ID,KEY_NAME);
  CREATE TABLE WB_LOG
  (
    LOG_DATE {#DATETIME#} NOT NULL,
    USER_NAME {#NVARCHAR#}(50) NOT NULL,
    IP {#VARCHAR#}(50) NOT NULL,
    LOG_TYPE {#NUMERIC#}(1) NOT NULL,
    MSG {#NVARCHAR#}(255) NOT NULL
  );
  CREATE INDEX WB_LOG_LOG_DATE ON WB_LOG(LOG_DATE);
  CREATE TABLE WB_MISC
  (
    ID_FIELD {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    STRING_FIELD {#NVARCHAR#}(20) NOT NULL,
    INT_FIELD {#NUMERIC#}(8),
    DOUBLE_FIELD {#NUMERIC#}(8,2),
    BOOL_FIELD {#NUMERIC#}(1),
    DATETIME_FIELD {#DATETIME#},
    CLOB_FIELD {#NCLOB#},
    BLOB_FIELD {#BLOB#}
  );
  CREATE TABLE WB_PAGING
  (
    V {#NUMERIC#}(5) NOT NULL
  );
  CREATE INDEX WB_PAGING_V ON WB_PAGING(V);
  CREATE TABLE WB_PERSON(
    PERSON_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    USER_ID {#VARCHAR#}(13),
    DEPT_ID {#VARCHAR#}(13) NOT NULL,
    PERSON_CODE VARCHAR(10) NOT NULL,
    PERSON_NAME {#NVARCHAR#}(50) NOT NULL,
    SEX {#VARCHAR#}(1),
    BIRTHDATE {#DATETIME#},
    NATION {#VARCHAR#}(2),
    EDU {#VARCHAR#}(1),
    SCHOOL {#NVARCHAR#}(100),
    MAJOR {#NVARCHAR#}(100),
    MOBILE_PHONE {#VARCHAR#}(30),
    ADDR {#NVARCHAR#}(200),
    REMARK {#NCLOB#},
    PIC {#BLOB#}
  );
  CREATE INDEX WB_PERSON_USER_ID ON WB_PERSON(USER_ID);
  CREATE INDEX WB_PERSON_DEPT_ID ON WB_PERSON(DEPT_ID);
  CREATE UNIQUE INDEX WB_PERSON_PERSON_CODE ON WB_PERSON(PERSON_CODE);
  CREATE INDEX WB_PERSON_PERSON_NAME ON WB_PERSON(PERSON_NAME);
  CREATE TABLE WB_REGION
  (
    REGION_ID {#VARCHAR#}(6) NOT NULL PRIMARY KEY,
    PARENT_ID {#VARCHAR#}(6) NOT NULL,
    CAPTION {#NVARCHAR#}(30) NOT NULL,
    MANAGER_CAPTION {#NVARCHAR#}(60) NOT NULL,
    SHORT_CAPTION {#NVARCHAR#}(30) NOT NULL,
    MANGER_SHORT_CAPTION {#NVARCHAR#}(30) NOT NULL,
    LEVEL_TYPE {#NUMERIC#}(1) NOT NULL,
    CITY_CODE {#VARCHAR#}(4),
    ZIP_CODE {#VARCHAR#}(6),
    PIN_YIN {#VARCHAR#}(20) NOT NULL,
    JIAN_PIN {#VARCHAR#}(10) NOT NULL,
    FIRST_CHAR {#VARCHAR#}(1) NOT NULL,
    LNG {#VARCHAR#}(12) NOT NULL,
    LAT {#VARCHAR#}(12) NOT NULL,
    REMARK {#NVARCHAR#}(30)
  );
  CREATE INDEX WB_REGION_PARENT_ID ON WB_REGION(PARENT_ID);
  CREATE TABLE WB_REPORT_DEMO
  (
    ROW_NUM {#NUMERIC#}(5) NOT NULL PRIMARY KEY,
    F1 {#NCLOB#},
    F2 {#NVARCHAR#}(200),
    F3 {#NUMERIC#}(8),
    F4 {#NUMERIC#}(8,2),
    F5 {#DATETIME#},
    F6 {#NUMERIC#}(8,5),
    F7 {#NUMERIC#}(8),
    F8 {#NUMERIC#}(8),
    F9 {#NUMERIC#}(8),
    F10 {#NUMERIC#}(8)
  );
  CREATE TABLE WB_RESOURCE
  (
    RES_ID {#VARCHAR#}(80) NOT NULL PRIMARY KEY,
    RES_CONTENT {#BLOB#}
  );
  CREATE TABLE WB_ROLE
  (
    ROLE_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    ROLE_NAME {#NVARCHAR#}(50) NOT NULL,
    REMARK {#NVARCHAR#}(200) NOT NULL,
    STATUS {#NUMERIC#}(1) NOT NULL
  );
  CREATE UNIQUE INDEX WB_ROLE_ROLE_NAME ON WB_ROLE(ROLE_NAME);
  CREATE INDEX WB_ROLE_STATUS ON WB_ROLE(STATUS);
  CREATE TABLE WB_SN
  (
    SN_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    SN_CODE {#VARCHAR#}(23) NOT NULL,
    AUTH_NAME {#NVARCHAR#}(200) NOT NULL,
    SN_PRICE {#NUMERIC#}(8) NOT NULL,
    SN_COUNT {#NUMERIC#}(5) NOT NULL,
    SN_TOTAL {#NUMERIC#}(9) NOT NULL,
    REG_DATE {#DATETIME#} NOT NULL,
    CONTACT {#NVARCHAR#}(50),
    EMAIL {#VARCHAR#}(100) NOT NULL,
    PHONE {#VARCHAR#}(30) NOT NULL,
    ADDRESS {#NVARCHAR#}(200) NOT NULL,
    SUPPORT {#NUMERIC#}(1) NOT NULL,
    STATUS {#NUMERIC#}(1) NOT NULL,
    REMARK {#NVARCHAR#}(200)
  );
  CREATE UNIQUE INDEX WB_SN_SN_CODE ON WB_SN(SN_CODE);
  CREATE TABLE WB_STAFF
  (
    KEY_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    USER_ID {#VARCHAR#}(13) NOT NULL,
    REAL_NAME {#NVARCHAR#}(100) NOT NULL,
    BIRTHDATE {#DATETIME#},
    EDU {#VARCHAR#}(1),
    NATION {#VARCHAR#}(2),
    TEL {#VARCHAR#}(30),
    EMAIL {#VARCHAR#}(100)
  );
  CREATE INDEX WB_STAFF_USER_ID ON WB_STAFF(USER_ID);
  CREATE TABLE WB_SYS1
  (
    SYS_IP {#VARCHAR#}(50) NOT NULL PRIMARY KEY
  );
  CREATE TABLE WB_SYS2
  (
    SYS_DATE {#DATETIME#} NOT NULL,
    SYS_IP {#VARCHAR#}(50) NOT NULL,
    SYS_TITLE {#NVARCHAR#}(200),
    SYS_SN {#VARCHAR#}(23)
  );
  CREATE INDEX WB_SYS2_SYS_DATE ON WB_SYS2(SYS_DATE);
  CREATE TABLE WB_TASK
  (
    TASK_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    TASK_NAME {#NVARCHAR#}(80) NOT NULL,
    INTERVAL_TYPE {#NUMERIC#}(1) NOT NULL,
    INTERVAL_EXPRESS {#VARCHAR#}(10) NOT NULL,
    CLASS_NAME {#VARCHAR#}(200),
    SERVER_SCRIPT {#NCLOB#},
    BEGIN_DATE {#DATETIME#},
    END_DATE {#DATETIME#},
    STATUS {#NUMERIC#}(1) NOT NULL,
    REMARK {#NVARCHAR#}(255)
  );
  CREATE UNIQUE INDEX WB_TASK_TASK_NAME ON WB_TASK(TASK_NAME);
  CREATE TABLE WB_USER
  (
    USER_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    USER_NAME {#NVARCHAR#}(50) NOT NULL,
    DISPLAY_NAME {#NVARCHAR#}(50) NOT NULL,
    PASSWORD {#VARCHAR#}(32) NOT NULL,
    STATUS {#NUMERIC#}(1) NOT NULL,
    CREATE_DATE {#DATETIME#} NOT NULL,
    LOGIN_TIMES {#NUMERIC#}(9) NOT NULL,
    EMAIL {#VARCHAR#}(100),
    USE_LANG {#VARCHAR#}(10),
    LAST_LOGIN {#DATETIME#}
  );
  CREATE UNIQUE INDEX WB_USER_USER_NAME ON WB_USER(USER_NAME);
  CREATE INDEX WB_USER_DISPLAY_NAME ON WB_USER(DISPLAY_NAME);
  CREATE INDEX WB_USER_STATUS ON WB_USER(STATUS);
  CREATE TABLE WB_USER_ROLE
  (
    USER_ID {#VARCHAR#}(13) NOT NULL,
    ROLE_ID {#VARCHAR#}(13) NOT NULL
  );
  CREATE INDEX WB_USER_ROLE_USER_ID ON WB_USER_ROLE(USER_ID);
  CREATE INDEX WB_USER_ROLE_ROLE_ID ON WB_USER_ROLE(ROLE_ID);
  CREATE TABLE WB_VALUE
  (
    VAL_ID {#VARCHAR#}(80) NOT NULL PRIMARY KEY,
    VAL_CONTENT {#VARCHAR#}(255)
  );
  CREATE TABLE WB_VERSION
  (
    S_ID {#VARCHAR#}(13) NOT NULL PRIMARY KEY,
    CHECK_DATE {#DATETIME#} NOT NULL,
    FILE_DATE {#DATETIME#} NOT NULL,
    FILE_PATH {#NVARCHAR#}(255) NOT NULL,
    USER_ID {#VARCHAR#}(13) NOT NULL,
    VERSION {#VARCHAR#}(10) NOT NULL,
    VERSION_DESC {#NVARCHAR#}(200),
    FILE_BLOB {#BLOB#}
  );
  CREATE INDEX WB_VERSION_CHECK_DATE ON WB_VERSION(CHECK_DATE);
  CREATE INDEX WB_VERSION_VERSION ON WB_VERSION(VERSION);
  CREATE INDEX WB_VERSION_FILE_PATH ON WB_VERSION(FILE_PATH);