ALTER TABLE `displays` ADD `allorders` INT NOT NULL DEFAULT '0' AFTER `displayname`;

INSERT INTO `tabledefs` (`defid`, `tablename`, `settingname`, `actualfield`, `datatype`, `fielddescription`, `isid`, `showintable`, `editable`, `ordinality`, `sqlquery`, `relationshiptable`, `displaysql`, `defaultvalue`) VALUES (NULL, 'displays', 'Display All Items/Tickets?', 'allorders', 'dropdown', 'Display all items and orders regardless of designation?', '0', '1', '1', '50', 'select valueid as id, valuename as val from booleanddl order by valueid asc', '', 'select valueid as id, valuename as val from booleanddl where valueid=\'%id%\'', '');