-
Notifications
You must be signed in to change notification settings - Fork 8
/
Copy pathGMSOA.sql
80 lines (80 loc) · 11.9 KB
/
GMSOA.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
USE [GMSOA]
GO
/****** Object: Table [dbo].[Staff] Script Date: 01/02/2014 08:20:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Staff](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](100) NOT NULL,
[CoverPicture] [nvarchar](300) NULL,
[Gender] [int] NOT NULL,
[Position] [int] NOT NULL,
[BirthDate] [datetime] NULL,
[Tel] [nvarchar](100) NOT NULL,
[Email] [nvarchar](100) NULL,
[Address] [nvarchar](200) NULL,
[BranchId] [int] NOT NULL,
[CreateTime] [datetime] NOT NULL,
CONSTRAINT [PK_Staff] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Staff] ON
INSERT [dbo].[Staff] ([ID], [Name], [CoverPicture], [Gender], [Position], [BirthDate], [Tel], [Email], [Address], [BranchId], [CreateTime]) VALUES (1, N'程一冰', NULL, 2, 0, CAST(0x000074E000000000 AS DateTime), N'13876540999', NULL, NULL, 5, CAST(0x0000A29C00DA08B8 AS DateTime))
INSERT [dbo].[Staff] ([ID], [Name], [CoverPicture], [Gender], [Position], [BirthDate], [Tel], [Email], [Address], [BranchId], [CreateTime]) VALUES (3, N'欧景致', NULL, 1, 0, CAST(0x0000709800000000 AS DateTime), N'13876544531', NULL, NULL, 4, CAST(0x0000A29C00DB1D7B AS DateTime))
INSERT [dbo].[Staff] ([ID], [Name], [CoverPicture], [Gender], [Position], [BirthDate], [Tel], [Email], [Address], [BranchId], [CreateTime]) VALUES (4, N'李敏', NULL, 1, 0, CAST(0x000077BA00000000 AS DateTime), N'13811329822', NULL, NULL, 0, CAST(0x0000A29C00DB1D7B AS DateTime))
INSERT [dbo].[Staff] ([ID], [Name], [CoverPicture], [Gender], [Position], [BirthDate], [Tel], [Email], [Address], [BranchId], [CreateTime]) VALUES (5, N'宋慈', NULL, 1, 0, CAST(0x000074E000000000 AS DateTime), N'17627138777', NULL, NULL, 0, CAST(0x0000A29C00DB1D7B AS DateTime))
INSERT [dbo].[Staff] ([ID], [Name], [CoverPicture], [Gender], [Position], [BirthDate], [Tel], [Email], [Address], [BranchId], [CreateTime]) VALUES (6, N'郑然', NULL, 2, 0, CAST(0x000074E000000000 AS DateTime), N'18978634571', NULL, NULL, 7, CAST(0x0000A29C00DB1D7B AS DateTime))
INSERT [dbo].[Staff] ([ID], [Name], [CoverPicture], [Gender], [Position], [BirthDate], [Tel], [Email], [Address], [BranchId], [CreateTime]) VALUES (7, N'张京微', NULL, 1, 0, CAST(0x00007A9500000000 AS DateTime), N'13456788765', NULL, NULL, 0, CAST(0x0000A29C00DB1D7B AS DateTime))
INSERT [dbo].[Staff] ([ID], [Name], [CoverPicture], [Gender], [Position], [BirthDate], [Tel], [Email], [Address], [BranchId], [CreateTime]) VALUES (8, N'黎西', NULL, 2, 0, CAST(0x0000792800000000 AS DateTime), N'13487673000', NULL, NULL, 0, CAST(0x0000A29C00DB1D7B AS DateTime))
INSERT [dbo].[Staff] ([ID], [Name], [CoverPicture], [Gender], [Position], [BirthDate], [Tel], [Email], [Address], [BranchId], [CreateTime]) VALUES (9, N'李进', NULL, 1, 0, CAST(0x0000737300000000 AS DateTime), N'14534567890', NULL, NULL, 1, CAST(0x0000A29C00DB1D7B AS DateTime))
INSERT [dbo].[Staff] ([ID], [Name], [CoverPicture], [Gender], [Position], [BirthDate], [Tel], [Email], [Address], [BranchId], [CreateTime]) VALUES (10, N'张一易', NULL, 1, 2, CAST(0x000077BA00000000 AS DateTime), N'13987654356', NULL, NULL, 3, CAST(0x0000A29C00DB1D7B AS DateTime))
SET IDENTITY_INSERT [dbo].[Staff] OFF
/****** Object: Table [dbo].[Branch] Script Date: 01/02/2014 08:20:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Branch](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](100) NOT NULL,
[Desc] [nvarchar](300) NULL,
[ParentId] [int] NOT NULL,
[CreateTime] [datetime] NOT NULL,
CONSTRAINT [PK_Branch] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Branch] ON
INSERT [dbo].[Branch] ([ID], [Name], [Desc], [ParentId], [CreateTime]) VALUES (1, N'总经办', NULL, 0, CAST(0x0000A29A017DB622 AS DateTime))
INSERT [dbo].[Branch] ([ID], [Name], [Desc], [ParentId], [CreateTime]) VALUES (2, N'测试部', NULL, 6, CAST(0x0000A29A017E06C6 AS DateTime))
INSERT [dbo].[Branch] ([ID], [Name], [Desc], [ParentId], [CreateTime]) VALUES (3, N'研发部', NULL, 6, CAST(0x0000A29B017CF018 AS DateTime))
INSERT [dbo].[Branch] ([ID], [Name], [Desc], [ParentId], [CreateTime]) VALUES (4, N'前端组', NULL, 3, CAST(0x0000A29B017D22FE AS DateTime))
INSERT [dbo].[Branch] ([ID], [Name], [Desc], [ParentId], [CreateTime]) VALUES (5, N'后端组', NULL, 3, CAST(0x0000A29B017DD85E AS DateTime))
INSERT [dbo].[Branch] ([ID], [Name], [Desc], [ParentId], [CreateTime]) VALUES (6, N'开发中心', NULL, 1, CAST(0x0000A29B017DFAA9 AS DateTime))
INSERT [dbo].[Branch] ([ID], [Name], [Desc], [ParentId], [CreateTime]) VALUES (7, N'人力资源部', NULL, 1, CAST(0x0000A29B017E143F AS DateTime))
SET IDENTITY_INSERT [dbo].[Branch] OFF
/****** Object: Default [DF_Staff_Hits] Script Date: 01/02/2014 08:20:43 ******/
ALTER TABLE [dbo].[Staff] ADD CONSTRAINT [DF_Staff_Hits] DEFAULT ((0)) FOR [Gender]
GO
/****** Object: Default [DF_Staff_IsActive] Script Date: 01/02/2014 08:20:43 ******/
ALTER TABLE [dbo].[Staff] ADD CONSTRAINT [DF_Staff_IsActive] DEFAULT ((0)) FOR [Position]
GO
/****** Object: Default [DF_Staff_Diggs] Script Date: 01/02/2014 08:20:43 ******/
ALTER TABLE [dbo].[Staff] ADD CONSTRAINT [DF_Staff_Diggs] DEFAULT ((0)) FOR [Tel]
GO
/****** Object: Default [DF_Staff_CreateDate] Script Date: 01/02/2014 08:20:43 ******/
ALTER TABLE [dbo].[Staff] ADD CONSTRAINT [DF_Staff_CreateDate] DEFAULT (getdate()) FOR [CreateTime]
GO
/****** Object: Default [DF_Branch_ParentId] Script Date: 01/02/2014 08:20:43 ******/
ALTER TABLE [dbo].[Branch] ADD CONSTRAINT [DF_Branch_ParentId] DEFAULT ((0)) FOR [ParentId]
GO
/****** Object: Default [DF_Branch_CreateDate] Script Date: 01/02/2014 08:20:43 ******/
ALTER TABLE [dbo].[Branch] ADD CONSTRAINT [DF_Branch_CreateDate] DEFAULT (getdate()) FOR [CreateTime]
GO