summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
authormichael pereira2011-03-21 10:52:51 +0100
committermichael pereira2011-03-21 10:52:51 +0100
commit3a59301fdf10fcc0ecc3a56db18f3a36cc0c1aac (patch)
treed70593ed8261f466b41d21731421dfb6489d7dfa /pbs.sql
parentPreboot Controller eingerichtet (diff)
parentLogin in User Module (diff)
downloadpbs2-3a59301fdf10fcc0ecc3a56db18f3a36cc0c1aac.tar.gz
pbs2-3a59301fdf10fcc0ecc3a56db18f3a36cc0c1aac.tar.xz
pbs2-3a59301fdf10fcc0ecc3a56db18f3a36cc0c1aac.zip
zfproject
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/pbs.sql b/pbs.sql
index bfac5e0..bf8503b 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -329,7 +329,7 @@ CREATE TABLE IF NOT EXISTS `pbs_filterentries` (
`filtervalue` varchar(140) NOT NULL,
`filtervalue2` varchar(140) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-
+ALTER TABLE `pbs_filterentries` CHANGE `filtervalue2` `filtervalue2` VARCHAR( 140 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL;
ALTER TABLE `pbs_filterentries` ADD `filterentriesID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `pbs_filterentries`
ADD CONSTRAINT `pbs_filterentries_ibfk_1` FOREIGN KEY (`filterID`) REFERENCES `pbs_filter` (`filterID`) ON DELETE CASCADE,