author | eilers <eilers> | 2002-10-09 14:36:57 (UTC) |
---|---|---|
committer | eilers <eilers> | 2002-10-09 14:36:57 (UTC) |
commit | 273d5329e29c43b287876202de2f0c500a312b7b (patch) (side-by-side diff) | |
tree | 04dfc8d29dd57dd2bea76beb98f154825ba178b3 /development/pim/dbpaper/tables.tex | |
parent | f9f2d227b3cfbc2187b4f7f535fc59f9735798d0 (diff) | |
download | opie-273d5329e29c43b287876202de2f0c500a312b7b.zip opie-273d5329e29c43b287876202de2f0c500a312b7b.tar.gz opie-273d5329e29c43b287876202de2f0c500a312b7b.tar.bz2 |
Changes regarding the tips of Robert Wittams
Diffstat (limited to 'development/pim/dbpaper/tables.tex') (more/less context) (ignore whitespace changes)
-rw-r--r-- | development/pim/dbpaper/tables.tex | 23 |
1 files changed, 12 insertions, 11 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 @@ -64,3 +64,3 @@ CREATE TABLE RECURRENCE ( UID int NOT NULL UNIQUE, - TID int NOT NULL + TID int NOT NULL RType int, @@ -130,7 +130,8 @@ Personal data: \\ \begin{verbatim} -CREATE TABLE PERSONAL_DATA_CONTACT ( - UID int NOT NULL UNIQUE, - ID int AUTOINCREMENT, - Ident text, - Value text, +CREATE TABLE PERSONAL_DATA ( + UID int NOT NULL UNIQUE, + ID int AUTOINCREMENT, + Ident text, + Priority int, + Value text, PRIMARY KEY(UID,ID) @@ -173,6 +174,6 @@ CREATE TABLE CROSSREF ( 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() @@ -196,3 +197,3 @@ CREATE TABLE CATEGORY ( ApplicationName text, - ForeGroundColor text, <-- maybe hex? + ForeGroundColor text, <-- maybe hex? BackGroundColor text, @@ -239,3 +240,3 @@ CREATE TABLE APPLICATION ( \noindent -Location: \\ +Location: \\ \begin{tabular}[ht]{|l|l|} |