From e5a623ef44dd07c29ec3e985ac9307fe52898b67 Mon Sep 17 00:00:00 2001 From: Jon Bergli Heier Date: Wed, 17 Nov 2010 20:05:59 +0100 Subject: Drop channel_hours, as this can be calculated from user_hours with channel_id. --- pg.pgc | 8 -------- 1 file changed, 8 deletions(-) diff --git a/pg.pgc b/pg.pgc index 18410ca..787135a 100644 --- a/pg.pgc +++ b/pg.pgc @@ -48,13 +48,6 @@ int pg_init() { PRIMARY KEY (id), UNIQUE (name) ); - EXEC SQL CREATE TABLE channel_hours ( - channel_id integer, - time_index integer, - lines integer, - PRIMARY KEY (channel_id, time_index), - FOREIGN KEY (channel_id) REFERENCES channel (id) - ); EXEC SQL CREATE TABLE channel_file ( id serial, channel_id integer, @@ -131,7 +124,6 @@ int pg_upgrade() { EXEC SQL WHENEVER SQLERROR SQLPRINT; void pg_dropall() { EXEC SQL DROP TABLE channel CASCADE; - EXEC SQL DROP TABLE channel_hours; EXEC SQL DROP TABLE channel_file; EXEC SQL DROP TABLE users CASCADE; EXEC SQL DROP TABLE user_hours; -- cgit v1.2.3