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