krm.sql

tomcat最新安装程序

  P_Brief text,
  P_Desc text,
  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,
  PRIMARY KEY  (P_ID)
) TYPE=BerkeleyDB;

CREATE TABLE TA_Detail (
  D_Serial varchar(50) NOT NULL default '0',
  D_Topic varchar(100) NOT NULL default '',
  D_Content text NOT NULL default '',
  D_Begin date NOT NULL default '1900-01-01',
  D_End date NOT NULL default '1900-01-01',
  User_ID varchar(20) NOT NULL default '',
  Dept_ID varchar(20) NOT NULL default '',
  D_Distribution varchar(50) NOT NULL default '',
  P_Content text,
  D_Process varchar(50) NOT NULL default '',
  D_IsDistribute char(1) default 'n',
  D_IsAccept char(1) default 'n',
  D_IsCheck char(1) default 'n',
  D_IsLookcCheck char(1) default 'n',
  D_FinishTime date default '1900-01-01',
  D_Conlusion varchar(100) default NULL,
  D_IsImport char(1) default NULL,
  D_Memo text,
  D_Importance varchar(20) NOT NULL default '',
  D_ImportTime date default '1900-01-01',
  P_Code varchar(50) NOT NULL default '0',
  D_IsWeek char(1) default NULL,
  D_Cancellation char(1) default NULL,
  D_CheckContent text,
  A_Serial varchar(50) default NULL,
  P_Serial varchar(50) default NULL,
  D_Num  varchar(20) default NULL,
  D_IntendPerson text,
  D_SelfExplainMark varchar(10) default '0%',
  D_PublicExplainMark varchar(10) default '0%',
  D_WantMoney float(10,4) default '0.0000',
  D_PreMoney float(10,4) default NULL,
  D_ContactMoney float(10,4) default NULL,
  D_Mark varchar(10) default NULL,
  D_AidPerson varchar(20) default NULL,
  D_ManagerID  varchar(20) default NULL,
  D_ManagerName  varchar(20) default NULL,
  D_Income float(10,4) default '0.0000',
  D_yingzhi float(10,4) default '0.0000',
  PRIMARY KEY  (D_Serial)
) TYPE=BerkeleyDB;

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


CREATE TABLE TA_NENews (
  N_ID bigint(20) unsigned NOT NULL default '0',
  N_HappenDate date default NULL,
  N_Content text,
  D_Serial varchar(50) default NULL,
  N_Cancellation char(1) default NULL,
  W_ID bigint(20) default NULL,
  PRIMARY KEY  (N_ID)
) TYPE=BerkeleyDB;

CREATE TABLE TA_NEWeekImport (
  W_ID bigint(20) unsigned NOT NULL default '0',
  User_ID varchar(20) default NULL,
  W_Content text,
  W_Import char(1) default NULL,
  D_Serial varchar(50) default NULL,
  W_Cancellation char(1) default NULL,
  W_Date date default NULL,
  PRIMARY KEY  (W_ID)
) TYPE=BerkeleyDB;

CREATE TABLE TA_Plan (
  P_Code varchar(50) NOT NULL default '0',
  P_Content text,
  P_Topic varchar(100) NOT NULL default '',
  P_MakeMan varchar(20) NOT NULL default '',
  P_Dept varchar(20) NOT NULL default '',
  P_Process varchar(50) NOT NULL default '',
  P_Importance varchar(20) NOT NULL default '',
  P_Serial varchar(50) default NULL,
  A_Serial varchar(50) default NULL,
  P_Cancellation char(1) default NULL,
  P_PlanTopic varchar(100) default NULL,
  PRIMARY KEY  (P_Code)
) TYPE=BerkeleyDB;

  CREATE TABLE TA_MonthCheck (
  mpid int(20) unsigned NOT NULL default 0,
  mp_num varchar(20) default '',
  mp_mission text NOT NULL default '',
  mp_user varchar(100) default '',
  mp_overtime varchar(40) default '',
  mp_overcircs text,
  insert_time date default '1900-01-01',
  update_time date default '1900-01-01',
  uid int(20) unsigned default 0,
  username varchar(40) default '',
  mp_dept varchar(20) default '',
  class varchar(20) NOT NULL default '0',
  plan_year varchar(4) default '',
  plan_mon char(2) default '',
  plan_time varchar(40) default '',
  dept_charge varchar(50) default '',
  dept_self text,
  checkmonth  text,
  leadercheck text,
  PRIMARY KEY  (mpid)
) TYPE=BerkeleyDB;

CREATE TABLE TA_Project (
  P_Serial varchar(50) NOT NULL default '0',
  P_Topic varchar(100) NOT NULL default '',
  A_Topic varchar(100) NOT NULL default '',
  P_MakeMan varchar(20) NOT NULL default '0',
  P_MainDept varchar(20) NOT NULL default '',
  P_OtherDept text NOT NULL default '',
  P_Process varchar(50) NOT NULL default '',
  P_Importance varchar(20) NOT NULL default '',
  A_Serial varchar(50) default NULL,
  P_Cancellation char(1) default NULL,
  PRIMARY KEY  (P_Serial)
) TYPE=BerkeleyDB;

CREATE TABLE TA_ReplyTransfer (
    RT_ID bigint(20) NOT NULL default 0,
    RT_PID bigint(20) NOT NULL default 0,
    RT_CreateUserID varchar(20) NOT NULL default '',
    RT_ActionID bigint(20) NOT NULL default 0,
    RT_ReplyerID varchar(20) NOT NULL default '',
    RT_ReplyDate datetime NOT NULL default '1900-01-01 00:00:00',
    RT_ReplyMind text,
    RT_Finished char(1) NOT NULL default '',
    RT_ApplyUserID varchar(20) NOT NULL default '',
    RT_Type char(1) default NULL,
    PRIMARY KEY (RT_ID)
) TYPE=BerkeleyDB;

CREATE TABLE TA_ReplyFlow (
    RF_ID bigint(20) NOT NULL default 0,
    RF_Name varchar(50) NOT NULL default '',
    RF_Flag char(1) NOT NULL default '0',
    PRIMARY KEY (RF_ID)
) TYPE=BerkeleyDB;

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

CREATE TABLE TA_ReplyEndAction (
    EA_ID bigint(20) NOT NULL default 0,
    EA_FlowID bigint(20) NOT NULL default 0,
    EA_ActionID bigint(20) NOT NULL default 0,
    EA_Flag bigint(20)  NOT NULL default 0,
    PRIMARY KEY (EA_ID)
) TYPE=BerkeleyDB;

CREATE TABLE TA_YearAim (
  A_Serial varchar(50) NOT NULL default '0',
  A_Topic varchar(100) NOT NULL default '',
  A_Year varchar(5) NOT NULL default '',
  A_OperatePeroid varchar(50) NOT NULL default '',
  A_IsProject char(1) NOT NULL default '',
  A_Cancellation char(1) default NULL,
#修改  
  A_Content text,
  A_Person varchar(20) NOT NULL default '',
#----  
  PRIMARY KEY  (A_Serial)
) TYPE=BerkeleyDB;

CREATE TABLE TA_DeInforAttachment (
  DI_AttachmentID  bigint(20) unsigned  NOT NULL default 0,
  DI_AttachmentName  varchar(60) NOT NULL default '',
  DI_AttachmentPath  varchar(60) NOT NULL default '',
  A_TypeID  bigint(20)  unsigned NOT NULL default 0,
  PRIMARY KEY  (DI_AttachmentID)
) TYPE=BerkeleyDB;


CREATE TABLE SM_ModuleInfo (
  MI_ModuleID varchar(20) NOT NULL default '',
  MI_ModuleName varchar(20) default NULL,
  PRIMARY KEY  (MI_ModuleID)
) TYPE=BerkeleyDB;

CREATE TABLE SM_BasicAuthUnit (
  BAU_UnitID varchar(20) NOT NULL default '',
  BAU_UnitName varchar(20) default NULL,
  BAU_ModuleID varchar(20) default NULL
) TYPE=BerkeleyDB;

CREATE TABLE SM_AuthUnitGroup (
  AUG_GroupID varchar(20) NOT NULL default '',
  AUG_GroupName varchar(20) default NULL,
  AUG_AccessControl varchar(100) default NULL,
  AUG_ModuleID varchar(20) default NULL,
  PRIMARY KEY  (AUG_GroupID)
) TYPE=BerkeleyDB;

CREATE TABLE SM_DepartmentInfo (
  DI_DepartmentID varchar(20) NOT NULL default '',
  DI_DepartmentName varchar(20) default NULL,
  PRIMARY KEY  (DI_DepartmentID)
) TYPE=BerkeleyDB;

CREATE TABLE SM_UserGroupInfo (
  UGI_UserGroupID varchar(20) NOT NULL default '',
  UGI_UserGroupName varchar(20) default NULL,
  UGI_AccessControl text NOT NULL,
  UGI_DepartmentID varchar(20) default NULL,
  PRIMARY KEY  (UGI_UserGroupID)
) TYPE=BerkeleyDB;

CREATE TABLE SM_DataAuthRole (
  DAR_RoleID varchar(20) NOT NULL default '',
  DAR_RoleName varchar(20) default NULL,
  DAR_UserGroupID varchar(20)  default NULL,
  DAR_DeptID varchar(20)  default NULL,
  DAR_AccessControl text NOT NULL,
  PRIMARY KEY  (DAR_RoleID)
) TYPE=BerkeleyDB;

CREATE TABLE SM_UserInfo (
  UI_UserID varchar(20) NOT NULL default '',
  UI_UserName varchar(20) default NULL,
  UI_Password varchar(24)  default NULL,
  UI_AccessControl text NOT NULL,
  UI_IP varchar(20) default NULL,
  UI_RoleID varchar(20) default NULL,
  UI_PrivateKey text NOT NULL,
  UI_PublicKey text NOT NULL,
  PRIMARY KEY  (UI_UserID)
) TYPE=BerkeleyDB;

CREATE TABLE SM_DataAuthInfo (
  DAI_Index varchar(20) NOT NULL default '',
  DAI_MasterRoleID varchar(20) default NULL,
  DAI_ClientRoleID varchar(20) default NULL,
  DAI_BasicUnitID varchar(20)  default NULL,
  DAI_OperationType varchar(20) default NULL,
  DAI_OperationValue varchar(20) default NULL,
  PRIMARY KEY  (DAI_Index)
) TYPE=BerkeleyDB;

CREATE TABLE SM_Unitoption (
  UNIT_ID int(4) NOT NULL default '0',
  UNIT_Name varchar(20) default NULL,
  UNIT_OptionID int(4) NOT NULL default '0',
  UNIT_OptionName varchar(20) default NULL,
  UNIT_OptionStatus int(4) NOT NULL default '0',
  PRIMARY KEY  (UNIT_ID,UNIT_OptionID)
) TYPE=BerkeleyDB;

CREATE TABLE KM_RecordInfo (
  RI_ID bigint(20) unsigned NOT NULL default 0,
  RI_RecordNumber varchar(20) NOT NULL default ' ',
  RI_RecordName varchar(80) NOT NULL default ' ',
  RI_PublishTime date NOT NULL default '1900-01-01',
  RI_PublishCompany varchar(60) default NULL,
  RI_RegisterTime date NOT NULL default '1900-01-01',
  RI_Comment varchar(200) default NULL,
  RGI_CategoryID bigint(20) unsigned NOT NULL default 0,
  RI_Transfer bigint(20) unsigned NOT NULL default 0,
  PRIMARY KEY  (RI_ID,RI_RecordNumber)
) TYPE=BerkeleyDB;



CREATE TABLE KM_RecordGroupInfo (
  RGI_GroupInfo varchar(2) NOT NULL default '1',
  RGI_CategoryName varchar(40) NOT NULL default '',
  RGI_CategoryID bigint(20) unsigned  NOT  NULL default 0,
  RGI_CategoryDescrible varchar(200) default NULL,
  RGI_CategoryBelong varchar(4) NOT NULL default 'in',
  PRIMARY KEY  (RGI_CategoryID)
) TYPE=BerkeleyDB;


 CREATE TABLE KM_RecordAttachment (
  RA_AttachmentName varchar(200) NOT NULL default '',
  RA_AttachmentPath varchar(200) NOT NULL default '',
  RA_AttachmentID bigint(20) unsigned  NOT  NULL default 0,
  RI_ID bigint(20) unsigned  NOT  NULL default 0,
  PRIMARY KEY  (RA_AttachmentID)
) TYPE=BerkeleyDB;

CREATE TABLE SM_UserLogInfo (
  ULI_Index varchar(20) NOT NULL default '',
  ULI_UserID varchar(20) default NULL,
  ULI_Time datetime default NULL,
  ULI_IP varchar(20)  default NULL,
  ULI_Common varchar(100) default NULL,
  PRIMARY KEY  (ULI_Index)
) TYPE=BerkeleyDB;

CREATE TABLE SM_OperationInfo (
  OI_Index varchar(20) NOT NULL default '',
  OI_UserID varchar(20) default NULL,
  OI_Time datetime default NULL,
  OI_IP varchar(20)  default NULL,
  OI_OperationRecord varchar(100) default NULL,
  OI_Common varchar(100) default NULL,
  PRIMARY KEY  (OI_Index)
) TYPE=BerkeleyDB;

CREATE TABLE VM_VehicleBasicInfo (
  VBI_VehicleID varchar(20) NOT NULL default '',
  VBI_VehicleNo varchar(20) default NULL,
  VBI_VehicleType varchar(20) default NULL,
  VBI_VehicleColor varchar(20) default NULL,
  VBI_BuyTime datetime default NULL,
  VBI_BuyMoney bigint(20) default NULL,
  VBI_RegTime datetime default NULL,
  VBI_RegRoadNum bigint(20) default NULL,
  VBI_PicName text,
  VBI_AverageOilnum bigint(20) default NULL,
  VBI_Comment text,
   PRIMARY KEY  (VBI_VehicleID)
) TYPE=BerkeleyDB;

CREATE TABLE VM_ManageBasicInfo (
  MBI_Index varchar(20) NOT NULL default '' ,
  MBI_UserID varchar(20) default NULL,
  MBI_VehicleID varchar(20) default NULL,
  MBI_StartTime datetime default NULL,
  MBI_EndTime datetime default NULL,
  MBI_StartRoadNum bigint(20) default NULL,
  MBI_EndRoadNum bigint(20) default NULL,
  MBI_Comment text,
  PRIMARY KEY  (MBI_Index)
) TYPE=BerkeleyDB;

CREATE TABLE VM_MourneyAndOil (
  MAO_Index varchar(20) NOT NULL default '' ,
  MAO_UserID varchar(20) default NULL,
  MAO_VehicleID varchar(20) default NULL,
  MAO_StartTime datetime default NULL,
  MAO_EndTime datetime default NULL,
  MAO_StartRoadNum bigint(20) default NULL,
  MAO_EndRoadNum bigint(20) default NULL,
  MAO_AllOilnum bigint(20) default NULL,
  MAO_Comment text,
  PRIMARY KEY  (MAO_Index)
) TYPE=BerkeleyDB;

CREATE TABLE VM_MaintenanceInfo (
  MI_Index varchar(20) NOT NULL default '' ,
  MI_UserID varchar(20) default NULL,
  MI_VehicleID varchar(20) default NULL,
  MI_Time datetime default NULL,
  MI_Item varchar(50) default NULL,
  MI_Factory varchar(100) default NULL,
  MI_Money bigint(20) default NULL,
  MI_Comment text,