commit 8c81aecb567d04f70f9b9e41bf8e80b1e5a123de
parent 4221cbbeaded390af2df00fdef7e725383408bc2
Author: Andreas Gruhler <andreas.gruhler@adfinis.com>
Date: Sat, 16 Sep 2023 23:38:29 +0200
doc: fix availability table schema in readme
Diffstat:
1 file changed, 5 insertions(+), 5 deletions(-)
diff --git a/README.md b/README.md
@@ -63,11 +63,11 @@ The schema of the `availability` table is very simple and straight forward:
```bash
sqlite3 app.db ".schema availability"
-CREATE TABLE availability (
- id INTEGER NOT NULL PRIMARY KEY,
- start DATETIME NOT NULL,
- end DATETIME NOT NULL,
- tz TEXT NOT NULL);
+var create_availability = `CREATE TABLE IF NOT EXISTS availability (
+ id INTEGER NOT NULL PRIMARY KEY,
+ start DATETIME NOT NULL,
+ end DATETIME NOT NULL,
+ recurring BOOL NOT NULL);`
```
To show the current availability time slots: