【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,guestmap.sql,希望对大家有所帮助!
-- guestmap.
sql -- 鍒涘缓鏁版嵁搴? `guestmap`
CREATE DATABASE ` guestmap ` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
-- 濡傛棤娉曞垱寤烘暟鎹簱锛屽彲浠ヤ娇鐢ㄥ凡鏈夌殑鏁版嵁搴?
-- --------------------------------------------------------
-- 鍒涘缓鏁版嵁琛╜guestinfo`
CREATE TABLE `guestinfo` (
`id` int(11) NOT NULL auto_increment COMMENT 'id',
`ip` int(11) NOT NULL COMMENT '璁垮IP',
`time` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '璁块棶鏃堕棿 ',
`lat` double NOT NULL COMMENT '绾害',
`lng` double NOT NULL COMMENT '缁忓害',
`city` varchar(255) NOT NULL COMMENT '璁垮鎵鍦ㄥ煄甯傦紙闀囩瓑锛?,
`region` varchar(255) NOT NULL COMMENT '璁垮鎵鍦ㄥ窞锛堢渷銆佽嚜娌诲尯銆佺洿杈栧競绛夛級',
`country` varchar(255) NOT NULL COMMENT '璁垮鎵鍦ㄥ浗瀹讹紙鎴栧湴鍖猴級',
`ua` varchar(255) NOT NULL COMMENT '娴忚鍣║A',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='璁垮淇℃伅琛?' AUTO_INCREMENT=1 ;