diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/001_LogStore.sql | 10 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/CreateLogsTable.sql | 2 |
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 @@ | |||
1 | CREATE 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 |