-- sqlap_Chapter14_InsertData

-- DDLは書籍の"はじめに"に掲載されているSQLを使用してください。
-- 以下の書籍サイトに公開されているサンプルコードにも setup.sql が提供されています。
-- http://www.oreilly.co.jp/books/9784873115894/

-- Product Table Insert
insert into products (product_name) values('Open RoundFile');
insert into products (product_name) values('Visual TurboBuilder');
insert into products (product_name) values('ReConsider');

-- Accounts Table Insert
insert into accounts (account_name, first_name, last_name, email)
  values('sqlap01', 'taro', 'hitachi', 'abc@mail.co.jp');
insert into accounts (account_name, first_name, last_name, email)
  values('sqlap02', 'hanako', 'hitachi', 'def@mail.co.jp');

-- BugStatus Table Insert
insert into bugstatus(status) values ('NEW');

-- Bugs Table Insert
insert into bugs (date_reported, reported_by, status, hours)
  values('2009-12-19', 1, 'NEW', 10.5);
insert into bugs (date_reported, reported_by, status, hours)
  values('2010-06-01', 2, 'NEW', 10.5);
insert into bugs (date_reported, reported_by, status, hours)
  values('2010-02-16', 1, 'NEW', 10.5);
insert into bugs (date_reported, reported_by, status, hours)
  values('2010-02-10', 2, 'NEW', 10.5);
insert into bugs (date_reported, reported_by, status, hours)
  values('2010-02-16', 1, 'NEW', 10.5);
insert into bugs (date_reported, reported_by, status, hours)
  values('2010-01-01', 2, 'NEW', 10.5);
insert into bugs (date_reported, reported_by, status, hours)
  values('2009-11-09', 1, 'NEW', 10.5);
  
-- Bugs Table PrimaryKey Update
update bugs set bug_id = 1234 where bug_id = 1;
update bugs set bug_id = 2248 where bug_id = 2;
update bugs set bug_id = 3456 where bug_id = 3;
update bugs set bug_id = 4077 where bug_id = 4;
update bugs set bug_id = 5150 where bug_id = 5;
update bugs set bug_id = 5678 where bug_id = 6;
update bugs set bug_id = 8063 where bug_id = 7;

-- BugsProducts Table Insert
insert into bugsproducts (bug_id, product_id)
  values(1234, 1);
insert into bugsproducts (bug_id, product_id)
  values(2248, 1);
insert into bugsproducts (bug_id, product_id)
  values(3456, 2);
insert into bugsproducts (bug_id, product_id)
  values(4077, 2);
insert into bugsproducts (bug_id, product_id)
  values(5150, 2);
insert into bugsproducts (bug_id, product_id)
  values(5678, 3);
insert into bugsproducts (bug_id, product_id)
  values(8063, 3);