blob: ddb0456372ba4a6ba3a1475836a4e6c86906bf66 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
ALTER TABLE wikidata ALTER COLUMN website TYPE text[] USING CASE WHEN website IS NULL THEN NULL ELSE ARRAY[website ] END;
ALTER TABLE wikidata ALTER COLUMN vndb TYPE text[] USING CASE WHEN vndb IS NULL THEN NULL ELSE ARRAY[vndb ] END;
ALTER TABLE wikidata ALTER COLUMN mobygames TYPE text[] USING CASE WHEN mobygames IS NULL THEN NULL ELSE ARRAY[mobygames ] END;
ALTER TABLE wikidata ALTER COLUMN mobygames_company TYPE text[] USING CASE WHEN mobygames_company IS NULL THEN NULL ELSE ARRAY[mobygames_company ] END;
ALTER TABLE wikidata ALTER COLUMN gamefaqs_game TYPE integer[] USING CASE WHEN gamefaqs_game IS NULL THEN NULL ELSE ARRAY[gamefaqs_game ] END;
ALTER TABLE wikidata ALTER COLUMN gamefaqs_company TYPE integer[] USING CASE WHEN gamefaqs_company IS NULL THEN NULL ELSE ARRAY[gamefaqs_company ] END;
ALTER TABLE wikidata ALTER COLUMN anidb_anime TYPE integer[] USING CASE WHEN anidb_anime IS NULL THEN NULL ELSE ARRAY[anidb_anime ] END;
ALTER TABLE wikidata ALTER COLUMN anidb_person TYPE integer[] USING CASE WHEN anidb_person IS NULL THEN NULL ELSE ARRAY[anidb_person ] END;
ALTER TABLE wikidata ALTER COLUMN ann_anime TYPE integer[] USING CASE WHEN ann_anime IS NULL THEN NULL ELSE ARRAY[ann_anime ] END;
ALTER TABLE wikidata ALTER COLUMN ann_manga TYPE integer[] USING CASE WHEN ann_manga IS NULL THEN NULL ELSE ARRAY[ann_manga ] END;
ALTER TABLE wikidata ALTER COLUMN musicbrainz_artist TYPE uuid[] USING CASE WHEN musicbrainz_artist IS NULL THEN NULL ELSE ARRAY[musicbrainz_artist] END;
ALTER TABLE wikidata ALTER COLUMN twitter TYPE text[] USING CASE WHEN twitter IS NULL THEN NULL ELSE ARRAY[twitter ] END;
ALTER TABLE wikidata ALTER COLUMN vgmdb_product TYPE integer[] USING CASE WHEN vgmdb_product IS NULL THEN NULL ELSE ARRAY[vgmdb_product ] END;
ALTER TABLE wikidata ALTER COLUMN vgmdb_artist TYPE integer[] USING CASE WHEN vgmdb_artist IS NULL THEN NULL ELSE ARRAY[vgmdb_artist ] END;
ALTER TABLE wikidata ALTER COLUMN discogs_artist TYPE integer[] USING CASE WHEN discogs_artist IS NULL THEN NULL ELSE ARRAY[discogs_artist ] END;
ALTER TABLE wikidata ALTER COLUMN acdb_char TYPE integer[] USING CASE WHEN acdb_char IS NULL THEN NULL ELSE ARRAY[acdb_char ] END;
ALTER TABLE wikidata ALTER COLUMN acdb_source TYPE integer[] USING CASE WHEN acdb_source IS NULL THEN NULL ELSE ARRAY[acdb_source ] END;
ALTER TABLE wikidata ALTER COLUMN indiedb_game TYPE text[] USING CASE WHEN indiedb_game IS NULL THEN NULL ELSE ARRAY[indiedb_game ] END;
ALTER TABLE wikidata ALTER COLUMN howlongtobeat TYPE integer[] USING CASE WHEN howlongtobeat IS NULL THEN NULL ELSE ARRAY[howlongtobeat ] END;
|
