← All repositories

crossmate

A collaborative crossword app for iPhone and iPad

git clone https://code.inqk.net/crossmate.git


cloudkit.ckdb (4750B)

1DEFINE SCHEMA
2
3    RECORD TYPE Archive (
4        "___createTime" TIMESTAMP,
5        "___createdBy"  REFERENCE,
6        "___etag"       STRING,
7        "___modTime"    TIMESTAMP,
8        "___modifiedBy" REFERENCE,
9        "___recordID"   REFERENCE,
10        archiveGameID   STRING,
11        cells           ASSET,
12        completedAt     TIMESTAMP,
13        completedBy     STRING,
14        journals        ASSET,
15        originalGameID  STRING,
16        puzzleSource    ASSET,
17        solveSeconds    INT64,
18        title           STRING,
19        GRANT WRITE TO "_creator",
20        GRANT CREATE TO "_icloud",
21        GRANT READ TO "_world"
22    );
23
24    RECORD TYPE Chronicle (
25        "___createTime" TIMESTAMP,
26        "___createdBy"  REFERENCE,
27        "___etag"       STRING,
28        "___modTime"    TIMESTAMP QUERYABLE,
29        "___modifiedBy" REFERENCE,
30        "___recordID"   REFERENCE QUERYABLE,
31        completedAt      TIMESTAMP QUERYABLE SORTABLE,
32        payload          ASSET,
33        GRANT WRITE TO "_creator",
34        GRANT CREATE TO "_icloud",
35        GRANT READ TO "_world"
36    );
37
38    RECORD TYPE Decision (
39        "___createTime" TIMESTAMP,
40        "___createdBy"  REFERENCE,
41        "___etag"       STRING,
42        "___modTime"    TIMESTAMP,
43        "___modifiedBy" REFERENCE,
44        "___recordID"   REFERENCE,
45        kind            STRING,
46        payload         STRING,
47        version         INT64,
48        GRANT WRITE TO "_creator",
49        GRANT CREATE TO "_icloud",
50        GRANT READ TO "_world"
51    );
52
53    RECORD TYPE Game (
54        "___createTime" TIMESTAMP,
55        "___createdBy"  REFERENCE,
56        "___etag"       STRING,
57        "___modTime"    TIMESTAMP QUERYABLE,
58        "___modifiedBy" REFERENCE,
59        "___recordID"   REFERENCE,
60        completedAt     TIMESTAMP,
61        completedBy     STRING,
62        puzzleSource    ASSET,
63        pushCredential  BYTES,
64        roomCredential  BYTES,
65        shareRecordName STRING,
66        syncVersion     INT64,
67        title           STRING,
68        GRANT WRITE TO "_creator",
69        GRANT CREATE TO "_icloud",
70        GRANT READ TO "_world"
71    );
72
73    RECORD TYPE Journal (
74        "___createTime" TIMESTAMP,
75        "___createdBy"  REFERENCE,
76        "___etag"       STRING,
77        "___modTime"    TIMESTAMP,
78        "___modifiedBy" REFERENCE,
79        "___recordID"   REFERENCE QUERYABLE,
80        entries         ASSET,
81        updatedAt       TIMESTAMP,
82        GRANT WRITE TO "_creator",
83        GRANT CREATE TO "_icloud",
84        GRANT READ TO "_world"
85    );
86
87    RECORD TYPE Moves (
88        "___createTime" TIMESTAMP,
89        "___createdBy"  REFERENCE,
90        "___etag"       STRING,
91        "___modTime"    TIMESTAMP QUERYABLE,
92        "___modifiedBy" REFERENCE,
93        "___recordID"   REFERENCE QUERYABLE,
94        cells           BYTES,
95        updatedAt       TIMESTAMP,
96        GRANT WRITE TO "_creator",
97        GRANT CREATE TO "_icloud",
98        GRANT READ TO "_world"
99    );
100
101    RECORD TYPE Ping (
102        "___createTime" TIMESTAMP,
103        "___createdBy"  REFERENCE,
104        "___etag"       STRING,
105        "___modTime"    TIMESTAMP QUERYABLE,
106        "___modifiedBy" REFERENCE,
107        "___recordID"   REFERENCE,
108        addressee       STRING,
109        kind            STRING QUERYABLE,
110        payload         STRING,
111        playerName      STRING,
112        puzzleTitle     STRING,
113        GRANT WRITE TO "_creator",
114        GRANT CREATE TO "_icloud",
115        GRANT READ TO "_world"
116    );
117
118    RECORD TYPE Player (
119        "___createTime" TIMESTAMP,
120        "___createdBy"  REFERENCE,
121        "___etag"       STRING,
122        "___modTime"    TIMESTAMP QUERYABLE,
123        "___modifiedBy" REFERENCE,
124        "___recordID"   REFERENCE,
125        name            STRING,
126        presenceUntil   TIMESTAMP,
127        pushAddress     STRING,
128        readThrough     TIMESTAMP,
129        selCol          INT64,
130        selDir          INT64,
131        selRow          INT64,
132        timeLog         BYTES,
133        updatedAt       TIMESTAMP,
134        viewedAt        TIMESTAMP,
135        GRANT WRITE TO "_creator",
136        GRANT CREATE TO "_icloud",
137        GRANT READ TO "_world"
138    );
139
140    RECORD TYPE "cloudkit.share" (
141        "___createTime"               TIMESTAMP,
142        "___createdBy"                REFERENCE,
143        "___etag"                     STRING,
144        "___modTime"                  TIMESTAMP,
145        "___modifiedBy"               REFERENCE,
146        "___recordID"                 REFERENCE,
147        "cloudkit.thumbnailImageData" BYTES,
148        "cloudkit.title"              STRING,
149        "cloudkit.type"               STRING,
150        GRANT WRITE TO "_creator",
151        GRANT CREATE TO "_icloud",
152        GRANT READ TO "_world"
153    );