# drop table if exists mvncoreConfig;


create table if not exists mvncoreConfig
(
   ConfigKey                      VARCHAR(100)                   not null,
   ConfigValue                    VARCHAR(250)                   not null,
   ConfigCategory                 VARCHAR(250)                   not null,
   ConfigDesc                     TEXT                           not null,
   ConfigCreationDate             DATETIME                       not null,
   ConfigModifiedDate             DATETIME                       not null,
   ConfigType                     INT                            not null,
   ConfigOption                   INT                            not null,
   ConfigStatus                   INT                            not null,
   primary key (ConfigKey, ConfigCategory)
);