1 files changed, 19 insertions, 0 deletions
diff --git a/sql/create-schema.sql b/sql/create-schema.sql
new file mode 100644
index 0000000..04e94fd
--- /dev/null
+++ b/sql/create-schema.sql
@@ -0,0 +1,19 @@
+CREATE TABLE status (
+ code VARCHAR(255) PRIMARY KEY,
+ class VARCHAR(255) NOT NULL,
+ description VARCHAR(255) NOT NULL,
+ is_active BOOLEAN NOT NULL
+);
+
+CREATE TABLE line (
+ id INT PRIMARY KEY,
+ name VARCHAR(255) NOT NULL UNIQUE
+);
+
+CREATE TABLE line_status (
+ time DATETIME NOT NULL,
+ line_id INT NOT NULL REFERENCES line(id),
+ status_code VARCHAR(255) NOT NULL REFERENCES status(code),
+ is_active BOOLEAN NOT NULL,
+ details TEXT
+);