Thread 'Description of the database'

Message boards : Server programs : Description of the database
Message board moderation

To post messages, you must log in.

AuthorMessage
Dorian

Send message
Joined: 16 Apr 15
Posts: 3
United Kingdom
Message 61633 - Posted: 16 Apr 2015, 14:18:26 UTC

Hello, after several days of research, I still do not find full documentation on MySQL architecture BOINC.
I am currently in the process of creating a graphical user interface in order to view the mass of data stored.

I would like know if there is a detailed description of the different tables and columns, and their possible status code.

Thank you in advance, and if you need more information, I remain at your disposal.

Dorian
ID: 61633 · Report as offensive
Richard Haselgrove
Volunteer tester
Help desk expert

Send message
Joined: 5 Oct 06
Posts: 5129
United Kingdom
Message 61635 - Posted: 16 Apr 2015, 14:42:15 UTC - in response to Message 61633.  

I don't know of any documentation, but the 'schema' files in http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=tree;f=db have the formal code needed to generate the tables and indexes.

Be aware that some fields have been recycled and are no longer used for the purposes their names suggest...
ID: 61635 · Report as offensive
Dorian

Send message
Joined: 16 Apr 15
Posts: 3
United Kingdom
Message 61762 - Posted: 21 Apr 2015, 9:58:21 UTC - in response to Message 61635.  

I don't know of any documentation, but the 'schema' files in http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=tree;f=db have the formal code needed to generate the tables and indexes.

Be aware that some fields have been recycled and are no longer used for the purposes their names suggest...


Thank you for your reply.
It looks like it lacks a bit of documentation on this subject, which could be very useful. (Description of columns, return codes...)
ID: 61762 · Report as offensive
ProfileJord
Volunteer tester
Help desk expert
Avatar

Send message
Joined: 29 Aug 05
Posts: 15567
Netherlands
Message 61763 - Posted: 21 Apr 2015, 10:09:18 UTC

ID: 61763 · Report as offensive
ProfileJord
Volunteer tester
Help desk expert
Avatar

Send message
Joined: 29 Aug 05
Posts: 15567
Netherlands
Message 61791 - Posted: 21 Apr 2015, 17:41:53 UTC
Last modified: 22 Apr 2015, 13:03:19 UTC

ID: 61791 · Report as offensive
Dorian

Send message
Joined: 16 Apr 15
Posts: 3
United Kingdom
Message 61812 - Posted: 22 Apr 2015, 12:57:41 UTC - in response to Message 61791.  

Thank you for your help!
These documents meet my needs.
If I have enough time to combine these documents, i will do it,it may help.
ID: 61812 · Report as offensive

Message boards : Server programs : Description of the database

Copyright © 2024 University of California.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.