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
@@ -107,95 +107,96 @@ Postal:\\
 CREATE TABLE POSTAL (
   UID     int NOT NULL ,
   TID      int NOT NULL,
   Type    int NOT NULL UNIQUE,  -- maybe text, then more are possible
   Street  text,
   City    text,
   State   text,
   Zip     text,  -- who knows if theres no country with letters in the zip code
   Country,
   PRIMARY KEY (UID, Type)
 );
 \end{verbatim}
  
 
 \noindent
 Personal data: \\
 \begin{tabular}[ht]{|l|l|l|l|}
 \hline
 \underline{UID} & \underline{ID} & Ident & Value \\
 \hline
  & & & \\
 \hline
 \end{tabular}
 \begin{verbatim}
-CREATE TABLE PERSONAL_DATA_CONTACT (
+CREATE TABLE PERSONAL_DATA (
   UID    int NOT NULL UNIQUE,
   ID     int AUTOINCREMENT,
   Ident  text,
+  Priority  int,
   Value  text,
   PRIMARY KEY(UID,ID)
 );      
 \end{verbatim}
 
 \noindent
 TableID: \\
 \begin{tabular}[ht]{|l|l|l|l|}
 \hline
 \underline{UID} & Name & DefaultRep & Version\\
 \hline
  & & &\\
 \hline
 \end{tabular}
 \begin{verbatim}
 CREATE TABLE TABLEID (
   UID         int NOT NULL UNIQUE,
   Name        text,
   DefaultRep  text, -- list of which which columns from apps table are supposed to be queried for default,
   Version     int NOT NULL 
   PRIMARY KEY (UID)
 );
 \end{verbatim}
 
 
 
 \noindent
 CrossRef: \\
 \begin{tabular}[ht]{|l|l|l|l|l|l|}
 \hline
 \underline{TID1} & \underline{UID1} & \underline{Item1} & \underline{TID2} & \underline{UID2} & \underline{Item2} \\
 \hline
  & & & & &\\
 \hline
 \end{tabular}
 \begin{verbatim}
 CREATE TABLE CROSSREF (
   TID1       int NOT NULL,
   UID1       int NOT NULL,
-  Item1      int NOT NULL,
-  TID2       int MOT NULL,
+  ID1        int NOT NULL,
+  TID2       int NOT NULL,
   UID2       int NOT NULL,
-  Item2      int NOT NULL,
+  ID2        int NOT NULL,
   PRIMARY KEY() 
 );
 \end{verbatim}
 
 
 \noindent
 Category: \\
 \begin{tabular}[ht]{|l|l|l|l|l|l|}
 \hline
 \underline{UID} & Parent & Name  & ApplicationName & ForeGroundColor & BackGroundColor\\
 \hline
  & & & & &\\
 \hline
 \end{tabular}
 \begin{verbatim}
 CREATE TABLE CATEGORY (
   UID   int NOT NULL UNIQUE,
   Name  text,
   ApplicationName text,
           ForeGroundColor text,<-- maybe hex?
   BackGroundColor text,
   PRIMARY KEY(UID)
 );
 \end{verbatim}