| | 26 | // New description on Ring Groups |
|---|
| | 27 | $sql = "SELECT description FROM ringgroups"; |
|---|
| | 28 | $check = $db->getRow($sql, DB_FETCHMODE_ASSOC); |
|---|
| | 29 | if(DB::IsError($check)) { |
|---|
| | 30 | // add new field |
|---|
| | 31 | $sql = "ALTER TABLE ringgroups ADD description VARCHAR( 35 ) NULL ;"; |
|---|
| | 32 | $result = $db->query($sql); |
|---|
| | 33 | if(DB::IsError($result)) { |
|---|
| | 34 | die($result->getDebugInfo()); |
|---|
| | 35 | } |
|---|
| | 36 | |
|---|
| | 37 | // update existing groups |
|---|
| | 38 | $sql = "UPDATE ringgroups SET description = CONCAT('Ring Group ', grpnum) WHERE description IS NULL ;"; |
|---|
| | 39 | $result = $db->query($sql); |
|---|
| | 40 | if(DB::IsError($result)) { |
|---|
| | 41 | die($result->getDebugInfo()); |
|---|
| | 42 | } |
|---|
| | 43 | |
|---|
| | 44 | // make new field required |
|---|
| | 45 | $sql = "ALTER TABLE `ringgroups` CHANGE `description` `description` VARCHAR( 35 ) NOT NULL ;"; |
|---|
| | 46 | $result = $db->query($sql); |
|---|
| | 47 | if(DB::IsError($result)) { |
|---|
| | 48 | die($result->getDebugInfo()); |
|---|
| | 49 | } |
|---|
| | 50 | } |
|---|
| | 51 | |
|---|
