Esempio n. 1
0
File: upgrade.py Progetto: boxed/CMi
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")
Esempio n. 2
0
def upgrade_1():
    run_sql('ALTER TABLE tvshows_show ADD COLUMN "auto_erase" bool NOT NULL DEFAULT 1')
Esempio n. 3
0
File: upgrade.py Progetto: boxed/CMi
def upgrade_5():
    run_sql('ALTER TABLE "tvshows_show" ADD COLUMN "category_id" integer REFERENCES "tvshows_category" ("id")')
Esempio n. 4
0
File: upgrade.py Progetto: boxed/CMi
def upgrade_6():
    run_sql('ALTER TABLE "tvshows_episode" ADD COLUMN "watched_at" DATETIME NOT NULL DEFAULT "1970-01-01 00:00:00"')
Esempio n. 5
0
File: upgrade.py Progetto: boxed/CMi
def upgrade_3():
    run_sql('ALTER TABLE tvshows_show ADD COLUMN "source" VARCHAR(255) NOT NULL DEFAULT ""')
Esempio n. 6
0
File: upgrade.py Progetto: boxed/CMi
def upgrade_4():
    run_sql('ALTER TABLE tvshows_show ADD COLUMN "ended" bool NOT NULL DEFAULT 0')
Esempio n. 7
0
File: upgrade.py Progetto: boxed/CMi
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')
Esempio n. 8
0
File: upgrade.py Progetto: boxed/CMi
def upgrade_6():
    run_sql(
        'ALTER TABLE "tvshows_episode" ADD COLUMN "watched_at" DATETIME NOT NULL DEFAULT "1970-01-01 00:00:00"'
    )
Esempio n. 9
0
File: upgrade.py Progetto: boxed/CMi
def upgrade_5():
    run_sql(
        'ALTER TABLE "tvshows_show" ADD COLUMN "category_id" integer REFERENCES "tvshows_category" ("id")'
    )
Esempio n. 10
0
File: upgrade.py Progetto: boxed/CMi
def upgrade_4():
    run_sql(
        'ALTER TABLE tvshows_show ADD COLUMN "ended" bool NOT NULL DEFAULT 0')
Esempio n. 11
0
File: upgrade.py Progetto: boxed/CMi
def upgrade_3():
    run_sql(
        'ALTER TABLE tvshows_show ADD COLUMN "source" VARCHAR(255) NOT NULL DEFAULT ""'
    )