public function up()
{
$t = new STable();
$t->addColumn('content', 'text');
$t->addColumn('remind_at', 'datetime');
$this->createTable('reminders', $t);
}
/**
* Create the comments table
* @access public
* @return void
*/
public function up()
{
$t = new STable();
$t->add_primary_key('id');
$t->add_column('achievement_id', 'integer', array('null' => false));
$t->add_column('author_id', 'integer', array('null' => false));
$t->add_column('body', 'text', array('null' => false));
$t->add_column('created_on', 'datetime');
$t->add_column('updated_on', 'datetime');
$this->create_table('comments', $t);
}
/**
* Create the psessions table (Persistent sessions)
* @access public
* @return void
*/
public function up()
{
$t = new STable();
$t->add_primary_key('id');
$t->add_column('user_id', 'integer', array('null' => false));
$t->add_column('key', 'text', array('null' => false));
$t->add_column('created_on', 'datetime');
$t->add_column('updated_on', 'datetime');
$this->create_table('psessions', $t);
}
public function testRenameTable()
{
$t = new STable();
$t->addColumn('url', 'string');
SActiveRecord::connection()->createTable('bookmarks', $t);
SActiveRecord::connection()->renameTable('bookmarks', 'favoris');
$this->assertNothingThrown();
SActiveRecord::connection()->execute("INSERT INTO favoris (url) VALUES ('http://www.rubyonrails.org')");
$row = SActiveRecord::connection()->selectOne('SELECT url FROM favoris WHERE id=1');
$this->assertEqual('http://www.rubyonrails.org', $row['url']);
try {
SActiveRecord::connection()->dropTable('bookmarks');
} catch (Exception $e) {
}
try {
SActiveRecord::connection()->dropTable('favoris');
} catch (Exception $e) {
}
}
/**
* Create users and achievements tables
* @access public
* @return void
*/
public function up()
{
$t = new STable();
$t->add_primary_key('id');
$t->add_column('login', 'string', array('null' => false));
$t->add_column('password', 'string', array('null' => false));
$t->add_column('email', 'string', array('null' => false));
$t->add_column('active', 'boolean', array('null' => false, 'default' => 1));
$t->add_column('created_on', 'datetime');
$t->add_column('updated_on', 'datetime');
$this->create_table('users', $t);
$t = new STable();
$t->add_primary_key('id');
$t->add_column('title', 'string', array('null' => false));
$t->add_column('description', 'string', array('null' => false));
$t->add_column('image_id', 'string');
$t->add_column('state', 'integer', array('null' => false, 'default' => 0));
$t->add_column('reward', 'string', array('null' => false));
$t->add_column('creator_id', 'integer', array('null' => false));
$t->add_column('winner_id', 'integer');
$t->add_column('created_on', 'datetime');
$t->add_column('updated_on', 'datetime');
$this->create_table('achievements', $t);
$this->execute("ALTER TABLE `achievements` MODIFY `state` ENUM('unlocked','locked','expired') NOT NULL DEFAULT 'locked';");
}
