📄 base.sql
字号:
CREATE TABLE [dbo].[ParaTable] (
[ParaName] [varchar] (50) NOT NULL ,
[ParaValue] [varchar] (200) NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[ErrorType] (
[errTypeId] [int] NOT NULL ,
[description] [varchar] (100) NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[ExmTemp] (
[ExmTempId] [numeric](20, 0) NULL ,
[ExmId] [numeric](20, 0) NULL ,
[TempKind] [varchar] (100) NULL ,
[TagsName] [varchar] (50) NULL ,
[TagsValue] [varchar] (255) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[File_Info] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[File_Name] [varchar] (255) NOT NULL ,
[File_Id] [varchar] (50) NULL ,
[Return_Date] [datetime] NULL ,
[Return_Man] [varchar] (20) NULL ,
[File_Source] [varchar] (255) NULL ,
[Slave_File] [varchar] (255) NULL ,
[Remark] [varchar] (255) NULL ,
[Theme] [varchar] (255) NULL ,
[TypeSec_Index] [int] NULL ,
[Author] [varchar] (50) NULL ,
[Lie_Flag] [int] NULL ,
[File_Station] [varchar] (255) NULL ,
[OldName] [varchar] (255) NULL ,
[NewName] [varchar] (255) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[File_PerRight] (
[UserName] [varchar] (20) NOT NULL ,
[TypeSec_Index] [int] NULL ,
[UserRight] [int] NULL ,
[UserType] [int] NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[File_TypeSec] (
[TypeSec_Index] [int] NOT NULL ,
[Type_Info] [varchar] (50) NOT NULL ,
[Sec_Index] [varchar] (50) NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[LimitTime] (
[InstallTime] [varchar] (20) NULL ,
[DisTime] [varchar] (20) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[ListRecord] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[ListName] [varchar] (30) NOT NULL ,
[ListContent] [varchar] (50) NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[MeetPrompt] (
[PromptId] [int] NULL ,
[Operate] [smallint] NULL ,
[Meetid] [int] NULL ,
[Thingid] [int] NULL ,
[Verid] [int] NULL ,
[Courseflag] [smallint] NULL ,
[ApplyId] [int] NULL ,
[EmailSubject] [varchar] (255) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[MeetRoom] (
[RoomId] [int] NULL ,
[RoomName] [varchar] (50) NOT NULL ,
[CheckFlag] [int] NULL ,
[stopuse] [smallint] NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[MeetRoomState] (
[OrderID] [int] NOT NULL ,
[ApplyID] [int] NOT NULL ,
[RoomId] [int] NOT NULL ,
[ApplyTime] [varchar] (16) NOT NULL ,
[UseDate] [varchar] (16) NULL ,
[UseTime] [smallint] NOT NULL ,
[UserName] [varchar] (50) NOT NULL ,
[Department_c] [varchar] (50) NOT NULL ,
[PassFlag] [int] NOT NULL ,
[Remark] [varchar] (50) NULL ,
[PersonNumber] [int] NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[NewsForms] (
[NewsId] [int] IDENTITY (1, 1) NOT NULL ,
[Provider] [varchar] (255) NOT NULL ,
[Title] [varchar] (255) NOT NULL ,
[TempFile] [varchar] (255) NOT NULL ,
[Department] [varchar] (255) NOT NULL ,
[DisFile] [varchar] (255) NULL ,
[EndDate] [smalldatetime] NULL ,
[flag] [int] NOT NULL ,
[Remark] [varchar] (255) NULL ,
[IssueDate] [smalldatetime] NULL ,
[PersonName] [varchar] (50) NULL ,
[NewsContent] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
CREATE TABLE [dbo].[NewsState] (
[UserId] [varchar] (30) NOT NULL ,
[NewsId] [varchar] (30) NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[NewsStyle] (
[FontName] [varchar] (50) NULL ,
[FontSize] [smallint] NULL ,
[FontColor] [varchar] (50) NULL ,
[tFontName] [varchar] (50) NULL ,
[tFontSize] [smallint] NULL ,
[tFontColor] [varchar] (50) NULL ,
[Title] [varchar] (50) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[RemindMain] (
[Id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[MindType] [varchar] (20) NOT NULL ,
[MindFlag] [char] (1) NOT NULL ,
[MIndUser] [varchar] (50) NOT NULL ,
[Mindcontent] [varchar] (255) NULL ,
[MindDate] [datetime] NOT NULL ,
[MsgCreater] [varchar] (50) NULL ,
[MsgCreatDate] [datetime] NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[RemindSub] (
[Mindid] [numeric](18, 0) NOT NULL ,
[ExtId] [int] NOT NULL ,
[Extinfo] [varchar] (255) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[groupuser] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[groupname] [varchar] (50) NOT NULL ,
[username] [varchar] (50) NOT NULL ,
[deparment_c] [varchar] (50) NOT NULL ,
[username_c] [varchar] (50) NOT NULL ,
[password] [varchar] (50) NULL ,
[phoneNo] [varchar] (50) NULL ,
[ArrangeOrder] [int] NULL ,
[tagpsw] [varchar] (50) NOT NULL ,
[Field1] [varchar] (50) NOT NULL
) ON [PRIMARY]
/* 默认值脚本开始 */
ALTER TABLE [dbo].[NewsForms] WITH NOCHECK ADD
CONSTRAINT [DF_NewsForms_PersonName] DEFAULT (' ') FOR [PersonName],
CONSTRAINT [DF_NewsForms_NewsContent] DEFAULT (' ') FOR [NewsContent]
ALTER TABLE [dbo].[RemindMain] WITH NOCHECK ADD
CONSTRAINT [DF_RemindMain_Content] DEFAULT (' ') FOR [Mindcontent],
CONSTRAINT [DF_ReMindMain_MsgCreater] DEFAULT (' ') FOR [MsgCreater],
CONSTRAINT [DF_ReMindMain_MsgCreatDate] DEFAULT (' ') FOR [MsgCreatDate]
ALTER TABLE [dbo].[RemindSub] WITH NOCHECK ADD
CONSTRAINT [DF_RemindSub_Extinfo] DEFAULT (' ') FOR [Extinfo]
ALTER TABLE [dbo].[groupuser] WITH NOCHECK ADD
CONSTRAINT [DF_groupuser_ArrangeOrder] DEFAULT (0) FOR [ArrangeOrder]
/* 默认值脚本结束 */
CREATE TABLE [dbo].[infoprompt] (
[PromptId] [int] NULL ,
[LonUser] [varchar] (50) NULL ,
[PromptContent] [varchar] (255) NULL ,
[PromptTime] [varchar] (16) NULL ,
[EndFlag] [char] (1) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[mainpagestyle] (
[leftbanner] [varchar] (255) NOT NULL ,
[banner] [varchar] (255) NOT NULL ,
[content] [varchar] (255) NOT NULL ,
[rightStyle] [varchar] (255) NOT NULL ,
[title] [varchar] (255) NULL ,
[font] [varchar] (50) NULL ,
[fontsize] [smallint] NULL ,
[color] [varchar] (20) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[mainpagepath] (
[mainpagepath] [varchar] (255) NOT NULL ,
[mainname] [varchar] (50) NULL ,
[servername] [varchar] (50) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[rc_popedom] (
[dxr] [varchar] (50) NOT NULL ,
[zxry] [varchar] (50) NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[richeng] (
[rcid] [int] NOT NULL ,
[decldate] [varchar] (14) NULL ,
[body] [varchar] (255) NULL ,
[zxry] [varchar] (50) NULL ,
[jsry] [varchar] (50) NULL ,
[inputdate] [varchar] (14) NULL ,
[remindid] [int] NULL ,
[source] [smallint] NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[tbContactorInfo] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[UserID] [int] NOT NULL ,
[ClassID] [int] NOT NULL ,
[Name] [varchar] (60) NOT NULL ,
[Sex] [tinyint] NULL ,
[MailAddress] [varchar] (50) NULL ,
[Phone] [char] (18) NULL ,
[CorpName] [varchar] (80) NULL ,
[Department] [varchar] (40) NULL ,
[Province] [varchar] (40) NULL ,
[InnerUserID] [int] NULL ,
[OtherContactMethod] [varchar] (100) NOT NULL ,
[Comment] [varchar] (250) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[tbDocInfo] (
[DocID] [int] NOT NULL ,
[CreateDate] [datetime] NULL ,
[SecuLevel] [int] NULL ,
[Author] [varchar] (100) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[tbDocument] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Filename] [varchar] (250) NULL ,
[FileTitle] [varchar] (250) NOT NULL ,
[FileSize] [int] NOT NULL ,
[Document] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
CREATE TABLE [dbo].[tbMail] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[FolderID] [int] NOT NULL ,
[SenderInfo] [varchar] (150) NOT NULL ,
[ReceiverInfo] [varchar] (500) NOT NULL ,
[CCInfo] [varchar] (500) NULL ,
[BCCInfo] [varchar] (500) NULL ,
[EditEnable] [tinyint] NULL ,
[SourceFolderID] [int] NULL ,
[SendDate] [datetime] NULL ,
[Title] [varchar] (250) NULL ,
[Content] [text] NULL ,
[BCCFlag] [tinyint] NULL ,
[ImportantFlag] [tinyint] NULL ,
[RequireReplyFlag] [tinyint] NULL ,
[ReadFlag] [tinyint] NULL ,
[DestReadFlag] [tinyint] NULL ,
[ComeInMailID] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
CREATE TABLE [dbo].[tbMailAttachment] (
[MailID] [int] NOT NULL ,
[DocID] [int] NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[tbUserContactorClass] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[UserID] [int] NOT NULL ,
[ClassName] [char] (20) NOT NULL ,
[Comment] [varchar] (150) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[tbUserFolder] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[FolderName] [varchar] (50) NOT NULL ,
[SysFolderFlag] [tinyint] NOT NULL ,
[Comment] [varchar] (150) NULL ,
[UserID] [int] NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[tbUserMailServer] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[UserID] [int] NOT NULL ,
[Username] [varchar] (30) NULL ,
[DisplayName] [varchar] (90) NULL ,
[MailAddress] [varchar] (50) NOT NULL ,
[SMTP_Address] [varchar] (50) NOT NULL ,
[SMTP_Port] [int] NOT NULL ,
[POP3_Address] [varchar] (50) NOT NULL ,
[POP3_Port] [int] NOT NULL ,
[Password] [varchar] (20) NOT NULL ,
[DefaultFlag] [tinyint] NOT NULL ,
[IsDelete] [tinyint] NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[treebase] (
[treeno] [varchar] (10) NOT NULL ,
[treename] [varchar] (50) NOT NULL ,
[linkstate] [smallint] NOT NULL ,
[linkfile] [varchar] (255) NULL ,
[dispstate] [smallint] NOT NULL ,
[dispstyle] [smallint] NOT NULL ,
[font] [varchar] (50) NULL ,
[fontsize] [smallint] NULL ,
[staticcolor] [varchar] (50) NULL ,
[dynamiccolor] [varchar] (50) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[treedefault] (
[font] [varchar] (50) NOT NULL ,
[fontsize] [smallint] NOT NULL ,
[staticcolor] [varchar] (50) NOT NULL ,
[dynamiccolor] [varchar] (50) NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[treelimit] (
[treeno] [varchar] (10) NOT NULL ,
[groupname] [varchar] (50) NOT NULL ,
[username] [varchar] (50) NOT NULL ,
[limit] [varchar] (10) NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[AppLimittest] (
[Code] [int] NOT NULL ,
[LimitName] [varchar] (250) NOT NULL ,
[DealType] [varchar] (250) NULL ,
[DealName] [varchar] (250) NOT NULL ,
[DealTable] [varchar] (250) NULL ,
[Query] [varchar] (1) NULL ,
[Edit] [varchar] (1) NULL ,
[Write] [varchar] (1) NULL ,
[Explain] [varchar] (250) NULL
) ON [PRIMARY]
insert into treebase values('0909','查找/编辑','9','SystemAsp\DealNews\Issue\editnews.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('09','通知通告','1','SystemAsp\DealNews\Provide\ProvideNews.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('0907','审查','9','SystemAsp\DealNews\Check\CheckupNews.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('0908','直接发布','9','systemasp\dealnews\issue\provide.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('10','电子邮件','9','systemasp/email/aspfile/bk_mail.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('11','日常办公','1','','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('1110','会议室管理','2','systemasp\meetroom\admin\mainweb.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('111004','维护会议室','2','systemasp\meetroom\admin\meetmaint.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('111002','申请会议室','2','systemasp\meetroom\admin\sendmeetapply.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('1112','日程安排','1','','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('34','意见箱','3','意见箱\','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('36','文档管理','1','SystemAsp\DocManage\SearchFiles\Begin.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('3602','科目密级','6','SystemAsp\DocManage\SecureTypeEdit.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('3604','删除文件','6','SystemAsp\DocManage\DelFiles\Begin.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('3605','归档文件','6','SystemAsp\DocManage\FileUpload.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('111201','日程管理','2','SystemAsp\Richeng\default.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('111202','日程查询','2','SystemAsp\Richeng\rc_view.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('0910','通知通告状态','9','SystemAsp\DealNews\Issue\IssueNews.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('63','系统工具','1','','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('6301','应用系统生成器','7','SystemAsp\AppWizard\AppTable.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('6304','常用名词','7','SystemAsp\AppWizard\Tools\EditSelectInfo.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('111001','查看会议室','2','SystemAsp\meetroom\admin\viewmeetroom.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('111003','审批会议室','2','SystemAsp\meetroom\admin\viewmeetapply.asp','1','2','新宋体','12','&H00FFFFFF&','&H000000FF&')
insert into treebase values('39','公文','1','','1','2','新宋体','12','&H00A00000&','&H000000FF&')
insert into treebase values('3901','收文','2','SystemAsp\AcceptSend\accept\default.asp','1','3','新宋体','12','&H00A00000&','&H000000FF&')
insert into treebase values('3902','发文','2','SystemAsp\AcceptSend\SendFile\default.asp','1','3','新宋体','12','&H00A00000&','&H000000FF&')
insert into treebase values('40','档案','2','SystemAsp\documentMang\default.htm','1','3','新宋体','12','&H00A00000&','&H000000FF&')
insert into treebase values('6306','收发文权限','2','SystemAsp\AcceptSend\limit\TransferRule.asp','1','3','新宋体','12','&H00A00000&','&H000000FF&')
insert into treebase values('6307','收文分类','2','SystemAsp\AcceptSend\acceptCode\FwMainFrame.htm','1','3','新宋体','12','&H00A00000&','&H000000FF&')
insert into treebase values('6308','发文分类','2','SystemAsp\AcceptSend\SendCode\FwMainFrame.htm','1','3','新宋体','12','&H00A00000&','&H000000FF&')
insert into treebase values('6305','系统参数','2','SystemAsp\Syspara\maint.asp','1','3','新宋体','12','&H00A00000&','&H000000FF&')
insert into mainpagestyle values('IMAGE\tongYong\lbanner.gif','IMAGE\tongYong\BANNER.GIF','IMAGE\tongYong\LEFT.JPG','IMAGE\newimg\center.gif','','楷体_GB2312','36','&H00FF0000&')
insert into newsstyle values('新宋体','18','&H00A00000&','新宋体','22','&H00808000&','通知通告')
insert into treedefault values('新宋体','12','&H00A00000&','&H000000FF&')
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -