ESSI_Resource : File /home/groups/d/di/diml/htdocs/wct/proto/WCT_HIERARCHY/index_.dim not found at line in

Table des matières
Component index
Data Model Templates
>> Top of page

WCT Users (integrators)

Component : WCT_HIERARCHY
Id : 005

Database Model

Script for database model creation

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
# --------------------------------------------------------
#
# Web Component DB Storage Model
# Object Name : WCT_HIERARCHY
# Object SQL : Installation script
# Object ID : 005
# Object Prototype URL : http://www.diml.org/wct/proto/WCT_HIERARCHY/
# --------------------------------------------------------
# Table structure for table 'wct005_categories'
#
DROP TABLE IF EXISTS wct005_categories;
CREATE TABLE wct005_categories (
   Id smallint(6) DEFAULT '0' NOT NULL auto_increment,
   instance smallint(6) DEFAULT '0' NOT NULL,
   node varchar(30) NOT NULL,
   code varchar(15),
   name varchar(255), 
   url varchar(255), 
   PRIMARY KEY (Id),
   KEY instance (instance)
);
DROP TABLE IF EXISTS wct005_attachements;
CREATE TABLE wct005_attachements (
   Id int DEFAULT '0' NOT NULL auto_increment,
   instance smallint(6) DEFAULT '0' NOT NULL,
   node varchar(30) NOT NULL,
   name varchar(255),
   type varchar(40),
   value varchar(255), 
   PRIMARY KEY (Id),
   KEY instance (instance)
);

Script for database model deletion

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

Script for database model cleanup

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


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