From: <vb...@us...> - 2002-09-08 22:06:46
|
Update of /cvsroot/webnotes/web In directory usw-pr-cvs1:/tmp/cvs-serv19246 Modified Files: database.php side_menu.php Log Message: - Added the database schema page. (links to sql/db_generate.sql) - Change the side_menu to disable the links to the pages which are not yet implemented. Index: database.php =================================================================== RCS file: /cvsroot/webnotes/web/database.php,v retrieving revision 1.3 retrieving revision 1.4 diff -u -d -r1.3 -r1.4 --- database.php 8 Sep 2002 06:12:53 -0000 1.3 +++ database.php 8 Sep 2002 22:06:43 -0000 1.4 @@ -1,9 +1,17 @@ <?php include('header.php') ?> +<?php + include('header.php'); + require_once('cvs_api.php'); +?> + <span class="page_title">Database Schema</span> <hr size="1" noshade="noshade" width="100%"> -<p>The database schema will be posted soon.</p> +<?php + cvs_echo_file( 'webnotes', 'webnotes', '/sql/db_generate.sql' ); + include('footer.php'); +?> <!-- This is a basic view of the database schema used in phpWebNotes. In my defense it was my first try at a decently sized project and the project has grown out of its original design. It should and will be re-normalized 'soon'. The schemas are a bit rough right now. I should add indicators for index, primary keys, 'foreign keys' (mysql doesn't support these, you have to fake them), unique fields, and relationships (1 to 1, 1 to many, etc). Index: side_menu.php =================================================================== RCS file: /cvsroot/webnotes/web/side_menu.php,v retrieving revision 1.6 retrieving revision 1.7 diff -u -d -r1.6 -r1.7 --- side_menu.php 8 Sep 2002 12:31:44 -0000 1.6 +++ side_menu.php 8 Sep 2002 22:06:43 -0000 1.7 @@ -9,17 +9,17 @@ <a class="big" href="index.php">Home</a><br /> <a class="big" href="demo.php">Demo</a><br /> <a class="big" href="tour.php">Admin Tour</a><br /> - <a class="big" href="about.php">About</a><br /> + About<br /> <a class="big" href="download.php">Download</a><br /> - <a class="big" href="screenshots.php">Screenshots</a><br /> - <a class="big" href="me.php">Author</a><br /> + Screenshots<br /> + Author<br /> <a class="big" href="credits.php">Credits</a><br /> - <a class="big" href="requirements.php">Requirements</a><br /> + Requirements<br /> <a class="big" href="release.php">Release Notes</a><br /> <a class="big" href="install.php">Installation</a><br /> - <a class="big" href="upgrading.php">Upgrading</a><br /> + Upgrading<br /> <a class="big" href="changelog.php">ChangeLog</a><br /> - <a class="big" href="links.php">Links</a><br /> + Links<br /> </td> </tr> <tr> @@ -29,7 +29,7 @@ </tr> <tr> <td class="menu_items"> - <a href="irc.php">IRC</a><br /> + IRC<br /> <a href="forums.php">Forums</a><br /> <a href="mailinglists.php">Mailing Lists</a><br /> </td> @@ -41,10 +41,7 @@ </tr> <tr> <td class="menu_items"> - <a href="general_development.php">General Information</a><br /> <a href="guidelines.php">Coding Guidelines</a><br /> - <a href="devnotes.php">Dev Notes</a><br /> - <a href="api.php">API</a><br /> <a href="cvs.php">CVS</a><br /> <a href="roadmap.php">Roadmap</a><br /> <a href="database.php">Database</a><br /> |