1 CREATE TABLE addressbooks (
2 id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
3 principaluri VARCHAR(255),
4 displayname VARCHAR(255),
7 ctag INT(11) UNSIGNED NOT NULL DEFAULT '1',
8 UNIQUE(principaluri, uri)
9 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
12 id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
13 addressbookid INT(11) UNSIGNED NOT NULL,
16 lastmodified INT(11) UNSIGNED
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;