Half way through migration away from sqlalchemy

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

diff --git a/app/DB/db_mysql.sql b/app/DB/db_mysql.sql
index 8a27eab753e2e26b8d56b7db0c6e60ebbe7e0b49..a3a14f5936fccd16c4b98efb83f75ddc93f5c64b 100644 (file)
--- 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,
   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_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;
       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,
   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),
   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)
       REFERENCES album (id) MATCH SIMPLE
       ON UPDATE CASCADE ON DELETE CASCADE,
   CONSTRAINT photo_format_fkey FOREIGN KEY (format)