sql.sql

来自「ajax打造的动态计数器」· SQL 代码 · 共 11 行

CREATE TABLE pagelink (
  id int(11) unsigned NOT NULL auto_increment,
  `file` varchar(30) NOT NULL,
  os varchar(20) NOT NULL default 'unknown',
  browser varchar(50) NOT NULL,
  browVer varchar(10) NOT NULL default 'unknown',
  ip varchar(20) NOT NULL default '',
  visit_time timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;