INSERT INTO packages (code, name)
VALUES ('writing', 'WRITING');
INSERT INTO packages (code, name)
VALUES ('editing', 'EDITING');
INSERT INTO packages (code, name)
VALUES ('writing_editing', 'WRITING + EDITING');

INSERT INTO package_configs (package_id, has_author, has_reviser, has_editor, has_pm, author_deadline_days, 
reviser_deadline_days, editor_deadline_days, pm_deadline_days, client_deadline, category_intro, category_desc,
special_offer_conditions, special_invoice_conditions)
SELECT id, 1, 0, 0, 0, 1, 0, 0, 0, 2, 'Text Content | Writing', '✔ LANGUAGE: [LANGUAGE]
✔ LENGTH: [LENGTH] [UNITS]/TEXT
✔ INFORMATION RESEARCH
✔ CONTENT WRITING
✔ PLAGIARISM FILTER', 'The terms and conditions of the Provision of Services Agreement located at http://www.key-content.com/terms are incorporated into and are part of this agreement, in their entirety. Customer and Issuer are bound and obligated to each other as described therein.',
'-'
FROM packages
WHERE code = 'writing';

INSERT INTO package_configs (package_id, has_author, has_reviser, has_editor, has_pm, author_deadline_days, 
reviser_deadline_days, editor_deadline_days, pm_deadline_days, client_deadline, category_intro, category_desc,
special_offer_conditions, special_invoice_conditions)
SELECT id, 0, 0, 1, 0, 0, 0, 1, 0, 2, 'Text Content | Editing', '✔ LANGUAGE: [LANGUAGE]
✔ LENGTH: [LENGTH] [UNITS]/TEXT
✔ GRAMMAR AND SPELLING CHECK
✔ STYLE & READABILITY PROOFREADING', 'The terms and conditions of the Provision of Services Agreement located at http://www.key-content.com/terms are incorporated into and are part of this agreement, in their entirety. Customer and Issuer are bound and obligated to each other as described therein.',
'-'
FROM packages
WHERE code = 'editing';

INSERT INTO package_configs (package_id, has_author, has_reviser, has_editor, has_pm, author_deadline_days, 
reviser_deadline_days, editor_deadline_days, pm_deadline_days, client_deadline, category_intro, category_desc,
special_offer_conditions, special_invoice_conditions)
SELECT id, 1, 0, 1, 0, 1, 0, 1, 0, 3, 'Text Content | Writing + Editing', '✔ LANGUAGE: [LANGUAGE]
✔ LENGTH: [LENGTH] [UNITS]/TEXT
✔ INFORMATION RESEARCH
✔ CONTENT WRITING
✔ PLAGIARISM FILTER
✔ GRAMMAR AND SPELLING CHECK
✔ STYLE & READABILITY PROOFREADING', 'The terms and conditions of the Provision of Services Agreement located at http://www.key-content.com/terms are incorporated into and are part of this agreement, in their entirety. Customer and Issuer are bound and obligated to each other as described therein.',
'-'
FROM packages
WHERE code = 'writing_editing';