Changeset 22 for trunk

Timestamp:

02/25/13 14:03:28 (12 years ago)

Author:

lucsch

Message:

Correcting swisstopo data model definition (columns missing)

Location:

trunk/models/swisstopo

Files:

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

trunk/models/swisstopo/user_structure.sql

@@ -109 +109 @@
 -- layer_at19 --
 CREATE TABLE `layer_at19` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Fault_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Verti_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
@@ -123 +124 @@
 -- layer_at20 --
 CREATE TABLE `layer_at20` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Fold_Typ` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Fold_For` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
@@ -135 +137 @@
 -- layer_at21 --
 CREATE TABLE `layer_at21` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Kind` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Plunge_Dir` int(11) DEFAULT NULL,
@@ -144 +147 @@
 -- layer_at22 --
 CREATE TABLE `layer_at22` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Polarity` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Phase` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
@@ -156 +160 @@
 -- layer_at23 --
 CREATE TABLE `layer_at23` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
   PRIMARY KEY (`OBJECT_ID`),
@@ -163 +168 @@
 -- layer_at24 --
 CREATE TABLE `layer_at24` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Division` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `System` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
@@ -174 +180 @@
  -- layer_at25 --
 CREATE TABLE `layer_at25` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Material` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
@@ -183 +190 @@
   -- layer_at26 --
 CREATE TABLE `layer_at26` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Chemistry` varchar(254) DEFAULT NULL,
   PRIMARY KEY (`OBJECT_ID`),
@@ -190 +198 @@
   -- layer_at27 --
 CREATE TABLE `layer_at27` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Orient` int(11) DEFAULT NULL, 
   PRIMARY KEY (`OBJECT_ID`),
@@ -197 +206 @@
  -- layer_at28 --
 CREATE TABLE `layer_at28` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Strati` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Name` varchar(254) DEFAULT NULL,
@@ -207 +217 @@
 -- layer_at29 --
 CREATE TABLE `layer_at29` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Cong_Spe` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Name_Horiz` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
@@ -216 +227 @@
 -- layer_at31 --
 CREATE TABLE `layer_at31` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
   PRIMARY KEY (`OBJECT_ID`),
@@ -223 +235 @@
 -- layer_at32 --
 CREATE TABLE `layer_at32` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Dip_Direct` int(11) DEFAULT NULL,
@@ -232 +245 @@
  -- layer_at33 --
 CREATE TABLE `layer_at33` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Type` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Altitude` decimal (5,2) DEFAULT NULL,
@@ -240 +254 @@
 -- layer_at34 --
 CREATE TABLE `layer_at34` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Dip_Direct` int(11) DEFAULT NULL,
  `Dip` int(11) DEFAULT NULL,
@@ -250 +265 @@
 -- layer_at35 --
 CREATE TABLE `layer_at35` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Confine` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Altitude` decimal (5,2) DEFAULT NULL,
@@ -259 +275 @@
 -- layer_at36 --
 CREATE TABLE `layer_at36` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Period` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
@@ -269 +286 @@
 -- layer_at37 --
 CREATE TABLE `layer_at37` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Period` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
@@ -278 +296 @@
 -- layer_at38 --
 CREATE TABLE `layer_at38` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Period` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
@@ -287 +306 @@
 -- layer_at39 --
 CREATE TABLE `layer_at39` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Depth_Tot` decimal (5,2) DEFAULT NULL,
@@ -296 +316 @@
  -- layer_at40 --
 CREATE TABLE `layer_at40` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
   PRIMARY KEY (`OBJECT_ID`),
@@ -303 +324 @@
 -- layer_at41 --
 CREATE TABLE `layer_at41` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Targ_Mat` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
@@ -311 +333 @@
 -- layer_at42 --
 CREATE TABLE `layer_at42` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Drill_Mo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Depth_Bedr` decimal (5,2) DEFAULT NULL,
@@ -330 +353 @@
 -- layer_at44 --
 CREATE TABLE `layer_at44` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Epoch` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
@@ -341 +365 @@
 -- layer_at45 --
 CREATE TABLE `layer_at45` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Combi` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
   PRIMARY KEY (`OBJECT_ID`),
@@ -348 +373 @@
 -- layer_at46 --
 CREATE TABLE `layer_at46` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Rel_Age` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Ref_Year` int(11) DEFAULT NULL,
@@ -357 +383 @@
 -- layer_at47 --
 CREATE TABLE `layer_at47` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Combi` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
   PRIMARY KEY (`OBJECT_ID`),
@@ -364 +391 @@
 -- layer_at48 --
 CREATE TABLE `layer_at48` (
+ `OBJECT_ID` int(10) unsigned NOT NULL,
  `Status` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
  `Flow_Con` int(11) DEFAULT NULL COMMENT 'ENUMERATION',