summaryrefslogtreecommitdiffabout
path: root/src/schema.sql
Side-by-side diff
Diffstat (limited to 'src/schema.sql') (more/less context) (show whitespace changes)
-rw-r--r--src/schema.sql9
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
+);