diff options
| author | woro <woro@e10066b5-e1e2-0310-b819-94efdf66514b> | 2008-02-09 08:12:48 +0000 |
|---|---|---|
| committer | woro <woro@e10066b5-e1e2-0310-b819-94efdf66514b> | 2008-02-09 08:12:48 +0000 |
| commit | 8db363fa1cefd36c37c571b21ffddf069ac948c7 (patch) | |
| tree | f3b707a40fb895dbd13012d831cd811e33366ba0 | |
| parent | 68b3ea8221158573d1c152c04cef324955d7e632 (diff) | |
| download | vdr-plugin-muggle-8db363fa1cefd36c37c571b21ffddf069ac948c7.tar.gz vdr-plugin-muggle-8db363fa1cefd36c37c571b21ffddf069ac948c7.tar.bz2 | |
just like for mysql and sqlite, drop tables before creating if they exist.
This patch is only needed as preparation for the next (restructure
code and fix mugglei -c option)
git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@1007 e10066b5-e1e2-0310-b819-94efdf66514b
| -rw-r--r-- | mg_db_gd_pg.c | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mg_db_gd_pg.c b/mg_db_gd_pg.c index 566ad9b..97d6fdc 100644 --- a/mg_db_gd_pg.c +++ b/mg_db_gd_pg.c @@ -142,6 +142,7 @@ mgDbGd::Threadsafe() static char *db_cmds[] = { + "DROP TABLE IF EXISTS album", "CREATE TABLE album ( " "artist varchar(255) default NULL, " "title varchar(255) default NULL, " @@ -153,21 +154,25 @@ static char *db_cmds[] = "PRIMARY KEY (cddbid))", "CREATE INDEX alb_artist ON album (artist)", "CREATE INDEX alb_title ON album (title)", + "DROP TABLE IF EXISTS genre", "CREATE TABLE genre (" "id varchar(10) NOT NULL default '', " "id3genre smallint default NULL, " "genre varchar(255) default NULL, " "freq int default NULL, " "PRIMARY KEY (id))", + "DROP TABLE IF EXISTS language", "CREATE TABLE language (" "id varchar(4) NOT NULL default '', " "language varchar(40) default NULL, " "freq int default NULL, " "PRIMARY KEY (id))", + "DROP TABLE IF EXISTS musictype", "CREATE TABLE musictype (" "musictype varchar(40) default NULL, " "id serial, " "PRIMARY KEY (id)) ", + "DROP TABLE IF EXISTS playlist", "CREATE TABLE playlist ( " "title varchar(255) default NULL, " "author varchar(255) default NULL, " @@ -175,13 +180,16 @@ static char *db_cmds[] = "created timestamp default NULL, " "id serial, " "PRIMARY KEY (id))", + "DROP TABLE IF EXISTS playlistitem", "CREATE TABLE playlistitem ( " "playlist int NOT NULL," "trackid int NOT NULL) WITH OIDS", + "DROP TABLE IF EXISTS source", "CREATE TABLE source ( " "source varchar(40) default NULL, " "id serial, " "PRIMARY KEY (id)) ", + "DROP TABLE IF EXISTS tracks", "CREATE TABLE tracks ( " "artist varchar(255) default NULL, " "title varchar(255) default NULL, " |