zabbix 2.0 database partitioning script diff

173a174,176
> CONSTRAINT_TABLES="acknowledges alerts auditlog service_alarms auditlog_details"
> CONSTRAINTS="c_acknowledges_1/c_acknowledges_2 c_alerts_1/c_alerts_2/c_alerts_3/c_alerts_4 c_auditlog_1 c_service_alarms_1 c_auditlog_details_1"
>
174a178,186
>
> cnt=0
> for i in $CONSTRAINT_TABLES; do
>       cnt=$(($cnt+1))
>       for constraint in $(echo $CONSTRAINTS |cut -f$cnt -d" " |awk -F/ '{for (i=1; i <= NF; i++) {if ($i != "") {print $i}}}'); do
>               echo "ALTER TABLE $i DROP FOREIGN KEY $constraint;" >>$SQL
>       done
> done
>
184d195
<                       echo "ALTER TABLE $i DROP PRIMARY KEY ;" >>$SQL
186c197
<                       echo "ALTER TABLE $i ADD KEY ${i}id ($id);" >>$SQL
---
>                       echo "ALTER TABLE $i DROP PRIMARY KEY, ADD KEY ${i}id ($id);" >>$SQL
191d201
<                       echo "ALTER TABLE $i DROP PRIMARY KEY ;" >>$SQL
193c203
<                       echo "ALTER TABLE $i ADD KEY ${i}id ($id);" >>$SQL
---
>                       echo "ALTER TABLE $i DROP PRIMARY KEY, ADD KEY ${i}id ($id);" >>$SQL
197d206
<                       echo "ALTER TABLE $i DROP PRIMARY KEY;" >>$SQL
199c208
<                       echo "ALTER TABLE $i ADD KEY ${i}id ($id);" >>$SQL
---
>                       echo "ALTER TABLE $i DROP PRIMARY KEY, ADD KEY ${i}id ($id);" >>$SQL