Context Navigation

source: sandbox/2.4.2-expresso1/expressoCalendar/setup/tables_current.inc.php @ 6945

Revision 6945, 16.2 KB checked in by acoutinho, 12 years ago (diff)
Ticket #2966 - Criacao de atividades com suporte a alarmes e anexos

Line
1	<?php
2	/**************************************************************************\
3	* eGroupWare *
4	* http://www.egroupware.org *
5	* -------------------------------------------- *
6	* This program is free software; you can redistribute it and/or modify it *
7	* under the terms of the GNU General Public License as published by the *
8	* Free Software Foundation; either version 2 of the License, or (at your *
9	* option) any later version. *
10	\**************************************************************************/
11
12
13	$phpgw_baseline = array(
14
15	'calendar_attach' => array(
16	'fd' => array(
17	'id' => array('type' => 'auto','nullable' => False),
18	'object_id' => array('type' => 'int', 'precision' => '8','nullable' => True),
19	'attach_id' => array('type' => 'int', 'precision' => '8','nullable' => True)
20	),
21	'pk' => array('id'),
22	'fk' => array(),
23	'ix' => array(),
24	'uc' => array()
25	),
26
27	'attachment' => array(
28	'fd' => array(
29	'id' => array('type' => 'auto','nullable' => False),
30	'source' => array('type' => 'blob','nullable' => False),
31	'type' => array('type' => 'varchar','precision' => '50','nullable' => False),
32	'name' => array('type' => 'varchar','precision' => '255','nullable' => False),
33	'size' => array('type' => 'varchar','precision' => '255','nullable' => False),
34	'owner' => array('type' => 'int', 'precision' => '8','nullable' => True)
35	),
36	'pk' => array('id'),
37	'fk' => array(),
38	'ix' => array(),
39	'uc' => array()
40	),
41
42	'calendar' => array(
43	'fd' => array(
44	'id' => array( 'type' => 'auto', 'nullable' => False),
45	'name' => array( 'type' => 'varchar','precision' => '150', 'nullable' => False),
46	'location' => array( 'type' => 'varchar','precision' => '150', 'nullable' => False),
47	'description' => array('type' => 'text', 'nullable' => True),
48	'duration' => array('type' => 'int', 'precision' => '8' ,'nullable' => True),
49	'tzid' => array('type' => 'varchar', 'precision' => '50' ,'nullable' => True),
50	'type' => array('type' => 'int', 'precision' => '2' ,'nullable' => false, 'default' => 0),
51	'dtstamp' => array('type' => 'int', 'precision' => '8' ,'nullable' => True)
52	),
53	'pk' => array('id'),
54	'fk' => array(),
55	'ix' => array(),
56	'uc' => array()
57	),
58
59	'calendar_class' => array(
60	'fd' => array(
61	'id' => array( 'type' => 'auto', 'nullable' => False),
62	'name' => array( 'type' => 'varchar','precision' => '50', 'nullable' => False)
63	),
64	'pk' => array('id'),
65	'fk' => array(),
66	'ix' => array(),
67	'uc' => array()
68	),
69
70	'calendar_object_type' => array(
71	'fd' => array(
72	'id' => array( 'type' => 'auto', 'nullable' => False),
73	'name' => array( 'type' => 'varchar','precision' => '50', 'nullable' => False)
74	),
75	'pk' => array('id'),
76	'fk' => array(),
77	'ix' => array(),
78	'uc' => array()
79	),
80
81	'calendar_participant_status' => array(
82	'fd' => array(
83	'id' => array( 'type' => 'auto', 'nullable' => False),
84	'name' => array( 'type' => 'varchar','precision' => '50', 'nullable' => False)
85	),
86	'pk' => array('id'),
87	'fk' => array(),
88	'ix' => array(),
89	'uc' => array()
90	),
91
92	'calendar_to_calendar_object' => array(
93	'fd' => array(
94	'id' => array( 'type' => 'auto', 'nullable' => False),
95	'calendar_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
96	'calendar_object_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
97	),
98	'pk' => array('id'),
99	'fk' => array(),
100	'ix' => array(),
101	'uc' => array()
102	),
103
104	'calendar_task_to_activity_object' => array(
105	'fd' => array(
106	'id' => array( 'type' => 'auto', 'nullable' => False),
107	'calendar_object_activity_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
108	'calendar_object_task_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
109	'owner' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
110	),
111	'pk' => array('id'),
112	'fk' => array(),
113	'ix' => array(),
114	'uc' => array()
115	),
116
117
118	'calendar_object' => array(
119	'fd' => array(
120	'id' => array( 'type' => 'auto', 'nullable' => False),
121	'type_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
122	'cal_uid' => array( 'type' => 'varchar','precision' => '255', 'nullable' => True),
123	'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => True ),
124	'dtstart' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False),
125	'description' => array( 'type' => 'text', 'nullable' => True),
126	'dtend' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => True),
127	'location' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True),
128	'class_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True),
129	'last_update' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
130	'range_end' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => True),
131	'summary' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True),
132	'range_start' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => True),
133	'allday' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => True),
134	'repeat' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => True),
135	'tzid' => array('type' => 'varchar', 'precision' => '50' ,'nullable' => True),
136	'transp' => array( 'type' => 'int', 'precision' => '2', 'nullable' => FALSE , 'default' => 0 ),
137	'sequence' => array( 'type' => 'int', 'precision' => '8', 'nullable' => FALSE , 'default' => 0 ),
138	'due' => array( 'type' => 'int', 'precision' => '8', 'nullable' => FALSE , 'default' => 0 ),
139	'percentage' => array( 'type' => 'int', 'precision' => '8', 'nullable' => FALSE , 'default' => 0 ),
140	'status' => array( 'type' => 'int', 'precision' => '8', 'nullable' => FALSE , 'default' => 0 ),
141	'priority' => array( 'type' => 'int', 'precision' => '8', 'nullable' => FALSE , 'default' => 2 )
142	),
143	'pk' => array('id'),
144	'fk' => array(),
145	'ix' => array(),
146	'uc' => array('cal_uid')
147	),
148
149
150	'calendar_participant' => array(
151	'fd' => array(
152	'id' => array( 'type' => 'auto', 'nullable' => False),
153	'user_info_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
154	'object_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True),
155	'delegated_from' => array( 'type' => 'int', 'precision' => '8','default' => 0, 'nullable' => False),
156	'is_organizer' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => False),
157	'is_external' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => False),
158	'participant_status_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => false , 'default' => 4),
159	'acl' => array('type' => 'varchar', 'precision' => '10' ,'default' => 'r', 'nullable' => False),
160	'receive_notification' => array( 'type' => 'int', 'precision' => '2', 'default' => 1, 'nullable' => False)
161	),
162	'pk' => array('id'),
163	'fk' => array(),
164	'ix' => array(),
165	'uc' => array()
166	),
167
168	'calendar_alarm' => array(
169	'fd' => array(
170	'id' => array( 'type' => 'auto', 'nullable' => False),
171	'action_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
172	'unit' => array('type' => 'varchar','precision' => '20','nullable' => True),
173	'alarm_offset' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False),
174	'time' => array('type' => 'varchar','precision' => '50','nullable' => True),
175	'participant_id' => array('type' => 'int', 'precision' => '8','nullable' => True),
176	'object_id' => array('type' => 'int', 'precision' => '8','nullable' => True),
177	'sent' => array('type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => False)
178
179	),
180	'pk' => array('id'),
181	'fk' => array(),
182	'ix' => array(),
183	'uc' => array()
184	),
185
186
187	'calendar_signature_alarm' => array(
188	'fd' => array(
189	'id' => array( 'type' => 'auto', 'nullable' => False),
190	'action_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
191	'unit' => array('type' => 'varchar','precision' => '20','nullable' => True),
192	'time' => array('type' => 'varchar','precision' => '50','nullable' => True),
193	'calendar_signature_id' => array('type' => 'int', 'precision' => '8','nullable' => FALSE),
194	),
195	'pk' => array('id'),
196	'fk' => array(),
197	'ix' => array(),
198	'uc' => array()
199	),
200
201	'calendar_ex_participant' => array(
202	'fd' => array(
203	'id' => array( 'type' => 'auto', 'nullable' => False),
204	'name' => array( 'type' => 'varchar','precision' => '100', 'nullable' => True),
205	'mail' => array( 'type' => 'varchar','precision' => '100', 'nullable' => False),
206	'owner' => array( 'type' => 'int','precision' => '8', 'nullable' => False)
207	),
208	'pk' => array('id'),
209	'fk' => array(),
210	'ix' => array(),
211	'uc' => array()
212	),
213
214
215
216	'calendar_permission' => array(
217	'fd' => array(
218	'id' => array( 'type' => 'auto', 'nullable' => False),
219	'uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
220	'object_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
221	'object_type' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
222	'permission' => array( 'type' => 'varchar','precision' => '50', 'nullable' => False)
223	),
224	'pk' => array('id'),
225	'fk' => array(),
226	'ix' => array(),
227	'uc' => array()
228	),
229
230	'calendar_repeat' => array(
231	'fd' => array(
232	'id' => array( 'type' => 'auto', 'nullable' => False),
233	'frequency' => array( 'type' => 'varchar','precision' => '20', 'nullable' => False),
234	'until' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True),
235	'dtstart' => array( 'type' => 'bigint','precision' => '16', 'nullable' => True),
236	'count' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True),
237	'object_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
238	'bysecond' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
239	'byminute' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
240	'byhour' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
241	'byday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
242	'bymonthday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
243	'byyearday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
244	'byweekno' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
245	'bymonth' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
246	'bysetpos' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
247	'wkst' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
248	'exceptions' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
249	'interval' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True)
250	),
251	'pk' => array('id'),
252	'fk' => array(),
253	'ix' => array(),
254	'uc' => array()
255	),
256
257	'calendar_repeat_ranges' => array(
258	'fd' => array(
259	'id' => array( 'type' => 'auto', 'nullable' => False),
260	'range_start' => array( 'type' => 'bigint','precision' => '16', 'nullable' => False),
261	'range_end' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False),
262	'user_info_id' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False)
263	),
264	'pk' => array('id'),
265	'fk' => array(),
266	'ix' => array(),
267	'uc' => array()
268	),
269
270	'calendar_repeat_occurrence' => array(
271	'fd' => array(
272	'id' => array( 'type' => 'auto', 'nullable' => False),
273	'occurrence' => array( 'type' => 'bigint','precision' => '16', 'nullable' => False),
274	'exception' => array( 'type' => 'smallint','precision' => '1', 'nullable' => False, 'default' => 0),
275	'repeat_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False)
276	),
277
278	'pk' => array('id'),
279	'fk' => array('repeat_id'),
280	'ix' => array(),
281	'uc' => array()
282	),
283
284	'calendar_signature' => array(
285	'fd' => array(
286	'id' => array( 'type' => 'auto', 'nullable' => False),
287	'user_uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
288	'calendar_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => false),
289	'is_owner' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => False),
290	'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'precision' => '16', 'nullable' => False),
291	'msg_add' => array( 'type' => 'text', 'nullable' => True),
292	'msg_cancel' => array( 'type' => 'text', 'nullable' => True),
293	'msg_update' => array( 'type' => 'text', 'nullable' => True),
294	'msg_reply' => array( 'type' => 'text', 'nullable' => True),
295	'msg_alarms' => array( 'type' => 'text', 'nullable' => True),
296	'font_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True),
297	'background_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True),
298	'border_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True),
299	'type' => array('type' => 'int', 'precision' => '2' ,'nullable' => false, 'default' => 0)
300	),
301	'pk' => array('id'),
302	'fk' => array(),
303	'ix' => array(),
304	'uc' => array()
305	),
306
307
308	'module_preference' => array(
309	'fd' => array(
310	'id' => array( 'type' => 'auto', 'nullable' => False),
311	'user_uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
312	'value' => array( 'type' => 'varchar','precision' => '100','nullable' => False),
313	'name' => array( 'type' => 'varchar', 'precision' => '50', 'nullable' => False),
314	'module' => array( 'type' => 'varchar', 'precision' => '30', 'nullable' => False)
315	),
316	'pk' => array('id'),
317	'fk' => array(),
318	'ix' => array(),
319	'uc' => array()
320	),
321
322	);
323	?>

Note: See TracBrowser for help on using the repository browser.

Download in other formats: