[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1446] add id fields to Artist and Album tables
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1446] add id fields to Artist and Album tables |
Date: |
Sun, 10 May 2009 02:52:20 +0000 |
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),
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1446] add id fields to Artist and Album tables,
Clint Adams <=