WCT Users (integrators)

Component : WCT_REPOSITORY Id : 006

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_REPOSITORY
# Object SQL : Installation script
# Object ID : 006
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_REPOSITORY/
# --------------------------------------------------------
# Table structure for table 'wct006_objects'
#
DROP TABLE IF EXISTS wct006_objects;
CREATE TABLE wct006_objects (
   instance     smallint(6) DEFAULT '0' NOT NULL,
   fullname     varchar(255) NOT NULL,
   hierarchy    varchar(255),
   language     varchar(4),
   keywords     varchar(255),
   abstract     text,
   lastModified datetime,
   PRIMARY KEY (fullname),
   KEY instance (instance)
);
DROP TABLE IF EXISTS wct006_properties;
CREATE TABLE wct006_properties (
   Id       int(10) DEFAULT'0' AUTO_INCREMENT,
   instance smallint(6) DEFAULT '0' NOT NULL,
   object   varchar(255) NOT NULL,
   name     varchar(255),
   value    varchar(255),
   PRIMARY KEY (Id),
   KEY instance (instance)
);
DROP TABLE IF EXISTS wct006_pastedobjects;
CREATE TABLE wct006_pastedobjects (
   instance     smallint(6) DEFAULT '0' NOT NULL,
   fullname     varchar(255) NOT NULL,
   hierarchy    varchar(255),
   language     varchar(4),
   keywords     varchar(255),
   abstract     text,
   lastModified datetime,
   PRIMARY KEY (fullname),
   KEY instance (instance)
);
DROP TABLE IF EXISTS wct006_pastedproperties;
CREATE TABLE wct006_pastedproperties (
   Id       int(10) DEFAULT'0' AUTO_INCREMENT,
   instance smallint(6) DEFAULT '0' NOT NULL,
   object   varchar(255) NOT NULL,
   name     varchar(255),
   value    varchar(255),
   PRIMARY KEY (Id),
   KEY instance (instance)
);

Script for database model deletion

# Web Component DB Storage Model
# Object Name : WCT_REPOSITORY
# Object SQL : Uninstallation script
# Object ID : 006
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_REPOSITORY
# --------------------------------------------------------
DROP TABLE IF EXISTS wct006_objects;
DROP TABLE IF EXISTS wct006_properties;
DROP TABLE IF EXISTS wct006_pastedobjects;
DROP TABLE IF EXISTS wct006_pastedproperties;

Script for database model cleanup

# Web Component DB Storage Model
# Object Name : WCT_REPOSITORY
# Object SQL : Instance cleanup script
# Object ID : 006
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_REPOSITORY
# --------------------------------------------------------
DELETE FROM wct006_objects WHERE instance = <%%WCT_REPOSITORY::ID%%>;
DELETE FROM wct006_properties WHERE instance = <%%WCT_REPOSITORY::ID%%>;
DELETE FROM wct006_pastedobjects WHERE instance = <%%WCT_REPOSITORY::ID%%>;
DELETE FROM wct006_pastedproperties WHERE instance = <%%WCT_REPOSITORY::ID%%>;