OpenSim/Data/SQLite/SQLiteInventoryStore.cs
/// <summary>
/// Create the "inventoryitems" table
/// </summary>
Create the "inventoryitems" table
Create the " inventoryitems " table
private static DataTable createInventoryItemsTable()
        {
            DataTable inv = new DataTable("inventoryitems");
            createCol(inv, "UUID", typeof (String)); 
            createCol(inv, "assetID", typeof (String));
            createCol(inv, "assetType", typeof (Int32));
            createCol(inv, "invType", typeof (Int32));
            createCol(inv, "parentFolderID", typeof (String));
            createCol(inv, "avatarID", typeof (String));
            createCol(inv, "creatorsID", typeof (String));
            createCol(inv, "inventoryName", typeof (String));
            createCol(inv, "inventoryDescription", typeof (String));
            createCol(inv, "inventoryNextPermissions", typeof (Int32));
            createCol(inv, "inventoryCurrentPermissions", typeof (Int32));
            createCol(inv, "inventoryBasePermissions", typeof (Int32));
            createCol(inv, "inventoryEveryOnePermissions", typeof (Int32));
            createCol(inv, "inventoryGroupPermissions", typeof (Int32));
            createCol(inv, "salePrice", typeof(Int32));
            createCol(inv, "saleType", typeof(Byte));
            createCol(inv, "creationDate", typeof(Int32));
            createCol(inv, "groupID", typeof(String));
            createCol(inv, "groupOwned", typeof(Boolean));
            createCol(inv, "flags", typeof(UInt32));
            inv.PrimaryKey = new DataColumn[] { inv.Columns["UUID"] };
            return inv;
        }
private static DataTable createInventoryItemsTable ( ) { DataTable inv = new DataTable ( " " ) ; createCol ( inv , " " , typeof ( String ) ) ; createCol ( inv , " " , typeof ( String ) ) ; createCol ( inv , " " , typeof ( Int32 ) ) ; createCol ( inv , " " , typeof ( Int32 ) ) ; createCol ( inv , " " , typeof ( String ) ) ; createCol ( inv , " " , typeof ( String ) ) ; createCol ( inv , " " , typeof ( String ) ) ; createCol ( inv , " " , typeof ( String ) ) ; createCol ( inv , " " , typeof ( String ) ) ; createCol ( inv , " " , typeof ( Int32 ) ) ; createCol ( inv , " " , typeof ( Int32 ) ) ; createCol ( inv , " " , typeof ( Int32 ) ) ; createCol ( inv , " " , typeof ( Int32 ) ) ; createCol ( inv , " " , typeof ( Int32 ) ) ; createCol ( inv , " " , typeof ( Int32 ) ) ; createCol ( inv , " " , typeof ( Byte ) ) ; createCol ( inv , " " , typeof ( Int32 ) ) ; createCol ( inv , " " , typeof ( String ) ) ; createCol ( inv , " " , typeof ( Boolean ) ) ; createCol ( inv , " " , typeof ( UInt32 ) ) ; inv . PrimaryKey = new DataColumn [ ] { inv . Columns [ " " ] } ; return inv ; }
Create the "inventoryitems" table
Create the " inventoryitems " table
//inventoryID // permissions // sale info // creation date // group info // Flags