File: myXTree/base.sql

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