Message boards : Server programs : Description of the database
Message board moderation
Author | Message |
---|---|
Send message Joined: 16 Apr 15 Posts: 3 |
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 |
Send message Joined: 5 Oct 06 Posts: 5123 |
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... |
Send message Joined: 16 Apr 15 Posts: 3 |
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. 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...) |
Send message Joined: 29 Aug 05 Posts: 15550 |
|
Send message Joined: 29 Aug 05 Posts: 15550 |
I asked David about this: - The table definitions (SQL) are in boinc/db/schema.sql http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=blob;f=db/schema.sql;h=cc4dbcb37b9f8df7484abf10aa0a5e7ff446efa4;hb=master - The various fields are documented in the corresponding .h file, boinc/db/boinc_db_types.h: http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=blob;f=db/boinc_db_types.h;h=22ce07d2e1d1d746400b31705d42a413abf17ae2;hb=master ... and in lib/common_defs.h: http://boinc.berkeley.edu/gitweb/?p=boinc-v2.git;a=blob;f=lib/common_defs.h;h=cd50472816d93ad307f410c449b31f8a1abe839c;hb=master |
Send message Joined: 16 Apr 15 Posts: 3 |
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. |
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.