diff options
| author | David Walter Seikel | 2013-03-15 01:05:46 +1000 |
|---|---|---|
| committer | David Walter Seikel | 2013-03-15 01:05:46 +1000 |
| commit | 532787d4d1d0b59d9610f76276c2fd65fa039fb5 (patch) | |
| tree | 86544df6f7785c21564ef22d8b3b2c9f1caef217 /sql/update-usernotes.sql | |
| parent | Add backups directory. (diff) | |
| download | opensim-SC_OLD-532787d4d1d0b59d9610f76276c2fd65fa039fb5.zip opensim-SC_OLD-532787d4d1d0b59d9610f76276c2fd65fa039fb5.tar.gz opensim-SC_OLD-532787d4d1d0b59d9610f76276c2fd65fa039fb5.tar.bz2 opensim-SC_OLD-532787d4d1d0b59d9610f76276c2fd65fa039fb5.tar.xz | |
Add the SQL update scripts.
Diffstat (limited to 'sql/update-usernotes.sql')
| -rw-r--r-- | sql/update-usernotes.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/update-usernotes.sql b/sql/update-usernotes.sql new file mode 100644 index 0000000..e4538d9 --- /dev/null +++ b/sql/update-usernotes.sql | |||
| @@ -0,0 +1,3 @@ | |||
| 1 | ALTER TABLE `usernotes` DROP PRIMARY KEY ; | ||
| 2 | ALTER TABLE `usernotes` ADD UNIQUE ( `useruuid` , `targetuuid` ); | ||
| 3 | |||