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

diff --git a/app/DB/db_postgres.sql b/app/DB/db_postgres.sql
index e302dcf..1b8ac79 100644
--- a/app/DB/db_postgres.sql
+++ b/app/DB/db_postgres.sql
@@ -107,9 +107,9 @@ CREATE TABLE public.album
   name character varying(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 public.portfolio (id) MATCH SIMPLE
       ON UPDATE CASCADE ON DELETE CASCADE
 );
@@ -149,11 +149,11 @@ CREATE TABLE public.photo
   name character varying(255),
   exif text,
   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 public.album (id) MATCH SIMPLE
       ON UPDATE CASCADE ON DELETE CASCADE,
   CONSTRAINT photo_format_fkey FOREIGN KEY (format)