<?xml version="1.0" encoding="windows-1252"?>
<!DOCTYPE XMI SYSTEM "UML_EA.dtd">
<XMI xmi.version="1.1" xmlns:UML="omg.org/UML1.3" timestamp="2011-06-18 08:45:46">
<XMI.header>
<XMI.documentation>
<XMI.exporter>Enterprise Architect</XMI.exporter>
<XMI.exporterVersion>2.5</XMI.exporterVersion>
</XMI.documentation>
</XMI.header>
<XMI.content>
<UML:Model name="EA Model" xmi.id="MX_EAID_7684FDB7_8D96_4a8c_91FD_137381277669">
<UML:Namespace.ownedElement>
<UML:Class name="EARootClass" xmi.id="EAID_11111111_5487_4080_A7F4_41526CB0AA00" isRoot="true" isLeaf="false" isAbstract="false"/>
<UML:Package name="Schema1" xmi.id="EAPK_7684FDB7_8D96_4a8c_91FD_137381277669" isRoot="false" isLeaf="false" isAbstract="false" visibility="public">
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="parent" value="EAID_2909FDB0_0A57_48dd_9395_CFDDFE432423"/>
<UML:TaggedValue tag="created" value="2011-06-18 08:10:10"/>
<UML:TaggedValue tag="modified" value="2011-06-18 08:10:10"/>
<UML:TaggedValue tag="iscontrolled" value="FALSE"/>
<UML:TaggedValue tag="lastloaddate" value="2011-06-18 08:10:10"/>
<UML:TaggedValue tag="lastsavedate" value="2011-06-18 08:10:10"/>
<UML:TaggedValue tag="isprotected" value="FALSE"/>
<UML:TaggedValue tag="usedtd" value="FALSE"/>
<UML:TaggedValue tag="logxml" value="FALSE"/>
<UML:TaggedValue tag="packageFlags" value="CRC=0;"/>
<UML:TaggedValue tag="batchsave" value="0"/>
<UML:TaggedValue tag="batchload" value="0"/>
<UML:TaggedValue tag="phase" value="1.0"/>
<UML:TaggedValue tag="status" value="Proposed"/>
<UML:TaggedValue tag="complexity" value="1"/>
<UML:TaggedValue tag="ea_stype" value="Public"/>
<UML:TaggedValue tag="eventflags" value="LNK=5560;"/>
<UML:TaggedValue tag="tpos" value="0"/>
<UML:TaggedValue tag="gentype" value="Java"/>
</UML:ModelElement.taggedValue>
<UML:Namespace.ownedElement>
<UML:Class name="users" xmi.id="EAID_1A60F71D_CEAD_4693_9164_FF166C034D12" visibility="public" namespace="EAPK_7684FDB7_8D96_4a8c_91FD_137381277669" isRoot="false" isLeaf="false" isAbstract="false" isActive="false">
<UML:ModelElement.stereotype>
<UML:Stereotype name="table"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="isSpecification" value="false"/>
<UML:TaggedValue tag="ea_stype" value="Class"/>
<UML:TaggedValue tag="ea_ntype" value="0"/>
<UML:TaggedValue tag="version" value="1.0"/>
<UML:TaggedValue tag="package" value="EAPK_7684FDB7_8D96_4a8c_91FD_137381277669"/>
<UML:TaggedValue tag="date_created" value="2005-11-22 13:04:42"/>
<UML:TaggedValue tag="date_modified" value="2011-06-18 08:11:22"/>
<UML:TaggedValue tag="gentype" value="MySql"/>
<UML:TaggedValue tag="tagged" value="0"/>
<UML:TaggedValue tag="package_name" value="Schema1"/>
<UML:TaggedValue tag="phase" value="1.0"/>
<UML:TaggedValue tag="complexity" value="1"/>
<UML:TaggedValue tag="product_name" value="MySql"/>
<UML:TaggedValue tag="status" value="Proposed"/>
<UML:TaggedValue tag="stereotype" value="table"/>
<UML:TaggedValue tag="tpos" value="0"/>
<UML:TaggedValue tag="ea_localid" value="10"/>
<UML:TaggedValue tag="ea_eleType" value="element"/>
<UML:TaggedValue tag="eventflags" value="LNK=2819;"/>
<UML:TaggedValue tag="style" value="BackColor=-1;BorderColor=-1;BorderWidth=-1;FontColor=-1;VSwimLanes=0;HSwimLanes=0;BorderStyle=0;"/>
<UML:TaggedValue tag="$ea_xref_property" value="$XREFPROP=$XID={2CD9DF93-EA92-4350-82D7-D7163A0A8FCF}$XID;$NAM=CustomProperties$NAM;$TYP=element property$TYP;$VIS=Public$VIS;$DES=@PROP=@NAME=isActive@ENDNAME;@TYPE=Boolean@ENDTYPE;@VALU=@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;$DES;$CLT={1A60F71D-CEAD-4693-9164-FF166C034D12}$CLT;$ENDXREF;$XREFPROP=$XID={4FEAAA9E-16FE-4ee0-BB15-B279DD8E7851}$XID;$NAM=Stereotypes$NAM;$TYP=element property$TYP;$VIS=Public$VIS;$DES=@STEREO;Name=table;GUID={4CED7E32-AF63-4172-ADE3-7FA7ADC7E308};@ENDSTEREO;$DES;$CLT={1A60F71D-CEAD-4693-9164-FF166C034D12}$CLT;$SUP=<none>$SUP;$ENDXREF;"/>
</UML:ModelElement.taggedValue>
<UML:Classifier.feature>
<UML:Attribute name="id" changeable="none" visibility="public" ownerScope="instance" targetScope="instance">
<UML:Attribute.initialValue>
<UML:Expression/>
</UML:Attribute.initialValue>
<UML:StructuralFeature.type>
<UML:Classifier xmi.idref="eaxmiid0"/>
</UML:StructuralFeature.type>
<UML:ModelElement.stereotype>
<UML:Stereotype name="column"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="type" value="INTEGER"/>
<UML:TaggedValue tag="ordered" value="1"/>
<UML:TaggedValue tag="static" value="1"/>
<UML:TaggedValue tag="stereotype" value="column"/>
<UML:TaggedValue tag="collection" value="false"/>
<UML:TaggedValue tag="position" value="0"/>
<UML:TaggedValue tag="lowerBound" value="1"/>
<UML:TaggedValue tag="upperBound" value="1"/>
<UML:TaggedValue tag="duplicates" value="1"/>
<UML:TaggedValue tag="ea_guid" value="{11129FF9-B568-4bd2-AC44-2273B4FC80AE}"/>
<UML:TaggedValue tag="ea_localid" value="1"/>
</UML:ModelElement.taggedValue>
</UML:Attribute>
<UML:Attribute name="username" changeable="none" visibility="public" ownerScope="instance" targetScope="instance">
<UML:Attribute.initialValue>
<UML:Expression/>
</UML:Attribute.initialValue>
<UML:StructuralFeature.type>
<UML:Classifier xmi.idref="eaxmiid1"/>
</UML:StructuralFeature.type>
<UML:ModelElement.stereotype>
<UML:Stereotype name="column"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="type" value="VARCHAR"/>
<UML:TaggedValue tag="length" value="20"/>
<UML:TaggedValue tag="ordered" value="0"/>
<UML:TaggedValue tag="static" value="1"/>
<UML:TaggedValue tag="stereotype" value="column"/>
<UML:TaggedValue tag="collection" value="false"/>
<UML:TaggedValue tag="position" value="1"/>
<UML:TaggedValue tag="lowerBound" value="1"/>
<UML:TaggedValue tag="upperBound" value="1"/>
<UML:TaggedValue tag="duplicates" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{CBB9D803-BB11-477f-8F66-9BFDC2D03DCD}"/>
<UML:TaggedValue tag="ea_localid" value="2"/>
</UML:ModelElement.taggedValue>
</UML:Attribute>
<UML:Attribute name="password" changeable="none" visibility="public" ownerScope="instance" targetScope="instance">
<UML:Attribute.initialValue>
<UML:Expression/>
</UML:Attribute.initialValue>
<UML:StructuralFeature.type>
<UML:Classifier xmi.idref="eaxmiid2"/>
</UML:StructuralFeature.type>
<UML:ModelElement.stereotype>
<UML:Stereotype name="column"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="type" value="CHAR"/>
<UML:TaggedValue tag="length" value="32"/>
<UML:TaggedValue tag="ordered" value="0"/>
<UML:TaggedValue tag="stereotype" value="column"/>
<UML:TaggedValue tag="collection" value="false"/>
<UML:TaggedValue tag="position" value="2"/>
<UML:TaggedValue tag="lowerBound" value="1"/>
<UML:TaggedValue tag="upperBound" value="1"/>
<UML:TaggedValue tag="duplicates" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{C0C59B16-7E2C-490c-B5E3-72CA72E9443D}"/>
<UML:TaggedValue tag="ea_localid" value="3"/>
</UML:ModelElement.taggedValue>
</UML:Attribute>
<UML:Operation name="PK_users" visibility="public" ownerScope="instance" isQuery="false" concurrency="sequential">
<UML:ModelElement.stereotype>
<UML:Stereotype name="PK"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="const" value="false"/>
<UML:TaggedValue tag="stereotype" value="PK"/>
<UML:TaggedValue tag="synchronised" value="0"/>
<UML:TaggedValue tag="position" value="0"/>
<UML:TaggedValue tag="returnarray" value="0"/>
<UML:TaggedValue tag="pure" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{CD1F23D3-E5DB-41d8-8ECC-7E36CE2ED6F5}"/>
<UML:TaggedValue tag="ea_localid" value="1"/>
</UML:ModelElement.taggedValue>
<UML:BehavioralFeature.parameter>
<UML:Parameter kind="return" visibility="public">
<UML:Parameter.type>
<UML:Classifier xmi.idref="eaxmiid3"/>
</UML:Parameter.type>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="pos" value="0"/>
<UML:TaggedValue tag="const" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{RETURNID-E5DB-41d8-8ECC-7E36CE2ED6F5}"/>
</UML:ModelElement.taggedValue>
<UML:Parameter.defaultValue>
<UML:Expression/>
</UML:Parameter.defaultValue>
</UML:Parameter>
<UML:Parameter name="id" kind="in" visibility="public">
<UML:Parameter.type>
<UML:Classifier xmi.idref="eaxmiid0"/>
</UML:Parameter.type>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="pos" value="0"/>
<UML:TaggedValue tag="type" value="INTEGER"/>
<UML:TaggedValue tag="const" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{D3C322B8-4B6D-441a-9D3E-720F00D07DEF}"/>
</UML:ModelElement.taggedValue>
<UML:Parameter.defaultValue>
<UML:Expression/>
</UML:Parameter.defaultValue>
</UML:Parameter>
</UML:BehavioralFeature.parameter>
</UML:Operation>
<UML:Operation name="UQ_users_username" visibility="public" ownerScope="instance" isQuery="false" concurrency="sequential">
<UML:ModelElement.stereotype>
<UML:Stereotype name="unique"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="const" value="false"/>
<UML:TaggedValue tag="stereotype" value="unique"/>
<UML:TaggedValue tag="synchronised" value="0"/>
<UML:TaggedValue tag="position" value="0"/>
<UML:TaggedValue tag="returnarray" value="0"/>
<UML:TaggedValue tag="pure" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{1C8DE4FF-2A5C-42e6-B92C-53E4AEB52C4A}"/>
<UML:TaggedValue tag="ea_localid" value="2"/>
</UML:ModelElement.taggedValue>
<UML:BehavioralFeature.parameter>
<UML:Parameter kind="return" visibility="public">
<UML:Parameter.type>
<UML:Classifier xmi.idref="eaxmiid3"/>
</UML:Parameter.type>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="pos" value="0"/>
<UML:TaggedValue tag="const" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{RETURNID-2A5C-42e6-B92C-53E4AEB52C4A}"/>
</UML:ModelElement.taggedValue>
<UML:Parameter.defaultValue>
<UML:Expression/>
</UML:Parameter.defaultValue>
</UML:Parameter>
<UML:Parameter name="username" kind="in" visibility="public">
<UML:Parameter.type>
<UML:Classifier xmi.idref="eaxmiid1"/>
</UML:Parameter.type>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="pos" value="0"/>
<UML:TaggedValue tag="type" value="VARCHAR"/>
<UML:TaggedValue tag="const" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{2FAB07E3-E227-4fcf-AB36-946ECBBA4403}"/>
</UML:ModelElement.taggedValue>
<UML:Parameter.defaultValue>
<UML:Expression/>
</UML:Parameter.defaultValue>
</UML:Parameter>
</UML:BehavioralFeature.parameter>
</UML:Operation>
</UML:Classifier.feature>
</UML:Class>
<UML:Association name="(user_id = id)" xmi.id="EAID_AAB7A59C_4B86_40f2_A77F_B2D5C6685946" visibility="public" isRoot="false" isLeaf="false" isAbstract="false">
<UML:ModelElement.stereotype>
<UML:Stereotype name="FK"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="style" value="3"/>
<UML:TaggedValue tag="ea_type" value="Association"/>
<UML:TaggedValue tag="direction" value="Unspecified"/>
<UML:TaggedValue tag="linemode" value="3"/>
<UML:TaggedValue tag="linecolor" value="-1"/>
<UML:TaggedValue tag="linewidth" value="1"/>
<UML:TaggedValue tag="seqno" value="0"/>
<UML:TaggedValue tag="stereotype" value="FK"/>
<UML:TaggedValue tag="styleex" value="FKINFO=SRC=FK_posts_users:DST=PK_users:;"/>
<UML:TaggedValue tag="headStyle" value="0"/>
<UML:TaggedValue tag="lineStyle" value="0"/>
<UML:TaggedValue tag="ea_localid" value="4"/>
<UML:TaggedValue tag="ea_sourceName" value="posts"/>
<UML:TaggedValue tag="ea_targetName" value="users"/>
<UML:TaggedValue tag="ea_sourceType" value="Class"/>
<UML:TaggedValue tag="ea_targetType" value="Class"/>
<UML:TaggedValue tag="ea_sourceID" value="9"/>
<UML:TaggedValue tag="ea_targetID" value="10"/>
<UML:TaggedValue tag="$ea_xref_property" value="$XREFPROP=$XID={121CE190-0807-4e68-8E52-B69AEA4345D5}$XID;$NAM=CustomProperties$NAM;$TYP=connector property$TYP;$VIS=Public$VIS;$DES=@PROP=@NAME=isDerived@ENDNAME;@TYPE=Boolean@ENDTYPE;@VALU=false@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;$DES;$CLT={AAB7A59C-4B86-40f2-A77F-B2D5C6685946}$CLT;$SUP=<none>$SUP;$ENDXREF;$XREFPROP=$XID={2F5E65BF-0AFD-4dae-9A8E-15B76A58B0CE}$XID;$NAM=Stereotypes$NAM;$TYP=connector property$TYP;$VIS=Public$VIS;$DES=@STEREO;Name=FK;GUID={7E0A7043-9D17-4d52-9ED5-A6DB649BCBC3};@ENDSTEREO;$DES;$CLT={AAB7A59C-4B86-40f2-A77F-B2D5C6685946}$CLT;$SUP=<none>$SUP;$ENDXREF;"/>
<UML:TaggedValue tag="$ea_src_xref_property" value="$XREFPROP=$XID={7D4094BB-FFB5-488d-B59A-B41373DEC681}$XID;$NAM=CustomProperties$NAM;$TYP=connectorSrcEnd property$TYP;$VIS=Public$VIS;$DES=@PROP=@NAME=isDerivedUnion@ENDNAME;@TYPE=Boolean@ENDTYPE;@VALU=false@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;@PROP=@NAME=isDerived@ENDNAME;@TYPE=Boolean@ENDTYPE;@VALU=false@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;@PROP=@NAME=default@ENDNAME;@TYPE=String@ENDTYPE;@VALU=@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;@PROP=@NAME=isReadOnly@ENDNAME;@TYPE=Boolean@ENDTYPE;@VALU=false@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;@PROP=@NAME=isComposite@ENDNAME;@TYPE=Boolean@ENDTYPE;@VALU=@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;@PROP=@NAME=aggregation@ENDNAME;@TYPE=AggregationKind@ENDTYPE;@VALU=none@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;$DES;$CLT={AAB7A59C-4B86-40f2-A77F-B2D5C6685946}$CLT;$SUP=<none>$SUP;$ENDXREF;"/>
<UML:TaggedValue tag="$ea_dst_xref_property" value="$XREFPROP=$XID={0B8A8184-CE88-40cd-8456-6614219E7F9F}$XID;$NAM=CustomProperties$NAM;$TYP=connectorDestEnd property$TYP;$VIS=Public$VIS;$DES=@PROP=@NAME=isDerivedUnion@ENDNAME;@TYPE=Boolean@ENDTYPE;@VALU=false@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;@PROP=@NAME=isDerived@ENDNAME;@TYPE=Boolean@ENDTYPE;@VALU=false@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;@PROP=@NAME=default@ENDNAME;@TYPE=String@ENDTYPE;@VALU=@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;@PROP=@NAME=isReadOnly@ENDNAME;@TYPE=Boolean@ENDTYPE;@VALU=false@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;@PROP=@NAME=isComposite@ENDNAME;@TYPE=Boolean@ENDTYPE;@VALU=@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;@PROP=@NAME=aggregation@ENDNAME;@TYPE=AggregationKind@ENDTYPE;@VALU=none@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;$DES;$CLT={AAB7A59C-4B86-40f2-A77F-B2D5C6685946}$CLT;$SUP=<none>$SUP;$ENDXREF;"/>
<UML:TaggedValue tag="privatedata5" value="SX=0;SY=0;EX=0;EY=0;"/>
<UML:TaggedValue tag="virtualInheritance" value="0"/>
<UML:TaggedValue tag="lb" value="0..*"/>
<UML:TaggedValue tag="lt" value="+FK_posts_users"/>
<UML:TaggedValue tag="mb" value=" 
«FK»"/>
<UML:TaggedValue tag="mt" value="(user_id = id)"/>
<UML:TaggedValue tag="rb" value="1"/>
<UML:TaggedValue tag="rt" value="+PK_users"/>
</UML:ModelElement.taggedValue>
<UML:Association.connection>
<UML:AssociationEnd visibility="public" multiplicity="0..*" name="FK_posts_users" aggregation="none" isOrdered="false" targetScope="instance" changeable="none" isNavigable="true" type="EAID_40A8EAC6_D408_4079_BC6C_8029CD4CBB1B">
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="containment" value="Unspecified"/>
<UML:TaggedValue tag="sourcestyle" value="Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Non-Navigable;"/>
<UML:TaggedValue tag="ea_end" value="source"/>
</UML:ModelElement.taggedValue>
</UML:AssociationEnd>
<UML:AssociationEnd visibility="public" multiplicity="1" name="PK_users" aggregation="none" isOrdered="false" targetScope="instance" changeable="none" isNavigable="true" type="EAID_1A60F71D_CEAD_4693_9164_FF166C034D12">
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="containment" value="Unspecified"/>
<UML:TaggedValue tag="deststyle" value="Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Unspecified;"/>
<UML:TaggedValue tag="ea_end" value="target"/>
</UML:ModelElement.taggedValue>
</UML:AssociationEnd>
</UML:Association.connection>
</UML:Association>
<UML:Class name="posts" xmi.id="EAID_40A8EAC6_D408_4079_BC6C_8029CD4CBB1B" visibility="public" namespace="EAPK_7684FDB7_8D96_4a8c_91FD_137381277669" isRoot="false" isLeaf="false" isAbstract="false" isActive="false">
<UML:ModelElement.stereotype>
<UML:Stereotype name="table"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="isSpecification" value="false"/>
<UML:TaggedValue tag="ea_stype" value="Class"/>
<UML:TaggedValue tag="ea_ntype" value="0"/>
<UML:TaggedValue tag="version" value="1.0"/>
<UML:TaggedValue tag="package" value="EAPK_7684FDB7_8D96_4a8c_91FD_137381277669"/>
<UML:TaggedValue tag="date_created" value="2005-11-22 13:04:46"/>
<UML:TaggedValue tag="date_modified" value="2011-06-18 08:32:08"/>
<UML:TaggedValue tag="gentype" value="MySql"/>
<UML:TaggedValue tag="tagged" value="0"/>
<UML:TaggedValue tag="package_name" value="Schema1"/>
<UML:TaggedValue tag="phase" value="1.0"/>
<UML:TaggedValue tag="complexity" value="1"/>
<UML:TaggedValue tag="product_name" value="MySql"/>
<UML:TaggedValue tag="status" value="Proposed"/>
<UML:TaggedValue tag="stereotype" value="table"/>
<UML:TaggedValue tag="tpos" value="0"/>
<UML:TaggedValue tag="ea_localid" value="9"/>
<UML:TaggedValue tag="ea_eleType" value="element"/>
<UML:TaggedValue tag="eventflags" value="LNK=282d;"/>
<UML:TaggedValue tag="style" value="BackColor=-1;BorderColor=-1;BorderWidth=-1;FontColor=-1;VSwimLanes=0;HSwimLanes=0;BorderStyle=0;"/>
<UML:TaggedValue tag="$ea_xref_property" value="$XREFPROP=$XID={EAB46348-F9F1-42ff-91C4-2EAD02C50811}$XID;$NAM=CustomProperties$NAM;$TYP=element property$TYP;$VIS=Public$VIS;$DES=@PROP=@NAME=isActive@ENDNAME;@TYPE=Boolean@ENDTYPE;@VALU=@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;$DES;$CLT={40A8EAC6-D408-4079-BC6C-8029CD4CBB1B}$CLT;$ENDXREF;$XREFPROP=$XID={C4102FF8-4FCF-4524-8ED0-433EBAB3AC7F}$XID;$NAM=Stereotypes$NAM;$TYP=element property$TYP;$VIS=Public$VIS;$DES=@STEREO;Name=table;GUID={4CED7E32-AF63-4172-ADE3-7FA7ADC7E308};@ENDSTEREO;$DES;$CLT={40A8EAC6-D408-4079-BC6C-8029CD4CBB1B}$CLT;$SUP=<none>$SUP;$ENDXREF;"/>
</UML:ModelElement.taggedValue>
<UML:Classifier.feature>
<UML:Attribute name="id" changeable="none" visibility="public" ownerScope="instance" targetScope="instance">
<UML:Attribute.initialValue>
<UML:Expression/>
</UML:Attribute.initialValue>
<UML:StructuralFeature.type>
<UML:Classifier xmi.idref="eaxmiid0"/>
</UML:StructuralFeature.type>
<UML:ModelElement.stereotype>
<UML:Stereotype name="column"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="type" value="INTEGER"/>
<UML:TaggedValue tag="ordered" value="1"/>
<UML:TaggedValue tag="static" value="1"/>
<UML:TaggedValue tag="stereotype" value="column"/>
<UML:TaggedValue tag="collection" value="false"/>
<UML:TaggedValue tag="position" value="0"/>
<UML:TaggedValue tag="lowerBound" value="1"/>
<UML:TaggedValue tag="upperBound" value="1"/>
<UML:TaggedValue tag="duplicates" value="1"/>
<UML:TaggedValue tag="ea_guid" value="{CE797B70-E448-473c-8559-2BA168639294}"/>
<UML:TaggedValue tag="ea_localid" value="5"/>
</UML:ModelElement.taggedValue>
</UML:Attribute>
<UML:Attribute name="user_id" changeable="none" visibility="public" ownerScope="instance" targetScope="instance">
<UML:Attribute.initialValue>
<UML:Expression/>
</UML:Attribute.initialValue>
<UML:StructuralFeature.type>
<UML:Classifier xmi.idref="eaxmiid0"/>
</UML:StructuralFeature.type>
<UML:ModelElement.stereotype>
<UML:Stereotype name="column"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="type" value="INTEGER"/>
<UML:TaggedValue tag="ordered" value="0"/>
<UML:TaggedValue tag="stereotype" value="column"/>
<UML:TaggedValue tag="collection" value="true"/>
<UML:TaggedValue tag="position" value="1"/>
<UML:TaggedValue tag="lowerBound" value="1"/>
<UML:TaggedValue tag="upperBound" value="1"/>
<UML:TaggedValue tag="duplicates" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{ABF6B741-2DE3-41a2-81FC-901B818471ED}"/>
<UML:TaggedValue tag="ea_localid" value="8"/>
</UML:ModelElement.taggedValue>
</UML:Attribute>
<UML:Attribute name="title" changeable="none" visibility="public" ownerScope="instance" targetScope="instance">
<UML:Attribute.initialValue>
<UML:Expression/>
</UML:Attribute.initialValue>
<UML:StructuralFeature.type>
<UML:Classifier xmi.idref="eaxmiid1"/>
</UML:StructuralFeature.type>
<UML:ModelElement.stereotype>
<UML:Stereotype name="column"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="type" value="VARCHAR"/>
<UML:TaggedValue tag="length" value="90"/>
<UML:TaggedValue tag="ordered" value="0"/>
<UML:TaggedValue tag="stereotype" value="column"/>
<UML:TaggedValue tag="collection" value="false"/>
<UML:TaggedValue tag="position" value="2"/>
<UML:TaggedValue tag="lowerBound" value="1"/>
<UML:TaggedValue tag="upperBound" value="1"/>
<UML:TaggedValue tag="duplicates" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{BA2EBB68-DFE8-4cee-BC00-A3714EB8E4DC}"/>
<UML:TaggedValue tag="ea_localid" value="6"/>
</UML:ModelElement.taggedValue>
</UML:Attribute>
<UML:Attribute name="body" changeable="none" visibility="public" ownerScope="instance" targetScope="instance">
<UML:Attribute.initialValue>
<UML:Expression/>
</UML:Attribute.initialValue>
<UML:StructuralFeature.type>
<UML:Classifier xmi.idref="eaxmiid4"/>
</UML:StructuralFeature.type>
<UML:ModelElement.stereotype>
<UML:Stereotype name="column"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="type" value="TEXT"/>
<UML:TaggedValue tag="ordered" value="0"/>
<UML:TaggedValue tag="stereotype" value="column"/>
<UML:TaggedValue tag="collection" value="false"/>
<UML:TaggedValue tag="position" value="3"/>
<UML:TaggedValue tag="lowerBound" value="1"/>
<UML:TaggedValue tag="upperBound" value="1"/>
<UML:TaggedValue tag="duplicates" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{68B01F09-8C60-4ab1-8FF6-8F93CCCBFA73}"/>
<UML:TaggedValue tag="ea_localid" value="7"/>
</UML:ModelElement.taggedValue>
</UML:Attribute>
<UML:Operation name="FK_posts_users" visibility="public" ownerScope="instance" isQuery="false" concurrency="sequential">
<UML:ModelElement.stereotype>
<UML:Stereotype name="FK"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="const" value="false"/>
<UML:TaggedValue tag="stereotype" value="FK"/>
<UML:TaggedValue tag="synchronised" value="0"/>
<UML:TaggedValue tag="position" value="0"/>
<UML:TaggedValue tag="pure" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{CE88CEDD-38F6-43c1-BC0C-ADA1A55976D8}"/>
<UML:TaggedValue tag="ea_localid" value="5"/>
<UML:TaggedValue tag="property" value="Delete Cascade=1;Update Cascade=1;" xmi.id="EAID_FC30FBAD_0F96_49db_A549_043CB2888B41"/>
</UML:ModelElement.taggedValue>
<UML:BehavioralFeature.parameter>
<UML:Parameter kind="return" visibility="public">
<UML:Parameter.type>
<UML:Classifier xmi.idref="eaxmiid3"/>
</UML:Parameter.type>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="pos" value="0"/>
<UML:TaggedValue tag="const" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{RETURNID-38F6-43c1-BC0C-ADA1A55976D8}"/>
</UML:ModelElement.taggedValue>
<UML:Parameter.defaultValue>
<UML:Expression/>
</UML:Parameter.defaultValue>
</UML:Parameter>
<UML:Parameter name="user_id" kind="in" visibility="public">
<UML:Parameter.type>
<UML:Classifier xmi.idref="eaxmiid0"/>
</UML:Parameter.type>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="pos" value="0"/>
<UML:TaggedValue tag="type" value="INTEGER"/>
<UML:TaggedValue tag="const" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{6E3EECD6-5643-42ed-98B4-5E5F8CAE71F9}"/>
</UML:ModelElement.taggedValue>
<UML:Parameter.defaultValue>
<UML:Expression/>
</UML:Parameter.defaultValue>
</UML:Parameter>
</UML:BehavioralFeature.parameter>
</UML:Operation>
<UML:Operation name="PK_posts" visibility="public" ownerScope="instance" isQuery="false" concurrency="sequential">
<UML:ModelElement.stereotype>
<UML:Stereotype name="PK"/>
</UML:ModelElement.stereotype>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="const" value="false"/>
<UML:TaggedValue tag="stereotype" value="PK"/>
<UML:TaggedValue tag="synchronised" value="0"/>
<UML:TaggedValue tag="position" value="0"/>
<UML:TaggedValue tag="returnarray" value="0"/>
<UML:TaggedValue tag="pure" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{87300E1C-04E3-4fb2-8427-90CABA557D96}"/>
<UML:TaggedValue tag="ea_localid" value="4"/>
</UML:ModelElement.taggedValue>
<UML:BehavioralFeature.parameter>
<UML:Parameter kind="return" visibility="public">
<UML:Parameter.type>
<UML:Classifier xmi.idref="eaxmiid3"/>
</UML:Parameter.type>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="pos" value="0"/>
<UML:TaggedValue tag="const" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{RETURNID-04E3-4fb2-8427-90CABA557D96}"/>
</UML:ModelElement.taggedValue>
<UML:Parameter.defaultValue>
<UML:Expression/>
</UML:Parameter.defaultValue>
</UML:Parameter>
<UML:Parameter name="id" kind="in" visibility="public">
<UML:Parameter.type>
<UML:Classifier xmi.idref="eaxmiid0"/>
</UML:Parameter.type>
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="pos" value="0"/>
<UML:TaggedValue tag="type" value="INTEGER"/>
<UML:TaggedValue tag="const" value="0"/>
<UML:TaggedValue tag="ea_guid" value="{4E965791-46A7-41e3-A06F-9CAC709C3DD2}"/>
</UML:ModelElement.taggedValue>
<UML:Parameter.defaultValue>
<UML:Expression/>
</UML:Parameter.defaultValue>
</UML:Parameter>
</UML:BehavioralFeature.parameter>
</UML:Operation>
</UML:Classifier.feature>
</UML:Class>
</UML:Namespace.ownedElement>
</UML:Package>
<UML:DataType xmi.id="eaxmiid3" visibility="private" isRoot="false" isLeaf="false" isAbstract="false"/>
<UML:DataType xmi.id="eaxmiid0" name="INTEGER" visibility="private" isRoot="false" isLeaf="false" isAbstract="false"/>
<UML:DataType xmi.id="eaxmiid2" name="CHAR" visibility="private" isRoot="false" isLeaf="false" isAbstract="false"/>
<UML:DataType xmi.id="eaxmiid1" name="VARCHAR" visibility="private" isRoot="false" isLeaf="false" isAbstract="false"/>
<UML:DataType xmi.id="eaxmiid4" name="TEXT" visibility="private" isRoot="false" isLeaf="false" isAbstract="false"/>
</UML:Namespace.ownedElement>
</UML:Model>
<UML:Diagram name="Schema1" xmi.id="EAID_59456792_5B7E_4fd2_817A_26AC36AF331A" diagramType="ClassDiagram" owner="EAPK_7684FDB7_8D96_4a8c_91FD_137381277669" toolName="Enterprise Architect 2.5">
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="version" value="1.0"/>
<UML:TaggedValue tag="author" value="tudor"/>
<UML:TaggedValue tag="created_date" value="2006-01-11 00:00:00"/>
<UML:TaggedValue tag="modified_date" value="2011-06-18 08:38:57"/>
<UML:TaggedValue tag="package" value="EAPK_7684FDB7_8D96_4a8c_91FD_137381277669"/>
<UML:TaggedValue tag="type" value="Logical"/>
<UML:TaggedValue tag="swimlanes" value="locked=false;orientation=0;width=0;inbar=false;names=false;color=0;bold=false;fcol=0;;cls=0;"/>
<UML:TaggedValue tag="matrixitems" value="locked=false;matrixactive=false;swimlanesactive=true;width=1;"/>
<UML:TaggedValue tag="ea_localid" value="2"/>
<UML:TaggedValue tag="EAStyle" value="ShowPrivate=1;ShowProtected=1;ShowPublic=1;HideRelationships=0;Locked=0;Border=0;HighlightForeign=0;PackageContents=0;SequenceNotes=0;ScalePrintImage=0;PPgs.cx=0;PPgs.cy=0;DocSize.cx=827;DocSize.cy=1169;ShowDetails=0;Orientation=P;Zoom=100;ShowTags=0;OpParams=1;VisibleAttributeDetail=0;ShowOpRetType=1;ShowIcons=1;CollabNums=0;HideProps=0;ShowReqs=0;ShowCons=0;PaperSize=9;HideParents=0;UseAlias=0;HideAtts=0;HideOps=0;HideStereo=0;HideElemStereo=0;ShowTests=0;ShowMaint=0;ConnectorNotation=;ExplicitNavigability=0;AdvancedElementProps=1;AdvancedFeatureProps=1;AdvancedConnectorProps=1;ShowNotes=0;SuppressBrackets=0;SuppConnectorLabels=0;PrintPageHeadFoot=0;"/>
<UML:TaggedValue tag="styleex" value="ExcludeRTF=0;DocAll=0;HideQuals=0;AttPkg=1;ShowTests=0;ShowMaint=0;SuppressFOC=1;MatrixActive=0;SwimlanesActive=1;MatrixLineWidth=1;MatrixLocked=0;TConnectorNotation=;TExplicitNavigability=0;AdvancedElementProps=1;AdvancedFeatureProps=1;AdvancedConnectorProps=1;ProfileData=;MDGDgm=;STBLDgm=;ShowNotes=0;VisibleAttributeDetail=0;ShowOpRetType=1;SuppressBrackets=0;SuppConnectorLabels=0;PrintPageHeadFoot=0;"/>
</UML:ModelElement.taggedValue>
<UML:Diagram.element>
<UML:DiagramElement geometry="Left=564;Top=109;Right=720;Bottom=284;imgL=480;imgT=35;imgR=636;imgB=210;" subject="EAID_40A8EAC6_D408_4079_BC6C_8029CD4CBB1B" seqno="1" style="DUID=ED15F429;"/>
<UML:DiagramElement geometry="Left=109;Top=114;Right=293;Bottom=276;imgL=25;imgT=40;imgR=209;imgB=202;" subject="EAID_1A60F71D_CEAD_4693_9164_FF166C034D12" seqno="2" style="DUID=4B87CF33;"/>
<UML:DiagramElement geometry="SX=0;SY=0;EX=0;EY=0;EDGE=4;$LLB=CX=17:CY=14:OX=0:OY=0:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;LLT=CX=78:CY=14:OX=0:OY=0:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;LMT=CX=62:CY=14:OX=0:OY=0:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;LMB=CX=26:CY=14:OX=0:OY=0:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;LRT=CX=50:CY=14:OX=0:OY=0:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;LRB=CX=7:CY=14:OX=0:OY=0:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;IRHS=;ILHS=;Path=;" subject="EAID_AAB7A59C_4B86_40f2_A77F_B2D5C6685946" style="Mode=3;EOID=4B87CF33;SOID=ED15F429;Color=-1;LWidth=1;Hidden=0;"/>
</UML:Diagram.element>
</UML:Diagram>
<UML:DiagramElement geometry="EDGE=2;$LLB=;LLT=;LMT=;LMB=;LRT=;LRB=;IRHS=;ILHS=;" subject="EAID_B175A04B_D678_4ad3_9877_E4BA571F14B9" style="Mode=3;EOID=A314D1DD;SOID=98EFF03E;Color=-1;LWidth=0;">
<UML:ModelElement.taggedValue>
<UML:TaggedValue tag="diagram_guid" value="EAID_BD837B7A_176D_4af9_A82E_49F6AB5D04F5"/>
<UML:TaggedValue tag="hidden" value="0"/>
</UML:ModelElement.taggedValue>
</UML:DiagramElement>
</XMI.content>
<XMI.difference/>
<XMI.extensions xmi.extender="Enterprise Architect 2.5">
<EAStub xmi.id="EAID_7684FDB7_8D96_4a8c_91FD_137381277669" name="Schema1" UMLType="Package"/>
<EAStub xmi.id="EAID_2909FDB0_0A57_48dd_9395_CFDDFE432423" UMLType="Note"/>
<EANoteLink xmi.id="EAID_B175A04B_D678_4ad3_9877_E4BA571F14B9" source="EAID_7684FDB7_8D96_4a8c_91FD_137381277669" target="EAID_2909FDB0_0A57_48dd_9395_CFDDFE432423"/>
</XMI.extensions>
</XMI>