diff options
| author | randomdan <randomdan@localhost> | 2014-01-05 21:02:18 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2014-01-05 21:02:18 +0000 |
| commit | 1f48d4d973f412037e9346865aa3f70ab7a8beba (patch) | |
| tree | aa6630143518e88fc5a4dad67b5aab5bdcef01ab | |
| parent | Unify the daemon base code (diff) | |
| download | p2pvr-1f48d4d973f412037e9346865aa3f70ab7a8beba.tar.bz2 p2pvr-1f48d4d973f412037e9346865aa3f70ab7a8beba.tar.xz p2pvr-1f48d4d973f412037e9346865aa3f70ab7a8beba.zip | |
Corrections to schema
| -rw-r--r-- | p2pvr/datasources/schema.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/p2pvr/datasources/schema.sql b/p2pvr/datasources/schema.sql index 126286d..e76b6b8 100644 --- a/p2pvr/datasources/schema.sql +++ b/p2pvr/datasources/schema.sql @@ -66,7 +66,7 @@ CREATE TABLE events ( -- CREATE FUNCTION event_tsvector(e events) RETURNS tsvector - LANGUAGE sql STABLE LEAKPROOF + LANGUAGE sql STABLE AS $$ select (setweight(to_tsvector('english', e.title), 'A') || setweight(to_tsvector('english', coalesce(e.subtitle, '')), 'B') || @@ -276,10 +276,10 @@ CREATE TABLE services ( providername text, type smallint, defaultauthority text, - runningstatus smallint NOT NULL, - eitschedule boolean NOT NULL, - eitpresentfollowing boolean NOT NULL, - freecamode boolean NOT NULL, + runningstatus smallint, + eitschedule boolean, + eitpresentfollowing boolean, + freecamode boolean, transportstreamid integer NOT NULL, programid integer ); |