[Mapbender-commits] r2704 - branches/testbaudson_dev/documents
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Wed Jul 23 05:43:45 EDT 2008
Author: christoph
Date: 2008-07-23 05:43:44 -0400 (Wed, 23 Jul 2008)
New Revision: 2704
Modified:
branches/testbaudson_dev/documents/mpbn25_.dia
Log:
updated
* innodb
* correct foreign keys with cascading
Modified: branches/testbaudson_dev/documents/mpbn25_.dia
===================================================================
--- branches/testbaudson_dev/documents/mpbn25_.dia 2008-07-23 09:13:25 UTC (rev 2703)
+++ branches/testbaudson_dev/documents/mpbn25_.dia 2008-07-23 09:43:44 UTC (rev 2704)
@@ -65,13 +65,13 @@
<dia:layer name="Background" visible="true">
<dia:object type="UML - Class" version="0" id="O0">
<dia:attribute name="obj_pos">
- <dia:point val="10.7,9.7"/>
+ <dia:point val="12.25,4.2"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="10.65,9.65;23.5,14.55"/>
+ <dia:rectangle val="12.2,4.15;25.05,9.05"/>
</dia:attribute>
<dia:attribute name="elem_corner">
- <dia:point val="10.7,9.7"/>
+ <dia:point val="12.25,4.2"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="12.75"/>
@@ -122,7 +122,7 @@
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="fill_color">
- <dia:color val="#ffffff"/>
+ <dia:color val="#add8e6"/>
</dia:attribute>
<dia:attribute name="text_color">
<dia:color val="#000000"/>
@@ -265,13 +265,13 @@
</dia:object>
<dia:object type="UML - Class" version="0" id="O1">
<dia:attribute name="obj_pos">
- <dia:point val="10.35,-20.15"/>
+ <dia:point val="12.5,-34.7"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="10.3,-20.2;25.6,-3.3"/>
+ <dia:rectangle val="12.45,-34.75;27.75,-17.85"/>
</dia:attribute>
<dia:attribute name="elem_corner">
- <dia:point val="10.35,-20.15"/>
+ <dia:point val="12.5,-34.7"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="15.199999999999999"/>
@@ -322,7 +322,7 @@
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="fill_color">
- <dia:color val="#ffffff"/>
+ <dia:color val="#add8e6"/>
</dia:attribute>
<dia:attribute name="text_color">
<dia:color val="#000000"/>
@@ -810,13 +810,13 @@
</dia:object>
<dia:object type="UML - Class" version="0" id="O2">
<dia:attribute name="obj_pos">
- <dia:point val="10.7,1.7"/>
+ <dia:point val="12.6,-9.6"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="10.65,1.65;20.35,4.95"/>
+ <dia:rectangle val="12.55,-9.65;22.25,-6.35"/>
</dia:attribute>
<dia:attribute name="elem_corner">
- <dia:point val="10.7,1.7"/>
+ <dia:point val="12.6,-9.6"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="9.5999999999999996"/>
@@ -867,7 +867,7 @@
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="fill_color">
- <dia:color val="#ffffff"/>
+ <dia:color val="#add8e6"/>
</dia:attribute>
<dia:attribute name="text_color">
<dia:color val="#000000"/>
@@ -964,16 +964,16 @@
</dia:object>
<dia:object type="UML - Association" version="1" id="O3">
<dia:attribute name="obj_pos">
- <dia:point val="17.95,-3.30081"/>
+ <dia:point val="20.1,-17.8497"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="14.75,-3.35081;21.65,2.5"/>
+ <dia:rectangle val="16.65,-17.8997;30.2,-8.85"/>
</dia:attribute>
<dia:attribute name="orth_points">
- <dia:point val="17.95,-3.30081"/>
- <dia:point val="17.95,-0.799871"/>
- <dia:point val="15.5,-0.799871"/>
- <dia:point val="15.5,1.7"/>
+ <dia:point val="20.1,-17.8497"/>
+ <dia:point val="20.1,-13.7249"/>
+ <dia:point val="17.4,-13.7249"/>
+ <dia:point val="17.4,-9.6"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="1"/>
@@ -981,7 +981,7 @@
<dia:enum val="1"/>
</dia:attribute>
<dia:attribute name="autorouting">
- <dia:boolean val="false"/>
+ <dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>##</dia:string>
@@ -1012,7 +1012,7 @@
<dia:string>#fkey_mb_user_id#</dia:string>
</dia:attribute>
<dia:attribute name="multiplicity">
- <dia:string>##</dia:string>
+ <dia:string>#on delete cascade on update cascade#</dia:string>
</dia:attribute>
<dia:attribute name="arrow">
<dia:boolean val="false"/>
@@ -1032,16 +1032,16 @@
</dia:object>
<dia:object type="UML - Association" version="1" id="O4">
<dia:attribute name="obj_pos">
- <dia:point val="17.075,9.6517"/>
+ <dia:point val="18.625,4.1497"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="14.75,4.15;21.65,10.4517"/>
+ <dia:rectangle val="16.65,-7.15;30.2,4.9497"/>
</dia:attribute>
<dia:attribute name="orth_points">
- <dia:point val="17.075,9.6517"/>
- <dia:point val="17.075,7.92505"/>
- <dia:point val="15.5,7.92505"/>
- <dia:point val="15.5,4.9"/>
+ <dia:point val="18.625,4.1497"/>
+ <dia:point val="18.625,-1.12515"/>
+ <dia:point val="17.4,-1.12515"/>
+ <dia:point val="17.4,-6.4"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="1"/>
@@ -1049,7 +1049,7 @@
<dia:enum val="1"/>
</dia:attribute>
<dia:attribute name="autorouting">
- <dia:boolean val="false"/>
+ <dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>##</dia:string>
@@ -1080,7 +1080,7 @@
<dia:string>#fkey_mb_group_id#</dia:string>
</dia:attribute>
<dia:attribute name="multiplicity">
- <dia:string>##</dia:string>
+ <dia:string>#on delete cascade on update cascade#</dia:string>
</dia:attribute>
<dia:attribute name="arrow">
<dia:boolean val="false"/>
@@ -1100,25 +1100,25 @@
</dia:object>
<dia:object type="UML - SmallPackage" version="0" id="O5">
<dia:attribute name="obj_pos">
- <dia:point val="32,-17.4625"/>
+ <dia:point val="10.8,21.8875"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="31.95,-18.4125;77.8,-14.4125"/>
+ <dia:rectangle val="10.75,20.9375;56.6,24.1375"/>
</dia:attribute>
<dia:attribute name="elem_corner">
- <dia:point val="32,-17.4625"/>
+ <dia:point val="10.8,21.8875"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="45.75"/>
</dia:attribute>
<dia:attribute name="elem_height">
- <dia:real val="3"/>
+ <dia:real val="2.2000000000000002"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="fill_colour">
- <dia:color val="#ffffff"/>
+ <dia:color val="#add8e6"/>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string>#postgres:post#</dia:string>
@@ -1126,8 +1126,7 @@
<dia:attribute name="text">
<dia:composite type="text">
<dia:attribute name="string">
- <dia:string>#ALTER TABLE mb_user ALTER COLUMN mb_user_id SET DEFAULT nextval('mb_user_id'::regclass);
-SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('mb_user','mb_user_id'), (SELECT max(mb_user_id) FROM mb_user), true);#</dia:string>
+ <dia:string>#SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('mb_user','mb_user_id'), (SELECT max(mb_user_id) FROM mb_user), true);#</dia:string>
</dia:attribute>
<dia:attribute name="font">
<dia:font family="monospace" style="0" name="Courier"/>
@@ -1136,7 +1135,7 @@
<dia:real val="0.80000000000000004"/>
</dia:attribute>
<dia:attribute name="pos">
- <dia:point val="32.3,-15.82"/>
+ <dia:point val="11.1,23.53"/>
</dia:attribute>
<dia:attribute name="color">
<dia:color val="#000000"/>
@@ -1149,16 +1148,16 @@
</dia:object>
<dia:object type="UML - SmallPackage" version="0" id="O6">
<dia:attribute name="obj_pos">
- <dia:point val="31.985,-13.1975"/>
+ <dia:point val="10.785,25.5025"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="31.935,-14.1475;42.085,-10.9475"/>
+ <dia:rectangle val="10.735,24.5525;42.235,27.7525"/>
</dia:attribute>
<dia:attribute name="elem_corner">
- <dia:point val="31.985,-13.1975"/>
+ <dia:point val="10.785,25.5025"/>
</dia:attribute>
<dia:attribute name="elem_width">
- <dia:real val="10.049999999999999"/>
+ <dia:real val="31.400000000000002"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="2.2000000000000002"/>
@@ -1167,15 +1166,15 @@
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="fill_colour">
- <dia:color val="#ffffff"/>
+ <dia:color val="#add8e6"/>
</dia:attribute>
<dia:attribute name="stereotype">
- <dia:string>#postgres:pre#</dia:string>
+ <dia:string>#innodb:pre#</dia:string>
</dia:attribute>
<dia:attribute name="text">
<dia:composite type="text">
<dia:attribute name="string">
- <dia:string>#CREATE SEQUENCE mb_user_id;#</dia:string>
+ <dia:string>#ALTER TABLE mb_user CHANGE COLUMN mb_user_id mb_user_id integer NOT NULL AUTO_INCREMENT;#</dia:string>
</dia:attribute>
<dia:attribute name="font">
<dia:font family="monospace" style="0" name="Courier"/>
@@ -1184,7 +1183,7 @@
<dia:real val="0.80000000000000004"/>
</dia:attribute>
<dia:attribute name="pos">
- <dia:point val="32.285,-11.555"/>
+ <dia:point val="11.085,27.145"/>
</dia:attribute>
<dia:attribute name="color">
<dia:color val="#000000"/>
@@ -1197,33 +1196,82 @@
</dia:object>
<dia:object type="UML - SmallPackage" version="0" id="O7">
<dia:attribute name="obj_pos">
- <dia:point val="31.985,-9.5975"/>
+ <dia:point val="10.8157,17.505"/>
</dia:attribute>
<dia:attribute name="obj_bb">
- <dia:rectangle val="31.935,-10.5475;63.435,-7.3475"/>
+ <dia:rectangle val="10.7657,16.555;43.6657,20.555"/>
</dia:attribute>
<dia:attribute name="elem_corner">
- <dia:point val="31.985,-9.5975"/>
+ <dia:point val="10.8157,17.505"/>
</dia:attribute>
<dia:attribute name="elem_width">
- <dia:real val="31.400000000000002"/>
+ <dia:real val="32.800000000000004"/>
</dia:attribute>
<dia:attribute name="elem_height">
+ <dia:real val="3"/>
+ </dia:attribute>
+ <dia:attribute name="line_colour">
+ <dia:color val="#000000"/>
+ </dia:attribute>
+ <dia:attribute name="fill_colour">
+ <dia:color val="#add8e6"/>
+ </dia:attribute>
+ <dia:attribute name="stereotype">
+ <dia:string>#postgres:pre#</dia:string>
+ </dia:attribute>
+ <dia:attribute name="text">
+ <dia:composite type="text">
+ <dia:attribute name="string">
+ <dia:string>#CREATE SEQUENCE mb_user_id_seq;
+ALTER TABLE mb_user ALTER COLUMN mb_user_id SET DEFAULT nextval('mb_user_id_seq'::regclass);#</dia:string>
+ </dia:attribute>
+ <dia:attribute name="font">
+ <dia:font family="monospace" style="0" name="Courier"/>
+ </dia:attribute>
+ <dia:attribute name="height">
+ <dia:real val="0.80000000000000004"/>
+ </dia:attribute>
+ <dia:attribute name="pos">
+ <dia:point val="11.1157,19.1475"/>
+ </dia:attribute>
+ <dia:attribute name="color">
+ <dia:color val="#000000"/>
+ </dia:attribute>
+ <dia:attribute name="alignment">
+ <dia:enum val="0"/>
+ </dia:attribute>
+ </dia:composite>
+ </dia:attribute>
+ </dia:object>
+ <dia:object type="UML - SmallPackage" version="0" id="O8">
+ <dia:attribute name="obj_pos">
+ <dia:point val="10.8083,38.855"/>
+ </dia:attribute>
+ <dia:attribute name="obj_bb">
+ <dia:rectangle val="10.7583,37.905;43.3083,41.105"/>
+ </dia:attribute>
+ <dia:attribute name="elem_corner">
+ <dia:point val="10.8083,38.855"/>
+ </dia:attribute>
+ <dia:attribute name="elem_width">
+ <dia:real val="32.450000000000003"/>
+ </dia:attribute>
+ <dia:attribute name="elem_height">
<dia:real val="2.2000000000000002"/>
</dia:attribute>
<dia:attribute name="line_colour">
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="fill_colour">
- <dia:color val="#ffffff"/>
+ <dia:color val="#add8e6"/>
</dia:attribute>
<dia:attribute name="stereotype">
- <dia:string>#mysql:post#</dia:string>
+ <dia:string>#innodb:pre#</dia:string>
</dia:attribute>
<dia:attribute name="text">
<dia:composite type="text">
<dia:attribute name="string">
- <dia:string>#ALTER TABLE mb_user CHANGE COLUMN mb_user_id mb_user_id integer NOT NULL AUTO_INCREMENT;#</dia:string>
+ <dia:string>#ALTER TABLE mb_group CHANGE COLUMN mb_group_id mb_group_id integer NOT NULL AUTO_INCREMENT;#</dia:string>
</dia:attribute>
<dia:attribute name="font">
<dia:font family="monospace" style="0" name="Courier"/>
@@ -1232,7 +1280,7 @@
<dia:real val="0.80000000000000004"/>
</dia:attribute>
<dia:attribute name="pos">
- <dia:point val="32.285,-7.955"/>
+ <dia:point val="11.1083,40.4975"/>
</dia:attribute>
<dia:attribute name="color">
<dia:color val="#000000"/>
@@ -1243,5 +1291,102 @@
</dia:composite>
</dia:attribute>
</dia:object>
+ <dia:object type="UML - SmallPackage" version="0" id="O9">
+ <dia:attribute name="obj_pos">
+ <dia:point val="10.7583,35.33"/>
+ </dia:attribute>
+ <dia:attribute name="obj_bb">
+ <dia:rectangle val="10.7083,34.38;57.9583,37.58"/>
+ </dia:attribute>
+ <dia:attribute name="elem_corner">
+ <dia:point val="10.7583,35.33"/>
+ </dia:attribute>
+ <dia:attribute name="elem_width">
+ <dia:real val="47.149999999999999"/>
+ </dia:attribute>
+ <dia:attribute name="elem_height">
+ <dia:real val="2.2000000000000002"/>
+ </dia:attribute>
+ <dia:attribute name="line_colour">
+ <dia:color val="#000000"/>
+ </dia:attribute>
+ <dia:attribute name="fill_colour">
+ <dia:color val="#add8e6"/>
+ </dia:attribute>
+ <dia:attribute name="stereotype">
+ <dia:string>#postgres:post#</dia:string>
+ </dia:attribute>
+ <dia:attribute name="text">
+ <dia:composite type="text">
+ <dia:attribute name="string">
+ <dia:string>#SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('mb_group','mb_group_id'), (SELECT max(mb_group_id) FROM mb_group), true);#</dia:string>
+ </dia:attribute>
+ <dia:attribute name="font">
+ <dia:font family="monospace" style="0" name="Courier"/>
+ </dia:attribute>
+ <dia:attribute name="height">
+ <dia:real val="0.80000000000000004"/>
+ </dia:attribute>
+ <dia:attribute name="pos">
+ <dia:point val="11.0583,36.9725"/>
+ </dia:attribute>
+ <dia:attribute name="color">
+ <dia:color val="#000000"/>
+ </dia:attribute>
+ <dia:attribute name="alignment">
+ <dia:enum val="0"/>
+ </dia:attribute>
+ </dia:composite>
+ </dia:attribute>
+ </dia:object>
+ <dia:object type="UML - SmallPackage" version="0" id="O10">
+ <dia:attribute name="obj_pos">
+ <dia:point val="10.7083,31.03"/>
+ </dia:attribute>
+ <dia:attribute name="obj_bb">
+ <dia:rectangle val="10.6583,30.08;44.6083,34.08"/>
+ </dia:attribute>
+ <dia:attribute name="elem_corner">
+ <dia:point val="10.7083,31.03"/>
+ </dia:attribute>
+ <dia:attribute name="elem_width">
+ <dia:real val="33.850000000000001"/>
+ </dia:attribute>
+ <dia:attribute name="elem_height">
+ <dia:real val="3"/>
+ </dia:attribute>
+ <dia:attribute name="line_colour">
+ <dia:color val="#000000"/>
+ </dia:attribute>
+ <dia:attribute name="fill_colour">
+ <dia:color val="#add8e6"/>
+ </dia:attribute>
+ <dia:attribute name="stereotype">
+ <dia:string>#postgres:pre#</dia:string>
+ </dia:attribute>
+ <dia:attribute name="text">
+ <dia:composite type="text">
+ <dia:attribute name="string">
+ <dia:string>#CREATE SEQUENCE mb_group_id_seq;
+ALTER TABLE mb_group ALTER COLUMN mb_group_id SET DEFAULT nextval('mb_group_id_seq'::regclass);#</dia:string>
+ </dia:attribute>
+ <dia:attribute name="font">
+ <dia:font family="monospace" style="0" name="Courier"/>
+ </dia:attribute>
+ <dia:attribute name="height">
+ <dia:real val="0.80000000000000004"/>
+ </dia:attribute>
+ <dia:attribute name="pos">
+ <dia:point val="11.0083,32.6725"/>
+ </dia:attribute>
+ <dia:attribute name="color">
+ <dia:color val="#000000"/>
+ </dia:attribute>
+ <dia:attribute name="alignment">
+ <dia:enum val="0"/>
+ </dia:attribute>
+ </dia:composite>
+ </dia:attribute>
+ </dia:object>
</dia:layer>
</dia:diagram>
More information about the Mapbender_commits
mailing list