/apps/learn/migrations/00.00.03_board.php

 1<?php
 2class Migration_00_00_03 extends Migration
 3{
 4	function up()
 5	{
 6		$sql = "create table board (id serial primary key, name text unique)";
 7		SqlAlterSchema($sql);
 8		SqlInsertRow("insert into board (name) values (:name)", array('name' => 'default'));
 9		
10		$sql = "create table board_cell (
11					id serial primary key, 
12					board_id int4 references board,
13					row_num int2 not null,
14					col_num int2 not null,
15					letter varchar(1) not null
16				)";
17		SqlAlterSchema($sql);
18		
19	}
20	
21	function down()
22	{
23		SqlAlterSchema("drop table board_cell");
24		SqlAlterSchema("drop table board");
25	}
26}