From a274acc7b837be217c48ac64e33a7085a7ba4456 Mon Sep 17 00:00:00 2001 From: MW Date: Sat, 1 Dec 2007 20:12:36 +0000 Subject: added the mysql table files for inventory. Thanks nebadon. --- share/sql/mysql-inventoryfolders.sql | 34 ++++++++++++++++++++++++++++++++++ share/sql/mysql-inventoryitems.sql | 32 ++++++++++++++++++++++++++++++++ 2 files changed, 66 insertions(+) diff --git a/share/sql/mysql-inventoryfolders.sql b/share/sql/mysql-inventoryfolders.sql index e69de29..af6ee08 100644 --- a/share/sql/mysql-inventoryfolders.sql +++ b/share/sql/mysql-inventoryfolders.sql @@ -0,0 +1,34 @@ +-- phpMyAdmin SQL Dump +-- version 2.11.2.2deb1 +-- http://www.phpmyadmin.net +-- +-- Host: localhost +-- Generation Time: Nov 23, 2007 at 10:19 PM +-- Server version: 5.0.45 +-- PHP Version: 5.2.4-2 + +SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; + +-- +-- Database: `opensim` +-- + +-- -------------------------------------------------------- + +-- +-- Table structure for table `inventoryfolders` +-- + +CREATE TABLE IF NOT EXISTS `inventoryfolders` ( + `folderID` varchar(36) NOT NULL default '', + `agentID` varchar(36) default NULL, + `parentFolderID` varchar(36) default NULL, + `folderName` varchar(64) default NULL, + PRIMARY KEY (`folderID`), + KEY `owner` (`agentID`), + KEY `parent` (`parentFolderID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `inventoryfolders` +-- diff --git a/share/sql/mysql-inventoryitems.sql b/share/sql/mysql-inventoryitems.sql index e69de29..dea12e8 100644 --- a/share/sql/mysql-inventoryitems.sql +++ b/share/sql/mysql-inventoryitems.sql @@ -0,0 +1,32 @@ +-- PHP Version: 5.2.4-2 + +SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; + +-- +-- Database: `opensim` +-- + +-- -------------------------------------------------------- + +-- +-- Table structure for table `inventoryitems` +-- + +CREATE TABLE IF NOT EXISTS `inventoryitems` ( + `inventoryID` varchar(36) NOT NULL default '', + `assetID` varchar(36) default NULL, + `type` int(11) default NULL, + `parentFolderID` varchar(36) default NULL, + `avatarID` varchar(36) default NULL, + `inventoryName` varchar(64) default NULL, + `inventoryDescription` varchar(64) default NULL, + `inventoryNextPermissions` int(10) unsigned default NULL, + `inventoryCurrentPermissions` int(10) unsigned default NULL, + PRIMARY KEY (`inventoryID`), + KEY `owner` (`avatarID`), + KEY `folder` (`parentFolderID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `inventoryitems` +-- -- cgit v1.1