use dokuwiki to maintain your SQL document

I use dokuwiki to maintain my developer’s document, especial for sql statement and data struture. I want my document has those futures:

  • code highlight
  • quick jump to other user objects or views display in current page
  • identify user objects, functions , views etc.
  • change log and history

I use dokuwiki to be the platform, and do the changes:

  • modify \inc\geshi\tsql.php  ( or you can add your script file, but remember to change  code language in document )
  • at line 47 add a new array item
  • ‘KEYWORDS’ => array(
    5 => array(
    //user’s object higlighted brown.
    ‘[book as1 select1]’, ‘中文的資料’,’Tables or Views list here’,
    ),
  • at line 361 add a new array item, so you can make quick link to your tables or views etc.
    • ‘URLS’ => array(
      1 => “,
      2 => “,
      3 => “,
      4 => “,
      5 => ‘http://localhost/dokuwiki/doku.php?id={FNAMEL}’
      ),
  • if your views or tables wiki page locate in different url, you can create new items above.  {FNAMEL} mean the keywoard listed in KEYWOARD array.

發表迴響

你的電子郵件位址並不會被公開。 必要欄位標記為 *

What is 15 + 14 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)