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")
def upgrade_1():
run_sql('ALTER TABLE tvshows_show ADD COLUMN "auto_erase" bool NOT NULL DEFAULT 1')
def upgrade_5():
run_sql('ALTER TABLE "tvshows_show" ADD COLUMN "category_id" integer REFERENCES "tvshows_category" ("id")')
def upgrade_6():
run_sql('ALTER TABLE "tvshows_episode" ADD COLUMN "watched_at" DATETIME NOT NULL DEFAULT "1970-01-01 00:00:00"')
def upgrade_3():
run_sql('ALTER TABLE tvshows_show ADD COLUMN "source" VARCHAR(255) NOT NULL DEFAULT ""')
def upgrade_4():
run_sql('ALTER TABLE tvshows_show ADD COLUMN "ended" bool NOT NULL DEFAULT 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')
def upgrade_6():
run_sql(
'ALTER TABLE "tvshows_episode" ADD COLUMN "watched_at" DATETIME NOT NULL DEFAULT "1970-01-01 00:00:00"'
)
def upgrade_5():
run_sql(
'ALTER TABLE "tvshows_show" ADD COLUMN "category_id" integer REFERENCES "tvshows_category" ("id")'
)
def upgrade_4():
run_sql(
'ALTER TABLE tvshows_show ADD COLUMN "ended" bool NOT NULL DEFAULT 0')
def upgrade_3():
run_sql(
'ALTER TABLE tvshows_show ADD COLUMN "source" VARCHAR(255) NOT NULL DEFAULT ""'
)