[pLog-svn] r4433 - plog/trunk/install

[oscar at devel.lifetype.net]

Author: oscar
Date: 2006-12-25 14:30:00 +0000 (Mon, 25 Dec 2006)
New Revision: 4433

Modified:
   plog/trunk/install/dbschemas.properties.php
Log:
I forgot about this, it's a temporary table so that wizard.php can transform the old permissions in LT 1.1 to the new ones in LT 1.2.


Modified: plog/trunk/install/dbschemas.properties.php
===================================================================
--- plog/trunk/install/dbschemas.properties.php	2006-12-25 14:28:42 UTC (rev 4432)
+++ plog/trunk/install/dbschemas.properties.php	2006-12-25 14:30:00 UTC (rev 4433)
@@ -183,6 +183,19 @@
 ";
 $Tables["users_permissions"]["options"] = "TYPE=MyISAM";
 
+//
+// temporary table only used during the upgrade process, will be dropped at the end of it
+//
+$Tables["tmp_users_permissions"]["schema"] = "
+  id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
+  user_id I(10) UNSIGNED NOTNULL DEFAULT '0',
+  blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
+  permission_id I(10) UNSIGNED NOTNULL DEFAULT '0',
+  INDEX blog_id (blog_id),
+  INDEX user_id_permission_id (user_id,permission_id)
+";
+$Tables["users_permissions"]["options"] = "TYPE=MyISAM";
+
 $Tables["config"]["schema"] = "
    config_key C(255) NOTNULL DEFAULT '' PRIMARY,
    config_value TEXT NOTNULL,