aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql/mysql-inventoryitems.sql
diff options
context:
space:
mode:
authorMW2007-12-01 20:12:36 +0000
committerMW2007-12-01 20:12:36 +0000
commita274acc7b837be217c48ac64e33a7085a7ba4456 (patch)
treeb0fff35484acb2e00e8e2a1c7651890d7e6aa75e /share/sql/mysql-inventoryitems.sql
parentOn login, if a set of inventory folders doesn't exist for the user then a new... (diff)
downloadopensim-SC_OLD-a274acc7b837be217c48ac64e33a7085a7ba4456.zip
opensim-SC_OLD-a274acc7b837be217c48ac64e33a7085a7ba4456.tar.gz
opensim-SC_OLD-a274acc7b837be217c48ac64e33a7085a7ba4456.tar.bz2
opensim-SC_OLD-a274acc7b837be217c48ac64e33a7085a7ba4456.tar.xz
added the mysql table files for inventory. Thanks nebadon.
Diffstat (limited to 'share/sql/mysql-inventoryitems.sql')
-rw-r--r--share/sql/mysql-inventoryitems.sql32
1 files changed, 32 insertions, 0 deletions
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 @@
1-- PHP Version: 5.2.4-2
2
3SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
4
5--
6-- Database: `opensim`
7--
8
9-- --------------------------------------------------------
10
11--
12-- Table structure for table `inventoryitems`
13--
14
15CREATE TABLE IF NOT EXISTS `inventoryitems` (
16 `inventoryID` varchar(36) NOT NULL default '',
17 `assetID` varchar(36) default NULL,
18 `type` int(11) default NULL,
19 `parentFolderID` varchar(36) default NULL,
20 `avatarID` varchar(36) default NULL,
21 `inventoryName` varchar(64) default NULL,
22 `inventoryDescription` varchar(64) default NULL,
23 `inventoryNextPermissions` int(10) unsigned default NULL,
24 `inventoryCurrentPermissions` int(10) unsigned default NULL,
25 PRIMARY KEY (`inventoryID`),
26 KEY `owner` (`avatarID`),
27 KEY `folder` (`parentFolderID`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29
30--
31-- Dumping data for table `inventoryitems`
32--