-- 
-- JClic reports test data
-- 
-- Base de dades: `jclicreports`
-- 
USE JClicReports;

-- --------------------------------------------------------

-- 
-- Estructura de la taula `JCLIC_GROUPS`
-- 

CREATE TABLE IF NOT EXISTS `JCLIC_GROUPS` (
  `GROUP_ID` varchar(50) NOT NULL default '',
  `GROUP_NAME` varchar(80) NOT NULL default '',
  `GROUP_DESCRIPTION` varchar(255) default NULL,
  `GROUP_ICON` varchar(255) default NULL,
  `GROUP_CODE` varchar(50) default NULL,
  `GROUP_KEYWORDS` varchar(255) default NULL,
  PRIMARY KEY  (`GROUP_ID`)
) ENGINE=MyISAM;

-- 
-- Volcant dades de la taula `JCLIC_GROUPS`
-- 

INSERT INTO `JCLIC_GROUPS` VALUES ('test', 'Test', NULL, NULL, NULL, NULL);
