From 4da9eb8bd486adb46db9a24d4b616c63efc733ab Mon Sep 17 00:00:00 2001 From: Karl 'vollmerk' Vollmer Date: Sat, 30 Sep 2006 21:24:10 +0000 Subject: default acl to interface --- lib/class/update.class.php | 2 +- sql/ampache.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/class/update.class.php b/lib/class/update.class.php index fc13ef44..6ff598a1 100644 --- a/lib/class/update.class.php +++ b/lib/class/update.class.php @@ -1664,7 +1664,7 @@ class Update { $sql = "ALTER TABLE `access_list` ADD INDEX `level` (`level`)"; $db_results = mysql_query($sql, dbh()); - $sql = "ALTER TABLE `access_list` ADD `type` VARCHAR( 64 ) NOT NULL AFTER `level`"; + $Sql = "ALTER TABLE `access_list` ADD `type` VARCHAR( 64 ) NOT NULL DEFAULT 'interface' AFTER `level`"; $db_results = mysql_query($sql, dbh()); // Album Table diff --git a/sql/ampache.sql b/sql/ampache.sql index a04ab7cd..d70a45c7 100755 --- a/sql/ampache.sql +++ b/sql/ampache.sql @@ -19,7 +19,7 @@ CREATE TABLE `access_list` ( `start` int(11) unsigned NOT NULL default '0', `end` int(11) unsigned NOT NULL default '0', `level` smallint(3) unsigned NOT NULL default '5', - `type` varchar(64) NOT NULL default '', + `type` varchar(64) NOT NULL default 'interface', `user` varchar(128) default NULL, `key` varchar(255) default NULL, PRIMARY KEY (`id`), -- cgit