Q6B2gybL

1		CREATE TABLE IF NOT EXISTS
2					pages  (id			INT NOT NULL AUTO_INCREMENT,
3							parent_id	INT NOT NULL DEFAULT 0,
4							level		INT NOT NULL DEFAULT 0,
5							lkey		INT NOT NULL DEFAULT 0,
6							rkey		INT NOT NULL DEFAULT 0,
7							user_id		INT NOT NULL DEFAULT 0,
8							href		VARCHAR(255) NOT NULL,
9							title		VARCHAR(255) NOT NULL,
10							header		VARCHAR(255) NOT NULL,
11							content		TEXT NOT NULL,
12							status		INT NOT NULL DEFAULT 0,
13							cdate		TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
14							adate		TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
15							desc		VARCHAR(255),
16							PRIMARY KEY(id),
17							FOREIGN KEY (user_id) REFERENCES user(id)
18						   );