mirror of
https://github.com/stashapp/stash.git
synced 2025-12-06 08:26:00 +01:00
bcf0fda7ac
* Add UI support for setting containing groups * Show containing groups in group details panel * Move tag hierarchical filter code into separate type * Add depth to scene_count and add sub_group_count * Add sub-groups tab to groups page * Add containing groups to edit groups dialog * Show containing group description in sub-group view * Show group scene number in group scenes view * Add ability to drag move grid cards * Add sub group order option * Add reorder sub-groups interface * Separate page size selector component * Add interfaces to add and remove sub-groups to a group * Separate MultiSet components * Allow setting description while setting containing groups
13 lines
594 B
SQL
13 lines
594 B
SQL
CREATE TABLE `groups_relations` (
|
|
`containing_id` integer not null,
|
|
`sub_id` integer not null,
|
|
`order_index` integer not null,
|
|
`description` varchar(255),
|
|
primary key (`containing_id`, `sub_id`),
|
|
foreign key (`containing_id`) references `groups`(`id`) on delete cascade,
|
|
foreign key (`sub_id`) references `groups`(`id`) on delete cascade,
|
|
check (`containing_id` != `sub_id`)
|
|
);
|
|
|
|
CREATE INDEX `index_groups_relations_sub_id` ON `groups_relations` (`sub_id`);
|
|
CREATE UNIQUE INDEX `index_groups_relations_order_index_unique` ON `groups_relations` (`containing_id`, `order_index`);
|