CREATE TABLE IF NOT EXISTS `ra_log_201712` ( 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 MySQL server version for the right syntax to use near 'TYPE = MYISAM AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 400 CHECKSUM = 0 MAX_ROWS = 50' at line 1
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /virtual/ombuds/ra_core/application/libs/Track.php:593) in /virtual/ombuds/lib/cheetan/dispatch.php on line 62

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /virtual/ombuds/ra_core/application/libs/Track.php:593) in /virtual/ombuds/lib/cheetan/dispatch.php on line 62
レポート一覧 - みやざき・市民オンブズマン

レポート一覧

underconstruction...