001_InventoryStore.sql 742 B

1234567891011121314151617181920212223242526
  1. BEGIN TRANSACTION;
  2. CREATE TABLE inventoryitems(
  3. UUID varchar(255) primary key,
  4. assetID varchar(255),
  5. assetType integer,
  6. invType integer,
  7. parentFolderID varchar(255),
  8. avatarID varchar(255),
  9. creatorsID varchar(255),
  10. inventoryName varchar(255),
  11. inventoryDescription varchar(255),
  12. inventoryNextPermissions integer,
  13. inventoryCurrentPermissions integer,
  14. inventoryBasePermissions integer,
  15. inventoryEveryOnePermissions integer);
  16. CREATE TABLE inventoryfolders(
  17. UUID varchar(255) primary key,
  18. name varchar(255),
  19. agentID varchar(255),
  20. parentID varchar(255),
  21. type integer,
  22. version integer);
  23. COMMIT;