Changeset 6996 for trunk/expressoCalendar/setup/tables_current.inc.php
- Timestamp:
- 08/10/12 19:11:37 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/expressoCalendar/setup/tables_current.inc.php
r6114 r6996 48 48 'duration' => array('type' => 'int', 'precision' => '8' ,'nullable' => True), 49 49 'tzid' => array('type' => 'varchar', 'precision' => '50' ,'nullable' => True), 50 'type' => array('type' => 'int', 'precision' => '2' ,'nullable' => false, 'default' => 0), 50 51 'dtstamp' => array('type' => 'int', 'precision' => '8' ,'nullable' => True) 51 52 ), … … 100 101 'uc' => array() 101 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 ), 102 116 103 117 … … 121 135 'tzid' => array('type' => 'varchar', 'precision' => '50' ,'nullable' => True), 122 136 'transp' => array( 'type' => 'int', 'precision' => '2', 'nullable' => FALSE , 'default' => 0 ), 123 'sequence' => array( 'type' => 'int', 'precision' => '8', '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 ) 124 142 ), 125 143 'pk' => array('id'), … … 130 148 131 149 132 150 'calendar_participant' => array( 133 151 'fd' => array( 134 152 'id' => array( 'type' => 'auto', 'nullable' => False), … … 165 183 'uc' => array() 166 184 ), 167 168 169 'calendar_signature_alarm' => array( 185 186 'calendar_historic' => array( 187 'fd' => array( 188 'id' => array( 'type' => 'auto', 'nullable' => False), 189 'object_id' => array('type' => 'int', 'precision' => '8','nullable' => True), 190 'user_uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False), 191 'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False), 192 'attribute' => array('type' => 'varchar','precision' => '50','nullable' => True), 193 'before_value' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True), 194 'after_value' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True) 195 ), 196 'pk' => array('id'), 197 'fk' => array(), 198 'ix' => array(), 199 'uc' => array() 200 ), 201 202 'calendar_signature_alarm' => array( 170 203 'fd' => array( 171 204 'id' => array( 'type' => 'auto', 'nullable' => False), … … 277 310 'msg_alarms' => array( 'type' => 'text', 'nullable' => True), 278 311 'font_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True), 279 280 'border_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True)281 312 'background_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True), 313 'border_color' => array( 'type' => 'varchar','precision' => '6', 'nullable' => True), 314 'type' => array('type' => 'int', 'precision' => '2' ,'nullable' => false, 'default' => 0) 282 315 ), 283 316 'pk' => array('id'),
Note: See TracChangeset
for help on using the changeset viewer.