[isf-wifidog] Terms of service support

[Gabriel Hahmann]

Robin,

I have some suggestions to make to your DB implementation of the TOS.

If you think that this can help, latter I can add on the wiki page.

TermsOfService Table:
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.

TOS_Accepted_Users Table:
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.

networks and nodes table:
I think that all tables that references the TOS need to use the TOS_id and
Version columns.

Regards,
Gabriel.

On Fri, Sep 26, 2008 at 7:38 PM, Robin Jones <Robin at networkfusion.co.uk>wrote:

>  Hi All,
>
> I have created a new document in the Wiki about how to implement Terms Of
> Service support (http://dev.wifidog.org/wiki/doc/developer/TermsOfService),
> 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!!!
>
>
> Regards,
>
> Robin.
>
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listes.ilesansfil.org/pipermail/wifidog/attachments/20080928/881feca6/attachment.htm