- [Show page]
- [Old revisions]
- [[unknown link type]]
- []
Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
python:django [2014/12/10 11:51] vondra [South] |
python:django [2015/01/28 13:12] (current) vondra [Database settings] |
||
---|---|---|---|
Line 39: | Line 39: | ||
To start using south... | To start using south... | ||
- | - Make sure your django tables match your current database tables exactly - if you planned to add or remove columns, comment those out. | + | Make sure your django tables match your current database tables exactly - if you planned to add or remove columns, comment those out and run: |
- | - <code> | + | <code> |
./manage.py schemamigration myapp --initial name_of_migration | ./manage.py schemamigration myapp --initial name_of_migration | ||
./manage.py migrate myapp --fake | ./manage.py migrate myapp --fake | ||
</code> | </code> | ||
- | - Make changes to your django model | + | Make changes to your django model and then run: |
- | - <code> | + | <code> |
./manage.py schemamigration myapp --auto | ./manage.py schemamigration myapp --auto | ||
./manage.py migrate myapp | ./manage.py migrate myapp | ||
Line 61: | Line 61: | ||
</code> | </code> | ||
...put this on the beginning of the source file. | ...put this on the beginning of the source file. | ||
+ | |||
+ | |||
+ | ====Database settings==== | ||
+ | MyISAM storage: | ||
+ | <code> | ||
+ | mysql>>> ALTER TABLE search_ftext ENGINE = MyISAM; | ||
+ | </code> | ||
+ | |||
+ | Create fulltext index | ||
+ | |||
+ | <code> | ||
+ | mysql>>> ALTER TABLE search_ftext ADD FULLTEXT (text); | ||
+ | </code> | ||
+ | |||
+ | if Django keeps falling after editing in admin - convert table DjangoAdminLog to the same collation as other tables: | ||
+ | <code> | ||
+ | alter table auth_user_user_permissions convert to character set utf8 collate utf8_unicode_ci; | ||
+ | </code> |
python/django.1418208698.txt.gz · Last modified: 2014/12/10 11:51 by vondra