public function testDropTable() { $q = new CreateTableQuery('points'); $q->column('x')->float(10, 2); $q->column('y')->float(10, 2); $this->assertQuery($q); $q = new DropTableQuery('points'); $q->drop('users'); $q->drop('books'); $q->ifExists(); $this->assertQuery($q); }
public function setUp() { parent::setUp(); $q = new DropTableQuery('users'); $q->ifExists(); $this->assertQuery($q); $q = new CreateTableQuery('users'); $q->column('id')->integer()->primary()->autoIncrement(); $q->column('first_name')->varchar(32); $q->column('last_name')->varchar(16); $q->column('age')->tinyint(3)->unsigned()->null(); $q->column('phone')->varchar(24)->null(); $q->column('email')->varchar(128)->notNull(); $q->column('confirmed')->boolean()->default(false); $q->column('types')->set('student', 'teacher'); $q->column('remark')->text(); $q->index(['first_name', 'last_name'])->name('username_idx'); $this->assertQuery($q); }