From 0576214fae36832123e05fb496c97f7c228b932a Mon Sep 17 00:00:00 2001 From: olivier Date: Mon, 2 Mar 2009 19:59:21 +0000 Subject: [PATCH] crem sql changes in relation with geo-ethno data import: - location_types primary key is now a string as in the xml source file - shorten the location name strings, otherwise composite keys are too big for mysql when using utf8 git-svn-id: http://svn.parisson.org/svn/crem@61 3bf09e05-f825-4182-b9bc-eedd7160adf0 --- trunk/docref/crem.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/trunk/docref/crem.sql b/trunk/docref/crem.sql index 4f60c51..e2d1700 100644 --- a/trunk/docref/crem.sql +++ b/trunk/docref/crem.sql @@ -110,15 +110,15 @@ CREATE TABLE publisher_collections ( -- CREATE TABLE location_types ( - id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, - type VARCHAR(250) NOT NULL + id VARCHAR(64) NOT NULL PRIMARY KEY, + name VARCHAR(150) NOT NULL ); CREATE TABLE locations ( - name VARCHAR(250) NOT NULL PRIMARY KEY, + name VARCHAR(150) NOT NULL PRIMARY KEY, type ENUM('country', 'continent', 'other'), - complete_type_id INTEGER NOT NULL, - current_name VARCHAR(250), + complete_type_id VARCHAR(64) NOT NULL, + current_name VARCHAR(150), is_authoritative BOOLEAN NOT NULL, FOREIGN KEY(current_name) REFERENCES locations (name), @@ -126,8 +126,8 @@ CREATE TABLE locations ( ); CREATE TABLE location_aliases ( - location_name VARCHAR(250) NOT NULL, - alias VARCHAR(250) NOT NULL, + location_name VARCHAR(150) NOT NULL, + alias VARCHAR(150) NOT NULL, is_authoritative BOOLEAN NOT NULL, PRIMARY KEY(location_name, alias), @@ -135,8 +135,8 @@ CREATE TABLE location_aliases ( ); CREATE TABLE location_relations ( - location_name VARCHAR(250) NOT NULL, - parent_location_name VARCHAR(250) NOT NULL, + location_name VARCHAR(150) NOT NULL, + parent_location_name VARCHAR(150) NOT NULL, PRIMARY KEY(location_name, parent_location_name), FOREIGN KEY(location_name) REFERENCES locations (name), -- 2.39.5