create_table_monuments_es_(ca).sql

  •  
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
cawiki uses idurl for lists of es monuments, too
cawiki uses idurl for lists of es monuments, too

    • -0
    • +1
    ./create_table_monuments_es_(ca).sql
  1. … 1 more file in changeset.
Enable title for create_table_monuments_es-*
Enable title for create_table_monuments_es-*

    • -0
    • +1
    ./create_table_monuments_es_(ca).sql
  1. … 3 more files in changeset.
Change the bic fields for Spain from integers to varchar(25), this is the…
Change the bic fields for Spain from integers to varchar(25), this is the

same definition that monuments_es-vc_(ca) had.

Increase the id field of monuments_all so that they fit there.

Change the import from monuments_es-vc_(ca) to use the bic as id, not

the idurl from the Direcció General del Patrimoni Cultural Valencià website.

This is accompanied by the following changes to the existing database:

ALTER TABLE `monuments_es_(es)` MODIFY COLUMN `bic` varchar(25) NOT NULL DEFAULT '0';

ALTER TABLE `monuments_es-ct_(ca)` MODIFY COLUMN `bic` varchar(25) NOT NULL DEFAULT '0';

ALTER TABLE `monuments_es_(ca)` MODIFY COLUMN `bic` varchar(25) NOT NULL DEFAULT '0';

    • -1
    • +1
    ./create_table_monuments_es_(ca).sql
  1. … 4 more files in changeset.
Add tipus field for es (ca).
Add tipus field for es (ca).
    • -0
    • +1
    ./create_table_monuments_es_(ca).sql
  1. … 1 more file in changeset.
Added nomcoor and used it for the name field
Added nomcoor and used it for the name field
    • -0
    • +1
    ./create_table_monuments_es_(ca).sql
  1. … 6 more files in changeset.
DROP TABLE IF EXISTS
DROP TABLE IF EXISTS
    • -0
    • +1
    ./create_table_monuments_es_(ca).sql
  1. … 8 more files in changeset.
Add municipi field in Spain.
Add municipi field in Spain.
    • -0
    • +1
    ./create_table_monuments_es_(ca).sql
  1. … 2 more files in changeset.
Add Spain in Catalan
Add Spain in Catalan

    • -0
    • +15
    ./create_table_monuments_es_(ca).sql