-
Notifications
You must be signed in to change notification settings - Fork 7
/
Copy pathpostgresql-data.sql
88 lines (82 loc) · 6.74 KB
/
postgresql-data.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
81
82
83
84
85
86
87
88
begin;
-- tables
create table departments (
department_id serial constraint departments$pk primary key,
name varchar(255) not null,
location varchar(4000),
country varchar(4000)
);
create table employees (
employee_id serial constraint employees$pk primary key,
department_id integer
constraint employees_department_id_fk
references departments on delete cascade,
name varchar(50) not null,
email varchar(255),
cost_center integer,
date_hired date,
job varchar(255)
);
-- indexes
create index employees_i1 on employees (department_id);
-- data
insert into departments (department_id, name, location, country)
values
(1, 'Product Support', 'Tanquecitos', 'United States'),
(2, 'Electronic Data Interchange', 'Sugarloaf', 'United States'),
(3, 'Legal', 'Dale City', 'United States'),
(4, 'Transportation', 'Grosvenor', 'United States'),
(5, 'Finance', 'Riverside', 'United States');
insert into employees (department_id, name, email, cost_center, date_hired, job)
values
(1, 'Gricelda Luebbers', '[email protected]', 82, current_date - 4, 'Marketing Associate'),
(1, 'Dean Bollich', '[email protected]', 83, current_date - 88, 'Usability Engineer'),
(1, 'Milo Manoni', '[email protected]', 64, current_date - 28, 'Analyst'),
(1, 'Laurice Karl', '[email protected]', 56, current_date - 58, 'Evengilist'),
(1, 'August Rupel', '[email protected]', 1, current_date - 37, 'Analyst'),
(1, 'Salome Guisti', '[email protected]', 6, current_date - 2, 'Marketing Manager'),
(1, 'Lovie Ritacco', '[email protected]', 91, current_date - 4, 'Help Desk Specialist'),
(1, 'Chaya Greczkowski', '[email protected]', 55, current_date - 66, 'Support Specialist'),
(1, 'Twila Coolbeth', '[email protected]', 22, current_date - 88, 'Support Specialist'),
(1, 'Carlotta Achenbach', '[email protected]', 99, current_date - 19, 'Marketing Manager'),
(1, 'Jeraldine Audet', '[email protected]', 41, current_date - 84, 'Quality Control Specialist'),
(1, 'August Arouri', '[email protected]', 54, current_date - 95, 'Customer Advocate'),
(1, 'Ward Stepney', '[email protected]', 41, current_date - 99, 'Cloud Architect'),
(1, 'Ayana Barkhurst', '[email protected]', 42, current_date - 76, 'Sustaining Engineering'),
(1, 'Luana Berends', '[email protected]', 24, current_date - 32, 'Vice President'),
(1, 'Lecia Alvino', '[email protected]', 29, current_date - 43, 'Engineer'),
(1, 'Joleen Himmelmann', '[email protected]', 20, current_date - 14, 'Business Applications'),
(1, 'Monty Kinnamon', '[email protected]', 85, current_date - 24, 'Usability Engineer'),
(1, 'Dania Grizzard', '[email protected]', 53, current_date - 11, 'Project Manager'),
(1, 'Inez Yamnitz', '[email protected]', 75, current_date - 53, 'HR Representitive'),
(1, 'Fidel Creps', '[email protected]', 41, current_date - 22, 'President'),
(1, 'Luis Pothoven', '[email protected]', 12, current_date - 44, 'Sales Consultant'),
(1, 'Bernardo Phoenix', '[email protected]', 11, current_date - 68, 'Software Engineer'),
(1, 'Carolyne Centore', '[email protected]', 61, current_date - 88, 'Business Operations'),
(1, 'Cornell Pratico', '[email protected]', 51, current_date - 92, 'System Operations'),
(1, 'Sam Rueb', '[email protected]', 83, current_date - 49, 'Sustaining Engineering'),
(1, 'Shakita Sablock', '[email protected]', 96, current_date - 39, 'Data Architect'),
(1, 'Sandy Heffren', '[email protected]', 58, current_date - 58, 'Systems Administrator'),
(1, 'Tressa Coppens', '[email protected]', 1, current_date - 48, 'Business Operations'),
(1, 'Shira Arocho', '[email protected]', 8, current_date - 7, 'Sales Representative'),
(1, 'Carter Sacarello', '[email protected]', 89, current_date - 62, 'Security Specialist'),
(1, 'Linda Merida', '[email protected]', 55, current_date - 55, 'Support Specialist'),
(1, 'Winfred Sohn', '[email protected]', 92, current_date - 73, 'User Experience Manager'),
(1, 'Nestor Caparros', '[email protected]', 39, current_date - 59, 'Systems Administrator'),
(1, 'Brooks Craker', '[email protected]', 37, current_date - 36, 'Engineer'),
(1, 'Ruthann Nixa', '[email protected]', 88, current_date - 20, 'Analyst'),
(1, 'Kenny Campobasso', '[email protected]', 15, current_date - 63, 'Customer Advocate'),
(1, 'Hildred Donnel', '[email protected]', 73, current_date - 30, 'Business Operations'),
(1, 'Luther Ardinger', '[email protected]', 71, current_date - 6, 'Web Developer'),
(1, 'Rhoda Hasfjord', '[email protected]', 100, current_date - 28, 'Security Specialist'),
(1, 'Cori Ablin', '[email protected]', 26, current_date - 30, 'Cloud Architect'),
(1, 'Reinaldo Feltner', '[email protected]', 42, current_date - 82, 'Webmaster'),
(1, 'Coralee Acerno', '[email protected]', 93, current_date - 31, 'Director'),
(1, 'Katherine Tagg', '[email protected]', 74, current_date - 84, 'Marketing Manager'),
(1, 'Lenore Sullivan', '[email protected]', 45, current_date - 42, 'Network Architect'),
(1, 'erda Sheer', '[email protected]', 57, current_date - 18, 'Accounting Analyst'),
(1, 'Pete Chevis', '[email protected]', 19, current_date - 68, 'Webmaster'),
(1, 'Joseph Wilke', '[email protected]', 15, current_date - 63, 'Quality Assurance Analyst'),
(1, 'Nella Rupnick', '[email protected]', 26, current_date - 70, 'Security Specialist'),
(1, 'Azalee Goodwater', '[email protected]', 14, current_date - 39, 'Business Development Manager');
commit;