A few fixes on upgrade scripts.

[platal.git] / upgrade / 1.0.1 / 12_profiles.sql

diff --git a/upgrade/1.0.1/12_profiles.sql b/upgrade/1.0.1/12_profiles.sql
index 4a792f0..9a33797 100644 (file)
--- a/upgrade/1.0.1/12_profiles.sql
+++ b/upgrade/1.0.1/12_profiles.sql
@@ -7,7 +7,7 @@ CREATE TABLE profile_modifications (
   oldText TEXT NOT NULL,
   newText TEXT NOT NULL,
   pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private',
-  PRIMARY KEY(pid, uid, field)
+  PRIMARY KEY(pid, uid, field),
   FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE,
   FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB, CHARSET=utf8;