From 1f48d4d973f412037e9346865aa3f70ab7a8beba Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Sun, 5 Jan 2014 21:02:18 +0000
Subject: Corrections to schema

---
 p2pvr/datasources/schema.sql | 10 +++++-----
 1 file 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
 );
-- 
cgit v1.2.3