Exemple #1
0
def upgrade_2():
    run_sql('ALTER TABLE tvshows_episode ADD COLUMN "watched_count" INTEGER default 0')
    run_sql("UPDATE tvshows_episode SET watched_count = watched")
Exemple #2
0
def upgrade_1():
    run_sql('ALTER TABLE tvshows_show ADD COLUMN "auto_erase" bool NOT NULL DEFAULT 1')
Exemple #3
0
def upgrade_5():
    run_sql('ALTER TABLE "tvshows_show" ADD COLUMN "category_id" integer REFERENCES "tvshows_category" ("id")')
Exemple #4
0
def upgrade_6():
    run_sql('ALTER TABLE "tvshows_episode" ADD COLUMN "watched_at" DATETIME NOT NULL DEFAULT "1970-01-01 00:00:00"')
Exemple #5
0
def upgrade_3():
    run_sql('ALTER TABLE tvshows_show ADD COLUMN "source" VARCHAR(255) NOT NULL DEFAULT ""')
Exemple #6
0
def upgrade_4():
    run_sql('ALTER TABLE tvshows_show ADD COLUMN "ended" bool NOT NULL DEFAULT 0')
Exemple #7
0
def upgrade_2():
    run_sql(
        'ALTER TABLE tvshows_episode ADD COLUMN "watched_count" INTEGER default 0'
    )
    run_sql('UPDATE tvshows_episode SET watched_count = watched')
Exemple #8
0
def upgrade_6():
    run_sql(
        'ALTER TABLE "tvshows_episode" ADD COLUMN "watched_at" DATETIME NOT NULL DEFAULT "1970-01-01 00:00:00"'
    )
Exemple #9
0
def upgrade_5():
    run_sql(
        'ALTER TABLE "tvshows_show" ADD COLUMN "category_id" integer REFERENCES "tvshows_category" ("id")'
    )
Exemple #10
0
def upgrade_4():
    run_sql(
        'ALTER TABLE tvshows_show ADD COLUMN "ended" bool NOT NULL DEFAULT 0')
Exemple #11
0
def upgrade_3():
    run_sql(
        'ALTER TABLE tvshows_show ADD COLUMN "source" VARCHAR(255) NOT NULL DEFAULT ""'
    )