how can I get askbot's database ,the detail of tables?

Question

asked 2012-04-03 08:30:55 -0500

ticktack
1 ● 1 ● 1

I want to get the tables sql script.how to get it???

Answer 1

2

answered 2012-04-03 15:54:57 -0500

This is database specific. You can log in to the db shell by typing:

python manage.py dbshell

Or log in to the database directly via an appropriate client.

then in mysql

show tables;

in sqlite

.tables

in postgres

\d

Comments

I haven't IDE,can you gave me the sql script of mysql version by email? email address is yfq2010@gmail.com ,thanks you very much.

ticktack ( 2012-04-03 20:16:34 -0500 )edit

All the commands are to be typed into the shell, no IDE needed. You can also run command python manage.py sqldump

Evgeny ( 2012-04-05 14:34:08 -0500 )edit