14 lines
412 B
SQL
14 lines
412 B
SQL
create database auditdb;
|
|
create user 'auditadder'@'%' identified by 'test123';
|
|
grant insert on auditdb.* to 'auditadder'@'%';
|
|
|
|
use auditdb;
|
|
|
|
CREATE TABLE audittrail (
|
|
id int(11) NOT NULL AUTO_INCREMENT,
|
|
ts timestamp NOT NULL DEFAULT current_timestamp(),
|
|
topic varchar(1024) NOT NULL,
|
|
payload varchar(4096) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1437058 DEFAULT CHARSET=latin1
|