CREATE TABLE `treedata` ( `idx` INT(11) NOT NULL AUTO_INCREMENT COMMENT '고유번호', `parent_idx` INT(11) NOT NULL DEFAULT '0' COMMENT '부모번호', `text` VARCHAR(50) NOT NULL COMMENT '노드명', PRIMARY KEY (`idx`) ) ENGINE=INNODB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; INSERT INTO `treedata`(`idx`,`parent_idx`,`text`) VALUES (1,0,'대표-세종대왕'),(2,0,'경영지원팀'),(3,0,'기획팀'),(4,0,'개발팀'),(5,2,'부장-홍길동'),(6,3,'차장-이순신'),(7,3,'과장-장영실'),(8,4,'부장-스티브잡스'),(9,4,'차장-빌게이츠'),(10,4,'대리-주커버크'),(11,4,'사원-몽고');