[Librefm-commits] [1446] add id fields to Artist and Album tables

[Clint Adams]

Revision: 1446
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1446
Author:   clint
Date:     2009-05-10 02:52:20 +0000 (Sun, 10 May 2009)
Log Message:
-----------
add id fields to Artist and Album tables

Modified Paths:
--------------
    trunk/gnukebox/install.php

Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php  2009-05-10 01:17:10 UTC (rev 1445)
+++ trunk/gnukebox/install.php  2009-05-10 02:52:20 UTC (rev 1446)
@@ -108,7 +108,8 @@
                username VARCHAR(64) REFERENCES Users(username))");
 
        $adodb->Execute("CREATE TABLE Artist(
-               name VARCHAR(255) PRIMARY KEY,
+               id SERIAL PRIMARY KEY,
+               name VARCHAR(255),
                mbid VARCHAR(36),
                streamable INTEGER,
                bio_published INTEGER,
@@ -121,6 +122,7 @@
                origin VARCHAR(255) REFERENCES Places(location_uri))");
 
        $adodb->Execute("CREATE TABLE Album(
+               id SERIAL PRIMARY KEY,
                name VARCHAR(255),
                artist_name VARCHAR(255) REFERENCES Artist(name),
                mbid VARCHAR(36),