简单的按月建立流水表类

    class createTableAction{
        public function index(){
            $dateSuffix = date('Y-m');
            $checkTable = $dateSuffix.'statistics';
            $res = $this->checkTables($checkTable);
            if(!$res){
                $checkTable = $this->createTable($checkTable);
            }
        }
        //检测数据表是否存在
        protected function checkTables($tables){
            $tables = date('Y-m').'statistics';
            $sql = "show tables like '{$tables}'";
            $res = M()->query($sql);
            if($res){
                return true;
            }else{
                return false;
            }
        }    
        //建立数据表
        private function createTable($tables){
            $sql = "
                create table if not exists `{$tables}`(
                    `id` bigint(20) not null primary key auto_increment,
                    `is_show` smallint(1) default 0 
                ) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
            M()->query($sql);
            //echo M()->getLastsql();
            return $table;
        }
    }