[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-cvs] [SqlQueries] (edit) sql explorations
From: |
karlberry |
Subject: |
[Savannah-cvs] [SqlQueries] (edit) sql explorations |
Date: |
Mon, 12 Sep 2011 18:33:39 +0000 |
??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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Savannah-cvs] [SqlQueries] (edit) sql explorations,
karlberry <=