if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblUser]
GO
CREATE TABLE [dbo].[tblInfo] (
[InfoID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[Processed] [bit] NOT NULL ,
[DeptSend] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DeptRecieve] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Addresser] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[AddresserTel] [varchar] (24) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ProcTimeLimit] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SendTime] [datetime] NOT NULL ,
[InfoContent] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Replyer] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ReplyerTel] [varchar] (24) COLLATE Chinese_PRC_CI_AS NULL ,
[ReplyTime] [datetime] NULL ,
[ReplyContent] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblUser] (
[UserName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[UserPwd] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[TrueName] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DeptUserIn] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
企业内部通信系统，给内部各部人员通信使用
需积分: 10 17 浏览量
2009-06-17
13:04:03
上传
评论
收藏 342KB RAR 举报
.rar （21个子文件） 
开发源文件 InfoProSys 
frmSendInfo.frm 16KB frmMain.frx 38KB frmUsrMgmt.frm 13KB MSSCCPRJ.SCC 199B InfoProcSystem.vbw 442B InfoProcSystem.vbp 1KB frmAbout.frm 6KB mdlSetIntr.bas 2KB frmMain.log 170B frmGetInfo.frm 9KB
InfoProSystem.exe 208KB frmMain.frm 45KB frmLogin.frm 10KB frmPrompt.frm 971B Msg.wav 117KB frmLogin.frx 4KB mdlPublic.bas 2KB 数据库 备份文件 InfoProcSystem.db.bak 979KB SQL脚本 InfoProcSystem.sql 3KB MDF文件 InfoProcSystem_Data.MDF 1024KB InfoProcSystem_Log.LDF 1024KB资源评论
