示例#1
0
 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);
 }
示例#2
0
 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);
 }