Drop channel_hours, as this can be calculated from user_hours with channel_id.

1 files changed, 0 insertions, 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;