File: sqlite.addressbooks.sql

package info (click to toggle)
php-sabredav 1.8.12-10
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, sid
  • size: 4,928 kB
  • sloc: php: 28,633; sql: 271; python: 221; makefile: 35; xml: 25; sh: 8
file content (17 lines) | stat: -rw-r--r-- 298 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
CREATE TABLE addressbooks (
    id integer primary key asc,
    principaluri text,
    displayname text,
    uri text,
    description text,
	ctag integer
);

CREATE TABLE cards (
	id integer primary key asc,
    addressbookid integer,
    carddata blob,
    uri text,
    lastmodified integer
);