📦 hediet / slideo

📄 slideo-dev.db · 44 lines
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44SQLite format 3@  .G�
�b��
:
�!���
��	�
�b	��'))�	tablevideos_mappingvideos_mappingCREATE TABLE videos_mapping (
    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    video_id INTEGER NOT NULL REFERENCES videos (id) ON DELETE CASCADE,
    video_ms INTEGER NOT NULL,
    pdf_hash TEXT,
    page INTEGER,
    UNIQUE (video_id, video_ms)
);O)indexsqlite_autoindex_videos_mapping_1videos_mapping�v##�3tablevideos_pdfsvideos_pdfs
CREATE TABLE videos_pdfs (
    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    video_id INTEGER NOT NULL REFERENCES videos (id) ON DELETE CASCADE,
    pdf_hash TEXT NOT NULL,
    UNIQUE (video_id, pdf_hash)
)5
I#indexsqlite_autoindex_videos_pdfs_1videos_pdfs�&
�'tablevideosvideosCREATE TABLE videos (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    video_hash TEXT NOT NULL UNIQUE,
    finished BOOLEAN NOT NULL
)+?indexsqlite_autoindex_videos_1videosP	++Ytablesqlite_sequencesqlite_sequence
CREATE TABLE sqlite_sequence(name,seq)�"�#tablefilesfilesCREATE TABLE files (
    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
    file_path TEXT UNIQUE NOT NULL,
    hash TEXT UNIQUE NOT NULL
))=indexsqlite_autoindex_files_2files	)=indexsqlite_autoindex_files_1files�J==�'tablepdf_extracted_pages_dirspdf_extracted_pages_dirsCREATE TABLE pdf_extracted_pages_dirs (
    pdf_hash TEXT PRIMARY KEY NOT NULL,
    dir TEXT NOT NULL UNIQUE,
    finished BOOLEAN NOT NULL
)Oc=indexsqlite_autoindex_pdf_extracted_pages_dirs_2pdf_extracted_pages_dirsOc=indexsqlite_autoindex_pdf_extracted_pages_dirs_1pdf_extracted_pages_dirs�)--�table_sqlx_migrations_sqlx_migrationsCREATE TABLE _sqlx_migrations (
    version BIGINT PRIMARY KEY,
    description TEXT NOT NULL,
    installed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    success BOOLEAN NOT NULL,
    checksum BLOB NOT NULL,
    execution_time BIGINT NOT NULL
)?S-indexsqlite_autoindex__sqlx_migrations_1_sqlx_migrations
��X3	la�KYVsetup2021-03-12 16:57:47d��ј낟yyq7ǁ؝[�
��?��h�v����݊B"����>�h({�
��		a�KYV