<div dir="ltr"><div>Robin,</div>
<div> </div>
<div>I have some suggestions to make to your DB implementation of the TOS.</div>
<div> </div>
<div>If you think that this can help, latter I can add on the wiki page.</div>
<div> </div>
<div>TermsOfService Table:</div>
<div>I think that the TOS_id could be of type integer as there would be fewer TOS on a whole network and this way we can create a sequence to generate them, we could add also a PRIMARY KEY constraint on the columns TOS_id and Version.</div>
<div> </div>
<div>TOS_Accepted_Users Table:</div>
<div>The columns TOS_id and Version could reference the same columns on the TermsOfService with a FOREIGN KEY constraint and user_id references the same column name on the table user.<br><br>networks and nodes table:</div>
<div>I think that all tables that references the TOS need to use the TOS_id and Version columns.</div>
<div> </div>
<div>Regards,</div>
<div>Gabriel.</div>
<div> </div>
<div class="gmail_quote">On Fri, Sep 26, 2008 at 7:38 PM, Robin Jones <span dir="ltr"><<a href="mailto:Robin@networkfusion.co.uk">Robin@networkfusion.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div><font face="Arial" color="#000000" size="2">Hi All,</font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">I have created a new document in the Wiki about how to implement Terms Of Service support (<a href="http://dev.wifidog.org/wiki/doc/developer/TermsOfService" target="_blank">http://dev.wifidog.org/wiki/doc/developer/TermsOfService</a>), Could people have a look and add to if they can (Max?). I have tried to make it support as many scenarios as possible and hopefully cover all the bases!!!</font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">Regards,</font></div>
<div><font face="Arial" size="2"></font> </div><font color="#888888">
<div><font face="Arial" size="2">Robin.</font></div></font></div><br>_______________________________________________<br>WiFiDog mailing list<br><a href="mailto:WiFiDog@listes.ilesansfil.org">WiFiDog@listes.ilesansfil.org</a><br>
<a href="http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog" target="_blank">http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog</a><br></blockquote></div><br></div>