cvs: php-testfest-web / Solar.config.php /db schema.sql /jail testfest

goldoraf Tue Apr 15 12:45:17 2008 UTC Added files: /php-testfest-web/db schema.sql Removed files: /php-testfest-web/jail testfest Modified files: /php-testfest-web Solar.config.php Log: - Removed SQLite db file. - Added /db dir and preliminary db schema dump. - Modified Solar config for use of MySQL. - Fixed default page (no more 'Hello world' home page) http://cvs.php.net/viewvc.cgi/php-testfest-web/Solar.config.php?r1=1.3&r2=1.4&diff_format=u Index: php-testfest-web/Solar.config.php diff -u php-testfest-web/Solar.config.php:1.3 php-testfest-web/Solar.config.php:1.4 --- php-testfest-web/Solar.config.php:1.3 Sun Apr 13 14:32:14 2008 +++ php-testfest-web/Solar.config.php Tue Apr 15 12:45:17 2008 @@ -10,20 +10,26 @@ // Base public directory href $config['Solar_Uri_Public']['path'] = "$URIBASE/public"; -$config['Solar_Sql_Adapter_Sqlite'] = array( - 'name' => "$safedir/testfest" +// DB config +$config['Solar_Sql'] = array( + 'adapter' => 'Solar_Sql_Adapter_Mysql', + 'host' => '127.0.0.1', + 'user' => 'testfest', + 'pass' => 'php', + 'name' => 'testfest', ); +// Auth config $config['Solar_Auth']['adapter'] = 'Solar_Auth_Adapter_Sql'; -$config['Solar_Auth_Adapter_Sql']['table'] = 'auth'; - -$config['Solar_Auth_Adapter_Sql']['handle_col'] = 'handle'; +$config['Solar_Auth_Adapter_Sql']['table'] = 'contributors'; +$config['Solar_Auth_Adapter_Sql']['uid_col'] = 'id'; +$config['Solar_Auth_Adapter_Sql']['handle_col'] = 'username'; $config['Solar_Auth_Adapter_Sql']['passwd_col'] = 'password'; $config['Solar_Auth_Adapter_Sql']['salt'] = 'testtt'; -$config['Solar_Controller_Front']['classes'] = array( - 'PHP_App', -); +// Front controller config +$config['Solar_Controller_Front']['classes'] = array('PHP_App'); +$config['Solar_Controller_Front']['default'] = 'index'; // Done! return $config; http://cvs.php.net/viewvc.cgi/php-testfest-web/db/schema.sql?view=markup&rev=1.1 Index: php-testfest-web/db/schema.sql +++ php-testfest-web/db/schema.sql CREATE TABLE contributors ( id int(10) unsigned NOT NULL auto_increment, username varchar(15) NOT NULL, password varchar(32) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE testfiles ( id int(10) unsigned NOT NULL auto_increment, filename varchar(100) NOT NULL, description tinytext NOT NULL, status enum('Uploaded','Confirmed','In Review','Accepted','Refused') NOT NULL, uploaded_on timestamp NOT NULL default CURRENT_TIMESTAMP, refusal_reason tinytext, PRIMARY KEY (id), KEY filename (filename), KEY status (status) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;