diff options
author | AlexRa | 2010-05-01 17:43:10 +0300 |
---|---|---|
committer | AlexRa | 2010-05-18 22:16:06 +0300 |
commit | e4419c34c30e1cf6529ced125f0c05aed24644a4 (patch) | |
tree | b54d5aff69c63fefc27dea2b938c1838974d77ac /OpenSim/Data/MySQL/Resources/FriendsStore.migrations | |
parent | Added MySqlMigrations.cs (supports stored proc/funcs) (diff) | |
download | opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.zip opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.gz opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.bz2 opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.xz |
Converted MySQL migration history to the new format
Replaced all NNN_StoreName.sql migration resources with a more
readable, single-file-per-store
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/FriendsStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/FriendsStore.migrations | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/FriendsStore.migrations b/OpenSim/Data/MySQL/Resources/FriendsStore.migrations new file mode 100644 index 0000000..ce713bd --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/FriendsStore.migrations | |||
@@ -0,0 +1,25 @@ | |||
1 | :VERSION 1 # ------------------------- | ||
2 | |||
3 | BEGIN; | ||
4 | |||
5 | CREATE TABLE `Friends` ( | ||
6 | `PrincipalID` CHAR(36) NOT NULL, | ||
7 | `Friend` VARCHAR(255) NOT NULL, | ||
8 | `Flags` VARCHAR(16) NOT NULL DEFAULT 0, | ||
9 | `Offered` VARCHAR(32) NOT NULL DEFAULT 0, | ||
10 | PRIMARY KEY(`PrincipalID`, `Friend`), | ||
11 | KEY(`PrincipalID`) | ||
12 | ); | ||
13 | |||
14 | COMMIT; | ||
15 | |||
16 | :VERSION 2 # ------------------------- | ||
17 | |||
18 | BEGIN; | ||
19 | |||
20 | INSERT INTO `Friends` SELECT `ownerID`, `friendID`, `friendPerms`, 0 FROM `userfriends`; | ||
21 | |||
22 | COMMIT; | ||
23 | |||
24 | |||
25 | |||