/** * @param Table $table * @throws Exception */ public function create(Table $table) { //$t = new Table('catalog'); $table->setDefaultCharset(); $table->setEngine(); $table->setAutoIncrement(); $table->addField('id', 'INT', 11, false, true); $table->addField('pid', 'INT', 11); $table->addField('name', 'VARCHAR', 50); $table->addField('url', 'VARCHAR', 100); $table->addField('old_url', 'VARCHAR', 100); $table->addField('img', 'VARCHAR', 50); $table->addField('description', 'TEXT'); $table->addIndex('PRIMARY', 'id'); $table->addIndex('KEY', 'pid'); $table->addIndex('FULLTEXT', 'url', 'url_text_index'); $table->addIndex('FULLTEXT', 'old_url', 'old_url'); //$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB'; $sql = "CREATE TABLE IF NOT EXISTS `catalog` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `pid` int(11) NOT NULL,\n `name` varchar(50) NOT NULL,\n `url` varchar(100) NOT NULL,\n `old_url` varchar(100) NOT NULL,\n `img` varchar(50) NOT NULL,\n `description` text NOT NULL,\n PRIMARY KEY (`id`),\n KEY `pid` (`pid`),\n FULLTEXT KEY `url_text_index` (`url`),\n FULLTEXT KEY `old_url` (`old_url`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;"; $this->query($sql); }