[Webnotes-cvs] webnotes/sql db_generate.sql,1.3,1.4 db_upgrade.sql,1.7,1.8

[<vb...@us...>]

Update of /cvsroot/webnotes/webnotes/sql
In directory usw-pr-cvs1:/tmp/cvs-serv15062/sql

Modified Files:
	db_generate.sql db_upgrade.sql 
Log Message:
- Fixed a parsing error in e-mail api.
- Fixed an undefined variable when using the action.php upon indexing/un-indexing a page.
- Fixed a problem with the timestamp in the preview page.
- Removed the Manage Pages from the menu.
- Updated the Change Log.
- Updated the Install document.
- Updated db_generate.sql / db_upgrade.sql.
- Changed the default password encryption to be MD5.

Index: db_generate.sql
===================================================================
RCS file: /cvsroot/webnotes/webnotes/sql/db_generate.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- db_generate.sql	30 Sep 2002 01:40:19 -0000	1.3
+++ db_generate.sql	6 Oct 2002 15:23:36 -0000	1.4
@@ -1,54 +1,68 @@
 # phpMyAdmin MySQL-Dump
+# version 2.3.0
 # http://phpwizard.net/phpMyAdmin/
+# http://www.phpmyadmin.net/ (download page)
 #
+# Host: localhost
+# Generation Time: Oct 07, 2002 at 12:58 AM
+# Server version: 3.23.49
+# PHP Version: 4.0.6
+# Database : `phpWebNotes`
+# --------------------------------------------------------
 
 #
-# Table structure for table 'phpWN_note_table'
+# Table structure for table `phpWN_note_table`
 #
 
 CREATE TABLE phpWN_note_table (
-   id int(10) unsigned zerofill DEFAULT '0000000000' NOT NULL auto_increment,
-   page_id int(10) unsigned zerofill DEFAULT '0000000000' NOT NULL,
-   email varchar(128) NOT NULL,
-   ip varchar(15) NOT NULL,
-   date_submitted datetime,
-   visible int(1) DEFAULT '0' NOT NULL,
-   note text NOT NULL,
-   PRIMARY KEY (id),
-   KEY id (id),
-   KEY visible (visible)
-);
+  id int(10) unsigned zerofill NOT NULL auto_increment,
+  page_id int(10) unsigned zerofill NOT NULL default '0000000000',
+  email varchar(128) NOT NULL default '',
+  ip varchar(15) NOT NULL default '',
+  date_submitted datetime default NULL,
+  visible int(1) NOT NULL default '0',
+  note text NOT NULL,
+  PRIMARY KEY  (id),
+  KEY visible (visible)
+) TYPE=MyISAM;
+# --------------------------------------------------------
 
 #
-# Table structure for table 'phpWN_page_table'
+# Table structure for table `phpWN_page_table`
 #
 
 CREATE TABLE phpWN_page_table (
-   id int(10) unsigned zerofill DEFAULT '0000000000' NOT NULL auto_increment,
-   date_indexed datetime,
-   page varchar(255) NOT NULL,
-   PRIMARY KEY (id),
-   KEY id (id),
-   UNIQUE page (page)
-);
+  id int(10) unsigned zerofill NOT NULL auto_increment,
+  date_indexed datetime default NULL,
+  last_updated datetime NOT NULL default '0000-00-00 00:00:00',
+  page varchar(255) NOT NULL default '',
+  url varchar(255) NOT NULL default '',
+  parent_id int(10) unsigned zerofill NOT NULL default '0000000000',
+  prev_id int(10) unsigned zerofill NOT NULL default '0000000000',
+  next_id int(10) unsigned zerofill NOT NULL default '0000000000',
+  PRIMARY KEY  (id),
+  UNIQUE KEY page (page),
+  KEY parent_id (parent_id)
+) TYPE=MyISAM;
+# --------------------------------------------------------
 
 #
-# Table structure for table 'phpWN_user_table'
+# Table structure for table `phpWN_user_table`
 #
 
 CREATE TABLE phpWN_user_table (
-   id int(10) unsigned zerofill DEFAULT '0000000000' NOT NULL auto_increment,
-   username varchar(32) NOT NULL,
-   password varchar(16) NOT NULL,
-   email varchar(64) NOT NULL,
-   access_level int(1) DEFAULT '0' NOT NULL,
-   enabled int(1) DEFAULT '0' NOT NULL,
-   cookie_string varchar(32) NOT NULL,
-   PRIMARY KEY (id)
-);
+  id int(10) unsigned zerofill NOT NULL auto_increment,
+  username varchar(32) NOT NULL default '',
+  password varchar(32) NOT NULL default '',
+  email varchar(64) NOT NULL default '',
+  access_level int(2) NOT NULL default '40',
+  enabled int(1) NOT NULL default '0',
+  cookie_string varchar(32) NOT NULL default '',
+  PRIMARY KEY  (id)
+) TYPE=MyISAM;
 
 #
 # Dumping data for table 'phpWN_user_table'
 #
 
-INSERT INTO phpWN_user_table VALUES ( '0000000001', 'administrator', 'Wy1r49AOWOdCI', '', '90', '1', '9eCxeTLdGjDpI149f9aca9f0ba076ce2');
\ No newline at end of file
+INSERT INTO phpWN_user_table VALUES ( '0000000001', 'administrator', '63a9f0ea7bb98050796b649e85481845', '', '90', '1', '9eCxeTLdGjDpI149f9aca9f0ba076ce2');

Index: db_upgrade.sql
===================================================================
RCS file: /cvsroot/webnotes/webnotes/sql/db_upgrade.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- db_upgrade.sql	1 Oct 2002 06:51:45 -0000	1.7
+++ db_upgrade.sql	6 Oct 2002 15:23:36 -0000	1.8
@@ -1,3 +1,6 @@
+#
+# Upgrade phpWebNotes 1.0.0 to phpWebNotes 2.0.0pr1
+#
 ALTER TABLE `phpWN_user_table` CHANGE `password` `password` VARCHAR( 32 ) NOT NULL;
 ALTER TABLE `phpWN_user_table` CHANGE `access_level` `access_level` INT( 2 ) DEFAULT '40' NOT NULL;
 ALTER TABLE `phpWN_page_table` ADD `url` VARCHAR( 255 ) NOT NULL ;