as it is now:
CREATE TABLE ocp_tools_config (
id integer Primary KEY DEFAULT nextval('ocp_tools_config_id_seq'),
module text NOT NULL UNIQUE,
param text NOT NULL UNIQUE,
value text DEFAULT NULL,
box_id text DEFAULT '' UNIQUE
);
will not allow the insertion of more than one row per module, or per param
in mysql, is the combination of module, param and box_id that must be unique
CREATE TABLE `ocp_tools_config` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`module` varchar(64) NOT NULL,
`param` varchar(64) NOT NULL,
`value` blob DEFAULT NULL,
`box_id` varchar(15) DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `box_key` (`module`,`param`,`box_id`)
);
as it is now:
CREATE TABLE ocp_tools_config ( id integer Primary KEY DEFAULT nextval('ocp_tools_config_id_seq'), module text NOT NULL UNIQUE, param text NOT NULL UNIQUE, value text DEFAULT NULL, box_id text DEFAULT '' UNIQUE );will not allow the insertion of more than one row per module, or per param
in mysql, is the combination of module, param and box_id that must be unique