Anonymous

CREATE TABLE users_site_structure (
  menu_id int(11) NOT NULL PRIMARY KEY auto_increment,
  menu_no int(3) NOT NULL,
  menu_parent int(11) NOT NULL default '0',
  menu_position int(3) default '0',
  menu_text varchar(255),
  menu_href varchar(255) default '',
  KEY (menu_no),
  KEY (menu_parent),
  FOREIGN KEY (menu_no) REFERENCES users_menus (menu_no)
)TYPE=INNODB;


mysql> select * from users_site_structure;
+---------+---------+-------------+---------------+------------------+------------------+
| menu_id | menu_no | menu_parent | menu_position | menu_text        | menu_href        |
+---------+---------+-------------+---------------+------------------+------------------+
|       1 |       1 |           0 |             2 | About Us    | about_us.html    |
|       2 |       1 |           0 |             3 | Products         | products.html    |
|       3 |       1 |           0 |             4 | Services         | services.html    |
|       4 |       1 |           0 |             5 | Contact Us  | contact_us.html  |
|      11 |       1 |           3 |             2 | Zinc Change | zinc_change.html |
|      13 |       1 |           0 |             1 | try              | try.html         |
+---------+---------+-------------+---------------+------------------+------------------+
6 rows in set (0.00 sec)