Conversion from 1.4 schema, zero downtime
[lhc/web/wiklou.git] / maintenance / archives / patch-img_width.sql
1 -- Extra image metadata, added for 1.5
2
3 ALTER TABLE /*$wgDBprefix*/image ADD (
4 img_width int(5) NOT NULL default 0,
5 img_height int(5) NOT NULL default 0,
6 img_bits int(5) NOT NULL default 0,
7 img_type int(5) NOT NULL default -1
8 );
9
10 ALTER TABLE /*$wgDBprefix*/oldimage ADD (
11 oi_width int(5) NOT NULL default 0,
12 oi_height int(5) NOT NULL default 0,
13 oi_bits int(3) NOT NULL default 0,
14 oi_type int(3) NOT NULL default 0
15 );
16
17