📄 krm.sql
字号:
MD_PreAddress varchar(200) default NULL,
MD_PreTime datetime default NULL,
MD_Attendance text,
MD_Record text,
MD_Address text,
MD_BeginTime datetime default NULL,
MD_EndTime datetime default NULL,
MD_Master varchar(100) default NULL,
MD_MasterID bigint(20) unsigned,
MD_Recorder varchar(100) default NULL,
MD_RecorderID bigint(20) unsigned,
MD_IsOpen char(1) default '0',
PRIMARY KEY (MM_ID,MD_Name)
) TYPE=BerkeleyDB;
CREATE TABLE MM_MeetingInform (
MM_ID bigint(20) unsigned NOT NULL default '0',
MI_InfoTime datetime NOT NULL default '1900-01-01 00:00:00',
MI_SendUser varchar(20) NOT NULL default '',
MI_MeetTime datetime default NULL,
MI_MeetName varchar(200) default NULL,
MI_MeetSubject varchar(200) default NULL,
MI_MeetAddress varchar(200) default NULL,
MI_IsValid char(1) default '1',
PRIMARY KEY (MM_ID,MI_InfoTime)
) TYPE=BerkeleyDB;
CREATE TABLE MM_MeetingPreparation (
MM_ID bigint(20) unsigned NOT NULL default '0',
MP_Leader varchar(100) default NULL,
MP_LeaderID bigint(20) unsigned,
MP_Command text,
MP_Person varchar(100) default NULL,
MP_PersonID bigint(20) unsigned,
MP_Division varchar(200) default NULL,
PRIMARY KEY (MM_ID)
) TYPE=BerkeleyDB;
CREATE TABLE MM_MeetingStaff (
MM_ID bigint(20) unsigned NOT NULL default '0',
MS_Person varchar(100) NOT NULL default '',
MS_NoticeTime datetime NOT NULL default '1900-01-01 00:00:00',
MS_IsKnow char(1) default '0',
MS_IsLeave char(1) default '0',
MS_IsAttend char(1) default '0',
MS_LeftReason text,
PRIMARY KEY (MM_ID,MS_Person,MS_NoticeTime)
) TYPE=BerkeleyDB;
CREATE TABLE Birth_Card (
User_Name varchar(20) default NULL,
Send_UserName varchar(20) default NULL,
Wish_Content varchar(200) default NULL,
Create_Time datetime default NULL
) TYPE=BerkeleyDB;
CREATE TABLE Card_File (
UserName varchar(20) default NULL,
Card_File varchar(20) default NULL,
Card_Content varchar(60) default NULL,
Birthday date default NULL
) TYPE=BerkeleyDB;
CREATE TABLE Card_Image (
Card_ID tinyint(4) default NULL,
Card_FileName varchar(20) default NULL
) TYPE=BerkeleyDB;
CREATE TABLE Feast_Date (
Feast_ID varchar(10) default NULL,
Feast_Name varchar(20) default NULL,
Feast_Date date default NULL
) TYPE=BerkeleyDB;
CREATE TABLE l_UserInfo (
User_ID varchar(20) default NULL,
I_Name varchar(20) default NULL,
Dept_Name varchar(20) default NULL,
Function_Name varchar(20) default NULL
) TYPE=BerkeleyDB;
CREATE TABLE PE_PersonImage (
PE_ImageID varchar(20) default NULL,
PE_Name varchar(20) default NULL,
PE_ImageFile varchar(20) default NULL
) TYPE=BerkeleyDB;
CREATE TABLE U_TotalDiary (
User_ID varchar(20) default NULL,
I_Name varchar(20) default NULL,
Total_Date date default NULL,
Dept_Name varchar(20) default NULL
) TYPE=BerkeleyDB;
CREATE TABLE WD_PWorkDiary (
User_ID varchar(20) default NULL,
I_Name varchar(20) default NULL,
Total_Date date default NULL,
Dept_Name varchar(20) default NULL
) TYPE=BerkeleyDB;
CREATE TABLE WD_UWriteDiary (
User_ID varchar(20) default NULL,
User_Name varchar(20) default NULL
) TYPE=BerkeleyDB;
#日程安排表 2004-03-21
CREATE TABLE WD_CalendarItem (
CAL_ID bigint(20) NOT NULL,
CAL_date date default NULL,
CAL_phase varchar(20) default NULL,
CAL_content text,
CAL_place varchar(200) default NULL,
CAL_memo text,
CAL_owner varchar(50) default NULL,
MOD_perm text,
READ_perm text,
PRIMARY KEY (CAL_ID)
) TYPE=BerkeleyDB;
CREATE TABLE mydate (
id bigint(11) NOT NULL ,
d_year int(4) default NULL,
d_month int(4) default NULL,
d_day int(2) default NULL,
d_quarter int(1) default NULL,
d_weekday int(2) default NULL,
d_week int(2) default NULL,
d_weekdaycn varchar(6) default NULL,
weekorder int(4) default NULL,
PRIMARY KEY (id)
) TYPE=BerkeleyDB;
#自动生成编号
CREATE TABLE TypeID (
ID bigint(20) unsigned NOT NULL default 0,
ID_type varchar(20) default NULL,
PRIMARY KEY (ID)
) TYPE=BerkeleyDB;
CREATE TABLE WD_WorkTip (
WTD_ID bigint(20) NOT NULL default '0',
WTD_TaskNo varchar(20) default NULL,
UserID varchar(20) NOT NULL default '',
UserName varchar(20) default NULL,
WTD_DeptName varchar(20) default NULL,
WTD_XUserID varchar(20) default NULL,
WTD_XUserName varchar(20) default NULL,
WTD_RUserID varchar(20) default NULL,
WTD_RUserName varchar(20) default NULL,
WTD_MeetPerson varchar(100) default NULL,
WTD_ManagerID varchar(20) default NULL,
WTD_ManagerName varchar(20) default NULL,
WTD_Type tinyint(4) NOT NULL default '0',
WTD_Status tinyint(4) default '0',
WTD_Impact tinyint(4) default NULL,
WTD_TaskContent varchar(255) default NULL,
WTD_TipName varchar(20) default NULL,
WTD_TaskAim varchar(255) default NULL,
WTD_TaskPlan varchar(255) default NULL,
WTD_XTaskDate date default NULL,
WTD_AskDate date default NULL,
WTD_Flag tinyint(4) default '0',
WTD_TipDate date NOT NULL default '0000-00-00',
WTD_TaskID varchar(20) default NULL,
WTD_TaskName varchar(20) default NULL,
WTD_Memo varchar(255) default NULL,
WTD_Approve varchar(250) default NULL,
WTD_EndTipDate date default NULL,
WTD_PlanFee float(9,0) default NULL,
WTD_FactFee float(9,0) default '0',
PRIMARY KEY (WTD_ID)
) TYPE=BerkeleyDB;
CREATE TABLE WD_WorkTipList (
WTL_ID bigint(20) NOT NULL default '0',
WTD_ID bigint(20) NOT NULL default '0',
UserID varchar(20) NOT NULL default '',
WTL_Status tinyint(4) default '0',
WTL_Time datetime NOT NULL default '0000-00-00 00:00:00',
WTL_Text varchar(255) default NULL,
PRIMARY KEY (WTL_ID)
) TYPE=BerkeleyDB;
#/*接待管理部分数据库脚本，本部分共有八个表
# 2003.09.21
#*/
#CREATE DATABASE if NOT EXISTS krma6;
#表一
DROP table if EXISTS RE_Visitor;
create table RE_Visitor(
VIS_ID BIGINT not null primary key,
TEA_ID BIGINT NOT NULL ,
VIS_Unit VARCHAR(50) NULL,
VIS_Name varchar(20) NOT NULL default '',
VIS_Sex CHAR(1) NOT NULL,
VIS_Duty varchar(20) NOT NULL default '',
VIS_Taxis int NULL,
VIS_Memo VARCHAR(100) NULL
) TYPE=BerkeleyDB;
#表二
DROP table if EXISTS RE_Team;
create table RE_Team(
TEA_ID BIGINT not null primary key ,
TEA_Name varchar(50) NOT NULL default '',
TEA_Unit varchar(50) NOT NULL default '',
TEA_FurlDate datetime null,
TEA_Leader varchar(20) NOT NULL default '',
TEA_VisitDate datetime NOT NULL default '1900-01-01 00:00:00',
TEA_FemaleCount int not null,
TEA_MaleCount int not null,
TEA_VehicleNumber varchar(50) null,
TEA_LeaveDate datetime null,
TEA_Linkman varchar(20) null,
TEA_TEL varchar(20) null,
TEA_Order varchar(100) not null,
TEA_BuilderPersonID varchar(100) not null,
TEA_Memo varchar(200) null
) TYPE=BerkeleyDB;
#表三
DROP table if EXISTS RE_Task;
create table RE_Task(
TAS_ID BIGINT not null primary key ,
TAS_Name varchar(50) NOT NULL default '',
TAS_BuildDate datetime NOT NULL default '1900-01-01 00:00:00',
TAS_BuilderPersonID varchar(20) NOT NULL default '',
TAS_LinkmanID varchar(20) NOT NULL default '',
TAS_LinkmanName varchar(20) NOT NULL default '',
TAS_Summary text null,
TAS_CompleteDate datetime null,
TAS_Execute char(1) not null DEFAULT 'N',
TAS_Memo varchar(200) null
) TYPE=BerkeleyDB;
#表四
DROP table if EXISTS RE_Scheme;
create table RE_Scheme(
SCH_ID BIGINT not null primary key ,
TAS_ID BIGINT not null ,
TEA_ID BIGINT not null ,
SCH_Name varchar(50) not null,
SCH_VisitorEquest text null ,
SCH_ReceptionPrincipalID varchar(20) NOT NULL default '',
SCH_ReceptionPrincipallName varchar(20) NOT NULL default '',
SCH_ReceptionProject text null ,
SCH_OutlayOutgo int not null,
SCH_OutlayIncome int not null,
SCH_OutlayNetOutgo int not null,
SCH_IsAppend char(1) not null DEFAULT 'N',
SCH_Execute char(1) not null DEFAULT 'N'
) TYPE=BerkeleyDB;
#表五
DROP table if EXISTS RE_SCHUserInfo;
create table RE_SCHUserInfo(
SCH_ID BIGINT not null,
SUI_AccompanyPersonrID varchar(20) NOT NULL default '',
SUI_AccompanyPersonName varchar(20) NOT NULL default '',
SUI_DutyTag char(1) not null
) TYPE=BerkeleyDB;
#表六
DROP table if EXISTS RE_SchemeInfo;
create table RE_SchemeInfo(
SCI_ID BIGINT not null primary key ,
SCH_ID BIGINT not null,
SCI_ReadyMind varchar(200) not null,
SCI_ReadyPersonID varchar(20) NOT NULL default '',
SCI_ReadyPersonName varchar(20) NOT NULL default '',
SCI_ReadyDate datetime NOT NULL default '1900-01-01 00:00:00',
SCI_SendEAADate datetime NOT NULL default '1900-01-01 00:00:00',
SCI_SendMode char(1) not null DEFAULT 'N',
SCI_CompleteDate Datetime null,
SCI_FactIncome Int null,
SCI_FactOutgo int null,
SCI_Summary text null,
SCI_Confirm char(1) not null DEFAULT 'N',
SCI_InformPrint char(1) not null DEFAULT 'N',
SCI_ProjectPrint char(1) not null DEFAULT 'N',
SCI_ReportPrint char(1) not null DEFAULT 'N'
) TYPE=BerkeleyDB;
#表七
DROP table if EXISTS RE_InformUser;
create table RE_InformUser(
SCI_ID BIGINT not null,
INU_InformPersonID varchar(20) NOT NULL default '',
INU_InformPersontName varchar(20) NOT NULL default '',
INU_Message TEXT not null,
INU_InformDate datetime NOT NULL default '1900-01-01 00:00:00',
INU_IsRead char(1) not null DEFAULT 'N'
) TYPE=BerkeleyDB;
#表八
DROP table if EXISTS RE_ApproveFlow;
create table RE_ApproveFlow(
APF_ID BIGINT not null primary key ,
SCH_ID BIGINT not null,
APF_ComeDate datetime NOT NULL default '1900-01-01 00:00:00',
APF_Step Int not null,
APF_EAAID varchar(20) NOT NULL default '',
APF_EAAName varchar(20) NOT NULL default '',
APF_FactEAAID varchar(20) null,
APF_FactEAAName varchar(20) null,
APF_Mind varchar(100) not null,
APF_EAAText varchar(200) null,
APF_Date datetime NOT NULL default '1900-01-01 00:00:00'
) TYPE=BerkeleyDB;
#/*以下是分别给参与接待人员信息表，通知用户信息表，审批流程表#
#建立索引
#*/
#/*ALTER TABLE RE_SCHUserInfo ADD INDEX SIBySCHID (SCH_ID);
#ALTER TABLE RE_InformUser ADD INDEX IUByPRIID (SCI_ID);
#ALTER TABLE RE_ApproveFlow ADD INDEX AFBySCHID (SCH_ID);*/
insert into SM_ModuleInfo (MI_ModuleID,MI_ModuleName) values("1","公文管理");
insert into SM_ModuleInfo (MI_ModuleID,MI_ModuleName) values("2","通讯管理");
insert into SM_ModuleInfo (MI_ModuleID,MI_ModuleName) values("3","任务管理");
insert into SM_ModuleInfo (MI_ModuleID,MI_ModuleName) values("4","人事管理");
insert into SM_ModuleInfo (MI_ModuleID,MI_ModuleName) values("5","工作日记");
insert into SM_ModuleInfo (MI_ModuleID,MI_ModuleName) values("6","接待管理");
insert into SM_ModuleInfo (MI_ModuleID,MI_ModuleName) values("7","考勤管理");
insert into SM_ModuleInfo (MI_ModuleID,MI_ModuleName) values("8","车辆管理");
insert into SM_ModuleInfo (MI_ModuleID,MI_ModuleName) values("9","财务管理");
insert into SM_ModuleInfo (MI_ModuleID,MI_ModuleName) values("10","会议管理");
insert into SM_ModuleInfo (MI_ModuleID,MI_ModuleName) values("11","知识管理");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("1","发文管理","1");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("2","收文管理","1");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("3","参数设置","1");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("4","公文催办","1");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("5","来文登记","1");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("6","发文拟稿","1");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("1","通知管理","2");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("2","信件管理","2");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("3","通讯录","2");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("1","年度目标信息","3");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("2","项目信息","3");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("3","计划信息","3");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("4","任务基本信息","3");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("5","大事记信息","3");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("6","每周要事","3");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("7","问题回复","3");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("8","回复流程参数设置","3");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("9","正式立项","3");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("10","立项申请","3");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("8","参数设置","4");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("4","离退休纪事","4");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("2","离退休基本信息","4");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("1","人事信息","4");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("6","编制数目信息","4");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values("3","部门信息","4");
insert into SM_BasicAuthUnit (BAU_UnitID,BAU_UnitName,BAU_ModuleID ) values('5','培训信息','4');
insert ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -