diff options
| -rw-r--r-- | db/xas.sql | 128 |
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; |