protected function run1($stage)
{
$this->console->out('Creating table for announcements...');
$this->db->Execute("\n CREATE TABLE `{$this->tableAnnouncements}` (\n `id` int NOT NULL AUTO_INCREMENT,\n `account_id` int DEFAULT NULL COMMENT 'Identifier of Account',\n `created_by_id` int DEFAULT NULL COMMENT 'User who created an announcement',\n `created_by_email` varchar(100) NOT NULL COMMENT 'Email of the User who created an announcement',\n `added` datetime NOT NULL COMMENT 'Create timestamp',\n `title` varchar(100) NOT NULL,\n `msg` text NOT NULL COMMENT 'Raw content',\n PRIMARY KEY (`id`),\n KEY `idx_added` (`added`),\n CONSTRAINT `fk_12741abab84d`\n FOREIGN KEY (`created_by_id`) REFERENCES `account_users` (`id`)\n ON DELETE SET NULL,\n CONSTRAINT `fk_312de420e119`\n FOREIGN KEY (`account_id`) REFERENCES `clients` (`id`)\n ON DELETE CASCADE\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT 'User Announcements'\n ");
}
