From 774958bbbf639090e73204be1d5b6d5c7653441a Mon Sep 17 00:00:00 2001 From: Diva Canto Date: Sun, 28 Feb 2010 16:09:06 -0800 Subject: Added FriendsData to both Null storage and SQLite. Untested. --- OpenSim/Data/SQLite/Resources/001_FriendsStore.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 OpenSim/Data/SQLite/Resources/001_FriendsStore.sql (limited to 'OpenSim/Data/SQLite/Resources/001_FriendsStore.sql') diff --git a/OpenSim/Data/SQLite/Resources/001_FriendsStore.sql b/OpenSim/Data/SQLite/Resources/001_FriendsStore.sql new file mode 100644 index 0000000..f1b9ab9 --- /dev/null +++ b/OpenSim/Data/SQLite/Resources/001_FriendsStore.sql @@ -0,0 +1,10 @@ +BEGIN TRANSACTION; + +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`)); + +COMMIT; -- cgit v1.1