krm.sql

tomcat最新安装程序

  PRIMARY KEY  (MI_Index)
) TYPE=BerkeleyDB;

CREATE TABLE VM_InsuranceInfo (
  II_Index varchar(20) NOT NULL default '' ,
  II_UserID varchar(20) default NULL,
  II_VehicleID varchar(20) default NULL,
  II_Time datetime default NULL,
  II_Item varchar(50) default NULL,
  II_Company varchar(100) default NULL,
  II_Money bigint(20) default NULL,
  II_Comment text,
  PRIMARY KEY  (II_Index)
) TYPE=BerkeleyDB;

CREATE TABLE WD_DiaryDate (
  DIA_ID bigint(20) NOT NULL default 0,
  DIA_workTime float default NULL,
  DIA_learnTime float default NULL,
  DIA_sportTime float default NULL,
  DIA_restTime float default NULL,
  DIA_selfInfo tinyint(4) default NULL,
  DIA_memoinfo varchar(255) default NULL,
  DIA_deptCheck tinyint(4) default NULL,
  DIA_checkinfo tinyint(4) default NULL,
  User_ID varchar(20) NOT NULL default '0',
  DIA_writeDate date NOT NULL default '1900-01-01',
  PRIMARY KEY  (DIA_ID)
) TYPE=BerkeleyDB;

CREATE TABLE WD_DiaryDefaultSet (
  DDS_TimePeriod varchar(20) NOT NULL default '',
  DDS_ID bigint(20) NOT NULL default 0,
  DDS_UserID varchar(20) NOT NULL default '',
  DDS_SelectItem varchar(10) NOT NULL default '',
  DDS_Value varchar(50) default NULL,
  PRIMARY KEY  (DDS_ID)
) TYPE=BerkeleyDB;

CREATE TABLE WD_DiaryItem (
  DIM_ID bigint(20) NOT NULL default 0,
  DIM_Name varchar(20) NOT NULL default '',
  DIM_Type varchar(10) default NULL,
  DIM_TypeID varchar(10) default NULL,
  PRIMARY KEY  (DIM_ID)
) TYPE=BerkeleyDB;

CREATE TABLE WD_DiaryPeriod (
  DPD_ID bigint(20) NOT NULL default 0,
  DIA_ID bigint(20) NOT NULL default 0,
  PD_ID bigint(20) NOT NULL default 0,
  UserID varchar(20) NOT NULL default '',
  DPD_writedate date NOT NULL default '1900-01-01',
  DPD_Item1 varchar(10) NOT NULL default '',
  DPD_Item2 varchar(10) NOT NULL default '',
  DPD_Item3 varchar(10) NOT NULL default '',
  DPD_Item4 varchar(10) NOT NULL default '',
  DPD_Item5 varchar(10) NOT NULL default '',
  DPD_Item6 varchar(10) NOT NULL default '',
  DPD_Item7 varchar(10) NOT NULL default '',
  DPD_Item8 varchar(10) NOT NULL default '',
  DPD_Item9 varchar(10) NOT NULL default '',
  DPD_Item10 varchar(10) NOT NULL default '',
  DPD_Item11 varchar(10) NOT NULL default '',
  DPD_Item12 varchar(10) NOT NULL default '',
  DPD_Item13 varchar(10) NOT NULL default '',
  DPD_Item14 varchar(10) NOT NULL default '',
  DPD_Item15 varchar(10) NOT NULL default '',
  DPD_Item16 varchar(10) NOT NULL default '',
  DPD_Item17 varchar(10) NOT NULL default '',
  DPD_Item18 varchar(10) NOT NULL default '',
  DPD_Item19 varchar(10) NOT NULL default '',
  DPD_Item20 varchar(10) NOT NULL default '',
  DPD_Item21 varchar(10) NOT NULL default '',
  DPD_Item22 varchar(10) NOT NULL default '',
  DPD_Item23 varchar(10) NOT NULL default '',
  DPD_Item24 varchar(10) NOT NULL default '',
  DPD_Value1 varchar(255) default NULL,
  DPD_Value2 varchar(255) default NULL,
  DPD_Value3 varchar(255) default NULL,
  DPD_Value4 varchar(255) default NULL,
  DPD_Value5 varchar(255) default NULL,
  DPD_Value6 varchar(255) default NULL,
  DPD_Value7 varchar(255) default NULL,
  DPD_Value8 varchar(255) default NULL,
  DPD_Value9 varchar(255) default NULL,
  DPD_Value10 varchar(255) default NULL,
  DPD_Value11 varchar(255) default NULL,
  DPD_Value12 varchar(255) default NULL,
  DPD_Value13 varchar(255) default NULL,
  DPD_Value14 varchar(255) default NULL,
  DPD_Value15 varchar(255) default NULL,
  DPD_Value16 varchar(255) default NULL,
  DPD_Value17 varchar(255) default NULL,
  DPD_Value18 varchar(255) default NULL,
  DPD_Value19 varchar(255) default NULL,
  DPD_Value20 varchar(255) default NULL,
  DPD_Value21 varchar(255) default NULL,
  DPD_Value22 varchar(255) default NULL,
  DPD_Value23 varchar(255) default NULL,
  DPD_Value24 varchar(255) default NULL,
  PRIMARY KEY  (DPD_ID)
) TYPE=BerkeleyDB;

CREATE TABLE WD_Period (
  PD_ID bigint(20) NOT NULL default 0,
  PD_startTime time NOT NULL default '00:00:00',
  PD_stopTime time NOT NULL default '00:00:00',
  PD_delSign char(1) NOT NULL default '',
  PRIMARY KEY  (PD_ID)
) TYPE=BerkeleyDB;

CREATE TABLE WD_DiaryInfoTip (
  DIT_ID bigint(20) NOT NULL default 0,
  DIT_WorkTime float(20,0) default NULL,
  DIT_StudyTime float(20,0) default NULL,
  DIT_SportTime float(12,0) default NULL,
  DIT_RestTime float(12,0) default NULL,
  DIT_MorningInfo varchar(255) default NULL,
  DIT_AfternoonInfo varchar(255) default NULL,
  DIT_NightInfo varchar(255) default NULL,
  DIT_MemoInfo varchar(255) default NULL,
  DIT_WriteDate date NOT NULL default '1900-01-01',
  DIT_UserID varchar(20) default NULL,
  DIT_Flag tinyint(4) default NULL,
  PRIMARY KEY  (DIT_ID)
) TYPE=BerkeleyDB;

CREATE TABLE WD_DiaryOtherInfoTip (
  DOIT_ID bigint(20) NOT NULL default 0,
  DOIT_Info varchar(255) default NULL,
  DOIT_MemoInfo varchar(255) default NULL,
  DOIT_WriteDate date NOT NULL default '1900-01-01',
  DOIT_UserID varchar(20) NOT NULL default '',
  DOIT_Flag tinyint(4) default NULL,
  PRIMARY KEY  (DOIT_ID)
) TYPE=BerkeleyDB;

CREATE TABLE WD_DiaryQuery (
  DQD_ID varchar(20) NOT NULL default '',
  DQD_QueryUserID varchar(20) NOT NULL default '0',
  DQD_QueryUserName varchar(20) default NULL,
  DQD_QueryCurrentTime datetime NOT NULL default '1900-01-01 00:00:00',
  DQD_DiaryWriteUserID varchar(20) NOT NULL default '',
  DQD_DiaryWriteDate date NOT NULL default '1900-01-01',
  PRIMARY KEY  (DQD_ID)
) TYPE=BerkeleyDB;

CREATE TABLE WD_DiaryForTask (
  UserID varchar(20) NOT NULL default '',
  UserName varchar(20) default NULL,
  DFT_WriteDate date NOT NULL default '1900-01-01',
  DFT_TaskID varchar(20) NOT NULL default '',
  DFT_TaskName varchar(100) default NULL,
  DFT_TaskNum varchar(20) default NULL,
  DFT_ManageID varchar(20) default NULL,
  DFT_ManageName varchar(20) default NULL,
  DFT_DiaryPeriod varchar(20) default NULL,
  DFT_Time tinyint(4) NOT NULL default 0,
  KEY UserID (UserID,DFT_WriteDate)
) TYPE=BerkeleyDB;

CREATE TABLE GM_TimeBook (
  TIM_ID bigint(20) NOT NULL default 0,
  TIM_start time NOT NULL default '00:00:00',
  TIM_end time NOT NULL default '00:00:00',
  TIM_dateStart date NOT NULL default '1900-01-01',
  TIM_dateEnd date default NULL,
  TIM_delSign char(1) NOT NULL default '',
  PRIMARY KEY  (TIM_ID)
) TYPE=BerkeleyDB;

CREATE TABLE GM_TimeOutGoing (
  OUT_ID bigint(20) NOT NULL default 0,
  User_ID varchar(20) NOT NULL default '',
  OUT_start date NOT NULL default '1900-01-01',
  OUT_end date NOT NULL default '1900-01-01',
  OUT_type varchar(4) NOT NULL default '',
  OUT_content varchar(20) NOT NULL default '',
  OUT_memo text,
  PRIMARY KEY  (OUT_ID)
) TYPE=BerkeleyDB;

CREATE TABLE GM_TimeRecord (
  REC_ID bigint(20) NOT NULL default '0',
  User_ID varchar(20) NOT NULL default '',
  REC_date date NOT NULL default '1900-01-01',
  REC_amArrive time default NULL,
  REC_amLeave time default NULL,
  REC_pmArrive time default NULL,
  REC_pmLeave time default NULL,
  REC_nightArrive time default NULL,
  REC_nightLeave time default NULL,
  PRIMARY KEY  (REC_ID)
) TYPE=BerkeleyDB;


CREATE TABLE FM_AccountItem (
  AI_ID bigint(20) NOT NULL default '0',
  AI_AccountID bigint(20) NOT NULL default '0',
  AI_ExpenseTypeID bigint(20) NOT NULL default '0',
  AI_Money float(10,2) NOT NULL default '0.00',
  AI_BillCount int(3) NOT NULL default '0',
  AI_Remark varchar(255) default NULL,
  AI_DiaryDate varchar(10),
  PRIMARY KEY  (AI_ID)
) TYPE=BerkeleyDB;



CREATE TABLE FM_ApprovalAccessories (
  AA_ID bigint(20) NOT NULL default '0',
  AA_AcountID bigint(20) NOT NULL default '0',
  AA_FileName varchar(50) NOT NULL default '',
  AA_Code varchar(50) NOT NULL default '',
  AA_Content longblob NOT NULL,
  PRIMARY KEY  (AA_ID)
) TYPE=BerkeleyDB;



CREATE TABLE FM_ApprovalFlow (
  AF_ID bigint(20) NOT NULL default '0',
  AF_Name varchar(50) NOT NULL default '',
  AF_Flag char(1) default NULL,
  PRIMARY KEY  (AF_ID)
) TYPE=BerkeleyDB;



CREATE TABLE FM_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_Type tinyint(2) default '0',
  FA_Roles text,  
#----  
  PRIMARY KEY  (FA_ID)
) TYPE=BerkeleyDB;



CREATE TABLE FM_ApprovalKind (
  AK_ID bigint(20) NOT NULL default '0',
  AK_Name varchar(50) NOT NULL default '',
  AK_Flag char(1) default NULL,
  AK_Loan char(1) default '0',
  AK_Stat char(1) NOT NULL default '1',
  PRIMARY KEY  (AK_ID)
) TYPE=BerkeleyDB;



CREATE TABLE FM_ApprovalTransfer (
  AT_ID bigint(20) NOT NULL default '0',
  AT_AcountID 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 '0000-00-00 00:00:00',
  AT_ApproveMind varchar(255) NOT NULL default '',
  AT_Finished char(1) NOT NULL default '',
  AT_ApplierID varchar(20) NOT NULL default '',
  PRIMARY KEY  (AT_ID)
) TYPE=BerkeleyDB;



CREATE TABLE FM_ExpenseAccountInfo (
  EI_ID bigint(20) NOT NULL default '0',
  EI_UserID varchar(20) NOT NULL default '',
  EI_DeptID varchar(20) NOT NULL default '',
  EI_FlowID bigint(20) NOT NULL default '0',
  EI_ItemID bigint(20) NOT NULL default '0',
  EI_ApprovalKindID bigint(20) NOT NULL default '0',
  EI_ApplyDate datetime NOT NULL default '1900-01-01 00:00:00',
  EI_ApproveDate datetime NOT NULL default '0000-00-00 00:00:00',
  EI_MoneySum float(10,2) NOT NULL default '0.00',
  EI_BillSum int(3) NOT NULL default '0',
  EI_Approved char(1) NOT NULL default '0',
#修改  
  EI_ItemName varchar(100) default NULL,  
#---  
#编号
  EI_SerialNum bigint(20) NOT NULL default '0',
#
  EI_Flag char(1) default '0',
  EI_ProcessDate datetime default NULL,
  EI_Status char(1) default '0',
  PRIMARY KEY  (EI_ID)
) TYPE=BerkeleyDB;

#修改
CREATE TABLE FM_FlowActionRelation (
  FAR_ID bigint(20) NOT NULL default '0',
  FAR_PreActionID bigint(20) NOT NULL default '0',
  FAR_NextActionID bigint(20) NOT NULL default '0',
  FAR_FlowID bigint(20) NOT NULL default '0',
  FAR_PreActionName varchar(50) NOT NULL default '',
  FAR_NextActionName varchar(50) NOT NULL default '',
  PRIMARY KEY (FAR_ID),
  UNIQUE KEY FAR_PreActionID (FAR_PreActionID)
) TYPE=BerkeleyDB;


CREATE TABLE FM_ExpenseType (
  ET_ID bigint(20) NOT NULL default '0',
  ET_Name varchar(50) NOT NULL default '',
  ET_Flag tinyint(4) default NULL,
  PRIMARY KEY  (ET_ID)
) TYPE=BerkeleyDB;



CREATE TABLE FM_ReportData (
  RD_ID bigint(20) unsigned NOT NULL default '0',
  RD_Date date NOT NULL default '1900-01-01',
  RD_PreBudget double default '0',
  RD_AddBudget double default '0',
  RD_Pexpence double default '0',
  RD_Hexpence double default '0',
  RD_Rexpence double default '0',
  RD_Analysis text,
  PRIMARY KEY  (RD_ID,RD_Date)
) TYPE=BerkeleyDB;

CREATE TABLE FM_LoanInfo (
  LI_ID bigint(20) NOT NULL default 0,
  LI_UserID bigint(20) NOT NULL default 0,
  LI_Money float(10,2) NOT NULL default 0.00,
  LI_Date datetime NOT NULL default '1900-01-01 00:00:00',
  LI_Flag char(1) NOT NULL default '0',
  LI_AccountID bigint(20) NOT NULL default 0,  
  LI_TaskName varchar(100) NOT NULL default '',
  LI_SerialNum bigint(20) NOT NULL default 0,    
  PRIMARY KEY  (LI_ID)
) TYPE=BerkeleyDB;

CREATE TABLE FM_TaskIncome (
  TI_ID bigint(20) NOT NULL default 0,
  TI_TaskID bigint(20) NOT NULL default 0,
  TI_TaskName varchar(100) NOT NULL default '',
  TI_Money float(10,2) NOT NULL default 0.00,
  TI_Date datetime NOT NULL default '1900-01-01 00:00:00',
  TI_Handler bigint(20) NOT NULL default 0,
  TI_Remark varchar(255) default NULL,
  PRIMARY KEY  (TI_ID)
) TYPE=BerkeleyDB;



CREATE TABLE MM_MeetingApprovation (
  MM_ID bigint(20) unsigned NOT NULL default '0',
  MA_Reason text,
  MA_Leader varchar(100) default NULL,
  MA_LeaderID bigint(20) unsigned, 
  MA_Advice text,
  MA_Document text,
  MA_Time datetime default NULL,
  MA_Applicant varchar(100) default NULL,
  MA_ApplicantID bigint(20) unsigned,
  PRIMARY KEY  (MM_ID)
) TYPE=BerkeleyDB;

CREATE TABLE MM_MeetingDetail (
  MM_ID bigint(20) unsigned NOT NULL default '0',
  MD_Name varchar(200) NOT NULL default '',
  MD_Subject varchar(200) default NULL,