dbscript.sql

来自「流量统计」· SQL 代码 · 共 28 行

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	4.1.20-community-nt

--
-- Create schema stat
--

CREATE DATABASE IF NOT EXISTS stat;
USE stat;

--
-- Table structure for table `stat`.`history`
--

DROP TABLE IF EXISTS `history`;
CREATE TABLE `history` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(50) default NULL,
  `os` varchar(50) default NULL,
  `browser` varchar(50) default NULL,
  `accessdate` date default '0000-00-00',
  `accesstime` time default '00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;