db/schema/nfo.users.sql

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

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

DROP TABLE IF EXISTS users;

CREATE TABLE users (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  password varchar(255) NOT NULL default '',
  rights varchar(255) NOT NULL default '',
  user_id int(10) unsigned NOT NULL default '0',
  timestamp datetime default NULL,
  logincount int(10) NOT NULL default '0',
  lastlogin datetime default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY name (name)
)
TYPE=MyISAM
COMMENT='NFO users'
;
1	#-------------------------------------------------------------------------------
2	#-- www.netfrag.org
3	#-- DB schema sql.
4	#-------------------------------------------------------------------------------
5	#-- rabit, 16:33 04.09.2004
6	#-- $Id$
7	#-------------------------------------------------------------------------------
8
9	#---------------------------------------
10	#-- Data base: "nfo"
11	#-- Table: "users"
12	#---------------------------------------
13
14	DROP TABLE IF EXISTS users;
15
16	CREATE TABLE users (
17	id int(10) unsigned NOT NULL auto_increment,
18	name varchar(255) NOT NULL default '',
19	password varchar(255) NOT NULL default '',
20	rights varchar(255) NOT NULL default '',
21	user_id int(10) unsigned NOT NULL default '0',
22	timestamp datetime default NULL,
23	logincount int(10) NOT NULL default '0',
24	lastlogin datetime default NULL,
25	PRIMARY KEY (id),
26	UNIQUE KEY name (name)
27	)
28	TYPE=MyISAM
29	COMMENT='NFO users'
30	;
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26