· 6 years ago · Dec 17, 2019, 01:48 AM
1--
2--
3-- SQL Server tables used to run the Editor examples.
4--
5-- For more information about how the client and server-sides interact, please
6-- refer to the Editor documentation: http://editor.datatables.net/manual .
7--
8-- Please note that SQL Server 2008 or newer is required for this script. Also,
9-- if you plan to use server-side processing with DataTables, SQL Server 2012 or
10-- newer is required.
11--
12--
13
14--
15-- To do list examples
16--
17IF OBJECT_ID('todo', 'U') IS NOT NULL
18 DROP TABLE todo;
19
20CREATE TABLE todo (
21 id int not null identity,
22 item nvarchar(255) NOT NULL default '',
23 done bit NOT NULL default '0',
24 priority integer NOT NULL default 1,
25 PRIMARY KEY (id)
26);
27
28INSERT INTO todo (item, done, priority)
29 VALUES
30 ( 'Send business plan to clients', 1, 1 ),
31 ( 'Web-site copy revisions', 0, 2 ),
32 ( 'Review client tracking', 0, 2 ),
33 ( 'E-mail catchup', 0, 3 ),
34 ( 'Complete worksheet', 0, 4 ),
35 ( 'Prep sales presentation', 0, 5 );
36
37
38
39--
40-- Users table examples
41--
42IF OBJECT_ID('user_dept', 'U') IS NOT NULL
43 DROP TABLE user_dept;
44IF OBJECT_ID('user_permission', 'U') IS NOT NULL
45 DROP TABLE user_permission;
46IF OBJECT_ID('user_access', 'U') IS NOT NULL
47 DROP TABLE user_access; -- legacy
48IF OBJECT_ID('users_files', 'U') IS NOT NULL
49 DROP TABLE users_files;
50IF OBJECT_ID('users_visits', 'U') IS NOT NULL
51 DROP TABLE users_visits;
52
53IF OBJECT_ID('dept', 'U') IS NOT NULL
54 DROP TABLE dept;
55IF OBJECT_ID('permission', 'U') IS NOT NULL
56 DROP TABLE permission;
57IF OBJECT_ID('sites', 'U') IS NOT NULL
58 DROP TABLE sites;
59IF OBJECT_ID('users', 'U') IS NOT NULL
60 DROP TABLE users;
61IF OBJECT_ID('files', 'U') IS NOT NULL
62 DROP TABLE files;
63
64CREATE TABLE users (
65 id int not null identity,
66 title nvarchar(255) default NULL,
67 first_name nvarchar(255) default NULL,
68 last_name nvarchar(255) default NULL,
69 phone nvarchar(100) default NULL,
70 city nvarchar(50) default NULL,
71 zip nvarchar(10) default NULL,
72 updated_date datetime DEFAULT GETDATE(),
73 registered_date datetime,
74 removed_date datetime,
75 active bit default NULL,
76 comments nvarchar(255) default NULL,
77 manager int default NULL,
78 site int default NULL,
79 image int default NULL,
80 shift_start time default NULL,
81 shift_end time default NULL,
82 PRIMARY KEY (id)
83);
84
85GO
86
87DROP TRIGGER IF EXISTS update_users_timestamp;
88GO
89CREATE TRIGGER update_users_timestamp ON users
90FOR UPDATE
91AS
92BEGIN
93 SET NOCOUNT ON;
94
95 IF NOT UPDATE (updated_date)
96 BEGIN
97 UPDATE al
98 SET updated_date = GETDATE()
99 FROM users AS al
100 INNER JOIN inserted AS i
101 ON al.id = i.id;
102 END
103END
104
105GO
106
107
108CREATE TABLE dept (
109 id int not null identity,
110 name nvarchar(250) default NULL,
111 PRIMARY KEY (id)
112);
113
114CREATE TABLE permission (
115 id int not null identity,
116 name nvarchar(250) default NULL,
117 PRIMARY KEY (id)
118);
119
120CREATE TABLE sites (
121 id int not null identity,
122 name nvarchar(250) default NULL,
123 PRIMARY KEY (id)
124);
125
126CREATE TABLE files (
127 id int not null identity,
128 filename nvarchar(250) default NULL,
129 filesize int default 0,
130 web_path nvarchar(250) default NULL,
131 system_path nvarchar(250) default NULL,
132 PRIMARY KEY (id)
133);
134
135
136-- Expect only one dept per user
137CREATE TABLE user_dept (
138 user_id int,
139 dept_id int,
140 PRIMARY KEY (user_id, dept_id),
141 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
142 FOREIGN KEY (dept_id) REFERENCES dept(id) ON DELETE CASCADE
143);
144
145-- Expect multiple permission per user
146CREATE TABLE user_permission (
147 user_id int,
148 permission_id int,
149 PRIMARY KEY (user_id, permission_id),
150 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
151 FOREIGN KEY (permission_id) REFERENCES permission(id) ON DELETE CASCADE
152);
153
154CREATE TABLE users_files (
155 user_id int NOT NULL,
156 file_id int NOT NULL,
157 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
158 FOREIGN KEY (file_id) REFERENCES files(id) ON DELETE CASCADE
159);
160GO
161
162
163CREATE OR ALTER VIEW staff_newyork as
164 select id, first_name, last_name, phone, city
165 from users
166 where site in (select id from sites where name = 'New York');
167GO
168
169INSERT INTO users (title, first_name, last_name, phone, city, zip, registered_date, active, manager, site, shift_start, shift_end)
170 VALUES
171 ('Miss','Quynn', 'Contreras', '1-971-977-4681', 'Slidell', '81080', '2012-04-06T18:53:00', '0', 1, 1, '08:00:00', '16:00:00'),
172 ('Mr', 'Kaitlin', 'Smith', '1-436-523-6103', 'Orlando', 'U5G 7J3', '2012-11-20T05:58:25', '1', 1, 2, '09:00:00', '17:00:00'),
173 ('Mrs', 'Cruz', 'Reynolds', '1-776-102-6352', 'Lynn', 'EJ89 9DQ', '2011-12-31T23:34:03', '0', 2, 3, '09:00:00', '17:00:00'),
174 ('Dr', 'Sophia', 'Morris', '1-463-224-1405', 'Belleville', 'T1F 2X1', '2012-08-04T02:55:53', '0', 3, 4, '08:00:00', '15:30:00'),
175 ('Miss','Kamal', 'Roberson', '1-134-408-5227', 'Rehoboth Beach', 'V7I 6T5', '2012-12-23T00:17:03', '1', 1, 5, '09:00:00', '17:00:00'),
176 ('Dr', 'Dustin', 'Rosa', '1-875-919-3188', 'Jersey City', 'E4 8ZE', '2012-10-05T22:18:59', '0', 1, 6, '09:00:00', '17:00:00'),
177 ('Dr', 'Xantha', 'George', '1-106-884-4754', 'Billings', 'Y2I 6J7', '2012-11-25T12:50:16', '0', 6, 1, '07:00:00', '15:00:00'),
178 ('Mrs', 'Bryar', 'Long', '1-918-114-8083', 'San Bernardino', '82983', '2012-05-14T23:32:25', '0', 1, 2, '09:00:00', '17:00:00'),
179 ('Mrs', 'Kuame', 'Wynn', '1-101-692-4039', 'Truth or Consequences', '21290', '2011-06-21T16:27:07', '1', 2, 3, '06:00:00', '14:00:00'),
180 ('Ms', 'Indigo', 'Brennan', '1-756-756-8161', 'Moline', 'NO8 3UY', '2011-02-19T12:51:08', '1', 5, 4, '12:00:00', '00:00:00'),
181 ('Mrs', 'Avram', 'Allison', '1-751-507-2640', 'Rancho Palos Verdes', 'I7Q 8H4', '2012-12-30T17:02:10', '0', 1, 5, '09:00:00', '17:00:00'),
182 ('Mr', 'Martha', 'Burgess', '1-971-722-1203', 'Toledo', 'Q5R 9HI', '2011-02-04T17:25:55', '1', 1, 6, '12:00:00', '00:00:00'),
183 ('Miss','Lael', 'Kim', '1-626-697-2194', 'Lake Charles', '34209', '2012-07-24T06:44:22', '1', 7, 1, '09:00:00', '17:00:00'),
184 ('Dr', 'Lyle', 'Lewis', '1-231-793-3520', 'Simi Valley', 'H9B 2H4', '2012-08-30T03:28:54', '0', 1, 2, '00:00:00', '12:00:00'),
185 ('Miss','Veronica', 'Marks', '1-750-981-6759', 'Glens Falls', 'E3C 5D1', '2012-08-14T12:09:24', '1', 2, 3, '09:00:00', '17:00:00'),
186 ('Mrs', 'Wynne', 'Ruiz', '1-983-744-5362', 'Branson', 'L9E 6E2', '2012-11-06T01:04:07', '0', 1, 4, '12:00:00', '00:00:00'),
187 ('Ms', 'Jessica', 'Bryan', '1-949-932-6772', 'Boulder City', 'F5P 6NU', '2013-02-01T20:22:33', '0', 5, 5, '09:00:00', '17:00:00'),
188 ('Ms', 'Quinlan', 'Hyde', '1-625-664-6072', 'Sheridan', 'Y8A 1LQ', '2011-10-25T16:53:45', '1', 1, 6, '08:00:00', '15:00:00'),
189 ('Miss','Mona', 'Terry', '1-443-179-7343', 'Juneau', 'G62 1OF', '2012-01-15T09:26:59', '0', 1, 1, '08:30:00', '16:30:00'),
190 ('Mrs', 'Medge', 'Patterson', '1-636-979-0497', 'Texarkana', 'I5U 6E0', '2012-10-20T16:26:18', '1', 1, 2, '09:00:00', '17:00:00'),
191 ('Mrs', 'Perry', 'Gamble', '1-440-976-9560', 'Arcadia', '98923', '2012-06-06T02:03:49', '1', 2, 3, '00:00:00', '12:00:00'),
192 ('Mrs', 'Pandora', 'Armstrong', '1-197-431-4390', 'Glendora', '34124', '2011-08-29T01:45:06', '0', 7, 4, '21:00:00', '03:00:00'),
193 ('Mr', 'Pandora', 'Briggs', '1-278-288-9221', 'Oneida', 'T9M 4H9', '2012-07-16T08:44:41', '1', 4, 5, '09:00:00', '17:00:00'),
194 ('Mrs', 'Maris', 'Leblanc', '1-936-114-2921', 'Cohoes', 'V1H 6Z7', '2011-05-04T13:07:04', '1', 1, 6, '00:00:00', '12:00:00'),
195 ('Mrs', 'Ishmael', 'Crosby', '1-307-243-2684', 'Midwest City', 'T6 8PS', '2011-07-02T23:11:11', '0', 3, 1, '09:00:00', '17:00:00'),
196 ('Miss','Quintessa', 'Pickett', '1-801-122-7471', 'North Tonawanda', '09166', '2013-02-05T10:33:22', '1', 1, 2, '12:00:00', '00:00:00'),
197 ('Miss','Ifeoma', 'Mays', '1-103-883-0962', 'Parkersburg', '87377', '2011-08-22T12:19:09', '0', 1, 3, '09:00:00', '17:00:00'),
198 ('Mrs', 'Basia', 'Harrell', '1-528-238-4178', 'Cody', 'LJ54 1IU', '2012-05-07T14:42:55', '1', 1, 4, '09:00:00', '17:00:00'),
199 ('Mrs', 'Hamilton', 'Blackburn', '1-676-857-1423', 'Delta Junction', 'X5 9HE', '2011-05-19T07:39:48', '0', 6, 5, '10:00:00', '18:00:00'),
200 ('Ms', 'Dexter', 'Burton', '1-275-332-8186', 'Gainesville', '65914', '2013-02-01T16:21:20', '1', 5, 6, '21:00:00', '03:00:00'),
201 ('Mrs', 'Quinn', 'Mccall', '1-808-916-4497', 'Fallon', 'X4 8UB', '2012-03-24T19:31:51', '0', 1, 1, '09:00:00', '17:00:00'),
202 ('Mr', 'Alexa', 'Wilder', '1-727-307-1997', 'Johnson City', '16765', '2011-10-14T08:21:14', '0', 3, 2, '09:00:00', '17:00:00'),
203 ('Ms', 'Rhonda', 'Harrell', '1-934-906-6474', 'Minnetonka', 'I2R 1H2', '2011-11-15T00:08:02', '1', 1, 3, '12:00:00', '00:00:00'),
204 ('Mrs', 'Jocelyn', 'England', '1-826-860-7773', 'Chico', '71102', '2012-05-31T18:01:43', '1', 1, 4, '09:00:00', '17:00:00'),
205 ('Dr', 'Vincent', 'Banks', '1-225-418-0941', 'Palo Alto', '03281', '2011-08-07T07:22:43', '0', 1, 5, '18:00:00', '02:00:00'),
206 ('Mrs', 'Stewart', 'Chan', '1-781-793-2340', 'Grand Forks', 'L1U 3ED', '2012-11-01T23:14:44', '1', 6, 6, '08:00:00', '16:00:00');
207
208INSERT INTO dept (name)
209 VALUES
210 ( 'IT' ),
211 ( 'Sales' ),
212 ( 'Pre-Sales' ),
213 ( 'Marketing' ),
214 ( 'Senior Management' ),
215 ( 'Accounts' ),
216 ( 'Support' );
217
218INSERT INTO permission (name)
219 VALUES
220 ( 'Printer' ),
221 ( 'Servers' ),
222 ( 'Desktop' ),
223 ( 'VMs' ),
224 ( 'Web-site' ),
225 ( 'Accounts' );
226
227
228INSERT INTO user_dept (user_id, dept_id)
229 VALUES
230 ( 1, 1 ),
231 ( 2, 4 ),
232 ( 3, 7 ),
233 ( 4, 3 ),
234 ( 5, 2 ),
235 ( 6, 6 ),
236 ( 7, 2 ),
237 ( 8, 1 ),
238 ( 9, 2 ),
239 ( 10, 3 ),
240 ( 11, 4 ),
241 ( 12, 5 ),
242 ( 13, 6 ),
243 ( 14, 4 ),
244 ( 15, 3 ),
245 ( 16, 6 ),
246 ( 17, 3 ),
247 ( 18, 7 ),
248 ( 19, 7 ),
249 ( 20, 1 ),
250 ( 21, 2 ),
251 ( 22, 6 ),
252 ( 23, 3 ),
253 ( 24, 4 ),
254 ( 25, 5 ),
255 ( 26, 6 ),
256 ( 27, 7 ),
257 ( 28, 2 ),
258 ( 29, 3 ),
259 ( 30, 1 ),
260 ( 31, 3 ),
261 ( 32, 4 ),
262 ( 33, 6 ),
263 ( 34, 7 ),
264 ( 35, 2 ),
265 ( 36, 3 );
266
267
268INSERT INTO user_permission (user_id, permission_id)
269 VALUES
270 ( 1, 1 ),
271 ( 1, 3 ),
272 ( 1, 4 ),
273 ( 2, 4 ),
274 ( 2, 1 ),
275 ( 4, 3 ),
276 ( 4, 4 ),
277 ( 4, 5 ),
278 ( 4, 6 ),
279 ( 5, 2 ),
280 ( 6, 6 ),
281 ( 7, 2 ),
282 ( 8, 1 ),
283 ( 9, 2 ),
284 ( 10, 3 ),
285 ( 10, 2 ),
286 ( 10, 1 ),
287 ( 11, 4 ),
288 ( 11, 6 ),
289 ( 12, 5 ),
290 ( 12, 1 ),
291 ( 12, 2 ),
292 ( 13, 1 ),
293 ( 13, 2 ),
294 ( 13, 3 ),
295 ( 13, 6 ),
296 ( 18, 3 ),
297 ( 18, 2 ),
298 ( 18, 1 ),
299 ( 20, 1 ),
300 ( 20, 2 ),
301 ( 20, 3 ),
302 ( 21, 2 ),
303 ( 21, 4 ),
304 ( 22, 6 ),
305 ( 22, 3 ),
306 ( 22, 2 ),
307 ( 30, 1 ),
308 ( 30, 5 ),
309 ( 30, 3 ),
310 ( 31, 3 ),
311 ( 32, 4 ),
312 ( 33, 6 ),
313 ( 34, 1 ),
314 ( 34, 2 ),
315 ( 34, 3 ),
316 ( 35, 2 ),
317 ( 36, 3 );
318
319INSERT INTO sites (name)
320 VALUES
321 ( 'Edinburgh' ),
322 ( 'London' ),
323 ( 'Paris' ),
324 ( 'New York' ),
325 ( 'Singapore' ),
326 ( 'Los Angeles' );
327
328
329--
330-- Reading list example table
331--
332IF OBJECT_ID('audiobooks', 'U') IS NOT NULL
333 DROP TABLE audiobooks;
334
335CREATE TABLE audiobooks (
336 id int not null identity,
337 title nvarchar(250) NOT NULL,
338 author nvarchar(250) NOT NULL,
339 duration int NOT NULL,
340 readingOrder int NOT NULL,
341 PRIMARY KEY (id)
342);
343
344INSERT INTO audiobooks (title, author, duration, readingOrder)
345 VALUES
346 ( 'The Final Empire: Mistborn', 'Brandon Sanderson', 1479, 1 ),
347 ( 'The Name of the Wind', 'Patrick Rothfuss', 983, 2 ),
348 ( 'The Blade Itself: The First Law', 'Joe Abercrombie', 1340, 3 ),
349 ( 'The Heroes', 'Joe Abercrombie', 1390, 4 ),
350 ( 'Assassin''s Apprentice: The Farseer Trilogy', 'Robin Hobb', 1043, 5 ),
351 ( 'The Eye of the World: Wheel of Time', 'Robert Jordan', 1802, 6 ),
352 ( 'The Wise Man''s Fear', 'Patrick Rothfuss', 1211, 7 ),
353 ( 'The Way of Kings: The Stormlight Archive', 'Brandon Sanderson', 2734, 8 ),
354 ( 'The Lean Startup', 'Eric Ries', 523, 9 ),
355 ( 'House of Suns', 'Alastair Reynolds', 1096, 10 ),
356 ( 'The Lies of Locke Lamora', 'Scott Lynch', 1323, 11 ),
357 ( 'Best Served Cold', 'Joe Abercrombie', 1592, 12 ),
358 ( 'Thinking, Fast and Slow', 'Daniel Kahneman', 1206, 13 ),
359 ( 'The Dark Tower I: The Gunslinger', 'Stephen King', 439, 14 ),
360 ( 'Theft of Swords: Riyria Revelations', 'Michael J. Sullivan', 1357, 15 ),
361 ( 'The Emperor''s Blades: Chronicle of the Unhewn Throne', 'Brian Staveley', 1126, 16 ),
362 ( 'The Magic of Recluce: Saga of Recluce', 'L. E. Modesitt Jr.', 1153, 17 ),
363 ( 'Red Country', 'Joe Abercrombie', 1196, 18 ),
364 ( 'Warbreaker', 'Brandon Sanderson', 1496, 19 ),
365 ( 'Magician', 'Raymond E. Feist', 2173, 20 ),
366 ( 'Blood Song', 'Anthony Ryan', 1385, 21 ),
367 ( 'Half a King', 'Joe Abercrombie', 565, 22 ),
368 ( 'Prince of Thorns: Broken Empire', 'Mark Lawrence', 537, 23 ),
369 ( 'The Immortal Prince: Tide Lords', 'Jennifer Fallon', 1164, 24 ),
370 ( 'Medalon: Demon Child', 'Jennifer Fallon', 1039, 25 ),
371 ( 'The Black Company: Chronicles of The Black Company', 'Glen Cook', 654, 26 );
372
373
374--
375-- Compound key examples
376--
377IF OBJECT_ID('users_visits', 'U') IS NOT NULL
378 DROP TABLE audiobooks;
379
380CREATE TABLE users_visits (
381 user_id int NOT NULL,
382 site_id int NOT NULL,
383 visit_date datetime DEFAULT NULL,
384 PRIMARY KEY (user_id, visit_date)
385);
386
387
388INSERT INTO users_visits (user_id, site_id, visit_date)
389 VALUES
390 ( 1, 1, '20160812' ),
391 ( 1, 4, '20160814' ),
392 ( 1, 7, '20160819' ),
393 ( 2, 3, '20160712' ),
394 ( 2, 2, '20160707' ),
395 ( 2, 6, '20160701' ),
396 ( 2, 1, '20160730' ),
397 ( 3, 1, '20160626' ),
398 ( 3, 2, '20161205' ),
399 ( 4, 3, '20161121' ),
400 ( 4, 4, '20161010' ),
401 ( 5, 5, '20160802' ),
402 ( 6, 6, '20160805' );
403
404--
405-- DataTables Ajax and server-side processing database (SQL Server)
406--
407IF OBJECT_ID('datatables_demo', 'U') IS NOT NULL
408 DROP TABLE datatables_demo;
409
410CREATE TABLE datatables_demo (
411 id int NOT NULL identity,
412 first_name varchar(250) NOT NULL default '',
413 last_name varchar(250) NOT NULL default '',
414 position varchar(250) NOT NULL default '',
415 email varchar(250) NOT NULL default '',
416 office varchar(250) NOT NULL default '',
417 start_date datetime default NULL,
418 age int,
419 salary int,
420 seq int,
421 extn varchar(8) NOT NULL default '',
422 PRIMARY KEY (id)
423);
424
425SET IDENTITY_INSERT datatables_demo ON;
426
427INSERT INTO datatables_demo
428 ( id, first_name, last_name, age, position, salary, start_date, extn, email, office, seq )
429 VALUES
430 ( 1, 'Tiger', 'Nixon', 61, 'System Architect', 320800, '20110425', 5421, 't.nixon@datatables.net', 'Edinburgh', 2 ),
431 ( 2, 'Garrett', 'Winters', 63, 'Accountant', 170750, '20110725', 8422, 'g.winters@datatables.net', 'Tokyo', 22 ),
432 ( 3, 'Ashton', 'Cox', 66, 'Junior Technical Author', 86000, '20090112', 1562, 'a.cox@datatables.net', 'San Francisco', 6 ),
433 ( 4, 'Cedric', 'Kelly', 22, 'Senior Javascript Developer', 433060, '20120329', 6224, 'c.kelly@datatables.net', 'Edinburgh', 41 ),
434 ( 5, 'Airi', 'Satou', 33, 'Accountant', 162700, '20081128', 5407, 'a.satou@datatables.net', 'Tokyo', 55 ),
435 ( 6, 'Brielle', 'Williamson', 61, 'Integration Specialist', 372000, '20121202', 4804, 'b.williamson@datatables.net', 'New York', 21 ),
436 ( 7, 'Herrod', 'Chandler', 59, 'Sales Assistant', 137500, '20120806', 9608, 'h.chandler@datatables.net', 'San Francisco', 46 ),
437 ( 8, 'Rhona', 'Davidson', 55, 'Integration Specialist', 327900, '20101014', 6200, 'r.davidson@datatables.net', 'Tokyo', 50 ),
438 ( 9, 'Colleen', 'Hurst', 39, 'Javascript Developer', 205500, '20090915', 2360, 'c.hurst@datatables.net', 'San Francisco', 26 ),
439 ( 10, 'Sonya', 'Frost', 23, 'Software Engineer', 103600, '20081213', 1667, 's.frost@datatables.net', 'Edinburgh', 18 ),
440 ( 11, 'Jena', 'Gaines', 30, 'Office Manager', 90560, '20081219', 3814, 'j.gaines@datatables.net', 'London', 13 ),
441 ( 12, 'Quinn', 'Flynn', 22, 'Support Lead', 342000, '20130303', 9497, 'q.flynn@datatables.net', 'Edinburgh', 23 ),
442 ( 13, 'Charde', 'Marshall', 36, 'Regional Director', 470600, '20081016', 6741, 'c.marshall@datatables.net', 'San Francisco', 14 ),
443 ( 14, 'Haley', 'Kennedy', 43, 'Senior Marketing Designer', 313500, '20121218', 3597, 'h.kennedy@datatables.net', 'London', 12 ),
444 ( 15, 'Tatyana', 'Fitzpatrick', 19, 'Regional Director', 385750, '20100317', 1965, 't.fitzpatrick@datatables.net', 'London', 54 ),
445 ( 16, 'Michael', 'Silva', 66, 'Marketing Designer', 198500, '20121127', 1581, 'm.silva@datatables.net', 'London', 37 ),
446 ( 17, 'Paul', 'Byrd', 64, 'Chief Financial Officer (CFO)', 725000, '20100609', 3059, 'p.byrd@datatables.net', 'New York', 32 ),
447 ( 18, 'Gloria', 'Little', 59, 'Systems Administrator', 237500, '20090410', 1721, 'g.little@datatables.net', 'New York', 35 ),
448 ( 19, 'Bradley', 'Greer', 41, 'Software Engineer', 132000, '20121013', 2558, 'b.greer@datatables.net', 'London', 48 ),
449 ( 20, 'Dai', 'Rios', 35, 'Personnel Lead', 217500, '20120926', 2290, 'd.rios@datatables.net', 'Edinburgh', 45 ),
450 ( 21, 'Jenette', 'Caldwell', 30, 'Development Lead', 345000, '20110903', 1937, 'j.caldwell@datatables.net', 'New York', 17 ),
451 ( 22, 'Yuri', 'Berry', 40, 'Chief Marketing Officer (CMO)', 675000, '20090625', 6154, 'y.berry@datatables.net', 'New York', 57 ),
452 ( 23, 'Caesar', 'Vance', 21, 'Pre-Sales Support', 106450, '20111212', 8330, 'c.vance@datatables.net', 'New York', 29 ),
453 ( 24, 'Doris', 'Wilder', 23, 'Sales Assistant', 85600, '20100920', 3023, 'd.wilder@datatables.net', 'Sidney', 56 ),
454 ( 25, 'Angelica', 'Ramos', 47, 'Chief Executive Officer (CEO)', 1200000, '20091009', 5797, 'a.ramos@datatables.net', 'London', 36 ),
455 ( 26, 'Gavin', 'Joyce', 42, 'Developer', 92575, '20101222', 8822, 'g.joyce@datatables.net', 'Edinburgh', 5 ),
456 ( 27, 'Jennifer', 'Chang', 28, 'Regional Director', 357650, '20101114', 9239, 'j.chang@datatables.net', 'Singapore', 51 ),
457 ( 28, 'Brenden', 'Wagner', 28, 'Software Engineer', 206850, '20110607', 1314, 'b.wagner@datatables.net', 'San Francisco', 20 ),
458 ( 29, 'Fiona', 'Green', 48, 'Chief Operating Officer (COO)', 850000, '20100311', 2947, 'f.green@datatables.net', 'San Francisco', 7 ),
459 ( 30, 'Shou', 'Itou', 20, 'Regional Marketing', 163000, '20110814', 8899, 's.itou@datatables.net', 'Tokyo', 1 ),
460 ( 31, 'Michelle', 'House', 37, 'Integration Specialist', 95400, '20110602', 2769, 'm.house@datatables.net', 'Sidney', 39 ),
461 ( 32, 'Suki', 'Burks', 53, 'Developer', 114500, '20091022', 6832, 's.burks@datatables.net', 'London', 40 ),
462 ( 33, 'Prescott', 'Bartlett', 27, 'Technical Author', 145000, '20110507', 3606, 'p.bartlett@datatables.net', 'London', 47 ),
463 ( 34, 'Gavin', 'Cortez', 22, 'Team Leader', 235500, '20081026', 2860, 'g.cortez@datatables.net', 'San Francisco', 52 ),
464 ( 35, 'Martena', 'Mccray', 46, 'Post-Sales support', 324050, '20110309', 8240, 'm.mccray@datatables.net', 'Edinburgh', 8 ),
465 ( 36, 'Unity', 'Butler', 47, 'Marketing Designer', 85675, '20091209', 5384, 'u.butler@datatables.net', 'San Francisco', 24 ),
466 ( 37, 'Howard', 'Hatfield', 51, 'Office Manager', 164500, '20081216', 7031, 'h.hatfield@datatables.net', 'San Francisco', 38 ),
467 ( 38, 'Hope', 'Fuentes', 41, 'Secretary', 109850, '20100212', 6318, 'h.fuentes@datatables.net', 'San Francisco', 53 ),
468 ( 39, 'Vivian', 'Harrell', 62, 'Financial Controller', 452500, '20090214', 9422, 'v.harrell@datatables.net', 'San Francisco', 30 ),
469 ( 40, 'Timothy', 'Mooney', 37, 'Office Manager', 136200, '20081211', 7580, 't.mooney@datatables.net', 'London', 28 ),
470 ( 41, 'Jackson', 'Bradshaw', 65, 'Director', 645750, '20080926', 1042, 'j.bradshaw@datatables.net', 'New York', 34 ),
471 ( 42, 'Olivia', 'Liang', 64, 'Support Engineer', 234500, '20110203', 2120, 'o.liang@datatables.net', 'Singapore', 4 ),
472 ( 43, 'Bruno', 'Nash', 38, 'Software Engineer', 163500, '20110503', 6222, 'b.nash@datatables.net', 'London', 3 ),
473 ( 44, 'Sakura', 'Yamamoto', 37, 'Support Engineer', 139575, '20090819', 9383, 's.yamamoto@datatables.net', 'Tokyo', 31 ),
474 ( 45, 'Thor', 'Walton', 61, 'Developer', 98540, '20130811', 8327, 't.walton@datatables.net', 'New York', 11 ),
475 ( 46, 'Finn', 'Camacho', 47, 'Support Engineer', 87500, '20090707', 2927, 'f.camacho@datatables.net', 'San Francisco', 10 ),
476 ( 47, 'Serge', 'Baldwin', 64, 'Data Coordinator', 138575, '20120409', 8352, 's.baldwin@datatables.net', 'Singapore', 44 ),
477 ( 48, 'Zenaida', 'Frank', 63, 'Software Engineer', 125250, '20100104', 7439, 'z.frank@datatables.net', 'New York', 42 ),
478 ( 49, 'Zorita', 'Serrano', 56, 'Software Engineer', 115000, '20120601', 4389, 'z.serrano@datatables.net', 'San Francisco', 27 ),
479 ( 50, 'Jennifer', 'Acosta', 43, 'Junior Javascript Developer', 75650, '20130201', 3431, 'j.acosta@datatables.net', 'Edinburgh', 49 ),
480 ( 51, 'Cara', 'Stevens', 46, 'Sales Assistant', 145600, '20111206', 3990, 'c.stevens@datatables.net', 'New York', 15 ),
481 ( 52, 'Hermione', 'Butler', 47, 'Regional Director', 356250, '20110321', 1016, 'h.butler@datatables.net', 'London', 9 ),
482 ( 53, 'Lael', 'Greer', 21, 'Systems Administrator', 103500, '20090227', 6733, 'l.greer@datatables.net', 'London', 25 ),
483 ( 54, 'Jonas', 'Alexander', 30, 'Developer', 86500, '20100714', 8196, 'j.alexander@datatables.net', 'San Francisco', 33 ),
484 ( 55, 'Shad', 'Decker', 51, 'Regional Director', 183000, '20081113', 6373, 's.decker@datatables.net', 'Edinburgh', 43 ),
485 ( 56, 'Michael', 'Bruce', 29, 'Javascript Developer', 183000, '20110627', 5384, 'm.bruce@datatables.net', 'Singapore', 16 ),
486 ( 57, 'Donna', 'Snider', 27, 'Customer Support', 112000, '20110125', 4226, 'd.snider@datatables.net', 'New York', 19 );
487
488 SET IDENTITY_INSERT datatables_demo OFF;