Index: trunk/models/swisstopo/user_structure.sql
===================================================================
--- trunk/models/swisstopo/user_structure.sql	(revision 21)
+++ trunk/models/swisstopo/user_structure.sql	(revision 21)
@@ -0,0 +1,376 @@
+-- layer_at1 --
+CREATE TABLE `layer_at1` (
+  `OBJECT_ID` int(10) unsigned NOT NULL,
+  `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Rock_Typ` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Rock_Spe` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Oeig_Descr` varchar(254) DEFAULT NULL, 
+  `Protected` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at2 --
+CREATE TABLE `layer_at2` (
+  `OBJECT_ID` int(10) unsigned NOT NULL,
+  `Orig_Descr` varchar(254) DEFAULT NULL,
+  `Buried_Out` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Composit` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Admixtur` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Structur` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Charact` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Morpholo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Glac_Typ` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Ref_Year` varchar(254) DEFAULT NULL,
+  `Thin_Cov` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at3 --
+CREATE TABLE `layer_at3` (
+  `OBJECT_ID` int(10) unsigned NOT NULL,
+  `Fm_Homog` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Orig_Descr` varchar(254) DEFAULT NULL,
+  `Buried_Out` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Exotic_Ele` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Colour` varchar(254) DEFAULT NULL,
+  `Main_Com` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Seco_Com` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Bond_Mat` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Bedding` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Sedi_Str` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Sedi_Tex` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Igne_Tex` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Grain_Si` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Affinity` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Full_Name` varchar(254) DEFAULT NULL,
+  `Mineral` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Meta_Str` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at7 --
+CREATE TABLE `layer_at7` (
+  `OBJECT_ID` int(10) unsigned NOT NULL,
+  `Main_Mov` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at9 --
+CREATE TABLE `layer_at9` (
+  `OBJECT_ID` int(10) unsigned NOT NULL,
+  `Morai_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Glac_Typ` varchar(254) DEFAULT NULL,
+  `Ice_M_P` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Quat_Str` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at13 --
+CREATE TABLE `layer_at13` (
+  `OBJECT_ID` int(10) unsigned NOT NULL,
+  `Ice_Cave` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at15 --
+CREATE TABLE `layer_at15` (
+  `OBJECT_ID` int(10) unsigned NOT NULL,
+  `Age` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at16 --
+CREATE TABLE `layer_at16` (
+  `OBJECT_ID` int(10) unsigned NOT NULL,
+  `Azimuth` int(11) DEFAULT NULL,
+  `Plunge` int(11) DEFAULT NULL,
+  `Fold_Typ` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Fold_For` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at18 --
+CREATE TABLE `layer_at18` (
+  `OBJECT_ID` int(10) unsigned NOT NULL,
+  `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Gen_Rela` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at19 --
+CREATE TABLE `layer_at19` (
+ `Fault_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Verti_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Horiz_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Lim_Tect_B` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Activity` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Meta_Sta` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Name` varchar(254) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at20 --
+CREATE TABLE `layer_at20` (
+ `Fold_Typ` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Fold_For` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Phase` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Phase_Ref` varchar(254) DEFAULT NULL,
+ `Plunge_Dir` int(11) DEFAULT NULL,
+ `Plunge` int(11) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at21 --
+CREATE TABLE `layer_at21` (
+ `Kind` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Plunge_Dir` int(11) DEFAULT NULL,
+ `Plunge` int(11) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at22 --
+CREATE TABLE `layer_at22` (
+ `Polarity` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Phase` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Phase_Ref` varchar(254) DEFAULT NULL,
+ `Ob_Dip_Slo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Dip_Direct` int(11) DEFAULT NULL,
+ `Dip` int(11) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at23 --
+CREATE TABLE `layer_at23` (
+ `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at24 --
+CREATE TABLE `layer_at24` (
+ `Division` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `System` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Dat_Meth` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Protected` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+ 
+ -- layer_at25 --
+CREATE TABLE `layer_at25` (
+ `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Material` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Chemistry` varchar(254) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+ 
+  -- layer_at26 --
+CREATE TABLE `layer_at26` (
+ `Chemistry` varchar(254) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+  -- layer_at27 --
+CREATE TABLE `layer_at27` (
+ `Orient` int(11) DEFAULT NULL,	
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+ -- layer_at28 --
+CREATE TABLE `layer_at28` (
+ `Strati` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Name` varchar(254) DEFAULT NULL,
+ `Accessibil` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Protected` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at29 --
+CREATE TABLE `layer_at29` (
+ `Cong_Spe` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Name_Horiz` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Orig_Descr` varchar(254) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at31 --
+CREATE TABLE `layer_at31` (
+ `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at32 --
+CREATE TABLE `layer_at32` (
+ `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Dip_Direct` int(11) DEFAULT NULL,
+ `Dip` int(11) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+ 
+ -- layer_at33 --
+CREATE TABLE `layer_at33` (
+ `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Altitude` decimal (5,2) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at34 --
+CREATE TABLE `layer_at34` (
+ `Dip_Direct` int(11) DEFAULT NULL,
+ `Dip` int(11) DEFAULT NULL,
+ `Height` decimal (5,2) DEFAULT NULL,
+ `Mea_Period` varchar(254) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at35 --
+CREATE TABLE `layer_at35` (
+ `Confine` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Altitude` decimal (5,2) DEFAULT NULL,
+ `Wa_Table` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at36 --
+CREATE TABLE `layer_at36` (
+ `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Period` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Age` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at37 --
+CREATE TABLE `layer_at37` (
+ `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Period` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Age` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at38 --
+CREATE TABLE `layer_at38` (
+ `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Period` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Age` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at39 --
+CREATE TABLE `layer_at39` (
+ `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Depth_Tot` decimal (5,2) DEFAULT NULL,
+ `Targ_Mat` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+ 
+ -- layer_at40 --
+CREATE TABLE `layer_at40` (
+ `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at41 --
+CREATE TABLE `layer_at41` (
+ `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Targ_Mat` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at42 --
+CREATE TABLE `layer_at42` (
+ `Drill_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Depth_Bedr` decimal (5,2) DEFAULT NULL,
+ `D_C_Underg` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Main_Tar` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Targ_Mat` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Depth_Tot` decimal (5,2) DEFAULT NULL,
+ `Depth_Fm_A` decimal (5,2) DEFAULT NULL,
+ `Depth_Fm_B` decimal (5,2) DEFAULT NULL,
+ `Depth_WT` decimal (5,2) DEFAULT NULL,
+ `Plunge_Dir` int(11) DEFAULT NULL,	
+ `Plunge` int(11) DEFAULT NULL,	
+ `Ref_Number` int(11) DEFAULT NULL,	
+ `Link` int(11) DEFAULT NULL,	
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at44 --
+CREATE TABLE `layer_at44` (
+ `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Depth` decimal (5,2) DEFAULT NULL,
+ `Depth_WT` decimal (5,2) DEFAULT NULL,
+ `Mea_Period` varchar(254) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at45 --
+CREATE TABLE `layer_at45` (
+ `Combi` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at46 --
+CREATE TABLE `layer_at46` (
+ `Rel_Age` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Ref_Year` int(11) DEFAULT NULL,
+ `Source` varchar(254) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at47 --
+CREATE TABLE `layer_at47` (
+ `Combi` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- layer_at48 --
+CREATE TABLE `layer_at48` (
+ `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Flow_Con` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Dis_Loca` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Combi` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+ `Temp` int(11) DEFAULT NULL,
+ `Chemistry` varchar(254) DEFAULT NULL,
+ `Azimuth` int(11) DEFAULT NULL,
+  PRIMARY KEY (`OBJECT_ID`),
+  KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;