PHP pdo_indexexists Examples

Example #1

File: upgrade.php Project: alextiannus/wormwood_wechat

<?php

if (!pdo_indexexists('scratchcard_reply', 'idx_rid')) {
    $sql = "ALTER TABLE " . tablename('scratchcard_reply') . " ADD INDEX `idx_rid` ( `rid` );";
    pdo_query($sql);
}
if (!pdo_indexexists('scratchcard_winner', 'idx_createtime_fromuser')) {
    $sql = "ALTER TABLE " . tablename('scratchcard_winner') . " ADD INDEX `idx_createtime_fromuser` ( `createtime` , `from_user` ), ADD INDEX `idx_fromuser_rid` (`from_user`,`rid`) ";
    pdo_query($sql);
}
if (!pdo_fieldexists('scratchcard_reply', 'background')) {
    pdo_query("ALTER TABLE " . tablename('scratchcard_reply') . " ADD `background` VARCHAR(255) NOT NULL DEFAULT '' ;");
}
if (pdo_fieldexists('scratchcard_award', 'activation_code')) {
    pdo_query("ALTER TABLE " . tablename('scratchcard_award') . " CHANGE `activation_code` `activation_code` text;");
}

Example #2

File: upgrade.php Project: eduNeusoft/weixin

}
if (!pdo_fieldexists('shake_reply', 'speedandroid')) {
    pdo_query("ALTER TABLE " . tablename('shake_reply') . " ADD `speedandroid` INT(10) UNSIGNED NOT NULL DEFAULT '8000' AFTER `speed`;");
}
if (!pdo_fieldexists('shake_reply', 'qrcode')) {
    pdo_query("ALTER TABLE " . tablename('shake_reply') . " ADD `qrcode` varchar(255) NOT NULL AFTER `cover`;");
}
if (!pdo_fieldexists('shake_reply', 'maxjoin')) {
    pdo_query("ALTER TABLE " . tablename('shake_reply') . " ADD `maxjoin` int(10) unsigned NOT NULL AFTER `maxwinner`;");
}
if (!pdo_fieldexists('shake_reply', 'joinprobability')) {
    pdo_query("ALTER TABLE " . tablename('shake_reply') . " ADD `joinprobability` int(10) unsigned NOT NULL AFTER `maxjoin`;");
}
if (!pdo_fieldexists('shake_member', 'status')) {
    pdo_query("ALTER TABLE " . tablename('shake_member') . " ADD `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0为不可摇奖，1为可摇奖' AFTER `lastupdate`;");
}
if (!pdo_indexexists('shake_member', 'createtime')) {
    pdo_query("ALTER TABLE " . tablename('shake_member') . " ADD KEY `createtime` (`createtime`);");
}
if (!pdo_fieldexists('shake_reply', 'speedandroid')) {
    pdo_query("ALTER TABLE " . tablename('shake_reply') . " ADD `speedandroid` int(10) unsigned NOT NULL DEFAULT '5000' AFTER `speed`;");
}
if (!pdo_fieldexists('shake_reply', 'uniacid')) {
    pdo_query("ALTER TABLE " . tablename('shake_reply') . " ADD   `uniacid` int(10) unsigned NOT NULL;");
}
if (pdo_fieldexists('shake_reply', 'qrcode')) {
    pdo_query("ALTER TABLE " . tablename('shake_reply') . " change   `qrcode` `qrcode` varchar(255) NOT NULL;");
}
if (pdo_fieldexists('shake_reply', 'speedandroid')) {
    pdo_query("ALTER TABLE " . tablename('shake_reply') . " change   `speedandroid`  `speedandroid` int(10) unsigned NOT NULL DEFAULT '8000';");
}

Example #3

File: upgrade.php Project: alextiannus/wormwood_wechat

<?php

if (!pdo_fieldexists('album', 'type')) {
    pdo_query("ALTER TABLE " . tablename('album') . " ADD `type` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER  `isview`;");
}
if (!pdo_indexexists('album_photo', 'idx_albumid')) {
    pdo_query("ALTER TABLE " . tablename('album_photo') . " ADD INDEX `idx_albumid` ( `albumid` );");
}