Example #1
0
 /**
  * @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);
 }