??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/SqlQueries#[email protected]/maintenance
