Diffstat (limited to 'development/pim/dbpaper/tables.tex') (more/less context) (show whitespace changes)
-rw-r--r-- | development/pim/dbpaper/tables.tex | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/development/pim/dbpaper/tables.tex b/development/pim/dbpaper/tables.tex index ac28a47..64ae02d 100644 --- a/development/pim/dbpaper/tables.tex +++ b/development/pim/dbpaper/tables.tex | |||
@@ -128,10 +128,11 @@ Personal data: \\ | |||
128 | \hline | 128 | \hline |
129 | \end{tabular} | 129 | \end{tabular} |
130 | \begin{verbatim} | 130 | \begin{verbatim} |
131 | CREATE TABLE PERSONAL_DATA_CONTACT ( | 131 | CREATE TABLE PERSONAL_DATA ( |
132 | UID int NOT NULL UNIQUE, | 132 | UID int NOT NULL UNIQUE, |
133 | ID int AUTOINCREMENT, | 133 | ID int AUTOINCREMENT, |
134 | Ident text, | 134 | Ident text, |
135 | Priority int, | ||
135 | Value text, | 136 | Value text, |
136 | PRIMARY KEY(UID,ID) | 137 | PRIMARY KEY(UID,ID) |
137 | ); | 138 | ); |
@@ -171,10 +172,10 @@ CrossRef: \\ | |||
171 | CREATE TABLE CROSSREF ( | 172 | CREATE TABLE CROSSREF ( |
172 | TID1 int NOT NULL, | 173 | TID1 int NOT NULL, |
173 | UID1 int NOT NULL, | 174 | UID1 int NOT NULL, |
174 | Item1 int NOT NULL, | 175 | ID1 int NOT NULL, |
175 | TID2 int MOT NULL, | 176 | TID2 int NOT NULL, |
176 | UID2 int NOT NULL, | 177 | UID2 int NOT NULL, |
177 | Item2 int NOT NULL, | 178 | ID2 int NOT NULL, |
178 | PRIMARY KEY() | 179 | PRIMARY KEY() |
179 | ); | 180 | ); |
180 | \end{verbatim} | 181 | \end{verbatim} |