ESSI_Resource : File /home/groups/d/di/diml/htdocs/wct/proto/WCT_SESSION/index_.dim not found at line in
My site System Board WCT Generals Documentation User support
[ french ]
Table des matières
Component index
Data Model Templates
>> Top of page

WCT Users (integrators)

Component : WCT_SESSION
Id : 002

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_SESSION
# Object SQL : Uninstallation script
# Object ID : 002
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_SESSION/
# --------------------------------------------------------
# Table structure for table 'wct002_session'
#
DROP TABLE IF EXISTS `wct002_session`;
CREATE TABLE `wct002_session` (
  `id` int(10) NOT NULL auto_increment,
  `instance` smallint(6) NOT NULL default '0',
  `authentication` text,
  `creationTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastAccess` timestamp(14) NOT NULL,
  `sessionData` text,
  `ip` varchar(15) default NULL,
  `host` varchar(80) default NULL,
  `userAgent` varchar(255) default NULL,
  `sessionStart` varchar(80) default NULL,
  `lastAccessed` varchar(80) default NULL,
  `hit` int(10) NOT NULL default '0',
  `startReferer` varchar(80) default NULL,
  `isIdle` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `instance` (`instance`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `wct002_session_saves`;
CREATE TABLE `wct002_session_saves` (
  `id` int(10) NOT NULL auto_increment,
  `instance` smallint(6) NOT NULL default '0',
  `authentication` text,
  `creationTime` date NOT NULL default '0000-00-00',
  `lastAccess` timestamp(14) NOT NULL,
  `sessionData` text,
  `ip` varchar(15) default NULL,
  `host` varchar(80) default NULL,
  `userAgent` varchar(255) default NULL,
  `sessionStart` varchar(80) default NULL,
  `lastAccessed` varchar(80) default NULL,
  `hit` int(10) NOT NULL default '0',
  `startReferer` varchar(80) default NULL,
  `isIdle` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  KEY `instance` (`instance`)
) TYPE=MyISAM;

Script for database model deletion

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

Script for database model cleanup

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

All material is copyleft V.G. FREMAUX (EISTI France) 1999 to 2003 except explicitly mentioned