Skip to content

pgsql schema for table ocp_tools_config is wrong #310

Description

@gmaruzz

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`)
);


Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions