"Fossies" - the Fresh Open Source Software Archive

Member "sqlupdate-1.6.6/progdesc.php" (25 Feb 2012, 2281 Bytes) of package /linux/privat/old/sqlupdate-1.6.6.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PHP source code syntax highlighting (style: standard) with prefixed line numbers and code folding option. Alternatively you can here view or download the uninterpreted source code file.

    1 <?php
    2 //TITLE=MySQL table patcher
    3 
    4 $title = 'MySQL table patcher';
    5 $progname = 'sqlupdate';
    6 
    7 function usagetext($prog)
    8 {
    9   exec($prog.' --help', $kk);
   10   $k='';foreach($kk as $s)$k.="$s\n";
   11   return $k;
   12 }
   13 
   14 $text = array(
   15    '1. Purpose' => "
   16 
   17  Reads a table creation file (tables.sql) and compares
   18  it to what mysqldump gives, and creates SQL clauses
   19  to update the database to match the creation file.
   20 <pre class=smallerpre>".htmlspecialchars(usagetext('sqlupdate'))."</pre>
   21 
   22 ", '1. Changes' => "
   23 
   24  Since version 1.3.0, supports also the InnoDB <code>FOREIGN KEY</code> constraints.
   25 <p>
   26  Since version 1.4.0, supports <code>TINYINT</code>, <code>DATE</code>, <code>TIME</code> and <code>ENUM</code> types.<br>
   27  Thanks to Leigh Purdie for this change!
   28 <p>
   29  Version 1.4.1 adds support for <code>CREATE INDEX</code> and field ordering.
   30 <p>
   31  Since version 1.5.0, supports <code>LONGTEXT</code>, <code>MEDIUMTEXT</code>
   32  and <code>MEDIUMBLOB</code>. Also now longer forces <code>DEFAULT</code> for
   33  <code>AUTOINCREMENT</code> columns.<br>
   34  Thanks to Frederic Lamsens for this change!
   35 <p>
   36  In version 1.6.0, a crude support for <code>CHARSET</code> and <code>COLLATE</code>
   37  was added.
   38 <p>
   39  In version 1.6.1, support for <code>GEOMETRY</code> and <code>SPATIAL</code>
   40  indexes was added.
   41 <p>
   42  Version 1.6.2: Added -c option (ignore character set differences).
   43 <p>
   44  In version 1.6.3, support for more spatial datatypes was added.
   45 <p>
   46  In version 1.6.4, a bug in the support of <code>ENUM</code> was fixed.
   47  Thanks to Martin Vít for this change!
   48 <p>
   49  In version 1.6.5, support was added for different index types in <code>PRIMARY KEY</code>.
   50 <p>
   51  In version 1.6.6, support was added for <code>BIT</code>, <code>COMMENT</code>, <code>SET</code>,
   52          <code>TINYTEXT</code> and <code>CURRENT_TIMESTAMP</code>.
   53  Thanks to Markus Ebeling for this change!
   54 
   55 ", '1. Copying' => "
   56 
   57 sqlupdate has been written by Joel Yliluoma, a.k.a.
   58 <a href=\"http://iki.fi/bisqwit/\">Bisqwit</a>,<br>
   59 and is distributed under the terms of the
   60 <a href=\"http://www.gnu.org/licenses/licenses.html#GPL\">General Public License</a> (GPL).
   61 
   62 ", '1. Requirements' => "
   63 
   64 GNU make is probably required.<br>
   65 mysqldump is also required. This program handles only MySQL tables indeed.
   66 
   67 ");
   68 include '/WWW/progdesc.php';