Index: trunk/models/swisstopo/user_structure.sql
===================================================================
--- trunk/models/swisstopo/user_structure.sql	(revision 23)
+++ trunk/models/swisstopo/user_structure.sql	(revision 24)
@@ -5,5 +5,5 @@
   `Rock_Typ` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
   `Rock_Spe` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
-  `Oeig_Descr` varchar(254) DEFAULT NULL, 
+  `Orig_Descr` varchar(254) DEFAULT NULL, 
   `Protected` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
   PRIMARY KEY (`OBJECT_ID`),
@@ -66,5 +66,6 @@
   `Glac_Typ` varchar(254) DEFAULT NULL,
   `Ice_M_P` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
-  `Quat_Str` 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`)
@@ -138,5 +139,4 @@
 CREATE TABLE `layer_at21` (
  `OBJECT_ID` int(10) unsigned NOT NULL,
- `Kind` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Plunge_Dir` int(11) DEFAULT NULL,
  `Plunge` int(11) DEFAULT NULL,
@@ -247,5 +247,5 @@
  `OBJECT_ID` int(10) unsigned NOT NULL,
  `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
- `Altitude` decimal (5,2) DEFAULT NULL,
+ `Altitude` decimal (4,2) DEFAULT NULL,
   PRIMARY KEY (`OBJECT_ID`),
   KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`)
@@ -257,5 +257,5 @@
  `Dip_Direct` int(11) DEFAULT NULL,
  `Dip` int(11) DEFAULT NULL,
- `Height` decimal (5,2) DEFAULT NULL,
+ `Height` decimal (4,2) DEFAULT NULL,
  `Mea_Period` varchar(254) DEFAULT NULL,
   PRIMARY KEY (`OBJECT_ID`),
@@ -267,5 +267,5 @@
  `OBJECT_ID` int(10) unsigned NOT NULL,
  `Confine` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
- `Altitude` decimal (5,2) DEFAULT NULL,
+ `Altitude` decimal (4,2) DEFAULT NULL,
  `Wa_Table` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
   PRIMARY KEY (`OBJECT_ID`),
@@ -308,5 +308,5 @@
  `OBJECT_ID` int(10) unsigned NOT NULL,
  `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
- `Depth_Tot` decimal (5,2) DEFAULT NULL,
+ `Depth_Tot` decimal (4,2) DEFAULT NULL,
  `Targ_Mat` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
   PRIMARY KEY (`OBJECT_ID`),
@@ -335,12 +335,12 @@
  `OBJECT_ID` int(10) unsigned NOT NULL,
  `Drill_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
- `Depth_Bedr` decimal (5,2) DEFAULT NULL,
+ `Depth_Bedr` decimal (4,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,
+ `Depth_Tot` decimal (4,2) DEFAULT NULL,
+ `Depth_Fm_A` decimal (4,2) DEFAULT NULL,
+ `Depth_Fm_B` decimal (4,2) DEFAULT NULL,
+ `Depth_WT` decimal (4,2) DEFAULT NULL,
  `Plunge_Dir` int(11) DEFAULT NULL,	
  `Plunge` int(11) DEFAULT NULL,	
@@ -356,6 +356,6 @@
  `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,
+ `Depth` decimal (3,2) DEFAULT NULL,
+ `Depth_WT` decimal (3,2) DEFAULT NULL,
  `Mea_Period` varchar(254) DEFAULT NULL,
   PRIMARY KEY (`OBJECT_ID`),
