USE tango;

-- >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

--                            Device DataBase 

-- >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
-- 

INSERT INTO device SET
 	name	= "archiving/tdb/tdbarchiver.01",
 	domain	= "archiving",
 	family	= "tdb",
 	member	= "tdbarchiver.01",
 	exported	= 0,
 	ior	= "tbd@rt",
 	host	= "tbd@rt",
 	server	= "TdbArchiver/01",
 	pid	= 0,
 	class 	= "TdbArchiver",
 	version	= 0,
 	started	= NULL,
 	stopped	= NULL;

INSERT INTO device SET
 	name	= "archiving/tdb/tdbextractor.01",
 	domain	= "archiving",
 	family	= "tdb",
 	member	= "tdbextractor.01",
 	exported	= 0,
 	ior	= "tbd@rt",
 	host	= "tbd@rt",
 	server	= "TdbExtractor/01",
 	pid	= 0,
 	class 	= "TdbExtractor",
 	version	= 0,
 	started	= NULL,
 	stopped	= NULL;

INSERT INTO device SET
 	name	= "archiving/tdb/tdbarchivingwatcher.01",
 	domain	= "archiving",
 	family	= "tdb",
 	member	= "tdbarchivingwatcher.01",
 	exported	= 0,
 	ior	= "tbd@rt",
 	host	= "tbd@rt",
 	server	= "HDBTDBArchivingWatcher/TDB",
 	pid	= 0,
 	class 	= "HDBTDBArchivingWatcher",
 	version	= 0,
 	started	= NULL,
 	stopped	= NULL;

INSERT INTO device SET
 	name	= "dserver/TdbArchiver/01",
 	domain	= "dserver",
 	family	= "TdbArchiver",
 	member	= "01",
 	exported	= 0,
 	ior	= "tbd@rt",
 	host	= "tbd@rt",
 	server	= "TdbArchiver/01",
 	pid	= 0,
 	class 	= "DServer",
 	version	= 0,
 	started	= NULL,
 	stopped	= NULL;


INSERT INTO device SET
 	name	= "dserver/TdbExtractor/01",
 	domain	= "dserver",
 	family	= "TdbExtractor",
 	member	= "01",
 	exported	= 0,
 	ior	= "tbd@rt",
 	host	= "tbd@rt",
 	server	= "TdbExtractor/01",
 	pid	= 0,
 	class 	= "DServer",
 	version	= 0,
 	started	= NULL,
 	stopped	= NULL;

-- >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

--                            Devices Properties 

-- >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
INSERT INTO property_device (device, name, count, value, updated, accessed, comment) VALUES
--	('archiving/tdb/tdbarchiver.01','DbUser','1','tdbarchiver',NULL,NULL,NULL),
--	('archiving/tdb/tdbarchiver.01','DbPassword','1','tdbarchiver',NULL,NULL,NULL),
	('archiving/tdb/tdbarchiver.01','HasThreadedStartup','1','true',NULL,NULL,NULL),
	('archiving/tdb/tdbarchiver.01','isDedicated','1','false',NULL,NULL,NULL),
	('archiving/tdb/tdbarchiver.01','reservedAttributes','1','',NULL,NULL,NULL),
	('archiving/tdb/tdbarchiver.01','hasDiary','1','true',NULL,NULL,NULL),
	('archiving/tdb/tdbarchiver.01','diaryLogLevel','1','DEBUG',NULL,NULL,NULL),
	('archiving/tdb/tdbarchiver.01','diaryPath','1','/var/archivage/tdb/01',NULL,NULL,NULL),
	('archiving/tdb/tdbarchiver.01','dsPath','1','/var/archivage/tdb/01',NULL,NULL,NULL),
	('archiving/tdb/tdbarchiver.01','dbPath','1','/var/archivage/tdb/01',NULL,NULL,NULL),

	('archiving/tdb/tdbextractor.01','DbUser','1','tdbbrowser',NULL,NULL,NULL),
	('archiving/tdb/tdbextractor.01','DbPassword','1','tdbbrowser',NULL,NULL,NULL),

	('archiving/tdb/tdbarchivingwatcher.01','archiverClass','1','TdbArchiver',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','checkLastValidDate','1','false',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','cyclePause','1','1200000',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','dbPwd','1','tdbmanager',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','dbUser','1','tdbmanager',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','doArchiverDiagnosis','1','true',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','doDiagnosis','1','true',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','doDiffReport','1','false',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','doRetry','1','true',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','exludeList','1',' ',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','GapDuration','1','900000',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','notificationContact','1',' ',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','notificationThreshold','1','340',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','onlyIncludeList','1',' ',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','periodicReport','1','7 days',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','realCheck','1','true',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','safetyPeriod','1','15 minutes',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','textTalkerLanguage','1','en',NULL,NULL,NULL),
	('archiving/tdb/tdbarchivingwatcher.01','unitaryPause','1','500',NULL,NULL,NULL);

-- >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

--                            Class Properties 

-- >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
INSERT INTO property_class (class, name, count, value, updated, accessed, comment) VALUES
	('TdbArchiver','Description','1','Device description',NULL,NULL,NULL),
	('TdbArchiver','ProjectTitle','1','Project description',NULL,NULL,NULL),
	('TdbArchiver','DbHost','1','localhost',NULL,NULL,NULL),
	('TdbArchiver','DbName','1','tdb',NULL,NULL,NULL),
	('TdbArchiver','DbSchema','1','tdb',NULL,NULL,NULL),
	('TdbArchiver','Facility','1','false',NULL,NULL,NULL),
	('TdbArchiver','DbUser','1','tdbbrowser',NULL,NULL,NULL),	-- À VÉRIFIER
	('TdbArchiver','DbPassword','1','tdbbrowser',NULL,NULL,NULL),	-- À VÉRIFIER
	('TdbArchiver','DbType','1','MySQL',NULL,NULL,NULL),	-- À VÉRIFIER
	('TdbArchiver','RetentionPeriod','1','days/3',NULL,NULL,NULL),	-- À VÉRIFIER

	('TdbExtractor','Description','1','Device description',NULL,NULL,NULL),	-- À VÉRIFIER
	('TdbExtractor','ProjectTitle','1','Project description',NULL,NULL,NULL);	-- À VÉRIFIER
