mambax7 / smartobject

    // db migrate version = 3

    $newDbVersion = 3;

    if ($dbVersion < $newDbVersion) {

        echo 'Database migrate to version ' . $newDbVersion . '<br>';

        // Create table smartobject_customtag

        $table = new XoopsModules\Smartobject\DbTable('smartobject_customtag');

        if (!$table->exists()) {

            $table->setStructure('

              `customtagid` int(11) NOT NULL auto_increment,

              `name` VARCHAR(255) NOT NULL,

              `description` TEXT NOT NULL,

              `content` TEXT NOT NULL,

              `language` TEXT NOT NULL,

              PRIMARY KEY  (`customtagid`)

            ');

        }

        if (!$dbupdater->updateTable($table)) {

            /**

             * @todo trap the errors

             */

        }

    }

    // db migrate version = 4

    $newDbVersion = 4;

    // db migrate version = 4

    $newDbVersion = 4;

    if ($dbVersion < $newDbVersion) {

        echo 'Database migrate to version ' . $newDbVersion . '<br>';

        // Create table smartobject_currency

        $table = new XoopsModules\Smartobject\DbTable('smartobject_currency');

        if (!$table->exists()) {

            $table->setStructure('

              `currencyid` int(11) NOT NULL auto_increment,

              `iso4217` VARCHAR(5) NOT NULL,

              `name` VARCHAR(255) NOT NULL,

              `symbol`  VARCHAR(1) NOT NULL,

              `rate` float NOT NULL,

              `default_currency` int(1) NOT NULL,

              PRIMARY KEY  (`currencyid`)

            ');

        }

        if (!$dbupdater->updateTable($table)) {

            /**

             * @todo trap the errors

             */

        }

    }

    // db migrate version = 6

    $newDbVersion = 6;