text: GRANT CREATE,ALTER,SELECT,INSERT,UPDATE,DELETE ON example.* TO example@localhost IDENTIFIED BY 'example';
  
  DROP TABLE IF EXISTS nodes;
  CREATE TABLE nodes (
    id int(10) unsigned NOT NULL default '0',
    prototype varchar(255) default NULL,
    name varchar(255) default NULL,
    visible tinyint(3) unsigned default NULL,
    position tinyint(3) unsigned default NULL,
    parent_id int(10) unsigned default NULL,
    creator_id int(11) default '0',
    creation_date datetime default NULL,
    modifier_id int(11) default '0',
    modification_date datetime default NULL,
    related_ids varchar(255) default NULL,
    text text,
    PRIMARY KEY  (id),
    KEY name (name,text(64)),
    FULLTEXT KEY search (name,text)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  INSERT INTO nodes VALUES (0,'Root','Welcome',1,0,NULL,0,'2007-11-06 15:08:38',0,'2007-11-08 02:51:34',NULL,'Welcome to this simple demonstration.'),(2,'Page','Three',1,2,0,NULL,'2007-11-07 23:26:26',0,'2007-11-08 02:52:27',NULL,'Same here really...'),(3,'Page','One',1,0,0,NULL,'2007-11-07 23:26:08',0,'2007-11-08 02:51:58',NULL,'Guys, I\'m mighty!'),(9,'Page','Two',1,1,0,0,'2007-11-07 23:26:18',0,'2007-11-08 02:52:06',NULL,'Not much here...');
  
  DROP TABLE IF EXISTS resources;
  CREATE TABLE resources (
    id int(10) unsigned NOT NULL default '0',
    node_id int(10) unsigned default NULL,
    post_id int(10) unsigned default NULL,
    prototype varchar(255) default NULL,
    name varchar(255) default NULL,
    visible tinyint(3) unsigned default NULL,
    position tinyint(3) unsigned default NULL,
    creator_id int(11) default '0',
    creation_date datetime default NULL,
    modifier_id int(11) default '0',
    modification_date datetime default NULL,
    extension varchar(16) default NULL,
    counter int(10) unsigned default NULL,
    version int(10) unsigned default NULL,
    width smallint(5) unsigned default NULL,
    height smallint(5) unsigned default NULL,
    type varchar(255) default NULL,
    PRIMARY KEY  (id),
    KEY name (name)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  INSERT INTO resources VALUES (1,3,NULL,'Picture','Billy.jpg',1,0,0,'2007-11-08 00:14:40',0,'2007-11-08 00:15:30','jpg',0,NULL,539,480,'image');
  
  DROP TABLE IF EXISTS users;
  CREATE TABLE users (
    id int(10) unsigned NOT NULL default '0',
    name varchar(255) default NULL,
    full_name varchar(64) default NULL,
    password varchar(255) default NULL,
    role int(10) unsigned default NULL,
    email varchar(255) default NULL,
    registration_date datetime default NULL,
    last_login datetime default NULL,
    text text,
    website varchar(255) default NULL,
    PRIMARY KEY  (id),
    KEY name (name)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  INSERT INTO users VALUES (0,'admin','Administrator','3f1d3578303c4cff3872a40345a00225f2c8192b',15,'juerg@scratchdisk.com','2005-01-21 11:01:55','2007-11-08 00:28:45','Sys Admins Do It Better','http://www.scratchdisk.com');
  