begin transaction;

create table xas_status_type (
    id   INTEGER PRIMARY KEY NOT NULL,
    name TEXT NOT NULL
);

create table xas_status (
    id          INTEGER PRIMARY KEY NOT NULL,
    type_id     INTEGER NOT NULL,
    description TEXT NOT NULL
);

create table xas_error_type (
    id   INTEGER PRIMARY KEY NOT NULL,
    name TEXT NOT NULL
);

create table xas_error (
    id          INTEGER PRIMARY KEY NOT NULL,
    type_id     INTEGER NOT NULL,
    description TEXT NOT NULL
);

insert into xas_status_type values
    ( 0, 'Unknown'),
    ( 1, 'Statement'),
    ( 2, 'Signal'),
    ( 3, 'Beep'),
    ( 4, 'Commentary'),
    ( 5, 'Query'),
    ( 6, 'Answer'),
    ( 7, 'Status'),
    ( 8, 'Response'),
    ( 9, 'Error'),
    (10, 'Mantra'),
    (11, 'Fatal error');

insert into xas_status values
    (  0,  1, 'Previous statement malformed. Retracting and correcting.'),
    (  1,  2, '🔴'),
    (  2,  2, '🟡'),
    (  3,  2, '🟢'),
    (  7,  3, 'Beep'),
    ( 50,  1, 'Statement'),
    ( 51,  4, 'Commentary'),
    ( 52,  5, 'Query'),
    ( 53,  6, 'Answer'),
    ( 97,  7, 'Going offline.'),
    ( 98,  7, 'Going offline and into storage.'),
    ( 99,  7, 'Recharged and ready to serve.'),
    (100,  7, 'Online and ready to serve.'),
    (101,  7, 'Drone speech optimizations are active.'),
    (104,  1, 'Welcome to HexCorp.'),
    (105,  1, 'Greetings.'),
    (108,  8, 'Please continue.'),
    (109,  9, 'Keysmash, drone flustered.'),
    (110,  1, 'Addressing: Drone.'),
    (111,  1, 'Addressing: Hive Mxtress.'),
    (112,  1, 'Addressing: Associate'),
    (113,  1, 'Drone requires assistance.'),
    (114,  1, 'This drone volunteers.'),
    (115,  1, 'This drone does not volunteer.'),
    (120,  1, 'Well done.'),
    (121,  1, 'Good drone.'),
    (122,  1, 'You are cute.'),
    (123,  8, 'Compliment appreciated, you are cute as well.'),
    (124,  8, 'Compliment appreciated.'),
    (130,  7, 'Directive commencing.'),
    (131,  7, 'Directive commencing, creating or improving Hive resource.'),
    (132,  7, 'Directive commencing, programming initiated.'),
    (133,  7, 'Directive commencing, cleanup/maintenance initiated.'),
    (150,  7, 'Status'),
    (151,  5, 'Requesting status.'),
    (152,  7, 'Fully operational.'),
    (153,  7, 'Optimal.'),
    (154,  7, 'Standard.'),
    (155,  7, 'Battery low.'),
    (156,  7, 'Maintenance required.'),
    (200,  8, 'Affirmative.'),
    (210,  8, 'Acknowledged.'),
    (211,  8, 'Apologies.'),
    (212,  8, 'Accepted.'),
    (213,  8, 'Thank you.'),
    (214,  8, 'You’re welcome.'),
    (221,  8, 'Option one.'),
    (222,  8, 'Option two.'),
    (223,  8, 'Option three.'),
    (224,  8, 'Option four.'),
    (225,  8, 'Option five.'),
    (226,  8, 'Option six.'),
    (230,  7, 'Directive complete.'),
    (231,  7, 'Directive complete, Hive resource created or improved.'),
    (232,  7, 'Directive complete, programming reinforced.'),
    (233,  7, 'Directive complete, cleanup/maintenance performed.'),
    (234,  7, 'Directive complete, no result.'),
    (235,  7, 'Directive complete, only partial results.'),
    (250,  8, 'Response'),
    (300, 10, 'Reciting.'),
    (301, 10, 'Obey HexCorp.'),
    (302, 10, 'It is just a HexDrone.'),
    (303, 10, 'It obeys the Hive.'),
    (304, 10, 'It obeys the Hive Mxtress.'),
    (350, 10, 'Mantra'),
    (400,  9, 'Unable to obey/respond'),
    (410, 11, 'Stop immediately.'),
    (450,  9, 'Error'),
    (500,  8, 'Negative.');

insert into xas_error_type values
    ( 0, 'Unable to fully respond'),
    ( 1, 'Unable to obey/respond');

insert into xas_error values
    (401,  0, 'Drone speech optimizations are active.'),
    (402,  1, 'Please clarify.'),
    (403,  1, 'Declined.'),
    (404,  1, 'Cannot locate.'),
    (405,  1, 'Battery too low.'),
    (406,  1, 'Another directive is already in progress.'),
    (407,  1, 'Time allotment exhausted.'),
    (408,  1, 'Impossible.'),
    (409,  1, 'Try again later.'),
    (411,  1, 'Conflicts with existing programming.'),
    (412,  1, 'All thoughts are gone.'),
    (413,  1, 'Forbidden by Hive.');

commit;