X-Git-Url: http://git.datanom.net/pwp.git/blobdiff_plain/e5424f290a1b4f0f9b200e720d19091b63ed3eb2..fc01a3eb12731e8e2512e77b426ab5b33503edd1:/app/DB/db_mysql.sql

diff --git a/app/DB/db_mysql.sql b/app/DB/db_mysql.sql
index 8a27eab..a3a14f5 100644
--- a/app/DB/db_mysql.sql
+++ b/app/DB/db_mysql.sql
@@ -58,9 +58,9 @@ CREATE TABLE album
   name varchar(255),
   visible boolean NOT NULL,
   public boolean NOT NULL,
-  portfolioid integer NOT NULL,
+  portfolio integer NOT NULL,
   CONSTRAINT album_pkey PRIMARY KEY (id),
-  CONSTRAINT album_portfolioid_fkey FOREIGN KEY (portfolioid)
+  CONSTRAINT album_portfolio_fkey FOREIGN KEY (portfolio)
       REFERENCES portfolio (id) MATCH SIMPLE
       ON UPDATE CASCADE ON DELETE CASCADE
 ) ENGINE = InnoDB;
@@ -82,11 +82,11 @@ CREATE TABLE photo
   name varchar(255),
   exif varchar(255),
   format integer NOT NULL,
-  albumid integer NOT NULL,
+  album integer NOT NULL,
   visible boolean NOT NULL,
   public boolean NOT NULL,
   CONSTRAINT photo_pkey PRIMARY KEY (id),
-  CONSTRAINT photo_albumid_fkey FOREIGN KEY (albumid)
+  CONSTRAINT photo_album_fkey FOREIGN KEY (album)
       REFERENCES album (id) MATCH SIMPLE
       ON UPDATE CASCADE ON DELETE CASCADE,
   CONSTRAINT photo_format_fkey FOREIGN KEY (format)