aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--install/config.sql3
-rw-r--r--install/db/41-database.php8
2 files changed, 6 insertions, 5 deletions
diff --git a/install/config.sql b/install/config.sql
index 150acb124..53753a8d4 100644
--- a/install/config.sql
+++ b/install/config.sql
@@ -29,4 +29,5 @@ INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('nbm_send_detaile
INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('nbm_complementary_mail_content','','Complementary mail content for notification by mail');
INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('email_admin_on_new_user','false','Send an email to the admin when a user registers');
INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('email_admin_on_comment','false','Send an email to the admin when a valid comment is entered');
-INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('email_admin_on_comment_validation','false','Send an email to the admin when a comment requires validation'); \ No newline at end of file
+INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('email_admin_on_comment_validation','false','Send an email to the admin when a comment requires validation');
+INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('ws_status','true','Web Service is active/inactive');
diff --git a/install/db/41-database.php b/install/db/41-database.php
index 3ed27424e..42d0bae12 100644
--- a/install/db/41-database.php
+++ b/install/db/41-database.php
@@ -40,20 +40,20 @@ include_once(PHPWG_ROOT_PATH.'include/constants.php');
echo "Create table ".WEB_SERVICES_ACCESS_TABLE;
$query = '
-CREATE TABLE '.WEB_SERVICES_ACCESS_TABLE.' (
+CREATE TABLE '.WEB_SERVICES_ACCESS_TABLE." (
id smallint(5) unsigned NOT NULL auto_increment,
name varchar(32) NOT NULL default '',
access varchar(255) default NULL,
`start` datetime default NULL,
`end` datetime default NULL,
request varchar(255) default NULL,
- high enum(\'true\',\'false\') NOT NULL default \'true\',
- normal enum(\'true\',\'false\') NOT NULL default \'true\',
+ high enum('true','false') NOT NULL default 'true',
+ normal enum('true','false') NOT NULL default 'true',
`limit` smallint(5) unsigned default NULL,
`comment` varchar(255) default NULL,
PRIMARY KEY (id),
UNIQUE KEY name (name)
-) ENGINE=MyISAM COMMENT=\'Access for Web Services\';';
+) ENGINE=MyISAM COMMENT='Access for Web Services';";
pwg_query($query);
echo