Index: include/pear-database.php =================================================================== RCS file: /repository/pearweb/include/pear-database.php,v retrieving revision 1.121 diff -u -r1.121 pear-database.php --- include/pear-database.php 15 Apr 2003 19:03:27 -0000 1.121 +++ include/pear-database.php 8 May 2003 12:25:51 -0000 @@ -291,6 +291,9 @@ if (empty($name)) { return PEAR::raiseError("package::add: invalid `name' field"); } + if (empty($homepage)) { + $homepage = ""; + } $query = "INSERT INTO packages (id,name,category,license,summary,description,homepage) VALUES(?,?,?,?,?,?,?)"; $id = $dbh->nextId("packages"); $err = $dbh->query($query, array($id, $name, $category, $license, $summary, $description, $homepage)); Index: sql/Makefile =================================================================== RCS file: /repository/pearweb/sql/Makefile,v retrieving revision 1.22 diff -u -r1.22 Makefile --- sql/Makefile 11 Feb 2003 00:33:22 -0000 1.22 +++ sql/Makefile 8 May 2003 12:25:51 -0000 @@ -33,7 +33,7 @@ deps.sql \ notes.sql \ users.sql \ - state_order.sql +# state_order.sql SQL_TYPE=mysql SQL_USER=pear SQL_PW=pear Index: sql/createdb.sql =================================================================== RCS file: /repository/pearweb/sql/createdb.sql,v retrieving revision 1.3 diff -u -r1.3 createdb.sql --- sql/createdb.sql 14 Aug 2001 09:27:39 -0000 1.3 +++ sql/createdb.sql 8 May 2003 12:25:52 -0000 @@ -1,8 +1,8 @@ CREATE DATABASE pear; -INSERT INTO user VALUES('pb1','pear',password('pear'),'N','N','N','N','N','N','N','N','N','N','N','N','N','N'); -INSERT INTO user VALUES('localhost','pear',password('pear'),'N','N','N','N','N','N','N','N','N','N','N','N','N','N'); -INSERT INTO db VALUES('%','pear','pear','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); +INSERT INTO user (host,user,password,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv,reload_priv,shutdown_priv,process_priv,file_priv,grant_priv,references_priv,index_priv,alter_priv) VALUES('pb1','pear',password('pear'),'N','N','N','N','N','N','N','N','N','N','N','N','N','N'); +INSERT INTO user (host,user,password,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv,reload_priv,shutdown_priv,process_priv,file_priv,grant_priv,references_priv,index_priv,alter_priv) VALUES('localhost','pear',password('pear'),'N','N','N','N','N','N','N','N','N','N','N','N','N','N'); +INSERT INTO db (host,db,user,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv,grant_priv,references_priv,index_priv,alter_priv) VALUES('%','pear','pear','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); FLUSH PRIVILEGES; Index: sql/users.sql =================================================================== RCS file: /repository/pearweb/sql/users.sql,v retrieving revision 1.8 diff -u -r1.8 users.sql --- sql/users.sql 30 Mar 2003 09:44:41 -0000 1.8 +++ sql/users.sql 8 May 2003 12:25:52 -0000 @@ -1,7 +1,7 @@ CREATE TABLE users ( handle VARCHAR(20) NOT NULL, password VARCHAR(64), - ppp_only TINYINT(4) NOT NULL default '0' + ppp_only TINYINT(4) NOT NULL default '0', name VARCHAR(100), email VARCHAR(100), homepage VARCHAR(255),