db/schema/nfo.logins.sql

#-------------------------------------------------------------------------------
#-- www.netfrag.org
#-- DB schema sql.
#-------------------------------------------------------------------------------
#-- rabit, 19:56 04.09.2004
#-- $Id$
#-------------------------------------------------------------------------------

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

DROP TABLE IF EXISTS logins;

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