CRM Core
From EChase
This has emerged recently, a set of core CRM concepts for modelling events and a few other things. It may be worth investigating for our metadata schema.
DTD[edit]
<?xml version='1.0' encoding='UTF-8' ?> <!--Generated by Turbo XML 2.3.1.100.--> <!-- CRM Core Metadata element set version 1.1. Approved by the CIDOC CRM Special Interest Group 15-11-2005 --> <!--#DOCUMENTATION:Represents the described CRM Entity. Corresponds to Dublin Core resource.--> <!ELEMENT CRM_Core (Category+ , Classification* , Identification+ , Description? , Event* , Relation*)> <!--#DOCUMENTATION:One of the CIDOC CRM Classes, or a mapping to/from DCMI Type Vocabulary. General term to characterize the nature of the described item. Compatibility: DC.Type, CIDOC CRM class system. --> <!ELEMENT Category (#PCDATA)> <!--#DOCUMENTATION:Any category classifying the described item. Preferrably from controlled vocabularies. Compatibility: CIDOC CRM P2 has type. E55 Type. Includes: DC.Format, DC.Language --> <!ELEMENT Classification (#PCDATA)> <!ATTLIST Classification name_space CDATA #IMPLIED > <!--#DOCUMENTATION:Any name or identifier used for the particular item described. Compatibility: DC.Title and DC.Identifier. CIDOC CRM P1 is identified by: E41 Appellation --> <!ELEMENT Identification (#PCDATA)> <!ATTLIST Identification name_space CDATA #IMPLIED > <!--#DOCUMENTATION:An account of the nature or content of the described item. Compatibility: DC.Description, CIDOC CRM P3 has note: E62 String --> <!ELEMENT Description (#PCDATA)> <!--#DOCUMENTATION:Any Event the described item was present at. (In generalization any period the object existed in ?) Compatibility: CIDOC CRM E5 Event Allows for expressing DC.Creator, DC.Publisher, DC.Contributor, DC.Date, DC.Coverage --> <!ELEMENT Event (Role_in_Event* , Identification+ , Event_Type* , Participant* , Participant_Type* , Thing_Present* , Thing_Present_Type* , Date? , Place? , RelatedEvent*)> <!--#DOCUMENTATION:Role of the described Item in the Event: Compatibility: Any subproperty of CIDOC CRM P12B was present at. Allows for connecting DC.Creator, DC.Contributor, DC.Publisher, DC.Coverage DC.Date. --> <!ELEMENT Role_in_Event (#PCDATA)> <!--#DOCUMENTATION:Classification of the Event, e.g. Publication, Production, Creation, Finding, Use) Compatibility: subclasses of CIDOC CRM E5 Event, and compatible E55 Type --> <!ELEMENT Event_Type (#PCDATA)> <!ATTLIST Event_Type name_space CDATA #IMPLIED > <!--#DOCUMENTATION:Any Actor participating or being present in the Event. Compatibility: DC.Creator,DC.Publisher,DC.Contributor, DC.Relation if an Agent is referred. CIDOC CRM P12B was present at: E39 Actor --> <!ELEMENT Participant (#PCDATA)> <!ATTLIST Participant name_space CDATA #IMPLIED > <!--#DOCUMENTATION:Any kind of Actor participating or being present in the Event. This expresses incomplete knowledge. Compatibility: CIDOC CRM P12B was present at: E39 Actor. P2 has type: E55 Type --> <!ELEMENT Participant_Type (#PCDATA)> <!ATTLIST Participant_Type name_space CDATA #IMPLIED > <!--#DOCUMENTATION:Any Stuff being present in the Event. Compatibility: DC.Relation CIDOC CRM P12B was present at: E70 Stuff --> <!ELEMENT Thing_Present (#PCDATA)> <!ATTLIST Thing_Present name_space CDATA #IMPLIED > <!--#DOCUMENTATION:Any kind of Stuff being present in the Event. Compatibility: DC.Relation CIDOC CRM P12B was present at: E70 Stuff --> <!ELEMENT Thing_Present_Type (#PCDATA)> <!ATTLIST Thing_Present_Type name_space CDATA #IMPLIED > <!--#DOCUMENTATION:A time date range constraining the event related to the described item. Compatibility: CIDOC CRM P4 has time-span:E52 Time-Span.P82 at some time within: E61 Time Primitive. Includes: DC.Date, DC.Coverage depending on the role of the item in the Event (Role_in_Event) --> <!ELEMENT Date (#PCDATA)> <!--#DOCUMENTATION:A time date range constraining the event related to the described item. Compatibility: CIDOC CRM P7 took place at E53 Place. Includes: DC.Coverage depending on the role of the item in the Event (Role_in_Event) --> <!ELEMENT Place (#PCDATA)> <!ATTLIST Place name_space CDATA #IMPLIED > <!--#DOCUMENTATION:Any not event-mediated relation. Restricted to: part of, reference, similarity for which causal events are not established. Compatibility: subset of DC.Relation --> <!ELEMENT Relation (To+ , Relation_Type)> <!ELEMENT To (#PCDATA)> <!ATTLIST To name_space CDATA #IMPLIED > <!ELEMENT Relation_Type (has_part , part_of , refers_to , referred_to_by , shows_features_of)> <!ELEMENT refers_to EMPTY> <!ELEMENT referred_to_by EMPTY> <!ELEMENT part_of EMPTY> <!ELEMENT has_part EMPTY> <!ELEMENT shows_features_of EMPTY> <!ELEMENT RelatedEvent (Role_in_Event , Identification)>
Example By Martin Doerr[edit]
One of the victims of the war was photojournalist John Hoagland (1947-84). His photographic career had started in 1970, videoing the Chicano Moratorium anti-war movement in Los Angeles and he moved to El Salvador in 1979, working for the French Gamma agency and Newsweek, for which he had five cover pictures. Together with Susan Meiselas he had a lucky escape in 1981 when his car ran over a land mine. Hoagland and Meiselas escaped with injuries but the third person in the car, Ian Mates, died. After a period covering the war in Beirut in 1983-4 he returned to El Salvador, marrying a Salvadoran.
His work in El Salvador was a clear and sometimes devastating account of what was happening, showing the bodies left on the ground by the death squads, a mother holding the body of her dead son and other horrific scenes. On the evidence of the work on the web he was a highly competent photographer who was seriously involved in recording the war and giving a truthful account of how he saw it. His last six frames, found in his camera, record his own death, and were analysed by Richard Astle for 'Wasted Space'. They show Hoagland a few yards from a pair of Salvadoran soldiers on an empty road. One turns towards him and apparently sees he is taking pictures. The next to last frame, shot as he was falling shows the tip of his show and the last picture ' is of the Salvadoran soil, his adoptive country.'
Record for article describing Hoagland's last six frames recording his own death:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE CRM_Core SYSTEM "CRM_Core.dtd">
<CRM_Core>
<Category>E31 Document</Category>
<Classification name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>articles</Classification>
<Identification>http://www.wastedspace.com/best/astle.html</Identification>
<Description>This article analyzes Hoagland's last six frames recording his own death.</Description>
<Event>
<Role_in_Event>P94B was created by</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo">Astle_writing_1985</Identification>
<Event_Type name_space="http://cidoc.ics.forth.gr/rdfs/cidoc_v4.2.rdfs">E65_Creation</Event_Type>
<Participant name_space="http://cidoc.ics.forth.gr/crm_core/demo">Richard Astle</Participant>
<Participant_Type
name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>journalists</Participant_Type>
<Date>1985</Date>
</Event>
<Event>
<Role_in_Event>P67 refers to</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo">John Hoagland's death
1984</Identification>
<Event_Type name_space="http://cidoc.ics.forth.gr/rdfs/cidoc_v4.2.rdfs">E69_Death</Event_Type>
<Event_Type name_space="http://cidoc.ics.forth.gr/rdfs/cidoc_v4.2.rdfs">E7_Activity</Event_Type>
<Participant name_space="http://cidoc.ics.forth.gr/crm_core/demo">John Hoagland</Participant>
<Participant_Type
name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>photojournalists</Participant_Type>
<Thing_Present name_space="http://cidoc.ics.forth.gr/crm_core/demo"
>Hoagland_taking_last_six_shots_1984</Thing_Present>
<Thing_Present_Type name_space="http://cidoc.ics.forth.gr/rdfs/cidoc_v4.2.rdfs">E38 Image</Thing_Present_Type>
<Date>1984</Date>
<Place name_space="http://www.getty.edu/research/conducting_research/vocabularies/tgn/">El
Salvador (nation)</Place>
<RelatedEvent>
<Role_in_Event>P9 forms part of</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo"
>Hoagland_taking_last_six_shots_1984</Identification>
</RelatedEvent>
<RelatedEvent>
<Role_in_Event>P9 forms part of</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo">Shooting at
Hoagland 1984</Identification>
</RelatedEvent>
</Event>
<Event>
<Role_in_Event>P129 is about</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo"
>Hoagland_taking_last_six_shots_1984</Identification>
<Event_Type name_space="http://cidoc.ics.forth.gr/rdfs/cidoc_v4.2.rdfs">E65_Creation</Event_Type>
<Participant name_space="http://cidoc.ics.forth.gr/crm_core/demo">John Hoagland</Participant>
<Participant_Type
name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>photojournalists</Participant_Type>
<Thing_Present name_space="http://cidoc.ics.forth.gr/crm_core/demo"
>Negative_of_Hoagland_picture</Thing_Present>
<Thing_Present_Type
name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>negatives</Thing_Present_Type>
<Date>1984</Date>
<Place name_space="http://www.getty.edu/research/conducting_research/vocabularies/tgn/">El
Salvador (nation)</Place>
</Event>
<Event>
<Role_in_Event>P129 is about</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo">Shooting at Hoagland
1984</Identification>
<Event_Type name_space="http://cidoc.ics.forth.gr/rdfs/cidoc_v4.2.rdfs">E7_Activity</Event_Type>
<Participant name_space="http://cidoc.ics.forth.gr/crm_core/demo">John Hoagland</Participant>
<Participant name_space="http://cidoc.ics.forth.gr/crm_core/demo">Salvadoran Soldier 1</Participant>
<Participant_Type
name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>photojournalists</Participant_Type>
<Participant_Type
name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>soldiers</Participant_Type>
<Date>1984</Date>
<Place name_space="http://www.getty.edu/research/conducting_research/vocabularies/tgn/">El
Salvador (nation)</Place>
</Event>
<Relation>
<To name_space="http://www.wastedspace.com/index.html">wasted space</To>
<Relation_Type>
<has_part/>
<part_of/>
<refers_to/>
<referred_to_by/>
<shows_features_of/>
</Relation_Type>
</Relation>
</CRM_Core>
Record for John Hoagland:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE CRM_Core SYSTEM "CRM_Core.dtd">
<CRM_Core>
<Category>E21 Person</Category>
<Classification name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>photojournalists</Classification>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo">John Hoagland</Identification>
<Description>Born in San Diego, California, the oldest child of Helen and Al Hoagland, a career
officer in the Navy and a combat air veteran of World War Two... </Description>
<Event>
<Role_in_Event>P100b died in</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo">John Hoagland's death
1984</Identification>
<Event_Type name_space="http://cidoc.ics.forth.gr/rdfs/cidoc_v4.2.rdfs">E69_Death</Event_Type>
<Event_Type name_space="http://cidoc.ics.forth.gr/rdfs/cidoc_v4.2.rdfs">E7_Activity</Event_Type>
<Participant name_space="http://cidoc.ics.forth.gr/crm_core/demo">Salvadoran Soldier 1</Participant>
<Participant_Type
name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>soldiers</Participant_Type>
<Date>1984</Date>
<Place name_space="http://www.getty.edu/research/conducting_research/vocabularies/tgn/">El
Salvador (nation)</Place>
<RelatedEvent>
<Role_in_Event>P9 forms part of</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo"
>Hoagland_taking_last_six_shots_1984</Identification>
</RelatedEvent>
<RelatedEvent>
<Role_in_Event>P9 forms part of</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo">Shooting at
Hoagland 1984</Identification>
</RelatedEvent>
</Event>
</CRM_Core>
Record for images of John Hoagland’s death
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE CRM_Core SYSTEM "CRM_Core.dtd">
<CRM_Core>
<Category>E38 Image</Category>
<Classification name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>photographs</Classification>
<Identification>http://thedagger.com/archive/elsal/lastsix.gif</Identification>
<Description>This image shows how one of Salvadoran soldiers turns towards the camera and spots
Hoagland "shooting" him.</Description>
<Event>
<Role_in_Event>P94B was created by</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo"
>Hoagland_taking_last_six_shots_1984</Identification>
<Event_Type name_space="http://cidoc.ics.forth.gr/rdfs/cidoc_v4.2.rdfs">E65_Creation</Event_Type>
<Participant name_space="http://cidoc.ics.forth.gr/crm_core/demo">John Hoagland</Participant>
<Participant_Type
name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>photojournalists</Participant_Type>
<Thing_Present name_space="http://cidoc.ics.forth.gr/crm_core/demo"
>Negative_of_Hoagland_picture</Thing_Present>
<Thing_Present_Type
name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>negatives</Thing_Present_Type>
<Date>1984</Date>
<Place name_space="http://www.getty.edu/research/conducting_research/vocabularies/tgn/">El
Salvador (nation)</Place>
<RelatedEvent>
<Role_in_Event>P9 consists of</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo">John Hoagland's
death 1984</Identification>
</RelatedEvent>
</Event>
<Event>
<Role_in_Event>P138 represents</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo">Shooting at Hoagland
1984</Identification>
<Event_Type name_space="http://cidoc.ics.forth.gr/rdfs/cidoc_v4.2.rdfs">E7_Activity</Event_Type>
<Participant name_space="http://cidoc.ics.forth.gr/crm_core/demo">John Hoagland</Participant>
<Participant name_space="http://cidoc.ics.forth.gr/crm_core/demo">Salvadoran Soldier 1</Participant>
<Participant_Type
name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>photojournalists</Participant_Type>
<Participant_Type
name_space="http://www.getty.edu/research/conducting_research/vocabularies/aat/"
>soldiers</Participant_Type>
<Date>1984</Date>
<Place name_space="http://www.getty.edu/research/conducting_research/vocabularies/tgn/">El
Salvador (nation)</Place>
<RelatedEvent>
<Role_in_Event>P9 consists of</Role_in_Event>
<Identification name_space="http://cidoc.ics.forth.gr/crm_core/demo">John Hoagland's
death 1984</Identification>
</RelatedEvent>
</Event>
</CRM_Core>
Attempt at a CRM Core SQL Schema[edit]
-- MySQL dump 10.9 -- -- Host: localhost Database: crm_core -- ------------------------------------------------------ -- Server version 4.1.11-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */; -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(11) NOT NULL auto_increment, `crm_core_id` int(11) NOT NULL default '0', `crm_concept_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `categories` -- /*!40000 ALTER TABLE `categories` DISABLE KEYS */; LOCK TABLES `categories` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `categories` ENABLE KEYS */; -- -- Table structure for table `classifications` -- CREATE TABLE `classifications` ( `id` int(11) NOT NULL auto_increment, `crm_core_id` int(11) default NULL, `thesaurus_item_id` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `classifications` -- /*!40000 ALTER TABLE `classifications` DISABLE KEYS */; LOCK TABLES `classifications` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `classifications` ENABLE KEYS */; -- -- Table structure for table `crm_concepts` -- CREATE TABLE `crm_concepts` ( `id` int(11) NOT NULL auto_increment, `category` varchar(50) default NULL, `display_en` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `crm_concepts` -- /*!40000 ALTER TABLE `crm_concepts` DISABLE KEYS */; LOCK TABLES `crm_concepts` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `crm_concepts` ENABLE KEYS */; -- -- Table structure for table `crm_cores` -- CREATE TABLE `crm_cores` ( `id` int(11) NOT NULL auto_increment, `crm_core_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `crm_cores` -- /*!40000 ALTER TABLE `crm_cores` DISABLE KEYS */; LOCK TABLES `crm_cores` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `crm_cores` ENABLE KEYS */; -- -- Table structure for table `crm_properties` -- CREATE TABLE `crm_properties` ( `id` int(11) NOT NULL auto_increment, `type` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `crm_properties` -- /*!40000 ALTER TABLE `crm_properties` DISABLE KEYS */; LOCK TABLES `crm_properties` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `crm_properties` ENABLE KEYS */; -- -- Table structure for table `dates` -- CREATE TABLE `dates` ( `id` int(11) NOT NULL auto_increment, `from_date` bigint(20) default NULL, `from_time` time default NULL, `from_ca` tinyint(1) default NULL, `to_date` bigint(20) default NULL, `to_time` time default NULL, `to_ca` tinyint(1) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `dates` -- /*!40000 ALTER TABLE `dates` DISABLE KEYS */; LOCK TABLES `dates` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `dates` ENABLE KEYS */; -- -- Table structure for table `description_texts` -- CREATE TABLE `description_texts` ( `id` int(11) NOT NULL auto_increment, `language_id` int(11) default NULL, `source` int(11) default NULL, `text` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `description_texts` -- /*!40000 ALTER TABLE `description_texts` DISABLE KEYS */; LOCK TABLES `description_texts` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `description_texts` ENABLE KEYS */; -- -- Table structure for table `descriptions` -- CREATE TABLE `descriptions` ( `id` int(11) NOT NULL auto_increment, `crm_core_id` int(11) NOT NULL default '0', `type` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `descriptions` -- /*!40000 ALTER TABLE `descriptions` DISABLE KEYS */; LOCK TABLES `descriptions` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `descriptions` ENABLE KEYS */; -- -- Table structure for table `event_places` -- CREATE TABLE `event_places` ( `id` int(11) NOT NULL auto_increment, `event_id` int(11) default NULL, `gazetteer_place_id` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `event_places` -- /*!40000 ALTER TABLE `event_places` DISABLE KEYS */; LOCK TABLES `event_places` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `event_places` ENABLE KEYS */; -- -- Table structure for table `event_types` -- CREATE TABLE `event_types` ( `id` int(11) NOT NULL auto_increment, `crm_concept_id` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `event_types` -- /*!40000 ALTER TABLE `event_types` DISABLE KEYS */; LOCK TABLES `event_types` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `event_types` ENABLE KEYS */; -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` int(11) NOT NULL auto_increment, `crm_core_id` int(11) NOT NULL default '0', `date_id` int(11) default NULL, `gazetteer_place_id` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `events` -- /*!40000 ALTER TABLE `events` DISABLE KEYS */; LOCK TABLES `events` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `events` ENABLE KEYS */; -- -- Table structure for table `gazetteer_place_names` -- CREATE TABLE `gazetteer_place_names` ( `id` int(11) NOT NULL auto_increment, `gazetteer_place_id` int(11) default NULL, `language_code` int(11) default NULL, `preferred` tinyint(1) default NULL, `text` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `gazetteer_place_names` -- /*!40000 ALTER TABLE `gazetteer_place_names` DISABLE KEYS */; LOCK TABLES `gazetteer_place_names` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `gazetteer_place_names` ENABLE KEYS */; -- -- Table structure for table `gazetteer_places` -- CREATE TABLE `gazetteer_places` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) default NULL, `hierarchy` text, `legacy_name` varchar(50) default NULL, `latitude` double default NULL, `longitude` double default NULL, `position_source` int(11) default NULL, `population` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `gazetteer_places` -- /*!40000 ALTER TABLE `gazetteer_places` DISABLE KEYS */; LOCK TABLES `gazetteer_places` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `gazetteer_places` ENABLE KEYS */; -- -- Table structure for table `identifications` -- CREATE TABLE `identifications` ( `id` int(11) NOT NULL auto_increment, `crm_core_id` int(11) default NULL, `namespace` text, `identification` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `identifications` -- /*!40000 ALTER TABLE `identifications` DISABLE KEYS */; LOCK TABLES `identifications` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `identifications` ENABLE KEYS */; -- -- Table structure for table `languages` -- CREATE TABLE `languages` ( `id` int(11) NOT NULL auto_increment, `code` varchar(5) default NULL, `name` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `languages` -- /*!40000 ALTER TABLE `languages` DISABLE KEYS */; LOCK TABLES `languages` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `languages` ENABLE KEYS */; -- -- Table structure for table `participants` -- CREATE TABLE `participants` ( `id` int(11) NOT NULL auto_increment, `event_id` int(11) default NULL, `crm_core` int(11) default NULL, `thesaurus_item_id` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `participants` -- /*!40000 ALTER TABLE `participants` DISABLE KEYS */; LOCK TABLES `participants` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `participants` ENABLE KEYS */; -- -- Table structure for table `related_events` -- CREATE TABLE `related_events` ( `id` int(11) NOT NULL auto_increment, `event_id` int(11) default NULL, `crm_property_id` int(11) default NULL, `rel_event_id` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `related_events` -- /*!40000 ALTER TABLE `related_events` DISABLE KEYS */; LOCK TABLES `related_events` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `related_events` ENABLE KEYS */; -- -- Table structure for table `relation_tos` -- CREATE TABLE `relation_tos` ( `id` int(11) NOT NULL auto_increment, `relation_id` int(11) NOT NULL default '0', `crm_core_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `relation_tos` -- /*!40000 ALTER TABLE `relation_tos` DISABLE KEYS */; LOCK TABLES `relation_tos` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `relation_tos` ENABLE KEYS */; -- -- Table structure for table `relation_types` -- CREATE TABLE `relation_types` ( `id` int(11) NOT NULL auto_increment, `relation_id` int(11) default NULL, `type` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `relation_types` -- /*!40000 ALTER TABLE `relation_types` DISABLE KEYS */; LOCK TABLES `relation_types` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `relation_types` ENABLE KEYS */; -- -- Table structure for table `relations` -- CREATE TABLE `relations` ( `id` int(11) NOT NULL auto_increment, `crm_core_id` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `relations` -- /*!40000 ALTER TABLE `relations` DISABLE KEYS */; LOCK TABLES `relations` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `relations` ENABLE KEYS */; -- -- Table structure for table `representations` -- CREATE TABLE `representations` ( `new_column` varchar(50) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `representations` -- /*!40000 ALTER TABLE `representations` DISABLE KEYS */; LOCK TABLES `representations` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `representations` ENABLE KEYS */; -- -- Table structure for table `role_in_events` -- CREATE TABLE `role_in_events` ( `id` int(11) NOT NULL auto_increment, `event_id` int(11) default NULL, `crm_property_id` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `role_in_events` -- /*!40000 ALTER TABLE `role_in_events` DISABLE KEYS */; LOCK TABLES `role_in_events` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `role_in_events` ENABLE KEYS */; -- -- Table structure for table `thesaurus_item_texts` -- CREATE TABLE `thesaurus_item_texts` ( `id` int(11) NOT NULL auto_increment, `thesaurus_item_id` int(11) default NULL, `language_id` int(11) default NULL, `source_id` int(11) default NULL, `preferred` tinyint(1) default NULL, `text` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `thesaurus_item_texts` -- /*!40000 ALTER TABLE `thesaurus_item_texts` DISABLE KEYS */; LOCK TABLES `thesaurus_item_texts` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `thesaurus_item_texts` ENABLE KEYS */; -- -- Table structure for table `thesaurus_items` -- CREATE TABLE `thesaurus_items` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) default NULL, `thesaurus_id` int(11) default NULL, `legacy_name` text, `hierarchy` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `thesaurus_items` -- /*!40000 ALTER TABLE `thesaurus_items` DISABLE KEYS */; LOCK TABLES `thesaurus_items` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `thesaurus_items` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
