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	torben	113	--
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');