From b92cb6126d8ca59121468fce44dc7b4c3b805181 Mon Sep 17 00:00:00 2001 From: Melanie Date: Fri, 5 Feb 2010 12:31:29 +0000 Subject: Implement the friends data adaptor --- OpenSim/Data/MySQL/Resources/001_FriendsStore.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 OpenSim/Data/MySQL/Resources/001_FriendsStore.sql (limited to 'OpenSim/Data/MySQL/Resources/001_FriendsStore.sql') diff --git a/OpenSim/Data/MySQL/Resources/001_FriendsStore.sql b/OpenSim/Data/MySQL/Resources/001_FriendsStore.sql new file mode 100644 index 0000000..da2c59c --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/001_FriendsStore.sql @@ -0,0 +1,5 @@ +BEGIN; + +CREATE TABLE `Friends` (`PrincipalID` CHAR(36) NOT NULL, `Friend` VARCHAR(255) NOT NULL, `Flags` VARCHAR(16) NOT NULL DEFAULT 0, `Offered` VARCHAR(32) NOT NULL DEFAULT 0, PRIMARY KEY(`PrincipalID`, `Friend`), KEY(`PrincipalID`)); + +COMMIT; -- cgit v1.1