WCT Users (integrators)

Component : WCT_STATS Id : 016

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_STATS
# Object SQL : Installation script
# Object ID : 016
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_STATS
# --------------------------------------------------------
# Table structure for table 'wct016_stats'
#
DROP TABLE IF EXISTS `wct016_stats`;
CREATE TABLE `wct016_stats` (
  `stamp` timestamp(14) NOT NULL,
  `instance` tinyint(4) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `host` varchar(80) NOT NULL default '',
  `referer` varchar(80) NOT NULL default '',
  `useragent` varchar(40) NOT NULL default '',
  `domain` varchar(10) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `keywords` varchar(80) default NULL,
  `sessionId` bigint(20) default NULL,
  `lap` time default NULL,
  PRIMARY KEY  (`stamp`),
  KEY `domain` (`domain`),
  KEY `keywords` (`keywords`),
  KEY `sessionId` (`sessionId`),
  KEY `instance` (`instance`)
) TYPE=MyISAM;

Script for database model deletion

# Web Component DB Storage Model
# Object Name : WCT_STATS
# Object SQL : Uninstallation script
# Object ID : 016
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_STATS
# --------------------------------------------------------
DROP TABLE IF EXISTS wct016_stats;

Script for database model cleanup

# Web Component DB Storage Model
# Object Name : WCT_STATS
# Object SQL : Instance cleanup script
# Object ID : 016
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_STATS
# --------------------------------------------------------
DELETE FROM wct016_stats WHERE instance = <%%WCT_STATS::ID%%>;