1 files changed, 9 insertions, 0 deletions

diff --git a/src/schema.sql b/src/schema.sql
new file mode 100644
index 0000000..f0fc4dd
--- a/dev/null
+++ b/src/schema.sql
@@ -0,0 +1,9 @@
+CREATE TABLE sleeps (
+                s_tobed text NOT NULL,          -- w3cish timestamp with minute precision
+                s_alarm text NOT NULL PRIMARY KEY,-- w3cish timestamp with minute precision
+                s_window integer NOT NULL,      -- number of minutes
+                s_data_a integer NOT NULL,      -- number of seconds
+                s_almost_awakes text NOT NULL,  -- [^0-9:TZ-]-separated list of w3cish
+                                                -- timestamps with second precision
+                s_timezone integer NOT NULL     -- seconds west of GMT, TODO: make use of it
+);