|
6#
楼主 |
发表于 2011-3-13 23:29:39
|
只看该作者
-- insert sample data into product_changes table
INSERT INTO product_changes (
product_id, product_type_id, name, description, price
) VALUES (
1, 1, 'Modern Science', 'A description of modern science', 40.00
);
INSERT INTO product_changes (
product_id, product_type_id, name, description, price
) VALUES (
2, 1, 'New Chemistry', 'Introduction to Chemistry', 35.00
);
INSERT INTO product_changes (
product_id, product_type_id, name, description, price
) VALUES (
3, 1, 'Supernova', 'A star explodes', 25.99
);
INSERT INTO product_changes (
product_id, product_type_id, name, description, price
) VALUES (
13, 2, 'Lunar Landing', 'Documentary', 15.99
);
INSERT INTO product_changes (
product_id, product_type_id, name, description, price
) VALUES (
14, 2, 'Submarine', 'Documentary', 15.99
);
INSERT INTO product_changes (
product_id, product_type_id, name, description, price
) VALUES (
15, 2, 'Airplane', 'Documentary', 15.99
);
-- commit the transaction
COMMIT;
-- insert sample data into more_products table
INSERT INTO more_products (
prd_id, prd_type_id, name, available
) VALUES (
1, 1, 'Modern Science', 'Y'
);
INSERT INTO more_products (
prd_id, prd_type_id, name, available
) VALUES (
2, 1, 'Chemistry', 'Y'
);
INSERT INTO more_products (
prd_id, prd_type_id, name, available
) VALUES (
3, NULL, 'Supernova', 'N'
);
INSERT INTO more_products (
prd_id, prd_type_id, name, available
) VALUES (
4, 2, 'Lunar Landing', 'N'
);
INSERT INTO more_products (
prd_id, prd_type_id, name, available
) VALUES (
5, 2, 'Submarine', 'Y'
);
-- commit the transaction
COMMIT;
-- insert sample data into more_employees table
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
1, NULL, 'James', 'Smith', 'CEO', 800000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
2, 1, 'Ron', 'Johnson', 'Sales Manager', 600000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
3, 2, 'Fred', 'Hobbs', 'Sales Person', 200000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
4, 1, 'Susan', 'Jones', 'Support Manager', 500000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
5, 2, 'Rob', 'Green', 'Sales Person', 40000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
6, 4, 'Jane', 'Brown', 'Support Person', 45000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
7, 4, 'John', 'Grey', 'Support Manager', 30000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
8, 7, 'Jean', 'Blue', 'Support Person', 29000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
9, 6, 'Henry', 'Heyson', 'Support Person', 30000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
10, 1, 'Kevin', 'Black', 'Ops Manager', 100000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
11, 10, 'Keith', 'Long', 'Ops Person', 50000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
12, 10, 'Frank', 'Howard', 'Ops Person', 45000
);
INSERT INTO more_employees (
employee_id, manager_id, first_name, last_name, title, salary
) VALUES (
13, 10, 'Doreen', 'Penn', 'Ops Person', 47000
);
-- commit the transaction
COMMIT;
-- insert sample data into divisions table
INSERT INTO divisions (
division_id, name
) VALUES (
'SAL', 'Sales'
);
INSERT INTO divisions (
division_id, name
) VALUES (
'OPE', 'Operations'
);
INSERT INTO divisions (
division_id, name
) VALUES (
'SUP', 'Support'
);
INSERT INTO divisions (
division_id, name
) VALUES (
'BUS', 'Business'
);
-- commit the transaction
COMMIT;
-- insert sample data into jobs table
INSERT INTO jobs (
job_id, name
) VALUES (
'WOR', 'Worker'
);
INSERT INTO jobs (
job_id, name
) VALUES (
'MGR', 'Manager'
);
INSERT INTO jobs (
job_id, name
) VALUES (
'ENG', 'Engineer'
);
INSERT INTO jobs (
job_id, name
) VALUES (
'TEC', 'Technologist'
);
INSERT INTO jobs (
job_id, name
) VALUES (
'PRE', 'President'
);
-- commit the transaction
COMMIT;
-- insert sample data into employees2 table
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
1, 'BUS', 'PRE', 'James', 'Smith', 800000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
2, 'SAL', 'MGR', 'Ron', 'Johnson', 350000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
3, 'SAL', 'WOR', 'Fred', 'Hobbs', 140000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
4, 'SUP', 'MGR', 'Susan', 'Jones', 200000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
5, 'SAL', 'WOR', 'Rob', 'Green', 350000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
6, 'SUP', 'WOR', 'Jane', 'Brown', 200000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
7, 'SUP', 'MGR', 'John', 'Grey', 265000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
8, 'SUP', 'WOR', 'Jean', 'Blue', 110000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
9, 'SUP', 'WOR', 'Henry', 'Heyson', 125000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
10, 'OPE', 'MGR', 'Kevin', 'Black', 225000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
11, 'OPE', 'MGR', 'Keith', 'Long', 165000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
12, 'OPE', 'WOR', 'Frank', 'Howard', 125000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
13, 'OPE', 'WOR', 'Doreen', 'Penn', 145000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
14, 'BUS', 'MGR', 'Mark', 'Smith', 155000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
15, 'BUS', 'MGR', 'Jill', 'Jones', 175000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
16, 'OPE', 'ENG', 'Megan', 'Craig', 245000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
17, 'SUP', 'TEC', 'Matthew', 'Brant', 115000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
18, 'OPE', 'MGR', 'Tony', 'Clerke', 200000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
19, 'BUS', 'MGR', 'Tanya', 'Conway', 200000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
20, 'OPE', 'MGR', 'Terry', 'Cliff', 215000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
21, 'SAL', 'MGR', 'Steve', 'Green', 275000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
22, 'SAL', 'MGR', 'Roy', 'Red', 375000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
23, 'SAL', 'MGR', 'Sandra', 'Smith', 335000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
24, 'SAL', 'MGR', 'Gail', 'Silver', 225000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
25, 'SAL', 'MGR', 'Gerald', 'Gold', 245000
);
INSERT INTO employees2 (
employee_id, division_id, job_id, first_name, last_name, salary
) VALUES (
26, 'SAL', 'MGR', 'Eileen', 'Lane', 235000
); |
|