PHP Classes

File: myXTree/base.sql

Recommend this page to a friend!
  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: 20 years ago
Size: 973 bytes


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');