Demos · Guide · Class Reference · Wiki · Extensions · Live Chat

Yii Framework Forum: Where are the SQL Statements - Yii Framework Forum

Jump to content

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

Where are the SQL Statements you promised me SQL statements Rate Topic:

#1 Hugh Guiney

Newbie

Group: Members
Posts: 1
Joined: 19-July 11

Posted 19 July 2011 - 05:37 PM

http://www.yiiframew...en/start.design:

Quote

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.

#2 tri

Elite Member

Group: Moderators
Posts: 1,628
Joined: 20-November 08
Location:Stockholm, Sweden

Posted 19 July 2011 - 05:45 PM

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

BTW welcome to the forum.

/Tommy

Don't forget to read The Definitive Guide to Yii (en) (sv) | The class reference has the details

#3 dave101ua

Newbie

Group: Members
Posts: 17
Joined: 23-April 12

Posted 23 April 2012 - 10:27 AM

I have same question, starting to learh yii today

tri, on 19 July 2011 - 05:45 PM, said:

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...

Yii newbie

#4 bennouna

Master Member

Group: Members
Posts: 1,115
Joined: 05-January 12
Location:Morocco

Posted 23 April 2012 - 10:40 AM

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 schema.mysql.sql or schema.sqlite.sql

http://fb.com/abdelaziz.bennouna.94
http://linkedin.com/...view?id=1678246