public static function activate($id, $pluginType) { try { Am_Di::getInstance()->db->query("CREATE TABLE ?_notification (\n notification_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\n content varchar(255),\n url varchar(255),\n is_blank TINYINT NOT NULL,\n begin date NULL,\n expire date NULL,\n is_disabled TINYINT NOT NULL\n ) CHARACTER SET utf8 COLLATE utf8_general_ci"); } catch (Am_Exception_Db $e) { } try { Am_Di::getInstance()->db->query("CREATE TABLE ?_notification_access (\n notification_access_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\n notification_id INT NOT NULL,\n fn enum('product_id','product_category_id','free','user_id'),\n id INT NULL\n ) CHARACTER SET utf8 COLLATE utf8_general_ci"); } catch (Am_Exception_Db $e) { } try { Am_Di::getInstance()->db->query("ALTER TABLE ?_notification\n ADD `limit` TINYINT,\n ADD is_custom TINYINT NOT NULL"); } catch (Am_Exception_Db $e) { } try { Am_Di::getInstance()->db->query("ALTER TABLE ?_notification_access\n MODIFY fn enum('product_id','product_category_id','free','user_id', 'user_group_id')"); } catch (Am_Exception_Db $e) { } try { Am_Di::getInstance()->db->query("ALTER TABLE ?_notification\n MODIFY content TEXT"); } catch (Am_Exception_Db $e) { } try { Am_Di::getInstance()->db->query("ALTER TABLE ?_notification\n ADD sort_order INT NOT NULL"); Am_Di::getInstance()->db->query("SET @i = 0"); Am_Di::getInstance()->db->query("UPDATE ?_notification SET sort_order=(@i:=@i+1) ORDER BY notification_id DESC"); } catch (Am_Exception_Db $e) { } try { Am_Di::getInstance()->db->query("CREATE TABLE IF NOT EXISTS ?_notification_click (\n notification_click_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,\n notification_id INT NOT NULL,\n user_id INT UNSIGNED NOT NULL,\n dattm date NOT NULL,\n INDEX notification_id (notification_id)\n ) CHARACTER SET utf8 COLLATE utf8_general_ci"); } catch (Am_Exception_Db $e) { //nop } return parent::activate($id, $pluginType); }
public static function activate($id, $pluginType) { try { Am_Di::getInstance()->db->query("CREATE TABLE ?_oto (\n oto_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\n comment varchar(255),\n conditions text,\n view mediumtext,\n product_id INT NOT NULL,\n coupon_id INT NULL,\n is_disabled TINYINT NOT NULL,\n bp_id INT\n ) CHARACTER SET utf8 COLLATE utf8_general_ci"); } catch (Am_Exception_Db $e) { } return parent::activate($id, $pluginType); }