On 11/4/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Waylan is right, SQLite has few types but and you can put pretty much > anything in. Its sort of an interesting database. TIMESTAMP is what I > anticipated based on the model. I have used SQLObject in the past to > generate SQL for SQLite with TIMESTAMP so perhaps it was out of this > experience that I was suprised it was not generated from Django. > > How can time zone be included from my model?
Hey David, When Django outputs the CREATE TABLE statements, it looks at the database engine you're currently using. Since you ran django-admin.py with the sqllite database backend, it used sqlite syntax. If you change your database engine to postgresql, the CREATE TABLE statements will use postgresql-specific column types. Hope that clears things up! > Also. I was just reading about install and found something about > including .sql files in a sql folder in the project directory. I guess > the alter table statement could be included here. I am assuming the > sql from the install gets loaded after the tables are created. Yes, the SQL from the install gets loaded after the tables are created. Adrian -- Adrian Holovaty holovaty.com | djangoproject.com | chicagocrime.org
