################################mysql################################## CREATE DATABASE salt DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
USE salt;
DROP TABLE IF EXISTS jids; CREATE TABLE jids ( jid varchar(255) NOT NULL, load mediumtext NOT NULL, UNIQUE KEY jid (jid) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS salt_returns; CREATE TABLE salt_returns ( fun varchar(50) NOT NULL, jid varchar(255) NOT NULL, return mediumtext NOT NULL, id varchar(255) NOT NULL, success varchar(10) NOT NULL, full_ret mediumtext NOT NULL, alter_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, KEY id (id), KEY jid (jid), KEY fun (fun) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS salt_events; CREATE TABLE salt_events ( id BIGINT NOT NULL AUTO_INCREMENT, tag varchar(255) NOT NULL, data varchar(1024) NOT NULL, alter_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY tag (tag) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
mysql> use salt mysql> show tables; +----------------+ | Tables_in_salt | +----------------+ | jids | | salt_events | | salt_returns | +----------------+
grant all on salt.* to salt@'%' identified by 'salt';
