diff options
| -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 ); |