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 User is offline   Hugh Guiney 

  • Newbie
  • Yii
  • 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.
0

#2 User is offline   tri 

  • Elite Member
  • Yii
  • Group: Moderators
  • Posts: 1,651
  • 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
0

#3 User is offline   dave101ua 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 17
  • Joined: 23-April 12

Posted 23 April 2012 - 10:27 AM

I have same question, starting to learh yii today

View Posttri, 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
0

#4 User is offline   bennouna 

  • Master Member
  • PipPipPipPip
  • Yii
  • Group: Members
  • Posts: 1,168
  • 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
0

#5 User is offline   dave101ua 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 17
  • Joined: 23-April 12

Posted 24 April 2012 - 01:54 AM

strange, I've uploaded framework again and now I see all sql statements there, thank you.
Yii newbie
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users