aboutsummaryrefslogtreecommitdiffstats
path: root/vendor/sabre/dav/examples/sql/sqlite.principals.sql
diff options
context:
space:
mode:
Diffstat (limited to 'vendor/sabre/dav/examples/sql/sqlite.principals.sql')
-rw-r--r--vendor/sabre/dav/examples/sql/sqlite.principals.sql11
1 files changed, 5 insertions, 6 deletions
diff --git a/vendor/sabre/dav/examples/sql/sqlite.principals.sql b/vendor/sabre/dav/examples/sql/sqlite.principals.sql
index 09dbc4d24..4105156f8 100644
--- a/vendor/sabre/dav/examples/sql/sqlite.principals.sql
+++ b/vendor/sabre/dav/examples/sql/sqlite.principals.sql
@@ -1,16 +1,15 @@
CREATE TABLE principals (
- id INTEGER PRIMARY KEY ASC,
- uri TEXT,
+ id INTEGER PRIMARY KEY ASC NOT NULL,
+ uri TEXT NOT NULL,
email TEXT,
displayname TEXT,
- vcardurl TEXT,
UNIQUE(uri)
);
CREATE TABLE groupmembers (
- id INTEGER PRIMARY KEY ASC,
- principal_id INTEGER,
- member_id INTEGER,
+ id INTEGER PRIMARY KEY ASC NOT NULL,
+ principal_id INTEGER NOT NULL,
+ member_id INTEGER NOT NULL,
UNIQUE(principal_id, member_id)
);