From 66bf2021d8ebe5188a844e7e21717fe8b0cb50ae Mon Sep 17 00:00:00 2001 From: Adam Frisby Date: Mon, 28 May 2007 22:23:41 +0000 Subject: Added SQL file for log saving (and apparently SQL files live in a new place) --- releng/dist/SQL/mysql-logs.txt | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 releng/dist/SQL/mysql-logs.txt diff --git a/releng/dist/SQL/mysql-logs.txt b/releng/dist/SQL/mysql-logs.txt new file mode 100644 index 0000000..05c19e8 --- /dev/null +++ b/releng/dist/SQL/mysql-logs.txt @@ -0,0 +1,10 @@ +CREATE TABLE `logs` ( + `logID` int(10) unsigned NOT NULL auto_increment, + `target` varchar(36) default NULL, + `server` varchar(64) default NULL, + `method` varchar(64) default NULL, + `arguments` varchar(255) default NULL, + `priority` int(11) default NULL, + `message` text, + PRIMARY KEY (`logID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 \ No newline at end of file -- cgit v1.1