Context Navigation

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

Revision 5341, 13.6 KB checked in by wmerlotto, 12 years ago (diff)
Ticket #2434 - Commit inicial do novo módulo de agenda do Expresso - expressoCalendar

Rev	Line
[5341]	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	),
	35	'pk' => array('id'),
	36	'fk' => array(),
	37	'ix' => array(),
	38	'uc' => array()
	39	),
	40
	41
	42
	43	'calendar' => array(
	44	'fd' => array(
	45	'id' => array( 'type' => 'auto', 'nullable' => False),
	46	'name' => array( 'type' => 'varchar','precision' => '150', 'nullable' => False),
	47	'location' => array( 'type' => 'varchar','precision' => '150', 'nullable' => False),
	48	'description' => array('type' => 'text', 'nullable' => True),
	49	'duration' => array('type' => 'int', 'precision' => '8' ,'nullable' => True),
	50	'tzid' => array('type' => 'varchar', 'precision' => '50' ,'nullable' => True),
	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' => 'date', 'nullable' => True),
	118	'summary' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True),
	119	'range_start' => array( 'type' => 'date', 'nullable' => False),
	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	),
	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_to' => 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	),
	142	'pk' => array('id'),
	143	'fk' => array(),
	144	'ix' => array(),
	145	'uc' => array()
	146	),
	147
	148	'calendar_alarm' => array(
	149	'fd' => array(
	150	'id' => array( 'type' => 'auto', 'nullable' => False),
	151	'action_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
	152	'range_end' => array('type' => 'date', 'nullable' => False),
	153	'range_start' => array('type' => 'date', 'nullable' => False),
	154	'unit' => array('type' => 'varchar','precision' => '20','nullable' => True),
	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	'permision' => 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' => False),
	216	'count' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True),
	217	'object_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
	218	'bysecond' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
	219	'byminute' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
	220	'byhour' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
	221	'byday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
	222	'bymonthday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
	223	'byyearday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
	224	'byweekno' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
	225	'bymonth' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
	226	'bysetpos' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
	227	'wkst' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True),
	228	'interval' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True)
	229	),
	230	'pk' => array('id'),
	231	'fk' => array(),
	232	'ix' => array(),
	233	'uc' => array()
	234	),
	235
	236	'calendar_signature' => array(
	237	'fd' => array(
	238	'id' => array( 'type' => 'auto', 'nullable' => False),
	239	'user_uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
	240	'calendar_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => false),
	241	'is_owner' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => False),
	242	'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'precision' => '16', 'nullable' => False),
	243	'msg_add' => array( 'type' => 'text', 'nullable' => True),
	244	'msg_cancel' => array( 'type' => 'text', 'nullable' => True),
	245	'msg_update' => array( 'type' => 'text', 'nullable' => True),
	246	'msg_reply' => array( 'type' => 'text', 'nullable' => True),
	247	'msg_alarms' => array( 'type' => 'text', 'nullable' => True),
	248	'font_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True),
	249	'background_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True),
	250	'border_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True)
	251
	252	),
	253	'pk' => array('id'),
	254	'fk' => array(),
	255	'ix' => array(),
	256	'uc' => array()
	257	),
	258
	259
	260	'module_preference' => array(
	261	'fd' => array(
	262	'id' => array( 'type' => 'auto', 'nullable' => False),
	263	'user_uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
	264	'value' => array( 'type' => 'varchar','precision' => '100','nullable' => False),
	265	'name' => array( 'type' => 'varchar', 'precision' => '50', 'nullable' => False),
	266	'module' => array( 'type' => 'varchar', 'precision' => '30', 'nullable' => False)
	267	),
	268	'pk' => array('id'),
	269	'fk' => array(),
	270	'ix' => array(),
	271	'uc' => array()
	272	),
	273
	274	);
	275	?>

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

Download in other formats: