<?php
$m = new waGroupModel();
try {
$m->query("SELECT icon FROM `wa_group` WHERE 0");
} catch (waDbException $e) {
$m->exec("ALTER TABLE `wa_group` ADD COLUMN `icon` VARCHAR(255) NULL DEFAULT NULL");
}
try {
$m->query("SELECT sort FROM `wa_group` WHERE 0");
} catch (waDbException $e) {
$m->exec("ALTER TABLE `wa_group` ADD COLUMN `sort` INT(11) NULL DEFAULT NULL");
}
$sort = 0;
$res = $m->query("SELECT * FROM `wa_group` ORDER BY name");
foreach ($res as $item) {
$m->updateById($item['id'], array('sort' => $sort++));
}
