<?php
-define( 'UPDATE_VERSION' , 1147 );
+define( 'UPDATE_VERSION' , 1149 );
/**
*
return UPDATE_SUCCESS ;
}
-/*
-function update_xxxx() {
+function update_1147() {
$r1 = q("ALTER TABLE `sign` ALTER `iid` SET DEFAULT '0'");
$r2 = q("ALTER TABLE `sign` ADD `retract_iid` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `iid`");
$r3 = q("ALTER TABLE `sign` ADD INDEX ( `retract_iid` )");
return UPDATE_FAILED ;
return UPDATE_SUCCESS ;
}
-*/
-// dump DB schema: mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql
+function update_1148() {
+ $r = q("ALTER TABLE photo ADD type CHAR(128) NOT NULL DEFAULT 'image/jpeg' AFTER filename");
+ if (!$r)
+ return UPDATE_FAILED;
+ return UPDATE_SUCCESS;
+}