All pastes #19303 Raw Edit

StarScream

public sql v1 · immutable
#19303 ·published 2005-08-04 15:00 UTC
rendered paste body
CREATE TABLE users_content_data ( content_id int(3) PRIMARY KEY auto_increment, page_content mediumtext, FOREIGN KEY (content_id) REFERENCES users_page_content (content_id) ON DELETE CASCADE)TYPE=INNODB;CREATE TABLE users_page_content (  page_content_id  int(11) PRIMARY KEY auto_increment,  page_id int(11) NOT NULL,  content_id int(3) NOT NULL,  KEY (page_id),  KEY (content_id),  FOREIGN KEY (page_id) REFERENCES users_site_structure ( menu_id))TYPE=INNODB;