public function up()
{
$tableOptions = null;
if ($this->db->driverName === 'mysql') {
// http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
}
$this->createTable(Book::tableName(), ['id' => $this->primaryKey(), 'user_id' => $this->integer(), 'name' => $this->string(32)->notNull(), 'preview' => $this->string(255)->notNull(), 'date' => $this->integer(), 'created_at' => $this->integer(), 'updated_at' => $this->integer()], $tableOptions);
$this->addForeignKey('fk_book', Book::tableName(), 'user_id', User::tableName(), 'id', 'CASCADE', 'RESTRICT');
}
public function up()
{
$tableOptions = null;
if ($this->db->driverName === 'mysql') {
// http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
}
$this->createTable(UserProfile::tableName(), ['user_id' => $this->primaryKey(), 'phone' => $this->string(10), 'site' => $this->string(255), 'description' => $this->string(2048), 'birthday' => $this->date()], $tableOptions);
$this->addForeignKey('fk_profile_user', UserProfile::tableName(), 'user_id', User::tableName(), 'id', 'CASCADE', 'RESTRICT');
}
public function up()
{
$tableOptions = null;
if ($this->db->driverName === 'mysql') {
// http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
}
$this->createTable(UserAuth::tableName(), ['id' => $this->primaryKey(), 'user_id' => $this->integer(11)->notNull(), 'source' => $this->string(255)->notNull(), 'source_id' => $this->string(255)->notNull()], $tableOptions);
$this->addForeignKey('fk-auth-user_id-user-id', UserAuth::tableName(), 'user_id', User::tableName(), 'id', 'CASCADE', 'CASCADE');
}
public function up()
{
$authManager = $this->getAuthManager();
$this->db = $authManager->db;
$tableOptions = null;
if ($this->db->driverName === 'mysql') {
// http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
}
$this->createTable($authManager->ruleTable, ['name' => $this->string(64)->notNull(), 'data' => $this->text(), 'created_at' => $this->integer(), 'updated_at' => $this->integer(), 'PRIMARY KEY (name)'], $tableOptions);
$this->createTable($authManager->itemTable, ['name' => $this->string(64)->notNull(), 'type' => $this->integer()->notNull(), 'description' => $this->text(), 'rule_name' => $this->string(64), 'data' => $this->text(), 'created_at' => $this->integer(), 'updated_at' => $this->integer(), 'PRIMARY KEY (name)', 'FOREIGN KEY (rule_name) REFERENCES ' . $authManager->ruleTable . ' (name) ON DELETE SET NULL ON UPDATE CASCADE'], $tableOptions);
$this->createIndex('idx-auth_item-type', $authManager->itemTable, 'type');
$this->createTable($authManager->itemChildTable, ['parent' => $this->string(64)->notNull(), 'child' => $this->string(64)->notNull(), 'PRIMARY KEY (parent, child)', 'FOREIGN KEY (parent) REFERENCES ' . $authManager->itemTable . ' (name) ON DELETE CASCADE ON UPDATE CASCADE', 'FOREIGN KEY (child) REFERENCES ' . $authManager->itemTable . ' (name) ON DELETE CASCADE ON UPDATE CASCADE'], $tableOptions);
$this->createTable($authManager->assignmentTable, ['item_name' => $this->string(64)->notNull(), 'user_id' => $this->integer(11)->notNull(), 'created_at' => $this->integer(), 'PRIMARY KEY (item_name, user_id)', 'FOREIGN KEY (item_name) REFERENCES ' . $authManager->itemTable . ' (name) ON DELETE CASCADE ON UPDATE CASCADE'], $tableOptions);
$this->addForeignKey('fk_auth_assignment_user', $authManager->assignmentTable, 'user_id', User::tableName(), 'id', 'CASCADE', 'RESTRICT');
}
public function down()
{
$this->dropTable(User::tableName());
}
