Version 2

How To Use SchemaChangelog

Created by: Unknown, Last modification: 16 Aug 2007 (14:56 UTC) by Unknown
The SchemaChangelog and thesis proposal page is a record of changes made to database tables in the current head branch of the bitweaver code base. This page offers some tips for using the information in the schema changelog with various databases.

Implementing Updates on MySQL

Schema change code listed on the SchemaChangelog page is written in SQL92 and for the most part is compatible with most SQL databases. That said, MySQL can be a pain in the ass and does not always accept SQL92 queries. In these cases look for special "-MySQL" notes in the listed changes. These notes offer alternative queries specifically written for MySQL.

Reporting Problems with MySQL

If you have a problem with running a query from the SchemaChangelog page on MySQL and no specific MySQL alternative query is included for the update, please report your finding on freenode IRC channel #bitweaver.

Using cPanelX

  1. Select "MySQL Databases"
  2. Select "phpMyAdmin" at bottom of page
  3. Select database table matching the updated you want to implement from SchemaChangelog
  4. Select SQL tab
  5. Paste SQL command from the SchemaChangelog page into "Run SQL query/queries on database" field
Page History
04 Nov 2007 (22:55 UTC)
Current • Source
View • Compare • Difference • Source
View • Compare • Difference • Source
View • Compare • Difference • Source
View • Compare • Difference • Source