File indexing completed on 2025-02-23 04:29:35
0001 -- SPDX-FileCopyrightText: 2022 Jonah Brüchert <jbb@kaidan.im> 0002 -- 0003 -- SPDX-License-Identifier: GPL-2.0-only OR GPL-3.0-only OR LicenseRef-KDE-Accepted-GPL 0004 0005 create table songs ( 0006 video_id Text primary key not null, 0007 title Text not null, 0008 artist Text, 0009 album Text 0010 ); 0011 0012 create table played_songs ( 0013 video_id Text primary key not null, 0014 plays Int not null, 0015 foreign key (video_id) references songs(video_id) 0016 ); 0017 0018 create table favourites ( 0019 video_id Text primary key not null, 0020 foreign key (video_id) references songs(video_id) 0021 ); 0022 0023 create table searches ( 0024 search_id integer primary key autoincrement not null, 0025 search_query Text not null 0026 );