Context Navigation

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

Revision 6876, 15.6 KB checked in by acoutinho, 12 years ago (diff)
Ticket #2966 - Criacao e edicao de tarefas / suporte a anexos, alarmes, participantes e mapa de disponibilidade

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
105	'calendar_object' => array(
106	'fd' => array(
107	'id' => array( 'type' => 'auto', 'nullable' => False),
108	'type_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
109	'cal_uid' => array( 'type' => 'varchar','precision' => '255', 'nullable' => True),
110	'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => True ),
111	'dtstart' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False),
112	'description' => array( 'type' => 'text', 'nullable' => True),
113	'dtend' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => True),
114	'location' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True),
115	'class_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True),
116	'last_update' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
117	'range_end' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => True),
118	'summary' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True),
119	'range_start' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => True),
120	'allday' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => True),
121	'repeat' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => True),
122	'tzid' => array('type' => 'varchar', 'precision' => '50' ,'nullable' => True),
123	'transp' => array( 'type' => 'int', 'precision' => '2', 'nullable' => FALSE , 'default' => 0 ),
124	'sequence' => array( 'type' => 'int', 'precision' => '8', 'nullable' => FALSE , 'default' => 0 ),
125	'due' => array( 'type' => 'int', 'precision' => '8', 'nullable' => FALSE , 'default' => 0 ),
126	'percentage' => array( 'type' => 'int', 'precision' => '8', 'nullable' => FALSE , 'default' => 0 ),
127	'status' => array( 'type' => 'int', 'precision' => '8', 'nullable' => FALSE , 'default' => 0 ),
128	'priority' => array( 'type' => 'int', 'precision' => '8', 'nullable' => FALSE , 'default' => 2 )
129	),
130	'pk' => array('id'),
131	'fk' => array(),
132	'ix' => array(),
133	'uc' => array('cal_uid')
134	),
135
136
137	'calendar_participant' => array(
138	'fd' => array(
139	'id' => array( 'type' => 'auto', 'nullable' => False),
140	'user_info_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
141	'object_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True),
142	'delegated_from' => array( 'type' => 'int', 'precision' => '8','default' => 0, 'nullable' => False),
143	'is_organizer' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => False),
144	'is_external' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => False),
145	'participant_status_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => false , 'default' => 4),
146	'acl' => array('type' => 'varchar', 'precision' => '10' ,'default' => 'r', 'nullable' => False),
147	'receive_notification' => array( 'type' => 'int', 'precision' => '2', 'default' => 1, 'nullable' => False)
148	),
149	'pk' => array('id'),
150	'fk' => array(),
151	'ix' => array(),
152	'uc' => array()
153	),
154
155	'calendar_alarm' => array(
156	'fd' => array(
157	'id' => array( 'type' => 'auto', 'nullable' => False),
158	'action_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
159	'unit' => array('type' => 'varchar','precision' => '20','nullable' => True),
160	'alarm_offset' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False),
161	'time' => array('type' => 'varchar','precision' => '50','nullable' => True),
162	'participant_id' => array('type' => 'int', 'precision' => '8','nullable' => True),
163	'object_id' => array('type' => 'int', 'precision' => '8','nullable' => True),
164	'sent' => array('type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => False)
165
166	),
167	'pk' => array('id'),
168	'fk' => array(),
169	'ix' => array(),
170	'uc' => array()
171	),
172
173
174	'calendar_signature_alarm' => array(
175	'fd' => array(
176	'id' => array( 'type' => 'auto', 'nullable' => False),
177	'action_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
178	'unit' => array('type' => 'varchar','precision' => '20','nullable' => True),
179	'time' => array('type' => 'varchar','precision' => '50','nullable' => True),
180	'calendar_signature_id' => array('type' => 'int', 'precision' => '8','nullable' => FALSE),
181	),
182	'pk' => array('id'),
183	'fk' => array(),
184	'ix' => array(),
185	'uc' => array()
186	),
187
188	'calendar_ex_participant' => array(
189	'fd' => array(
190	'id' => array( 'type' => 'auto', 'nullable' => False),
191	'name' => array( 'type' => 'varchar','precision' => '100', 'nullable' => True),
192	'mail' => array( 'type' => 'varchar','precision' => '100', 'nullable' => False),
193	'owner' => array( 'type' => 'int','precision' => '8', 'nullable' => False)
194	),
195	'pk' => array('id'),
196	'fk' => array(),
197	'ix' => array(),
198	'uc' => array()
199	),
200
201
202
203	'calendar_permission' => array(
204	'fd' => array(
205	'id' => array( 'type' => 'auto', 'nullable' => False),
206	'uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
207	'object_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
208	'object_type' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
209	'permission' => array( 'type' => 'varchar','precision' => '50', 'nullable' => False)
210	),
211	'pk' => array('id'),
212	'fk' => array(),
213	'ix' => array(),
214	'uc' => array()
215	),
216
217	'calendar_repeat' => array(
218	'fd' => array(
219	'id' => array( 'type' => 'auto', 'nullable' => False),
220	'frequency' => array( 'type' => 'varchar','precision' => '20', 'nullable' => False),
221	'until' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True),
222	'dtstart' => array( 'type' => 'bigint','precision' => '16', 'nullable' => True),
223	'count' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True),
224	'object_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
225	'bysecond' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
226	'byminute' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
227	'byhour' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
228	'byday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
229	'bymonthday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
230	'byyearday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
231	'byweekno' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
232	'bymonth' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
233	'bysetpos' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
234	'wkst' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
235	'exceptions' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
236	'interval' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True)
237	),
238	'pk' => array('id'),
239	'fk' => array(),
240	'ix' => array(),
241	'uc' => array()
242	),
243
244	'calendar_repeat_ranges' => array(
245	'fd' => array(
246	'id' => array( 'type' => 'auto', 'nullable' => False),
247	'range_start' => array( 'type' => 'bigint','precision' => '16', 'nullable' => False),
248	'range_end' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False),
249	'user_info_id' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False)
250	),
251	'pk' => array('id'),
252	'fk' => array(),
253	'ix' => array(),
254	'uc' => array()
255	),
256
257	'calendar_repeat_occurrence' => array(
258	'fd' => array(
259	'id' => array( 'type' => 'auto', 'nullable' => False),
260	'occurrence' => array( 'type' => 'bigint','precision' => '16', 'nullable' => False),
261	'exception' => array( 'type' => 'smallint','precision' => '1', 'nullable' => False, 'default' => 0),
262	'repeat_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False)
263	),
264
265	'pk' => array('id'),
266	'fk' => array('repeat_id'),
267	'ix' => array(),
268	'uc' => array()
269	),
270
271	'calendar_signature' => array(
272	'fd' => array(
273	'id' => array( 'type' => 'auto', 'nullable' => False),
274	'user_uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
275	'calendar_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => false),
276	'is_owner' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => False),
277	'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'precision' => '16', 'nullable' => False),
278	'msg_add' => array( 'type' => 'text', 'nullable' => True),
279	'msg_cancel' => array( 'type' => 'text', 'nullable' => True),
280	'msg_update' => array( 'type' => 'text', 'nullable' => True),
281	'msg_reply' => array( 'type' => 'text', 'nullable' => True),
282	'msg_alarms' => array( 'type' => 'text', 'nullable' => True),
283	'font_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True),
284	'background_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True),
285	'border_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True),
286	'type' => array('type' => 'int', 'precision' => '2' ,'nullable' => false, 'default' => 0)
287	),
288	'pk' => array('id'),
289	'fk' => array(),
290	'ix' => array(),
291	'uc' => array()
292	),
293
294
295	'module_preference' => array(
296	'fd' => array(
297	'id' => array( 'type' => 'auto', 'nullable' => False),
298	'user_uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
299	'value' => array( 'type' => 'varchar','precision' => '100','nullable' => False),
300	'name' => array( 'type' => 'varchar', 'precision' => '50', 'nullable' => False),
301	'module' => array( 'type' => 'varchar', 'precision' => '30', 'nullable' => False)
302	),
303	'pk' => array('id'),
304	'fk' => array(),
305	'ix' => array(),
306	'uc' => array()
307	),
308
309	);
310	?>

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

Download in other formats: