12,673
回編集
差分
ナビゲーションに移動
検索に移動
$table = 'users';
\DBUtil::create_table($table, array(
'id' => array('type' => 'int', 'constraint' => 11, 'auto_increment' => true),
'username' => array('type' => 'varchar', 'constraint' => 50),
'password' => array('type' => 'varchar', 'constraint' => 255),
'group_id' => array('type' => 'int', 'constraint' => 11, 'default' => 1),
'email' => array('type' => 'varchar', 'constraint' => 255),
'last_login' => array('type' => 'varchar', 'constraint' => 25),
'previous_login' => array('type' => 'varchar', 'constraint' => 25, 'default' => 0),
'login_hash' => array('type' => 'varchar', 'constraint' => 255),
'user_id' => array('type' => 'int', 'constraint' => 11, 'default' => 0),
'created_at' => array('type' => 'int', 'constraint' => 11, 'default' => 0),
'updated_at' => array('type' => 'int', 'constraint' => 11, 'default' => 0),
), array('id'));
// add a unique index on username and email $table = \DBUtilConfig::create_index($table, arrayget('username', 'email'), 'usernamesimpleauth.table_name', 'UNIQUEusers');
→Databaseテーブルの作成
<pre>
public function action_createusertable() {
// only do this if it doesn't exist yet if ( ! \DBUtil::table_exists($table)) { // table users \DBUtil::create_table($table, array( 'id' => array('type' => 'int', 'constraint' => 11, 'auto_increment' => true), 'username' => array('type' => 'varchar', 'constraint' => 50), 'password' => array('type' => 'varchar', 'constraint' => 255), 'group' => array('type' => 'int', 'constraint' => 11, 'default' => 1), 'email' => array('type' => 'varchar', 'constraint' => 255), 'last_login' => array('type' => 'varchar', 'constraint' => 25), 'login_hash' => array('type' => 'varchar', 'constraint' => 255), 'profile_fields' => array('type' => 'text'), 'created_at' => array('type' => 'int', 'constraint' => 11, 'default' => 0), 'updated_at' => array('type' => 'int', 'constraint' => 11, 'default' => 0), ), array('id')); // add a unique index on username and email \DBUtil::create_index($table, array('username', 'email'), 'username', 'UNIQUE'); } return "Created${table}";
}
</pre>
© 2006 矢木浩人
