From 19938f25e1157140d648d74f350edaea94106825 Mon Sep 17 00:00:00 2001 From: APTX Date: Tue, 24 Jul 2012 01:24:44 +0200 Subject: [PATCH] OP is not an episode type --- localmylist/share/schema/default_config.sql | 1 - localmylist/share/schema/schema.sql | 2 +- 2 files changed, 1 insertion(+), 2 deletions(-) diff --git a/localmylist/share/schema/default_config.sql b/localmylist/share/schema/default_config.sql index 633b699..c0d587e 100644 --- a/localmylist/share/schema/default_config.sql +++ b/localmylist/share/schema/default_config.sql @@ -33,4 +33,3 @@ INSERT INTO episode_type VALUES ('C', 'Credits/Opening/Ending', 2); INSERT INTO episode_type VALUES ('T', 'Trailer/Promo/Ads', 3); INSERT INTO episode_type VALUES ('P', 'Parody/Fandub', 4); INSERT INTO episode_type VALUES ('O', 'Other', 5); -INSERT INTO episode_type VALUES ('OP', 'Opening/Ending', 6); diff --git a/localmylist/share/schema/schema.sql b/localmylist/share/schema/schema.sql index 0bbfe24..e7c274c 100644 --- a/localmylist/share/schema/schema.sql +++ b/localmylist/share/schema/schema.sql @@ -1,5 +1,5 @@ DROP TYPE IF EXISTS episode_type_enum; -CREATE TYPE episode_type_enum AS ENUM ('', 'S', 'C', 'T', 'P', 'O', 'OP'); +CREATE TYPE episode_type_enum AS ENUM ('', 'S', 'C', 'T', 'P', 'O'); CREATE TABLE anime ( aid integer NOT NULL, -- 2.52.0