krm.sql

tomcat最新安装程序

CREATE DATABASE krm;

use krm;

CREATE TABLE TA_ApplyDEAim (
  A_ApplyID bigint(20) unsigned NOT NULL default '0',
  A_ApplyName text NOT NULL,
  A_ApplyRecycle text default NULL,
  A_ApplyQuarlity text,
  A_ApplyCost varchar(50) default NULL,
  D_Serial varchar(50) NOT NULL default '0',
  A_Serial varchar(50) default NULL,
  P_Serial varchar(50) default NULL,
  P_Code varchar(50) default NULL,
  A_ApplyDelete char(1) default NULL,
  PRIMARY KEY  (A_ApplyID)
) TYPE=BerkeleyDB;

CREATE TABLE TA_ApplyDEPlan (
  P_ApplyID bigint(20) unsigned NOT NULL default '0',
  P_ApplyStartDate date default '1900-01-01' NOT NULL,
  P_ApplyDate date default NULL,
  P_ApplyGrade bigint(20) default NULL,
  P_ApplyBrief text,
  P_ApplyDetail text,
  P_ApplyChargeMan varchar(20) default NULL,
  P_ApplyMemo text,
  D_Serial varchar(50) NOT NULL default '0',
  A_Serial varchar(50) default NULL,
  P_Serial varchar(50) default NULL,
  P_Code varchar(50) default NULL,
  P_ApplyDelete char(1) default NULL,
  PRIMARY KEY  (P_ApplyID)
) TYPE=BerkeleyDB; 

CREATE TABLE TA_ApplyDetail (
  AD_Serial varchar(50) NOT NULL default '0',
  AD_Topic varchar(100) NOT NULL default '',
  AD_Content text NOT NULL,
  AD_Begin date NOT NULL default '1900-01-01',
  AD_End date NOT NULL default '1900-01-01',
  User_ID varchar(20) NOT NULL default '',
  Dept_ID varchar(20) NOT NULL default '',
  AD_Memo text,
  AD_Importance varchar(20) NOT NULL default '',
  P_Code varchar(50) NOT NULL default '0',
  A_Serial varchar(50) default NULL,
  P_Serial varchar(50) default NULL,
  AD_ManagerID varchar(20) default NULL,
  AD_ManagerName varchar(20) default NULL,
  AD_IntendPerson text,
  AD_WantMoney float(10,1) NOT NULL default '0.0',
  AD_PreMoney float(10,1) NOT NULL default '0.0',
  AD_ContactMoney float(10,1) NOT NULL default '0.0',
  AD_AidPerson varchar(20) default NULL,
  AD_ApplyUser bigint(20) NOT NULL default '0',
  AD_ApplyTime datetime default NULL,
  AD_Approved char(1) default NULL,
  AD_ApproveTime datetime default NULL,
  A_Topic varchar(255) default NULL,
  PRIMARY KEY  (AD_Serial)
) TYPE=BerkeleyDB;

CREATE TABLE TA_ApprovalAccessories (
  AA_ID bigint(20) NOT NULL default '0',
  AA_DetailID bigint(20) NOT NULL default '0',
  AA_FileName varchar(50) NOT NULL default '',
  AA_Code varchar(50) NOT NULL default '',
  PRIMARY KEY  (AA_ID)
) TYPE=BerkeleyDB;

CREATE TABLE TA_ApprovalFlowAction (
  FA_ID bigint(20) NOT NULL default '0',
  FA_Name varchar(50) NOT NULL default '',
  FA_FlowID bigint(20) NOT NULL default '0',
  FA_Flag char(1) default NULL,
  FA_Roles text,
  FA_Type tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (FA_ID)
) TYPE=BerkeleyDB;

CREATE TABLE TA_ApprovalTransfer (
  AT_ID bigint(20) NOT NULL default '0',
  AT_DetailID bigint(20) NOT NULL default '0',
  AT_ActionID bigint(20) NOT NULL default '0',
  AT_ApproverID varchar(20) NOT NULL default '',
  AT_ApproveDate datetime NOT NULL default '1900-01-01 00:00:00',
  AT_ApproveMind varchar(255)  default '',
  AT_Finished char(1) NOT NULL default '',
  AT_ApplierID varchar(20) NOT NULL default '',
  PRIMARY KEY  (AT_ID)
) TYPE=BerkeleyDB;

CREATE TABLE CM_AddressList (
  AL_ID bigint(20) unsigned NOT NULL default '0',
  ALT_ID bigint(20) unsigned NOT NULL default '0',
  AL_OwnerID varchar(20) NOT NULL default '0',
  Dic_OccupID text default '',
  AL_Name varchar(20) NOT NULL default '',
  AL_Duty varchar(50) default NULL,
  AL_OfficeTel varchar(20) default NULL,
  AL_HomeTel varchar(20) default NULL,
  AL_MobileTel varchar(20) default NULL,
  AL_Mail varchar(50) default NULL,
  AL_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (AL_ID)
) TYPE=BerkeleyDB;

CREATE TABLE CM_AddressListType (
  ALT_ID bigint(20) unsigned NOT NULL default '0',
  ALT_Title varchar(50) NOT NULL default '',
  ALT_Owner varchar(20) NOT NULL default '0',
  ALT_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (ALT_ID)
) TYPE=BerkeleyDB;

CREATE TABLE CM_FileAccessories (
  FA_ID bigint(20) unsigned NOT NULL default '0',
  FA_Flag bigint(20) NOT NULL default '0',
  FA_FileName varchar(50) NOT NULL default '',
  FA_Name varchar(50) default NULL,
  FA_Code varchar(10) default NULL,
  FA_Type varchar(50) default NULL,
  FA_Content longblob,
  PRIMARY KEY  (FA_ID)
) TYPE=BerkeleyDB;


CREATE TABLE CM_InformInfo (
  II_ID bigint(20) unsigned NOT NULL default '0',
  II_Title varchar(50) NOT NULL default '',
  IT_ID bigint(20) unsigned NOT NULL default '0',
  II_Date datetime NOT NULL default '1900-01-01 00:00:00',
  II_SendID varchar(20) NOT NULL default '0',
  II_Sender varchar(20) NOT NULL default '',
  II_Accept text NOT NULL,
  II_AcceptName text,
  II_Accepted text,
  II_AcceptedName text,
  II_Content text,
  II_Flag char(1) NOT NULL default '0',
  II_Accepting text,
  PRIMARY KEY  (II_ID)
) TYPE=BerkeleyDB;

CREATE TABLE CM_InformType (
  IT_ID bigint(20) unsigned NOT NULL default '0',
  IT_Title varchar(50) NOT NULL default '',
  IT_Memo varchar(200) default NULL,
  IT_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (IT_ID)
) TYPE=BerkeleyDB;

CREATE TABLE CM_MailInfo (
  MI_ID bigint(20) unsigned NOT NULL default '0',
#修改  
  MI_Title varchar(150) NOT NULL default '',
  MT_ID bigint(20) unsigned NOT NULL default '0',
  MI_Date datetime NOT NULL default '1900-01-01 00:00:00',
  MI_SendID varchar(20) NOT NULL default '0',
  MI_Sender varchar(20) NOT NULL default '',
  MI_Accept text NOT NULL,
  MI_AcceptName text,
  MI_Accepted text,
  MI_AcceptedName text,
  MI_Content text,
  MI_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (MI_ID)
) TYPE=BerkeleyDB;

CREATE TABLE CM_MailType (
  MT_ID bigint(20) unsigned NOT NULL default '0',
  MT_Title varchar(50) NOT NULL default '',
  MT_Owner varchar(20) NOT NULL default '0',
  MT_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (MT_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_AcceptDocumentInfo (
  ADI_ID bigint(20) unsigned NOT NULL default 0,
  ADI_Title varchar(100) NOT NULL default '',
  ADI_Secrecy varchar(20) NOT NULL default '',
  ADI_Urgent varchar(20) NOT NULL default '',
  ADI_TransactionType varchar(20) NOT NULL default '',
  ADI_SecrecyTime varchar(20) NOT NULL default '',
  ADI_SendOrgan varchar(100) NOT NULL default '',
  ADI_SendOrganFlag varchar(100) default '',
  ADI_OrganSeal longtext,
  ADI_Type varchar(20) NOT NULL default '',
  ADI_Kind varchar(20) NOT NULL default '',
  ADI_SN varchar(50) NOT NULL default '',
  ADI_Signer varchar(20) NOT NULL default '',
  ADI_SignerSeal longtext,
  ADI_FirstOrgan varchar(200) NOT NULL default '',
  ADI_SecondOrgan varchar(200) default NULL,
  ADI_ThirdOrgan varchar(200) default NULL,
  ADI_Content text,
  ADI_SubScrible BLOB,
  ADI_Date date NOT NULL default '1900-01-01',
  ADI_Memo text,
  ADI_Theme text,
  ADI_PrintOrgan varchar(200) default NULL,
  ADI_PrintDate date default '1900-01-01',
  ADI_PrintPiece bigint(20) unsigned default NULL,
  ADI_Pigeonhole char(1) NOT NULL default '0',
  ADI_AcceptDate date NOT NULL default '1900-01-01',
  PRIMARY KEY  (ADI_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_AcceptRegister (
  AR_ID bigint(20) unsigned NOT NULL default 0,
  AR_AcceptDate date NOT NULL default '1900-01-01',
  AR_SN varchar(50) NOT NULL default '',
  CO_ID varchar(200) NOT NULL default '',
  DUD_ID varchar(20) NOT NULL default '',
  AR_TimeLimit varchar(20) default NULL,
  DSR_ID varchar(20) NOT NULL default '',
  ADI_ID varchar(20) NOT NULL default '',
  AR_Content text,
  AR_SendDate datetime default NULL,
  AR_AcceptOrgan varchar(200) default NULL,
  AR_ReturnDate datetime default NULL,
  AR_AccepterID varchar(20) NOT NULL default '0',
  AR_Accepter varchar(20) NOT NULL default '',
  PRIMARY KEY  (AR_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_ComeOrgan (
  CO_ID bigint(20) unsigned NOT NULL default 0,
  CO_Name varchar(50) NOT NULL default '',
  CO_SubjectionOrgan varchar(50) NOT NULL default '',
  OA_ID bigint(20) default 0,
  CO_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (CO_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_DefaultMind (
  DM_ID bigint(20) NOT NULL default 0,
  DM_Name varchar(100) NOT NULL default '',
  PRIMARY KEY  (DM_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_DocAccessories (
  DA_ID bigint(20) unsigned NOT NULL default 0,
  DA_DocID bigint(20) unsigned NOT NULL default 0,
  DA_Flag char(1) NOT NULL default '0',
  DA_FileName varchar(200) NOT NULL default '',
  DA_Name varchar(200) default NULL,
  DA_Code varchar(50) NOT NULL default '',
  DA_Type varchar(1) NOT NULL default '',
  PRIMARY KEY  (DA_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_DocFlowName (
  DFN_ID bigint(20) unsigned NOT NULL default 0,
  DFN_Doc varchar(10) NOT NULL default '',
  DFN_Name varchar(100) NOT NULL default '',
  DFN_Taxis bigint(20) unsigned NOT NULL default 0,
  FND_ID bigint(20) unsigned NOT NULL default 0,
  DFN_Flag char(1) NOT NULL default '0',
  DFN_Modify int(1) NOT NULL default 0,
  PRIMARY KEY  (DFN_ID)
) TYPE=BerkeleyDB;

INSERT INTO DM_DocFlowName VALUES ('1','3','分阅','8','6','1','0');
INSERT INTO DM_DocFlowName VALUES ('2','3','催办','8','7','1','0');
INSERT INTO DM_DocFlowName VALUES ('3','3','延期','9','7','1','0');

CREATE TABLE DM_DocKind (
  DK_ID bigint(20) unsigned NOT NULL default 0,
  DT_ID bigint(20) unsigned NOT NULL default 0,
  DK_Name varchar(20) NOT NULL default '',
  DK_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (DK_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_DocPigeonhole (
  DP_ID bigint(20) unsigned NOT NULL default 0,
  DP_DocID bigint(20) unsigned NOT NULL default 0,
  DP_Date date NOT NULL default '1900-01-01',
  DP_Location varchar(255) NOT NULL default '0',
  DP_HandlersID varchar(20) NOT NULL default '',
  DP_Handlers varchar(20) NOT NULL default '',
  DP_Remark varchar(255) NOT NULL default '',
  PRIMARY KEY  (DP_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_DocSecrecyRank (
  DSR_ID bigint(20) unsigned NOT NULL default 0,
  DSR_Name varchar(20) NOT NULL default '',
  DSR_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (DSR_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_DocTransactionType (
  DTT_ID bigint(20) unsigned NOT NULL default 0,
  DTT_Name varchar(20) NOT NULL default '',
  DTT_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (DTT_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_DocTransfer (
  DT_ID bigint(20) unsigned NOT NULL default 0,
  DT_Flag char(1) NOT NULL default '0',
  DT_DocID bigint(20) unsigned NOT NULL default 0,
  DFN_ID bigint(20) unsigned NOT NULL default 0,
  DT_HandlersID varchar(20) NOT NULL default '0',
  DT_Handlers varchar(20) NOT NULL default '',
  DT_Date datetime NOT NULL default '1900-01-01 00:00:00',
  DT_Finish char(1) NOT NULL default '0',
  DT_NextHandlersID bigint(20) NOT NULL default 0,
  DT_NextHandlers varchar(20) NOT NULL default '',
  DT_TimeLimit date default NULL,
  PRIMARY KEY  (DT_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_DocType (
  DT_ID bigint(20) unsigned NOT NULL default 0,
  DT_Name varchar(20) NOT NULL default '',
  DT_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (DT_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_DocUrgentDegree (
  DUD_ID bigint(20) unsigned NOT NULL default 0,
  DUD_Name varchar(20) NOT NULL default '',
  DUD_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (DUD_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_FlowNameDiscerner (
  FND_ID bigint(20) unsigned NOT NULL default 0,
  FND_Name varchar(20) NOT NULL default '',
  PRIMARY KEY  (FND_ID)
) TYPE=BerkeleyDB;

INSERT INTO DM_FlowNameDiscerner VALUES (1,'审批');
INSERT INTO DM_FlowNameDiscerner VALUES (3,'办理');
INSERT INTO DM_FlowNameDiscerner VALUES (4,'分发');
INSERT INTO DM_FlowNameDiscerner VALUES (5,'归档');

CREATE TABLE DM_OrganAddress (
  OA_ID bigint(20) unsigned NOT NULL default 0,
  OA_Province varchar(10) default '',
  OA_City varchar(10) default '',
  OA_County varchar(10) default '',
  OA_Street varchar(10) default '',
  OA_Doorplate varchar(10) default '',
  OA_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (OA_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_OrganSeal (
  Dept_ID varchar(20) NOT NULL default '0',
  OS_Seal longtext,
  OS_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (Dept_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_SearchCondition (
  SC_ID bigint(20) NOT NULL default 0,
  SC_SearchID bigint(20) NOT NULL default 0,
  SC_Key varchar(50) NOT NULL default '',
  SC_Value varchar(200) NOT NULL default '',
  SC_Opt varchar(10) NOT NULL default '',
  SC_GroupID int(2) NOT NULL default 0,
  SC_Table varchar(50) default NULL,
  PRIMARY KEY  (SC_ID)
) TYPE=BerkeleyDB;