/* First, create our shells table: */
CREATE TABLE shells (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    exec VARCHAR(255) NOT NULL,
    env TEXT,
    output TEXT
);

/* Then insert some shells for testing: */
INSERT INTO shells (title,exec,env)
    VALUES ('Bash', '/bin/bash',
'a:2:{s:4:"PATH";s:43:"/bin:/usr/bin:/var/www/cake/app/webroot/bin";s:3:"PS1";s:5:"bash$";}');