dsyslog-module-mysql 0.6.0build2 / usr / share / dsyslog / tables.mysql

---
--- dsyslog - a dumb syslog (e.g. syslog for people who have a clue)
--- Copyright (c) 2008 William Pitcock <nenolod@sacredspiral.co.uk>
---
--- Permission to use, copy, modify, and/or distribute this software for any
--- purpose with or without fee is hereby granted, provided that the above
--- copyright notice and this permission notice is present in all copies.
---
--- THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
--- ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
--- WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
--- DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
--- ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
--- (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
--- LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
--- ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
--- (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
--- SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
---

CREATE TABLE `log` (
	logid int(11) NOT NULL auto_increment,
	logcode int(11) NOT NULL,
	timestamp int(11) NOT NULL,
	datestamp varchar(255) NOT NULL,
	source varchar(255) NOT NULL,
	program varchar(255) NOT NULL,
	message mediumtext NOT NULL,
	PRIMARY KEY (logid)
) ENGINE=InnoDB;