mirror of
https://github.com/ManfredAabye/OpenSim-Viewer-Webinterface.git
synced 2026-08-14 08:53:07 +00:00
841 lines
25 KiB
SQL
841 lines
25 KiB
SQL
-- phpMyAdmin SQL Dump
|
|
-- version 5.1.1deb5ubuntu1
|
|
-- https://www.phpmyadmin.net/
|
|
--
|
|
-- Host: localhost:3306
|
|
-- Erstellungszeit: 19. Okt 2025 um 11:02
|
|
-- Server-Version: 10.6.22-MariaDB-0ubuntu0.22.04.1
|
|
-- PHP-Version: 8.1.2-1ubuntu2.22
|
|
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
START TRANSACTION;
|
|
SET time_zone = "+00:00";
|
|
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!40101 SET NAMES utf8mb4 */;
|
|
|
|
--
|
|
-- Datenbank: `robust`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `AgentPrefs`
|
|
--
|
|
|
|
CREATE TABLE `AgentPrefs` (
|
|
`PrincipalID` char(36) NOT NULL,
|
|
`AccessPrefs` char(2) NOT NULL DEFAULT 'M',
|
|
`HoverHeight` double(30,27) NOT NULL DEFAULT 0.000000000000000000000000000,
|
|
`Language` char(5) NOT NULL DEFAULT 'en-us',
|
|
`LanguageIsPublic` tinyint(1) NOT NULL DEFAULT 1,
|
|
`PermEveryone` int(6) NOT NULL DEFAULT 0,
|
|
`PermGroup` int(6) NOT NULL DEFAULT 0,
|
|
`PermNextOwner` int(6) NOT NULL DEFAULT 532480
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `assets`
|
|
--
|
|
|
|
CREATE TABLE `assets` (
|
|
`name` varchar(64) NOT NULL,
|
|
`description` varchar(64) NOT NULL,
|
|
`assetType` tinyint(4) NOT NULL,
|
|
`local` tinyint(1) NOT NULL,
|
|
`temporary` tinyint(1) NOT NULL,
|
|
`data` longblob NOT NULL,
|
|
`id` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`create_time` int(11) DEFAULT 0,
|
|
`access_time` int(11) DEFAULT 0,
|
|
`asset_flags` int(11) NOT NULL DEFAULT 0,
|
|
`CreatorID` varchar(128) NOT NULL DEFAULT ''
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `auth`
|
|
--
|
|
|
|
CREATE TABLE `auth` (
|
|
`UUID` char(36) NOT NULL,
|
|
`passwordHash` char(32) NOT NULL DEFAULT '',
|
|
`passwordSalt` char(32) NOT NULL DEFAULT '',
|
|
`webLoginKey` varchar(255) NOT NULL DEFAULT '',
|
|
`accountType` varchar(32) NOT NULL DEFAULT 'UserAccount'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `Avatars`
|
|
--
|
|
|
|
CREATE TABLE `Avatars` (
|
|
`PrincipalID` char(36) NOT NULL,
|
|
`Name` varchar(32) NOT NULL,
|
|
`Value` text DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `balances`
|
|
--
|
|
|
|
CREATE TABLE `balances` (
|
|
`user` varchar(36) NOT NULL,
|
|
`balance` int(10) NOT NULL,
|
|
`status` tinyint(2) DEFAULT NULL,
|
|
`type` tinyint(2) NOT NULL DEFAULT 0
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Rev.4';
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `classifieds`
|
|
--
|
|
|
|
CREATE TABLE `classifieds` (
|
|
`classifieduuid` char(36) NOT NULL,
|
|
`creatoruuid` char(36) NOT NULL,
|
|
`creationdate` int(20) NOT NULL,
|
|
`expirationdate` int(20) NOT NULL,
|
|
`category` varchar(20) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`description` text NOT NULL,
|
|
`parceluuid` char(36) NOT NULL,
|
|
`parentestate` int(11) NOT NULL,
|
|
`snapshotuuid` char(36) NOT NULL,
|
|
`simname` varchar(255) NOT NULL,
|
|
`posglobal` varchar(255) NOT NULL,
|
|
`parcelname` varchar(255) NOT NULL,
|
|
`classifiedflags` int(8) NOT NULL,
|
|
`priceforlisting` int(5) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `Friends`
|
|
--
|
|
|
|
CREATE TABLE `Friends` (
|
|
`PrincipalID` varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`Friend` varchar(255) NOT NULL,
|
|
`Flags` varchar(16) NOT NULL DEFAULT '0',
|
|
`Offered` varchar(32) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `GridUser`
|
|
--
|
|
|
|
CREATE TABLE `GridUser` (
|
|
`UserID` varchar(255) NOT NULL,
|
|
`HomeRegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`HomePosition` char(64) NOT NULL DEFAULT '<0,0,0>',
|
|
`HomeLookAt` char(64) NOT NULL DEFAULT '<0,0,0>',
|
|
`LastRegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`LastPosition` char(64) NOT NULL DEFAULT '<0,0,0>',
|
|
`LastLookAt` char(64) NOT NULL DEFAULT '<0,0,0>',
|
|
`Online` char(5) NOT NULL DEFAULT 'false',
|
|
`Login` char(16) NOT NULL DEFAULT '0',
|
|
`Logout` char(16) NOT NULL DEFAULT '0'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `hg_traveling_data`
|
|
--
|
|
|
|
CREATE TABLE `hg_traveling_data` (
|
|
`SessionID` varchar(36) NOT NULL,
|
|
`UserID` varchar(36) NOT NULL,
|
|
`GridExternalName` varchar(255) NOT NULL DEFAULT '',
|
|
`ServiceToken` varchar(255) NOT NULL DEFAULT '',
|
|
`ClientIPAddress` varchar(16) NOT NULL DEFAULT '',
|
|
`MyIPAddress` varchar(16) NOT NULL DEFAULT '',
|
|
`TMStamp` timestamp NOT NULL DEFAULT current_timestamp()
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `im_offline`
|
|
--
|
|
|
|
CREATE TABLE `im_offline` (
|
|
`ID` mediumint(9) NOT NULL,
|
|
`PrincipalID` char(36) NOT NULL DEFAULT '',
|
|
`FromID` char(36) NOT NULL DEFAULT '',
|
|
`Message` text NOT NULL,
|
|
`TMStamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `inventoryfolders`
|
|
--
|
|
|
|
CREATE TABLE `inventoryfolders` (
|
|
`folderName` varchar(64) DEFAULT NULL,
|
|
`type` smallint(6) NOT NULL DEFAULT 0,
|
|
`version` int(11) NOT NULL DEFAULT 0,
|
|
`folderID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`agentID` char(36) DEFAULT NULL,
|
|
`parentFolderID` char(36) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `inventoryitems`
|
|
--
|
|
|
|
CREATE TABLE `inventoryitems` (
|
|
`assetID` varchar(36) DEFAULT NULL,
|
|
`assetType` int(11) DEFAULT NULL,
|
|
`inventoryName` varchar(64) DEFAULT NULL,
|
|
`inventoryDescription` varchar(128) DEFAULT NULL,
|
|
`inventoryNextPermissions` int(10) UNSIGNED DEFAULT NULL,
|
|
`inventoryCurrentPermissions` int(10) UNSIGNED DEFAULT NULL,
|
|
`invType` int(11) DEFAULT NULL,
|
|
`creatorID` varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`inventoryBasePermissions` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`inventoryEveryOnePermissions` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`salePrice` int(11) NOT NULL DEFAULT 0,
|
|
`saleType` tinyint(4) NOT NULL DEFAULT 0,
|
|
`creationDate` int(11) NOT NULL DEFAULT 0,
|
|
`groupID` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`groupOwned` tinyint(4) NOT NULL DEFAULT 0,
|
|
`flags` int(11) UNSIGNED NOT NULL DEFAULT 0,
|
|
`inventoryID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`avatarID` char(36) DEFAULT NULL,
|
|
`parentFolderID` char(36) DEFAULT NULL,
|
|
`inventoryGroupPermissions` int(10) UNSIGNED NOT NULL DEFAULT 0
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `migrations`
|
|
--
|
|
|
|
CREATE TABLE `migrations` (
|
|
`name` varchar(100) DEFAULT NULL,
|
|
`version` int(11) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `MuteList`
|
|
--
|
|
|
|
CREATE TABLE `MuteList` (
|
|
`AgentID` char(36) NOT NULL,
|
|
`MuteID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`MuteName` varchar(64) NOT NULL DEFAULT '',
|
|
`MuteType` int(11) NOT NULL DEFAULT 1,
|
|
`MuteFlags` int(11) NOT NULL DEFAULT 0,
|
|
`Stamp` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `os_groups_groups`
|
|
--
|
|
|
|
CREATE TABLE `os_groups_groups` (
|
|
`GroupID` char(36) NOT NULL DEFAULT '',
|
|
`Location` varchar(255) NOT NULL DEFAULT '',
|
|
`Name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
|
|
`Charter` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
|
|
`InsigniaID` char(36) NOT NULL DEFAULT '',
|
|
`FounderID` char(36) NOT NULL DEFAULT '',
|
|
`MembershipFee` int(11) NOT NULL DEFAULT 0,
|
|
`OpenEnrollment` varchar(255) NOT NULL DEFAULT '',
|
|
`ShowInList` int(4) NOT NULL DEFAULT 0,
|
|
`AllowPublish` int(4) NOT NULL DEFAULT 0,
|
|
`MaturePublish` int(4) NOT NULL DEFAULT 0,
|
|
`OwnerRoleID` char(36) NOT NULL DEFAULT ''
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `os_groups_invites`
|
|
--
|
|
|
|
CREATE TABLE `os_groups_invites` (
|
|
`InviteID` char(36) NOT NULL DEFAULT '',
|
|
`GroupID` char(36) NOT NULL DEFAULT '',
|
|
`RoleID` char(36) NOT NULL DEFAULT '',
|
|
`PrincipalID` varchar(255) NOT NULL DEFAULT '',
|
|
`TMStamp` timestamp NOT NULL DEFAULT current_timestamp()
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `os_groups_membership`
|
|
--
|
|
|
|
CREATE TABLE `os_groups_membership` (
|
|
`GroupID` char(36) NOT NULL DEFAULT '',
|
|
`PrincipalID` varchar(255) NOT NULL DEFAULT '',
|
|
`SelectedRoleID` char(36) NOT NULL DEFAULT '',
|
|
`Contribution` int(11) NOT NULL DEFAULT 0,
|
|
`ListInProfile` int(4) NOT NULL DEFAULT 1,
|
|
`AcceptNotices` int(4) NOT NULL DEFAULT 1,
|
|
`AccessToken` char(36) NOT NULL DEFAULT ''
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `os_groups_notices`
|
|
--
|
|
|
|
CREATE TABLE `os_groups_notices` (
|
|
`GroupID` char(36) NOT NULL DEFAULT '',
|
|
`NoticeID` char(36) NOT NULL DEFAULT '',
|
|
`TMStamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`FromName` varchar(255) NOT NULL DEFAULT '',
|
|
`Subject` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
|
|
`Message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
|
|
`HasAttachment` int(4) NOT NULL DEFAULT 0,
|
|
`AttachmentType` int(4) NOT NULL DEFAULT 0,
|
|
`AttachmentName` varchar(128) NOT NULL DEFAULT '',
|
|
`AttachmentItemID` char(36) NOT NULL DEFAULT '',
|
|
`AttachmentOwnerID` varchar(255) NOT NULL DEFAULT ''
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `os_groups_principals`
|
|
--
|
|
|
|
CREATE TABLE `os_groups_principals` (
|
|
`PrincipalID` varchar(255) NOT NULL DEFAULT '',
|
|
`ActiveGroupID` char(36) NOT NULL DEFAULT ''
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `os_groups_rolemembership`
|
|
--
|
|
|
|
CREATE TABLE `os_groups_rolemembership` (
|
|
`GroupID` char(36) NOT NULL DEFAULT '',
|
|
`RoleID` char(36) NOT NULL DEFAULT '',
|
|
`PrincipalID` varchar(255) NOT NULL DEFAULT ''
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `os_groups_roles`
|
|
--
|
|
|
|
CREATE TABLE `os_groups_roles` (
|
|
`GroupID` char(36) NOT NULL DEFAULT '',
|
|
`RoleID` char(36) NOT NULL DEFAULT '',
|
|
`Name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
|
|
`Description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
|
|
`Title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
|
|
`Powers` bigint(20) UNSIGNED NOT NULL DEFAULT 0
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `Presence`
|
|
--
|
|
|
|
CREATE TABLE `Presence` (
|
|
`UserID` varchar(255) NOT NULL,
|
|
`RegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`SessionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`SecureSessionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`LastSeen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `regions`
|
|
--
|
|
|
|
CREATE TABLE `regions` (
|
|
`uuid` varchar(36) NOT NULL,
|
|
`regionHandle` bigint(20) UNSIGNED NOT NULL,
|
|
`regionName` varchar(128) DEFAULT NULL,
|
|
`regionRecvKey` varchar(128) DEFAULT NULL,
|
|
`regionSendKey` varchar(128) DEFAULT NULL,
|
|
`regionSecret` varchar(128) DEFAULT NULL,
|
|
`regionDataURI` varchar(255) DEFAULT NULL,
|
|
`serverIP` varchar(64) DEFAULT NULL,
|
|
`serverPort` int(10) UNSIGNED DEFAULT NULL,
|
|
`serverURI` varchar(255) DEFAULT NULL,
|
|
`locX` int(10) UNSIGNED DEFAULT NULL,
|
|
`locY` int(10) UNSIGNED DEFAULT NULL,
|
|
`locZ` int(10) UNSIGNED DEFAULT NULL,
|
|
`eastOverrideHandle` bigint(20) UNSIGNED DEFAULT NULL,
|
|
`westOverrideHandle` bigint(20) UNSIGNED DEFAULT NULL,
|
|
`southOverrideHandle` bigint(20) UNSIGNED DEFAULT NULL,
|
|
`northOverrideHandle` bigint(20) UNSIGNED DEFAULT NULL,
|
|
`regionAssetURI` varchar(255) DEFAULT NULL,
|
|
`regionAssetRecvKey` varchar(128) DEFAULT NULL,
|
|
`regionAssetSendKey` varchar(128) DEFAULT NULL,
|
|
`regionUserURI` varchar(255) DEFAULT NULL,
|
|
`regionUserRecvKey` varchar(128) DEFAULT NULL,
|
|
`regionUserSendKey` varchar(128) DEFAULT NULL,
|
|
`regionMapTexture` varchar(36) DEFAULT NULL,
|
|
`serverHttpPort` int(10) DEFAULT NULL,
|
|
`serverRemotingPort` int(10) DEFAULT NULL,
|
|
`owner_uuid` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`originUUID` varchar(36) DEFAULT NULL,
|
|
`access` int(10) UNSIGNED DEFAULT 1,
|
|
`ScopeID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`sizeX` int(11) NOT NULL DEFAULT 0,
|
|
`sizeY` int(11) NOT NULL DEFAULT 0,
|
|
`flags` int(11) NOT NULL DEFAULT 0,
|
|
`last_seen` int(11) NOT NULL DEFAULT 0,
|
|
`PrincipalID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
|
|
`Token` varchar(255) NOT NULL,
|
|
`parcelMapTexture` varchar(36) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `tokens`
|
|
--
|
|
|
|
CREATE TABLE `tokens` (
|
|
`UUID` char(36) NOT NULL,
|
|
`token` varchar(255) NOT NULL,
|
|
`validity` datetime NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `totalsales`
|
|
--
|
|
|
|
CREATE TABLE `totalsales` (
|
|
`UUID` varchar(36) NOT NULL,
|
|
`user` varchar(36) NOT NULL,
|
|
`objectUUID` varchar(36) NOT NULL,
|
|
`type` int(10) NOT NULL,
|
|
`TotalCount` int(10) NOT NULL DEFAULT 0,
|
|
`TotalAmount` int(10) NOT NULL DEFAULT 0,
|
|
`time` int(11) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Rev.3';
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `transactions`
|
|
--
|
|
|
|
CREATE TABLE `transactions` (
|
|
`UUID` varchar(36) NOT NULL,
|
|
`sender` varchar(36) NOT NULL,
|
|
`receiver` varchar(36) NOT NULL,
|
|
`amount` int(10) NOT NULL,
|
|
`senderBalance` int(10) NOT NULL DEFAULT -1,
|
|
`receiverBalance` int(10) NOT NULL DEFAULT -1,
|
|
`objectUUID` varchar(36) DEFAULT NULL,
|
|
`objectName` varchar(255) DEFAULT NULL,
|
|
`regionHandle` varchar(36) NOT NULL,
|
|
`regionUUID` varchar(36) NOT NULL,
|
|
`type` int(10) NOT NULL,
|
|
`time` int(11) NOT NULL,
|
|
`secure` varchar(36) NOT NULL,
|
|
`status` tinyint(1) NOT NULL,
|
|
`commonName` varchar(128) NOT NULL,
|
|
`description` varchar(255) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Rev.12';
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `UserAccounts`
|
|
--
|
|
|
|
CREATE TABLE `UserAccounts` (
|
|
`PrincipalID` char(36) NOT NULL,
|
|
`ScopeID` char(36) NOT NULL,
|
|
`FirstName` varchar(64) NOT NULL,
|
|
`LastName` varchar(64) NOT NULL,
|
|
`Email` varchar(64) DEFAULT NULL,
|
|
`ServiceURLs` text DEFAULT NULL,
|
|
`Created` int(11) DEFAULT NULL,
|
|
`UserLevel` int(11) NOT NULL DEFAULT 0,
|
|
`UserFlags` int(11) NOT NULL DEFAULT 0,
|
|
`UserTitle` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
|
|
`active` int(11) NOT NULL DEFAULT 1
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `userdata`
|
|
--
|
|
|
|
CREATE TABLE `userdata` (
|
|
`UserId` char(36) NOT NULL,
|
|
`TagId` varchar(64) NOT NULL,
|
|
`DataKey` varchar(255) DEFAULT NULL,
|
|
`DataVal` varchar(255) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `userinfo`
|
|
--
|
|
|
|
CREATE TABLE `userinfo` (
|
|
`user` varchar(36) NOT NULL,
|
|
`simip` varchar(64) NOT NULL,
|
|
`avatar` varchar(50) NOT NULL,
|
|
`pass` varchar(36) NOT NULL DEFAULT '',
|
|
`type` tinyint(2) NOT NULL DEFAULT 0,
|
|
`class` tinyint(2) NOT NULL DEFAULT 0,
|
|
`serverurl` varchar(255) NOT NULL DEFAULT ''
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Rev.3';
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `usernotes`
|
|
--
|
|
|
|
CREATE TABLE `usernotes` (
|
|
`useruuid` varchar(36) NOT NULL,
|
|
`targetuuid` varchar(36) NOT NULL,
|
|
`notes` text NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `userpicks`
|
|
--
|
|
|
|
CREATE TABLE `userpicks` (
|
|
`pickuuid` varchar(36) NOT NULL,
|
|
`creatoruuid` varchar(36) NOT NULL,
|
|
`toppick` enum('true','false') NOT NULL,
|
|
`parceluuid` varchar(36) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`description` text NOT NULL,
|
|
`snapshotuuid` varchar(36) NOT NULL,
|
|
`user` varchar(255) NOT NULL,
|
|
`originalname` varchar(255) NOT NULL,
|
|
`simname` varchar(255) NOT NULL,
|
|
`posglobal` varchar(255) NOT NULL,
|
|
`sortorder` int(2) NOT NULL,
|
|
`enabled` enum('true','false') NOT NULL,
|
|
`gatekeeper` varchar(255) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `userprofile`
|
|
--
|
|
|
|
CREATE TABLE `userprofile` (
|
|
`useruuid` varchar(36) NOT NULL,
|
|
`profilePartner` varchar(36) NOT NULL,
|
|
`profileAllowPublish` binary(1) NOT NULL,
|
|
`profileMaturePublish` binary(1) NOT NULL,
|
|
`profileURL` varchar(255) NOT NULL,
|
|
`profileWantToMask` int(3) NOT NULL,
|
|
`profileWantToText` text NOT NULL,
|
|
`profileSkillsMask` int(3) NOT NULL,
|
|
`profileSkillsText` text NOT NULL,
|
|
`profileLanguages` text NOT NULL,
|
|
`profileImage` varchar(36) NOT NULL,
|
|
`profileAboutText` text NOT NULL,
|
|
`profileFirstImage` varchar(36) NOT NULL,
|
|
`profileFirstText` text NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `usersettings`
|
|
--
|
|
|
|
CREATE TABLE `usersettings` (
|
|
`useruuid` varchar(36) NOT NULL,
|
|
`imviaemail` enum('true','false') NOT NULL,
|
|
`visible` enum('true','false') NOT NULL,
|
|
`email` varchar(254) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
|
|
--
|
|
-- Indizes der exportierten Tabellen
|
|
--
|
|
|
|
--
|
|
-- Indizes für die Tabelle `AgentPrefs`
|
|
--
|
|
ALTER TABLE `AgentPrefs`
|
|
ADD PRIMARY KEY (`PrincipalID`),
|
|
ADD UNIQUE KEY `PrincipalID` (`PrincipalID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `assets`
|
|
--
|
|
ALTER TABLE `assets`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `auth`
|
|
--
|
|
ALTER TABLE `auth`
|
|
ADD PRIMARY KEY (`UUID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `Avatars`
|
|
--
|
|
ALTER TABLE `Avatars`
|
|
ADD PRIMARY KEY (`PrincipalID`,`Name`),
|
|
ADD KEY `PrincipalID` (`PrincipalID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `balances`
|
|
--
|
|
ALTER TABLE `balances`
|
|
ADD PRIMARY KEY (`user`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `classifieds`
|
|
--
|
|
ALTER TABLE `classifieds`
|
|
ADD PRIMARY KEY (`classifieduuid`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `Friends`
|
|
--
|
|
ALTER TABLE `Friends`
|
|
ADD PRIMARY KEY (`PrincipalID`(36),`Friend`(36)),
|
|
ADD KEY `PrincipalID` (`PrincipalID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `GridUser`
|
|
--
|
|
ALTER TABLE `GridUser`
|
|
ADD PRIMARY KEY (`UserID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `hg_traveling_data`
|
|
--
|
|
ALTER TABLE `hg_traveling_data`
|
|
ADD PRIMARY KEY (`SessionID`),
|
|
ADD KEY `UserID` (`UserID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `im_offline`
|
|
--
|
|
ALTER TABLE `im_offline`
|
|
ADD PRIMARY KEY (`ID`),
|
|
ADD KEY `PrincipalID` (`PrincipalID`),
|
|
ADD KEY `FromID` (`FromID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `inventoryfolders`
|
|
--
|
|
ALTER TABLE `inventoryfolders`
|
|
ADD PRIMARY KEY (`folderID`),
|
|
ADD KEY `inventoryfolders_agentid` (`agentID`),
|
|
ADD KEY `inventoryfolders_parentFolderid` (`parentFolderID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `inventoryitems`
|
|
--
|
|
ALTER TABLE `inventoryitems`
|
|
ADD PRIMARY KEY (`inventoryID`),
|
|
ADD KEY `inventoryitems_avatarid` (`avatarID`),
|
|
ADD KEY `inventoryitems_parentFolderid` (`parentFolderID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `MuteList`
|
|
--
|
|
ALTER TABLE `MuteList`
|
|
ADD UNIQUE KEY `AgentID_2` (`AgentID`,`MuteID`,`MuteName`),
|
|
ADD KEY `AgentID` (`AgentID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `os_groups_groups`
|
|
--
|
|
ALTER TABLE `os_groups_groups`
|
|
ADD PRIMARY KEY (`GroupID`),
|
|
ADD UNIQUE KEY `Name` (`Name`);
|
|
ALTER TABLE `os_groups_groups` ADD FULLTEXT KEY `Name_2` (`Name`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `os_groups_invites`
|
|
--
|
|
ALTER TABLE `os_groups_invites`
|
|
ADD PRIMARY KEY (`InviteID`),
|
|
ADD UNIQUE KEY `PrincipalGroup` (`GroupID`,`PrincipalID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `os_groups_membership`
|
|
--
|
|
ALTER TABLE `os_groups_membership`
|
|
ADD PRIMARY KEY (`GroupID`,`PrincipalID`),
|
|
ADD KEY `PrincipalID` (`PrincipalID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `os_groups_notices`
|
|
--
|
|
ALTER TABLE `os_groups_notices`
|
|
ADD PRIMARY KEY (`NoticeID`),
|
|
ADD KEY `GroupID` (`GroupID`),
|
|
ADD KEY `TMStamp` (`TMStamp`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `os_groups_principals`
|
|
--
|
|
ALTER TABLE `os_groups_principals`
|
|
ADD PRIMARY KEY (`PrincipalID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `os_groups_rolemembership`
|
|
--
|
|
ALTER TABLE `os_groups_rolemembership`
|
|
ADD PRIMARY KEY (`GroupID`,`RoleID`,`PrincipalID`),
|
|
ADD KEY `PrincipalID` (`PrincipalID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `os_groups_roles`
|
|
--
|
|
ALTER TABLE `os_groups_roles`
|
|
ADD PRIMARY KEY (`GroupID`,`RoleID`),
|
|
ADD KEY `GroupID` (`GroupID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `Presence`
|
|
--
|
|
ALTER TABLE `Presence`
|
|
ADD UNIQUE KEY `SessionID` (`SessionID`),
|
|
ADD KEY `UserID` (`UserID`),
|
|
ADD KEY `RegionID` (`RegionID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `regions`
|
|
--
|
|
ALTER TABLE `regions`
|
|
ADD PRIMARY KEY (`uuid`),
|
|
ADD KEY `regionName` (`regionName`),
|
|
ADD KEY `regionHandle` (`regionHandle`),
|
|
ADD KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`),
|
|
ADD KEY `ScopeID` (`ScopeID`),
|
|
ADD KEY `flags` (`flags`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `tokens`
|
|
--
|
|
ALTER TABLE `tokens`
|
|
ADD UNIQUE KEY `uuid_token` (`UUID`,`token`),
|
|
ADD KEY `UUID` (`UUID`),
|
|
ADD KEY `token` (`token`),
|
|
ADD KEY `validity` (`validity`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `totalsales`
|
|
--
|
|
ALTER TABLE `totalsales`
|
|
ADD PRIMARY KEY (`UUID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `transactions`
|
|
--
|
|
ALTER TABLE `transactions`
|
|
ADD PRIMARY KEY (`UUID`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `UserAccounts`
|
|
--
|
|
ALTER TABLE `UserAccounts`
|
|
ADD UNIQUE KEY `PrincipalID` (`PrincipalID`),
|
|
ADD KEY `Email` (`Email`),
|
|
ADD KEY `FirstName` (`FirstName`),
|
|
ADD KEY `LastName` (`LastName`),
|
|
ADD KEY `Name` (`FirstName`,`LastName`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `userdata`
|
|
--
|
|
ALTER TABLE `userdata`
|
|
ADD PRIMARY KEY (`UserId`,`TagId`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `userinfo`
|
|
--
|
|
ALTER TABLE `userinfo`
|
|
ADD PRIMARY KEY (`user`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `usernotes`
|
|
--
|
|
ALTER TABLE `usernotes`
|
|
ADD UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `userpicks`
|
|
--
|
|
ALTER TABLE `userpicks`
|
|
ADD PRIMARY KEY (`pickuuid`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `userprofile`
|
|
--
|
|
ALTER TABLE `userprofile`
|
|
ADD PRIMARY KEY (`useruuid`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `usersettings`
|
|
--
|
|
ALTER TABLE `usersettings`
|
|
ADD PRIMARY KEY (`useruuid`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT für exportierte Tabellen
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT für Tabelle `im_offline`
|
|
--
|
|
ALTER TABLE `im_offline`
|
|
MODIFY `ID` mediumint(9) NOT NULL AUTO_INCREMENT;
|
|
COMMIT;
|
|
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|