DROP TABLE IF EXISTS ACCOUNT;
DROP TABLE IF EXISTS ACTIVITY;
DROP TABLE IF EXISTS CODE;
DROP TABLE IF EXISTS CODE_TYPE;
DROP TABLE IF EXISTS CONTACT;
DROP TABLE IF EXISTS CUSTOMER;
DROP TABLE IF EXISTS CUST_ACCT;
DROP TABLE IF EXISTS ISSUE;
DROP TABLE IF EXISTS ORDER_FORM;
DROP TABLE IF EXISTS ORDER_ITEM;
DROP TABLE IF EXISTS PERMISSION;
DROP TABLE IF EXISTS RESOURCES;
DROP TABLE IF EXISTS PERMS_RESRC;
DROP TABLE IF EXISTS PRODUCT;
DROP TABLE IF EXISTS ROLE;
DROP TABLE IF EXISTS ROLE_PERMS;
DROP TABLE IF EXISTS SUPPORT;
DROP TABLE IF EXISTS USER;
DROP TABLE IF EXISTS USER_ROLE;

CREATE TABLE ACCOUNT (
  ACCT_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  ACCT_NAME VARCHAR(50) NOT NULL,
  PHONE_WORK VARCHAR(50) DEFAULT NULL,
  PHONE_HOME VARCHAR(50) DEFAULT NULL,
  PHONE_MOBILE VARCHAR(50) DEFAULT NULL,
  EMAIL VARCHAR(255) DEFAULT NULL,
  MSN VARCHAR(255) DEFAULT NULL,
  QQ VARCHAR(20) DEFAULT NULL,
  DEPARTMENT VARCHAR(50) DEFAULT NULL,
  DUTY VARCHAR(50) DEFAULT NULL,
  REMARKS CHARACTER,
  CREATE_BY VARCHAR(32) DEFAULT NULL,
  CREATE_DTTM DATETIME NOT NULL,
  LAST_UPDATE_BY VARCHAR(32) DEFAULT NULL,
  LAST_UPDATE_DTTM DATETIME NOT NULL,
  PRIMARY KEY  (ACCT_ID)
);

CREATE TABLE ACTIVITY (
  ACTI_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  ACCT_ID INTEGER NOT NULL,
  CUST_ID INTEGER DEFAULT NULL,
  CONT_ID INTEGER DEFAULT NULL,
  ACTI_TYPE VARCHAR(20) DEFAULT NULL,
  SUMMARY VARCHAR(1024) NOT NULL,
  REMARKS CHARACTER,
  START_DTTM DATETIME DEFAULT NULL,
  END_DTTM DATETIME DEFAULT NULL,
  PRIORITY VARCHAR(20) DEFAULT NULL,
  COMPLETED BOOLEAN DEFAULT NULL,
  CREATE_BY VARCHAR(32) DEFAULT NULL,
  CREATE_DTTM DATETIME NOT NULL,
  LAST_UPDATE_BY VARCHAR(32) DEFAULT NULL,
  LAST_UPDATE_DTTM DATETIME NOT NULL,
  PRIMARY KEY  (ACTI_ID)
);

CREATE TABLE CODE (
  CODE_TYPE_ID VARCHAR(20) NOT NULL,
  CODE_ID VARCHAR(20) NOT NULL,
  CODE_DESC VARCHAR(255) DEFAULT NULL,
  CODE_SEQ INTEGER NOT NULL,
  STATUS CHAR(1) NOT NULL,
  CREATE_BY VARCHAR(32) NOT NULL,
  CREATE_DTTM DATETIME NOT NULL,
  LAST_UPDATE_BY VARCHAR(32) NOT NULL,
  LAST_UPDATE_DTTM DATETIME NOT NULL,
  PRIMARY KEY  (CODE_TYPE_ID,CODE_ID)
);

CREATE TABLE CODE_TYPE (
  CODE_TYPE_ID VARCHAR(20) NOT NULL,
  CODE_TYPE_DESC VARCHAR(255) DEFAULT NULL,
  CREATE_BY VARCHAR(32) NOT NULL,
  CREATE_DTTM DATETIME NOT NULL,
  LAST_UPDATE_BY VARCHAR(32) NOT NULL,
  LAST_UPDATE_DTTM DATETIME NOT NULL,
  PRIMARY KEY  (CODE_TYPE_ID)
);

CREATE TABLE CONTACT (
  CONT_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  CUST_ID INTEGER DEFAULT NULL,
  CONT_NAME VARCHAR(50) NOT NULL,
  SEX CHAR(1) DEFAULT NULL,
  DUTY VARCHAR(50) DEFAULT NULL,
  PHONE_WORK VARCHAR(50) DEFAULT NULL,
  PHONE_HOME VARCHAR(50) DEFAULT NULL,
  PHONE_MOBILE VARCHAR(50) DEFAULT NULL,
  EMAIL VARCHAR(255) DEFAULT NULL,
  MSN VARCHAR(255) DEFAULT NULL,
  QQ VARCHAR(20) DEFAULT NULL,
  REMARKS CHARACTER,
  CREATE_BY VARCHAR(32) DEFAULT NULL,
  CREATE_DTTM DATETIME NOT NULL,
  LAST_UPDATE_BY VARCHAR(32) DEFAULT NULL,
  LAST_UPDATE_DTTM DATETIME NOT NULL,
  PRIMARY KEY  (CONT_ID)
);

CREATE TABLE CUSTOMER (
  CUST_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  CUST_NAME VARCHAR(1024) NOT NULL,
  CUST_TYPE VARCHAR(20) DEFAULT NULL,
  ADDRESS VARCHAR(1024) DEFAULT NULL,
  POSTCODE VARCHAR(6) DEFAULT NULL,
  FAX VARCHAR(50) DEFAULT NULL,
  PROVINCE VARCHAR(50) DEFAULT NULL,
  CITY VARCHAR(50) DEFAULT NULL,
  COUNTY VARCHAR(50) DEFAULT NULL,
  INDUSTRY VARCHAR(50) DEFAULT NULL,
  WEBSITE VARCHAR(1024) DEFAULT NULL,
  ATTACHMENT VARCHAR(1024) DEFAULT NULL,
  NET_DESC CHARACTER,
  APP_DESC CHARACTER,
  REMARKS CHARACTER,
  ASSIGNED_ACCT_ID VARCHAR(32) DEFAULT NULL,
  CREATE_BY VARCHAR(32) DEFAULT NULL,
  CREATE_DTTM DATETIME NOT NULL,
  LAST_UPDATE_BY VARCHAR(32) DEFAULT NULL,
  LAST_UPDATE_DTTM DATETIME NOT NULL,
  PRIMARY KEY  (CUST_ID)
);

CREATE TABLE CUST_ACCT (
  CUST_ID INTEGER NOT NULL,
  ACCT_ID INTEGER NOT NULL
);

CREATE TABLE ISSUE (
  ISSUE_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  SPT_ID INTEGER DEFAULT NULL,
  PROD_ID INTEGER DEFAULT NULL,
  ISSUE_TYPE VARCHAR(255) DEFAULT NULL,
  SUMMARY VARCHAR(1024) NOT NULL,
  DESCRIPTION CHARACTER,
  RESOLUTION CHARACTER,
  STATUS VARCHAR(50) DEFAULT NULL,
  DUE_DATE DATETIME DEFAULT NULL,
  CREATE_BY VARCHAR(32) DEFAULT NULL,
  CREATE_DTTM DATETIME NOT NULL,
  LAST_UPDATE_BY VARCHAR(32) DEFAULT NULL,
  LAST_UPDATE_DTTM DATETIME NOT NULL,
  PRIMARY KEY  (ISSUE_ID)
);

CREATE TABLE ORDER_FORM (
  ORDER_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  CUST_ID INTEGER DEFAULT NULL,
  CONT_ID INTEGER DEFAULT NULL,
  ACCT_ID INTEGER DEFAULT NULL,
  PROJ_NAME VARCHAR(255) DEFAULT NULL,
  ADDRESS VARCHAR(1024) DEFAULT NULL,
  ACCT_NUM VARCHAR(255) DEFAULT NULL,
  TAX_NUM VARCHAR(255) DEFAULT NULL,
  ORDER_DATE DATE DEFAULT NULL,
  CREATE_BY VARCHAR(32) DEFAULT NULL,
  CREATE_DTTM DATETIME NOT NULL,
  LAST_UPDATE_BY VARCHAR(32) DEFAULT NULL,
  LAST_UPDATE_DTTM DATETIME NOT NULL,
  PRIMARY KEY  (ORDER_ID)
);

CREATE TABLE ORDER_ITEM (
  ORDER_ID INTEGER DEFAULT NULL,
  PROD_ID INTEGER NOT NULL,
  SEQUENCE INTEGER DEFAULT NULL,
  AMOUNT INTEGER NOT NULL,
  START_DATE DATE DEFAULT NULL,
  USE_END_DATE DATE DEFAULT NULL,
  SERV_END_DATE DATE DEFAULT NULL,
  USE_REMIND_EMAIL_CD VARCHAR(2) DEFAULT NULL,
  SERV_REMIND_EMAIL_CD VARCHAR(2) DEFAULT NULL
);

CREATE TABLE PERMISSION (
  PERMS_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  PERMS_NAME VARCHAR(50) NOT NULL,
  PERMS_DESC VARCHAR(1024) DEFAULT NULL,
  OPERATION VARCHAR(255) DEFAULT NULL,
  STATUS VARCHAR(50) DEFAULT NULL,
  PRIMARY KEY  (PERMS_ID)
);

CREATE TABLE RESOURCES (
  RESRC_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  RESRC_NAME VARCHAR(255) NOT NULL,
  RESRC_TYPE VARCHAR(50) NOT NULL,
  RESRC_STRING VARCHAR(255) NOT NULL,
  RESRC_DESC VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY  (RESRC_ID)
);

CREATE TABLE PERMS_RESRC (
  PERMS_ID INTEGER NOT NULL,
  RESRC_ID INTEGER NOT NULL
);

CREATE TABLE PRODUCT (
  PROD_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  MANUFACTURER VARCHAR(255) DEFAULT NULL,
  PROD_NAME VARCHAR(255) NOT NULL,
  PROD_TYPE VARCHAR(255) DEFAULT NULL,
  PROD_MODEL VARCHAR(255) DEFAULT NULL,
  PROD_SPEC VARCHAR(255) DEFAULT NULL,
  PROD_STATUS VARCHAR(20) DEFAULT NULL,
  REMARKS CHARACTER,
  CREATE_BY VARCHAR(32) DEFAULT NULL,
  CREATE_DTTM DATETIME NOT NULL,
  LAST_UPDATE_BY VARCHAR(32) DEFAULT NULL,
  LAST_UPDATE_DTTM DATETIME NOT NULL,
  PRIMARY KEY  (PROD_ID)
);

CREATE TABLE ROLE (
  ROLE_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  ROLE_NAME VARCHAR(50) NOT NULL,
  ROLE_DESC VARCHAR(1024) DEFAULT NULL,
  PRIMARY KEY  (ROLE_ID)
);

CREATE TABLE ROLE_PERMS (
  ROLE_ID INTEGER NOT NULL,
  PERMS_ID INTEGER NOT NULL
);

CREATE TABLE SUPPORT (
  SPT_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  ACCT_ID INTEGER NOT NULL,
  CUST_ID INTEGER DEFAULT NULL,
  CONT_ID INTEGER DEFAULT NULL,
  SPT_TYPE VARCHAR(100) DEFAULT NULL,
  SUMMARY VARCHAR(1024) NOT NULL,
  REMARKS CHARACTER,
  START_DTTM DATETIME DEFAULT NULL,
  END_DTTM DATETIME DEFAULT NULL,
  PRIORITY VARCHAR(50) DEFAULT NULL,
  COMPLETED BOOLEAN DEFAULT NULL,
  CREATE_BY VARCHAR(32) DEFAULT NULL,
  CREATE_DTTM DATETIME NOT NULL,
  LAST_UPDATE_BY VARCHAR(32) DEFAULT NULL,
  LAST_UPDATE_DTTM DATETIME NOT NULL,
  PRIMARY KEY  (SPT_ID)
);

CREATE TABLE USER (
  USER_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
  USER_NAME VARCHAR(50) NOT NULL,
  USER_PASSWORD VARCHAR(50) NOT NULL,
  STATUS INTEGER DEFAULT NULL,
  LAST_LOGIN_TIME DATETIME DEFAULT NULL,
  LAST_LOGIN_IP VARCHAR(50) DEFAULT NULL,
  PRIMARY KEY  (USER_ID)
);

CREATE TABLE USER_ROLE (
  USER_ID INTEGER NOT NULL,
  ROLE_ID INTEGER NOT NULL
);

INSERT INTO account (ACCT_ID, ACCT_NAME, PHONE_WORK, PHONE_HOME, PHONE_MOBILE, EMAIL, MSN, QQ, DEPARTMENT, DUTY, REMARKS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES 
  (1,'admin',NULL,'','','admin@admin.com','','','','','',NULL,'2006-05-31 19:30:10',NULL,'2006-05-31 19:30:10');

COMMIT;


INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('ACTI_TYPE','FIRST_TEL','初次电话访问',1,'A','SYSTEM','2006-04-23','SYSTEM','2006-05-27 20:13:28');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('CUSTOMER_TYPE','AGENT','代理商',1,'A','SYSTEM','2006-03-15 19:11:40','SYSTEM','2006-05-13 14:38:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','BUSINESS','工商',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','EDU','教育',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','ELECTRIC','电力',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','ELECTRON','电子家电',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','ENERGY','其他能源',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','FINANCE','金融',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','GOVERNMENT','政府',0,'A','SYSTEM','2006-03-15 19:01:08','SYSTEM','2006-03-15 19:01:08');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','HOSPITAL','医院',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','INSURANCE','保险',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','MANUFACTURE','制造',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','MILITARY_AREA','军区',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','NAT_REVENUE','国税',0,'A','SYSTEM','2006-03-15 19:01:08','SYSTEM','2006-03-15 19:01:08');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','POST','邮政',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','PUBLIC','公共事业',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','QUALITY_CONTROL','质检',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','REGION_REVENUE','地税',0,'A','SYSTEM','2006-03-15 19:01:08','SYSTEM','2006-03-15 19:01:08');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','STEEL','钢铁冶金',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','TOBACCO','烟草',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','TRAFFIC','交通',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','TRAFFIC_POLICE','交警',0,'A','SYSTEM','2006-03-15 19:01:08','SYSTEM','2006-03-15 19:01:08');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('ISSUE_STATUS','NEW','新问题',1,'A','SYSTEM','2006-04-23','SYSTEM','2006-04-23');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('ISSUE_TYPE','CONFIG','配置问题',1,'A','SYSTEM','2006-04-23','SYSTEM','2006-04-23');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('MANUFACTURER','MICROSOFT','MICROSOFT',1,'A','SYSTEM','2006-03-20','SYSTEM','2006-03-20 20:42:46');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('PRIORITY','HIGH','高',1,'A','SYSTEM','2006-04-23','SYSTEM','2006-04-23');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('PRIORITY','LOW','低',5,'A','SYSTEM','2006-05-14 17:27:58','SYSTEM','2006-05-14 17:27:58');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('PRIORITY','MEDIUM','中',4,'A','SYSTEM','2006-05-14 17:27:39','SYSTEM','2006-05-14 17:27:39');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('PROD_STATUS','NOT_SALE','未销售',1,'A','SYSTEM','2006-03-20','SYSTEM','2006-03-20');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('PROD_STATUS','ON_SALE','销售中',2,'A','SYSTEM','2006-03-20 18:03:52','SYSTEM','2006-03-20 18:03:52');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('PROD_STATUS','STOP_SALE','停止销售',3,'A','SYSTEM','2006-03-20 18:04:02','SYSTEM','2006-03-20 18:04:02');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('PROD_TYPE','FIREWALL','防火墙',1,'A','SYSTEM','2006-03-20','SYSTEM','2006-05-27 20:11:16');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('SPT_TYPE','IMPLEMENT','项目实施',6,'A','SYSTEM','2006-05-14 17:31:11','SYSTEM','2006-05-14 17:31:11');
INSERT INTO code (CODE_TYPE_ID, CODE_ID, CODE_DESC, CODE_SEQ, STATUS, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('SPT_TYPE','TEL_SUPPORT','电话支持',1,'A','SYSTEM','2006-04-23','SYSTEM','2006-04-23');

COMMIT;

INSERT INTO code_type (CODE_TYPE_ID, CODE_TYPE_DESC, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('ACTI_TYPE','活动类型','SYSTEM','2006-05-11','SYSTEM','2006-05-11');
INSERT INTO code_type (CODE_TYPE_ID, CODE_TYPE_DESC, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('CUSTOMER_TYPE','客户类型','SYSTEM','2006-05-11','SYSTEM','2006-05-11');
INSERT INTO code_type (CODE_TYPE_ID, CODE_TYPE_DESC, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('INDUSTRY','行业','SYSTEM','2006-05-11','SYSTEM','2006-05-11');
INSERT INTO code_type (CODE_TYPE_ID, CODE_TYPE_DESC, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('ISSUE_STATUS','问题状态','SYSTEM','2006-05-11','SYSTEM','2006-05-11');
INSERT INTO code_type (CODE_TYPE_ID, CODE_TYPE_DESC, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('ISSUE_TYPE','问题类型','SYSTEM','2006-05-11','SYSTEM','2006-05-11');
INSERT INTO code_type (CODE_TYPE_ID, CODE_TYPE_DESC, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('MANUFACTURER','制造商','SYSTEM','2006-05-11','SYSTEM','2006-05-11');
INSERT INTO code_type (CODE_TYPE_ID, CODE_TYPE_DESC, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('PRIORITY','优先级','SYSTEM','2006-05-11','SYSTEM','2006-05-11');
INSERT INTO code_type (CODE_TYPE_ID, CODE_TYPE_DESC, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('PROD_STATUS','产品状态','SYSTEM','2006-05-11','SYSTEM','2006-05-11');
INSERT INTO code_type (CODE_TYPE_ID, CODE_TYPE_DESC, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('PROD_TYPE','产品类型','SYSTEM','2006-05-11','SYSTEM','2006-05-11');
INSERT INTO code_type (CODE_TYPE_ID, CODE_TYPE_DESC, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('SPT_TYPE','客户服务类型','SYSTEM','2006-05-11','SYSTEM','2006-05-11');
INSERT INTO code_type (CODE_TYPE_ID, CODE_TYPE_DESC, CREATE_BY, CREATE_DTTM, LAST_UPDATE_BY, LAST_UPDATE_DTTM) VALUES ('USER_STATUS','用户帐号状态','SYSTEM','2006-05-14','SYSTEM','2006-05-14');

COMMIT;

INSERT INTO role (ROLE_ID, ROLE_NAME, ROLE_DESC) VALUES (1,'ROLE_USER','普通用户');
INSERT INTO role (ROLE_ID, ROLE_NAME, ROLE_DESC) VALUES (2,'ROLE_ORDER_ADMIN','定单管理员');
INSERT INTO role (ROLE_ID, ROLE_NAME, ROLE_DESC) VALUES (3,'ROLE_SALES','销售');
INSERT INTO role (ROLE_ID, ROLE_NAME, ROLE_DESC) VALUES (4,'ROLE_SUPPORT','技术支持人员');
INSERT INTO role (ROLE_ID, ROLE_NAME, ROLE_DESC) VALUES (5,'ROLE_ADMIN','管理员');
INSERT INTO role (ROLE_ID, ROLE_NAME, ROLE_DESC) VALUES (6,'ROLE_PROD_ADMIN','产品管理员');

COMMIT;

INSERT INTO user (USER_ID, USER_NAME, USER_PASSWORD, STATUS, LAST_LOGIN_TIME, LAST_LOGIN_IP) VALUES (1,'admin','202cb962ac59075b964b07152d234b70',NULL,NULL,NULL);

COMMIT;

INSERT INTO user_role (USER_ID, ROLE_ID) VALUES (1,4);
INSERT INTO user_role (USER_ID, ROLE_ID) VALUES (1,6);
INSERT INTO user_role (USER_ID, ROLE_ID) VALUES (1,3);
INSERT INTO user_role (USER_ID, ROLE_ID) VALUES (1,1);
INSERT INTO user_role (USER_ID, ROLE_ID) VALUES (1,5);
INSERT INTO user_role (USER_ID, ROLE_ID) VALUES (1,2);

COMMIT;