`intranet`.`page`
Code: Select all
+--------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------+------------------+------+-----+---------+----------------+
| PageID | int(10) unsigned | | PRI | NULL | auto_increment |
| Title | tinytext | | | | |
+--------+------------------+------+-----+---------+----------------+Code: Select all
+-----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+----------------+
| ContentID | int(10) unsigned | | PRI | NULL | auto_increment |
| PageID | int(10) unsigned | | | 0 | |
| Title | tinytext | | | | |
| Body | text | | | | |
| UserID | int(10) unsigned | | | 0 | |
| Order | tinyint(4) | | | 0 | |
+-----------+------------------+------+-----+---------+----------------+Preferably, it should be done in a single SQL statement, but take as many as you need.
This one has me beat