Where are the SQL Statements

[hguiney (Hugh Guiney)]

http://www.yiiframework.com/doc/blog/1.1/en/start.design:

Complete SQL statements corresponding to the above ER diagram may be found in the blog demo. In our Yii installation, they are in the file /wwwroot/yii/demos/blog/protected/data/schema.sqlite.sql.

There’s none there. Only a bunch of nonsense posts.

[tri (tri - Tommy Riboe)]

You will find it in your Yii installation, in the subdirectory demos/blog/protected/data/.

BTW welcome to the forum.

/Tommy

[dave101ua]

I have same question, starting to learh yii today

You will find it in your Yii installation, in the subdirectory demos/blog/protected/data/.

BTW welcome to the forum.

/Tommy

There I can find sql statement for users table only, but there should be more: posts, comments, tags…

[abennouna]

Where are you looking exactly?

I’ve just checked in the unzipped yii-1.1.10.r3566 (version 1.10) and I find all tables in [font=“Courier New”]schema.mysql.sql[/font] or [font=“Courier New”]schema.sqlite.sql[/font]

[dave101ua]

strange, I’ve uploaded framework again and now I see all sql statements there, thank you.