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	rabit	1.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