mirror of
https://github.com/stashapp/stash.git
synced 2025-12-06 08:26:00 +01:00
964b559309
* Add new txn manager interface * Add txn management to sqlite * Rename get to getByID * Add contexts to repository methods * Update query builders * Add context to reader writer interfaces * Use repository in resolver * Tighten interfaces * Tighten interfaces in dlna * Tighten interfaces in match package * Tighten interfaces in scraper package * Tighten interfaces in scan code * Tighten interfaces on autotag package * Remove ReaderWriter usage * Merge database package into sqlite
7 lines
245 B
SQL
7 lines
245 B
SQL
CREATE TABLE `studio_aliases` (
|
|
`studio_id` integer,
|
|
`alias` varchar(255) NOT NULL,
|
|
foreign key(`studio_id`) references `studios`(`id`) on delete CASCADE
|
|
);
|
|
|
|
CREATE UNIQUE INDEX `studio_aliases_alias_unique` on `studio_aliases` (`alias`);
|