CREATE TABLE addressbooks (
      id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
      principaluri VARCHAR(255),
      displayname VARCHAR(255),
      uri VARCHAR(200),
      description TEXT,
      ctag INT(11) UNSIGNED NOT NULL DEFAULT '1',
      UNIQUE(principaluri, uri)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  CREATE TABLE cards (
      id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
      addressbookid INT(11) UNSIGNED NOT NULL,
      carddata MEDIUMBLOB,
      uri VARCHAR(200),
      lastmodified INT(11) UNSIGNED
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;