OA---数据库数据脚本.doc

if exists (select * from sysobjects where id = OBJECT_ID(ERPAnPai) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPAnPaiCREATE TABLE ERPAnPai (ID int IDENTITY (1, 1) NOT NULL,UserName varchar (50) NULL,TitleStr varchar (500) NULL,ContentStr text NULL,TimeStart datetime NULL,TimeEnd datetime NULL,TimeTiXing datetime NULL,TypeStr varchar (50) NULL,TimeStr datetime NULL DEFAULT (getdate(),GongXiangWho varchar (5000) NULL)ALTER TABLE ERPAnPai WITH NOCHECK ADD CONSTRAINT PK_ERPAnPai PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPAnPai ONINSERT ERPAnPai (ID,UserName,TitleStr,ContentStr,TimeStart,TimeEnd,TimeTiXing,TypeStr,GongXiangWho) VALUES ( 20,admin,举行公司内部例会，要准时参加,准时参加单位内部例会，通知其他参会人员，外派人员也要同时参加。,2012-03-10 9:00:00,2012-03-10 12:00:00,2012-03-10 0:00:00,单位事务,待处理)INSERT ERPAnPai (ID,UserName,TitleStr,ContentStr,TimeStart,TimeEnd,TimeTiXing,TypeStr,TimeStr,GongXiangWho) VALUES ( 21,admin,营销课程培训，按照要求参加,单位营销课程培训，需要全体人员参加，提前准备资料。,2012-04-18 13:00:00,2012-04-18 15:00:00,2012-04-18 0:00:00,个人事务,2012-02-29 15:59:13,待处理)INSERT ERPAnPai (ID,UserName,TitleStr,ContentStr,TimeStart,TimeEnd,TimeTiXing,TypeStr,TimeStr,GongXiangWho) VALUES ( 22,admin,客户现场处理问题，同时联系驻点工程师,及时去客户现场处理问题，联系驻点工程师一起前往。,2012-05-21 8:00:00,2012-05-21 17:00:00,2012-05-21 0:00:00,单位事务,2012-02-29 16:00:37,待处理)SET IDENTITY_INSERT ERPAnPai OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPBaoJia) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPBaoJiaCREATE TABLE ERPBaoJia (ID int IDENTITY (1, 1) NOT NULL,CustomName varchar (100) NULL,BaoJiaTitle varchar (500) NULL,BaoJiaType varchar (500) NULL,BaoJiaJinE varchar (500) NULL,BaoJiaContent varchar (8000) NULL,BaoJiaResult varchar (5000) NULL,BaoJiaTime varchar (500) NULL,BackInfo varchar (8000) NULL,UserName varchar (50) NULL,TimeStr datetime NULL DEFAULT (getdate(),IFShare varchar (5000) NULL,CusBakA varchar (8000) NULL,CusBakB varchar (8000) NULL,CusBakC varchar (8000) NULL,CusBakD varchar (8000) NULL,CusBakE varchar (8000) NULL)ALTER TABLE ERPBaoJia WITH NOCHECK ADD CONSTRAINT PK_ERPBaoJia PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPBaoJia ONINSERT ERPBaoJia (ID,CustomName,BaoJiaTitle,BaoJiaType,BaoJiaJinE,BaoJiaContent,BaoJiaResult,BaoJiaTime,UserName,TimeStr) VALUES ( 3,重庆大江美丽信工业制品有限公司,OA办公自动化系统报价,初次报价,35000,符合全部需求，包含实施培训,成功,2012-3-1,admin,2012-03-2 11:46:21)SET IDENTITY_INSERT ERPBaoJia OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPBaoXiao) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPBaoXiaoCREATE TABLE ERPBaoXiao (ID int IDENTITY (1, 1) NOT NULL,ProjectName varchar (200) NULL,FeiYongType varchar (50) NULL,ShenQingRen varchar (50) NULL,ShenPiRen varchar (50) NULL,ShenQingContent varchar (5000) NULL,JinE varchar (50) NULL,StateNow varchar (50) NULL,Username varchar (50) NULL,ShenQingTime datetime NULL DEFAULT (getdate()ALTER TABLE ERPBaoXiao WITH NOCHECK ADD CONSTRAINT PK_ERPBaoXiao PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPBaoXiao ONINSERT ERPBaoXiao (ID,ProjectName,FeiYongType,ShenQingRen,ShenPiRen,ShenQingContent,JinE,StateNow,Username,ShenQingTime) VALUES ( 3,大江信息化实施项目,出差,admin,admin,申请报销出差时花费的元,5000,通过,admin,2012-03-2 12:08:54)SET IDENTITY_INSERT ERPBaoXiao OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPBBSBanKuai) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPBBSBanKuaiCREATE TABLE ERPBBSBanKuai (ID int IDENTITY (1, 1) NOT NULL,BanKuaiName varchar (500) NULL,BanZhuList varchar (500) NULL,BanKuaiMiaoShu varchar (8000) NULL,BanKuaiImg varchar (200) NULL,JiaoSeXianZhiList varchar (8000) NULL,BuMenXianZhi varchar (8000) NULL,UserXianZhi varchar (8000) NULL)ALTER TABLE ERPBBSBanKuai WITH NOCHECK ADD CONSTRAINT PK_ERPBBSBanKuai PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPBBSBanKuai ONINSERT ERPBBSBanKuai (ID,BanKuaiName,BanZhuList,BanKuaiMiaoShu,BanKuaiImg,JiaoSeXianZhiList,BuMenXianZhi,UserXianZhi) VALUES ( 1,休闲娱乐,admin,员工休闲娱乐区，畅所欲言！,BanKuai.gif,所有角色,所有部门,所有用户)INSERT ERPBBSBanKuai (ID,BanKuaiName,BanZhuList,BanKuaiMiaoShu,BanKuaiImg,JiaoSeXianZhiList,BuMenXianZhi,UserXianZhi) VALUES ( 2,灌水乐园,admin,英雄莫问出处，吹水不询缘由。灌就一个字.,BanKuai.gif,所有角色,所有部门,所有用户)INSERT ERPBBSBanKuai (ID,BanKuaiName,BanZhuList,BanKuaiMiaoShu,BanKuaiImg,JiaoSeXianZhiList,BuMenXianZhi,UserXianZhi) VALUES ( 3,文学天地,admin,网络是虚幻的，情感是苍白的，文字是真实的；我们以虔诚的心捧赤子之笔，书写自己或别人的故事。,BanKuai.gif,所有角色,所有部门,所有用户)INSERT ERPBBSBanKuai (ID,BanKuaiName,BanZhuList,BanKuaiMiaoShu,BanKuaiImg,JiaoSeXianZhiList,BuMenXianZhi,UserXianZhi) VALUES ( 4,贴图专区,admin,人物| 景物| 体育| 会员靓照| 其他美图| 图像制作| 搞笑| 另类.图文并茂，展示你的风采。,BanKuai.gif,所有角色,所有部门,所有用户)INSERT ERPBBSBanKuai (ID,BanKuaiName,BanZhuList,BanKuaiMiaoShu,BanKuaiImg,JiaoSeXianZhiList,BuMenXianZhi,UserXianZhi) VALUES ( 5,时尚生活,admin,每一天，都要活出新的精彩，让年轻的个性在时尚中尽情延伸.,BanKuai.gif,所有角色,所有部门,所有用户)INSERT ERPBBSBanKuai (ID,BanKuaiName,BanZhuList,BanKuaiMiaoShu,BanKuaiImg,JiaoSeXianZhiList,BuMenXianZhi,UserXianZhi) VALUES ( 6,音乐星空,admin,畅游音乐的天堂，感受美好的世界。,BanKuai.gif,所有角色,所有部门,所有用户)SET IDENTITY_INSERT ERPBBSBanKuai OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPBBSTieZi) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPBBSTieZiCREATE TABLE ERPBBSTieZi (ID int IDENTITY (1, 1) NOT NULL,BanKuaiID int NULL,TitleStr varchar (500) NULL,UserName varchar (50) NULL,TimeStr datetime NULL DEFAULT (getdate(),ContentStr text NULL,ZuiHouUser varchar (50) NULL,ZuiHouTime datetime NULL DEFAULT (getdate(),PaiXu int NULL DEFAULT (0),HuiFuContent text NULL)ALTER TABLE ERPBBSTieZi WITH NOCHECK ADD CONSTRAINT PK_ERPBBSTieZi PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPBBSTieZi ONINSERT ERPBBSTieZi (ID,BanKuaiID,TitleStr,UserName,TimeStr,ContentStr,ZuiHouUser,ZuiHouTime,PaiXu) VALUES ( 4,6,十年的百度是一个年轻的企业，十年的百度是一个从零到亿的突破。,admin,2012-03-2 12:36:52,十年的百度是一个年轻的企业，十年的百度是一个从零到亿的突破，十年的百度是从个人到人的跨越。十年的百度亲历了中国互联网的兴衰，一路凯歌的背后是一路坎坷，一路坎坷的背后是百度人的乐观、专注和激情。看百度十年，看中国互联网十年，是谁在推动着中国的进步，是谁在帮助亿万人走向成功。从北京到纳斯达克，从艰难创业到功成名就，是什么在坚定着李彦宏的信念，是什么影响着百度人的生活百度大厦历史展厅，将为你一一解读。,admin,2012-03-2 12:36:52,0)INSERT ERPBBSTieZi (ID,BanKuaiID,TitleStr,UserName,TimeStr,ContentStr,ZuiHouUser,ZuiHouTime,PaiXu) VALUES ( 5,6,通过它找到心中所想，通过它与人交流，通过它实现梦想。,admin,2012-03-2 12:37:16,当互联网大潮来袭，我们每个人都无一幸免的陷入其中。我们通过它来了解世界，通过它找到心中所想，通过它与人交流，通过它实现梦想。我们的生活方式正在悄然发生着改变，可能有些我们已经发现，有些我们还全然不觉。今天，电话还是唯一的沟通工具吗？一定还要去图书馆查询资料吗？你的问题只有你自己在关注吗？什么才是你完全离不开的？百度大厦产品展厅，向您解读您和您身边正在发生的变化，看百度为您营造的全新生活方式,admin,2012-03-2 12:37:16,0)SET IDENTITY_INSERT ERPBBSTieZi OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPBook) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPBookCREATE TABLE ERPBook (ID int IDENTITY (1, 1) NOT NULL,BookName varchar (50) NULL,BookSerils varchar (50) NULL,SuoShuBuMen varchar (50) NULL,BookType varchar (50) NULL,Auother varchar (50) NULL,ISBN varchar (50) NULL,CoperStr varchar (50) NULL,ChuBanDate varchar (50) NULL,CunFangDian varchar (50) NULL,ShuLiang varchar (50) NULL,JiaGe varchar (50) NULL,NeiRong varchar (5000) NULL,NowState varchar (50) NULL,BackInfo varchar (5000) NULL,UserName varchar (50) NULL,TimeStr datetime NULL)ALTER TABLE ERPBook WITH NOCHECK ADD CONSTRAINT PK_ERPBook PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPBook ONINSERT ERPBook (ID,BookName,BookSerils,SuoShuBuMen,BookType,Auother,ISBN,CoperStr,ChuBanDate,CunFangDian,ShuLiang,JiaGe,NeiRong,NowState,BackInfo,UserName,TimeStr) VALUES ( 2,程序基本编码规范,CX-001,开发部,技术书籍,佰鼎科技,BD0982001,佰鼎出版社,2012-3-1,B柜,6,50,讲述程序基本编码规范，有利于学习。,在用,无,admin,2012-03-2 10:35:14)SET IDENTITY_INSERT ERPBook OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPBookJieHuan) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPBookJieHuanCREATE TABLE ERPBookJieHuan (ID int IDENTITY (1, 1) NOT NULL,BookName varchar (50) NULL,JieShuDate varchar (50) NULL,GuiHuanDate varchar (50) NULL,JieHuanState varchar (50) NULL,BackInfo varchar (5000) NULL,UserName varchar (50) NULL,TimeStr datetime NULL)ALTER TABLE ERPBookJieHuan WITH NOCHECK ADD CONSTRAINT PK_ERPBookJieHuan PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPBookJieHuan ONINSERT ERPBookJieHuan (ID,BookName,JieShuDate,GuiHuanDate,JieHuanState,BackInfo,UserName,TimeStr) VALUES ( 4,程序基本编码规范,2012-3-1,2012-3-2,已归还,无,朵夏琳,2012-03-2 10:35:46)INSERT ERPBookJieHuan (ID,BookName,JieShuDate,JieHuanState,BackInfo,UserName,TimeStr) VALUES ( 5,程序基本编码规范,2012-3-2,已借出,无,周标,2012-03-2 10:36:26)SET IDENTITY_INSERT ERPBookJieHuan OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPBuMen) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPBuMenCREATE TABLE ERPBuMen (ID int IDENTITY (1, 1) NOT NULL,BuMenName varchar (50) NULL,ChargeMan varchar (50) NULL,TelStr varchar (50) NULL,ChuanZhen varchar (50) NULL,BackInfo varchar (8000) NULL,DirID int NULL)ALTER TABLE ERPBuMen WITH NOCHECK ADD CONSTRAINT PK_ERPBuMen PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPBuMen ONINSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 29,重庆佰鼎科技有限责任公司,admin023-67466469,0)INSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 30,客服部,admin023-67466469,29)INSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 31,开发部,admin023-67466469,29)INSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 32,技术部,admin023-67466469,29)INSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 33,财务部,admin023-67466469,29)INSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 34,总经办,admin023-67466469,29)INSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 35,销售部,admin023-67466469,29)INSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 36,综合部,admin023-67466469,29)INSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 42,广告营销,admin023-67466469,35)INSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 43,产品销售,admin023-67466469,35)INSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 44,综合办公室,admin023-67466469,36)INSERT ERPBuMen (ID,BuMenName,ChargeMan,TelStr,ChuanZhen,DirID) VALUES ( 45,西南办事处,admin023-67466469,36)SET IDENTITY_INSERT ERPBuMen OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPBuyChanPin) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPBuyChanPinCREATE TABLE ERPBuyChanPin (ID int IDENTITY (1, 1) NOT NULL,OrderName varchar (50) NULL,ProductName varchar (50) NULL,ProductSerils varchar (50) NULL,GongYingShang varchar (50) NULL,ProductType varchar (50) NULL,XingHao varchar (50) NULL,DanWei varchar (50) NULL,DanJia numeric (18,2) NULL,ShuLiang numeric (18,2) NULL,ZongJia numeric (18,2) NULL,YiFuKuan numeric (18,2) NULL,QianKuanShu numeric (18,2) NULL,IFJiaoFu varchar (50) NULL,ChanPinMiaoShu varchar (5000) NULL,UserName varchar (50) NULL,TimeStr datetime NULL,BackInfo varchar (5000) NULL)ALTER TABLE ERPBuyChanPin WITH NOCHECK ADD CONSTRAINT PK_ERPBuyChanPin PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPBuyChanPin ONINSERT ERPBuyChanPin (ID,OrderName,ProductName,ProductSerils,GongYingShang,ProductType,XingHao,DanWei,DanJia,ShuLiang,ZongJia,YiFuKuan,QianKuanShu,IFJiaoFu,UserName,TimeStr) VALUES ( 3,联想服务器采购合同,服务器主机,BD-CP-001,联想电脑,硬件产品,服务器版,台,30000.00,7.00,210000.00,210000.00,0.00,已交付,admin,2012-03-2 12:01:11)SET IDENTITY_INSERT ERPBuyChanPin OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPBuyOrder) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPBuyOrderCREATE TABLE ERPBuyOrder (ID int IDENTITY (1, 1) NOT NULL,OrderName varchar (50) NULL,GongYingShangName varchar (50) NULL,Serils varchar (50) NULL,DingDanLeiXing varchar (50) NULL,DingDanMiaoShu varchar (5000) NULL,CreateDate datetime NULL,LaiHuoDate datetime NULL,TiXingDate datetime NULL,ChuangJianRen varchar (50) NULL,FuZeRen varchar (50) NULL,FuJianList varchar (500) NULL,NowState varchar (50) NULL,ShenPiTongGuoRen varchar (50) NULL,BackInfo text NULL,UserName varchar (50) NULL,TimeStr datetime NULL DEFAULT (getdate()ALTER TABLE ERPBuyOrder WITH NOCHECK ADD CONSTRAINT PK_ERPBuyOrder PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPBuyOrder ONINSERT ERPBuyOrder (ID,OrderName,GongYingShangName,Serils,DingDanLeiXing,DingDanMiaoShu,CreateDate,LaiHuoDate,TiXingDate,ChuangJianRen,FuZeRen,NowState,BackInfo,UserName,TimeStr) VALUES ( 2,联想服务器采购合同,联想电脑,BD-CG-001,重要订单,采购联想服务器,2012-03-1 0:00:00,2012-03-2 0:00:00,2012-03-1 0:00:00,张为龙,张为龙,通过审核,及时交付，及时付款。,admin,2012-03-2 11:59:46)SET IDENTITY_INSERT ERPBuyOrder OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPCarBaoXian) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPCarBaoXianCREATE TABLE ERPCarBaoXian (ID int IDENTITY (1, 1) NOT NULL,CarName varchar (50) NULL,FeiYongName varchar (50) NULL,ProjectName varchar (50) NULL,BaoXianPrice varchar (50) NULL,BaoXianDate varchar (50) NULL,TiXingDate varchar (50) NULL,UserName varchar (50) NULL,TimeStr datetime NULL DEFAULT (getdate(),BackInfo varchar (5000) NULL)ALTER TABLE ERPCarBaoXian WITH NOCHECK ADD CONSTRAINT PK_ERPCarBaoXian PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPCarBaoXian ONINSERT ERPCarBaoXian (ID,CarName,FeiYongName,ProjectName,BaoXianPrice,BaoXianDate,TiXingDate,UserName,TimeStr,BackInfo) VALUES ( 2,单位商务车,车辆保险,全部项目,8000,2012-3-1,2012-3-1,admin,2012-03-2 10:28:49,很多保险)INSERT ERPCarBaoXian (ID,CarName,FeiYongName,ProjectName,BaoXianPrice,BaoXianDate,TiXingDate,UserName,TimeStr,BackInfo) VALUES ( 3,一般事务车,车辆保险,全部项目,3000,2012-3-1,2012-3-1,admin,2012-03-2 10:29:30,无)SET IDENTITY_INSERT ERPCarBaoXian OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPCarBaoYang) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPCarBaoYangCREATE TABLE ERPCarBaoYang (ID int IDENTITY (1, 1) NOT NULL,CarName varchar (50) NULL,BYDate varchar (50) NULL,JingBanUser varchar (50) NULL,ZhuGuanUser varchar (50) NULL,BYQianLCBNum varchar (50) NULL,QiYouJinE varchar (50) NULL,BYJinE varchar (50) NULL,WeiXiuJinE varchar (50) NULL,OtherJinE varchar (50) NULL,UserName varchar (50) NULL,TimeStr datetime NULL DEFAULT (getdate(),BackInfo varchar (5000) NULL)ALTER TABLE ERPCarBaoYang WITH NOCHECK ADD CONSTRAINT PK_ERPCarBaoYang PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT ERPCarBaoYang ONINSERT ERPCarBaoYang (ID,CarName,BYDate,JingBanUser,ZhuGuanUser,BYQianLCBNum,QiYouJinE,BYJinE,WeiXiuJinE,OtherJinE,UserName,TimeStr,BackInfo) VALUES ( 2,单位商务车,2012-3-1,张国光,张国光,2000,500,200,300,200,admin,2012-03-2 10:31:56,消耗比较大)SET IDENTITY_INSERT ERPCarBaoYang OFFif exists (select * from sysobjects where id = OBJECT_ID(ERPCarInfo) and OBJECTPROPERTY(id, IsUserTable) = 1) DROP TABLE ERPCarInfoCREATE TABLE ERPCarInfo (ID int IDENTITY (1, 1) NOT NULL,CarName varchar (50) NULL,CarPaiHao varchar (50) NULL,CarXingHao varchar (50) NULL,LeiXing varchar (50) NULL,SuoShuDep varchar (8000) NULL,DriverUser varchar (50) NULL,NowState varchar (50) NULL,UserName varchar (50) NULL,TimeStr datetime NULL DEFAULT (getdate(),BackInfo varchar (5000) NULL)ALTER TABLE ERPCarInfo WITH NOCHECK ADD CONSTRAINT PK_ERPCarInfo PRIMARY KEY NONCLUSTERED ( ID )SET IDENTITY_INSERT E