CREATE TABLE serendipity_icard_authors (
  ppid varchar(255) default NULL,
  `hash` varchar(32) default NULL,
  authorid int(11) default '0'
) ENGINE=MyISAM;

CREATE TABLE serendipity_pending_icard_authors (
  realname varchar(255) default NULL,
  username varchar(32) default NULL,
  ppid varchar(255) default NULL,
  email varchar(128) NOT NULL default '',
  userlevel int(4) unsigned NOT NULL default '0',
  right_publish int(1) default '1',
  no_create int(1) default '0',
  `hash` varchar(32) default NULL
) ENGINE=MyISAM;