migrations.toml

# This file is auto-generated by Turbosql.
# It is used to create and apply automatic schema migrations.
# It should be checked into source control.
# Modifying it by hand may be dangerous; see the docs.

migrations_append_only = [
  'CREATE TABLE pdf (rowid INTEGER PRIMARY KEY)',
  'ALTER TABLE pdf ADD COLUMN id INTEGER',
  'ALTER TABLE pdf ADD COLUMN name TEXT',
  'ALTER TABLE pdf ADD COLUMN content TEXT',
  'ALTER TABLE pdf ADD COLUMN filesize INTEGER',
  'CREATE TABLE card (rowid INTEGER PRIMARY KEY)',
  'ALTER TABLE card ADD COLUMN id INTEGER',
  'ALTER TABLE card ADD COLUMN filesize INTEGER',
  'ALTER TABLE card ADD COLUMN name TEXT',
  'ALTER TABLE card ADD COLUMN content TEXT',
  'ALTER TABLE card ADD COLUMN created_time REAL',
  'ALTER TABLE card ADD COLUMN modified_time REAL',
  'ALTER TABLE card ADD COLUMN last_display_time REAL',
  'ALTER TABLE card ADD COLUMN next_display_time REAL',
  'ALTER TABLE card ADD COLUMN answer TEXT',
  'ALTER TABLE card ADD COLUMN presentation_order INTEGER',
  'CREATE TABLE cardlist (rowid INTEGER PRIMARY KEY)',
  'ALTER TABLE cardlist ADD COLUMN list TEXT',
  'ALTER TABLE cardlist ADD COLUMN created_time REAL',
  'CREATE TABLE log (rowid INTEGER PRIMARY KEY)',
  'ALTER TABLE log ADD COLUMN entry TEXT',
  'ALTER TABLE log ADD COLUMN created_time REAL',
  'CREATE TABLE turbocafeentry (rowid INTEGER PRIMARY KEY)',
  'ALTER TABLE turbocafeentry ADD COLUMN hash TEXT',
  'ALTER TABLE turbocafeentry ADD COLUMN data BLOB',
  '-- Change to new timestamp format:',
  'CREATE TABLE new_cardlist (rowid INTEGER PRIMARY KEY, list TEXT, created_time INTEGER)',
  'INSERT INTO new_cardlist SELECT rowid, list, cast(created_time * 1000 as int) FROM cardlist',
  'DROP TABLE cardlist',
  'ALTER TABLE new_cardlist RENAME TO cardlist',
  '--ALTER TABLE cardlist ADD COLUMN created_time INTEGER',
  'CREATE TABLE new_card (rowid INTEGER PRIMARY KEY, content TEXT, answer TEXT, created_time INTEGER, modified_time INTEGER, last_display_time INTEGER, next_display_time INTEGER)',
  'INSERT INTO new_card SELECT rowid, content, answer, cast(created_time * 1000 as int), cast(modified_time * 1000 as int), cast(last_display_time * 1000 as int), cast(next_display_time * 1000 as int) FROM card',
  'DROP TABLE card',
  'ALTER TABLE new_card RENAME TO card',
  '--ALTER TABLE card ADD COLUMN created_time INTEGER',
  '--ALTER TABLE card ADD COLUMN modified_time INTEGER',
  '--ALTER TABLE card ADD COLUMN last_display_time INTEGER',
  '--ALTER TABLE card ADD COLUMN next_display_time INTEGER',
  'DROP TABLE turbocafeentry',
  'CREATE TABLE _turbocafe_entry (rowid INTEGER PRIMARY KEY)',
  'ALTER TABLE _turbocafe_entry ADD COLUMN hash TEXT',
  'ALTER TABLE _turbocafe_entry ADD COLUMN content BLOB',
  'CREATE TABLE component_instantiation_data (rowid INTEGER PRIMARY KEY)',
  'ALTER TABLE component_instantiation_data ADD COLUMN component_id TEXT',
  'ALTER TABLE component_instantiation_data ADD COLUMN instantiation_id TEXT',
  'ALTER TABLE component_instantiation_data ADD COLUMN data_string_1 TEXT',
  'ALTER TABLE component_instantiation_data ADD COLUMN data_blob_1 BLOB',
  'ALTER TABLE component_instantiation_data ADD COLUMN data_i54_1 INTEGER',
  'ALTER TABLE component_instantiation_data ADD COLUMN data_i54_2 INTEGER',
  'ALTER TABLE card ADD COLUMN component_id TEXT',
  'ALTER TABLE card ADD COLUMN instantiation_id TEXT',
  'CREATE TABLE _turbotime_entry (rowid INTEGER PRIMARY KEY)',
  'ALTER TABLE _turbotime_entry ADD COLUMN timestamp INTEGER',
  'ALTER TABLE _turbotime_entry ADD COLUMN instantiation_id TEXT',
  'ALTER TABLE _turbotime_entry ADD COLUMN steps TEXT',
  'DROP TABLE log',
  'CREATE TABLE log (rowid INTEGER PRIMARY KEY)',
  'ALTER TABLE log ADD COLUMN entry TEXT',
  'ALTER TABLE log ADD COLUMN created_time INTEGER',
]
output_generated_schema_for_your_information_do_not_edit = '''
  CREATE TABLE "card" (
    rowid INTEGER PRIMARY KEY,
    content TEXT,
    answer TEXT,
    created_time INTEGER,
    modified_time INTEGER,
    last_display_time INTEGER,
    next_display_time INTEGER,
    component_id TEXT,
    instantiation_id TEXT
  )
  CREATE TABLE "cardlist" (
    rowid INTEGER PRIMARY KEY,
    list TEXT,
    created_time INTEGER
  )
  CREATE TABLE _turbocafe_entry (
    rowid INTEGER PRIMARY KEY,
    hash TEXT,
    content BLOB
  )
  CREATE TABLE _turbosql_migrations (
    rowid INTEGER PRIMARY KEY,
    migration TEXT NOT NULL
  )
  CREATE TABLE _turbotime_entry (
    rowid INTEGER PRIMARY KEY,
    timestamp INTEGER,
    instantiation_id TEXT,
    steps TEXT
  )
  CREATE TABLE component_instantiation_data (
    rowid INTEGER PRIMARY KEY,
    component_id TEXT,
    instantiation_id TEXT,
    data_string_1 TEXT,
    data_blob_1 BLOB,
    data_i54_1 INTEGER,
    data_i54_2 INTEGER
  )
  CREATE TABLE log (
    rowid INTEGER PRIMARY KEY,
    entry TEXT,
    created_time INTEGER
  )
  CREATE TABLE pdf (
    rowid INTEGER PRIMARY KEY,
    id INTEGER,
    name TEXT,
    content TEXT,
    filesize INTEGER
  )
'''
[output_generated_tables_do_not_edit._turbocafe_entry]
name = '_turbocafe_entry'

[[output_generated_tables_do_not_edit._turbocafe_entry.columns]]
name = 'rowid'
rust_type = 'Option < i64 >'
sql_type = 'INTEGER PRIMARY KEY'

[[output_generated_tables_do_not_edit._turbocafe_entry.columns]]
name = 'hash'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[[output_generated_tables_do_not_edit._turbocafe_entry.columns]]
name = 'content'
rust_type = 'Option < Blob >'
sql_type = 'BLOB'

[output_generated_tables_do_not_edit._turbotime_entry]
name = '_turbotime_entry'

[[output_generated_tables_do_not_edit._turbotime_entry.columns]]
name = 'rowid'
rust_type = 'Option < i64 >'
sql_type = 'INTEGER PRIMARY KEY'

[[output_generated_tables_do_not_edit._turbotime_entry.columns]]
name = 'timestamp'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER'

[[output_generated_tables_do_not_edit._turbotime_entry.columns]]
name = 'instantiation_id'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[[output_generated_tables_do_not_edit._turbotime_entry.columns]]
name = 'steps'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[output_generated_tables_do_not_edit.card]
name = 'card'

[[output_generated_tables_do_not_edit.card.columns]]
name = 'rowid'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER PRIMARY KEY'

[[output_generated_tables_do_not_edit.card.columns]]
name = 'content'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[[output_generated_tables_do_not_edit.card.columns]]
name = 'answer'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[[output_generated_tables_do_not_edit.card.columns]]
name = 'component_id'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[[output_generated_tables_do_not_edit.card.columns]]
name = 'instantiation_id'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[[output_generated_tables_do_not_edit.card.columns]]
name = 'created_time'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER'

[[output_generated_tables_do_not_edit.card.columns]]
name = 'modified_time'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER'

[[output_generated_tables_do_not_edit.card.columns]]
name = 'last_display_time'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER'

[[output_generated_tables_do_not_edit.card.columns]]
name = 'next_display_time'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER'

[output_generated_tables_do_not_edit.cardlist]
name = 'cardlist'

[[output_generated_tables_do_not_edit.cardlist.columns]]
name = 'rowid'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER PRIMARY KEY'

[[output_generated_tables_do_not_edit.cardlist.columns]]
name = 'list'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[[output_generated_tables_do_not_edit.cardlist.columns]]
name = 'created_time'
rust_type = 'Option < i64 >'
sql_type = 'INTEGER'

[output_generated_tables_do_not_edit.component_instantiation_data]
name = 'component_instantiation_data'

[[output_generated_tables_do_not_edit.component_instantiation_data.columns]]
name = 'rowid'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER PRIMARY KEY'

[[output_generated_tables_do_not_edit.component_instantiation_data.columns]]
name = 'component_id'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[[output_generated_tables_do_not_edit.component_instantiation_data.columns]]
name = 'instantiation_id'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[[output_generated_tables_do_not_edit.component_instantiation_data.columns]]
name = 'data_string_1'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[[output_generated_tables_do_not_edit.component_instantiation_data.columns]]
name = 'data_blob_1'
rust_type = 'Option < Blob >'
sql_type = 'BLOB'

[[output_generated_tables_do_not_edit.component_instantiation_data.columns]]
name = 'data_i54_1'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER'

[[output_generated_tables_do_not_edit.component_instantiation_data.columns]]
name = 'data_i54_2'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER'

[output_generated_tables_do_not_edit.log]
name = 'log'

[[output_generated_tables_do_not_edit.log.columns]]
name = 'rowid'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER PRIMARY KEY'

[[output_generated_tables_do_not_edit.log.columns]]
name = 'entry'
rust_type = 'Option < String >'
sql_type = 'TEXT'

[[output_generated_tables_do_not_edit.log.columns]]
name = 'created_time'
rust_type = 'Option < i54 >'
sql_type = 'INTEGER'