yii_framework/demos/phonebook/protected/data/schema.sql

CREATE TABLE Contact
(
	id INTEGER NOT NULL PRIMARY KEY,
	name VARCHAR(128) NOT NULL,
	phone VARCHAR(64) NOT NULL
);