Changeset 1893 in ExiteCMS

Timestamp:

10/20/08 08:51:26 (3 years ago)

Author:

hverton

Message:

updated the module_installer to create utf8 tables

File:

• modules/common/shoutbox_panel/php-files/modules/shoutbox_panel/module_installer.php (modified) (4 diffs)

modules/common/shoutbox_panel/php-files/modules/shoutbox_panel/module_installer.php

@@ -17 +17 @@
 $mod_title = "Shoutbox";
 $mod_description = "Shoutbox side panel";
-$mod_version = "1.1.0";
+$mod_version = "1.1.1";
 $mod_developer = "WanWizard";
 $mod_email = "wanwizard@gmail.com";
@@ -376 +376 @@
 
 $mod_install_cmds = array();
+$mod_install_cmds[] = array('type' => 'db', 'value' => "CREATE TABLE ##PREFIX##shoutbox (
+  shout_id smallint(5) unsigned NOT NULL auto_increment,
+  shout_name varchar(50) NOT NULL default '',
+  shout_message varchar(200) NOT NULL default '',
+  shout_datestamp int(10) unsigned NOT NULL default '0',
+  shout_ip varchar(20) NOT NULL default '0.0.0.0',
+  PRIMARY KEY  (shout_id)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8");
 
 /*---------------------------------------------------+
@@ -382 +390 @@
 
 $mod_uninstall_cmds = array();
+$mod_uninstall_cmds[] = array('type' => 'db', 'value' => "DROP TABLE ##PREFIX##shoutbox");
 
 /*---------------------------------------------------+
@@ -398 +407 @@
             case "1.1.0":
                 // upgrade to ExiteCMS v7.1. no upgrade actions for this release
+            case "1.1.1":
+                // upgrade to ExiteCMS v7.2. no upgrade actions for this release
+                $result = dbquery"CREATE TABLE IF NOT EXISTS ".$db_prefix."shoutbox (
+                        shout_id smallint(5) unsigned NOT NULL auto_increment,
+                        shout_name varchar(50) NOT NULL default '',
+                        shout_message varchar(200) NOT NULL default '',
+                        shout_datestamp int(10) unsigned NOT NULL default '0',
+                        shout_ip varchar(20) NOT NULL default '0.0.0.0',
+                        PRIMARY KEY  (shout_id)
+                    ) ENGINE=MyISAM DEFAULT CHARSET=utf8");
             default:
                 // do this at every upgrade