Changeset 8

Timestamp:

02/19/13 13:31:36 (11 years ago)

Author:

lucsch

Message:

Removing auto_increment=value

File:

• trunk/models/base/base_structure.sql (modified) (14 diffs)

trunk/models/base/base_structure.sql

@@ -17 +17 @@
   `DESCRIPTION_4` varchar(255) DEFAULT NULL,
   PRIMARY KEY (`CATALOG_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 -- dmn_layer_attribut --
@@ -25 +25 @@
   `ATTRIBUT_NAME` varchar(100) DEFAULT NULL,
   PRIMARY KEY (`ATTRIBUT_ID`,`LAYER_INDEX`)
-) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM DEFAULT CHARSET=utf8
 
 -- dmn_layer_object --
@@ -44 +44 @@
   PRIMARY KEY (`OBJECT_ID`),
   KEY `DMN_LAYER_OBJECT_FKIndex2` (`THEMATIC_LAYERS_LAYER_INDEX`,`OBJECT_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 -- dmn_layer_type --
@@ -65 +65 @@
   `SHORTCUT_DESC` varchar(255) DEFAULT NULL,
   PRIMARY KEY (`SHORTCUT_CD`)
-) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 INSERT INTO dmn_shortcut_key VALUES(1,"F1","");
@@ -111 +111 @@
   `OBJECT_GEOMETRY` linestring NOT NULL COMMENT 'Feature geometry',
   PRIMARY KEY (`OBJECT_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 -- generic_labels --
@@ -118 +118 @@
   `OBJECT_GEOMETRY` multipoint NOT NULL,
   PRIMARY KEY (`OBJECT_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=90 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 -- generic_lat --
@@ -134 +134 @@
   `OBJECT_GEOMETRY` linestring NOT NULL,
   PRIMARY KEY (`OBJECT_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=602 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 -- generic_notes --
@@ -163 +163 @@
   `OBJECT_GEOMETRY` multipoint NOT NULL COMMENT 'Feature geometry',
   PRIMARY KEY (`OBJECT_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 -- lang_def --
@@ -187 +187 @@
   `QUERIES_CODE` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`QUERIES_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 INSERT INTO prj_queries VALUES(1,0,"Lines without attribution","SELECT o.OBJECT_ID FROM generic_lines AS o WHERE o.OBJECT_ID NOT IN (SELECT a.OBJECT_GEOM_ID FROM generic_aat AS a)");
@@ -208 +208 @@
   `PRJ_SNAP_TOLERENCE` int(11) NOT NULL DEFAULT '10',
   PRIMARY KEY (`SETTING_DBK`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 
@@ -229 +229 @@
   `DATE_END` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (`STAT_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 -- prj_toc --
@@ -244 +244 @@
   PRIMARY KEY (`CONTENT_ID`),
   KEY `PRJ_TOC_FKIndex1` (`TYPE_CD`)
-) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 
@@ -272 +272 @@
   PRIMARY KEY (`LAYER_INDEX`),
   KEY `THEMATIC_LAYERS_FKIndex1` (`TYPE_CD`)
-) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 -- zoom_level --
@@ -280 +280 @@
   `RANK` int(11) DEFAULT NULL,
   PRIMARY KEY (`ZOOM_ID`)
-) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8
 
 INSERT INTO zoom_level VALUES(1,5000,2);