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 '')
-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 | |||