[isf-wifidog] Terms of service support

[Max Horváth]

Hi,

if TOS_id would be an autoincrementing integer I#d like the  
implementation ...

Cheers, Max

Robin Jones wrote:

> Hi Gabriel,
>
> I agree with you about the TermsOfService Tables TOS_id being a  
> Primary Key set to an auto incrementing integer and that the  
> TOS_Accepted_Users table should be linked by a foreign key  
> constraint. However the way I envisioned the version to work is that  
> when the terms of service is updated, the TermsOfService version  
> number is incremented, then when a user logs in, the  
> TOS_Accepted_Users version number is checked against the  
> TermsOfService Tables version number. If they are not equal, the  
> user is prompted to agree to the new terms and the row is updated to  
> reflect this.
>
> The Nodes and networks table should also be linked to the TOS_id  
> through a foreign key constraint.
>
>
> Hope all that makes sense.
>
>
> Regards,
>
> Robin.
>
> ________________________________
>
> From: wifidog-bounces at listes.ilesansfil.org on behalf of Gabriel  
> Hahmann
> Sent: Sun 9/28/2008 4:41 PM
> To: WiFiDog Captive Portal
> Subject: Re: [isf-wifidog] Terms of service support
>
>
> 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
> 	
>
>
> <winmail.dat>_______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog