summaryrefslogtreecommitdiffabout
path: root/src/schema.sql
authorMichael Krelin <hacker@klever.net>2008-04-05 11:17:33 (UTC)
committer Michael Krelin <hacker@klever.net>2008-04-05 11:17:33 (UTC)
commit04fb190243442e83349f129b523ab747e58100bf (patch) (side-by-side diff)
treeddc28357fbe78b07fd3a5e0aa8088130bf305829 /src/schema.sql
downloadnapkin-0.0.zip
napkin-0.0.tar.gz
napkin-0.0.tar.bz2
Initial commit into public repository0.0
Signed-off-by: Michael Krelin <hacker@klever.net>
Diffstat (limited to 'src/schema.sql') (more/less context) (ignore 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
+);