Akelos チュートリアル 4

Akelos チュートリアル 3 で設定した内容でテーブルを生成する。
成功すれば、下記のステータスが表示される。

% ./script/migrate Booklink install
Upgrading-----
(mysqlt): SET AUTOCOMMIT=0
-----
-----
(mysqlt): BEGIN
-----
-----
(mysqlt): SHOW COLUMNS FROM books
-----
1146: Table 'booklink_dev.books' doesn't exist
adodb_mysqlt._execute(SHOW COLUMNS FROM books, false)% line  855, file: /Users/littlebuhha/akelos/vendor/adodb/adodb.inc.php
adodb_mysqlt.execute(SHOW COLUMNS FROM books)% line  394, file: /Users/littlebuhha/akelos/vendor/adodb/drivers/adodb-mysql.inc.php
adodb_mysqlt.metacolumns(books, true, false)% line  203, file: /Users/littlebuhha/akelos/vendor/adodb/adodb-datadict.inc.php
adodb2_mysql.metacolumns(books)% line  725, file: /Users/littlebuhha/akelos/vendor/adodb/adodb-datadict.inc.php
adodb2_mysql.changetablesql(books, id I NOTNULL AUTO KEY,
title C(32) NOTNULL,
description C(255),
author_id I ,
published_on D,
updated_at T,
created_at T, Array[1])% line  332, file: /Users/littlebuhha/akelos/lib/AkInstaller.php
-----
(mysqlt): CREATE TABLE books (
id                       INTEGER NOT NULL AUTO_INCREMENT,
title                    VARCHAR(32) NOT NULL,
description              VARCHAR(255),
author_id                INTEGER,
published_on             DATE,
updated_at               DATETIME,
created_at               DATETIME,
                 PRIMARY KEY (id)
)TYPE=InnoDB
-----
-----
(mysqlt): ALTER TABLE books ADD  INDEX idx_books_author_id  (author_id)
-----
-----
(mysqlt): SHOW COLUMNS FROM authors
-----
1146: Table 'booklink_dev.authors' doesn't exist
adodb_mysqlt._execute(SHOW COLUMNS FROM authors, false)% line  855, file: /Users/littlebuhha/akelos/vendor/adodb/adodb.inc.php
adodb_mysqlt.execute(SHOW COLUMNS FROM authors)% line  394, file: /Users/littlebuhha/akelos/vendor/adodb/drivers/adodb-mysql.inc.php
adodb_mysqlt.metacolumns(authors, true, false)% line  203, file: /Users/littlebuhha/akelos/vendor/adodb/adodb-datadict.inc.php
adodb2_mysql.metacolumns(authors)% line  725, file: /Users/littlebuhha/akelos/vendor/adodb/adodb-datadict.inc.php
adodb2_mysql.changetablesql(authors, id I NOTNULL AUTO KEY,
name C(64) NOTNULL,
updated_at T,
created_at T, Array[1])% line  332, file: /Users/littlebuhha/akelos/lib/AkInstaller.php
-----
(mysqlt): CREATE TABLE authors (
id                       INTEGER NOT NULL AUTO_INCREMENT,
name                     VARCHAR(64) NOT NULL,
updated_at               DATETIME,
created_at               DATETIME,
                 PRIMARY KEY (id)
)TYPE=InnoDB
-----
-----
(mysqlt): COMMIT
-----
-----
(mysqlt): SET AUTOCOMMIT=1
-----
Smart Commit occurred

%

生成されたテーブルを確認してみる。

% /Applications/xampp/xamppfiles/bin/mysql -u littlbuddha -h localhost -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 62
Server version: 5.0.51a Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> desc booklink_dev.books;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| id           | int(11)      | NO   | PRI | NULL    | auto_increment | 
| title        | varchar(32)  | NO   |     | NULL    |                | 
| description  | varchar(255) | YES  |     | NULL    |                | 
| author_id    | int(11)      | YES  | MUL | NULL    |                | 
| published_on | date         | YES  |     | NULL    |                | 
| updated_at   | datetime     | YES  |     | NULL    |                | 
| created_at   | datetime     | YES  |     | NULL    |                | 
+--------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

mysql> desc booklink_dev.authors;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id         | int(11)     | NO   | PRI | NULL    | auto_increment | 
| name       | varchar(64) | NO   |     | NULL    |                | 
| updated_at | datetime    | YES  |     | NULL    |                | 
| created_at | datetime    | YES  |     | NULL    |                | 
+------------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql> exit;
Bye
%