[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1574] create the Relationship_Flags table before User
From: |
David Mignot |
Subject: |
[Librefm-commits] [1574] create the Relationship_Flags table before User_Relationship_Flags |
Date: |
Thu, 14 May 2009 18:18:39 +0000 |
Revision: 1574
http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1574
Author: idflood
Date: 2009-05-14 18:18:39 +0000 (Thu, 14 May 2009)
Log Message:
-----------
create the Relationship_Flags table before User_Relationship_Flags
Modified Paths:
--------------
trunk/gnukebox/install.php
Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php 2009-05-14 18:14:55 UTC (rev 1573)
+++ trunk/gnukebox/install.php 2009-05-14 18:18:39 UTC (rev 1574)
@@ -265,6 +265,10 @@
uid2 INTEGER REFERENCES Users(uniqueid) ON DELETE CASCADE,
established INTEGER NOT NULL,
PRIMARY KEY (uid1, uid2))");
+
+ $adodb->Execute("CREATE TABLE Relationship_Flags (
+ flag VARCHAR(12),
+ PRIMARY KEY (flag))");
$adodb->Execute("CREATE TABLE User_Relationship_Flags (
uid1 INTEGER,
@@ -272,11 +276,8 @@
flag VARCHAR(12) REFERENCES Relationship_Flags(flag),
PRIMARY KEY (uid1, uid2, flag),
FOREIGN KEY (uid1, uid2) REFERENCES User_Relationships (uid1,
uid2))");
-
- $adodb->Execute("CREATE TABLE Relationship_Flags (
- flag VARCHAR(12),
- PRIMARY KEY (flag))");
-
+
+
$adodb->Execute("INSERT INTO Relationship_Flags VALUES ('contact')");
$adodb->Execute("INSERT INTO Relationship_Flags VALUES
('acquaintance')");
$adodb->Execute("INSERT INTO Relationship_Flags VALUES ('friend')");
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1574] create the Relationship_Flags table before User_Relationship_Flags,
David Mignot <=