⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 outstate.sql

📁 一套三层结构的文件管理OA系统源码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
ON [PRIMARY]
GO

EXEC sp_addextendedproperty 'MS_Description', N'标记类型', 'user', 'dbo', 'table', 'Pic_db_Folder_Body', 'column', 'PicType'
GO

--
-- Definition for table Pic_db_Folder_Share : 
--

CREATE TABLE [dbo].[Pic_db_Folder_Share] (
  [FileID]int NOT NULL,
  [ClientUserID]varchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [UpLoad]bit CONSTRAINT [DF_Pic_db_Folder_Share_UpLoad] DEFAULT 0 NOT NULL,
  [DownLoad]bit CONSTRAINT [DF_Pic_db_Folder_Share_DownLoad] DEFAULT 0 NOT NULL
)
ON [PRIMARY]
GO

EXEC sp_addextendedproperty 'MS_Description', N'可访问用户，EveryOne-所有人都可访问', 'user', 'dbo', 'table', 'Pic_db_Folder_Share', 'column', 'ClientUserID'
GO

EXEC sp_addextendedproperty 'MS_Description', N'可上传--0：NO；1：YES', 'user', 'dbo', 'table', 'Pic_db_Folder_Share', 'column', 'UpLoad'
GO

EXEC sp_addextendedproperty 'MS_Description', N'可下载--0：NO；1：YES', 'user', 'dbo', 'table', 'Pic_db_Folder_Share', 'column', 'DownLoad'
GO

--
-- Definition for table Pic_db_User : 
--

CREATE TABLE [dbo].[Pic_db_User] (
  [UserID]varchar(20) COLLATE Chinese_PRC_CI_AS NOT NULL,
  [UserName]varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [Psw]varchar(20) COLLATE Chinese_PRC_CI_AS NULL,
  [UserClass]varchar(10) COLLATE Chinese_PRC_CI_AS NULL
)
ON [PRIMARY]
GO

--
-- Data for table Comm_db_Company  (LIMIT 0,500)
--

SET IDENTITY_INSERT [dbo].[Comm_db_Company] ON
GO

INSERT INTO [dbo].[Comm_db_Company] ([CompanyNum], [CompanyCode], [CompanyName])
VALUES 
  (1, 'GME', '长安誉铭')
GO

INSERT INTO [dbo].[Comm_db_Company] ([CompanyNum], [CompanyCode], [CompanyName])
VALUES 
  (2, 'GM', '沙井誉铭')
GO

INSERT INTO [dbo].[Comm_db_Company] ([CompanyNum], [CompanyCode], [CompanyName])
VALUES 
  (3, 'MS', '繁星')
GO

--
-- 3 record(s) inserted to [dbo].[Comm_db_Company]
--



SET IDENTITY_INSERT [dbo].[Comm_db_Company] OFF
GO

--
-- Data for table Comm_db_Dept  (LIMIT 0,500)
--

SET IDENTITY_INSERT [dbo].[Comm_db_Dept] ON
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (1, '行政课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (2, 'IT课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (3, '注塑课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (4, '技术课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (5, '丝喷课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (6, '计划课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (7, '仓务课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (8, '品质课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (9, '财务课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (10, '报关课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (11, '采购课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (12, '营业课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (13, '文控课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (14, '模具课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (15, '制造课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (16, '营业（欧美）')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (17, '总经办')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (18, 'ISO')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (19, '管理课')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (20, '捷塑')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (21, '董事办')
GO

INSERT INTO [dbo].[Comm_db_Dept] ([DeptNum], [DeptName])
VALUES 
  (22, '管理委员会')
GO

--
-- 22 record(s) inserted to [dbo].[Comm_db_Dept]
--



SET IDENTITY_INSERT [dbo].[Comm_db_Dept] OFF
GO

--
-- Data for table Comm_db_Menu  (LIMIT 0,500)
--

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('10', NULL, '我的桌面')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('1010', NULL, '个人设置')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('1011', NULL, '通讯簿')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('1012', NULL, '工作日志')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('1013', NULL, '日程安排')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('1014', NULL, '公告通知')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('1015', NULL, '短信息')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('1016', NULL, '工作提醒')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('20', NULL, '公共事务')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('2010', NULL, '公文流转')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('2021', NULL, '会议管理')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('2022', NULL, '车辆管理')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('2023', NULL, '借阅管理')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('2030', NULL, '规章制度')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('2031', NULL, '组织机构')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('2040', NULL, '夹具管理')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('30', NULL, '人力资源')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('3010', NULL, '培训管理')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('40', NULL, '商业管理')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('50', NULL, '信息交流')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('5010', '', '网络文件')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('501010', 'Pic_MyFile', '我的文件')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('501020', 'Pic_ShareFile', '共享文件')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('5020', NULL, '讨论区')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('5030', NULL, '聊天室')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('60', NULL, '辅助办公')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('6010', NULL, '万年历')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('6011', NULL, '公司电话')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('70', NULL, '控制面板')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('7010', NULL, '修改密码')
GO

INSERT INTO [dbo].[Comm_db_Menu] ([ItemNo], [MenuCode], [MenuName])
VALUES 
  ('7011', NULL, '权限设置')
GO

--
-- 31 record(s) inserted to [dbo].[Comm_db_Menu]
--



--
-- Data for table Comm_db_User  (LIMIT 0,500)
--

INSERT INTO [dbo].[Comm_db_User] ([UserID], [UserName], [Psw], [UserClass], [EMail], [DeptName], [OnLine], [UseState], [AtOut])
VALUES 
  ('Kent', '箭牌', '123', 'A', 'Temp@goodmark.com.cn', NULL, 0, 1, NULL)
GO

INSERT INTO [dbo].[Comm_db_User] ([UserID], [UserName], [Psw], [UserClass], [EMail], [DeptName], [OnLine], [UseState], [AtOut])
VALUES 
  ('System', '系统管理员', '123', 'Z', 'Temp@goodmark.com.cn', NULL, 0, 1, NULL)
GO

INSERT INTO [dbo].[Comm_db_User] ([UserID], [UserName], [Psw], [UserClass], [EMail], [DeptName], [OnLine], [UseState], [AtOut])
VALUES 
  ('XZ1', '行政文员1', '123', 'A', NULL, NULL, 0, 1, NULL)
GO

INSERT INTO [dbo].[Comm_db_User] ([UserID], [UserName], [Psw], [UserClass], [EMail], [DeptName], [OnLine], [UseState], [AtOut])
VALUES 
  ('XZ2', '行政文员2', '123', 'A', NULL, NULL, 0, 1, NULL)
GO

INSERT INTO [dbo].[Comm_db_User] ([UserID], [UserName], [Psw], [UserClass], [EMail], [DeptName], [OnLine], [UseState], [AtOut])
VALUES 
  ('XZGL1', '行政管理1', '123', 'A', NULL, NULL, 0, 1, NULL)
GO

INSERT INTO [dbo].[Comm_db_User] ([UserID], [UserName], [Psw], [UserClass], [EMail], [DeptName], [OnLine], [UseState], [AtOut])
VALUES 
  ('XZGL2', '行政管理2', '123', 'A', NULL, NULL, 0, 1, NULL)
GO

--
-- 6 record(s) inserted to [dbo].[Comm_db_User]
--



--
-- Data for table Comm_db_UserGrant_Menu  (LIMIT 0,500)
--

INSERT INTO [dbo].[Comm_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('system', 'Pic_MyFile')
GO

INSERT INTO [dbo].[Comm_db_UserGrant_Menu] ([UserID], [MenuCode])
VALUES 
  ('system', 'Pic_ShareFile')
GO

--
-- 2 record(s) inserted to [dbo].[Comm_db_UserGrant_Menu]
--



--
-- Data for table File_db_Condition_Body  (LIMIT 0,500)
--

INSERT INTO [dbo].[File_db_Condition_Body] ([ISO_Docnum], [Item], [StateOK], [StateNO], [OkGoTo], [NoGoTo], [State1], [State2], [State3], [OkMan], [Remark])
VALUES 
  ('ISO-001', 1, '登记', '取消', 2, 99, '待审', '取消', '', 1, NULL)
GO

INSERT INTO [dbo].[File_db_Condition_Body] ([ISO_Docnum], [Item], [StateOK], [StateNO], [OkGoTo], [NoGoTo], [State1], [State2], [State3], [OkMan], [Remark])
VALUES 
  ('ISO-001', 2, '批准', '不批准', 3, 99, '批准', '不批准', NULL, 1, NULL)
GO

INSERT INTO [dbo].[File_db_Condition_Body] ([ISO_Docnum], [Item], [StateOK], [StateNO], [OkGoTo], [NoGoTo], [State1], [State2], [State3], [OkMan], [Remark])
VALUES 
  ('ISO-001', 3, '接受', '不接受', 99, 99, '接受', '不接受', NULL, 1, NULL)
GO

INSERT INTO [dbo].[File_db_Condition_Body] ([ISO_Docnum], [Item], [StateOK], [StateNO], [OkGoTo], [NoGoTo], [State1], [State2], [State3], [OkMan], [Remark])
VALUES 
  ('ISO-001', 99, '完成', '未完', 0, 0, '完成', '未完', NULL, 1, NULL)
GO
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -