2 function upgrade_do20() {
4 if (upgrade_checkinstall(20))
5 return "already installed";
10 $query = 'ALTER TABLE '.sql_table('item')
11 . " ADD ikarmaneg int(11) NOT NULL default '0'";
12 upgrade_query("Adding ikarmaneg column to items",$query);
14 // rename ikarma to ikarmapos
15 $query = 'ALTER TABLE '.sql_table('item')
16 . " CHANGE ikarma ikarmapos int(11) NOT NULL default '0'";
17 upgrade_query("Renaming ikarma column for items to ikarmapos",$query);
19 // drop key in actionlog
20 $query = 'ALTER TABLE '.sql_table('actionlog').' DROP PRIMARY KEY';
21 upgrade_query("Dropping primary key in actionlog table",$query);
23 // change cmail field length
24 $query = 'ALTER TABLE '.sql_table('comment').' CHANGE cmail cmail varchar(100) default NULL';
25 upgrade_query("changing max email/url length of guest comments to 100",$query);
27 // create default skin option
28 $skinid = SKIN::getIdFromName('default');
29 $query = 'INSERT INTO '.sql_table('config')." VALUES ('BaseSkin', '$skinid');";
30 upgrade_query("Adding setting BaseSkin",$query);
32 // add SkinsURL setting
34 $skinsurl = str_replace('/media/','/skins/',$CONF['MediaURL']);
35 $query = 'INSERT INTO '.sql_table('config')." VALUES ('SkinsURL', '".addslashes($skinsurl)."');";
36 upgrade_query("Adding setting SkinsURL",$query);
38 // add ActionURL setting
39 $actionurl = str_replace('/media/','/action.php',$CONF['MediaURL']);
40 $query = 'INSERT INTO '.sql_table('config')." VALUES ('ActionURL', '".addslashes($actionurl)."');";
41 upgrade_query("Adding setting ActionURL",$query);
43 // time offset can also be decimal (for half time zones like GMT+3:30)
44 upgrade_query('Changing time offset column type to decimal','ALTER TABLE '.sql_table('blog')." CHANGE btimeoffset btimeoffset DECIMAL( 3, 1 ) DEFAULT '0' NOT NULL");
46 // add sdincmode and sdincpref to skins
47 $query = 'ALTER TABLE '.sql_table('skin_desc')
48 . " ADD sdincmode varchar(10) NOT NULL default 'normal'";
49 upgrade_query('Adding IncludeMode property to skins',$query);
50 $query = 'ALTER TABLE '.sql_table('skin_desc')
51 . " ADD sdincpref varchar(50) NOT NULL default ''";
52 upgrade_query('Adding IncludePrefix property to skins',$query);
54 // add ballowpast option to nucleus_blog
55 $query = 'ALTER TABLE '.sql_table('blog')." ADD ballowpast tinyint(2) NOT NULL default '0'";
56 upgrade_query("Adding 'Allow posting to the past' option to blogs",$query);
59 $query = 'INSERT INTO '.sql_table('config')." VALUES ('URLMode', 'normal');";
60 upgrade_query("Adding setting URLMode",$query);
62 // add id to nucleus_plugin_option (allows for ordening)
63 $query = 'ALTER TABLE '.sql_table('plugin_option').' ADD oid int(11) NOT NULL auto_increment UNIQUE ';
64 upgrade_query("Adding id attribute to plugin options table",$query);