mirror of
https://github.com/kcozens/OpenSimProfile.git
synced 2026-08-17 02:22:00 +00:00
kcozens
e120aa49fc
Updated the upgrade instructions in the README file. git-svn-id: http://forge.opensimulator.org/svn/osprofile/trunk@112 19860011-0018-435d-96ae-4a7b0aaa3128
16 lines
554 B
PL/PgSQL
16 lines
554 B
PL/PgSQL
#This file updates the tables used by OpenSimProfile to the latest schema.
|
|
#Use this file if you are updating an existing installation of the search
|
|
#module. If you are doing a first time install, use the osprofile.sql file.
|
|
|
|
#SVN revision 69
|
|
BEGIN;
|
|
ALTER TABLE `userprofile` ADD `profileImage` VARCHAR( 36 ) NOT NULL AFTER `profileLanguages`,
|
|
ADD `profileAboutText` TEXT NOT NULL AFTER `profileImage` ;
|
|
COMMIT;
|
|
|
|
#SVN revision 78
|
|
BEGIN;
|
|
ALTER TABLE `usernotes` DROP PRIMARY KEY ;
|
|
ALTER TABLE `usernotes` ADD UNIQUE ( `useruuid` , `targetuuid` );
|
|
COMMIT;
|