CREATE TABLE folders ( id INT NOT NULL DEFAULT 0, name VARCHAR(255), parentid INT, PRIMARY KEY (id), FOREIGN KEY (parentid) REFERENCES folders(id) ON DELETE CASCADE ) ENGINE=InnoDB; More options ...

Create, edit, and delete databases List fields, indexes, foreign keys and triggers of table Change the name, engine, collation, auto_increment, and comment of tables ...