Context Navigation

source: trunk/expressoCalendar/setup/tables_current.inc.php @ 6111

Revision 6111, 15.0 KB checked in by natan, 12 years ago (diff)
Ticket #2141 - Eventos com repeticao nao dispara notificacao nos alarmes - implementação final

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

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

Download in other formats: