[Librefm-commits] [1574] create the Relationship_Flags table before User_Relationship_Flags

[David Mignot]

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')");