krm.sql

tomcat最新安装程序

CREATE TABLE DM_SearchEngine (
  SE_ID bigint(20) NOT NULL default 0,
  SE_Name varchar(50) NOT NULL default '',
  SE_UserID varchar(20) NOT NULL default '',
  SE_Type int(2) NOT NULL default 0,
  PRIMARY KEY  (SE_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_SendDocumentInfo (
  SDI_ID bigint(20) unsigned NOT NULL default 0,
  SDI_Title varchar(50) NOT NULL default '',
  DSR_Name varchar(20) NOT NULL default '0',
  DUD_Name varchar(20) NOT NULL default '0',
  SDI_SecrecyTime varchar(10) NOT NULL default '',
  SDI_SendOrgan varchar(100) NOT NULL default '',
  SDI_No varchar(20) NOT NULL default '',
  SDI_SignerID varchar(20) default NULL,
  SDI_FirstOrgan varchar(50) NOT NULL default '',
  SDI_SecondOrgan varchar(50) default NULL,
  SDI_ThirdOrgan varchar(50) default NULL,
  SDI_Date date  default '1900-01-01',
  SDI_Memo varchar(50) default NULL,
  SDI_Theme varchar(100) default NULL,
  SDI_PrintOrgan varchar(50) default NULL,
  SDI_PrintDate date default '1900-01-01',
  SDI_PrintPiece varchar(20) default NULL,
  SDI_Pigeonhole char(1) NOT NULL default '0',
  PRIMARY KEY  (SDI_ID)
) TYPE=BerkeleyDB;


CREATE TABLE DM_SendOrgan (
  SO_ID bigint(20) unsigned NOT NULL default 0,
  SO_Name varchar(50) NOT NULL default '',
  SO_AB varchar(50) NOT NULL default '',
  SO_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (SO_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_SendRegister (
  SR_ID bigint(20) unsigned NOT NULL default 0,
  SR_Date datetime NOT NULL default '1900-01-01 00:00:00',
  SR_SenderID varchar(20) NOT NULL default '0',
  SR_Sender varchar(20) NOT NULL default '',
  SR_SendDeptID varchar(20) NOT NULL default '0',
  SR_SendDept varchar(20) NOT NULL default '0',
  SR_DocID bigint(20) NOT NULL default 0,
  PRIMARY KEY  (SR_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_SignerSeal (
  User_ID varchar(20) NOT NULL default '0',
  SS_Seal longtext,
  SS_Flag char(1) NOT NULL default '0',
  PRIMARY KEY  (User_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_TempletInfo (
  TI_ID bigint(20) NOT NULL default 0,
  TI_Name varchar(200) NOT NULL default '',
  PRIMARY KEY  (TI_ID)
) TYPE=BerkeleyDB;

CREATE TABLE DM_TransferMind (
  TM_ID bigint(20) unsigned NOT NULL default 0,
  Doc_ID bigint(20) unsigned NOT NULL default 0,
  DT_ID bigint(20) unsigned NOT NULL default 0,
  TM_NextDFN varchar(20) default '0',
  TM_HandlersID varchar(20) NOT NULL default '0',
  TM_Handlers varchar(20) NOT NULL default '',
  TM_Mind text,
  TM_Signer blob,
  TM_Date datetime NOT NULL default '1900-01-01 00:00:00',
  PRIMARY KEY  (TM_ID)
) TYPE=BerkeleyDB;

CREATE TABLE ObjectID (
  ID bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=BerkeleyDB;

INSERT INTO ObjectID VALUES (0);

CREATE TABLE FM_ProcessInfo (
  PI_ID bigint(20) NOT NULL default 0,
  PI_AccountID bigint(20) NOT NULL default 0,
  PI_TaskID bigint(20) NOT NULL default 0,
  PI_Money float(10,2) NOT NULL default 0.00,
  PI_Payout char(1) NOT NULL default '',
  PI_Standoff char(1) NOT NULL default '',
  PI_Remark varchar(255) default NULL,
  PI_AppKind bigint(20) NOT NULL default 0,
  PI_ApproveDate datetime NOT NULL default '1900-01-01 00:00:00',
  PRIMARY KEY  (PI_ID)
) TYPE=BerkeleyDB;

CREATE TABLE FM_IncomePast (
  IP_ID bigint(20) NOT NULL default '0',
  IP_TaskID bigint(20) NOT NULL default '0',
  IP_TaskName varchar(100) NOT NULL default '',
  IP_Money float(10,2) NOT NULL default '0.00',
  IP_Date datetime NOT NULL default '1900-01-01 00:00:00',
  IP_Handler bigint(20) NOT NULL default '0',
  IP_Remark varchar(255) default NULL,
  PRIMARY KEY  (IP_ID)
) TYPE=BerkeleyDB;

CREATE TABLE PE_PersonInfo (
  User_ID varchar(20) NOT NULL default '0',
  I_Name varchar(20) NOT NULL default '',
  I_Sex char(2) NOT NULL default '',
  I_Racil varchar(30) NOT NULL default '',
  I_RacilName varchar(16) default NULL,
  I_Native varchar(40) NOT NULL default '',
  Dept_ID varchar(20) NOT NULL default '',
  L_OccupID bigint(20) NOT NULL default '0',
  L_OccupName varchar(20) default NULL,
  O_ID bigint(20) NOT NULL default '0',
  I_Born date NOT NULL default '1900-01-01',
  I_Party varchar(20) default NULL,
  I_PartyName varchar(20) default NULL,
  I_PartyDate date default NULL,
  I_WorkDate date NOT NULL default '1900-01-01',
  I_Education varchar(50) default NULL,
  I_EducationName varchar(12) default NULL,
  I_Graduate varchar(50) default NULL,
  I_Degree varchar(50) default NULL,
  I_DegreeName varchar(20) default NULL,
  I_LevelDate date default NULL,
  I_OccupyDate date default NULL,
  I_EnterDate date NOT NULL default '1900-01-01',
  I_Memo text,
  I_Sequency bigint(20) NOT NULL default '0',
  I_Authorization varchar(50) default NULL,
  I_AuthorizationName varchar(20) default NULL,
  I_IsLeader char(1) default NULL,
  I_RealDel char(1) default NULL,
  I_Worker char(1) NOT NULL default '',
  L_Name varchar(50) default NULL,
  I_Mobile bigint(20) default '0',
  I_IsRetire char(1) default 'n',
  I_IsNotUse char(1) default 'n',
  N_Addr VARCHAR(100) DEFAULT '',
  ISMarry CHAR(1) DEFAULT '0',
  I_PersonID VARCHAR(18),
  A_Addr VARCHAR(100),
  HousePhone VARCHAR(15) DEFAULT '0',
  Address VARCHAR(100) DEFAULT ' ',
  Degree VARCHAR(8),
  WorkMemo TEXT,
  UseStatus CHAR(1) DEFAULT '1',
  PositionDate DATE DEFAULT '1900-01-01',
  StartDate DATE DEFAULT '1900-01-01',
  EndDate DATE DEFAULT '1900-01-01',
  Manager VARCHAR(20),
  Stuff VARCHAR(255),  
  PRIMARY KEY  (User_ID)
) TYPE=BerkeleyDB;

CREATE TABLE PE_PersonDuty (
  UserID bigint(20) NOT NULL default '0',
  Duty varchar(255) default '',
  Degree char(1) default '0',
  Percent tinyint(4) default '0'
) TYPE=BerkeleyDB;

CREATE TABLE MM_Netmeetinginform (
  NM_ID bigint(20) unsigned NOT NULL default '0',
  NM_MeetMemo text NOT NULL,
  NM_SendUser varchar(20) NOT NULL default '',
  NM_MeetTime datetime default '1900-01-01 00:00:00',
  NM_MeetName varchar(200) default NULL,
  NM_MeetSubject varchar(200) default NULL,
  NM_MeetMen text,
  NM_IPAddress varchar(20) default NULL,
  NM_IsValid char(1) default '1',
  PRIMARY KEY  (NM_ID)
) TYPE=BerkeleyDB;


CREATE TABLE PE_Auth (
  A_ID bigint(20) default NULL,
  A_Name varchar(20) default NULL
) TYPE=BerkeleyDB;

CREATE TABLE PE_Authorization (
  A_ID bigint(20) NOT NULL default '0',
  Dept_ID varchar(20) NOT NULL default '0',
  A_Career bigint(20) NOT NULL default '0',
  A_Admin bigint(20) NOT NULL default '0',
  A_RealDel char(1) default NULL,
  PRIMARY KEY  (A_ID)
) TYPE=BerkeleyDB;

CREATE TABLE PE_Clan (
  C_ID bigint(20) default NULL,
  C_Name varchar(20) default NULL
) TYPE=BerkeleyDB;

CREATE TABLE PE_Degree (
  P_ID bigint(20) default NULL,
  P_Degree varchar(20) default NULL
) TYPE=BerkeleyDB;

CREATE TABLE PE_DeptInfo (
  Dept_ID varchar(20) NOT NULL default '0',
  D_Name varchar(50) NOT NULL default '',
  D_Desc text,
  D_Sequency bigint(20) NOT NULL default '0',
  D_RealDel char(1) default NULL,
  PRIMARY KEY  (Dept_ID)
) TYPE=BerkeleyDB;

CREATE TABLE PE_Folk (
  F_ID bigint(20) default NULL,
  F_Name varchar(20) default NULL
) TYPE=BerkeleyDB;

CREATE TABLE PE_Level (
  L_OccupID bigint(20) default NULL,
  L_Occup varchar(20) default NULL,
  L_Sequency bigint(20) default NULL
) TYPE=BerkeleyDB;

CREATE TABLE PE_Occupation (
  O_ID bigint(20) NOT NULL default '0',
  Dept_ID varchar(20) NOT NULL default '0',
  L_OccupID bigint(20) default '0',
  O_IsLeader char(1) default NULL,
  O_Total bigint(20) default '0',
  O_RealDel char(1) default NULL,
  O_Sheng bigint(20) default '0',
  O_TingLeader bigint(20) default '0',
  O_TingNLeader bigint(20) default '0',
  O_FTingLeader bigint(20) default '0',
  O_FTingNLeader bigint(20) default '0',
  O_ChuLeader bigint(20) default '0',
  O_ChuNLeader bigint(20) default '0',
  O_FChuLeader bigint(20) default '0',
  O_FChuNLeader bigint(20) default '0',
  PRIMARY KEY  (O_ID)
) TYPE=BerkeleyDB;

CREATE TABLE PE_OccupDic (
  O_ID bigint(20) default NULL,
  O_Name varchar(20) default NULL
) TYPE=BerkeleyDB;


CREATE TABLE PE_Propost (
  P_ID bigint(20) default NULL,
  P_Name varchar(20) default NULL
) TYPE=BerkeleyDB;


CREATE TABLE PE_Retire (
  OUser_ID varchar(20) NOT NULL default '0',
  R_Name varchar(20) NOT NULL default '',
  R_Sex char(2) default NULL,
  R_Sequency bigint(20) default '0',
  R_Born date default NULL,
  R_Native varchar(40) default NULL,
  R_WorkTime date NOT NULL default '1900-01-01',
  R_RetireDate date NOT NULL default '1900-01-01',
  R_OrigiOccup varchar(50) default NULL,
  R_Salary varchar(50) NOT NULL default '',
  R_Phone varchar(15) default NULL,
  R_Kind varchar(20) default NULL,
  R_Address varchar(50) default NULL,
  R_Healthy varchar(100) default NULL,
  R_Memo varchar(100) default NULL,
  R_RealDel char(1) default NULL,
  PRIMARY KEY  (OUser_ID)
) TYPE=BerkeleyDB;

CREATE TABLE PE_RetireDOC (
  RD_ID bigint(20) unsigned NOT NULL default '0',
  RD_Date date NOT NULL default '1900-01-01',
  RD_Content text,
  RD_RealDel char(1) default NULL,
  PRIMARY KEY  (RD_ID)
) TYPE=BerkeleyDB;

CREATE TABLE PE_Train (
  T_ID bigint(20) unsigned NOT NULL default '0',
  User_ID varchar(20) default '0',
  T_Kind varchar(10) default NULL,
  T_Content text,
  T_Date date default '1900-01-01',
  T_RealDel char(1) default NULL,
  PRIMARY KEY  (T_ID)
) TYPE=BerkeleyDB;





CREATE TABLE TA_DEAim (
  A_ID bigint(20) unsigned NOT NULL default '0',
  A_Name text NOT NULL,
  A_Recycle text default NULL,
  A_Quarlity text,
  A_Cost 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_Delete char(1) default NULL,
  PRIMARY KEY  (A_ID)
) TYPE=BerkeleyDB;

CREATE TABLE TA_DEAttach (
  A_ID bigint(20) unsigned NOT NULL default '0',
  A_Name varchar(100) default NULL,
  A_Content longblob,
  A_Size bigint(20) default NULL,
  A_Date date 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_Delete char(1) default NULL,
  PRIMARY KEY  (A_ID)
) TYPE=BerkeleyDB;

CREATE TABLE TA_DEPlan (
  P_ID bigint(20) unsigned NOT NULL default '0',
  P_StartDate DATE DEFAULT '1900-01-01' NOT NULL,  
  P_Date date default NULL,
  P_Grade bigint(20) default NULL,
  P_Brief text,
  P_Detail text,
  P_ChargeMan varchar(20) default NULL,
  P_Memo 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_Delete char(1) default NULL,
  P_Check TINYINT(4) DEFAULT 0,
  PRIMARY KEY  (P_ID)
) TYPE=BerkeleyDB;

CREATE TABLE TA_DEProblem (
  P_ID bigint(20) unsigned NOT NULL default '0',
  P_Title text,
  P_Content text,
  P_SendDate date default NULL,
  P_Reply text,
  P_ReplyDate date default NULL,
  P_CT varchar(20) 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,
  P_Delete char(1) default NULL,
  Create_UserID varchar(20) NOT NULL default '',
  Reply_UserID varchar(20) NOT NULL default '',
  Flow_ID bigint(20) NOT NULL default 0,
  Action_ID bigint(20) NOT NULL default 0,
  P_Type char(1) default NULL,
  PRIMARY KEY  (P_ID)
) TYPE=BerkeleyDB;


CREATE TABLE TA_DEProccess (
  P_ID bigint(20) unsigned NOT NULL default '0',
  P_FinishDate date default NULL,