Half way through migration away from sqlalchemy

[pwp.git] / app / DB / db_postgres.sql

diff --git a/app/DB/db_postgres.sql b/app/DB/db_postgres.sql
index e302dcf8ab321a0c5fa7002b73ffe524ba9cc1e0..1b8ac790386fa1659a0525731e236a243cc93ba0 100644 (file)
--- 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)