@@ 292-296 (lines=5) @@ | ||
289 | $oDB->addColumn("member_group_member", "site_srl", "number", 11, 0, true); |
|
290 | $oDB->addIndex("member_group_member", "idx_site_srl", "site_srl", false); |
|
291 | } |
|
292 | if(!$oDB->isColumnExists("member_group", "site_srl")) |
|
293 | { |
|
294 | $oDB->addColumn("member_group", "site_srl", "number", 11, 0, true); |
|
295 | $oDB->addIndex("member_group","idx_site_title", array("site_srl","title"),true); |
|
296 | } |
|
297 | if($oDB->isIndexExists("member_group","uni_member_group_title")) |
|
298 | { |
|
299 | $oDB->dropIndex("member_group","uni_member_group_title",true); |
|
@@ 303-308 (lines=6) @@ | ||
300 | } |
|
301 | ||
302 | // Add a column(list_order) to "member_group" table (05/18/2011) |
|
303 | if(!$oDB->isColumnExists("member_group", "list_order")) |
|
304 | { |
|
305 | $oDB->addColumn("member_group", "list_order", "number", 11, '', true); |
|
306 | $oDB->addIndex("member_group","idx_list_order", "list_order",false); |
|
307 | $output = executeQuery('member.updateAllMemberGroupListOrder'); |
|
308 | } |
|
309 | // Add a column for image_mark (02/14/2009) |
|
310 | if(!$oDB->isColumnExists("member_group", "image_mark")) |
|
311 | { |