CREATE TABLE DEPARTMENT
(
ID INT PRIMARY KEY
IDENTITY(1,1),
Path VARCHAR(180) UNIQUE,
Position INT NOT NULL,
NAME VARCHAR(128)
)
GO
INSERT INTO DEPARTMENT (Path, Position, NAME)
VALUES ('1', 1, 'Организация «Рога и копыта»')
INSERT INTO DEPARTMENT (Path, Position, NAME)
VALUES ('1.1', 1, 'Департамент «Рога»')
INSERT INTO DEPARTMENT (Path, Position, NAME)
VALUES ('1.1.1', 1, 'Отдел продажи рогов')
INSERT INTO DEPARTMENT (Path, Position, NAME)
VALUES ('1.1.2', 2, 'Отдел покупки рогов')
INSERT INTO DEPARTMENT (Path, Position, NAME)
VALUES ('1.1.2.1', 1, 'Группа оценки качества рогов')
INSERT INTO DEPARTMENT (Path, Position, NAME)
VALUES ('1.1.3', 3, 'Отдел проката рогов')
INSERT INTO DEPARTMENT (Path, Position, NAME)
VALUES ('1.2', 2, 'Департамент «Копыта»')
INSERT INTO DEPARTMENT (Path, Position, NAME)
VALUES ('1.2.1', 1, 'Отдел покупки копыт')
INSERT INTO DEPARTMENT (Path, Position, NAME)
VALUES ('1.2.2', 2, 'Отдел продажи копыт')
GO
|