WCT Users (integrators)
Component : WCT_METRICS
Id : 019
|
|
Database Model
Script for database model creation
# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_METRICS
# Object SQL : Installation script
# Object ID : 019
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_METRICS
# --------------------------------------------------------
# Table structure for table 'wct019_metrics'
#
DROP TABLE IF EXISTS `wct019_metrics`;
CREATE TABLE `wct019_metrics` (
`instance` tinyint(4) NOT NULL default '0',
`metric` varchar(40) NOT NULL default '',
`value` int(11) NOT NULL default '0',
`floatvalue` float NOT NULL default '0',
`calculation` timestamp(14) NOT NULL,
PRIMARY KEY (`instance`,`metric`)
) TYPE=MyISAM;
Script for database model deletion
# Web Component DB Storage Model
# Object Name : WCT_METRICS
# Object SQL : Uninstallation script
# Object ID : 019
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_METRICS
# --------------------------------------------------------
DROP TABLE IF EXISTS wct019_metrics;
Script for database model cleanup
# Web Component DB Storage Model
# Object Name : WCT_METRICS
# Object SQL : Instance cleanup script
# Object ID : 019
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_METRICS
# --------------------------------------------------------
DELETE FROM wct019_metrics WHERE instance = <%%WCT_METRICS::ID%%>;
All material is copyleft V.G. FREMAUX (EISTI France) 1999 to 2003 except explicitly mentioned
|