CREATE TABLE `SERVICE` (
  `ID_INTERNAL` int(11) NOT NULL auto_increment,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) NOT NULL default '1',
  `NAME` VARCHAR(255) default NULL,
  `TYPE` VARCHAR(255) default NULL,
  `CREATION_ENTITY` text,
  `CREATION_ENTITY_DATE` date default NULL,
  `UPDATE_ENTITY` text,
  `UPDATE_ENTITY_DATE` datetime default NULL,
  PRIMARY KEY  (`ID_INTERNAL`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO 
	SERVICE (
	KEY_ROOT_DOMAIN_OBJECT, 
	NAME,
	TYPE, 
	CREATION_ENTITY, 
	CREATION_ENTITY_DATE) 
	VALUE (
	1,
	'Active Directory',
	'DC1',
	'SQL_SCRIPT',
	NOW());

INSERT INTO 
	SERVICE (
	KEY_ROOT_DOMAIN_OBJECT, 
	NAME,
	TYPE, 
	CREATION_ENTITY, 
	CREATION_ENTITY_DATE) 
	VALUE (
	1,
	'Active Directory',
	'HORUS',
	'SQL_SCRIPT',
	NOW());

INSERT INTO 
	SERVICE (
	KEY_ROOT_DOMAIN_OBJECT, 
	NAME,
	TYPE, 
	CREATION_ENTITY, 
	CREATION_ENTITY_DATE) 
	VALUE (
	1,
	'Active Directory',
	'ISCTENT',
	'SQL_SCRIPT',
	NOW());

INSERT INTO 
	SERVICE (
	KEY_ROOT_DOMAIN_OBJECT, 
	NAME,
	TYPE, 
	CREATION_ENTITY, 
	CREATION_ENTITY_DATE) 
	VALUE (
	1,
	'Email',
	'NEFTIS',
	'SQL_SCRIPT',
	NOW());

INSERT INTO 
	SERVICE (
	KEY_ROOT_DOMAIN_OBJECT, 
	NAME,
	TYPE, 
	CREATION_ENTITY, 
	CREATION_ENTITY_DATE) 
	VALUE (
	1,
	'E-learning',
	'BLACKBOARD',
	'SQL_SCRIPT',
	NOW());
