initial commit of db/xas.sql

1 files changed, 128 insertions, 0 deletions

diff --git a/db/xas.sql b/db/xas.sql
new file mode 100644
index 0000000..4318e05
--- /dev/null
+++ b/db/xas.sql
@@ -0,0 +1,128 @@
+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;