#
# Table structure for table `installedmodules`
#
DROP TABLE IF EXISTS  copixmodule;
CREATE TABLE copixmodule (
  name_cpm varchar(255) NOT NULL default '',
  path_cpm varchar(255) NOT NULL default '',  
  PRIMARY KEY  (name_cpm)
) CHARACTER SET utf8;

DROP TABLE IF EXISTS `copixconfig`;
CREATE TABLE `copixconfig` (
  `id_ccfg` varchar(255) NOT NULL default '',
  `module_ccfg` varchar(255) NOT NULL default '',
  `value_ccfg` varchar(255) default NULL,
  PRIMARY KEY  (`id_ccfg`)
) CHARACTER SET utf8;


DROP TABLE IF EXISTS `copixlog`;
CREATE TABLE `copixlog` (
  `date` varchar(255) NOT NULL default '',
  `profile` varchar(255) NOT NULL default '',
  `message` text NOT NULL default '',
  `level` varchar(255) NOT NULL default '',
  `user` varchar(255) default NULL,
  `classname` varchar(255) default NULL,
  `functionname` varchar(255) default NULL,
  `line` varchar(5) default NULL,
  `file` varchar(255) default NULL,
  `type` varchar(50) default NULL  
) CHARACTER SET utf8;