# EMS MySQL Manager 
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : cpdb


DROP DATABASE IF EXISTS `cpdb`;
CREATE DATABASE IF NOT EXISTS `cpdb`;

USE cpdb;

#
# Structure for the `creationDates` table : 
#

CREATE TABLE `creationDates` (
  `id` int(11) NOT NULL auto_increment,
  `created` varchar(255) NOT NULL default '',
  `circa` varchar(255) NOT NULL default '(c)',
  `so` int,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Structure for the `locations` table : 
#

CREATE TABLE `locations` (
  `id` int(11) NOT NULL auto_increment,
  `location` varchar(255) NOT NULL default '',
  `so` int,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Structure for the `depiction` table : 
#

CREATE TABLE `depiction` (
  `id` int(11) NOT NULL auto_increment,
  `depth` int(11) NOT NULL default '0',
  `parent` int(11) NOT NULL default '0',
  `what` varchar(255) NOT NULL default '',
  `so` int,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Structure for the `discoveryDates` table : 
#

CREATE TABLE `discoveryDates` (
  `id` int(11) NOT NULL auto_increment,
  `discovered` varchar(128) NOT NULL default '',
  `circa` varchar(128) NOT NULL default '(c)',
  `so` int,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;


#
# Structure for the `joinObjectDocument` table : 
#

CREATE TABLE `joinObjectDocument` (
  `oid` int(11) NOT NULL default '0',
  `tid` int(11) NOT NULL default '0'
) TYPE=MyISAM;	 

#
# Structure for the `joinObjectAttribute` table : 
#

CREATE TABLE `joinObjectAttribute` (
  `oid` int(11) NOT NULL default '0',
  `tid` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Structure for the `joinObjectContent` table : 
#

CREATE TABLE `joinObjectContent` (
  `oid` int(11) NOT NULL default '0',
  `tid` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Structure for the `joinObjectType` table : 
#

CREATE TABLE `joinObjectType` (
  `oid` int(11) NOT NULL default '0',
  `tid` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Structure for the `objectTypes` table : 
#

CREATE TABLE `objectTypes` (
  `id` int(11) NOT NULL auto_increment,
  `depth` int(11) NOT NULL default '0',
  `isa` int(11) NOT NULL default '0',
  `type` varchar(255) NOT NULL default '',
  `so` int,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Structure for the `objects` table : 
#

CREATE TABLE `objects` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `inventory` varchar(128) default NULL,
  `name` varchar(128) default NULL,
  `description` varchar(255) default NULL,
  `created` int(11) default NULL,
  `discovered` int(11) default NULL,
  `width` varchar(128) default NULL,
  `length` varchar(128) default NULL,
  `height` varchar(128) default NULL,
  `location` int(11) default NULL,
  `bibliography` text default NULL,
  `notes` text default NULL,
  `catalogueNum` varchar(128) default NULL,
  `excavationInvNum` varchar(128) default NULL,
  `accessionNum` varchar(128) default NULL,
  `assignedLocation` text default NULL,
  `findSpotLocation` text default NULL,
  `keywords` text,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM;


#
# Structure for the `photos` table : 
#

CREATE TABLE `photos` (
  `ph_id` bigint(20) unsigned NOT NULL auto_increment,
  `ph_inventory` varchar(128) default NULL,
  `ph_name` varchar(128) default NULL,
  `ph_description` varchar(255) default NULL,
  `ph_location` int(11) default NULL,
  `ph_notes` text default NULL,
  `ph_rollnumber` text default NULL,
  `ph_framenumber` text default NULL,
  `ph_catalogueNum` varchar(128) default NULL,
  PRIMARY KEY  (`ph_id`),
  KEY `ph_id` (`ph_id`)
) TYPE=MyISAM;

CREATE TABLE `objectsFieldTitles` (
  `fieldName` text,
  `fieldTitle` text
) TYPE=MyISAM;

INSERT INTO photosFieldTitles VALUES
	('ph_id','Db Unique ID'),
	('ph_inventory','Photo Inventory Number'),
	('ph_name','Phot Name'),
	('ph_description','Photo Description'),
	('ph_location','Photo Location'),
	('ph_notes','Photo Notes'),
	('ph_rollnumber','Photo Roll Number'),
	('ph_framenumber','Photo Frame Number'),
	('ph_calatlogueNum','Photo Catalogue Number')
;

#
# Structure for the `drawings` table : 
#

CREATE TABLE `drawings` (
  `dr_id` bigint(20) unsigned NOT NULL auto_increment,
  `dr_inventory` varchar(128) default NULL,
  `dr_name` varchar(128) default NULL,
  `dr_description` varchar(255) default NULL,
  `dr_location` int(11) default NULL,
  `dr_notes` text default NULL,
  `dr_catalogueNum` varchar(128) default NULL,
  PRIMARY KEY  (`dr_id`),
  KEY `dr_id` (`dr_id`)
) TYPE=MyISAM;	  
		  

INSERT INTO drawingsFieldTitles VALUES
	('dr_id','Db Unique ID'),
	('dr_inventory','Drawing Inventory Number'),
	('dr_name','Phot Name'),
	('dr_description','Drawing Description'),
	('dr_location','Drawing Location'),
	('dr_notes','Drawing Notes'),
	('dr_calatlogueNum','Drawing Catalogue Number')
;

#
# Structure for the `joinObjectphoto` table : 
#

CREATE TABLE `joinObjectphoto` (
  `oid` int(11) NOT NULL default '0',
  `iid` int(11) NOT NULL default '0'
) TYPE=MyISAM;


#
# Structure for the `joinObjectdrawing` table : 
#

CREATE TABLE `joinObjectdrawing` (
  `oid` int(11) NOT NULL default '0',
  `iid` int(11) NOT NULL default '0'
) TYPE=MyISAM;


CREATE TABLE `objectsFieldTitles` (
  `fieldName` text,
  `fieldTitle` text
) TYPE=MyISAM;

INSERT INTO objectsFieldTitles VALUES
	('id','Db Unique ID'),
	('inventory','Object ID'),
	('name','Object Name'),
	('description','Object Description'),
	('created','CreatedDate'),
	('discovered','Discovered Date'),
	('width','Thickness'),
	('length','Length'),
	('height','Height'),
	('location','Current Location'),
	('keywords','Search Keywords'),
	('location','Current Location'),
	('bibliography','Bibliography'),
	('notes','Field Notebook Entry'),
	('catalogueNum','Catalogue Number'),
	('excavationInvNum','Excavation Inventory Number'),
	('accessionNum','Museum Accession Number'),
	('assignedLocation','Assigned Original Location'),
	('findSpotLocation','Find Spot Location')
;


#
# Structure for the `physicalAttributes` table : 
#


CREATE TABLE `physicalAttributes` (
  `id` int(11) NOT NULL default '0',
  `depth` int(11) NOT NULL default '0',
  `parent` int(11) NOT NULL default '0',
  `attribute` varchar(255) NOT NULL default 'other',
  `so` int,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;

#
# Data for the `physicalAttributes` table  (LIMIT 0,500)
#

INSERT INTO `physicalAttributes` (`id`, `so`, `depth`, `parent`, `attribute`) VALUES 
  (1 , 10,0,0 ,'Material'),
  (2 , 20,1,1 ,'clay'),
  (3 , 30,1,1 ,'ivory'),
  (4 , 40,1,1 ,'metal'),
  (5 , 50,1,1 ,'mudbrick'),
  (6 , 60,1,1 ,'plaster'),
  (7 , 70,1,1 ,'stone'),
  (8 , 80,0,0 ,'Shape'),
  (9 ,155,1,8 ,  'round'),
  (10,100,1,8 ,  'barrel-shaped'),
  (11,110,1,8 ,  'conical'),
  (12,120,1,8 ,  'cylindrical'),
  (13,130,1,8 ,  'pyriform'),
  (14,140,1,8 ,  'rectangular'),
  (15,150,2,15,    'square'),
  (16,160,1,8 ,  'squat'),
  (17,170,0,0 ,'Decoration'),
  (18,180,1,17,  '<cylinder seal style>'),
  (19,190,2,18,    'cut style'),
  (20,200,2,18,    'drilled'),
  (21,210,2,18,    'linear style'),
  (22,220,1,17,  'bas-relief'),
  (23,230,1,17,  'en creux'),
  (24,240,1,17,  'glazed'),
  (25,250,1,17,  'incized'),
  (26,260,1,17,  'modeled'),
  (27,270,1,17,  'painted'),
  (28,280,1,17,  'plain (undecorated)'),
  (29,290,0,0 ,'Preservation'),
  (30,300,1,29,  'complete'),
  (31,310,1,29,  'partially preserved - restorable'),
  (32,320,1,29,  'partially preserved - not restorable'),
  (33,330,1,29,  'numerous fragments');

COMMIT;

#
# Data for the `objectTypes` table  (LIMIT 0,500)
#
# deleted  (15,150,0,0 ,'box'),

INSERT INTO `objectTypes` (`id`, `so`, `depth`, `isa`, `type`) VALUES 
  (1 ,10 ,0,0 ,'architectural feature'),
  (2 ,20 ,1,1 ,  'beam'),
  (3 ,30 ,1,1 ,  'cistern'),
  (4 ,40 ,1,1 ,  'corbel'),
  (5 ,50 ,1,1 ,  'door pivot'),
  (6 ,60 ,1,1 ,  'door seat'),
  (7 ,70 ,1,1 ,  'doorway'),
  (8 ,80 ,1,1 ,  'floor slab'),
  (9 ,90 ,1,1 ,  'orthostate'),
  (10,100,2,9 ,    'corner slab'),
  (11,110,2,9 ,    'rabetted slab'),
  (12,120,1,1 ,  'threshold'),
  (13,130,1,1 ,  'wall'),
  (14,140,1,1 ,  'well'),
  (16,160,0,0 ,'brick'),
  (17,170,0,0 ,'coin'),
  (18,180,0,0 ,'furniture'),
  (19,190,0,0 ,'obelisk'),
  (20,200,0,0 ,'obelisk base'),
  (21,210,0,0 ,'pavement slab'),
  (22,220,1,21,  'with holes'),
  (23,230,1,21,  'with indentations'),
  (24,240,0,0 ,'seal'),
  (25,250,0,0 ,'statue'),
  (26,260,0,0 ,'stela'),
  (27,270,0,0 ,'vessel'),
  (28,280,1,27,  'open shape'),
  (29,290,1,27,  'closed shape'),
  (30,300,1,27,  'misc. shape'),
  (31,310,1,27,  'indeterminable');

COMMIT;
	   
#
# Data for the `locations` table  (LIMIT 0,500)
#

INSERT INTO `locations` (`id`, `so`, `location`) VALUES 
  (1,10,'in situ'),
  (2,20,'museum'),
  (3,30,'on-site storage'),
  (4,40,'private collection'),
  (5,50,'lost'),
  (6,60,'stolen');

COMMIT;

#
# Data for the `discoveryDates` table  (LIMIT 0,500)
#

INSERT INTO `discoveryDates` (`id`, `so`, `discovered`, `circa`) VALUES 
  (1,10,'Layard excavation','(c)'),
  (2,20,'Rassam excavation','(c)'),
  (3,30,'Austrian excavation','(c)'),
  (4,40,'Mallowan excavation','(c)'),
  (5,50,'Iraqi excavation','(c)'),
  (6,60,'Polish excavation','(c)'),
  (7,70,'rediscovered by the Polish team','(c)'),
  (8,80,'no information available (looted?)','(c)');

COMMIT;

#
# Data for the `depiction` table  (LIMIT 0,500)
#

INSERT INTO `depiction` (`id`, `so`, `depth`, `parent`, `what`) VALUES 
  (1  ,10 ,0,0  ,'representation'),
  (2  ,20 ,1,1  ,  '<representational element>'),
  (3  ,30 ,2,2  ,    'architecture (built environment)'),
  (4  ,40 ,3,3  ,      'campsite'),
  (5  ,50 ,3,3  ,      'citadel'),
  (7  ,70 ,3,3  ,      'stockade'),
  (8  ,80 ,3,3  ,      'tent'),
  (9  ,90 ,3,3  ,      'town / city'),
  (183,100 ,2,2  ,    'divine symbol'),
  (34 ,110 ,3,2  ,    'figure'),
  (35 ,120 ,3,34 ,      '<figure by affiliation>'),
  (36 ,130 ,4,35 ,        'Assyrian'),
  (37 ,140 ,4,35 ,        'enemy'),
  (38 ,150 ,3,34 ,      '<figure by function>'),
  (39 ,160 ,4,38 ,        'apotropaic figure'),
  (40 ,170 ,4,38 ,        'child'),
  (41 ,180 ,4,38 ,        'courtier'),
  (42 ,190 ,5,41 ,          'attendant'),
  (43 ,200 ,6,42 ,            'for banquet'),
  (44 ,210 ,6,42 ,            'with fly whisk'),
  (45 ,220 ,6,42 ,            'with weapons'),
  (46 ,230 ,5,41 ,          'herald'),
  (47 ,240 ,4,38 ,        'dead figure'),
  (48 ,250 ,5,47 ,          'corpse in battle'),
  (49 ,260 ,5,47 ,          'piked figure'),
  (50 ,270 ,4,38 ,        'demon'),
  (51 ,280 ,4,38 ,        'genius'),
  (52 ,290 ,5,51 ,          'empty handed'),
  (53 ,300 ,5,51 ,          'winged'),
  (54 ,310 ,5,51 ,          'wingless'),
  (55 ,320 ,5,51 ,          'with animal'),
  (56 ,330 ,5,51 ,          'with cone and bucket'),
  (57 ,340 ,5,51 ,          'with head band'),
  (58 ,350 ,5,51 ,          'with miter'),
  (59 ,360 ,5,51 ,          'with plant'),
  (162,370 ,5,51 ,          'without miter'),
  (60 ,380 ,5,51 ,          'without plant'),
  (61 ,390 ,4,38 ,        'king'),
  (62 ,400 ,5,61 ,          'in chariot'),
  (63 ,410 ,6,62 ,            'with bow and arrow'),
  (64 ,420 ,6,62 ,            'with mace'),
  (65 ,430 ,5,61 ,          'on throne'),
  (66 ,440 ,6,65 ,            'with staff'),
  (67 ,450 ,5,61 ,        'standing'),
  (68 ,460 ,6,67 ,          'with army officers'),
  (69 ,470 ,6,67 ,          'with bow and arrow'),
  (70 ,480 ,6,67 ,          'with bow and bowl'),
  (71 ,490 ,6,67 ,          'with courtiers'),
  (72 ,500 ,6,67 ,          'with courtiers and soldiers'),
  (73 ,510 ,6,67 ,          'with courtiers and army officers'),
  (74 ,520 ,6,67 ,          'with mace'),
  (75 ,530 ,6,67 ,          'with soldiers'),
  (76 ,540 ,6,67 ,          'with staff'),
  (77 ,550 ,4,38 ,      'priest'),
  (78 ,560 ,4,38 ,      'soldier'),
  (79 ,570 ,5,78 ,        '<soldier by role>'),
  (80 ,580 ,6,79 ,          'army officer'),
  (81 ,590 ,6,79 ,          'boatman'),
  (82 ,600 ,6,79 ,          'cavalry'),
  (83 ,610 ,6,79 ,          'charioteer (refers only to driver)'),
  (84 ,620 ,6,79 ,          'foot soldier'),
  (85 ,630 ,7,84 ,            '<foot soldier by type>'),
  (86 ,640 ,8,85 ,              'bowman'),
  (87 ,650 ,8,85 ,              'fire brand thrower'),
  (88 ,660 ,8,85 ,              'looter / bounty collector'),
  (89 ,670 ,8,85 ,              'miner'),
  (90 ,680 ,8,85 ,              'rock thrower'),
  (91 ,690 ,8,85 ,              'scribe'),
  (92 ,700 ,8,85 ,              'siege engine mechanic'),
  (93 ,710 ,8,85 ,              'slinger'),
  (94 ,720 ,8,85 ,              'swordsman'),
  (95 ,730 ,7,84 ,            '<foot soldier by attribute>'),
  (96 ,740 ,8,95 ,              'with full-body armor'),
  (97 ,750 ,8,95 ,              'with full-body shield'),
  (98 ,760 ,8,95 ,              'with helmet'),
  (99 ,770 ,8,95 ,              'with javelin'),
  (100,780 ,8,95 ,              'with round shield'),
  (101,790 ,8,95 ,              'with sling'),
  (102,800 ,8,95 ,              'with spear'),
  (103,810 ,8,95 ,              'with sword'),
  (104,820 ,4,38 ,      'sailor'),
  (105,830 ,4,38 ,      'scribe'),
  (106,840 ,5,105,        'with pen and papyrus or vellum roll'),
  (107,850 ,5,105,        'with stylus and tablet or wax board'),
  (108,860 ,3,34 ,    '<figure by type>'),
  (163,870 ,4,108,    'animal'),
  (164,880 ,5,163,      'bovine'),
  (171,890 ,6,164,        'bull'),
  (172,900 ,6,164,        'calf'),
  (173,910 ,6,164,        'cow'),
  (174,920 ,6,164,        'ox'),
  (165,930 ,5,163,      'camel'),
  (166,940 ,5,163,      'caprid'),
  (175,950 ,6,166,        'ewe'),
  (176,960 ,6,166,        'lamb'),
  (177,970 ,6,166,        'ram'),
  (167,980 ,5,163,      'fish'),
  (178,990 ,6,167,        'dolphin'),
  (168,1000 ,5,163,      'horse'),
  (169,1010 ,5,163,      'turtle'),
  (170,1020 ,5,163,      'vulture'),
  (179,1030 ,5,163,      'unidentifiable'),
  (180,1040 ,4,108,    'divine'),
  (181,1050 ,4,108,    'human'),
  (109,1060 ,5,181,      'man'),
  (110,1070 ,5,181,      'woman'),
  (201,1080 ,0,2  ,'landscape'),
  (202,1090 ,0,201  ,'desert'),
  (203,1100 ,0,201  ,'hilly'),
  (204,1110 ,0,201  ,'mountain'),
  (10 ,1120 ,2,2  ,    'object (material culture)'),
  (142,1130 ,3,10 ,      'bag'),
  (12 ,1140 ,3,10 ,      'boat'),
  (31 ,1150 ,3,10 ,      'boulder/cobble'),
  (143,1160 ,3,10 ,      'box'),
  (144,1170 ,3,10 ,      'bucket'),
  (145,1180 ,3,10 ,      'cart'),
  (146,1190 ,3,10 ,      'cauldron'),
  (147,1200 ,3,10 ,      '<cloting and accessories>'),
  (148,1210 ,4,147,        '<accessories>'),
  (18 ,1220 ,5,148,          'flywhisk'),
  (25 ,1230 ,5,148,          'shield'),
  (26 ,1240 ,6,25 ,            'full-body shield'),
  (27 ,1250 ,6,25 ,            'round shield'),
  (13 ,1260 ,4,147,        'body armor'),
  (14 ,1270 ,5,13 ,          'cuirass'),
  (15 ,1280 ,5,13 ,          'full-body armor'),
  (19 ,1290 ,4,147,        'helmet'),
  (23 ,1300 ,4,147,        'miter (headdress)'),
  (200,1310 ,3,10 ,      'fire altar'),
  (149,1320 ,3,10 ,      '<furniture and furnishings>'),
  (150,1330 ,4,149,        'bed'),
  (151,1340 ,4,149,        'camp stool'),
  (152,1350 ,4,149,        'footstool'),
  (153,1360 ,4,149,        'lampstand'),
  (154,1370 ,4,149,        'table'),
  (155,1380 ,5,154,          'for offering'),
  (156,1390 ,5,154,          'for food'),
  (33 ,1400 ,4,149,        'throne'),
  (157,1410 ,3,10 ,      'ladder'),
  (158,1420 ,3,10 ,      'statuee'),
  (159,1430 ,3,10 ,      'tent'),
  (160,1440 ,3,10 ,      'weapon'),
  (11 ,1450 ,4,160 ,        'arrow'),
  (16 ,1460 ,4,160 ,        'bow'),
  (17 ,1470 ,4,160 ,        'firebrand'),
  (20 ,1480 ,4,160 ,        'hook'),
  (21 ,1490 ,4,160 ,        'javelin'),
  (22 ,1500 ,4,160 ,        'mace'),
  (24 ,1510 ,4,160 ,        'pike'),
  (28 ,1520 ,4,160 ,        'siege engine'),
  (161,1530 ,4,160 ,        'siege ramp'),
  (29 ,1540 ,4,160 ,        'sling'),
  (30 ,1550 ,4,160 ,        'sling stone'),
  (32 ,1560 ,4,160 ,        'spear'),
  (111,1570 ,3,  2,    'vegetation'),
  (112,1580 ,4,111,    'plant'),
  (113,1590 ,4,111,    'tree'),
  (114,1600 ,5,113,      'sacred tree'),
  (115,1610 ,6,114,        '<sacred tree by location>'),
  (116,1620 ,7,115,          'corner tree'),
  (117,1630 ,7,115,          'wall'),
  (118,1640 ,6,114,        '<sacred tree by species>'),
  (119,1650 ,7,118,          'cone'),
  (120,1660 ,7,118,          'palmetto'),
  (121,1670 ,5,113,      '<tree by species>'),
  (122,1680 ,6,121,        'pine'),
  (123,1690 ,6,121,        'scrub oak'),
  (124,1700 ,4,111,    'vine'),
  (125,1710 ,1,1  ,  '<representational composition>'),
  (126,1720 ,2,125,    'narrative'),
  (127,1730 ,3,126,      'battle scene'),
  (128,1740 ,4,127,        'city siege'),
  (129,1750 ,4,127,        'field battle'),
  (130,1760 ,5,129,          'countryside field battle'),
  (131,1770 ,5,129,          'desert wasteland field battle'),
  (132,1780 ,5,129,          'mounted'),
  (133,1790 ,5,129,          'on foot'),
  (134,1800 ,4,127,        'mythic battle'),
  (135,1810 ,3,126,      'hunt scene'),
  (136,1820 ,3,126,      'presentation scene'),
  (137,1830 ,4,136,        'court scene'),
  (138,1840 ,4,136,        'religious scene'),
  (139,1850 ,4,136,        'victory procession'),
  (140,1860 ,0,0  ,'inscription'),
  (141,1870 ,0,0  ,'undecorated');
        
COMMIT;

#
# Data for the `creationDates` table  (LIMIT 0,500)
#

INSERT INTO `creationDates` (`id`, `so`, `created`, `circa`) VALUES 
  (1 ,10,'Tukulti-Ninurta II','(911-891)'),
  (2 ,20,'Adad-nirari','(890-884)'),
  (3 ,30,'Ashur-nasir-pal II','(883-859)'),
  (4 ,40,'Shalmaneser III','(859-824?)'),
  (5 ,50,'Shamshi-Adad V','(823-811)'),
  (6 ,60,'Adad-nirari III','(810-783) (Sammuramat)'),
  (7 ,70,'Shalmaneser IV','(782-773)'),
  (8 ,80,'Ashur-Dan III','(772-755)'),
  (9 ,90,'Ashur-nirari V','(754-745)'),
  (10,100,'Tiglath-pileser III','(744-727)'),
  (11,110,'Shalmaneser V','(726-722)'),
  (12,120,'Sargon II','(721-705)'),
  (13,130,'Sennacherib','(704-681)'),
  (14,140,'Esarhaddon','(680-669)'),
  (15,150,'Ashur-bani-pal','(688-631/617?)'),
  (16,160,'Ashur-etil-ilani','(630/626-623?)'),
  (17,170,'Sin-shar-ishkun','(622?-612)'),
  (18,180,'Ashur-uballit II','(611-609)'),
  (19,190,'Post-Assyrian Empire','()'),
  (20,200,'undatable','()');

COMMIT;





#
# Data for the `joinObjectAttribute` table  (LIMIT 0,500)
#

INSERT INTO `joinObjectAttribute` (`oid`, `tid`) VALUES 
  (3,22),
  (3,14),
  (3,7),
  (25,31),
  (25,28),
  (25,14),
  (25,7),
  (24,31),
  (3,31),
  (14,7),
  (14,14),
  (15,7),
  (15,14),
  (26,14),
  (26,2),
  (17,7),
  (17,14),
  (17,31),
  (18,7),
  (18,14),
  (18,22),
  (18,31),
  (18,33),
  (19,7),
  (19,14),
  (19,31),
  (19,33),
  (24,22),
  (24,14),
  (24,7),
  (22,7),
  (22,14),
  (22,22),
  (23,7),
  (23,14),
  (23,31),
  (23,33);

COMMIT;

#
# Data for the `joinObjectContent` table  (LIMIT 0,500)
#

INSERT INTO `joinObjectContent` (`oid`, `tid`) VALUES 
  (3,114),
  (3,113),
  (3,1),
  (26,140),
  (25,140),
  (3,116),
  (3,119),
  (14,1),
  (14,34),
  (14,36),
  (14,41),
  (14,42),
  (14,44),
  (15,1),
  (15,34),
  (15,39),
  (15,51),
  (15,53),
  (15,56),
  (15,58),
  (17,1),
  (17,3),
  (17,9),
  (17,28),
  (17,126),
  (17,127),
  (17,128),
  (18,1),
  (18,16),
  (18,34),
  (18,36),
  (18,41),
  (18,42),
  (18,45),
  (18,109),
  (18,126),
  (18,136),
  (18,137),
  (19,1),
  (19,39),
  (24,39),
  (24,1),
  (22,1),
  (22,39),
  (23,1),
  (23,39);

COMMIT;

#
# Data for the `joinObjectType` table  (LIMIT 0,500)
#

INSERT INTO `joinObjectType` (`oid`, `tid`) VALUES 
  (3,10),
  (3,9),
  (3,1),
  (14,1),
  (14,9),
  (15,1),
  (15,9),
  (17,1),
  (17,9),
  (18,1),
  (18,9),
  (19,1),
  (19,7),
  (19,9),
  (26,16),
  (24,9),
  (24,7),
  (22,1),
  (22,7),
  (22,9),
  (22,11),
  (23,1),
  (23,7),
  (23,9);

COMMIT;

#
# Data for the `objects` table  (LIMIT 0,500)
#

INSERT INTO `objects` (`id`, `inventory`, `name`, `description`, `created`, `discovered`, `width`, `length`, `height`, `location`, `keywords`) VALUES 
  (3,'N-A/26/1976','bas-relief','corner tree with cones and pomegranates',10,6,'12','75','88',1,NULL),
  (25,'N/35a/1975','so-called \"wall inscription\"','stone tablet inscribed on both sides',3,1,'5','34.7','32',1,NULL),
  (26,'N/2/1976','brick','fragment of right side of inscribed brick (5 lines)',3,1,'?','28','24',1,NULL),
  (14,'N-A/22/1975','bas-relief','courtier facing right (with fly whisk), one register',10,1,'9','69','248',1,NULL),
  (15,'N-A/21/1975','bas-relief','Genius facing left with cone and bucket, one register',10,1,'13','96','244',1,NULL),
  (17,'N-A/84/1975','bas-relief','siege engine (ram) on battle ramp (before a city wall)',10,1,'5','21','20',1,NULL),
  (18,'N-A/19a+b+c/1976','bas-relief','two arms bearers facing left in a court procession',10,1,'10','83','51',1,NULL),
  (19,'N-A/18/1976','bas-relief','upper right corner of head and wings of bull-lamassu facing left',10,6,'16','92','117',1,NULL),
  (24,'N-A/79/1975','bas-relief','bull lamassu facing left',4,1,'77','472','251',1,NULL),
  (22,'N-A/40/1976','bas-relief','Middle front part of body of a bull lamassu facing left',10,1,'16','122','89',1,NULL),
  (23,'N-A/18/1976','bas-relief','front hooves of a bull lamassu facing left',10,6,'15','125','107',1,NULL);

COMMIT;


