Changeset 1031

Show
Ignore:
Timestamp:
12/29/07 22:05:03 (1 year ago)
Author:
samtay
Message:

Added karmaLocks table, members table, screenshots table, comments table

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • sandbox/appdb/sql/Database.xml

    r981 r1031  
    319319<RELATIONS_START> 
    320320<RELATION_START ID="1381" /> 
     321<RELATION_START ID="1522" /> 
    321322</RELATIONS_START> 
    322323<RELATIONS_END> 
    …… 
    336337</INDICES> 
    337338</TABLE> 
    338 <TABLE ID="1208" Tablename="repository" PrevTableName="Table_02" XPos="321" YPos="20" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" > 
     339<TABLE ID="1208" Tablename="repository" PrevTableName="Table_02" XPos="380" YPos="18" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" > 
    339340<COLUMNS> 
    340341<COLUMN ID="1210" ColName="repoID" PrevColName="" Pos="0" idDatatype="4" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> 
    …… 
    366367</INDICES> 
    367368</TABLE> 
    368 <TABLE ID="1229" Tablename="applicationVersions" PrevTableName="Table_04" XPos="323" YPos="127" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="4" > 
     369<TABLE ID="1229" Tablename="applicationVersions" PrevTableName="Table_04" XPos="367" YPos="149" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="4" > 
    369370<COLUMNS> 
    370371<COLUMN ID="1231" ColName="appVersionID" PrevColName="" Pos="0" idDatatype="4" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> 
    …… 
    374375</OPTIONSELECTED> 
    375376</COLUMN> 
     377<COLUMN ID="1485" ColName="memberID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
     378<OPTIONSELECTED> 
     379<OPTIONSELECT Value="1" /> 
     380<OPTIONSELECT Value="0" /> 
     381</OPTIONSELECTED> 
     382</COLUMN> 
    376383<COLUMN ID="1388" ColName="appID" PrevColName="" Pos="1" idDatatype="4" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
    377384<OPTIONSELECTED> 
    …… 
    472479<COLUMN ID="1449" ColName="wdiFile" PrevColName="" Pos="20" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
    473480<OPTIONSELECTED> 
     481<OPTIONSELECT Value="0" /> 
     482</OPTIONSELECTED> 
     483</COLUMN> 
     484<COLUMN ID="1476" ColName="applicationVersionkarma" PrevColName="" Pos="21" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments=""> 
     485<OPTIONSELECTED> 
     486<OPTIONSELECT Value="1" /> 
    474487<OPTIONSELECT Value="0" /> 
    475488</OPTIONSELECTED> 
    …… 
    484497<RELATIONS_END> 
    485498<RELATION_END ID="1381" /> 
     499<RELATION_END ID="1481" /> 
    486500</RELATIONS_END> 
    487501<INDICES> 
    …… 
    496510</INDEXCOLUMNS> 
    497511</INDEX> 
    498 </INDICES> 
    499 </TABLE> 
    500 <TABLE ID="1276" Tablename="applicationRequires" PrevTableName="Table_05" XPos="21" YPos="274" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="5" > 
     512<INDEX ID="1483" IndexName="applicationVersions_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1481"> 
     513<INDEXCOLUMNS> 
     514<INDEXCOLUMN idColumn="1485" LengthParam="0" /> 
     515</INDEXCOLUMNS> 
     516</INDEX> 
     517</INDICES> 
     518</TABLE> 
     519<TABLE ID="1276" Tablename="applicationRequires" PrevTableName="Table_05" XPos="25" YPos="274" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="5" > 
    501520<COLUMNS> 
    502521<COLUMN ID="1278" ColName="appRequiresID" PrevColName="" Pos="0" idDatatype="4" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> 
    …… 
    539558</INDICES> 
    540559</TABLE> 
    541 <TABLE ID="1389" Tablename="applicationFiles" PrevTableName="Table_05" XPos="35" YPos="407" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="9" > 
     560<TABLE ID="1389" Tablename="applicationFiles" PrevTableName="Table_05" XPos="28" YPos="406" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="9" > 
    542561<COLUMNS> 
    543562<COLUMN ID="1391" ColName="appUrlID" PrevColName="applcationUrlID" Pos="0" idDatatype="4" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> 
    …… 
    580599</INDICES> 
    581600</TABLE> 
    582 <TABLE ID="1401" Tablename="applicationCracks" PrevTableName="Table_06" XPos="202" YPos="578" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="11" > 
     601<TABLE ID="1401" Tablename="applicationCracks" PrevTableName="Table_06" XPos="182" YPos="680" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="11" > 
    583602<COLUMNS> 
    584603<COLUMN ID="1404" ColName="appCracksID" PrevColName="applicationCracksID" Pos="0" idDatatype="4" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> 
    …… 
    626645</INDICES> 
    627646</TABLE> 
    628 <TABLE ID="1426" Tablename="applicationCD" PrevTableName="Table_07" XPos="427" YPos="578" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="14" > 
     647<TABLE ID="1426" Tablename="applicationCD" PrevTableName="Table_07" XPos="416" YPos="677" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="14" > 
    629648<COLUMNS> 
    630649<COLUMN ID="1428" ColName="appCdID" PrevColName="" Pos="0" idDatatype="4" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> 
    …… 
    662681</INDICES> 
    663682</TABLE> 
     683<TABLE ID="1450" Tablename="members" PrevTableName="Table_08" XPos="632" YPos="273" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" > 
     684<COLUMNS> 
     685<COLUMN ID="1452" ColName="memberID" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> 
     686<OPTIONSELECTED> 
     687<OPTIONSELECT Value="1" /> 
     688<OPTIONSELECT Value="0" /> 
     689</OPTIONSELECTED> 
     690</COLUMN> 
     691<COLUMN ID="1454" ColName="memberEmail" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     692<OPTIONSELECTED> 
     693<OPTIONSELECT Value="0" /> 
     694</OPTIONSELECTED> 
     695</COLUMN> 
     696<COLUMN ID="1455" ColName="memberPassword" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     697<OPTIONSELECTED> 
     698<OPTIONSELECT Value="0" /> 
     699</OPTIONSELECTED> 
     700</COLUMN> 
     701<COLUMN ID="1456" ColName="joinDate" PrevColName="" Pos="3" idDatatype="16" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     702<OPTIONSELECTED> 
     703</OPTIONSELECTED> 
     704</COLUMN> 
     705<COLUMN ID="1457" ColName="userLevel" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     706<OPTIONSELECTED> 
     707<OPTIONSELECT Value="1" /> 
     708<OPTIONSELECT Value="0" /> 
     709</OPTIONSELECTED> 
     710</COLUMN> 
     711</COLUMNS> 
     712<RELATIONS_START> 
     713<RELATION_START ID="1481" /> 
     714<RELATION_START ID="1486" /> 
     715<RELATION_START ID="1501" /> 
     716<RELATION_START ID="1525" /> 
     717</RELATIONS_START> 
     718<INDICES> 
     719<INDEX ID="1453" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
     720<INDEXCOLUMNS> 
     721<INDEXCOLUMN idColumn="1452" LengthParam="0" /> 
     722</INDEXCOLUMNS> 
     723</INDEX> 
     724</INDICES> 
     725</TABLE> 
     726<TABLE ID="1458" Tablename="comments" PrevTableName="Table_09" XPos="593" YPos="441" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="17" > 
     727<COLUMNS> 
     728<COLUMN ID="1460" ColName="commentID" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> 
     729<OPTIONSELECTED> 
     730<OPTIONSELECT Value="1" /> 
     731<OPTIONSELECT Value="0" /> 
     732</OPTIONSELECTED> 
     733</COLUMN> 
     734<COLUMN ID="1489" ColName="memberID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
     735<OPTIONSELECTED> 
     736<OPTIONSELECT Value="1" /> 
     737<OPTIONSELECT Value="0" /> 
     738</OPTIONSELECTED> 
     739</COLUMN> 
     740<COLUMN ID="1462" ColName="commentObject" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     741<OPTIONSELECTED> 
     742<OPTIONSELECT Value="1" /> 
     743<OPTIONSELECT Value="0" /> 
     744</OPTIONSELECTED> 
     745</COLUMN> 
     746<COLUMN ID="1463" ColName="commentObjectId" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     747<OPTIONSELECTED> 
     748<OPTIONSELECT Value="1" /> 
     749<OPTIONSELECT Value="0" /> 
     750</OPTIONSELECTED> 
     751</COLUMN> 
     752<COLUMN ID="1464" ColName="commentBody" PrevColName="" Pos="3" idDatatype="30" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     753<OPTIONSELECTED> 
     754</OPTIONSELECTED> 
     755</COLUMN> 
     756<COLUMN ID="1465" ColName="commentDate" PrevColName="" Pos="4" idDatatype="16" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     757<OPTIONSELECTED> 
     758</OPTIONSELECTED> 
     759</COLUMN> 
     760<COLUMN ID="1466" ColName="commentUserIp" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(45)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     761<OPTIONSELECTED> 
     762<OPTIONSELECT Value="0" /> 
     763</OPTIONSELECTED> 
     764</COLUMN> 
     765<COLUMN ID="1474" ColName="commentKarma" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments=""> 
     766<OPTIONSELECTED> 
     767<OPTIONSELECT Value="1" /> 
     768<OPTIONSELECT Value="0" /> 
     769</OPTIONSELECTED> 
     770</COLUMN> 
     771</COLUMNS> 
     772<RELATIONS_END> 
     773<RELATION_END ID="1486" /> 
     774</RELATIONS_END> 
     775<INDICES> 
     776<INDEX ID="1461" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
     777<INDEXCOLUMNS> 
     778<INDEXCOLUMN idColumn="1460" LengthParam="0" /> 
     779</INDEXCOLUMNS> 
     780</INDEX> 
     781<INDEX ID="1488" IndexName="comments_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1486"> 
     782<INDEXCOLUMNS> 
     783<INDEXCOLUMN idColumn="1489" LengthParam="0" /> 
     784</INDEXCOLUMNS> 
     785</INDEX> 
     786</INDICES> 
     787</TABLE> 
     788<TABLE ID="1490" Tablename="karmaLock" PrevTableName="Table_12" XPos="891" YPos="324" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" > 
     789<COLUMNS> 
     790<COLUMN ID="1492" ColName="karmaLockId" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> 
     791<OPTIONSELECTED> 
     792<OPTIONSELECT Value="1" /> 
     793<OPTIONSELECT Value="0" /> 
     794</OPTIONSELECTED> 
     795</COLUMN> 
     796<COLUMN ID="1505" ColName="memberID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
     797<OPTIONSELECTED> 
     798<OPTIONSELECT Value="1" /> 
     799<OPTIONSELECT Value="0" /> 
     800</OPTIONSELECTED> 
     801</COLUMN> 
     802<COLUMN ID="1494" ColName="karmaObject" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     803<OPTIONSELECTED> 
     804<OPTIONSELECT Value="1" /> 
     805<OPTIONSELECT Value="0" /> 
     806</OPTIONSELECTED> 
     807</COLUMN> 
     808<COLUMN ID="1495" ColName="karmaObjectID" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     809<OPTIONSELECTED> 
     810<OPTIONSELECT Value="1" /> 
     811<OPTIONSELECT Value="0" /> 
     812</OPTIONSELECTED> 
     813</COLUMN> 
     814<COLUMN ID="1496" ColName="karmaUserIp" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(45)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     815<OPTIONSELECTED> 
     816<OPTIONSELECT Value="0" /> 
     817</OPTIONSELECTED> 
     818</COLUMN> 
     819<COLUMN ID="1497" ColName="KarmaStatus" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="If user voted +n then status = 1 if user votes -n status = 0"> 
     820<OPTIONSELECTED> 
     821<OPTIONSELECT Value="1" /> 
     822<OPTIONSELECT Value="0" /> 
     823</OPTIONSELECTED> 
     824</COLUMN> 
     825<COLUMN ID="1514" ColName="karmaTime" PrevColName="" Pos="6" idDatatype="16" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     826<OPTIONSELECTED> 
     827</OPTIONSELECTED> 
     828</COLUMN> 
     829</COLUMNS> 
     830<RELATIONS_END> 
     831<RELATION_END ID="1501" /> 
     832</RELATIONS_END> 
     833<INDICES> 
     834<INDEX ID="1493" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
     835<INDEXCOLUMNS> 
     836<INDEXCOLUMN idColumn="1492" LengthParam="0" /> 
     837</INDEXCOLUMNS> 
     838</INDEX> 
     839<INDEX ID="1503" IndexName="karmaLock_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1501"> 
     840<INDEXCOLUMNS> 
     841<INDEXCOLUMN idColumn="1505" LengthParam="0" /> 
     842</INDEXCOLUMNS> 
     843</INDEX> 
     844</INDICES> 
     845</TABLE> 
     846<TABLE ID="1506" Tablename="screenshots" PrevTableName="Table_13" XPos="579" YPos="19" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="22" > 
     847<COLUMNS> 
     848<COLUMN ID="1508" ColName="screenshotID" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments=""> 
     849<OPTIONSELECTED> 
     850<OPTIONSELECT Value="1" /> 
     851<OPTIONSELECT Value="0" /> 
     852</OPTIONSELECTED> 
     853</COLUMN> 
     854<COLUMN ID="1529" ColName="appID" PrevColName="" Pos="1" idDatatype="4" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
     855<OPTIONSELECTED> 
     856<OPTIONSELECT Value="0" /> 
     857<OPTIONSELECT Value="0" /> 
     858</OPTIONSELECTED> 
     859</COLUMN> 
     860<COLUMN ID="1528" ColName="memberID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
     861<OPTIONSELECTED> 
     862<OPTIONSELECT Value="1" /> 
     863<OPTIONSELECT Value="0" /> 
     864</OPTIONSELECTED> 
     865</COLUMN> 
     866<COLUMN ID="1516" ColName="screenshotFile" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(255)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     867<OPTIONSELECTED> 
     868<OPTIONSELECT Value="0" /> 
     869</OPTIONSELECTED> 
     870</COLUMN> 
     871<COLUMN ID="1517" ColName="screenshotTime" PrevColName="" Pos="2" idDatatype="16" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
     872<OPTIONSELECTED> 
     873</OPTIONSELECTED> 
     874</COLUMN> 
     875<COLUMN ID="1518" ColName="screenshotKarma" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="0" Comments=""> 
     876<OPTIONSELECTED> 
     877<OPTIONSELECT Value="1" /> 
     878<OPTIONSELECT Value="0" /> 
     879</OPTIONSELECTED> 
     880</COLUMN> 
     881</COLUMNS> 
     882<RELATIONS_END> 
     883<RELATION_END ID="1522" /> 
     884<RELATION_END ID="1525" /> 
     885</RELATIONS_END> 
     886<INDICES> 
     887<INDEX ID="1509" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
     888<INDEXCOLUMNS> 
     889<INDEXCOLUMN idColumn="1508" LengthParam="0" /> 
     890</INDEXCOLUMNS> 
     891</INDEX> 
     892<INDEX ID="1524" IndexName="screenshots_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1522"> 
     893<INDEXCOLUMNS> 
     894<INDEXCOLUMN idColumn="1529" LengthParam="0" /> 
     895</INDEXCOLUMNS> 
     896</INDEX> 
     897<INDEX ID="1527" IndexName="screenshots_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1525"> 
     898<INDEXCOLUMNS> 
     899<INDEXCOLUMN idColumn="1528" LengthParam="0" /> 
     900</INDEXCOLUMNS> 
     901</INDEX> 
     902</INDICES> 
     903</TABLE> 
    664904</TABLES> 
    665905<RELATIONS> 
    666 <RELATION ID="1377" RelationName="Rel_04" Kind="2" SrcTable="1208" DestTable="1194" FKFields="repoID=repoID\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="1379" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="6" /> 
     906<RELATION ID="1377" RelationName="Rel_04" Kind="2" SrcTable="1208" DestTable="1194" FKFields="repoID=repoID\n" FKFieldsComments="\n" relDirection="4" MidOffset="-24" 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="1379" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="6" /> 
    667907<RELATION ID="1381" RelationName="Rel_05" Kind="2" SrcTable="1194" DestTable="1229" FKFields="appID=appID\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="1383" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="7" /> 
    668908<RELATION ID="1384" RelationName="Rel_06" Kind="2" SrcTable="1229" DestTable="1276" FKFields="appVersionID=appVersionID\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="1386" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" /> 
    …… 
    670910<RELATION ID="1409" RelationName="Rel_05" Kind="2" SrcTable="1229" DestTable="1401" FKFields="appVersionID=appVersionID\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="1411" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="12" /> 
    671911<RELATION ID="1433" RelationName="Rel_06" Kind="2" SrcTable="1229" DestTable="1426" FKFields="appVersionID=appVersionID\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="1435" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" /> 
     912<RELATION ID="1481" RelationName="Rel_07" Kind="2" SrcTable="1450" DestTable="1229" FKFields="memberID=memberID\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="1483" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="18" /> 
     913<RELATION ID="1486" RelationName="Rel_08" Kind="2" SrcTable="1450" DestTable="1458" FKFields="memberID=memberID\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="1488" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" /> 
     914<RELATION ID="1501" RelationName="Rel_10" Kind="2" SrcTable="1450" DestTable="1490" FKFields="memberID=memberID\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="1503" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="21" /> 
     915<RELATION ID="1522" RelationName="Rel_12" Kind="2" SrcTable="1194" DestTable="1506" FKFields="appID=appID\n" FKFieldsComments="\n" relDirection="2" MidOffset="-44" 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="1524" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="23" /> 
     916<RELATION ID="1525" RelationName="Rel_13" Kind="2" SrcTable="1450" DestTable="1506" FKFields="memberID=memberID\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="1527" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="24" /> 
    672917</RELATIONS> 
    673918<NOTES>