delete from e.do_timecard; delete from e.do_time; delete from e.do_expense; delete from e.do; delete from e.plan_person_monthly; delete from e.plan_person; delete from e.plan_expense_monthly; delete from e.plan_expense; update e.plan set plan_cashflow_id=null; delete from e.plan_cashflow_monthly; delete from e.sales_project_monthly; update e.plan set sales_project_id=null; delete from e.sales_project; delete from e.plan_cashflow; delete from e.plan; delete from e.activity_check; delete from e.activity; delete from e.contactlog; delete from r.calendar; delete from r.param; delete from r.default_price; delete from r.news; update r.company set group_no=null,leader_no=null,salesman_no=null,manager_no=null; delete from r.person; delete from r.company; delete from r.group; delete from r.unit_sales; delete from r.unit; delete from r.person; delete from r.company; alter sequence r.calendar_id_seq restart with 1; insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-1-1', '祝日', '元日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-1-8', '祝日', '成人の日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-2-11', '祝日', '建国記念の日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-2-12', '祝日', '振替休日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-3-21', '祝日', '春分の日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-4-29', '祝日', '昭和の日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-4-30', '祝日', '振替休日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-5-3', '祝日', '憲法記念日 ', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-5-4', '祝日', 'みどりの日 ', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-5-5', '祝日', '子供の日 ', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-7-16', '祝日', '海の日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-9-17', '祝日', '敬老の日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-9-23', '祝日', '秋分の日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-9-24', '祝日', '振替休日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-10-8', '祝日', '体育の日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-11-3', '祝日', '文化の日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-11-23', '祝日', '勤労感謝の日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-12-23', '祝日', '天皇誕生日', 0); insert into r.calendar (id, ymd, cat, name, verno) values (nextval('r.calendar_id_seq'), '2007-12-24', '祝日', '振替休日', 0); alter sequence r.calendar_id_seq restart with 1000000; alter sequence r.param_id_seq restart with 1; insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '法人区分', '顧客法人', '顧客法人', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '法人区分', '協力会社', '協力会社', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '法人区分', '購入先', '購入先', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '格付区分', 'AAA', 'AAA: 与信限度額(6万円)', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '格付区分', 'AA', 'AA : 与信限度額(4万円)', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '格付区分', 'A', 'A : 与信限度額(2万円)', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '格付区分', 'BBB', 'BBB: 与信限度額(1.5万円)', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '格付区分', 'BB', 'BB : 与信限度額(1万円)', 5, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '格付区分', 'B', 'B : 与信限度額(5000円)', 6, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '格付区分', 'CCC', 'CCC: 与信限度額(1000円)', 7, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '格付区分', 'CC', 'CC : 与信限度額(0円)', 8, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '格付区分', 'C', 'C : 与信限度額(0円)', 9, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '格付区分', 'なし', 'なし - 評点による', 10, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '評点区分', '80点以上', '80点以上: 与信限度額(1.5万円)', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '評点区分', '70-79点', '70-79点: 与信限度額(1万円)', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '評点区分', '60-69点', '60-69点: 与信限度額(7000円)', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '評点区分', '50-59点', '50-59点: 与信限度額(3000円)', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '評点区分', '45-49点', '45-49点: 与信限度額(500円)', 5, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '評点区分', '45点未満', '45点未満: 与信限度額(0円)', 6, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '評点区分', 'なし', 'なし - 業態による', 10, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '業態区分', '東証上場', '東証上場: 与信限度額(1万円)', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '業態区分', '店頭上場', '店頭上場: 与信限度額(7000円)', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '業態区分', '新市場上場', '新市場上場: 与信限度額(3000円)', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '業態区分', '公益法人等', '公益法人等: 与信限度額(500円)', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '業態区分', '海外法人', '海外法人: 与信限度額(500円)', 5, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '業態区分', 'その他', 'その他: 与信限度額(100円)', 10, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '個人区分', '正社員', '正社員', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '個人区分', '契約社員', '契約社員', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '個人区分', '協力社員', '協力社員', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '個人区分', '顧客個人', '顧客個人', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '個人区分', '潜在顧客', '潜在顧客', 5, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '職位', '1', '1', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '職位', '2', '2', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '職位', '3', '3', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '職位', '4', '4', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '職位', '5', '5', 5, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '職位', '6', '6', 6, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '人件費区分', '人時', '人時', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '人件費区分', '人日', '人日', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '人件費区分', '人月', '人月', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '日付区分', '祝日', '祝日', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '日付区分', '重要日', '重要日', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '案件区分', '営業', '営業', 0, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '案件区分', '一般', '一般', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '案件区分', '協業', '協業', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '案件区分', '社内', '社内', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '案件区分', '汎用', '汎用', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '案件状況', '関係構築', '関係構築', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '案件状況', '提案', '提案', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '案件状況', '契約交渉', '契約交渉', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '案件状況', '先行準備', '先行準備', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '案件状況', '正式活動', '正式活動', 5, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '案件状況', '定着支援', '定着支援', 6, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '契約区分', '請負', '請負', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '契約区分', '委任', '委任', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '売上区分', '企画売上', '企画売上', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '売上区分', '開発売上', '開発売上', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '売上区分', '教育売上', '教育売上', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '売上区分', '製品売上', '製品売上', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業テーマ', '新規開拓', '新規開拓', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業テーマ', '案件継続', '案件継続', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業タイプ', '受託開発', '受託開発', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業タイプ', '開発委託', '開発委託', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '提供品目', 'システム企画', 'システム企画', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '提供品目', 'システム開発', 'システム開発', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '提供品目', 'システム教育', 'システム教育', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業優先度', '最優先', '最優先', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業優先度', '優先', '優先', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業優先度', '通常', '通常', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業優先度', '最低', '最低', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業状況', '種撒き', '種撒き', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業状況', '見込あり', '見込あり', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業状況', '最終調整', '最終調整', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業状況', '契約締結', '契約締結', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '営業状況', '失注', '失注', 5, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '受注確度', '確定', '確定(90%)', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '受注確度', '有利', '有利(70%)', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '受注確度', '微妙', '微妙(50%)', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '受注確度', '不利', '不利(30%)', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '受注確度', '奇跡', '奇跡(10%)', 5, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '失注理由', '事情変化', '事情変化', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '失注理由', '提案評価', '提案評価', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '失注理由', '内部事情', '内部事情', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '失注理由', 'そのほか', 'そのほか', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '計画区分', '模擬', '模擬', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '計画区分', '実行', '実行', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '実行権限', 'メンバ', 'メンバ', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '実行権限', 'PM', 'PM', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '勤務区分', 'PRE', 'PRE', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '勤務区分', 'CHG', 'CHG', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '勤務区分', 'POS', 'POS', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '勤務区分', 'OTH', 'OTH', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '経費区分', '社員経費', '社員経費', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '経費区分', '案件経費', '案件経費', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '経費区分', '外注費', '外注費', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_社員経費_個別', '交通費', '交通費', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_社員経費_個別', '出張旅費', '出張旅費', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_社員経費_個別', '事務消耗品', '事務消耗品', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_社員経費_共通', '新聞図書', '新聞図書', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_社員経費_共通', '研修', '研修', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_個別', '派遣料', '派遣料', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_個別', '派遣交通費', '派遣交通費', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_個別', '収入印紙', '収入印紙', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_個別', '会議費', '会議費', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_個別', '接待交際費', '接待交際費', 5, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '慰労会など', '慰労会など', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '健康診断・人間ドック', '健康診断・人間ドック', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '派遣料', '派遣料', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '派遣交通費', '派遣交通費', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '収入印紙', '収入印紙', 5, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '会議費', '会議費', 6, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '通勤定期代', '通勤定期代', 7, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '交通費', '交通費', 8, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '出張旅費', '出張旅費', 9, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '接待交際費', '接待交際費', 10, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '文房具', '文房具', 11, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', 'OA機器', 'OA機器', 12, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '消耗品', '消耗品', 13, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_案件経費_共通', '採用関係費', '採用関係費', 14, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_外注費_個別', '外注加工費', '外注加工費', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '費目区分_外注費_共通', '外注加工費', '外注加工費', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '承認状況', '未確定', '未確定', 0, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '承認状況', '未承認', '未承認', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '承認状況', 'PM承認', 'PM承認', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '承認状況', 'LM承認', 'LM承認', 3, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '承認状況', '経理承認', '経理承認', 4, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '承認状況', '差戻', '差戻', 5, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '定数', '業務期間', '2007-03-01', 0, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '定数', 'お問い合わせ先', 'mailto:kuzumeji@users.sourceforge.jp', 0, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '定数', 'LDAP接続先', '', 0, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), '定数', 'LDAPドメイン', '', 0, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), 'FAQ', 'パスワードを変更できますか?', '個人設定メニューから変更してください。', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), 'FAQ', '社員名を変更できますか?', '個人設定メニューから変更してください。', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), 'FAQ', '検索で条件入力するたびに検索しないようにできますか?', '個人設定メニューの検索イベントを「なし」にしてください。', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), 'FAQ', '登録したデータが一覧表示へ反映されていないときがあるのはなぜですか?', '再検索するなど一覧を再表示してください。応答速度を高速化するため一部データを遅延読み込みしているため本現象が発生します。ご了解ください。', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), 'FAQ', '「データ操作で想定外の例外を検知しました」のときはどうすればよいですか?', 'データベースやネットワークなどサーバ環境に問題があると考えられるためシステム運用者へ連絡してください。システム再開のアナウンスは別途ご連絡いたします。', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), 'FAQ', '「サーバーが見つかりません。」「ページを表示できません。」などのときはどうすればよいですか?', 'システムが停止しているか,あなたとサーバ間のネットワークに問題があると考えられるためシステム運用者へ連絡してください。システム再開のアナウンスは別途ご連絡いたします。', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), 'FAQ', '「HTTP Status 404」という画面のときはどうすればよいですか?', 'システムはハードウェアとして稼働していますが,図面管理は停止していると考えられるためシステム運用者へ連絡してください。システム再開のアナウンスは別途ご連絡いたします。', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), 'FAQ', '「HTTP Status 500」という画面のときはどうすればよいですか?', 'システムは稼働中ですが,あなたの処理要求をサーバで処理するときに想定外のエラーが発生しました。おもに原因が根深いときに発生するためシステム運用者へ操作データおよび操作内容をできるだけ詳しく状況連絡してください。問題修復のアナウンスは別途ご連絡いたします。', 2, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), 'FAQ', '「HTTP Status 503 - This application is not currently available」という画面のときはどうすればよいですか?', 'システムの計算資源が許容量を越えてしまったときなどシステム稼働の継続が困難なときなどに発生します。再開には何らかの処置が必要となるためシステム運用者へご連絡をお願いします。システム再開のアナウンスは別途ご連絡いたします。', 1, 0); insert into r.param (id, cat, key, val, order_no, verno) values (nextval('r.param_id_seq'), 'FAQ', '「JBoss Seam Debug Page」などのよく分からない画面が表示されたときはどうすればよいですか?', '図面管理システムの表示状態はクライアントへ保存されています。ブラウザの戻るボタンで直前の画面を表示してリトライしてみてください。繰り返し失敗するときは一旦ログアウトしてからやり直してください。(ご迷惑をおかけします。画面へ表示されたログには原因を特定するために開発者にとって有意義な情報が出力されますがサーバログにも同様の情報が出力されるためシステム運用者へのご連絡などは結構です。原因究明から再発防止などの措置がとれた際のアナウンスは別途ご連絡いたします。)', 2, 0); alter sequence r.param_id_seq restart with 1000000; alter sequence r.default_price_id_seq restart with 1; insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '営業', '1', '人月', 1000000, 1000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '営業', '2', '人月', 2000000, 2000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '営業', '3', '人月', 3000000, 3000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '営業', '4', '人月', 4000000, 4000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '営業', '5', '人月', 5000000, 5000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '営業', '6', '人月', 6000000, 6000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '一般', '1', '人月', 1000000, 1500000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '一般', '2', '人月', 2000000, 2500000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '一般', '3', '人月', 3000000, 3500000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '一般', '4', '人月', 4000000, 4500000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '一般', '5', '人月', 5000000, 5500000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '一般', '6', '人月', 6000000, 6500000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '協業', '1', '人月', 1000000, 1300000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '協業', '2', '人月', 2000000, 2300000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '協業', '3', '人月', 3000000, 3300000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '協業', '4', '人月', 4000000, 4300000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '協業', '5', '人月', 5000000, 5300000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '協業', '6', '人月', 6000000, 6300000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '社内', '1', '人月', 1000000, 1000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '社内', '2', '人月', 2000000, 2000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '社内', '3', '人月', 3000000, 3000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '社内', '4', '人月', 4000000, 4000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '社内', '5', '人月', 5000000, 5000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '社内', '6', '人月', 6000000, 6000000, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '汎用', '1', '人月', 1000000, 0, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '汎用', '2', '人月', 2000000, 0, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '汎用', '3', '人月', 3000000, 0, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '汎用', '4', '人月', 4000000, 0, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '汎用', '5', '人月', 5000000, 0, 0); insert into r.default_price (id, activity_cat, job_rank, price_cat, cost_price, unit_price, verno) values (nextval('r.default_price_id_seq'), '汎用', '6', '人月', 6000000, 0, 0); alter sequence r.default_price_id_seq restart with 1000000; alter sequence r.news_id_seq restart with 1; insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-1', '苦集滅道ERP 始動', 'nilcyにより活動開始', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-2', 'SVNリポジトリ作成', 'http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi/kuzumeji-erp/?root=kuzumeji', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-3', 'プロジェクトサイトがオープン', '見てね⇒ http://kuzumeji.sourceforge.jp/', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-4', 'なにを作るか', '活動収支、事業収支、(営業支援)', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-4', 'テーマ', 'シンプル、パワフル', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-4', 'ゴール', '操作性、運用性・保守性、一貫性・合理性', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-4', 'プラン', '〜2007/04 要求開発、〜2007/05 基盤開発、〜2007/08 機能開発、〜2007/09 機能検証', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-5', 'ステータス', 'ガシガシと開発', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-6', 'ステータス', '数社の導入を予定', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-6', 'ステータス', '無支援、孤立開発を決定', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-6', 'ステータス', 'Conf)個人設定を開発', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-7', 'ステータス', 'Resource)リソース権限の画面を開発開始', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-8', 'ステータス', 'Resource)リソース権限の画面を開発完了', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-9', 'ステータス', 'Activity)活動イベント権限の画面を開発完了', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-10', 'ステータス', 'Activity)案件管理のデータ入力画面を開発完了', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-11', 'ステータス', 'Plan)計画・要員計画・工数計画を開発', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-12', 'ステータス', 'Plan)経費計画・入出金計画を開発', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-13', 'ステータス', 'Do)実績を開発', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-14', 'ステータス', 'Do)勤務実績・経費実績を開発', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-15', 'ステータス', '資料)計画書・機能要求設計書を記載', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-16', 'ステータス', '資料)データ設計書を記載', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-17', 'ステータス', 'Resource)マスタメンテを利用者ごとに整理', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-18', 'ステータス', '顧客管理を整理。Plan)営業案件・プロジェクトを整理', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-19', 'ステータス', 'Do)基本実績、勤務時間の入力を再整理。', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-19', 'ステータス', 'Do)勤務時間の入力は該当月の日数分を横へ並べてみた。クリッカブルなカレンダへもいずれ対応したいが', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-19', 'ステータス', '顧客管理の法人系の画面へ法人番号と法人名で検索できるようにした。', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-20', 'ステータス', 'Report)勤務履歴,経費履歴を開発', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-20', 'ステータス', 'Check)勤務承認,経費承認を開発', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-21', 'ステータス', '全体的に洗練化。サジェストボックスを開発。', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-22', 'ステータス', 'レポートをまじめに開発', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-23', 'ステータス', '売上区分の追加など細かな修正', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-26', 'ステータス', '購入先、債券債務など整理', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-29', 'ステータス', '格付、評点、業態による与信限度額の管理など顧客管理を強化', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-4-30', 'ステータス', '決算条件の追加。月毎の案件計画を再考してデータから画面まで大改造。', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-5-16', 'ステータス', '顧客管理の基本機能を確認。区分デフォルト設定。リレーション更新。入力チェック、機能漏れなど対応。', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-5-21', 'ステータス', '顧客管理をさらに確認。製品シリーズ切替をログインで選択。', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-5-22', 'ステータス', 'リソース管理をさらに確認。', 0); insert into r.news (id, ymd, title, content, verno) values (nextval('r.news_id_seq'), '2007-5-23', 'ステータス', '案件管理の営業情報を大整理。そして基本機能を確認。', 0); alter sequence r.news_id_seq restart with 1000000; alter sequence r.group_id_seq restart with 1; insert into r.group (id, no, name, kana, contact_name, contact_zip, contact_addr, contact_tel, contact_fax, contact_mail, contact_url, verno) values (nextval('r.group_id_seq'), '101', '苦集滅道グループ', 'クズメジ・グループ', 'どこでもない', '000-0000', 'どこでもない', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', 0); insert into r.group (id, no, name, kana, contact_name, contact_zip, contact_addr, contact_tel, contact_fax, contact_mail, contact_url, verno) values (nextval('r.group_id_seq'), '102', 'JBoss Group', 'ジェイボス・グループ', 'どこでもない', '000-0000', 'どこでもない', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', 0); alter sequence r.group_id_seq restart with 1000000; alter sequence r.unit_id_seq restart with 1; insert into r.unit (id, no, name, verno) values (nextval('r.unit_id_seq'), '100', 'IT教育部', 0); insert into r.unit (id, no, name, verno) values (nextval('r.unit_id_seq'), '200', 'IT開発部', 0); insert into r.unit (id, no, name, verno) values (nextval('r.unit_id_seq'), '300', 'IT指南部', 0); insert into r.unit (id, no, name, verno) values (nextval('r.unit_id_seq'), '900', '総務部', 0); alter sequence r.unit_id_seq restart with 1000000; alter sequence r.unit_sales_id_seq restart with 1; insert into r.unit_sales (id, unit_no, year, q1, q2, q3, q4, verno) values (nextval('r.unit_sales_id_seq'), '200', '2007-01-01 0:0:1', 100000000, 100000000, 100000000, 100000000, 0); alter sequence r.unit_sales_id_seq restart with 1000000; alter sequence r.person_id_seq restart with 1; insert into r.person (id, cat, pid, no, active, password, name, kana, job_rank, monthly_cost, daily_cost, hourly_cost, rest_paid_vacation_hour, rest_alt_vacation_hour, company_no, role_resource, role_activity, role_plan, role_do, role_check, role_su, role_sales, role_customer, role_accounting, contact_name, contact_zip, contact_addr, contact_tel, contact_fax, contact_mail, contact_url, unit_no, team, verno, work_rate, goal_sales) values (nextval('r.person_id_seq'), '正社員', 'shimokawa', '264', true, 'happyhacking', '下川岳洋', 'シモカワタケヒロ', '6', 1000000, 50000, 5000, 20, 0, null, true, true, true, true, true, true, true, true, true, '豆蔵', '000-0000', '東京', '00-0000-0000', '00-0000-0000', 'shimokawa@mamezou.com', 'http://kuzumeji.sourceforge.jp/', '200', 'フリーソフトウェア制作チーム', 0, 1, 30000000); insert into r.person (id, cat, pid, no, active, password, name, kana, job_rank, monthly_cost, daily_cost, hourly_cost, rest_paid_vacation_hour, rest_alt_vacation_hour, company_no, role_resource, role_activity, role_plan, role_do, role_check, role_su, role_sales, role_customer, role_accounting, contact_name, contact_zip, contact_addr, contact_tel, contact_fax, contact_mail, contact_url, unit_no, team, verno, work_rate, goal_sales) values (nextval('r.person_id_seq'), '契約社員', 'rms', '600', true, 'happyhacking', 'リチャードストールマン', 'リチャードストールマン', '6', 1000000, 50000, 5000, 20, 0, null, true, true, true, true, true, false, false, true, true, 'GNU', '000-0000', 'US', '00-0000-0000', '00-0000-0000', 'rms@gnu.org', 'http://www.gnu.org/', '100', 'フリーソフトウェア制作チーム', 0, 1, 30000000); alter sequence r.company_id_seq restart with 1; insert into r.company (id, cat, no, credit_debt, alias, name, kana, group_no, product, note, contact_name, contact_zip, contact_addr, contact_unit, contact_tel, contact_fax, contact_mail, contact_url, bill_name, bill_zip, bill_addr, bill_unit, bill_tel, bill_fax, bill_mail, bill_url, salesman_no, leader_no, manager_no, verno) values (nextval('r.company_id_seq'), '顧客法人', '1001', false, 'ねこバス', '(株)ねこバス', 'ネコバス', '101', 'ねこバスを製造・販売', '不明', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', '264', '264', '264', 0); insert into r.company (id, cat, no, credit_debt, alias, name, kana, group_no, product, note, contact_name, contact_zip, contact_addr, contact_unit, contact_tel, contact_fax, contact_mail, contact_url, bill_name, bill_zip, bill_addr, bill_unit, bill_tel, bill_fax, bill_mail, bill_url, salesman_no, leader_no, manager_no, verno) values (nextval('r.company_id_seq'), '顧客法人', '1002', false, '宇宙旅行社', '(株)宇宙旅行社', 'ウチュウリョコウシャ', '101', '宇宙旅行を企画・販売', '不明', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', '264', '264', '264', 0); insert into r.company (id, cat, no, credit_debt, alias, name, kana, group_no, product, note, contact_name, contact_zip, contact_addr, contact_unit, contact_tel, contact_fax, contact_mail, contact_url, bill_name, bill_zip, bill_addr, bill_unit, bill_tel, bill_fax, bill_mail, bill_url, salesman_no, leader_no, manager_no, verno) values (nextval('r.company_id_seq'), '協力会社', '2001', true, '筋金開発団', '(株)筋金開発団', 'スジガネカイハツダン', '101', 'ITシステム開発', '不明', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', '264', '264', '264', 0); insert into r.company (id, cat, no, credit_debt, alias, name, kana, group_no, product, note, contact_name, contact_zip, contact_addr, contact_unit, contact_tel, contact_fax, contact_mail, contact_url, bill_name, bill_zip, bill_addr, bill_unit, bill_tel, bill_fax, bill_mail, bill_url, salesman_no, leader_no, manager_no, verno) values (nextval('r.company_id_seq'), '協力会社', '2002', true, '精鋭頭脳団', '(株)精鋭頭脳団', 'セイエイズノウダン', '101', 'ITコンサル', '不明', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', '264', '264', '264', 0); insert into r.company (id, cat, no, credit_debt, alias, name, kana, group_no, product, note, contact_name, contact_zip, contact_addr, contact_unit, contact_tel, contact_fax, contact_mail, contact_url, bill_name, bill_zip, bill_addr, bill_unit, bill_tel, bill_fax, bill_mail, bill_url, salesman_no, leader_no, manager_no, verno) values (nextval('r.company_id_seq'), '購入先', '3001', true, '超速プリンタ', '(株)超速プリンタ', 'チョウソクプリンタ', '101', 'プリンタの開発・販売', '不明', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', '264', '264', '264', 0); insert into r.company (id, cat, no, credit_debt, alias, name, kana, group_no, product, note, contact_name, contact_zip, contact_addr, contact_unit, contact_tel, contact_fax, contact_mail, contact_url, bill_name, bill_zip, bill_addr, bill_unit, bill_tel, bill_fax, bill_mail, bill_url, salesman_no, leader_no, manager_no, verno) values (nextval('r.company_id_seq'), '購入先', '3002', true, 'レトロ文房具', '(株)レトロ文房具', 'レトロブンボウグ', '101', '文房具の開発・販売', '不明', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', 'だれでもない', '000-0000', 'どこでもない', '不明', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.com/', '264', '264', '264', 0); alter sequence r.company_id_seq restart with 1000000; insert into r.person (id, cat, no, active, password, name, kana, job_rank, monthly_cost, daily_cost, hourly_cost, rest_paid_vacation_hour, rest_alt_vacation_hour, company_no, role_resource, role_activity, role_plan, role_do, role_check, role_su, role_sales, role_customer, role_accounting, contact_name, contact_zip, contact_addr, contact_tel, contact_fax, contact_mail, contact_url, unit_no, verno, work_rate, goal_sales) values (nextval('r.person_id_seq'), '協力社員', '700', true, 'happyhacking', '筋金小僧', 'スジガネコゾウ', '', 1000000, 50000, 5000, 20, 0, '2001', true, true, true, true, true, false, false, true, true, '自宅', '000-0000', '北海道', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.org', 'http://www.nowhere.org/', '900', 0, 1, 0); insert into r.person (id, cat, no, active, password, name, kana, job_rank, monthly_cost, daily_cost, hourly_cost, rest_paid_vacation_hour, rest_alt_vacation_hour, company_no, role_resource, role_activity, role_plan, role_do, role_check, role_su, role_sales, role_customer, role_accounting, contact_name, contact_zip, contact_addr, contact_tel, contact_fax, contact_mail, contact_url, unit_no, verno, work_rate, goal_sales) values (nextval('r.person_id_seq'), '顧客個人', '800', true, 'happyhacking', 'コナン', 'コナン', '', 1000000, 50000, 5000, 20, 0, '1001', true, true, true, true, true, false, false, true, true, '例の島', '000-0000', '島なので', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.com', 'http://www.nowhere.org/', '900', 0, 1, 0); insert into r.person (id, cat, no, active, password, name, kana, job_rank, monthly_cost, daily_cost, hourly_cost, rest_paid_vacation_hour, rest_alt_vacation_hour, company_no, role_resource, role_activity, role_plan, role_do, role_check, role_su, role_sales, role_customer, role_accounting, contact_name, contact_zip, contact_addr, contact_tel, contact_fax, contact_mail, contact_url, unit_no, verno, work_rate, goal_sales) values (nextval('r.person_id_seq'), '潜在顧客', '900', true, 'happyhacking', '風船おじさん', 'フウセンオジサン', '', 1000000, 50000, 5000, 20, 0, null, true, true, true, true, true, false, false, true, true, '空', '000-0000', '天国', '00-0000-0000', '00-0000-0000', 'nobody@nowhere.org', 'http://www.nowhere.org/', '900', 0, 1, 0); alter sequence r.person_id_seq restart with 1000000; update r.calendar set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update r.company set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update r.default_price set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update r.person set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update r.news set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update r.param set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update r.unit_sales set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update r.unit set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; alter sequence e.activity_id_seq restart with 1; alter sequence e.activity_check_id_seq restart with 1; alter sequence e.contactlog_id_seq restart with 1; alter sequence e.plan_id_seq restart with 1; alter sequence e.plan_person_id_seq restart with 1; alter sequence e.plan_person_monthly_id_seq restart with 1; alter sequence e.plan_cashflow_id_seq restart with 1; alter sequence e.plan_cashflow_monthly_id_seq restart with 1; alter sequence e.plan_expense_id_seq restart with 1; alter sequence e.plan_expense_monthly_id_seq restart with 1; alter sequence e.sales_project_id_seq restart with 1; alter sequence e.sales_project_monthly_id_seq restart with 1; alter sequence e.do_timecard_id_seq restart with 1; alter sequence e.do_id_seq restart with 1; alter sequence e.do_time_id_seq restart with 1; alter sequence e.do_expense_id_seq restart with 1; insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), '1001', '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '営業', 'D0000100', 'Aシステム構築', 'Aシステム開発', 'Aシステム基盤開発', '生産管理システム再構築', '30年も継続利用した汎用機システムをUnixで再構築', '正式活動', '2007-2-16', '2007-3-31', '請負', '請負', '2007-2-16', '2007-3-31', 50000000, 50000000, 1, '狙いは年間保守50%削減', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), '1001', '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '一般', 'C0000200', '営業支援システム制作', 'システム企画', '基本構想', '現状分析・理想像策定・実行計画', '基本構想・RFP作成', '正式活動', '2007-2-16', '2007-3-31', '請負', '請負', '2007-2-16', '2007-3-31', 50000000, 50000000, 1, '狙いは安定稼働', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), '1001', '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '一般', 'C0000210', '営業支援システム制作', 'システム開発', '基本開発', '基盤開発・基本機能を開発', '業務分析・基本設計', '正式活動', '2007-2-16', '2007-3-31', '請負', '請負', '2007-4-1', '2007-5-31', 50000000, 50000000, 1, '狙いは安定稼働', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), '1001', '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '一般', 'C0000211', '営業支援システム制作', 'システム開発', '追加開発', '追加機能を開発', '基本機能の洗練・追加開発', '正式活動', '2007-2-16', '2007-3-31', '請負', '請負', '2007-5-1', '2007-5-31', 50000000, 50000000, 1, '狙いは安定稼働', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), '1001', '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '一般', 'C0000220', '営業支援システム制作', 'システム運用', '運用分析', '運用の現状分析', '運用費の比率が高過ぎる', '正式活動', '2007-2-16', '2007-3-31', '請負', '請負', '2007-6-1', '2007-8-30', 50000000, 50000000, 1, '狙いは安定稼働', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), '1001', '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '一般', 'C0000221', '営業支援システム制作', 'システム運用', '新運用設計', '新しい運用設計', '運用費の比率を正常化', '正式活動', '2007-2-16', '2007-3-31', '請負', '請負', '2007-7-1', '2007-8-30', 50000000, 50000000, 1, '狙いは安定稼働', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), '1001', '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '一般', 'C0000222', '営業支援システム制作', 'システム運用', '運用最適化', '実運用の中で最適化', 'リリース後が勝負', '正式活動', '2007-2-16', '2007-3-31', '請負', '請負', '2007-8-1', '2007-8-30', 50000000, 50000000, 1, '狙いは安定稼働', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), '1002', '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '協業', 'E0000300', 'C社SE教育', 'SE基本教育', 'SE基本教育1', '大手SI屋向け教育', '不明', '正式活動', '2007-2-16', '2007-3-31', '請負', '請負', '2007-2-16', '2007-3-31', 50000000, 50000000, 1, '狙いは生産性50%向上', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), null, '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '一般', 'I0000400', '社内IT化', 'IT導入', 'IT導入支援', '藁....', '笑える状況を打破', '正式活動', '2007-2-16', '2007-3-31', '請負', '請負', '2007-2-16', '2007-3-31', 50000000, 50000000, 1, '狙いは業務効率50%向上', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), null, '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '一般', 'P0000500', 'ERPパッケージ販売', 'PKG開発', 'PKG基本開発', '不明', '不明', '正式活動', '2007-2-16', '2007-3-31', '請負', '請負', '2007-2-16', '2007-3-31', 50000000, 50000000, 1, '不明', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), null, '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '汎用', 'G9000100', '有休休暇', '有休休暇', '有休休暇', '不明', '不明', '正式活動', '2007-1-1', '2007-12-31', '', '', '2007-2-16', '2007-3-31', 50000000, 50000000, 1, '不明', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), null, '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '汎用', 'G9000101', '振替休暇', '振替休暇', '振替休暇', '不明', '不明', '正式活動', '2007-1-1', '2007-12-31', '', '', '2007-2-16', '2007-3-31', 50000000, 50000000, 1, '不明', 0); insert into e.activity (id, company_no, salesman_no, leader_no, unit_no, biz_theme, biz_type, biz_product, biz_priority, biz_sts, biz_order, biz_folder, biz_lost, cat, no, project, phase, alias, name, digest, sts, start_ymd, end_ymd, customer_contract, partner_contract, contract_start_ymd, contract_end_ymd, all_price, pure_price, risk_rate, note, verno) values (nextval('e.activity_id_seq'), null, '264', '264', '200', '新規開拓', '受託開発', 'システム開発', '最優先', '契約締結', '確定', '/home/D0000100', null, '汎用', 'G9000200', '部門共通', '部門共通', '部門共通', '不明', '不明', '正式活動', '2007-1-1', '2007-12-31', '', '', '2007-2-16', '2007-3-31', 50000000, 50000000, 1, '不明', 0); insert into e.activity_check (id, activity_no, no, checked, verno) values (nextval('e.activity_check_id_seq'), 'D0000100', '1', true, 0); insert into e.activity_check (id, activity_no, no, checked, verno) values (nextval('e.activity_check_id_seq'), 'D0000100', '2', false, 0); insert into e.activity_check (id, activity_no, no, checked, verno) values (nextval('e.activity_check_id_seq'), 'C0000200', '1', false, 0); insert into e.activity_check (id, activity_no, no, checked, verno) values (nextval('e.activity_check_id_seq'), 'C0000200', '2', true, 0); insert into e.contactlog (id, company_no, ymd, sts, note, verno) values (nextval('e.contactlog_id_seq'), '1001', '2007-2-10', '提案', 'お客様へ提案書を送付した。ご説明は明日。合否判定は来週早々の予定。', 0); insert into e.contactlog (id, company_no, ymd, sts, note, verno) values (nextval('e.contactlog_id_seq'), '1001', '2007-2-16', '契約交渉', '契約条件を相談して10%の営業値引で締結。来月から正式に活動開始の予定。', 0); insert into e.plan (id, activity_no, cat, price_cat, note, verno) values (nextval('e.plan_id_seq'), 'D0000100', '模擬', '人月', '計画の補記', 0); insert into e.plan (id, activity_no, cat, price_cat, note, verno) values (nextval('e.plan_id_seq'), 'C0000200', '実行', '人月', '計画の補記', 0); insert into e.plan_person (id, plan_id, role, person_no, cost_price, unit_price, verno) values (nextval('e.plan_person_id_seq'), 2, 'PM', '264', 1000000, 3000000, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-2-1', 1.0, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-3-1', 0.5, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-4-1', 0.25, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-5-1', 0, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-6-1', 0, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-7-1', 0, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-8-1', 0, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-9-1', 0, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-10-1', 0, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-11-1', 0, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-12-1', 0, 0); insert into e.plan_person_monthly (id, plan_person_id, ym, time, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2008-1-1', 0, 0); insert into e.plan_expense (id, plan_id, cat, item, price, num, verno) values (nextval('e.plan_expense_id_seq'), 2, '社員経費', '交通費', 200000, 1, 0); insert into e.plan_expense (id, plan_id, cat, item, price, num, verno) values (nextval('e.plan_expense_id_seq'), 2, '案件経費', '接待交際費', 50000, 1, 0); insert into e.plan_expense (id, plan_id, cat, item, price, num, verno) values (nextval('e.plan_expense_id_seq'), 2, '外注費', '外注加工費', 2000000, 1, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-2-1', 80000, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-3-1', 80000, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-4-1', 40000, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-5-1', 50, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-6-1', 60, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-7-1', 70, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-8-1', 80, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-9-1', 90, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-10-1', 100, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-11-1', 110, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-12-1', 120, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2008-1-1', 130, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-2-1', 20000, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-3-1', 20000, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-4-1', 10000, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-5-1', 0, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-6-1', 0, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-7-1', 0, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-8-1', 80, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-9-1', 90, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-10-1', 100, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-11-1', 110, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-12-1', 120, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2008-1-1', 130, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2007-2-1', 2000000, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2007-3-1', 2000000, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2007-4-1', 0, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2007-5-1', 0, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2007-6-1', 0, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2007-7-1', 0, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2007-8-1', 80, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2007-9-1', 90, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2007-10-1', 100, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2007-11-1', 110, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2007-12-1', 120, 0); insert into e.plan_expense_monthly (id, plan_expense_id, ym, cost, verno) values (nextval('e.plan_person_monthly_id_seq'), 3, '2008-1-1', 130, 0); insert into e.plan_cashflow (id, plan_id, dd_bill, dd_in, dd_out, verno) values (nextval('e.plan_cashflow_id_seq'), 1, 20, 25, 26, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-2-1', 2500000, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-3-1', 2500000, 2500000, 1000000, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-4-1', 0, 2500000, 1000000, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-5-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-6-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-7-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-8-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-9-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-10-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-11-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2007-12-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 1, '2008-1-1', 0, 0, 0, 0); insert into e.plan_cashflow (id, plan_id, dd_bill, dd_in, dd_out, verno) values (nextval('e.plan_cashflow_id_seq'), 2, 20, 25, 26, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-2-1', 2500000, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-3-1', 2500000, 2500000, 1000000, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-4-1', 0, 2500000, 1000000, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-5-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-6-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-7-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-8-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-9-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-10-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-11-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2007-12-1', 0, 0, 0, 0); insert into e.plan_cashflow_monthly (id, plan_cashflow_id, ym, cash_bill, cash_in, cash_out, verno) values (nextval('e.plan_person_monthly_id_seq'), 2, '2008-1-1', 0, 0, 0, 0); update e.plan set plan_cashflow_id=id; insert into e.sales_project (id, plan_id, verno) values (nextval('e.sales_project_id_seq'), 1, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2007-2-1', 2500000, '2007-3-25', 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2007-3-1', 2500000, '2007-4-25', 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2007-4-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2007-5-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2007-6-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2007-7-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2007-8-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2007-9-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2007-10-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2007-11-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2007-12-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 1, '2008-1-1', 0, null, 0); insert into e.sales_project (id, plan_id, verno) values (nextval('e.sales_project_id_seq'), 2, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2007-2-1', 2500000, '2007-3-25', 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2007-3-1', 2500000, '2007-4-25', 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2007-4-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2007-5-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2007-6-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2007-7-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2007-8-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2007-9-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2007-10-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2007-11-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2007-12-1', 0, null, 0); insert into e.sales_project_monthly (id, sales_project_id, ym, cash_sales, ymd_in, verno) values (nextval('e.sales_project_monthly_id_seq'), 2, '2008-1-1', 0, null, 0); delete from e.do_timecard; insert into e.do_timecard (id, person_no, ym, i01, i02, i03, i04, i05, i06, i07, i08, i09, i10, i11, i12, i13, i14, i15, i16, i17, i18, i19, i20, i21, i22, i23, i24, i25, i26, i27, i28, i29, i30, i31, o01, o02, o03, o04, o05, o06, o07, o08, o09, o10, o11, o12, o13, o14, o15, o16, o17, o18, o19, o20, o21, o22, o23, o24, o25, o26, o27, o28, o29, o30, o31, verno) values (nextval('e.do_timecard_id_seq'), '264', '2007-3-1', '2007-3-1 9:00:00', '2007-3-1 9:00:00', null, null, '2007-3-1 9:00:00', '2007-3-1 9:00:00', '2007-3-1 9:00:00', '2007-3-1 9:00:00', '2007-3-1 9:00:00', null, null, '2007-3-1 9:00:00', '2007-3-1 9:00:00', '2007-3-1 9:00:00', '2007-3-1 9:00:00', '2007-3-1 9:00:00', null, null, '2007-3-1 9:00:00', '2007-3-1 9:00:00', '2007-3-1 9:00:00', '2007-3-1 9:00:00', '2007-3-1 9:00:00', null, null, '2007-3-1 9:00:00', '2007-3-1 9:00:00', '2007-3-1 9:00:00', null, null, null, '2007-3-1 18:00:00', '2007-3-1 18:00:00', null, null, '2007-3-1 18:00:00', '2007-3-1 18:00:00', '2007-3-1 18:00:00', '2007-3-1 18:00:00', '2007-3-1 18:00:00', null, null, '2007-3-1 18:00:00', '2007-3-1 18:00:00', '2007-3-1 18:00:00', '2007-3-1 18:00:00', '2007-3-1 18:00:00', null, null, '2007-3-1 18:00:00', '2007-3-1 18:00:00', '2007-3-1 18:00:00', '2007-3-1 18:00:00', '2007-3-1 18:00:00', null, null, '2007-3-1 18:00:00', '2007-3-1 18:00:00', '2007-3-1 18:00:00', null, null, null, 0); insert into e.do (id, person_no, activity_no, ym, commit_time, commit_expense, commit_project, commit_partner, check_time_sts, check_expense_sts, verno) values (nextval('e.do_id_seq'), '264', 'C0000200', '2007-3-1', false, false, false, false, null, null, 0); insert into e.do (id, person_no, activity_no, ym, commit_time, commit_expense, commit_project, commit_partner, check_time_sts, check_expense_sts, verno) values (nextval('e.do_id_seq'), '264', 'D0000100', '2007-3-1', false, false, false, false, null, null, 0); insert into e.do (id, person_no, activity_no, ym, commit_time, commit_expense, commit_project, commit_partner, check_time_sts, check_expense_sts, verno) values (nextval('e.do_id_seq'), '264', 'G9000200', '2007-3-1', false, false, false, false, null, null, 0); insert into e.do_time (id, do_id, cat, t01, t02, t03, t04, t05, t06, t07, t08, t09, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20, t21, t22, t23, t24, t25, t26, t27, t28, t29, t30, t31, verno) values (nextval('e.do_time_id_seq'), 2, 'PRE', 1, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 0); insert into e.do_time (id, do_id, cat, t01, t02, t03, t04, t05, t06, t07, t08, t09, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20, t21, t22, t23, t24, t25, t26, t27, t28, t29, t30, t31, verno) values (nextval('e.do_time_id_seq'), 2, 'CHG', 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 8, 8, 0, 0, 8, 8, 8, 0, 0, 0, 0); insert into e.do_time (id, do_id, cat, t01, t02, t03, t04, t05, t06, t07, t08, t09, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20, t21, t22, t23, t24, t25, t26, t27, t28, t29, t30, t31, verno) values (nextval('e.do_time_id_seq'), 2, 'OTH', 1, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 0); insert into e.do_time (id, do_id, cat, t01, t02, t03, t04, t05, t06, t07, t08, t09, t10, t11, t12, t13, t14, t15, t16, t17, t18, t19, t20, t21, t22, t23, t24, t25, t26, t27, t28, t29, t30, t31, verno) values (nextval('e.do_time_id_seq'), 3, 'OTH', 1, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 0); insert into e.do_expense (id, do_id, ymd, cat, item, name, place, note, cost, no, verno) values (nextval('e.do_expense_id_seq'), 2, '2007-3-20', '社員経費', '交通費', '自宅から客様', 'KDDI', '納品', 10000, '1', 0); insert into e.do_expense (id, do_id, ymd, cat, item, name, place, note, cost, no, verno) values (nextval('e.do_expense_id_seq'), 2, '2007-3-20', '社員経費', '交通費', '客先から自宅', 'KDDI', '納品', 10000, '2', 0); insert into e.do_expense (id, do_id, ymd, cat, item, name, place, note, cost, no, verno) values (nextval('e.do_expense_id_seq'), 2, '2007-3-20', '案件経費', '接待交際費', '慰労会', '新宿屋台', '不明', 10000, '3', 0); insert into e.do_expense (id, do_id, ymd, cat, item, name, place, note, cost, no, verno) values (nextval('e.do_expense_id_seq'), 2, '2007-3-20', '外注費', '外注加工費', '筋金開発団', '不明', '中の上', 10000, '4', 0); insert into e.do_expense (id, do_id, ymd, cat, item, name, place, note, cost, no, verno) values (nextval('e.do_expense_id_seq'), 3, '2007-3-27', '社員経費', '交通費', '客先から自宅', 'IBM', '不明', 10000, '5', 0); insert into e.do_expense (id, do_id, ymd, cat, item, name, place, note, cost, no, verno) values (nextval('e.do_expense_id_seq'), 3, '2007-3-27', '案件経費', '接待交際費', '送別会', '銀座', '不明', 20000, '6', 0); update e.activity set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update e.activity_check set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update e.contactlog set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update e.do set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update e.do_expense set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update e.do_time set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update e.do_timecard set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update e.plan set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update e.plan_person set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update e.plan_expense set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update e.plan_cashflow set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; update e.sales_project set create_user='000',create_time=current_timestamp,update_user='000',update_time=current_timestamp; alter sequence e.activity_id_seq restart with 1000000; alter sequence e.activity_check_id_seq restart with 1000000; alter sequence e.contactlog_id_seq restart with 1000000; alter sequence e.plan_id_seq restart with 1000000; alter sequence e.plan_person_id_seq restart with 1000000; alter sequence e.plan_person_monthly_id_seq restart with 1000000; alter sequence e.plan_cashflow_id_seq restart with 1000000; alter sequence e.plan_cashflow_monthly_id_seq restart with 1000000; alter sequence e.plan_expense_id_seq restart with 1000000; alter sequence e.plan_expense_monthly_id_seq restart with 1000000; alter sequence e.sales_project_id_seq restart with 1000000; alter sequence e.sales_project_monthly_id_seq restart with 1000000; alter sequence e.do_id_seq restart with 1000000; alter sequence e.do_time_id_seq restart with 1000000; alter sequence e.do_timecard_id_seq restart with 1000000; alter sequence e.do_expense_id_seq restart with 1000000;