Bugs in SQL-Import of Autodia 2.03
- From: Patrick Kilian <mail petschge de>
- To: dia-list gnome org
- Cc: hans breuer org
- Subject: Bugs in SQL-Import of Autodia 2.03
- Date: Thu, 10 Jan 2008 13:35:03 +0100
Hello,
I am trying to generate diagrams from SQL dumps of a MySQL database
which I administrate. I found the tool autodia which seems to do what I
need. So I downloaded version 2.03 from
http://search.cpan.org/CPAN/authors/id/T/TE/TEEJAY/Autodia-2.03.tar.gz
and tried it.
When I run autodia on the dumpfile I get the following output:
getting handlers..
getting pattern for sql
AutoDia - version 2.03(c) Copyright 2003 A Trevena
using language : sql
..using Autodia::Handler::SQL
opening dump
Can't call method "add_attribute" on an undefined value at
/usr/lib/perl5/site_perl/5.8.8/Autodia/Handler/SQL.pm line 86, <INFILE>
line 96613.
Line 96613 is the very last line of the file an contains:
-- Dump completed on 2008-01-10 12:02:37
Unfortunately I can not give you that file for debugging so I decided to
strip town the dump to the minimum needed to reproduce the error.
The first step was:
cat dump | grep -v "INSERT" | grep -v "^--" | grep -v LOCK | grep -v
"^\/\*" | uniq > dump_a.sql
And the resulting file is attached to this email.
If I run "autodia.pl -l sql dump_a.sql" I get:
getting handlers..
getting pattern for sql
AutoDia - version 2.03(c) Copyright 2003 A Trevena
using language : sql
..using Autodia::Handler::SQL
opening dump_a.sql
Can't call method "add_attribute" on an undefined value at
/usr/lib/perl5/site_perl/5.8.8/Autodia/Handler/SQL.pm line 86, <INFILE>
line 402.
I continued to further strip down the sql dump and found that the inline
comments /* ... */ caused the problem. Removing them from the dump file
allowed autodia to complete with the following output:
getting handlers..
getting pattern for sql
AutoDia - version 2.03(c) Copyright 2003 A Trevena
using language : sql
..using Autodia::Handler::SQL
opening dump_b.sql
using default (dia) template
Diagram.pm : Dependancies : no dependancies to be printed - ignoring..
Diagram.pm : Dependancies : no dependancies to be printed - ignoring..
Diagram.pm : Dependancies : no dependancies to be printed - ignoring..
written outfile : autodia.out.xml successfully
complete. (processed 1 files)
But if I run dia on the resulting file autodia.out.xml I get:
<type 'exceptions.SyntaxError'>SyntaxError('invalid syntax',
('<string>', 1, 4, 'Dia:diagram()'))Traceback (most recent call last):
File "/usr/share/dia/python/doxrev.py", line 482, in import_file
classes = GetClasses ([sFile])
File "/usr/share/dia/python/doxrev.py", line 400, in GetClasses
classes.extend (Parse (f.read()))
File "/usr/share/dia/python/doxrev.py", line 391, in Parse
p.Parse(sData)
File "/usr/share/dia/python/doxrev.py", line 344, in start_element
o = eval (s + "()")
Thank you for using Dia.
The dia version I use is
Dia version 0.96.1, compiled 23:09:04 Sep 22 2007
as shipped with openSuSE 10.3
Looking at the output with vim I was unable to find anything in the xml
file which looked wrong.
Could you please give me some help how to debug this problem?
Greets,
Patrick "Petschge" Kilian
PS.: Please CC my email address as I am not subscribed to the list. Thanks.
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `t_login` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `t_login`;
DROP TABLE IF EXISTS `cookie`;
CREATE TABLE `cookie` (
`id` int(11) NOT NULL auto_increment,
`matrikelnr` int(11) NOT NULL default '0',
`capa` int(11) NOT NULL default '0',
`expire` int(11) NOT NULL default '0',
`userinfo` mediumtext,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2147478054 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `email`;
CREATE TABLE `email` (
`matrikelnr` int(11) NOT NULL default '0',
`email` text,
PRIMARY KEY (`matrikelnr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
`matrikelnr` int(11) NOT NULL default '0',
`art` int(11) NOT NULL default '9',
`passwd` text NOT NULL,
`level` int(11) default '0',
`hidden` int(11) default '0',
`chaot` int(11) NOT NULL default '0',
PRIMARY KEY (`matrikelnr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `people`;
CREATE TABLE `people` (
`matrikelnr` int(11) NOT NULL default '0',
`name` text,
`vorname` text,
PRIMARY KEY (`matrikelnr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `schein`;
CREATE TABLE `schein` (
`matrikelnr` int(11) NOT NULL default '0',
`geburtsort` text NOT NULL,
`geburtsdatum` text NOT NULL,
`sid` int(11) NOT NULL default '9',
`active` int(11) NOT NULL default '1',
PRIMARY KEY (`matrikelnr`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `studienrichtungen`;
CREATE TABLE `studienrichtungen` (
`sid` int(11) NOT NULL auto_increment,
`kennbuchstabe` tinytext NOT NULL,
`studienrichtung` text NOT NULL,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `t_pa` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `t_pa`;
DROP TABLE IF EXISTS `data`;
CREATE TABLE `data` (
`nr` int(11) NOT NULL auto_increment,
`matrikelnr` int(11) NOT NULL default '0',
`aid` int(11) default NULL,
`tid` int(11) default NULL,
`partner` int(11) default NULL,
`error` int(11) NOT NULL default '0',
`immutable` tinyint(1) default NULL,
`dropout` tinyint(1) default '0',
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`nr`),
KEY `index_partner` (`partner`),
KEY `index_matrikel` (`matrikelnr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `wuensche`;
CREATE TABLE `wuensche` (
`nr` int(11) NOT NULL auto_increment,
`matrikelnr` int(11) NOT NULL default '0',
`aid` int(11) NOT NULL default '0',
`tid` int(11) NOT NULL default '0',
`partner` int(11) NOT NULL default '0',
`prioritaet` smallint(6) NOT NULL default '0',
KEY `nr` (`nr`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `t_orga` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `t_orga`;
DROP TABLE IF EXISTS `abfolge`;
CREATE TABLE `abfolge` (
`aid` int(11) NOT NULL auto_increment,
`eid` int(11) NOT NULL default '0',
`kid` int(11) NOT NULL default '0',
`zeile` int(11) NOT NULL default '0',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM AUTO_INCREMENT=2671 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `ctermin`;
CREATE TABLE `ctermin` (
`betreuer` int(11) NOT NULL,
`eid` int(11) NOT NULL,
`kid` int(11) NOT NULL,
`cid` int(11) NOT NULL,
`zeit` int(11) NOT NULL,
`rid` int(11) NOT NULL,
UNIQUE KEY `betreuer_eid_kid_cid` (`betreuer`,`eid`,`kid`,`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `daten`;
CREATE TABLE `daten` (
`eid` int(11) NOT NULL default '0',
`tid` int(11) NOT NULL default '0',
`did` int(11) NOT NULL default '0',
`datum` varchar(64) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `kurs`;
CREATE TABLE `kurs` (
`kid` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`beschreibung` text,
PRIMARY KEY (`kid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `mapping`;
CREATE TABLE `mapping` (
`VerNR` int(8) NOT NULL default '0',
`eid` int(8) NOT NULL default '0',
`kid` int(8) NOT NULL default '0',
PRIMARY KEY (`VerNR`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `raum`;
CREATE TABLE `raum` (
`rid` int(11) NOT NULL auto_increment,
`name` varchar(64) NOT NULL,
`beschreibung` text,
PRIMARY KEY (`rid`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `semester`;
CREATE TABLE `semester` (
`semesterid` int(11) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`semesterid`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `slot`;
CREATE TABLE `slot` (
`eid` int(11) default NULL,
`kid` int(11) default NULL,
`tid` int(11) default NULL,
`max` int(11) default NULL,
`used` int(11) default NULL,
`locked` int(11) default NULL,
`regular` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `slot_kom`;
CREATE TABLE `slot_kom` (
`eid` int(11) NOT NULL default '0',
`kid` int(11) NOT NULL default '0',
`tid` int(11) NOT NULL default '0',
`kommentar` text,
KEY `eid_kid_tid` (`eid`,`kid`,`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `termin`;
CREATE TABLE `termin` (
`tid` int(11) NOT NULL auto_increment,
`name` varchar(64) default NULL,
`datum` text,
PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `veranstaltung`;
CREATE TABLE `veranstaltung` (
`eid` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`semester` int(11) default NULL,
`active` int(2) default NULL,
`visible` int(2) default NULL,
`groupsize` int(11) NOT NULL default '1',
`art` int(11) default NULL,
`finaltest` int(3) NOT NULL default '0',
`easyedit` int(1) NOT NULL default '0',
`nrwishes` int(1) NOT NULL default '0',
PRIMARY KEY (`eid`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `veranstaltungsart`;
CREATE TABLE `veranstaltungsart` (
`art` int(11) NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
`bw1_name` varchar(64) NOT NULL default 'Punkte 1',
`bw1_sn` varchar(4) NOT NULL default '',
`bw1_min` int(11) NOT NULL default '0',
`bw1_default` int(11) NOT NULL default '0',
`bw1_max` int(11) NOT NULL default '12',
`bw1_mult` int(11) NOT NULL default '1',
`bw2_name` varchar(64) NOT NULL default 'Punkte 2',
`bw2_sn` varchar(4) NOT NULL default '',
`bw2_min` int(11) NOT NULL default '0',
`bw2_default` int(11) NOT NULL default '0',
`bw2_max` int(11) NOT NULL default '12',
`bw2_mult` int(11) NOT NULL default '1',
PRIMARY KEY (`art`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `versuch`;
CREATE TABLE `versuch` (
`vid` int(11) NOT NULL default '0',
`name` text NOT NULL,
`beschreibung` text NOT NULL,
PRIMARY KEY (`vid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `zeile`;
CREATE TABLE `zeile` (
`aid` int(11) NOT NULL default '0',
`did` int(11) NOT NULL default '0',
`vid` int(11) NOT NULL default '0',
KEY `adid_index` (`aid`,`did`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `t_punkte` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `t_punkte`;
DROP TABLE IF EXISTS `kolloq`;
CREATE TABLE `kolloq` (
`matrikelnr` int(11) NOT NULL default '0',
`eid` int(11) NOT NULL default '0',
`kid` int(11) NOT NULL default '0',
`pruefer` int(11) default '0',
`cid` int(11) default NULL,
`status` int(11) default '0',
`ergebnis` int(11) default '-1',
`kommentar` text,
UNIQUE KEY `matrikelnr_eid_kid` (`matrikelnr`,`eid`,`kid`),
KEY `matnr_eid_kid` (`matrikelnr`,`eid`,`kid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `punkte`;
CREATE TABLE `punkte` (
`matrikelnr` int(11) NOT NULL default '0',
`eid` int(11) NOT NULL default '0',
`vid` int(11) NOT NULL default '0',
`bw1` int(11) NOT NULL default '0',
`bw2` int(11) NOT NULL default '0',
`bemerkung` varchar(255) NOT NULL default '-',
`betreuer` int(11) NOT NULL default '0',
`modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
KEY `punkte_index` (`matrikelnr`,`eid`,`vid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `t_gui` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `t_gui`;
DROP TABLE IF EXISTS `kolloq`;
CREATE TABLE `kolloq` (
`bid` int(11) NOT NULL default '0',
`art` int(11) NOT NULL default '0',
`button` text NOT NULL,
`action` text NOT NULL,
`alttext` text NOT NULL,
`eintrag` text,
PRIMARY KEY (`bid`,`art`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `t_log` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `t_log`;
DROP TABLE IF EXISTS `bug`;
CREATE TABLE `bug` (
`id` int(11) NOT NULL auto_increment,
`message` text,
`file` text,
`line` int(11) default NULL,
`timestamp` int(11) default NULL,
`matrikelnr` int(11) default NULL,
`seen` int(11) default NULL,
`userip` varchar(128) default NULL,
`browser` text,
`referer` varchar(150) default NULL,
`to_site` text,
`zusatzinfo` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=234 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `feedback`;
CREATE TABLE `feedback` (
`id` int(11) NOT NULL auto_increment,
`referer` varchar(150) default NULL,
`message` text,
`email` varchar(150) default NULL,
`time` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `t_import` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `t_import`;
DROP TABLE IF EXISTS `k_parallel`;
CREATE TABLE `k_parallel` (
`id` int(1) NOT NULL,
`kurzbez` text NOT NULL,
`aktiv` varchar(2) NOT NULL,
`gruppennr` varchar(50) NOT NULL,
`gruppenname` text NOT NULL,
`gruppenname2` text NOT NULL,
`none` text NOT NULL,
`none2` text NOT NULL,
`timestamp` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `k_rhythmus`;
CREATE TABLE `k_rhythmus` (
`id` int(1) NOT NULL,
`kurzbez` text NOT NULL,
`aktiv` varchar(2) NOT NULL,
`kurzbez2` text NOT NULL,
`bezeichnung` text NOT NULL,
`bezeichnung2` text NOT NULL,
`none` text NOT NULL,
`abstand` varchar(10) NOT NULL,
`timestamp` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `k_verart`;
CREATE TABLE `k_verart` (
`id` text NOT NULL,
`aktiv` varchar(2) NOT NULL,
`kurzbez` text NOT NULL,
`bezeichnung` text NOT NULL,
`bezeichnung2` text NOT NULL,
`timestamp` text NOT NULL,
`zahlen` int(1) NOT NULL,
`none` text NOT NULL,
`none2` text NOT NULL,
`none3` text NOT NULL,
`none4` text NOT NULL,
`none5` text NOT NULL,
`none6` text NOT NULL,
`none7` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `k_wochentag`;
CREATE TABLE `k_wochentag` (
`id` int(1) NOT NULL,
`kurzbez` text NOT NULL,
`aktiv` varchar(2) NOT NULL,
`kurzbez2` text NOT NULL,
`bezeichnung` text NOT NULL,
`bezeichnung2` text NOT NULL,
`wochentag` varchar(3) NOT NULL,
`timestamp` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `r_beleg`;
CREATE TABLE `r_beleg` (
`id` int(1) NOT NULL,
`veranstaltung_id` int(1) NOT NULL,
`zugelassen` varchar(3) NOT NULL,
`none` text NOT NULL,
`matrikelnr` varchar(8) NOT NULL,
`sospos` varchar(6) NOT NULL,
`k_parallel_id` int(1) NOT NULL,
`timestamp` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `veranstaltung`;
CREATE TABLE `veranstaltung` (
`id` int(1) NOT NULL,
`k_verart_id` int(1) NOT NULL,
`aktiv` varchar(1) NOT NULL,
`vorlesungsvz_id` int(1) NOT NULL,
`name` text NOT NULL,
`timestamp` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `veransttermin`;
CREATE TABLE `veransttermin` (
`id` int(1) NOT NULL,
`uhrz_start` varchar(5) NOT NULL,
`uhrz_ende` varchar(5) NOT NULL,
`k_wochentag_id` int(1) NOT NULL,
`k_rhythmus_id` int(1) NOT NULL,
`k_parallel_id` int(1) NOT NULL,
`veranstaltung_id` int(1) NOT NULL,
`timestamp` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE DATABASE `t_login`;
USE `t_login`;
DROP TABLE IF EXISTS `cookie`;
CREATE TABLE `cookie` (
`id` int(11) NOT NULL auto_increment,
`matrikelnr` int(11) NOT NULL default '0',
`capa` int(11) NOT NULL default '0',
`expire` int(11) NOT NULL default '0',
`userinfo` mediumtext,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2147478054 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `email`;
CREATE TABLE `email` (
`matrikelnr` int(11) NOT NULL default '0',
`email` text,
PRIMARY KEY (`matrikelnr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
`matrikelnr` int(11) NOT NULL default '0',
`art` int(11) NOT NULL default '9',
`passwd` text NOT NULL,
`level` int(11) default '0',
`hidden` int(11) default '0',
`chaot` int(11) NOT NULL default '0',
PRIMARY KEY (`matrikelnr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `people`;
CREATE TABLE `people` (
`matrikelnr` int(11) NOT NULL default '0',
`name` text,
`vorname` text,
PRIMARY KEY (`matrikelnr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `schein`;
CREATE TABLE `schein` (
`matrikelnr` int(11) NOT NULL default '0',
`geburtsort` text NOT NULL,
`geburtsdatum` text NOT NULL,
`sid` int(11) NOT NULL default '9',
`active` int(11) NOT NULL default '1',
PRIMARY KEY (`matrikelnr`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `studienrichtungen`;
CREATE TABLE `studienrichtungen` (
`sid` int(11) NOT NULL auto_increment,
`kennbuchstabe` tinytext NOT NULL,
`studienrichtung` text NOT NULL,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;
<?xml version="1.0"?>
<dia:diagram xmlns:dia="http://www.lysator.liu.se/~alla/dia/";>
<dia:diagramdata>
<dia:attribute name="background">
<dia:color val="#ffffff"/>
</dia:attribute>
<dia:attribute name="paper">
<dia:composite type="paper">
<dia:attribute name="name">
<dia:string>#A4#</dia:string>
</dia:attribute>
<dia:attribute name="tmargin">
<dia:real val="2.82"/>
</dia:attribute>
<dia:attribute name="bmargin">
<dia:real val="2.82"/>
</dia:attribute>
<dia:attribute name="lmargin">
<dia:real val="2.82"/>
</dia:attribute>
<dia:attribute name="rmargin">
<dia:real val="2.82"/>
</dia:attribute>
<dia:attribute name="is_portrait">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="scaling">
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="fitto">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="grid">
<dia:composite type="grid">
<dia:attribute name="width_x">
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="width_y">
<dia:real val="1"/>
</dia:attribute>
<dia:attribute name="visible_x">
<dia:int val="1"/>
</dia:attribute>
<dia:attribute name="visible_y">
<dia:int val="1"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="guides">
<dia:composite type="guides">
<dia:attribute name="hguides"/>
<dia:attribute name="vguides"/>
</dia:composite>
</dia:attribute>
</dia:diagramdata>
<dia:layer name="Background" visible="true">
<dia:object type="UML - Class" version="0" id="O1">
<dia:attribute name="obj_pos">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="1.000,1.000;10.000,5.400"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="9.000"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="4.400"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#email#</dia:string>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_attributes">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_operations">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="visible_attributes">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="visible_operations">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="foreground_color">
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="background_color">
<dia:color val="#ffffff"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`matrikelnr`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`email`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#text#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="operations">
<dia:composite type="umloperation">
<dia:attribute name="name">
<dia:string>#Primary Key#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#pk#</dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="parameters">
<dia:composite type="umlparameter">
<dia:attribute name="name">
<dia:string>#`matrikelnr`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="kind">
<dia:enum val="0"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="template">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="templates"/>
</dia:object>
<dia:object type="UML - Class" version="0" id="O3">
<dia:attribute name="obj_pos">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="1.000,1.000;10.000,6.200"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="9.000"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="5.200"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#people#</dia:string>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_attributes">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_operations">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="visible_attributes">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="visible_operations">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="foreground_color">
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="background_color">
<dia:color val="#ffffff"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`matrikelnr`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`name`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#text#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`vorname`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#text#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="operations">
<dia:composite type="umloperation">
<dia:attribute name="name">
<dia:string>#Primary Key#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#pk#</dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="parameters">
<dia:composite type="umlparameter">
<dia:attribute name="name">
<dia:string>#`matrikelnr`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="kind">
<dia:enum val="0"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="template">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="templates"/>
</dia:object>
<dia:object type="UML - Class" version="0" id="O4">
<dia:attribute name="obj_pos">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="1.000,1.000;10.000,7.800"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="9.000"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="6.800"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#schein#</dia:string>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_attributes">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_operations">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="visible_attributes">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="visible_operations">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="foreground_color">
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="background_color">
<dia:color val="#ffffff"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`matrikelnr`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`geburtsort`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#text#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`geburtsdatum`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#text#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`sid`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`active`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="operations">
<dia:composite type="umloperation">
<dia:attribute name="name">
<dia:string>#Primary Key#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#pk#</dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="parameters">
<dia:composite type="umlparameter">
<dia:attribute name="name">
<dia:string>#`matrikelnr`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="kind">
<dia:enum val="0"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="template">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="templates"/>
</dia:object>
<dia:object type="UML - Class" version="0" id="O0">
<dia:attribute name="obj_pos">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="1.000,1.000;10.000,7.000"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="9.000"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="6.000"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#cookie#</dia:string>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_attributes">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_operations">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="visible_attributes">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="visible_operations">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="foreground_color">
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="background_color">
<dia:color val="#ffffff"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`id`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`matrikelnr`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`capa`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`expire`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="operations">
<dia:composite type="umloperation">
<dia:attribute name="name">
<dia:string>#Primary Key#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#pk#</dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="parameters">
<dia:composite type="umlparameter">
<dia:attribute name="name">
<dia:string>#`id`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="kind">
<dia:enum val="0"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="template">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="templates"/>
</dia:object>
<dia:object type="UML - Class" version="0" id="O5">
<dia:attribute name="obj_pos">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="1.000,1.000;10.000,5.400"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="9.000"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="4.400"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#studienrichtungen#</dia:string>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_attributes">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_operations">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="visible_attributes">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="visible_operations">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="foreground_color">
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="background_color">
<dia:color val="#ffffff"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`sid`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`studienrichtung`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#text#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="operations">
<dia:composite type="umloperation">
<dia:attribute name="name">
<dia:string>#Primary Key#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#pk#</dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="parameters">
<dia:composite type="umlparameter">
<dia:attribute name="name">
<dia:string>#`sid`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="kind">
<dia:enum val="0"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="template">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="templates"/>
</dia:object>
<dia:object type="UML - Class" version="0" id="O2">
<dia:attribute name="obj_pos">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="1.000,1.000;10.000,8.600"/>
</dia:attribute>
<dia:attribute name="elem_corner">
<dia:point val="1.000,1.000"/>
</dia:attribute>
<dia:attribute name="elem_width">
<dia:real val="9.000"/>
</dia:attribute>
<dia:attribute name="elem_height">
<dia:real val="7.600"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string>#login#</dia:string>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_attributes">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="suppress_operations">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="visible_attributes">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="visible_operations">
<dia:boolean val="true"/>
</dia:attribute>
<dia:attribute name="foreground_color">
<dia:color val="#000000"/>
</dia:attribute>
<dia:attribute name="background_color">
<dia:color val="#ffffff"/>
</dia:attribute>
<dia:attribute name="attributes">
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`matrikelnr`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`art`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`passwd`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#text#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`level`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`hidden`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
<dia:composite type="umlattribute">
<dia:attribute name="name">
<dia:string>#`chaot`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#int(11)#</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:string></dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="operations">
<dia:composite type="umloperation">
<dia:attribute name="name">
<dia:string>#Primary Key#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>#pk#</dia:string>
</dia:attribute>
<dia:attribute name="visibility">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="abstract">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="class_scope">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="parameters">
<dia:composite type="umlparameter">
<dia:attribute name="name">
<dia:string>#`matrikelnr`#</dia:string>
</dia:attribute>
<dia:attribute name="type">
<dia:string>##</dia:string>
</dia:attribute>
<dia:attribute name="value">
<dia:enum val="0"/>
</dia:attribute>
<dia:attribute name="kind">
<dia:enum val="0"/>
</dia:attribute>
</dia:composite>
</dia:attribute>
</dia:composite>
</dia:attribute>
<dia:attribute name="template">
<dia:boolean val="false"/>
</dia:attribute>
<dia:attribute name="templates"/>
</dia:object>
<dia:object type="UML - Generalization" version="0" id="O13">
<dia:attribute name="obj_pos">
<dia:point val="2.5,-2"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="2.5,-2;7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="2.5,-2"/>
<dia:point val="2.5,-0.5"/>
<dia:point val="7.5,-0.5"/>
<dia:point val="7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="1"/>
<dia:enum val="0"/>
<dia:enum val="1"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string/>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O0" connection="6"/>
<dia:connection handle="1" to="O0" connection="1"/>
</dia:connections>
</dia:object>
<dia:object type="UML - Generalization" version="0" id="O10">
<dia:attribute name="obj_pos">
<dia:point val="2.5,-2"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="2.5,-2;7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="2.5,-2"/>
<dia:point val="2.5,-0.5"/>
<dia:point val="7.5,-0.5"/>
<dia:point val="7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="1"/>
<dia:enum val="0"/>
<dia:enum val="1"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string/>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O4" connection="6"/>
<dia:connection handle="1" to="O2" connection="1"/>
</dia:connections>
</dia:object>
<dia:object type="UML - Generalization" version="0" id="O12">
<dia:attribute name="obj_pos">
<dia:point val="2.5,-2"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="2.5,-2;7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="2.5,-2"/>
<dia:point val="2.5,-0.5"/>
<dia:point val="7.5,-0.5"/>
<dia:point val="7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="1"/>
<dia:enum val="0"/>
<dia:enum val="1"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string/>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O4" connection="6"/>
<dia:connection handle="1" to="O4" connection="1"/>
</dia:connections>
</dia:object>
<dia:object type="UML - Generalization" version="0" id="O8">
<dia:attribute name="obj_pos">
<dia:point val="2.5,-2"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="2.5,-2;7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="2.5,-2"/>
<dia:point val="2.5,-0.5"/>
<dia:point val="7.5,-0.5"/>
<dia:point val="7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="1"/>
<dia:enum val="0"/>
<dia:enum val="1"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string/>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O4" connection="6"/>
<dia:connection handle="1" to="O0" connection="1"/>
</dia:connections>
</dia:object>
<dia:object type="UML - Generalization" version="0" id="O6">
<dia:attribute name="obj_pos">
<dia:point val="2.5,-2"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="2.5,-2;7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="2.5,-2"/>
<dia:point val="2.5,-0.5"/>
<dia:point val="7.5,-0.5"/>
<dia:point val="7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="1"/>
<dia:enum val="0"/>
<dia:enum val="1"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string/>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O5" connection="6"/>
<dia:connection handle="1" to="O4" connection="1"/>
</dia:connections>
</dia:object>
<dia:object type="UML - Generalization" version="0" id="O7">
<dia:attribute name="obj_pos">
<dia:point val="2.5,-2"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="2.5,-2;7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="2.5,-2"/>
<dia:point val="2.5,-0.5"/>
<dia:point val="7.5,-0.5"/>
<dia:point val="7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="1"/>
<dia:enum val="0"/>
<dia:enum val="1"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string/>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O5" connection="6"/>
<dia:connection handle="1" to="O5" connection="1"/>
</dia:connections>
</dia:object>
<dia:object type="UML - Generalization" version="0" id="O9">
<dia:attribute name="obj_pos">
<dia:point val="2.5,-2"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="2.5,-2;7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="2.5,-2"/>
<dia:point val="2.5,-0.5"/>
<dia:point val="7.5,-0.5"/>
<dia:point val="7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="1"/>
<dia:enum val="0"/>
<dia:enum val="1"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string/>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O4" connection="6"/>
<dia:connection handle="1" to="O1" connection="1"/>
</dia:connections>
</dia:object>
<dia:object type="UML - Generalization" version="0" id="O11">
<dia:attribute name="obj_pos">
<dia:point val="2.5,-2"/>
</dia:attribute>
<dia:attribute name="obj_bb">
<dia:rectangle val="2.5,-2;7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_points">
<dia:point val="2.5,-2"/>
<dia:point val="2.5,-0.5"/>
<dia:point val="7.5,-0.5"/>
<dia:point val="7.5,1.000"/>
</dia:attribute>
<dia:attribute name="orth_orient">
<dia:enum val="1"/>
<dia:enum val="0"/>
<dia:enum val="1"/>
</dia:attribute>
<dia:attribute name="name">
<dia:string/>
</dia:attribute>
<dia:attribute name="stereotype">
<dia:string/>
</dia:attribute>
<dia:connections>
<dia:connection handle="0" to="O4" connection="6"/>
<dia:connection handle="1" to="O3" connection="1"/>
</dia:connections>
</dia:object>
</dia:layer>
</dia:diagram>
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]
