Changeset 28 for trunk

Timestamp:

03/01/13 12:52:40 (12 years ago)

Author:

lucsch

Message:

Correcting float size

File:

• trunk/models/swisstopo/user_structure.sql (modified) (6 diffs)

trunk/models/swisstopo/user_structure.sql

@@ -247 +247 @@
  `OBJECT_ID` int(10) unsigned NOT NULL,
  `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
- `Altitude` decimal (4,2) DEFAULT NULL,
+ `Altitude` decimal (6,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 (4,2) DEFAULT NULL,
+ `Height` decimal (6,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 (4,2) DEFAULT NULL,
+ `Altitude` decimal (6,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 (4,2) DEFAULT NULL,
+ `Depth_Tot` decimal (6,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 (4,2) DEFAULT NULL,
+ `Depth_Bedr` decimal (6,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 (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,
+ `Depth_Tot` decimal (6,2) DEFAULT NULL,
+ `Depth_Fm_A` decimal (6,2) DEFAULT NULL,
+ `Depth_Fm_B` decimal (6,2) DEFAULT NULL,
+ `Depth_WT` decimal (5,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 (3,2) DEFAULT NULL,
- `Depth_WT` decimal (3,2) DEFAULT NULL,
+ `Depth` decimal (5,2) DEFAULT NULL,
+ `Depth_WT` decimal (5,2) DEFAULT NULL,
  `Mea_Period` varchar(254) DEFAULT NULL,
   PRIMARY KEY (`OBJECT_ID`),