1 | USE [master]
|
---|
2 | GO
|
---|
3 | /****** Object: Database [TALENTRACKDATA.MDF] Script Date: 05.09.2015 02:39:46 ******/
|
---|
4 | CREATE DATABASE [TALENTRACKDATA.MDF]
|
---|
5 | GO
|
---|
6 | ALTER DATABASE [TALENTRACKDATA.MDF] SET COMPATIBILITY_LEVEL = 110
|
---|
7 | GO
|
---|
8 | IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
|
---|
9 | begin
|
---|
10 | EXEC [TALENTRACKDATA.MDF].[dbo].[sp_fulltext_database] @action = 'enable'
|
---|
11 | end
|
---|
12 | GO
|
---|
13 | ALTER DATABASE [TALENTRACKDATA.MDF] SET ANSI_NULL_DEFAULT OFF
|
---|
14 | GO
|
---|
15 | ALTER DATABASE [TALENTRACKDATA.MDF] SET ANSI_NULLS OFF
|
---|
16 | GO
|
---|
17 | ALTER DATABASE [TALENTRACKDATA.MDF] SET ANSI_PADDING OFF
|
---|
18 | GO
|
---|
19 | ALTER DATABASE [TALENTRACKDATA.MDF] SET ANSI_WARNINGS OFF
|
---|
20 | GO
|
---|
21 | ALTER DATABASE [TALENTRACKDATA.MDF] SET ARITHABORT OFF
|
---|
22 | GO
|
---|
23 | ALTER DATABASE [TALENTRACKDATA.MDF] SET AUTO_CLOSE ON
|
---|
24 | GO
|
---|
25 | ALTER DATABASE [TALENTRACKDATA.MDF] SET AUTO_SHRINK ON
|
---|
26 | GO
|
---|
27 | ALTER DATABASE [TALENTRACKDATA.MDF] SET AUTO_UPDATE_STATISTICS ON
|
---|
28 | GO
|
---|
29 | ALTER DATABASE [TALENTRACKDATA.MDF] SET CURSOR_CLOSE_ON_COMMIT OFF
|
---|
30 | GO
|
---|
31 | ALTER DATABASE [TALENTRACKDATA.MDF] SET CURSOR_DEFAULT GLOBAL
|
---|
32 | GO
|
---|
33 | ALTER DATABASE [TALENTRACKDATA.MDF] SET CONCAT_NULL_YIELDS_NULL OFF
|
---|
34 | GO
|
---|
35 | ALTER DATABASE [TALENTRACKDATA.MDF] SET NUMERIC_ROUNDABORT OFF
|
---|
36 | GO
|
---|
37 | ALTER DATABASE [TALENTRACKDATA.MDF] SET QUOTED_IDENTIFIER OFF
|
---|
38 | GO
|
---|
39 | ALTER DATABASE [TALENTRACKDATA.MDF] SET RECURSIVE_TRIGGERS OFF
|
---|
40 | GO
|
---|
41 | ALTER DATABASE [TALENTRACKDATA.MDF] SET DISABLE_BROKER
|
---|
42 | GO
|
---|
43 | ALTER DATABASE [TALENTRACKDATA.MDF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
|
---|
44 | GO
|
---|
45 | ALTER DATABASE [TALENTRACKDATA.MDF] SET DATE_CORRELATION_OPTIMIZATION OFF
|
---|
46 | GO
|
---|
47 | ALTER DATABASE [TALENTRACKDATA.MDF] SET TRUSTWORTHY OFF
|
---|
48 | GO
|
---|
49 | ALTER DATABASE [TALENTRACKDATA.MDF] SET ALLOW_SNAPSHOT_ISOLATION OFF
|
---|
50 | GO
|
---|
51 | ALTER DATABASE [TALENTRACKDATA.MDF] SET PARAMETERIZATION SIMPLE
|
---|
52 | GO
|
---|
53 | ALTER DATABASE [TALENTRACKDATA.MDF] SET READ_COMMITTED_SNAPSHOT OFF
|
---|
54 | GO
|
---|
55 | ALTER DATABASE [TALENTRACKDATA.MDF] SET HONOR_BROKER_PRIORITY OFF
|
---|
56 | GO
|
---|
57 | ALTER DATABASE [TALENTRACKDATA.MDF] SET RECOVERY SIMPLE
|
---|
58 | GO
|
---|
59 | ALTER DATABASE [TALENTRACKDATA.MDF] SET MULTI_USER
|
---|
60 | GO
|
---|
61 | ALTER DATABASE [TALENTRACKDATA.MDF] SET PAGE_VERIFY CHECKSUM
|
---|
62 | GO
|
---|
63 | ALTER DATABASE [TALENTRACKDATA.MDF] SET DB_CHAINING OFF
|
---|
64 | GO
|
---|
65 | ALTER DATABASE [TALENTRACKDATA.MDF] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
|
---|
66 | GO
|
---|
67 | ALTER DATABASE [TALENTRACKDATA.MDF] SET TARGET_RECOVERY_TIME = 0 SECONDS
|
---|
68 | GO
|
---|
69 | USE [TALENTRACKDATA.MDF]
|
---|
70 | GO
|
---|
71 | /****** Object: Table [dbo].[Applicant] Script Date: 05.09.2015 02:39:46 ******/
|
---|
72 | SET ANSI_NULLS ON
|
---|
73 | GO
|
---|
74 | SET QUOTED_IDENTIFIER ON
|
---|
75 | GO
|
---|
76 | CREATE TABLE [dbo].[Applicant](
|
---|
77 | [IdApplicant] [nchar](13) NOT NULL,
|
---|
78 | [NameApplicant] [nchar](10) NOT NULL,
|
---|
79 | [SurnameApplicant] [nchar](10) NOT NULL,
|
---|
80 | PRIMARY KEY CLUSTERED
|
---|
81 | (
|
---|
82 | [IdApplicant] ASC
|
---|
83 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
84 | ) ON [PRIMARY]
|
---|
85 |
|
---|
86 | GO
|
---|
87 | /****** Object: Table [dbo].[Employee] Script Date: 05.09.2015 02:39:46 ******/
|
---|
88 | SET ANSI_NULLS ON
|
---|
89 | GO
|
---|
90 | SET QUOTED_IDENTIFIER ON
|
---|
91 | GO
|
---|
92 | CREATE TABLE [dbo].[Employee](
|
---|
93 | [IdEmployee] [nchar](13) NOT NULL,
|
---|
94 | [NameEmployee] [nchar](10) NOT NULL,
|
---|
95 | [SurnameEmployee] [nchar](10) NOT NULL,
|
---|
96 | [Contact] [nvarchar](50) NOT NULL,
|
---|
97 | [NameTitle] [nchar](100) NOT NULL,
|
---|
98 | [Status] [nchar](10) NULL,
|
---|
99 | PRIMARY KEY CLUSTERED
|
---|
100 | (
|
---|
101 | [IdEmployee] ASC
|
---|
102 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
103 | ) ON [PRIMARY]
|
---|
104 |
|
---|
105 | GO
|
---|
106 | /****** Object: Table [dbo].[EmployeeSkills] Script Date: 05.09.2015 02:39:46 ******/
|
---|
107 | SET ANSI_NULLS ON
|
---|
108 | GO
|
---|
109 | SET QUOTED_IDENTIFIER ON
|
---|
110 | GO
|
---|
111 | CREATE TABLE [dbo].[EmployeeSkills](
|
---|
112 | [IdEmployee] [nchar](13) NOT NULL,
|
---|
113 | [NameSkill] [nchar](50) NOT NULL,
|
---|
114 | [Rating] [decimal](18, 2) NOT NULL,
|
---|
115 | CONSTRAINT [PK_EmployeeSkills] PRIMARY KEY CLUSTERED
|
---|
116 | (
|
---|
117 | [IdEmployee] ASC,
|
---|
118 | [NameSkill] ASC
|
---|
119 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
120 | ) ON [PRIMARY]
|
---|
121 |
|
---|
122 | GO
|
---|
123 | /****** Object: Table [dbo].[Jobs] Script Date: 05.09.2015 02:39:46 ******/
|
---|
124 | SET ANSI_NULLS ON
|
---|
125 | GO
|
---|
126 | SET QUOTED_IDENTIFIER ON
|
---|
127 | GO
|
---|
128 | CREATE TABLE [dbo].[Jobs](
|
---|
129 | [IdJob] [int] IDENTITY(1,1) NOT NULL,
|
---|
130 | [Information] [nvarchar](max) NOT NULL,
|
---|
131 | [NameJob] [nchar](100) NOT NULL,
|
---|
132 | [Date] [datetime] NOT NULL,
|
---|
133 | PRIMARY KEY CLUSTERED
|
---|
134 | (
|
---|
135 | [IdJob] ASC
|
---|
136 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
137 | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
---|
138 |
|
---|
139 | GO
|
---|
140 | /****** Object: Table [dbo].[JobsApplicants] Script Date: 05.09.2015 02:39:46 ******/
|
---|
141 | SET ANSI_NULLS ON
|
---|
142 | GO
|
---|
143 | SET QUOTED_IDENTIFIER ON
|
---|
144 | GO
|
---|
145 | CREATE TABLE [dbo].[JobsApplicants](
|
---|
146 | [IdJob] [int] NOT NULL,
|
---|
147 | [IdApplicant] [nchar](13) NOT NULL,
|
---|
148 | CONSTRAINT [PK_JobsApplicants] PRIMARY KEY CLUSTERED
|
---|
149 | (
|
---|
150 | [IdJob] ASC,
|
---|
151 | [IdApplicant] ASC
|
---|
152 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
153 | ) ON [PRIMARY]
|
---|
154 |
|
---|
155 | GO
|
---|
156 | /****** Object: Table [dbo].[Skills] Script Date: 05.09.2015 02:39:46 ******/
|
---|
157 | SET ANSI_NULLS ON
|
---|
158 | GO
|
---|
159 | SET QUOTED_IDENTIFIER ON
|
---|
160 | GO
|
---|
161 | CREATE TABLE [dbo].[Skills](
|
---|
162 | [NameSkill] [nchar](50) NOT NULL,
|
---|
163 | PRIMARY KEY CLUSTERED
|
---|
164 | (
|
---|
165 | [NameSkill] ASC
|
---|
166 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
167 | ) ON [PRIMARY]
|
---|
168 |
|
---|
169 | GO
|
---|
170 | /****** Object: Table [dbo].[Title] Script Date: 05.09.2015 02:39:46 ******/
|
---|
171 | SET ANSI_NULLS ON
|
---|
172 | GO
|
---|
173 | SET QUOTED_IDENTIFIER ON
|
---|
174 | GO
|
---|
175 | CREATE TABLE [dbo].[Title](
|
---|
176 | [NameTitle] [nchar](100) NOT NULL,
|
---|
177 | [Salary] [int] NOT NULL,
|
---|
178 | [hasAccount] [int] NOT NULL,
|
---|
179 | PRIMARY KEY CLUSTERED
|
---|
180 | (
|
---|
181 | [NameTitle] ASC
|
---|
182 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
183 | ) ON [PRIMARY]
|
---|
184 |
|
---|
185 | GO
|
---|
186 | /****** Object: Table [dbo].[User] Script Date: 05.09.2015 02:39:46 ******/
|
---|
187 | SET ANSI_NULLS ON
|
---|
188 | GO
|
---|
189 | SET QUOTED_IDENTIFIER ON
|
---|
190 | GO
|
---|
191 | CREATE TABLE [dbo].[User](
|
---|
192 | [IdUser] [int] IDENTITY(1,1) NOT NULL,
|
---|
193 | [UserName] [nchar](50) NULL,
|
---|
194 | [Password] [nchar](50) NULL,
|
---|
195 | [Role] [nchar](10) NOT NULL,
|
---|
196 | [idEmployee] [nchar](13) NOT NULL,
|
---|
197 | [AccountFlag] [int] NULL,
|
---|
198 | PRIMARY KEY CLUSTERED
|
---|
199 | (
|
---|
200 | [IdUser] ASC
|
---|
201 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
---|
202 | ) ON [PRIMARY]
|
---|
203 |
|
---|
204 | GO
|
---|
205 | ALTER TABLE [dbo].[Employee] WITH CHECK ADD CONSTRAINT [FK_Employee_Title] FOREIGN KEY([NameTitle])
|
---|
206 | REFERENCES [dbo].[Title] ([NameTitle])
|
---|
207 | GO
|
---|
208 | ALTER TABLE [dbo].[Employee] CHECK CONSTRAINT [FK_Employee_Title]
|
---|
209 | GO
|
---|
210 | ALTER TABLE [dbo].[EmployeeSkills] WITH CHECK ADD CONSTRAINT [FK_EmployeeSkills_Employee] FOREIGN KEY([IdEmployee])
|
---|
211 | REFERENCES [dbo].[Employee] ([IdEmployee])
|
---|
212 | GO
|
---|
213 | ALTER TABLE [dbo].[EmployeeSkills] CHECK CONSTRAINT [FK_EmployeeSkills_Employee]
|
---|
214 | GO
|
---|
215 | ALTER TABLE [dbo].[EmployeeSkills] WITH CHECK ADD CONSTRAINT [FK_EmployeeSkills_Skills] FOREIGN KEY([NameSkill])
|
---|
216 | REFERENCES [dbo].[Skills] ([NameSkill])
|
---|
217 | GO
|
---|
218 | ALTER TABLE [dbo].[EmployeeSkills] CHECK CONSTRAINT [FK_EmployeeSkills_Skills]
|
---|
219 | GO
|
---|
220 | ALTER TABLE [dbo].[JobsApplicants] WITH NOCHECK ADD CONSTRAINT [FK_JobsApplicants_Applicant] FOREIGN KEY([IdApplicant])
|
---|
221 | REFERENCES [dbo].[Applicant] ([IdApplicant])
|
---|
222 | GO
|
---|
223 | ALTER TABLE [dbo].[JobsApplicants] CHECK CONSTRAINT [FK_JobsApplicants_Applicant]
|
---|
224 | GO
|
---|
225 | ALTER TABLE [dbo].[JobsApplicants] WITH NOCHECK ADD CONSTRAINT [FK_JobsApplicants_Jobs] FOREIGN KEY([IdJob])
|
---|
226 | REFERENCES [dbo].[Jobs] ([IdJob])
|
---|
227 | GO
|
---|
228 | ALTER TABLE [dbo].[JobsApplicants] CHECK CONSTRAINT [FK_JobsApplicants_Jobs]
|
---|
229 | GO
|
---|
230 | ALTER TABLE [dbo].[User] WITH CHECK ADD CONSTRAINT [FK_User_Employee] FOREIGN KEY([idEmployee])
|
---|
231 | REFERENCES [dbo].[Employee] ([IdEmployee])
|
---|
232 | GO
|
---|
233 | ALTER TABLE [dbo].[User] CHECK CONSTRAINT [FK_User_Employee]
|
---|
234 | GO
|
---|
235 | USE [master]
|
---|
236 | GO
|
---|
237 | ALTER DATABASE [TALENTRACKDATA.MDF] SET READ_WRITE
|
---|
238 | GO
|
---|