[Savannah-cvs] [SqlQueries] (edit) sql explorations

[karlberry]

??changed:
-As of 20051217.
The following are not related to stats, but making a new page seemed worse.  
Here are some queries to get a grip on the mysql databases for savannah:

mysql savane     # on the internal subhost
show databases;           # show all databases in the installation
show tables from savane;  # show tables in the main database
show columns from savane.groups;  # show columns in one of the main tables

Random info: it seems the top-level "news" posts are saved in the 
savane.news_bytes table, with the group_id field recording the project and the 
id field the unique id for each post.  The savane.forum table is apparently 
only for replies to these news posts; its group_forum_id column matches up with 
the id column in news_bytes.


Some stats as of 20051217.

--
forwarded from http://savannah.gnu.org/maintenance/address@hidden/maintenance