[Savannah-cvs] [97] trivially reformat

[karl]

Revision: 97
          http://svn.sv.gnu.org/viewvc/?view=rev&root=administration&revision=97
Author:   karl
Date:     2014-08-18 23:20:45 +0000 (Mon, 18 Aug 2014)
Log Message:
-----------
trivially reformat

Modified Paths:
--------------
    trunk/sviki/SqlQueries.mdwn

Modified: trunk/sviki/SqlQueries.mdwn
===================================================================
--- trunk/sviki/SqlQueries.mdwn 2014-08-14 22:02:21 UTC (rev 96)
+++ trunk/sviki/SqlQueries.mdwn 2014-08-18 23:20:45 UTC (rev 97)
@@ -1,23 +1,36 @@
-    (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:
+SQL queries and info
+--------------------
 
-      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
+Here are some queries to get a grip on the mysql databases for savannah:
 
-    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 forum_id 
column in news_bytes.  Set display type of news comments to flat or 
replies-to-comments will not be displayed.
+  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
 
-    On the internal host, in /root/bin are some scripts:
-      forum-remove-by-id, items-list-by-id, items-remove-by-id
-    The first silently removes all forum posts for ids listed on the cmdline.
-    The second lists all posts in all trackers, plus forum posts, for the 
given id,
-    the third removes all posts in all trackers, plus forum posts.
+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 forum_id column in news_bytes.  Set display type of news
+comments to flat or replies-to-comments will not be displayed.
 
-    This was all to deal with the overwhelming accumulated spam in news posts 
comments, sept 2011.
+On the internal host, in /root/bin are some scripts:
+  forum-remove-by-id, items-list-by-id, items-remove-by-id
+The first silently removes all forum posts for ids listed on the cmdline.
+The second lists all posts in all trackers, plus forum posts, for the given id,
+the third removes all posts in all trackers, plus forum posts.
 
-    Some (old) stats, as of 20051217.
-    As you can see, we have actually few CVS users; most of our traffic is 
from people who browse resources.
+This was all to deal with the overwhelming accumulated spam in news
+posts comments, sept 2011.
 
+Old stats
+--------
+Some (old) stats, as of 20051217.
+
+As you can see, we have actually few CVS users; most of our traffic is
+from people (spiders?) who browse resources.
+
     # Number of users with shell access (!)
     mysql> select count(*) from user where authorized_keys is not null and 
authorized_keys != "";
     +----------+