Editing WikiDB/Tables

From TestWiki
Jump to: navigation, search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision Your text
Line 1: Line 1:
There are three additional tables that WikiDB will add to the database in order to store the data required by the extension. In all cases, the data stored in these tables is derived from data elsewhere on your wiki, therefore it is always safe to delete and rebuild these tables, if necessary.
+
There are three new tables in the database that store the WikiDB data. If you have any suggestions about how these could be further optimised, please discuss them on the [[Talk:WikiDB/Tables|talk page]].
 
+
If you have any suggestions about how these tables could be further optimised, please discuss them on the [[Talk:WikiDB/Tables|talk page]].
+
  
  
Line 7: Line 5:
 
'''IMPORTANT NOTES - READ THESE BEFORE YOU CONTINUE!'''
 
'''IMPORTANT NOTES - READ THESE BEFORE YOU CONTINUE!'''
  
# WikiDB comes with scripts to add these tables to the database, and to populate them with data (or to reset/re-populate them if necessary, e.g. because your configuration has changed).  The scripts will also allow you to upgrade existing installations if the schema has changed.  Therefore, so long as you have command-line access to run the [[WikiDB/Maintenance scripts|maintenance scripts]] then you should never need to manually modify the database.
+
# The schema may change as the extension develops and change may be incompatible with the current version.  It may not be obvious how to change from one version to another, and if the incorrect version is used, the behaviour is undefined.
# The schema may change as the extension develops and changes may be incompatible with the current version.  It may not be obvious how to change from one version to another, and if the incorrect version is used, the behaviour is undefined.  Therefore, take care if you are unable to run the command-line scripts, and so need to modify the tables manually.
+
# I have not yet built any script to rebuild the tables if you need to delete/recreate them for any reason. If you do this, you will need to perform a null edit to all pages that contain table or data definitions to get the data back in your cache.
# If a new release makes changes to the schema, then the major version of the WikiDB software will be incremented, so it should be easy to tell if you need to update your schema.  See [[WikiDB/Versioning]] for more details.
+
# I cannot be held responsible for any problems or damage that may arise from using this pre-release software... standard disclaimer, etc. :)
# ''The table definitions on this page are live'', and are pulled from the DB that is powering this wiki.  Any changes made to the live DB will automatically be reflected here (which is achieved using my [[Debugging tools]] extension).  This has two implications.  Occasionally I upgrade the wiki before a stable release is made available, for testing purposes.  In this case the schema shown here may be more recent than the latest released version.  Check [[Special:Version]] to see what version of WikiDB this wiki is running.  Secondly, because these are updated live and are not shown in the page history, there is no easy way to view the schema for old versions of WikiDB.  If this is a problem, you should check the SQL in <code>~/maintenance/sql/tables.sql</code>, though this is not in a format that is ready to be run directly on your database.
+
# I cannot be held responsible for any problems or damage that may arise from using the software, deploying with the wrong schema or running the SQL on this page... standard disclaimer, etc. :)
+
  
 +
''The table definitions on this page are live.  Changes to the DB will automatically be reflected here (which is achieved using my [[Debugging tools]] extension).''
 
----
 
----
  

Please note that all contributions to TestWiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see TestWiki:Copyrights for details). Do not submit copyrighted work without permission!

To edit this page, please answer the question that appears below (more info):

Cancel | Editing help (opens in new window)