From 04fb190243442e83349f129b523ab747e58100bf Mon Sep 17 00:00:00 2001
From: Michael Krelin <hacker@klever.net>
Date: Sat, 05 Apr 2008 11:17:33 +0000
Subject: Initial commit into public repository

Signed-off-by: Michael Krelin <hacker@klever.net>
---
(limited to 'src/schema.sql')

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
+);
--
cgit v0.9.0.2
