<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<link rel=File-List href="cid:filelist.xml@01C0D69E.E32D0850">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>110</w:Zoom>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
span.EmailStyle17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:windowtext;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I am giving this neat PHP program a try, it uses a <span
class=SpellE>MySql</span> backend….I am not familiar with <span
class=SpellE>mysql</span>, but with instructions I’ve been able to build
the databases for most apps that require it….the following instructions
are rather weird, I was wondering if anyone could make better sense out of
them, its copied right from the INSTALL file.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><span class=GramE><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>first</span></font></span><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> create the
database:<br>
<span class=SpellE><span class=GramE>mysqladmin</span></span> -u
<root-user> -p create database <your-database></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><span class=GramE><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>then</span></font></span><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>:<br>
<span class=GramE>( <span class=SpellE>mysql</span></span> -u <root-user>
-p )<br>
--<br>
<span class=GramE>database</span>->table user:<br>
<span class=GramE>add</span>: <span class=SpellE>localhost</span>,
<www-search>, password<br>
<span class=GramE>and</span> <span class=SpellE>localhost</span>,
<www-admin>, password<br>
<span class=GramE>with</span> all privileges to 'N'</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><span class=GramE><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>and</span></font></span><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><br>
--<br>
<span class=GramE>database</span>->table db:<br>
<span class=GramE>add</span>: <span class=SpellE>localhost</span>,
<your-database>, <www-admin>, Y,Y,Y,Y<br>
and<span class=GramE> <span class=SpellE>localhost</span></span>,
<your-database>, <www-search>, Y,Y</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><www-search>, <www-admin> and
<your-database> can be <span class=SpellE>choosen</span> by you. You<br>
<span class=GramE>have</span> to set the same values (and password) in the <span
class=SpellE>pt_config.inc</span> file in the<br>
<span class=GramE>admin</span> section!</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>An example run: </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><span class=GramE><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>insert</span></font></span><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> into user (<span
class=SpellE>Host,User,Password</span>)<br>
<span class=GramE>values(</span>'<span class=SpellE>localhost','www-search',password</span>('mySecret1');<br>
<span class=GramE>insert</span> into user (<span class=SpellE>Host,User,Password</span>)<br>
<span class=GramE>values(</span>'<span class=SpellE>localhost','www-admin',password</span>('<span
class=SpellE>myTopSecret</span>');</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><span class=GramE><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>and</span></font></span><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><span class=GramE><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>insert</span></font></span><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> into db (<span
class=SpellE>Host,Db,User,Select_priv</span>)<br>
<span class=GramE>values(</span>'<span class=SpellE>localhost','your-database','www-search','Y</span>');<br>
<span class=GramE>insert</span> into db (<span class=SpellE>Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv</span>)<br>
values('<span class=SpellE>localhost','your-database','www-admin','Y','Y','Y','Y</span>');<br>
<br>
-> <span class=GramE>flush</span> privileges; !!!</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Now create the tables, and insert the sample data. You find
them in<br>
<span class=SpellE>myphpPagetool/doc/tables-mysql.sql</span> and data-<span
class=SpellE>mysql.sql</span></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><span class=GramE><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>example</span></font></span><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>:<br>
> <span class=SpellE><span class=GramE>mysql</span></span> -u
<root-user> -p your-database < tables-<span class=SpellE>mysql.sql</span><br>
> <span class=SpellE><span class=GramE>mysql</span></span> -u
<root-user> -p your-database < data-<span class=SpellE>mysql.sql</span></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>