Re: DB Schema

[Lukáš Lommer <drom kdyne net>]

Just another one thing:

Comments > Status

This (status) means the status of the comment (new, reported, checked),
see ago comments administration.

Thomas Wood píše v Po 04. 06. 2007 v 20:47 +0100:
> On 04/06/07 19:06, Bruno Santos wrote:
> > Hey,
> > 
> > I've just finished a first version of the DB schema.
> > Give it a look and tell what you think.
> 
> Hi Bruno,
> 
> Thanks for the initial draft. I think we can use the artweb-list for 
> discussions like this one so anyone who is interested can comment.
> 
> I have a few questions to start with:
> 
> Artwork:
>    Missing a name field?
>    What is the allow_in_collection field for?
>    What is download_id?
> 
> Collection:
>    What is download_id?
>    Missing a name field?
> 
> Downloads:
>    Do we need an extra field here for file type, or size?
>    Should we calculate the resolution from the file, rather than have a 
> fixed number of resolutions?
> 
> Types:
>    Install instructions would be good here
> 
> Categories:
>    What are the values for flag?
> 
> Users:
>    "acl_level" should be just "acl"
>    Add last_login to record the last time the user logged in
> 
> 
> Thanks for the time taken to bring all this together! Perhaps we can now 
> add it to the wiki page?
> 
> We also need to decide on a naming convention for our table and field 
> names. There are some good ones on the internet. I have found 
> <http://justinsomnia.org/writings/naming_conventions.html> which is 
> probably closest to our current style. It also lists some alternatives 
> at the bottom. Let me know which one you like best.
> 
> Regards,
> 
> Thomas
> _______________________________________________
> artweb-list mailing list
> artweb-list gnome org
> http://mail.gnome.org/mailman/listinfo/artweb-list
-- 
Have a nice day
Lucas "Drom" Lommer
Art.Gnome.org team

You can visit us at #gnome-art channel on irc.gnome.org IRC server

GnuPG: http://kdyne.net/general/download/certifikaty/gpg-public_key-Lucas_Lommer.asc