Revision d4493d99
b/README.upgrade | ||
---|---|---|
43 | 43 |
0.8.1 -> 0.8.2 |
44 | 44 |
-------------- |
45 | 45 |
* Add the 'X-Forwarded-Protocol' header directive in the apache configuration, as described in the admin guide |
46 |
* Update 'attributes' table in mysql (backend): |
|
47 |
|
|
48 |
mysql> CREATE TABLE `attributes_new` ( |
|
49 |
`serial` int(11) NOT NULL, |
|
50 |
`domain` varchar(255) COLLATE utf8_bin NOT NULL, |
|
51 |
`key` varchar(255) COLLATE utf8_bin NOT NULL, |
|
52 |
`value` varchar(255) COLLATE utf8_bin DEFAULT NULL, |
|
53 |
PRIMARY KEY (`serial`,`domain`,`key`), |
|
54 |
CONSTRAINT FOREIGN KEY (`serial`) REFERENCES `versions` (`serial`) ON DELETE CASCADE ON UPDATE CASCADE |
|
55 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
56 |
mysql> insert into attributes_new select `serial`, 'pithos', `key`, `value` from attributes; |
|
57 |
mysql> drop table attributes; |
|
58 |
mysql> alter table attributes_new rename to attributes; |
Also available in: Unified diff