Changeset 24 for trunk/models/swisstopo

Timestamp:

02/28/13 09:55:13 (12 years ago)

Author:

lucsch

Message:

Small Swisstopo model corrections

Location:

trunk/models/swisstopo

Files:

• user_content.txt (modified) (previous)
• user_structure.sql (modified) (9 diffs)

trunk/models/swisstopo/user_structure.sql

@@ -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 +66 @@
   `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 +139 @@
 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 +247 @@
  `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 +257 @@
  `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 +267 @@
  `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 +308 @@
  `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 +335 @@
  `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 +356 @@
  `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`),