db.sql

来自「jsp+servlet+jdbc结构的在线访问统计系统」· SQL 代码 · 共 16 行

create database statisticDB;
use statisticDB;

drop table if exists access;
create table access
(
   id             	int not null auto_increment,
   ip				varchar(30),
   os				varchar(30),
   brower			varchar(100),
   page				varchar(30),
   accessDate		date,
   accessTime		time,
   primary key (id)
)ENGINE=InnoDB DEFAULT CHARSET=gb2312;