Changeset 32

Timestamp:

07/26/13 11:23:20 (11 years ago)

Author:

lucsch

Message:

Model 1.1 edited by CV

Location:

trunk/models/flood

Files:

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

trunk/models/flood/user_structure.sql

@@ -2 +2 @@
 CREATE TABLE `layer_at1` (
   `OBJECT_ID` int(10) unsigned NOT NULL,
-  `Flooding` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
-  `Debris_flo` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
-  `Erosion` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Flood` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Flood_stat` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Dflow` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Dflow_stat` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Eros` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Eros_stat` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
   `Author` varchar(254) DEFAULT NULL, 
   PRIMARY KEY (`OBJECT_ID`),
@@ -24 +27 @@
   `OBJECT_ID` int(10) unsigned NOT NULL,
   `Process` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Recur_age` int (11) DEFAULT NULL,
   `Remarks` varchar(254) DEFAULT NULL,
   PRIMARY KEY (`OBJECT_ID`),
@@ -33 +37 @@
   `OBJECT_ID` int(10) unsigned NOT NULL,
   `Process` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Recur_age` int (11) DEFAULT NULL,
   `Remarks` varchar(254) DEFAULT NULL,
   PRIMARY KEY (`OBJECT_ID`),
@@ -42 +47 @@
   `OBJECT_ID` int(10) unsigned NOT NULL,
   `Process` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Recur_age` int (11) DEFAULT NULL,
   `Remarks` varchar(254) DEFAULT NULL,
   PRIMARY KEY (`OBJECT_ID`),
@@ -52 +58 @@
   `OBJECT_ID` int(10) unsigned NOT NULL,
   `Process` int(11) DEFAULT NULL COMMENT 'ENUMERATION',
+  `Recur_age` int (11) DEFAULT NULL,
   `Remarks` varchar(254) DEFAULT NULL,
   PRIMARY KEY (`OBJECT_ID`),