-
Notifications
You must be signed in to change notification settings - Fork 0
/
aaron_recipies.sqs
489 lines (489 loc) · 30.7 KB
/
aaron_recipies.sqs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
<?xml version="1.0" encoding="UTF-8"?>
<SQLContainer>
<SQLTable>
<name><![CDATA[categories]]></name>
<schema><![CDATA[]]></schema>
<location>
<x>64.00</x>
<y>64.00</y>
</location>
<size>
<width>192.00</width>
<height>128.00</height>
</size>
<zorder>1</zorder>
<SQLField>
<name><![CDATA[id]]></name>
<type><![CDATA[integer]]></type>
<primaryKey>1</primaryKey>
<forcedUnique><![CDATA[1]]></forcedUnique>
<uid><![CDATA[8B9BDCD5-574E-4ECB-8A66-FB1E6D4D636E]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[name]]></name>
<type><![CDATA[string]]></type>
<uid><![CDATA[73368B9B-4C55-4DED-A8A4-CAC9D4691B09]]></uid>
<unique><![CDATA[1]]></unique>
</SQLField>
<SQLField>
<name><![CDATA[created_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[9B27054A-4B4D-4982-97C6-994A1F2C714F]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[updated_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[7786C72E-224E-4671-BD37-E9391CC9DF91]]></uid>
</SQLField>
<labelWindowIndex><![CDATA[6]]></labelWindowIndex>
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
<uid><![CDATA[086D801F-2EC2-4942-924A-B25659103DF6]]></uid>
</SQLTable>
<SQLTable>
<name><![CDATA[recipes]]></name>
<schema><![CDATA[]]></schema>
<location>
<x>576.00</x>
<y>64.00</y>
</location>
<size>
<width>174.00</width>
<height>180.00</height>
</size>
<zorder>0</zorder>
<SQLField>
<name><![CDATA[id]]></name>
<type><![CDATA[integer]]></type>
<primaryKey>1</primaryKey>
<forcedUnique><![CDATA[1]]></forcedUnique>
<uid><![CDATA[FB57A155-6A3E-4880-9AC0-AD50F2DB37D0]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[name]]></name>
<type><![CDATA[string]]></type>
<uid><![CDATA[4B7AC9CE-CBBF-4D0F-8E48-842529948713]]></uid>
<unique><![CDATA[1]]></unique>
</SQLField>
<SQLField>
<name><![CDATA[author]]></name>
<type><![CDATA[string]]></type>
<uid><![CDATA[BEC7D379-BC13-4975-8D5A-B454376DFE0B]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[servings]]></name>
<type><![CDATA[integer]]></type>
<uid><![CDATA[3E34CD8A-8C40-4BDE-87C9-8572CFE90932]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[serving_suggestion]]></name>
<type><![CDATA[string]]></type>
<uid><![CDATA[3C10BEEA-869D-4985-8E80-47C320741669]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[rating]]></name>
<type><![CDATA[float]]></type>
<uid><![CDATA[F3677764-72FA-434D-BABF-CA5D58B75711]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[created_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[273DFCE4-DFD0-4470-A6E0-CEA892A8404B]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[updated_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[DF9358F9-1E3B-492B-B2A5-906917025100]]></uid>
</SQLField>
<labelWindowIndex><![CDATA[5]]></labelWindowIndex>
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
<uid><![CDATA[11A718D2-DFDB-415C-96F3-E5A152F4A624]]></uid>
</SQLTable>
<SQLTable>
<name><![CDATA[directions]]></name>
<schema><![CDATA[]]></schema>
<location>
<x>320.00</x>
<y>256.00</y>
</location>
<size>
<width>192.00</width>
<height>192.00</height>
</size>
<zorder>4</zorder>
<SQLField>
<name><![CDATA[id]]></name>
<type><![CDATA[integer]]></type>
<primaryKey>1</primaryKey>
<uid><![CDATA[E0FB09B8-C149-4681-A2A0-CCF02FA5BF14]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[recipe_id]]></name>
<type><![CDATA[integer]]></type>
<referencesField>id</referencesField>
<referencesTable>recipes</referencesTable>
<referencesField><![CDATA[id]]></referencesField>
<referencesTable><![CDATA[recipes]]></referencesTable>
<sourceCardinality>0</sourceCardinality>
<destinationCardinality>0</destinationCardinality>
<referencesFieldUID><![CDATA[FB57A155-6A3E-4880-9AC0-AD50F2DB37D0]]></referencesFieldUID>
<referencesTableUID><![CDATA[11A718D2-DFDB-415C-96F3-E5A152F4A624]]></referencesTableUID>
<uid><![CDATA[C61DF4AE-2E13-41B3-94A1-696AD42CC8C8]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[step]]></name>
<type><![CDATA[integer]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[4CF00E61-5AA1-4757-AD65-7EAB5F1DF151]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[action]]></name>
<type><![CDATA[string]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[E2F7FDA0-5469-4512-B00F-4E5C9C88A3C9]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[created_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[878471E9-B413-428C-9F61-E2B72EE593E7]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[updated_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[E197ED43-8E03-4BE8-A97A-5CF04A1F41E4]]></uid>
</SQLField>
<SQLConstraint>
<name><![CDATA[directions_cns_1]]></name>
<fieldName><![CDATA[recipe_id]]></fieldName>
<fieldName><![CDATA[step]]></fieldName>
<SQLIndexEntry>
<name><![CDATA[recipe_id]]></name>
<prefixSize><![CDATA[]]></prefixSize>
<fieldUid><![CDATA[C61DF4AE-2E13-41B3-94A1-696AD42CC8C8]]></fieldUid>
</SQLIndexEntry>
<SQLIndexEntry>
<name><![CDATA[step]]></name>
<prefixSize><![CDATA[]]></prefixSize>
<fieldUid><![CDATA[4CF00E61-5AA1-4757-AD65-7EAB5F1DF151]]></fieldUid>
</SQLIndexEntry>
<indexNamePrefix><![CDATA[directions]]></indexNamePrefix>
<indexType><![CDATA[UNIQUE]]></indexType>
<uid><![CDATA[AD8B9CFB-489B-44E4-BB99-FB0016AABBD7]]></uid>
</SQLConstraint>
<labelWindowIndex><![CDATA[4]]></labelWindowIndex>
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
<uid><![CDATA[14F961B9-8B05-4933-8522-F5B0413857A9]]></uid>
</SQLTable>
<SQLTable>
<name><![CDATA[recipe_categories]]></name>
<schema><![CDATA[]]></schema>
<location>
<x>320.00</x>
<y>64.00</y>
</location>
<size>
<width>192.00</width>
<height>128.00</height>
</size>
<zorder>2</zorder>
<SQLField>
<name><![CDATA[id]]></name>
<type><![CDATA[integer]]></type>
<primaryKey>1</primaryKey>
<uid><![CDATA[2D3D00BD-6D00-4931-AFFA-B83300899D83]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[recipe_id]]></name>
<type><![CDATA[integer]]></type>
<referencesField>id</referencesField>
<referencesTable>recipes</referencesTable>
<referencesField><![CDATA[id]]></referencesField>
<referencesTable><![CDATA[recipes]]></referencesTable>
<sourceCardinality>0</sourceCardinality>
<destinationCardinality>0</destinationCardinality>
<referencesFieldUID><![CDATA[FB57A155-6A3E-4880-9AC0-AD50F2DB37D0]]></referencesFieldUID>
<referencesTableUID><![CDATA[11A718D2-DFDB-415C-96F3-E5A152F4A624]]></referencesTableUID>
<uid><![CDATA[5A7CC99C-6897-4B58-BD03-C47C1907F6CF]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[category_id]]></name>
<type><![CDATA[integer]]></type>
<referencesField>id</referencesField>
<referencesTable>categories</referencesTable>
<referencesField><![CDATA[id]]></referencesField>
<referencesTable><![CDATA[categories]]></referencesTable>
<sourceCardinality>0</sourceCardinality>
<destinationCardinality>0</destinationCardinality>
<referencesFieldUID><![CDATA[8B9BDCD5-574E-4ECB-8A66-FB1E6D4D636E]]></referencesFieldUID>
<referencesTableUID><![CDATA[086D801F-2EC2-4942-924A-B25659103DF6]]></referencesTableUID>
<uid><![CDATA[7FDE44E7-B33B-451A-99DB-F2A5E1C95610]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[created_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[8C181DB1-8D46-4F5E-AFFF-1E7BE74362D3]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[updated_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[15B0B151-69DF-4212-AEC3-483972A6A85A]]></uid>
</SQLField>
<labelWindowIndex><![CDATA[3]]></labelWindowIndex>
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
<uid><![CDATA[2611CDA8-8AF7-4A2A-A237-EEE112865955]]></uid>
</SQLTable>
<SQLTable>
<name><![CDATA[pictures]]></name>
<schema><![CDATA[]]></schema>
<location>
<x>576.00</x>
<y>320.00</y>
</location>
<size>
<width>192.00</width>
<height>200.00</height>
</size>
<zorder>6</zorder>
<SQLField>
<name><![CDATA[id]]></name>
<type><![CDATA[integer]]></type>
<primaryKey>1</primaryKey>
<uid><![CDATA[8F8D58BA-C7C3-4ED4-AFB2-2A62FD196548]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[recipe_id]]></name>
<type><![CDATA[integer]]></type>
<referencesField>id</referencesField>
<referencesTable>recipes</referencesTable>
<referencesField><![CDATA[id]]></referencesField>
<referencesTable><![CDATA[recipes]]></referencesTable>
<sourceCardinality>0</sourceCardinality>
<destinationCardinality>0</destinationCardinality>
<referencesFieldUID><![CDATA[FB57A155-6A3E-4880-9AC0-AD50F2DB37D0]]></referencesFieldUID>
<referencesTableUID><![CDATA[11A718D2-DFDB-415C-96F3-E5A152F4A624]]></referencesTableUID>
<uid><![CDATA[37AB44B9-08C4-4BBE-8D81-12F93C44A4E6]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[fname]]></name>
<type><![CDATA[string]]></type>
<uid><![CDATA[43A14151-BC33-4226-9AF3-B1794FA48ED3]]></uid>
<unique><![CDATA[1]]></unique>
</SQLField>
<SQLField>
<name><![CDATA[sum]]></name>
<type><![CDATA[string(32)]]></type>
<uid><![CDATA[F4B2CD51-6490-4405-9E46-BC698F560409]]></uid>
<unique><![CDATA[1]]></unique>
</SQLField>
<SQLField>
<name><![CDATA[width]]></name>
<type><![CDATA[integer]]></type>
<uid><![CDATA[65555E1E-4617-4B79-915F-A8BEAB78EE69]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[height]]></name>
<type><![CDATA[integer]]></type>
<uid><![CDATA[0CF6B32F-D6F3-4A4C-AA1B-8BA9FB0170EE]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[size]]></name>
<type><![CDATA[integer]]></type>
<objectComment><![CDATA[Filesize in bytes]]></objectComment>
<uid><![CDATA[D8C0EAC9-3A66-4CC8-AAF9-E4A341A3CB38]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[created_at]]></name>
<type><![CDATA[datetime]]></type>
<forcedUnique><![CDATA[0]]></forcedUnique>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[510F079E-568E-40A3-A72E-2F5A718F0BFF]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[updated_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[81B8C5EC-12AF-404D-9098-2EE93870ECC9]]></uid>
</SQLField>
<labelWindowIndex><![CDATA[2]]></labelWindowIndex>
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
<uid><![CDATA[5EEF9ED1-20E6-46E3-AD1A-14E635B1B99D]]></uid>
</SQLTable>
<SQLTable>
<name><![CDATA[notes]]></name>
<schema><![CDATA[]]></schema>
<location>
<x>832.00</x>
<y>320.00</y>
</location>
<size>
<width>192.00</width>
<height>140.00</height>
</size>
<zorder>5</zorder>
<SQLField>
<name><![CDATA[id]]></name>
<type><![CDATA[integer]]></type>
<primaryKey>1</primaryKey>
<uid><![CDATA[EF78A6CC-26C2-489B-9B63-A5E8DEC745DB]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[recipe_id]]></name>
<type><![CDATA[integer]]></type>
<referencesField>id</referencesField>
<referencesTable>recipes</referencesTable>
<referencesField><![CDATA[id]]></referencesField>
<referencesTable><![CDATA[recipes]]></referencesTable>
<sourceCardinality>0</sourceCardinality>
<destinationCardinality>0</destinationCardinality>
<referencesFieldUID><![CDATA[FB57A155-6A3E-4880-9AC0-AD50F2DB37D0]]></referencesFieldUID>
<referencesTableUID><![CDATA[11A718D2-DFDB-415C-96F3-E5A152F4A624]]></referencesTableUID>
<uid><![CDATA[CD2F1148-9FFB-4A43-A6F2-F782EC2D5F29]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[note]]></name>
<type><![CDATA[text]]></type>
<uid><![CDATA[8E3EB260-ADDC-44FA-98FD-4B0E17F91944]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[created_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[3006A7C6-004C-4578-BD21-493459ABE173]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[updated_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[04C3234A-4091-4C56-A2A7-0FB6CBFEEF44]]></uid>
</SQLField>
<SQLConstraint>
<name><![CDATA[notes_cns_1]]></name>
<fieldName><![CDATA[recipe_id]]></fieldName>
<fieldName><![CDATA[note]]></fieldName>
<SQLIndexEntry>
<name><![CDATA[recipe_id]]></name>
<prefixSize><![CDATA[]]></prefixSize>
<fieldUid><![CDATA[CD2F1148-9FFB-4A43-A6F2-F782EC2D5F29]]></fieldUid>
</SQLIndexEntry>
<SQLIndexEntry>
<name><![CDATA[note]]></name>
<prefixSize><![CDATA[]]></prefixSize>
<fieldUid><![CDATA[8E3EB260-ADDC-44FA-98FD-4B0E17F91944]]></fieldUid>
</SQLIndexEntry>
<indexNamePrefix><![CDATA[notes]]></indexNamePrefix>
<indexType><![CDATA[UNIQUE]]></indexType>
<uid><![CDATA[116C2BF4-D613-482C-9160-83CBE530EDF4]]></uid>
</SQLConstraint>
<labelWindowIndex><![CDATA[1]]></labelWindowIndex>
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
<uid><![CDATA[F3906520-81E5-4D97-9D84-DFA54EEB1A49]]></uid>
</SQLTable>
<SQLTable>
<name><![CDATA[ingredients]]></name>
<schema><![CDATA[]]></schema>
<location>
<x>832.00</x>
<y>64.00</y>
</location>
<size>
<width>167.00</width>
<height>200.00</height>
</size>
<zorder>3</zorder>
<SQLField>
<name><![CDATA[id]]></name>
<type><![CDATA[integer]]></type>
<primaryKey>1</primaryKey>
<uid><![CDATA[E7664607-D569-4595-96EC-D879C4601408]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[recipe_id]]></name>
<type><![CDATA[integer]]></type>
<referencesField>id</referencesField>
<referencesTable>recipes</referencesTable>
<referencesField><![CDATA[id]]></referencesField>
<referencesTable><![CDATA[recipes]]></referencesTable>
<sourceCardinality>0</sourceCardinality>
<destinationCardinality>0</destinationCardinality>
<referencesFieldUID><![CDATA[FB57A155-6A3E-4880-9AC0-AD50F2DB37D0]]></referencesFieldUID>
<referencesTableUID><![CDATA[11A718D2-DFDB-415C-96F3-E5A152F4A624]]></referencesTableUID>
<uid><![CDATA[8C7FEE8A-9692-4EB7-9858-383883F57E39]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[qty]]></name>
<type><![CDATA[string]]></type>
<uid><![CDATA[B1C76163-99F4-482D-B229-D252287E522B]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[unit]]></name>
<type><![CDATA[string]]></type>
<uid><![CDATA[680B5AB7-8909-49D6-9A52-D79C529A565B]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[extra]]></name>
<type><![CDATA[string]]></type>
<uid><![CDATA[F32D6E0E-4313-400D-A0EB-6AAA7192F8C2]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[item]]></name>
<type><![CDATA[string]]></type>
<uid><![CDATA[1B63B930-C880-4422-BD1A-303DCC1F3D14]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[note]]></name>
<type><![CDATA[text]]></type>
<uid><![CDATA[718DF543-AEB6-4654-BF76-AEBF592E5FB9]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[created_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[175C80F8-B2B7-48A3-883B-A8E07AFC5983]]></uid>
</SQLField>
<SQLField>
<name><![CDATA[updated_at]]></name>
<type><![CDATA[datetime]]></type>
<notNull><![CDATA[1]]></notNull>
<uid><![CDATA[4283D46E-D841-48E9-BC33-9BD452BCA46A]]></uid>
</SQLField>
<labelWindowIndex><![CDATA[0]]></labelWindowIndex>
<ui.treeExpanded><![CDATA[1]]></ui.treeExpanded>
<uid><![CDATA[F628910C-B828-4B88-B01F-6CC34809B802]]></uid>
</SQLTable>
<SQLDocumentInfo>
<encodedPrintInfo><![CDATA[BAtzdHJlYW10eXBlZIHoA4QBQISEhAtOU1ByaW50SW5mbwGEhAhOU09iamVjdACFkoSEhBNOU011dGFibGVEaWN0aW9uYXJ5AISEDE5TRGljdGlvbmFyeQCUhAFpDZKEhIQITlNTdHJpbmcBlIQBKw5OU1BNUGFnZUZvcm1hdIaShISEDU5TTXV0YWJsZURhdGEAhIQGTlNEYXRhAJSXgbIbhAdbNzA5MGNdPD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPCFET0NUWVBFIHBsaXN0IFBVQkxJQyAiLS8vQXBwbGUvL0RURCBQTElTVCAxLjAvL0VOIiAiaHR0cDovL3d3dy5hcHBsZS5jb20vRFREcy9Qcm9wZXJ0eUxpc3QtMS4wLmR0ZCI+CjxwbGlzdCB2ZXJzaW9uPSIxLjAiPgo8ZGljdD4KCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1Ib3Jpem9udGFsUmVzPC9rZXk+Cgk8ZGljdD4KCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5pdGVtQXJyYXk8L2tleT4KCQk8YXJyYXk+CgkJCTxkaWN0PgoJCQkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFnZUZvcm1hdC5QTUhvcml6b250YWxSZXM8L2tleT4KCQkJCTxyZWFsPjcyPC9yZWFsPgoJCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LnN0YXRlRmxhZzwva2V5PgoJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJPC9kaWN0PgoJCTwvYXJyYXk+Cgk8L2RpY3Q+Cgk8a2V5PmNvbS5hcHBsZS5wcmludC5QYWdlRm9ybWF0LlBNT3JpZW50YXRpb248L2tleT4KCTxkaWN0PgoJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJPHN0cmluZz5jb20uYXBwbGUuam9idGlja2V0PC9zdHJpbmc+CgkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCTxhcnJheT4KCQkJPGRpY3Q+CgkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYWdlRm9ybWF0LlBNT3JpZW50YXRpb248L2tleT4KCQkJCTxpbnRlZ2VyPjE8L2ludGVnZXI+CgkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQk8L2RpY3Q+CgkJPC9hcnJheT4KCTwvZGljdD4KCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1TY2FsaW5nPC9rZXk+Cgk8ZGljdD4KCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5pdGVtQXJyYXk8L2tleT4KCQk8YXJyYXk+CgkJCTxkaWN0PgoJCQkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFnZUZvcm1hdC5QTVNjYWxpbmc8L2tleT4KCQkJCTxyZWFsPjE8L3JlYWw+CgkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQk8L2RpY3Q+CgkJPC9hcnJheT4KCTwvZGljdD4KCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1WZXJ0aWNhbFJlczwva2V5PgoJPGRpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LmNyZWF0b3I8L2tleT4KCQk8c3RyaW5nPmNvbS5hcHBsZS5qb2J0aWNrZXQ8L3N0cmluZz4KCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJPGFycmF5PgoJCQk8ZGljdD4KCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1WZXJ0aWNhbFJlczwva2V5PgoJCQkJPHJlYWw+NzI8L3JlYWw+CgkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQk8L2RpY3Q+CgkJPC9hcnJheT4KCTwvZGljdD4KCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1WZXJ0aWNhbFNjYWxpbmc8L2tleT4KCTxkaWN0PgoJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJPHN0cmluZz5jb20uYXBwbGUuam9idGlja2V0PC9zdHJpbmc+CgkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCTxhcnJheT4KCQkJPGRpY3Q+CgkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYWdlRm9ybWF0LlBNVmVydGljYWxTY2FsaW5nPC9rZXk+CgkJCQk8cmVhbD4xPC9yZWFsPgoJCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LnN0YXRlRmxhZzwva2V5PgoJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJPC9kaWN0PgoJCTwvYXJyYXk+Cgk8L2RpY3Q+Cgk8a2V5PmNvbS5hcHBsZS5wcmludC5zdWJUaWNrZXQucGFwZXJfaW5mb190aWNrZXQ8L2tleT4KCTxkaWN0PgoJCTxrZXk+UE1QUERQYXBlckNvZGVOYW1lPC9rZXk+CgkJPGRpY3Q+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJCTxhcnJheT4KCQkJCTxkaWN0PgoJCQkJCTxrZXk+UE1QUERQYXBlckNvZGVOYW1lPC9rZXk+CgkJCQkJPHN0cmluZz5MZXR0ZXI8L3N0cmluZz4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5QTVBQRFRyYW5zbGF0aW9uU3RyaW5nUGFwZXJOYW1lPC9rZXk+CgkJPGRpY3Q+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJCTxhcnJheT4KCQkJCTxkaWN0PgoJCQkJCTxrZXk+UE1QUERUcmFuc2xhdGlvblN0cmluZ1BhcGVyTmFtZTwva2V5PgoJCQkJCTxzdHJpbmc+VVMgTGV0dGVyPC9zdHJpbmc+CgkJCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LnN0YXRlRmxhZzwva2V5PgoJCQkJCTxpbnRlZ2VyPjA8L2ludGVnZXI+CgkJCQk8L2RpY3Q+CgkJCTwvYXJyYXk+CgkJPC9kaWN0PgoJCTxrZXk+UE1UaW9nYVBhcGVyTmFtZTwva2V5PgoJCTxkaWN0PgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCQk8c3RyaW5nPmNvbS5hcHBsZS5qb2J0aWNrZXQ8L3N0cmluZz4KCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCQk8YXJyYXk+CgkJCQk8ZGljdD4KCQkJCQk8a2V5PlBNVGlvZ2FQYXBlck5hbWU8L2tleT4KCQkJCQk8c3RyaW5nPm5hLWxldHRlcjwvc3RyaW5nPgoJCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5zdGF0ZUZsYWc8L2tleT4KCQkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQkJPC9kaWN0PgoJCQk8L2FycmF5PgoJCTwvZGljdD4KCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYWdlRm9ybWF0LlBNQWRqdXN0ZWRQYWdlUmVjdDwva2V5PgoJCTxkaWN0PgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCQk8c3RyaW5nPmNvbS5hcHBsZS5qb2J0aWNrZXQ8L3N0cmluZz4KCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCQk8YXJyYXk+CgkJCQk8ZGljdD4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYWdlRm9ybWF0LlBNQWRqdXN0ZWRQYWdlUmVjdDwva2V5PgoJCQkJCTxhcnJheT4KCQkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCQkJPHJlYWw+NzM0PC9yZWFsPgoJCQkJCQk8cmVhbD41NzY8L3JlYWw+CgkJCQkJPC9hcnJheT4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFnZUZvcm1hdC5QTUFkanVzdGVkUGFwZXJSZWN0PC9rZXk+CgkJPGRpY3Q+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJCTxhcnJheT4KCQkJCTxkaWN0PgoJCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhZ2VGb3JtYXQuUE1BZGp1c3RlZFBhcGVyUmVjdDwva2V5PgoJCQkJCTxhcnJheT4KCQkJCQkJPHJlYWw+LTE4PC9yZWFsPgoJCQkJCQk8cmVhbD4tMTg8L3JlYWw+CgkJCQkJCTxyZWFsPjc3NDwvcmVhbD4KCQkJCQkJPHJlYWw+NTk0PC9yZWFsPgoJCQkJCTwvYXJyYXk+CgkJCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LnN0YXRlRmxhZzwva2V5PgoJCQkJCTxpbnRlZ2VyPjA8L2ludGVnZXI+CgkJCQk8L2RpY3Q+CgkJCTwvYXJyYXk+CgkJPC9kaWN0PgoJCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhcGVySW5mby5QTVBQRFBhcGVyRGltZW5zaW9uPC9rZXk+CgkJPGRpY3Q+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJCTxhcnJheT4KCQkJCTxkaWN0PgoJCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhcGVySW5mby5QTVBQRFBhcGVyRGltZW5zaW9uPC9rZXk+CgkJCQkJPGFycmF5PgoJCQkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQkJCQk8cmVhbD42MTI8L3JlYWw+CgkJCQkJCTxyZWFsPjc5MjwvcmVhbD4KCQkJCQk8L2FycmF5PgoJCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5zdGF0ZUZsYWc8L2tleT4KCQkJCQk8aW50ZWdlcj4wPC9pbnRlZ2VyPgoJCQkJPC9kaWN0PgoJCQk8L2FycmF5PgoJCTwvZGljdD4KCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYXBlckluZm8uUE1QYXBlck5hbWU8L2tleT4KCQk8ZGljdD4KCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LmNyZWF0b3I8L2tleT4KCQkJPHN0cmluZz5jb20uYXBwbGUuam9idGlja2V0PC9zdHJpbmc+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5pdGVtQXJyYXk8L2tleT4KCQkJPGFycmF5PgoJCQkJPGRpY3Q+CgkJCQkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFwZXJJbmZvLlBNUGFwZXJOYW1lPC9rZXk+CgkJCQkJPHN0cmluZz5uYS1sZXR0ZXI8L3N0cmluZz4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFwZXJJbmZvLlBNVW5hZGp1c3RlZFBhZ2VSZWN0PC9rZXk+CgkJPGRpY3Q+CgkJCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5jcmVhdG9yPC9rZXk+CgkJCTxzdHJpbmc+Y29tLmFwcGxlLmpvYnRpY2tldDwvc3RyaW5nPgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuaXRlbUFycmF5PC9rZXk+CgkJCTxhcnJheT4KCQkJCTxkaWN0PgoJCQkJCTxrZXk+Y29tLmFwcGxlLnByaW50LlBhcGVySW5mby5QTVVuYWRqdXN0ZWRQYWdlUmVjdDwva2V5PgoJCQkJCTxhcnJheT4KCQkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCQkJPHJlYWw+NzM0PC9yZWFsPgoJCQkJCQk8cmVhbD41NzY8L3JlYWw+CgkJCQkJPC9hcnJheT4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFwZXJJbmZvLlBNVW5hZGp1c3RlZFBhcGVyUmVjdDwva2V5PgoJCTxkaWN0PgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCQk8c3RyaW5nPmNvbS5hcHBsZS5qb2J0aWNrZXQ8L3N0cmluZz4KCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCQk8YXJyYXk+CgkJCQk8ZGljdD4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYXBlckluZm8uUE1VbmFkanVzdGVkUGFwZXJSZWN0PC9rZXk+CgkJCQkJPGFycmF5PgoJCQkJCQk8cmVhbD4tMTg8L3JlYWw+CgkJCQkJCTxyZWFsPi0xODwvcmVhbD4KCQkJCQkJPHJlYWw+Nzc0PC9yZWFsPgoJCQkJCQk8cmVhbD41OTQ8L3JlYWw+CgkJCQkJPC9hcnJheT4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQuUGFwZXJJbmZvLnBwZC5QTVBhcGVyTmFtZTwva2V5PgoJCTxkaWN0PgoJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuY3JlYXRvcjwva2V5PgoJCQk8c3RyaW5nPmNvbS5hcHBsZS5qb2J0aWNrZXQ8L3N0cmluZz4KCQkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0Lml0ZW1BcnJheTwva2V5PgoJCQk8YXJyYXk+CgkJCQk8ZGljdD4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC5QYXBlckluZm8ucHBkLlBNUGFwZXJOYW1lPC9rZXk+CgkJCQkJPHN0cmluZz5MZXR0ZXI8L3N0cmluZz4KCQkJCQk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQuc3RhdGVGbGFnPC9rZXk+CgkJCQkJPGludGVnZXI+MDwvaW50ZWdlcj4KCQkJCTwvZGljdD4KCQkJPC9hcnJheT4KCQk8L2RpY3Q+CgkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LkFQSVZlcnNpb248L2tleT4KCQk8c3RyaW5nPjAwLjIwPC9zdHJpbmc+CgkJPGtleT5jb20uYXBwbGUucHJpbnQudGlja2V0LnR5cGU8L2tleT4KCQk8c3RyaW5nPmNvbS5hcHBsZS5wcmludC5QYXBlckluZm9UaWNrZXQ8L3N0cmluZz4KCTwvZGljdD4KCTxrZXk+Y29tLmFwcGxlLnByaW50LnRpY2tldC5BUElWZXJzaW9uPC9rZXk+Cgk8c3RyaW5nPjAwLjIwPC9zdHJpbmc+Cgk8a2V5PmNvbS5hcHBsZS5wcmludC50aWNrZXQudHlwZTwva2V5PgoJPHN0cmluZz5jb20uYXBwbGUucHJpbnQuUGFnZUZvcm1hdFRpY2tldDwvc3RyaW5nPgo8L2RpY3Q+CjwvcGxpc3Q+CoaShJmZC05TUGFwZXJTaXplhpKEhIQHTlNWYWx1ZQCUhAEqhIQLe0NHU2l6ZT1kZH2fgWQCgRgDhpKEmZkWTlNIb3Jpem9udGFsbHlDZW50ZXJlZIaShISECE5TTnVtYmVyAJ+ehIQBY6EBhpKEmZkUTlNWZXJ0aWNhbGx5Q2VudGVyZWSGkqKShJmZDE5TTGVmdE1hcmdpboaShKOehIQBZKIShpKEmZkNTlNSaWdodE1hcmdpboaSp5KEmZkLTlNUb3BNYXJnaW6GkoSjnqiiHoaShJmZDU5TT3JpZW50YXRpb26GkoSjnoSEAXGjAIaShJmZFU5TSG9yaXpvbmFsUGFnaW5hdGlvboaSrZKEmZkUTlNWZXJ0aWNhbFBhZ2luYXRpb26Gkq2ShJmZDk5TQm90dG9tTWFyZ2luhpKEo56oojSGkoSZmQtOU1BhcGVyTmFtZYaShJmZCW5hLWxldHRlcoaShJmZD05TU2NhbGluZ0ZhY3RvcoaShKOeqKIBhoaG]]></encodedPrintInfo>
<autoSizeTablesOption><![CDATA[1]]></autoSizeTablesOption>
<documentScaleFactor><![CDATA[1]]></documentScaleFactor>
<exportDialect><![CDATA[Rails]]></exportDialect>
<fileversion><![CDATA[4]]></fileversion>
<generator><![CDATA[com.malcolmhardie.sqleditor]]></generator>
<generatorVersion><![CDATA[3.2.2]]></generatorVersion>
<hideFieldIcons><![CDATA[0]]></hideFieldIcons>
<hideFieldTypes><![CDATA[0]]></hideFieldTypes>
<overviewPanelHidden><![CDATA[0]]></overviewPanelHidden>
<pageBoundariesVisible><![CDATA[0]]></pageBoundariesVisible>
<PageGridVisible><![CDATA[1]]></PageGridVisible>
<RightSidebarWidth><![CDATA[1163.000000]]></RightSidebarWidth>
<sidebarIndex><![CDATA[1]]></sidebarIndex>
<snapToGrid><![CDATA[1]]></snapToGrid>
<SourceSidebarWidth><![CDATA[312.000000]]></SourceSidebarWidth>
<SQLEditorFileFormatVersion><![CDATA[4]]></SQLEditorFileFormatVersion>
<uid><![CDATA[F3BE7F82-9B86-4020-8CD0-44948D2EE8A4]]></uid>
<windowHeight><![CDATA[872.000000]]></windowHeight>
<windowLocationX><![CDATA[0.000000]]></windowLocationX>
<windowLocationY><![CDATA[5.000000]]></windowLocationY>
<windowScrollOrigin><![CDATA[{38, 0}]]></windowScrollOrigin>
<windowWidth><![CDATA[1440.000000]]></windowWidth>
</SQLDocumentInfo>
<AllowsIndexRenamingOnInsert><![CDATA[1]]></AllowsIndexRenamingOnInsert>
<containerName><![CDATA[model controller orginal container]]></containerName>
<defaultLabelExpanded><![CDATA[1]]></defaultLabelExpanded>
<ui.treeDisplayMode><![CDATA[0]]></ui.treeDisplayMode>
</SQLContainer>