[Mapbender-commits] r2802 - trunk/mapbender/resources/db
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Thu Aug 14 11:24:02 EDT 2008
Author: christoph
Date: 2008-08-14 11:24:02 -0400 (Thu, 14 Aug 2008)
New Revision: 2802
Modified:
trunk/mapbender/resources/db/schema_2.5.dia
Log:
changed several sequences and auto increments
Modified: trunk/mapbender/resources/db/schema_2.5.dia
===================================================================
--- trunk/mapbender/resources/db/schema_2.5.dia 2008-08-14 15:15:15 UTC (rev 2801)
+++ trunk/mapbender/resources/db/schema_2.5.dia 2008-08-14 15:24:02 UTC (rev 2802)
@@ -12005,13 +12005,13 @@
<dia:point val="126,-89"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="125.95,-89.95;166.2,-86.75"/>
+ <dia:rectangle val="125.95,-89.95;165.5,-86.75"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="126,-89"/>
</dia:attribute>
<dia:attribute name="elem_width">
- <dia:real val="40.149999999999999"/>
+ <dia:real val="39.450000000000003"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="2.2000000000000002"/>
@@ -12028,7 +12028,7 @@
<dia:attribute name="text">
<dia:composite type="text">
<dia:attribute name="string">
- <dia:string>#SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('wfs','wfs_id'), (SELECT max(wfs_id) FROM wfs), true);#</dia:string>
+ <dia:string>#SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('mb_log','id'), (SELECT max(id) FROM mb_log), true);#</dia:string>
</dia:attribute>
<dia:attribute name="font">
<dia:font family="monospace" style="0" name="Courier"/>
@@ -12053,13 +12053,13 @@
<dia:point val="126,-85"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="125.95,-85.95;153.25,-82.75"/>
+ <dia:rectangle val="125.95,-85.95;151.5,-82.75"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="126,-85"/>
</dia:attribute>
<dia:attribute name="elem_width">
- <dia:real val="27.200000000000003"/>
+ <dia:real val="25.450000000000003"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="2.2000000000000002"/>
@@ -12076,7 +12076,7 @@
<dia:attribute name="text">
<dia:composite type="text">
<dia:attribute name="string">
- <dia:string>#ALTER TABLE wfs CHANGE COLUMN wfs_id wfs_id integer NOT NULL AUTO_INCREMENT;#</dia:string>
+ <dia:string>#ALTER TABLE mb_log CHANGE COLUMN id id integer NOT NULL AUTO_INCREMENT;#</dia:string>
</dia:attribute>
<dia:attribute name="font">
<dia:font family="monospace" style="0" name="Courier"/>
@@ -12101,13 +12101,13 @@
<dia:point val="126,-94"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="125.95,-94.95;154.65,-90.95"/>
+ <dia:rectangle val="125.95,-94.95;157.8,-90.95"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="126,-94"/>
</dia:attribute>
<dia:attribute name="elem_width">
- <dia:real val="28.600000000000001"/>
+ <dia:real val="31.75"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="3"/>
@@ -12124,8 +12124,8 @@
<dia:attribute name="text">
<dia:composite type="text">
<dia:attribute name="string">
- <dia:string>#CREATE SEQUENCE wfs_id_seq;
-ALTER TABLE wfs ALTER COLUMN wfs_id SET DEFAULT nextval('wfs_id_seq'::regclass);#</dia:string>
+ <dia:string>#CREATE SEQUENCE mb_log_id_seq;
+ALTER TABLE mb_log ALTER COLUMN mb_log_id SET DEFAULT nextval('mb_log_id_seq'::regclass);#</dia:string>
</dia:attribute>
<dia:attribute name="font">
<dia:font family="monospace" style="0" name="Courier"/>
@@ -15282,13 +15282,13 @@
<dia:point val="-47,-68"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="-47.05,-68.95;-6.8,-65.75"/>
+ <dia:rectangle val="-47.05,-68.95;8.6,-65.75"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="-47,-68"/>
</dia:attribute>
<dia:attribute name="elem_width">
- <dia:real val="40.149999999999999"/>
+ <dia:real val="55.550000000000004"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="2.2000000000000002"/>
@@ -15305,7 +15305,7 @@
<dia:attribute name="text">
<dia:composite type="text">
<dia:attribute name="string">
- <dia:string>#SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('wfs','wfs_id'), (SELECT max(wfs_id) FROM wfs), true);#</dia:string>
+ <dia:string>#SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('sld_user_layer','sld_user_layer_id'), (SELECT max(sld_user_layer_id) FROM sld_user_layer), true);#</dia:string>
</dia:attribute>
<dia:attribute name="font">
<dia:font family="monospace" style="0" name="Courier"/>
@@ -15330,13 +15330,13 @@
<dia:point val="-47,-64"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="-47.05,-64.95;-19.75,-61.75"/>
+ <dia:rectangle val="-47.05,-64.95;-8.2,-61.75"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="-47,-64"/>
</dia:attribute>
<dia:attribute name="elem_width">
- <dia:real val="27.200000000000003"/>
+ <dia:real val="38.75"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="2.2000000000000002"/>
@@ -15353,7 +15353,7 @@
<dia:attribute name="text">
<dia:composite type="text">
<dia:attribute name="string">
- <dia:string>#ALTER TABLE wfs CHANGE COLUMN wfs_id wfs_id integer NOT NULL AUTO_INCREMENT;#</dia:string>
+ <dia:string>#ALTER TABLE sld_user_layer CHANGE COLUMN sld_user_layer_id sld_user_layer_id integer NOT NULL AUTO_INCREMENT;#</dia:string>
</dia:attribute>
<dia:attribute name="font">
<dia:font family="monospace" style="0" name="Courier"/>
@@ -15378,13 +15378,13 @@
<dia:point val="-47,-73"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="-47.05,-73.95;-18.35,-69.95"/>
+ <dia:rectangle val="-47.05,-73.95;-6.8,-69.95"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="-47,-73"/>
</dia:attribute>
<dia:attribute name="elem_width">
- <dia:real val="28.600000000000001"/>
+ <dia:real val="40.149999999999999"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="3"/>
@@ -15401,8 +15401,8 @@
<dia:attribute name="text">
<dia:composite type="text">
<dia:attribute name="string">
- <dia:string>#CREATE SEQUENCE wfs_id_seq;
-ALTER TABLE wfs ALTER COLUMN wfs_id SET DEFAULT nextval('wfs_id_seq'::regclass);#</dia:string>
+ <dia:string>#CREATE SEQUENCE sld_user_layer_id_seq;
+ALTER TABLE sld_user_layer ALTER COLUMN sld_user_layer_id SET DEFAULT nextval('sld_user_layer_id_seq'::regclass);#</dia:string>
</dia:attribute>
<dia:attribute name="font">
<dia:font family="monospace" style="0" name="Courier"/>
@@ -16114,13 +16114,13 @@
<dia:point val="-47,-102"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="-47.05,-102.95;-19.75,-99.75"/>
+ <dia:rectangle val="-47.05,-102.95;-5.05,-99.75"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="-47,-102"/>
</dia:attribute>
<dia:attribute name="elem_width">
- <dia:real val="27.200000000000003"/>
+ <dia:real val="41.899999999999999"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="2.2000000000000002"/>
@@ -16137,7 +16137,7 @@
<dia:attribute name="text">
<dia:composite type="text">
<dia:attribute name="string">
- <dia:string>#ALTER TABLE wfs CHANGE COLUMN wfs_id wfs_id integer NOT NULL AUTO_INCREMENT;#</dia:string>
+ <dia:string>#ALTER TABLE md_topic_category CHANGE COLUMN md_topic_category_id md_topic_category_id integer NOT NULL AUTO_INCREMENT;#</dia:string>
</dia:attribute>
<dia:attribute name="font">
<dia:font family="monospace" style="0" name="Courier"/>
More information about the Mapbender_commits
mailing list