Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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