librefm-commits
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Librefm-commits] [1571] added unique constraint to 'name' in Artist tab


From: David Mignot
Subject: [Librefm-commits] [1571] added unique constraint to 'name' in Artist table
Date: Thu, 14 May 2009 17:16:47 +0000

Revision: 1571
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1571
Author:   idflood
Date:     2009-05-14 17:16:46 +0000 (Thu, 14 May 2009)
Log Message:
-----------
added unique constraint to 'name' in Artist table

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

Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php  2009-05-14 17:02:24 UTC (rev 1570)
+++ trunk/gnukebox/install.php  2009-05-14 17:16:46 UTC (rev 1571)
@@ -111,7 +111,7 @@
 
        $adodb->Execute("CREATE TABLE Artist(
                id SERIAL PRIMARY KEY,
-               name VARCHAR(255),
+               name VARCHAR(255) unique,
                mbid VARCHAR(36),
                streamable INTEGER,
                bio_published INTEGER,





reply via email to

[Prev in Thread] Current Thread [Next in Thread]