test/fixtures/app/installers/protected_person_installer.php

   1 <?php
   2
   3 class ProtectedPersonInstaller extends AkInstaller
   4 {
   5     function up_1()
   6     {
   7         $this->createTable('protected_people','
   8           id,
   9           name string(32) not null,
  10           birthday datetime,
  11           is_active boolean not null default 1,
  12           credit_points int default 1000,
  13           created_by int default null,
  14           created_at,
  15           updated_at
  16         ');
  17     }
  18
  19     function down_1()
  20     {
  21         $this->dropTable('protected_people', array('sequence'=>true));
  22     }
  23 }
  24
  25 ?>