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 | |
| parent | fix an edge case with migrations in the region store. (diff) | |
| download | opensim-SC-d28a5a4de78f79d2730d09d20a8284caef5339bf.zip opensim-SC-d28a5a4de78f79d2730d09d20a8284caef5339bf.tar.gz opensim-SC-d28a5a4de78f79d2730d09d20a8284caef5339bf.tar.bz2 opensim-SC-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')
| -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 |