path: root/db/blossom.sqlite-wal

7�-���js�"��HR
����T
��js�"��T�]^q�SQLite format 3@  

.[2
�����)
--
�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��js�"���H�b�w
��js�"��@�M���a

��js�"��$�<N���SQLite format 3@  

.[2
����
�V��V
��
	|�	E����##
�Utablenotes_medianotes_mediaCREATE TABLE notes_media (
    note_id integer not null, 
    media_id integer not null,
    foreign key (note_id) references notes(note_id),
    foreign key (media_id) references media(id),
    primary key (note_id, media_id)
)5I#
indexsqlite_autoindex_notes_media_1notes_media�a
�!tablemediamediaCREATE TABLE media (
    id integer not null primary key autoincrement,
    media_type varchar(32) not null,
    source varchar(128) not null,
    foreign key (media_type) references media_types(name)
)i
##
�tablemedia_typesmedia_typesCREATE TABLE media_types (
    name varchar(32) not null primary key
)5I#
indexsqlite_autoindex_media_types_1media_types�
�wtablenotesnotes
CREATE TABLE notes (
    post_id integer not null,
    content text,
    foreign key (post_id) references posts(id)
)�D
�[tablearticlesarticlesCREATE TABLE articles (
    post_id integer not null,
    source varchar(128) not null,
    hash varchar(64) not null,
    foreign key (post_id) references posts(id)
)�u	!!
�5tableposts_tagsposts_tags
CREATE TABLE posts_tags (
    post_id integer not null,
    tag varchar(128) not null,
    foreign key (post_id) references posts(id),
    foreign key (tag) references tags(name),
    primary key (post_id, tag)
)3
G!
indexsqlite_autoindex_posts_tags_1posts_tagsU
�
tabletagstagsCREATE TABLE tags (
    name varchar(128) not null primary key
)';
indexsqlite_autoindex_tags_1tags	P++
Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�
�tablepostspostsCREATE TABLE posts (
    id integer not null primary key autoincrement,
    created_at bigint not null default (unixepoch()),
    updated_at bigint,
    post_type varchar(32) not null default ('note'),
    foreign key (post_type) references post_types(name)
)f!!
�tablepost_typespost_typesCREATE TABLE post_types (
    name varchar(32) not null primary key
)3G!
indexsqlite_autoindex_post_types_1post_types�)
--
�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��js�"�󍿓Y��1
���note	
article��js�"��[�
y&��.
���
note
	article��js�"��,W���
��js�"��;(TU'��h
��js�"��rG�-��
	��js�"��t�:K�]�

��js�"���W�Q�Qk�
��js�"��Z�3���3r
��js�"��O8�|P�q

��js�"��d9�}��c
��js�"��ͼʠ�X
����audiovideo
image��js�"��;�V(�%
����	
audio	
video	image��js�"�����w�x
��js�"��r���F|/W
��js�"���qy>�hc�
��js�"��.ؔ�Ս��

��Z
3	lf6��[blossom2023-02-19 02:11:40�\���]��>�i�ZX�};��"�Nr�W��9Ѥ�� q�[�y����js�"��\OB0�

��		f6��[