mod_auth_mysql/mod_auth_mysql/htpasswd.sql


#
# Table structure for table `host_info`
#
# the fields created, updated, and isadmin are not needed by the module!
# they may help you creating a php-htpasswd frontend
# 

CREATE TABLE host_info (
  id int(14) NOT NULL auto_increment,
  host char(255) NOT NULL default '',
  host_group int(14) NOT NULL default '0',
  created timestamp(14) NOT NULL,
  updated timestamp(14) NOT NULL,
  PRIMARY KEY  (id),
  KEY host (host)
) TYPE=MyISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `user_group`
#

CREATE TABLE user_group (
  id int(14) NOT NULL auto_increment,
  user_name char(50) NOT NULL default '',
  user_group char(20) NOT NULL default '',
  host_group int(14) default NULL,
  created timestamp(14) NOT NULL,
  updated timestamp(14) NOT NULL,
  PRIMARY KEY  (id),
  KEY host_group (host_group),
  KEY user_group (user_group)
) TYPE=MyISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Table structure for table `user_info`
#

CREATE TABLE user_info (
  id int(14) NOT NULL auto_increment,
  user_name char(30) NOT NULL default '',
  user_passwd char(120) NOT NULL default '',
  host_group int(14) NOT NULL default '0',
  created timestamp(14) NOT NULL,
  updated timestamp(14) NOT NULL,
  isadmin tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY user_name (user_name,host_group)
) TYPE=MyISAM PACK_KEYS=1;

    

 


1
2	#
3	# Table structure for table `host_info`
4	#
5	# the fields created, updated, and isadmin are not needed by the module!
6	# they may help you creating a php-htpasswd frontend
7	#
8
9	CREATE TABLE host_info (
10	id int(14) NOT NULL auto_increment,
11	host char(255) NOT NULL default '',
12	host_group int(14) NOT NULL default '0',
13	created timestamp(14) NOT NULL,
14	updated timestamp(14) NOT NULL,
15	PRIMARY KEY (id),
16	KEY host (host)
17	) TYPE=MyISAM PACK_KEYS=1;
18	# --------------------------------------------------------
19
20	#
21	# Table structure for table `user_group`
22	#
23
24	CREATE TABLE user_group (
25	id int(14) NOT NULL auto_increment,
26	user_name char(50) NOT NULL default '',
27	user_group char(20) NOT NULL default '',
28	host_group int(14) default NULL,
29	created timestamp(14) NOT NULL,
30	updated timestamp(14) NOT NULL,
31	PRIMARY KEY (id),
32	KEY host_group (host_group),
33	KEY user_group (user_group)
34	) TYPE=MyISAM PACK_KEYS=1;
35	# --------------------------------------------------------
36
37	#
38	# Table structure for table `user_info`
39	#
40
41	CREATE TABLE user_info (
42	id int(14) NOT NULL auto_increment,
43	user_name char(30) NOT NULL default '',
44	user_passwd char(120) NOT NULL default '',
45	host_group int(14) NOT NULL default '0',
46	created timestamp(14) NOT NULL,
47	updated timestamp(14) NOT NULL,
48	isadmin tinyint(4) NOT NULL default '0',
49	PRIMARY KEY (id),
50	UNIQUE KEY user_name (user_name,host_group)
51	) TYPE=MyISAM PACK_KEYS=1;
52
53
54
55
56
57
No admin address has been configured">No admin address has been configured	ViewVC Help
Powered by ViewVC 1.1.5