Select Code to Download

CREATE TABLE node (
  node_id int(11) NOT NULL auto_increment,
...
  KEY author (author_user),
  KEY type (type_nodetype)
);

CREATE TABLE nodetype (
  nodetype_id int(11) DEFAULT '0' NOT NULL auto_increment,
...
  canworkspace int(11) DEFAULT '-1' NOT NULL,
  PRIMARY KEY (nodetype_id)
);