diff options
| author | Sean Dague | 2008-06-19 15:42:57 +0000 |
|---|---|---|
| committer | Sean Dague | 2008-06-19 15:42:57 +0000 |
| commit | d28a5a4de78f79d2730d09d20a8284caef5339bf (patch) | |
| tree | bb8591c996283ffa6127ce2896771a75ac017fa9 /OpenSim/Data/MySQL/Resources/001_LogStore.sql | |
| parent | fix an edge case with migrations in the region store. (diff) | |
| download | opensim-SC_OLD-d28a5a4de78f79d2730d09d20a8284caef5339bf.zip opensim-SC_OLD-d28a5a4de78f79d2730d09d20a8284caef5339bf.tar.gz opensim-SC_OLD-d28a5a4de78f79d2730d09d20a8284caef5339bf.tar.bz2 opensim-SC_OLD-d28a5a4de78f79d2730d09d20a8284caef5339bf.tar.xz | |
add migrations support for mysql log store. This should complete
all the mysql bits for migration.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/001_LogStore.sql')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/001_LogStore.sql | 10 |
1 files changed, 10 insertions, 0 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; | ||