From 5894f968f624789316632806d2c39fa9856f194c Mon Sep 17 00:00:00 2001 From: MW Date: Fri, 7 Dec 2007 19:55:26 +0000 Subject: correctly add missing sequence quota_id_seq --- admin/upgrade_inc.php | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/admin/upgrade_inc.php b/admin/upgrade_inc.php index b21cdaf..87a6ba2 100644 --- a/admin/upgrade_inc.php +++ b/admin/upgrade_inc.php @@ -13,6 +13,12 @@ array( 'DATADICT' => array( 'tiki_quotas_group_map' => 'quotas_group_map', )), )), + +// query: create a quota_id_seq and bring the table up to date with the current max quota_id used in the quotas table - this basically for mysql +array( 'PHP' => ' + $query = $gBitDb->getOne("SELECT MAX(quota_id) FROM `'.BIT_DB_PREFIX.'quotas`"); + $tempId = $gBitDb->mDb->GenID("`'.BIT_DB_PREFIX.'quota_id_seq`", $query); +' ), ) ), -- cgit v1.3