--# -*- mode: sql; coding: sjis-dos -*-
--# ================================================================
--$ user
insert into user (id, account, password, enabled, verno) values (01, 'U92001', 'Ss/jICpf9c9GeJj8WKqx1hUClEE=', true, 0)
insert into user (id, account, password, enabled, verno) values (02, 'U92002', 'Ss/jICpf9c9GeJj8WKqx1hUClEE=', true, 0)
insert into user (id, account, password, enabled, verno) values (03, 'U92003', 'Ss/jICpf9c9GeJj8WKqx1hUClEE=', true, 0)
insert into user (id, account, password, enabled, verno) values (04, 'U92004', 'Ss/jICpf9c9GeJj8WKqx1hUClEE=', true, 0)
insert into user (id, account, password, enabled, verno) values (05, 'U92005', 'Ss/jICpf9c9GeJj8WKqx1hUClEE=', true, 0)
insert into user (id, account, password, enabled, verno) values (06, 'U92006', 'Ss/jICpf9c9GeJj8WKqx1hUClEE=', true, 0)
insert into user (id, account, password, enabled, verno) values (07, 'U92007', 'Ss/jICpf9c9GeJj8WKqx1hUClEE=', true, 0)
insert into user (id, account, password, enabled, verno) values (08, 'U92008', 'Ss/jICpf9c9GeJj8WKqx1hUClEE=', true, 0)
insert into user (id, account, password, enabled, verno) values (09, 'U92009', 'Ss/jICpf9c9GeJj8WKqx1hUClEE=', true, 0)
insert into user (id, account, password, enabled, verno) values (10, 'U92010', 'Ss/jICpf9c9GeJj8WKqx1hUClEE=', true, 0)
--$ role
insert into role (id, name, conditional, verno) values (1, 'admin', false, 0)
insert into role (id, name, conditional, verno) values (2, 'member', false, 0)
insert into role (id, name, conditional, verno) values (3, 'guest', true, 0)
insert into user_role (user_id, member_of_role) values (1, 1)
insert into role_group (role_id, member_of_role) values (1, 2)
--# ================================================================
--$ notify
insert into notify (time, user, title, text, verno) values ('2009-11-23', '下川岳洋', 'ChangeLog', 'システム共通部を開発中です。', 0)
--# ================================================================
--$ calendar
insert into calendar (date, cat, name, text, verno) values ('2009-01-01', 'HOLIDAY', '元日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-01-12', 'HOLIDAY', '成人の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-02-11', 'HOLIDAY', '建国記念の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-03-20', 'HOLIDAY', '春分の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-04-29', 'HOLIDAY', '昭和の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-05-03', 'HOLIDAY', '憲法記念日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-05-04', 'HOLIDAY', 'みどりの日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-05-05', 'HOLIDAY', 'こどもの日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-05-06', 'HOLIDAY', '振替休日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-07-20', 'HOLIDAY', '海の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-09-21', 'HOLIDAY', '敬老の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-09-22', 'HOLIDAY', '国民の休日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-09-23', 'HOLIDAY', '秋分の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-10-12', 'HOLIDAY', '体育の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-11-03', 'HOLIDAY', '文化の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-11-23', 'HOLIDAY', '勤労感謝の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2009-12-23', 'HOLIDAY', '天皇誕生日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-01-01', 'HOLIDAY', '元日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-01-12', 'HOLIDAY', '成人の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-02-11', 'HOLIDAY', '建国記念の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-03-20', 'HOLIDAY', '春分の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-04-29', 'HOLIDAY', '昭和の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-05-03', 'HOLIDAY', '憲法記念日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-05-04', 'HOLIDAY', 'みどりの日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-05-05', 'HOLIDAY', 'こどもの日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-05-06', 'HOLIDAY', '振替休日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-07-20', 'HOLIDAY', '海の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-09-21', 'HOLIDAY', '敬老の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-09-22', 'HOLIDAY', '国民の休日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-09-23', 'HOLIDAY', '秋分の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-10-12', 'HOLIDAY', '体育の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-11-03', 'HOLIDAY', '文化の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-11-23', 'HOLIDAY', '勤労感謝の日', '', 0)
insert into calendar (date, cat, name, text, verno) values ('2010-12-23', 'HOLIDAY', '天皇誕生日', '', 0)
--# ================================================================
--$ config
insert into config (cat, key, val, creatable, readable, verno) values ('_CONST', 'SERVICE_NAME', 'Kuzumeji', true, true, 0)
--$ option
insert into option (cat, key, val, ono, creatable, readable, verno) values ('_CONST', 'WORKER_TYPE', 'DIRECTOR', 1, true, true, 0)
insert into option (cat, key, val, ono, creatable, readable, verno) values ('_CONST', 'WORKER_TYPE', 'FULL-TIME', 2, true, true, 0)
insert into option (cat, key, val, ono, creatable, readable, verno) values ('_CONST', 'WORKER_TYPE', 'PART-TIME', 3, true, true, 0)
insert into option (cat, key, val, ono, creatable, readable, verno) values ('_CONST', 'WORKER_TYPE', 'FREE-LANCERS', 4, true, true, 0)
--# ================================================================
--$ party
insert into party (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (01, 'T101', '企画1部', '企画1', '企画1特記事項', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into party (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (02, 'T102', '企画2部', '企画2', '企画2特記事項', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into party (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (03, 'T201', '制作1部', '制作1', '制作1特記事項', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into party (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (04, 'T202', '制作2部', '制作2', '制作2特記事項', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into party (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (05, 'T203', '制作3部', '制作3', '制作3特記事項', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into party (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (06, 'T301', '事業1部', '事業1', '事業1特記事項', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into party (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (07, 'T302', '事業2部', '事業2', '事業2特記事項', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into party (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (08, 'T303', '事業3部', '事業3', '事業3特記事項', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into party (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (09, 'T900', '管理1部', '管理1', '管理1特記事項', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into party (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (10, 'T901', '管理2部', '管理2', '管理2特記事項', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
--$ team
insert into team (id) values (01)
insert into team (id) values (02)
insert into team (id) values (03)
insert into team (id) values (04)
insert into team (id) values (05)
insert into team (id) values (06)
insert into team (id) values (07)
insert into team (id) values (08)
insert into team (id) values (09)
insert into team (id) values (10)
--$ person
insert into person (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (01, 'W92001', '企画一郎', 'キカクイチロウ'  , '', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into person (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (02, 'W92002', '企画二郎', 'キカクジロウ'    , '', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into person (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (03, 'W92003', '制作一郎', 'セイサクイチロウ', '', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into person (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (04, 'W92004', '制作二郎', 'セイサクジロウ'  , '', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into person (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (05, 'W92005', '制作三郎', 'セイサクサブロウ', '', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into person (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (06, 'W92006', '事業一郎', 'ジギョウイチロウ', '', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into person (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (07, 'W92007', '事業二郎', 'ジギョウジロウ'  , '', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into person (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (08, 'W92008', '事業三郎', 'ジギョウサブロウ', '', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into person (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (09, 'W92009', '管理一郎', 'カンリイチロウ'  , '', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
insert into person (id, code, name, nick, note, zip, addr1, addr2, tel, mail, web, creatable, readable, verno) values (10, 'W92010', '管理二郎', 'カンリジロウ'    , '', '163-8001', '東京都新宿区西新宿', '2-8-1', '03-5321-1111', 'nobody@nowhere.com', 'http://www.metro.tokyo.jp/', true, true, 0)
--$ worker
insert into worker (id, team_id, user_id) values (01, 01, 01)
insert into worker (id, team_id, user_id) values (02, 02, 02)
insert into worker (id, team_id, user_id) values (03, 03, 03)
insert into worker (id, team_id, user_id) values (04, 04, 04)
insert into worker (id, team_id, user_id) values (05, 05, 05)
insert into worker (id, team_id, user_id) values (06, 06, 06)
insert into worker (id, team_id, user_id) values (07, 07, 07)
insert into worker (id, team_id, user_id) values (08, 08, 08)
insert into worker (id, team_id, user_id) values (09, 09, 09)
insert into worker (id, team_id, user_id) values (10, 10, 10)
--# ================================================================
--$ balance_sheet
insert into balance_sheet (id, verno) values (01, 01)
--$ bs_asset
insert into bs_asset (id, petty_cash, ordinary_account, verno) values (01, 3000000, 10000000, 01)
--$ bs_liability
insert into bs_liability (id, verno) values (01, 01)
--$ bs_net_worth
insert into bs_net_worth (id, verno) values (01, 01)
--# ================================================================
