extension.driver.php

<?php

class Extension_UniqueCheckboxField extends Extension
{

    public function install()
    {
        return Symphony::Database()->query("
            CREATE TABLE IF NOT EXISTS `tbl_fields_uniquecheckbox` (
                `id` int(11) unsigned NOT NULL auto_increment,
                `field_id` int(11) unsigned NOT NULL,
                `default_state` enum('on', 'off') NOT NULL DEFAULT 'on',
                `unique_entries` int(11) unsigned NOT NULL DEFAULT 1,
                `unique_steal` enum('on', 'off') NOT NULL DEFAULT 'on',
                PRIMARY KEY (`id`),
                KEY `field_id` (`field_id`)
            ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
        ");
    }

    public function uninstall()
    {
        Symphony::Database()->query("DROP TABLE `tbl_fields_uniquecheckbox`");
    }

    public function update($previousVersion = false)
    {
        if (version_compare($previousVersion, '1.3', '<'))
        {
            try{
                Symphony::Database()->query("ALTER TABLE `tbl_fields_uniquecheckbox` DROP `description`");
            }
            catch(Exception $e){
                // Discard
            }
        }
    }
}