[root@localhost ~]# grep -v
"^--"
auth.sql | grep -v
"^/"
| grep -v
"^$"
CREATE
DATABASE
/*!32312 IF
NOT
EXISTS*/ `auth` /*!40100
DEFAULT
CHARACTER
SET
utf8 */;
USE `auth`;
DROP
TABLE
IF EXISTS `servers`;
CREATE
TABLE
`servers` (
`Server_name`
char
(64)
NOT
NULL
,
`Host`
char
(64)
NOT
NULL
,
`Db`
char
(64)
NOT
NULL
,
`Username`
char
(64)
NOT
NULL
,
`
Password
`
char
(64)
NOT
NULL
,
`Port`
int
(4)
DEFAULT
NULL
,
`Socket`
char
(64)
DEFAULT
NULL
,
`Wrapper`
char
(64)
NOT
NULL
,
`Owner`
char
(64)
NOT
NULL
,
PRIMARY
KEY
(`Server_name`)
) ENGINE=MyISAM
DEFAULT
CHARSET=utf8 COMMENT=
'MySQL Foreign Servers table'
;
LOCK TABLES `servers` WRITE;
UNLOCK TABLES;
DROP
TABLE
IF EXISTS `users`;
CREATE
TABLE
`users` (
`user_name`
char
(16)
NOT
NULL
,
`user_passwd`
char
(48)
DEFAULT
''
,
PRIMARY
KEY
(`user_name`)
) ENGINE=InnoDB
DEFAULT
CHARSET=utf8;
LOCK TABLES `users` WRITE;
INSERT
INTO
`users`
VALUES
(
'jacktian'
,
'*B2B366CA5C4697F31D4C55D61F0B17E70E5664EC'
);
UNLOCK TABLES;