admin area

DB-Structure

For database management we've include a current version of adminer.php in /admin/adminer.php.

The documentation can be found here: https://www.adminer.org/

This is the schema of the current database:

database schema

This is a dump of the structure of the sql-tables:

CREATE TABLE `groups` (
                      `id` int NOT NULL,
                      `hidden` int NOT NULL DEFAULT '0',
                      `deleted` int NOT NULL DEFAULT '0',
                      `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                      `tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                      `position_via` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                      `position_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                      `position_x` int NOT NULL DEFAULT '0',
                      `position_y` int NOT NULL DEFAULT '0',
                      `rotation` int NOT NULL DEFAULT '0',
                      `collision_area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                      `collision_area_x` int NOT NULL DEFAULT '0',
                      `collision_area_y` int NOT NULL DEFAULT '0',
                      `collision_area_radius` int NOT NULL DEFAULT '0',
                      `collision_area_width` int NOT NULL DEFAULT '0',
                      `collision_area_height` int NOT NULL DEFAULT '0',
                      `shadow_texture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                      `shadow_area_x` int NOT NULL DEFAULT '0',
                      `shadow_area_width` int NOT NULL DEFAULT '0',
                      `shadow_area_height` int NOT NULL DEFAULT '0',
                      `shadow_area_y` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `infos` (
                     `id` int NOT NULL,
                     `type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
                     `text` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
                     `position` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

CREATE TABLE `layers` (
                      `id` int NOT NULL,
                      `deleted` int NOT NULL DEFAULT '0',
                      `object_id` int NOT NULL,
                      `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                      `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                      `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                      `year` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                      `material` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                      `dimensions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                      `lender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                      `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `media` (
                     `id` int NOT NULL,
                     `layer_id` int NOT NULL,
                     `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                     `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                     `vimeo_id` int NOT NULL,
                     `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `objects` (
                       `id` int NOT NULL,
                       `deleted` int NOT NULL DEFAULT '0',
                       `group_id` int NOT NULL,
                       `file_3D` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                       `file_highres_3D` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                       `position_x` int DEFAULT '0',
                       `position_y` int NOT NULL DEFAULT '0',
                       `rotation` int NOT NULL DEFAULT '0',
                       `interaction_area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                       `interaction_area_x` int NOT NULL DEFAULT '0',
                       `interaction_area_y` int NOT NULL DEFAULT '0',
                       `interaction_area_radius` int NOT NULL DEFAULT '0',
                       `interaction_area_width` int NOT NULL DEFAULT '0',
                       `interaction_area_height` int NOT NULL DEFAULT '0',
                       `detail_view` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                       `detail_view_x` int NOT NULL DEFAULT '0',
                       `detail_view_y` int NOT NULL DEFAULT '0',
                       `detail_view_z` int NOT NULL DEFAULT '0',
                       `detail_view_distance` int NOT NULL DEFAULT '0',
                       `detail_view_extern` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
                       `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                       `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                       `year` int NOT NULL DEFAULT '0',
                       `material` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                       `dimensions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                       `lender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
                       `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `tag_values` (
                          `group_id` int NOT NULL,
                          `tag_id` int NOT NULL,
                          `value` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `groups`
    ADD PRIMARY KEY (`id`);

ALTER TABLE `infos`
    ADD PRIMARY KEY (`id`);

ALTER TABLE `layers`
    ADD PRIMARY KEY (`id`),
    ADD KEY `object_id` (`object_id`);

ALTER TABLE `media`
    ADD PRIMARY KEY (`id`),
    ADD KEY `layer_id` (`layer_id`);

ALTER TABLE `objects`
    ADD PRIMARY KEY (`id`),
    ADD KEY `group_id` (`group_id`);

ALTER TABLE `tag_values`
    ADD PRIMARY KEY (`group_id`,`tag_id`);

ALTER TABLE `groups`
    MODIFY `id` int NOT NULL AUTO_INCREMENT;

ALTER TABLE `infos`
    MODIFY `id` int NOT NULL AUTO_INCREMENT;

ALTER TABLE `layers`
    MODIFY `id` int NOT NULL AUTO_INCREMENT;

ALTER TABLE `media`
    MODIFY `id` int NOT NULL AUTO_INCREMENT;

ALTER TABLE `objects`
    MODIFY `id` int NOT NULL AUTO_INCREMENT;

ALTER TABLE `layers`
    ADD CONSTRAINT `layer_object_constraint` FOREIGN KEY (`object_id`) REFERENCES `objects` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

ALTER TABLE `media`
    ADD CONSTRAINT `media_layer_constraint` FOREIGN KEY (`layer_id`) REFERENCES `layers` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

ALTER TABLE `objects`
    ADD CONSTRAINT `object_group_constraint` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;

ALTER TABLE `tag_values`
    ADD CONSTRAINT `tag_value_group_constraint` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
COMMIT;

Search results