diff options
| author | Iago Toral <itoral@igalia.com> | 2010-02-19 08:28:06 +0100 |
|---|---|---|
| committer | Iago Toral <itoral@igalia.com> | 2010-02-19 08:28:06 +0100 |
| commit | c4ea842a4056f124f61c6bf7f2d58d401cda92d3 (patch) | |
| tree | 3e133940efafffe490a76435cd3a2c978f53540a | |
| parent | 8320aa8bf0ccd5e5e6502631f426c421207829c0 (diff) | |
| download | grilo-plugins-c4ea842a4056f124f61c6bf7f2d58d401cda92d3.tar.gz | |
[podcasts] Remove primary key constraint so that the same stream
can be part of various podcasts.
| -rw-r--r-- | src/podcasts/grl-podcasts.c | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/src/podcasts/grl-podcasts.c b/src/podcasts/grl-podcasts.c index 96fe90e..37b20c2 100644 --- a/src/podcasts/grl-podcasts.c +++ b/src/podcasts/grl-podcasts.c @@ -56,14 +56,14 @@ "desc TEXT," \ "last_refreshed DATE)" -#define GRL_SQL_CREATE_TABLE_STREAMS \ - "CREATE TABLE IF NOT EXISTS streams (" \ - "podcast INTEGER REFERENCES podcasts (id)," \ - "url TEXT PRIMARY KEY," \ - "title TEXT," \ - "length INTEGER," \ - "mime TEXT," \ - "date TEXT," \ +#define GRL_SQL_CREATE_TABLE_STREAMS \ + "CREATE TABLE IF NOT EXISTS streams ( " \ + "podcast INTEGER REFERENCES podcasts (id), " \ + "url TEXT, " \ + "title TEXT, " \ + "length INTEGER, " \ + "mime TEXT, " \ + "date TEXT, " \ "desc TEXT)" #define GRL_SQL_GET_PODCASTS \ |