aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
-rw-r--r--OpenSim/Data/MySQL/Resources/001_LogStore.sql10
-rw-r--r--OpenSim/Data/MySQL/Resources/CreateLogsTable.sql2
2 files changed, 11 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_LogStore.sql b/OpenSim/Data/MySQL/Resources/001_LogStore.sql
new file mode 100644
index 0000000..b4c29fb
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/001_LogStore.sql
@@ -0,0 +1,10 @@
1CREATE TABLE `logs` (
2 `logID` int(10) unsigned NOT NULL auto_increment,
3 `target` varchar(36) default NULL,
4 `server` varchar(64) default NULL,
5 `method` varchar(64) default NULL,
6 `arguments` varchar(255) default NULL,
7 `priority` int(11) default NULL,
8 `message` text,
9 PRIMARY KEY (`logID`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/OpenSim/Data/MySQL/Resources/CreateLogsTable.sql b/OpenSim/Data/MySQL/Resources/CreateLogsTable.sql
index 64b3a80..53dcd31 100644
--- a/OpenSim/Data/MySQL/Resources/CreateLogsTable.sql
+++ b/OpenSim/Data/MySQL/Resources/CreateLogsTable.sql
@@ -7,4 +7,4 @@ CREATE TABLE `logs` (
7 `priority` int(11) default NULL, 7 `priority` int(11) default NULL,
8 `message` text, 8 `message` text,
9 PRIMARY KEY (`logID`) 9 PRIMARY KEY (`logID`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; 10) ENGINE=InnoDB DEFAULT CHARSET=utf8