openvpn/openvpn-auth_mysql/msgtypes.sql

-- 
-- Struktur-dump for tabellen `errortypes`
-- 

CREATE TABLE msgtypes (
  id int(11) NOT NULL default '0',
  errmsg varchar(60) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

-- 
-- Data dump for tabellen `errortypes`
-- 

INSERT INTO msgtypes VALUES (0, 'Successfull login');
INSERT INTO msgtypes VALUES (1, 'User is locked out');
INSERT INTO msgtypes VALUES (2, 'Account has expired');
INSERT INTO msgtypes VALUES (3, 'Zero-length password');
INSERT INTO msgtypes VALUES (4, 'User tried with wrong password');
INSERT INTO msgtypes VALUES (5, 'User does not exist');
INSERT INTO msgtypes VALUES (6, 'User has a failcount>3');
1	--
2	-- Struktur-dump for tabellen `errortypes`
3	--
4
5	CREATE TABLE msgtypes (
6	id int(11) NOT NULL default '0',
7	errmsg varchar(60) NOT NULL default '',
8	PRIMARY KEY (id)
9	) TYPE=MyISAM;
10
11	--
12	-- Data dump for tabellen `errortypes`
13	--
14
15	INSERT INTO msgtypes VALUES (0, 'Successfull login');
16	INSERT INTO msgtypes VALUES (1, 'User is locked out');
17	INSERT INTO msgtypes VALUES (2, 'Account has expired');
18	INSERT INTO msgtypes VALUES (3, 'Zero-length password');
19	INSERT INTO msgtypes VALUES (4, 'User tried with wrong password');
20	INSERT INTO msgtypes VALUES (5, 'User does not exist');
21	INSERT INTO msgtypes VALUES (6, 'User has a failcount>3');