schema

package

v0.0.34 Latest Latest Go to latest Published: Mar 23, 2026 License: BSD-3-Clause Imports: 2 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/chapmanjacobd/discoteca

Links

Open Source Insights

Documentation ¶

Constants ¶

This section is empty.

Variables ¶

View Source

var SchemaFS embed.FS

Functions ¶

func GetCaptionsFTS ¶

func GetCaptionsFTS() string

GetCaptionsFTS returns the captions FTS SQL

func GetCaptionsTable ¶

func GetCaptionsTable() string

GetCaptionsTable returns the captions table SQL

func GetCoreIndexes ¶

func GetCoreIndexes() string

GetCoreIndexes returns the SQL to create core indexes (media indexes)

func GetCoreTables ¶

func GetCoreTables() string

GetCoreTables returns the SQL to create all core tables (media, playlists, history, meta)

func GetFTSTables ¶

func GetFTSTables() string

GetFTSTables returns the SQL to create FTS tables (media, captions) Note: Call GetCaptionsTable first if you want captions FTS

func GetHistoryTable ¶

func GetHistoryTable() string

GetHistoryTable returns the history table and indexes SQL

func GetMediaFTS ¶

func GetMediaFTS() string

GetMediaFTS returns the media FTS SQL

func GetMediaIndexes ¶

func GetMediaIndexes() string

GetMediaIndexes returns the media indexes SQL

func GetMediaTable ¶

func GetMediaTable() string

GetMediaTable returns the media table SQL

func GetMetaTables ¶

func GetMetaTables() string

GetMetaTables returns the metadata tables SQL

func GetPlaylistsTables ¶

func GetPlaylistsTables() string

GetPlaylistsTables returns the playlists tables SQL

func GetSchema ¶

func GetSchema() string

GetSchema returns the complete database schema SQL (Legacy/Full) This includes EVERYTHING: core tables, indexes, captions, and FTS. Useful for backward compatibility or tests that expect a full DB.

Types ¶

This section is empty.

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL