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 %