Home\Controller\UpdateController::sqlite PHP Method

    public function sqlite()
    {
        //catalog表增加parent_cat_id字段
        $columns = M("catalog")->getDbFields();
        if ($columns) {
            $has_it = 0;
            //是否存在该字段
            foreach ($columns as $key => $value) {
                if ($value == 'parent_cat_id') {
                    $has_it = 1;
                }
            }
            if ($has_it === 0) {
                $sql = "ALTER TABLE " . C('DB_PREFIX') . "catalog ADD parent_cat_id INT( 10 ) NOT NULL DEFAULT '0' ;";
                D("catalog")->execute($sql);
            }
        }
        //catalog表增加level字段
        $columns = M("catalog")->getDbFields();
        if ($columns) {
            $has_it = 0;
            //是否存在该字段
            foreach ($columns as $key => $value) {
                if ($value == 'level') {
                    $has_it = 1;
                }
            }
            if ($has_it === 0) {
                $sql = "ALTER TABLE " . C('DB_PREFIX') . "catalog ADD level INT( 10 ) NOT NULL DEFAULT '2'  ;";
                D("catalog")->execute($sql);
            }
        }
        //item表增加item_domain字段
        $columns = M("item")->getDbFields();
        if ($columns) {
            $has_it = 0;
            //是否存在该字段
            foreach ($columns as $key => $value) {
                if ($value == 'item_domain') {
                    $has_it = 1;
                }
            }
            if ($has_it === 0) {
                $sql = "ALTER TABLE " . C('DB_PREFIX') . "item ADD item_domain text NOT NULL DEFAULT '';";
                D("item")->execute($sql);
            }
        }
        //创建user_token表
        $sql = "CREATE TABLE IF NOT EXISTS `user_token` (\n        `id`  INTEGER PRIMARY KEY ,\n        `uid` int(10) NOT NULL DEFAULT '0',\n        `token` CHAR(200) NOT NULL DEFAULT '',\n        `token_expire` int(11) NOT NULL DEFAULT '0' ,\n        `ip` CHAR(200) NOT NULL DEFAULT '',\n        `addtime` int(11) NOT NULL DEFAULT '0'\n        )";
        D("UserToken")->execute($sql);
        //创建template表
        $sql = "CREATE TABLE IF NOT EXISTS `template` (\n        `id`  INTEGER PRIMARY KEY ,\n        `uid` int(10) NOT NULL DEFAULT '0',\n        `username` CHAR(200) NOT NULL DEFAULT '',\n        `template_title` CHAR(200) NOT NULL DEFAULT '' ,\n        `template_content` text NOT NULL DEFAULT '',\n        `addtime` int(11) NOT NULL DEFAULT '0'\n        )";
        D("UserToken")->execute($sql);
        //page表增加page_comments字段
        $columns = D("Page")->getDbFields();
        if ($columns) {
            $has_it = 0;
            //是否存在该字段
            foreach ($columns as $key => $value) {
                if ($value == 'page_comments') {
                    $has_it = 1;
                }
            }
            if ($has_it === 0) {
                $sql = "ALTER TABLE " . C('DB_PREFIX') . "page ADD page_comments text NOT NULL DEFAULT ''  ;";
                D("Page")->execute($sql);
            }
        }
        //page_history 表增加page_comments字段
        $columns = D("PageHistory")->getDbFields();
        if ($columns) {
            $has_it = 0;
            //是否存在该字段
            foreach ($columns as $key => $value) {
                if ($value == 'page_comments') {
                    $has_it = 1;
                }
            }
            if ($has_it === 0) {
                $sql = "ALTER TABLE " . C('DB_PREFIX') . "page_history ADD page_comments text NOT NULL DEFAULT '';";
                D("PageHistory")->execute($sql);
            }
        }
        //item_member表增加member_group_id字段
        $columns = M("ItemMember")->getDbFields();
        if ($columns) {
            $has_it = 0;
            //是否存在该字段
            foreach ($columns as $key => $value) {
                if ($value == 'member_group_id') {
                    $has_it = 1;
                }
            }
            if ($has_it === 0) {
                $sql = "ALTER TABLE " . C('DB_PREFIX') . "item_member ADD member_group_id INT( 1 ) NOT NULL DEFAULT '1'  ;";
                D("ItemMember")->execute($sql);
            }
        }
        //item表增加item_type字段
        $columns = M("Item")->getDbFields();
        if ($columns) {
            $has_it = 0;
            //是否存在该字段
            foreach ($columns as $key => $value) {
                if ($value == 'item_type') {
                    $has_it = 1;
                }
            }
            if ($has_it === 0) {
                $sql = "ALTER TABLE " . C('DB_PREFIX') . "item ADD item_type INT( 1 ) NOT NULL DEFAULT '1'  ;";
                D("Item")->execute($sql);
            }
        }
        echo 'OK!';
    }