text:
Using POSper/Developer guide/Database Diagram XML Source

To edit the Database Diagram, open the following xml with DBDesigner. http://fabforce.net/dbdesigner4/ this is the xml describing the model for revision 423

   <GLOBALSETTINGS ModelName="posperDbdRev423" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="91.00" XPos="566" YPos="922" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="" HPageCount="4.0" PageAspectRatio="1.440892512336408" PageOrientation="1" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="1" DefaultTableType="0" ActivateRefDefForNewRelations="1" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="1" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="nimbus sans l" CanvasWidth="4096" CanvasHeight="2842" />

<COLUMN ID="1032" ColName="visibleId" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\Ahuman-friendly\A id visible to the user and editable by the user">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1033" ColName="address" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="address of the location">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1034" ColName="name" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="user assigned location name">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1310" />

<RELATION_START ID="1327" />

</RELATIONS_START>

<INDICES>

<INDEX ID="1027" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1026" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1043" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="UUID instead of int">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1440" ColName="posper_floor_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1045" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="this is used by hibernate to track table version">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1046" ColName="name" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="user-assigned name">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1047" ColName="x" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="x coordinate">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1048" ColName="y" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="y coordinate">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1277" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1439" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1044" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1043" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1441" IndexName="Place_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1439">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1440" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1066" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1068" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1069" ColName="customer" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1070" ColName="chairs" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1071" ColName="date" PrevColName="" Pos="4" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1072" ColName="done" PrevColName="" Pos="5" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1073" ColName="description" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1067" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1066" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1087" ColName="id" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1088" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1087" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1091" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1093" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1095" ColName="dateOpen" PrevColName="" Pos="3" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1096" ColName="dateClose" PrevColName="" Pos="4" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1097" ColName="host" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1358" />

</RELATIONS_START>

<INDICES>

<INDEX ID="1092" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1091" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1100" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1346" ColName="posper_category_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="this field doesn\at exist : the actual field name is parent_id">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1260" ColName="posper_image_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1102" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1103" ColName="visibleId" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1104" ColName="category_name" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1105" ColName="parent_id" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1270" />

<RELATION_START ID="1342" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1259" />

<RELATION_END ID="1342" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1101" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1100" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1261" IndexName="category_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1259">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1260" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1344" IndexName="category_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1342">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1346" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1109" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1111" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1112" ColName="posper_imageBlob" PrevColName="" Pos="2" idDatatype="25" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1113" ColName="description" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1256" />

<RELATION_START ID="1259" />

<RELATION_START ID="1262" />

<RELATION_START ID="1265" />

<RELATION_START ID="1465" />

</RELATIONS_START>

<INDICES>

<INDEX ID="1110" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1109" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1128" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1511" ColName="posper_ticket_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1130" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1132" ColName="amount" PrevColName="" Pos="3" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1133" ColName="method" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1510" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1129" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1128" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1512" IndexName="posper_payment_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1510">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1511" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1136" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1263" ColName="posper_image_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1138" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1139" ColName="reference" PrevColName="visibleId" Pos="2" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1140" ColName="inStock" PrevColName="" Pos="3" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1141" ColName="com" PrevColName="" Pos="4" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1142" ColName="scale" PrevColName="" Pos="5" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1143" ColName="priceBuy" PrevColName="" Pos="6" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1144" ColName="priceSell" PrevColName="" Pos="7" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1145" ColName="stockCost" PrevColName="" Pos="8" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1146" ColName="volume" PrevColName="" Pos="9" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1147" ColName="displayOrder" PrevColName="" Pos="10" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1148" ColName="description" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1149" ColName="code" PrevColName="" Pos="12" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1150" ColName="posper_tax_id" PrevColName="" Pos="13" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1152" ColName="posper_category_id" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1309" />

<RELATION_START ID="1323" />

<RELATION_START ID="1326" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1262" />

<RELATION_END ID="1268" />

<RELATION_END ID="1270" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1137" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1136" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1264" IndexName="product_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1262">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1263" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1269" IndexName="product_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1268">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1150" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1271" IndexName="product_FKIndex3" IndexKind="1" FKRefDef_Obj_id="1270">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1152" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1155" ColName="posper_property_key" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1157" ColName="value" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1156" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1155" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1160" ColName="posper_resource_key" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1162" ColName="text" PrevColName="resType" Pos="1" idDatatype="29" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1514" ColName="version" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1161" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1160" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1167" ColName="name" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1284" />

<RELATION_START ID="1295" />

</RELATIONS_START>

<INDICES>

<INDEX ID="1168" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1167" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1176" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1178" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1179" ColName="visibleId" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1180" ColName="rate" PrevColName="" Pos="3" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1181" ColName="posper_tax_name" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1268" />

<RELATION_START ID="1454" />

</RELATIONS_START>

<INDICES>

<INDEX ID="1177" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1176" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1184" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1492" ColName="posper_place_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1278" ColName="posper_user_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1186" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1187" ColName="visibleId" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1188" ColName="dateOpen" PrevColName="" Pos="3" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1189" ColName="dateClose" PrevColName="" Pos="4" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1447" ColName="synched" PrevColName="" Pos="10" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1190" ColName="number" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1191" ColName="host" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1194" ColName="parent_id" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1359" />

<RELATION_START ID="1505" />

<RELATION_START ID="1510" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1272" />

<RELATION_END ID="1277" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1185" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1184" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1274" IndexName="ticket_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1272">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1278" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1504" IndexName="posper_ticket_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1277">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1492" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1202" ColName="id" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1203" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1202" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1206" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1506" ColName="posper_ticket_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1490" ColName="posper_tax_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1208" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1516" ColName="description" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1451" ColName="visibleId" PrevColName="" Pos="10" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1209" ColName="amount" PrevColName="" Pos="2" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1210" ColName="priceSell" PrevColName="" Pos="3" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1457" ColName="posper_taxRate" PrevColName="" Pos="11" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1213" ColName="parentOrder_id" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1214" ColName="posper_product_id" PrevColName="" Pos="7" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1216" ColName="line_index" PrevColName="" Pos="9" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1323" />

<RELATION_END ID="1454" />

<RELATION_END ID="1505" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1207" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1206" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1324" IndexName="ticket_line_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1323">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1214" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1455" IndexName="ticket_line_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1454">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1490" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1507" IndexName="posper_ticketline_FKIndex3" IndexKind="1" FKRefDef_Obj_id="1505">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1506" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1224" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1266" ColName="posper_image_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1226" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1227" ColName="visible" PrevColName="" Pos="2" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1228" ColName="name" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1229" ColName="user_password" PrevColName="password_2" Pos="4" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1230" ColName="posper_role_name" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1272" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1265" />

<RELATION_END ID="1284" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1225" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1224" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1267" IndexName="user_2_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1265">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1266" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1285" IndexName="user_2_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1284">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1230" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1289" ColName="name" PrevColName="permission" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1476" ColName="posper_permission_name" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1294" />

<RELATION_START ID="1475" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1475" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1290" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1289" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1477" IndexName="Permission_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1475">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1476" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1298" ColName="posper_role_name" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1474" ColName="posper_permission_name" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1294" />

<RELATION_END ID="1295" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1300" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1298" LengthParam="0" />

<INDEXCOLUMN idColumn="1474" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1297" IndexName="permission_has_role_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1294">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1474" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1299" IndexName="permission_has_role_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1295">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1298" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1311" ColName="posper_product_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1313" ColName="posper_location_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1317" ColName="id" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1318" ColName="version" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1319" ColName="stockMaximum" PrevColName="" Pos="4" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1320" ColName="stockSecurity" PrevColName="" Pos="5" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1309" />

<RELATION_END ID="1310" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1315" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1311" LengthParam="0" />

<INDEXCOLUMN idColumn="1313" LengthParam="0" />

<INDEXCOLUMN idColumn="1317" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1312" IndexName="product_has_Location_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1309">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1311" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1314" IndexName="product_has_Location_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1310">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1313" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1339" ColName="id" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1328" ColName="posper_product_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1330" ColName="posper_location_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1334" ColName="version" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1335" ColName="price" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1336" ColName="reason" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1337" ColName="units" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1338" ColName="date" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1326" />

<RELATION_END ID="1327" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1332" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1339" LengthParam="0" />

<INDEXCOLUMN idColumn="1328" LengthParam="0" />

<INDEXCOLUMN idColumn="1330" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1329" IndexName="product_has_Location_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1326">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1328" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1331" IndexName="product_has_Location_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1327">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1330" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1360" ColName="posper_cashregister_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1362" ColName="posper_ticket_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1358" />

<RELATION_END ID="1359" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1364" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1360" LengthParam="0" />

<INDEXCOLUMN idColumn="1362" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1361" IndexName="cash_register_has_ticket_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1358">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1360" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1363" IndexName="cash_register_has_ticket_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1359">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1362" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1461" ColName="id" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1462" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1461" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

<COLUMNS>

<COLUMN ID="1469" ColName="posper_resource_key" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1466" ColName="posper_image_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1465" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1470" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1469" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1467" IndexName="image_resource_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1465">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1466" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLES> <RELATIONS> <RELATION ID="1256" RelationName="I\k-\gF" Kind="2" SrcTable="1107" DestTable="1014" FKFields="id=posper_image_id\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1258" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="28" />

<RELATION ID="1259" RelationName="C\k-\gI" Kind="2" SrcTable="1107" DestTable="1098" FKFields="id=posper_image_id\n" FKFieldsComments="\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1261" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="29" />

<RELATION ID="1262" RelationName="P\k-\gI" Kind="2" SrcTable="1107" DestTable="1134" FKFields="id=posper_image_id\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1264" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="30" />

<RELATION ID="1265" RelationName="I\k-\gU" Kind="2" SrcTable="1107" DestTable="1222" FKFields="id=posper_image_id\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1267" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="31" />

<RELATION ID="1268" RelationName="TX\k-\gP" Kind="2" SrcTable="1174" DestTable="1134" FKFields="id=posper_tax_id\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1269" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />

<RELATION ID="1270" RelationName="P\k-\gC" Kind="2" SrcTable="1098" DestTable="1134" FKFields="id=posper_category_id\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1271" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="33" />

<RELATION ID="1272" RelationName="T\k-\gU" Kind="2" SrcTable="1222" DestTable="1182" FKFields="id=posper_user_id\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1274" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="34" />

<RELATION ID="1277" RelationName="T\k-\gP" Kind="2" SrcTable="1041" DestTable="1182" FKFields="id=posper_place_id\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1504" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="35" />

<RELATION ID="1284" RelationName="U\k-\gR" Kind="2" SrcTable="1165" DestTable="1222" FKFields="name=posper_role_name\n" FKFieldsComments="\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1285" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="36" />

<RELATION ID="1294" RelationName="P\k-\gRP" Kind="1" SrcTable="1287" DestTable="1293" FKFields="name=posper_permission_name\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1297" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="39" />

<RELATION ID="1295" RelationName="RP\k-\gR" Kind="1" SrcTable="1165" DestTable="1293" FKFields="name=posper_role_name\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1299" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="40" />

<RELATION ID="1309" RelationName="PL\k-\gP" Kind="1" SrcTable="1134" DestTable="1308" FKFields="id=posper_product_id\n" FKFieldsComments="\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1312" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="41" />

<RELATION ID="1310" RelationName="PL\k-\gL" Kind="1" SrcTable="1024" DestTable="1308" FKFields="id=posper_location_id\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1314" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="42" />

<RELATION ID="1323" RelationName="TL\k-\gP" Kind="2" SrcTable="1134" DestTable="1204" FKFields="id=posper_product_id\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1324" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="42" />

<RELATION ID="1326" RelationName="P\k-\gSD" Kind="1" SrcTable="1134" DestTable="1325" FKFields="id=posper_product_id\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1329" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="44" />

<RELATION ID="1327" RelationName="L\k-\gSD" Kind="1" SrcTable="1024" DestTable="1325" FKFields="id=posper_location_id\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1331" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="45" />

<RELATION ID="1342" RelationName="C\k.-\gC" Kind="2" SrcTable="1098" DestTable="1098" FKFields="id=posper_category_id\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1344" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="45" />

<RELATION ID="1358" RelationName="CR\k-\gTC" Kind="1" SrcTable="1089" DestTable="1357" FKFields="id=posper_cashregister_id\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1361" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="49" />

<RELATION ID="1359" RelationName="TC\k-\gT" Kind="1" SrcTable="1182" DestTable="1357" FKFields="id=posper_ticket_id\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1363" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="50" />

<RELATION ID="1439" RelationName="P\k-\gF" Kind="2" SrcTable="1014" DestTable="1041" FKFields="id=posper_floor_id\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1441" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="54" />

<RELATION ID="1454" RelationName="TL\k-\gTX" Kind="2" SrcTable="1174" DestTable="1204" FKFields="id=posper_tax_id\n" FKFieldsComments="\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1455" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="55" />

<RELATION ID="1465" RelationName="I\k-\gIR" Kind="2" SrcTable="1107" DestTable="1463" FKFields="id=posper_image_id\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1467" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="58" />

<RELATION ID="1475" RelationName="P\k-\gP" Kind="2" SrcTable="1287" DestTable="1287" FKFields="name=posper_permission_name\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1477" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="59" />

<RELATION ID="1505" RelationName="TL\k-\gT" Kind="2" SrcTable="1182" DestTable="1204" FKFields="id=posper_ticket_id\n" FKFieldsComments="\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1507" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="53" />

<RELATION ID="1510" RelationName="P\k-\gT" Kind="2" SrcTable="1182" DestTable="1126" FKFields="id=posper_ticket_id\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="1512" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="54" />

</RELATIONS> <NOTES> </NOTES> <IMAGES> </IMAGES> </METADATA> <PLUGINDATA> <PLUGINDATARECORDS> </PLUGINDATARECORDS> </PLUGINDATA> <QUERYDATA> <QUERYRECORDS> </QUERYRECORDS> </QUERYDATA> <LINKEDMODELS> </LINKEDMODELS> </DBMODEL>


text:
Using POSper/Developer guide/SQL Queries

Postgres Total Sales Per Date: SELECT date(tickets.datenew), SUM(productsout.price*productsout.units) AS total FROM tickets LEFT OUTER JOIN productsout ON tickets.ticketid=productsout.ticketid GROUP BY date ORDER BY date Totals per product, per date, within a date range: SELECT date(datenew) AS theDate, name, SUM(units * price) AS price FROM productsout LEFT OUTER JOIN products ON productsout.product=products.reference LEFT OUTER JOIN tickets on productsout.ticketid=tickets.ticketid

WHERE datenew BETWEEN '2006/2/16' AND '2006/2/19:23:59'

GROUP BY date(datenew),name ORDER BY date(datenew),name Reset Database without removing products ?

MySQL:

license: Creative Commons - Attribution Share-Alike - https://creativecommons.org/licenses/by-sa/4.0/


text:
Using POSper/Left Menu

Overview
This page is dedicated to the menu on the left side of the screen when POSper is running.

My idea is that each item has helpful information (including answers to forum questions) so do please add information or change layout as you see fit

There are three main menu sections:
 * Principal
 * Administration
 * System

Principal

 * Sales
 * Edit Sales
 * Payments
 * Current Cash
 * Close Cash

Administration

 * Stock
 * Maintenance
 * Products Add your products here Link01 Link02
 * Products by Warehouse ????
 * Categories Define the different Product categories for your products here. Link01
 * Taxes Here you can define the different taxes you will need to use for the sale of your products in your country. Link01
 * Stock Diary ????
 * Stock Maintenance ????
 * Reports
 * Products
 * Catalog
 * Warehouses
 * Current Inventory
 * Current Inventory Broken
 * Inventory Diary

 * Sales
 * Reports
 * Cash by User
 * Product Sales
 * Taxes
 * Sales Chart

 * Maintenance
 * Point of Sale
 * Users In this section you can add new users to POSPER Link01
 * Roles define roles and Privileges for different users Link01
 * Resources Resources change much of the layout and appearance of receipts and other things within POSPER, you can find more Info on how to edit them by following these links Link01 Link02
 * Warehouses here you can setup different warehouses/ storerooms, where your stock will be stored e.g.: bar, cellar ...
 * Floors (for use in restaurant mode) you can setup different floors of your restaurant here e.g.: outside, front, back, first floor.
 * Tables (for use in restaurant mode) you can create different tables, like in your restaurant.
 * Openbravo ERP
 * Products synchronisation
 * Orders Synchronisation

System

 * Change Password Assign a Password or change your existing Password. !!!By default there are no passwords assigned to Users!!!

 * Configuration
 * Database Configure here, which database POSPER will use Link01
 * Cash Register Details on configuring your hardware Link01
 * Payment Configure your Credit Card payment gateway here
 * Layout Configure the appearance of the product and category buttons. The *size buttons use values like "130,50" to set the width to 130 and the height to 50. The style setting understands HTML/CSS like "color:blue; font-size:80%;" and are also used to align the images. Valid options are "image-position:right", "image-position:left", "image-position:bottom", "image-position:center".

 * Printer This tab gives you on screen printouts of your receipts that have been going through the till

 * Exit Log yourself out by clicking here, to return to the startup screen for a different user to log in.

title: Using POSper/Left Menu


text:
User:Arsharpe/drafts

User:arsharpe/drafts/berlingo_service_manual

User:arsharpe/drafts/kangoo

User:arsharpe/drafts/berlingo_service_manual_current

User:arsharpe/drafts/berling_owners_manual_current

User:arsharpe/drafts/berlingo_fault_finding1

User:arsharpe/drafts/bvs_beginners

User:arsharpe/drafts/max_ev_range

User:arsharpe/drafts/berlingo_brushes

User:arsharpe/drafts/yahoo_notes

title: User:Arsharpe/drafts


text:
GIMP/Saving as JPEG

When saving as a JPEG, you should let the image itself dictate the quality rather than reusing settings. The same settings for one image may produce significant loss on another.

Basic Settings
Quality: the overall quality of the output JPEG. The lower this value is the more compression you'll attain, at a cost to visual quality. Generally you'll want the lowest quality with no significantly noticeable loss. Start at the default and adjust to the best compromise for the image. You shouldn't usually go above 95, as the size grows significantly for no noticeable quality gain. Likewise, you shouldn't go below ~25 as banding may occur. The “Show Preview in image Window” option creates a new layer with how the image will look with the current settings. It updates in real-time as you change the settings. You can zoom or hide as usual to get a better look at the quality.

Advanced Settings
These can be uncollapsed by selecting the box next to “Advanced Settings” and are saved for the current session, along with most other saving settings.

Lossy
These settings alter the actual image to help with compression. Changing these will change the overall subjective quality of the image.  Smoothing:  Setting the smoothing option to a non-zero value will smooth out the image slightly. This reduces fuzzy artifacts from compression, and helps with the compression. A setting of 0.10-0.15 removes a good portion of the artifacts without smearing edges.  Subsampling:  Gimp allows three subsampling modes. Subsampling discards more colour information (which is harder to discern) compared to luminance. Subsampling improves image compression at a cost to image quality, sometimes a significantly noticeable loss (such as on red), or no noticeable difference at all. Subsampling on an image where it shouldn't be used will smear the detail, most noticeably on sharp edges. If you notice significant loss with the default, you can turn it off by selecting "4:4:4", which is technically no subsampling.  DCT Method:  The 'Floating' DCT method produces slightly better results than the 'Integer' method with a slight cost to speed. 'Fast Integer' should only be used where speed is imperative. (DCT) Discrete_cosine_transform Discrete Cosine Transform is generally a mathematical method that helps reduce the amount of unnecessary detail and aids in lossy compression methods.

Lossless
The following settings are lossless, meaning they don't affect the image's quality.  Optimize:  Optimize the images table for a gain in compression. Unless speed is a concern, there's no reason to turn it off.  Comment:  Add a comment to the image.  Save EXIF Data:  Preserve EXIF metadata about the image, such as when and where it was taken. For images with no EXIF data, this option will be grayed out.  Save Thumbnail:  Save a thumbnail of the image into the JPEG file itself. (Most software that use thumbnails can generate thumbnails on their own, in which case saving your own is unnecessary and would add several kilobytes to the image size.)  Progressive:  Change how the image loads. A standard JPEG loads in rows from top to bottom, which may create an unsightly blank region on a user's screen while loading. In contrast, a progressive JPEG covers its entire area from the start, but in a rough form that becomes more refined as the JPEG loads. Progressive encoding also helps with the image compression. Leaving this option unchecked will result in Standard encoding.

 Restart Markers:  Restart markers are useful when data corruption can occur; the image will only be corrupt up until the next marker. Setting this higher increases the frequency of restart markers at a cost to filesize. Without restart makers, if any corruption occurs, the entire file can be compromised.

title: GIMP/Saving as JPEG


text:
User:Lindsay Ridgeway

Welcome to the userpage for Lindsay Ridgeway.

Books under Construction
Here's are links to my Wikibooks:

 * The 2Q Retriever: A Field Training Workbook
 * The 2Q Retriever: A Field Training Workbook (Print Version)

Obsolete chapters from The 2Q Retriever, to be incorporated into new structure:

 * "Foundation Training"
 * "Thrown Marks"

Links for an earlier attempt at this project, maintained temporarily for possible source material in The 2Q Retriever:

 * Reward-based Field Training for Retrievers
 * Reward-based Field Training for Retrievers (Print Version)
 * Alternative Name: Clicker Training the American Retriever
 * Another Alternative Name: Training the American Retriever: The Discovery Method

title: User:Lindsay Ridgeway


text:
User talk:61.102.10.205

Please stop removing content from Wikibooks; it is considered vandalism. If you want to experiment, please use the sandbox. Thank you. -- Herby talk thyme 12:39, 10 July 2007 (UTC)

title: User talk:61.102.10.205


text:
User:Lindsay Ridgeway/Reward-based Field Training for Retrievers

Table of Contents

 * /Preface/

 * /Disclaimer/

 * /How to Use This Book/

 * 1) /Principles/
 * 2) /Foundation Behaviors/
 * 3) /Basic Retriever Skills/
 * 4) /Marked Retrieve/
 * 5) /Blind Retrieve/
 * 6) /Problem Solving/

 * /Bibliography/

 * /Authors/


text:
Chess Opening Theory/1. e4/1...e5/2. Nf3/2...Nc6/3. Bb5/3...a6/4. Ba4/4...Nf6/5. O-O/5...Be7

=Closed Ruy Lopez=

Whereas had Black chosen to capture White's e-pawn on the previous move, White could recover the pawn tactically by exploiting Black's multiple vulnerabilities on the half-open e-file, 5...Be7 has removed one of these vulnerabilities by guarding the Black King. Consequently, Black now threatens to win the pawn outright via 6...b5 (removing White's remaining tactical opportunity to win Black's e-pawn in exchange for his own) 7. Bb3 Nxe4. White typically removes this threat with
 * 6. Re1.

Either
 * 6. Nc3 or
 * 6. d3 would again interfere with White's optimal plan of c3 and d4 (compare the position before 5. O-O).

White can also opt for
 * 6. Bxc6!?, the fantastically named Delayed Exchange Ruy Lopez Deferred (deferred with 4. Ba4 and delayed with 5. O-O, or something like that). Compared to the main line of the Exchange Variation, White has lost a tempo, but Black can no longer play ...f6 to hold the e-pawn. White can also argue that Black's bishop on e7 is awkwardly developed compared to the normal Exchange Variation.

Just as White had the option of 5. Qe2 last move, she can now play
 * 6. Qe2, the Worrall Attack (yes, it's confusing having the Wormald and the Worrall depending on when you play Qe2). Again the plan is to hold e4 with the queen and move the rook to d1 in preparation for d2-d4, and again this has the drawback of putting the queen on the file most likely to be opened by Black.

Theory table
.

1. e4 e5 2. Nf3 Nc6 3. Bb5 a6 4. Ba4 Nf6 5. O-O Be7


text:
College Guide/Swarthmore College

Swarthmore is a highly competitive liberal arts college in Pennsylvania.

Admission

 * 15% ../Acceptance rate/
 * ../Early Decision/ (November 15)
 * Regular admission (January 2)
 * Middle 50% of SAT scores:
 * Critical Reading: 660 - 770
 * Math: 660 - 760
 * Writing: 650 - 760
 * Average High School ../GPA/:

Admission Factors
Very important:
 * ../Essays/
 * Personality
 * Class rank
 * ../Recommendations/
 * Secondary school record

Important:
 * Extracurricular activities
 * Standardized test scores

Academics

 * ../Student-faculty ratio/ - 8:1
 * Honors program

Demographics

 * Enrollment: 1484
 * M/F ratio: 48/52

Cost and Financial Aid

 * Tuition: $34,884
 * Room and Board: $10,816

Location
20 minutes (?) from Philadelphia

Sports
NCAA Division III

Campus Life
7% of students join a fraternity or sorority

Should You Go?
Swarthmore is a great place if you are politically active (especially if you lean towards the left). Also, Swarthmore has one of the highest rates of students who eventually get a PhD. However, many people on studentsreview complain about poor social life.

Contact
500 College Avenue Swarthmore, PA 19081 (610) 328-8000 www.swarthmore.edu

title: College Guide/Swarthmore College