PHP Schema::create_table Exemples

Exemple #1

Fichier : migrations.php Projet : nonconforme/ci-chat-1

 public function install()
 {
     $this->load->database();
     $this->load->library('schema');
     $table_name = 'messages';
     $query = $this->db->query("SHOW TABLES LIKE '{$table_name}'");
     if ($query->num_rows > 0) {
         exit("Database tables already exist.\n");
     } else {
         Schema::create_table($table_name, function ($table) {
             $table->auto_increment_integer('id');
             $table->string('author', 50);
             $table->text('message');
             $table->datetime('created_at');
             $table->key('created_at');
         });
         print "Database tables were created successfully.\n";
     }
 }

Exemple #2

Fichier : Schema_test.php Projet : fagray/codeigniter-schema

 public function test_create_table_52()
 {
     $table = Schema::create_table('name', FALSE);
     $this->assert_class($table, 'Schema_Table_Definition');
 }