# $Id: sqlsyslogd.sql,v 1.1.1.1 2001/05/21 15:31:50 venglin Exp $

CREATE DATABASE sqlsyslogd;

USE sqlsyslogd;

CREATE TABLE logs (
	id int(10) DEFAULT '0' NOT NULL auto_increment,
	timestamp varchar(16),
	host varchar(255),
	prog varchar(255),
	mesg text,
	PRIMARY KEY (id)
);

USE mysql;

INSERT INTO user VALUES ( 'localhost', 'sqlsyslogd', PASSWORD('foo'), 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');

INSERT INTO db VALUES ( 'localhost', 'sqlsyslogd', 'sqlsyslogd', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');

FLUSH PRIVILEGES;