| 1 |
<?php |
<?php |
| 2 |
// $Id: shoutbox.install,v 1.4 2008/03/07 10:42:40 snpower Exp $ |
// $Id: shoutbox.install,v 1.4.2.1 2008/07/10 08:56:11 disterics Exp $ |
| 3 |
|
|
| 4 |
/** |
/** |
| 5 |
* @file |
* @file |
| 58 |
} |
} |
| 59 |
|
|
| 60 |
/** |
/** |
| 61 |
* Update hook. |
* Update hook. |
| 62 |
* This update prepares the database for for |
* This update prepares the database for for |
| 63 |
* shoutbox 5.2.x |
* shoutbox 5.2.x |
| 64 |
* Removes the moderation table |
* Removes the moderation table |
| 65 |
* Drops the status column on the shoutbox table |
* Drops the status column on the shoutbox table |
| 72 |
switch ($GLOBALS['db_type']) { |
switch ($GLOBALS['db_type']) { |
| 73 |
case 'mysql': |
case 'mysql': |
| 74 |
case 'mysqli': |
case 'mysqli': |
| 75 |
case 'pgsql': |
case 'pgsql': |
| 76 |
$items[] = update_sql("DROP TABLE {shoutbox_moderation}"); |
$items[] = update_sql("DROP TABLE {shoutbox_moderation}"); |
| 77 |
$items[] = update_sql("ALTER TABLE {shoutbox} DROP status"); |
$items[] = update_sql("ALTER TABLE {shoutbox} DROP status"); |
| 78 |
$items[] = update_sql("ALTER TABLE {shoutbox} ADD COLUMN sid varchar(64) NOT NULL default ''"); |
$items[] = update_sql("ALTER TABLE {shoutbox} ADD COLUMN sid varchar(64) NOT NULL default ''"); |
| 82 |
} |
} |
| 83 |
return $items; |
return $items; |
| 84 |
} |
} |
| 85 |
|
|