WCT Users (integrators)

Component : WCT_SECURITY Id : 001

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_SECURITY
# Object SQL : Installation script
# Object ID : 001
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_SECURITY
# --------------------------------------------------------
# Table structure for table 'wct001_authentication'
#
DROP TABLE IF EXISTS `wct001_authentication`;
CREATE TABLE `wct001_authentication` (
  `Id` smallint(6) NOT NULL auto_increment,
  `login` varchar(16) NOT NULL default '',
  `password` varchar(16) NOT NULL default '',
  `domain` varchar(40) NOT NULL default '',
  `instance` smallint(6) NOT NULL default '0',
  `active` enum('yes','no') NOT NULL default 'yes',
  PRIMARY KEY  (`login`,`domain`,`instance`),
  KEY `Id` (`Id`),
  KEY `instance` (`instance`)
) TYPE=MyISAM;
#
# Table structure for table `wct001_domains`
#
DROP TABLE IF EXISTS `wct001_domains`;
CREATE TABLE `wct001_domains` (
  `domain` varchar(32) NOT NULL default '',
  `instance` tinyint(4) NOT NULL default '0',
  `description` varchar(255) NOT NULL default '',
  `superDomains` varchar(255) default NULL,
  `active` enum('yes','no') NOT NULL default 'yes',
  PRIMARY KEY  (`domain`,`instance`),
  KEY `instance` (`instance`)
) TYPE=MyISAM;
#
# Table structure for table `wct001_userdomains`
#
DROP TABLE IF EXISTS `wct001_userdomains`;
CREATE TABLE `wct001_userdomains` (
  `login` varchar(16) NOT NULL default '',
  `domain` varchar(32) NOT NULL default '',
  `instance` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`login`,`domain`,`instance`),
  KEY `instance` (`instance`)
) TYPE=MyISAM;

Script for database model deletion

# Web Component DB Storage Model
# Object Name : WCT_SECURITY
# Object SQL : Uninstallation script
# Object ID : 001
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_SECURITY
# --------------------------------------------------------
DROP TABLE IF EXISTS wct001_authentication;
DROP TABLE IF EXISTS wct001_domains;
DROP TABLE IF EXISTS wct001_userdomains;

Script for database model cleanup

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