db/schema/nfo.hits.sql

#-------------------------------------------------------------------------------
#-- www.netfrag.org
#-- DB schema sql.
#-------------------------------------------------------------------------------
#-- rabit, 16:28 04.09.2004
#-- $Id$
#-------------------------------------------------------------------------------

#---------------------------------------
#-- Data base:  "nfo"
#-- Table:      "hits"
#---------------------------------------

DROP TABLE IF EXISTS hits;

CREATE TABLE hits (
  id bigint(20) unsigned NOT NULL auto_increment,
  timestamp datetime NOT NULL default '0000-00-00 00:00:00',
  address varchar(21) NOT NULL default '',
  entryurl varchar(255) NOT NULL default '',
  referer varchar(255) default NULL,
  sessionid varchar(32) NOT NULL default '',
  useragent varchar(255) default NULL,
  requestcount int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
)
TYPE=MyISAM
COMMENT='NFO hit log'
;

1	#-------------------------------------------------------------------------------
2	#-- www.netfrag.org
3	#-- DB schema sql.
4	#-------------------------------------------------------------------------------
5	#-- rabit, 16:28 04.09.2004
6	#-- $Id$
7	#-------------------------------------------------------------------------------
8
9	#---------------------------------------
10	#-- Data base: "nfo"
11	#-- Table: "hits"
12	#---------------------------------------
13
14	DROP TABLE IF EXISTS hits;
15
16	CREATE TABLE hits (
17	id bigint(20) unsigned NOT NULL auto_increment,
18	timestamp datetime NOT NULL default '0000-00-00 00:00:00',
19	address varchar(21) NOT NULL default '',
20	entryurl varchar(255) NOT NULL default '',
21	referer varchar(255) default NULL,
22	sessionid varchar(32) NOT NULL default '',
23	useragent varchar(255) default NULL,
24	requestcount int(10) unsigned NOT NULL default '0',
25	PRIMARY KEY (id)
26	)
27	TYPE=MyISAM
28	COMMENT='NFO hit log'
29	;
30
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26