CREATE TABLE IF NOT EXISTS `ra_log_202504` ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', dd VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'アクセス日', logtype CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'ログタイプ', uid VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '訪問者ID', hh VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'アクセス時', mi VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'アクセス分', ss VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'アクセス秒', weekday VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '曜日', remote_addr VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'IPアドレス', remote_host VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'リモートホスト', domain VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'ドメイン', jpdomain VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'JPドメイン', country VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '国', pref VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '都道府県', url TEXT CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'URL', title TEXT CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'タイトル', screenwh VARCHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '画面解像度', screencol VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '画面色', jsck CHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'Javascript/Cookie', os VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'OS', browser VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'ブラウザ', brow_ver VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'ブラウザバージョン', crawler VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'クローラー', keyword TEXT CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '検索キーワード', engine VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '検索エンジン', referer_title TEXT CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'リファラータイトル', referer_host VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'リファラーホスト名', http_user_agent TEXT CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'ユーザーエージェント', http_referer TEXT CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'リファラー', PRIMARY KEY ( id ) , INDEX idx_research (dd, logtype) ) TYPE = MYISAM AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 400 CHECKSUM = 0 MAX_ROWS = 50000000 MIN_ROWS = 1 PACK_KEYS = DEFAULT DELAY_KEY_WRITE = 0 ROW_FORMAT = DEFAULT DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'ログテーブル' ;:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE = MYISAM AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 400 CHECKSUM = 0 MAX_ROWS =...' at line 1
CoCoMoNetミラー - JpLOグループ
