Login   Register  
PHP Classes
elePHPant
Icontem

File: myXTree/base.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Tereshchenko Andrey  >  myXTree  >  myXTree/base.sql  >  Download  
File: myXTree/base.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL queries for create database
Class: myXTree
myXTree is an interface to a SQL-tree.
Author: By
Last change:
Date: 11 years ago
Size: 973 bytes
 

Contents

Class file image Download
CREATE TABLE `Objects` (
    `ObjectID` INT AUTO_INCREMENT,
    `ObjectName` VARCHAR(24) NOT NULL,
    `ObjectValue` TEXT,
    `leftLimit` MEDIUMINT NOT NULL,
    `rightLimit` MEDIUMINT NOT NULL,
    `depth` TINYINT NOT NULL,
    PRIMARY KEY(`ObjectID`),
    UNIQUE(`ObjectID`,`leftLimit`,`rightLimit`),
    INDEX (`ObjectName`)
    );

CREATE TABLE `Attributes` (
    `ObjectID` INT AUTO_INCREMENT,
    `ObjectName` VARCHAR(24) NOT NULL,
    `ObjectValue` VARCHAR(255),
    `OwnerObject` INT NOT NULL,
    PRIMARY KEY(`ObjectID`),
    UNIQUE(`ObjectID`)
    );

CREATE TABLE `myXTree` (
    `Version` VARCHAR(5) NOT NULL,
		`Description` VARCHAR(255)
		);

INSERT INTO Objects (ObjectID, ObjectName, leftLimit, rightLimit, depth)
VALUES (200303301, '_ROOT_', 1, 2, 0);

INSERT INTO Attributes (ObjectID, ObjectName, ObjectValue, OwnerObject)
VALUES (200303302, 'id', '200303301', 200303301);

INSERT INTO myXTree (Version) VALUES ('00.11');