Statistics
| Branch: | Tag: | Revision:

root / README.upgrade @ fe243425

History | View | Annotate | Download (1000 Bytes)

1 4a1c29ea Antony Chazapis
UPGRADE
2 4a1c29ea Antony Chazapis
=======
3 4a1c29ea Antony Chazapis
4 4a1c29ea Antony Chazapis
0.7.9 -> 0.7.10
5 4a1c29ea Antony Chazapis
---------------
6 c08d0b66 Antony Chazapis
* Update settings.py (BACKEND*, SERVICE_NAME, *_EMAIL, *_TARGET, IM_*)
7 c95d1471 Antony Chazapis
* Update 'attributes' table in mysql (backend):
8 4a1c29ea Antony Chazapis
    
9 c95d1471 Antony Chazapis
    mysql> update attributes set `key`='ETag' where `key`='hash';
10 c95d1471 Antony Chazapis
11 c95d1471 Antony Chazapis
* Upgrade 'im_user' table (im app):
12 c95d1471 Antony Chazapis
    
13 c95d1471 Antony Chazapis
    ALTER TABLE im_user ADD COLUMN 'password' VARCHAR(255);
14 4a1c29ea Antony Chazapis
15 0c581627 Sofia Papagiannaki
0.7.10 -> 0.7.11
16 0c581627 Sofia Papagiannaki
----------------
17 7f5c469e Antony Chazapis
* Upgrade 'public' table in mysql (backend):
18 7f5c469e Antony Chazapis
	* Run: mysqldump pithosdb public > public-table.sql
19 7f5c469e Antony Chazapis
	* mysql> drop table public;
20 7f5c469e Antony Chazapis
	* Update the codebase and run the server so the new public table is created
21 7f5c469e Antony Chazapis
	* From the sql dump above, take the row:
22 7f5c469e Antony Chazapis
	    
23 7f5c469e Antony Chazapis
		INSERT INTO `public` VALUES (...);
24 7f5c469e Antony Chazapis
      
25 13797bc1 Antony Chazapis
          Rewrite as:
26 7f5c469e Antony Chazapis
	    
27 7f5c469e Antony Chazapis
		INSERT INTO `public`(`path`) VALUES (...);
28 7f5c469e Antony Chazapis
	  
29 7f5c469e Antony Chazapis
	  And execute in the database
30 ebb54b0b Antony Chazapis
* Add 'south', remove 'pithos.public' in INSTALLED_APPS in settings.py
31 0f8ffac4 Antony Chazapis
* Install python-django-south
32 0f8ffac4 Antony Chazapis
* Setup south:
33 0c581627 Sofia Papagiannaki
    python manage.py syncdb
34 0c581627 Sofia Papagiannaki
    python manage.py migrate im 0001 --fake
35 0c581627 Sofia Papagiannaki
    python manage.py migrate im