[727] | 1 | <?php |
---|
| 2 | /**************************************************************************\ |
---|
| 3 | * phpGroupWare * |
---|
| 4 | * http://www.phpgroupware.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 | 'phpgw_config' => array( |
---|
| 15 | 'fd' => array( |
---|
| 16 | 'config_app' => array('type' => 'varchar','precision' => '50','nullable' => False), |
---|
| 17 | 'config_name' => array('type' => 'varchar','precision' => '255','nullable' => False), |
---|
| 18 | 'config_value' => array('type' => 'text') |
---|
| 19 | ), |
---|
| 20 | 'pk' => array('config_app','config_name'), |
---|
| 21 | 'fk' => array(), |
---|
| 22 | 'ix' => array(), |
---|
| 23 | 'uc' => array() |
---|
| 24 | ), |
---|
| 25 | 'phpgw_applications' => array( |
---|
| 26 | 'fd' => array( |
---|
| 27 | 'app_id' => array('type' => 'auto','precision' => '4','nullable' => False), |
---|
| 28 | 'app_name' => array('type' => 'varchar','precision' => '25','nullable' => False), |
---|
| 29 | 'app_enabled' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 30 | 'app_order' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 31 | 'app_tables' => array('type' => 'text','nullable' => False), |
---|
| 32 | 'app_version' => array('type' => 'varchar','precision' => '20','nullable' => False,'default' => '0.0') |
---|
| 33 | ), |
---|
| 34 | 'pk' => array('app_id'), |
---|
| 35 | 'fk' => array(), |
---|
| 36 | 'ix' => array(array('app_enabled','app_order')), |
---|
| 37 | 'uc' => array('app_name') |
---|
| 38 | ), |
---|
| 39 | 'phpgw_acl' => array( |
---|
| 40 | 'fd' => array( |
---|
| 41 | 'acl_appname' => array('type' => 'varchar','precision' => '50','nullable' => False), |
---|
| 42 | 'acl_location' => array('type' => 'varchar','precision' => '255','nullable' => False), |
---|
| 43 | 'acl_account' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 44 | 'acl_rights' => array('type' => 'int','precision' => '4') |
---|
| 45 | ), |
---|
| 46 | 'pk' => array('acl_appname','acl_location','acl_account'), |
---|
| 47 | 'fk' => array(), |
---|
| 48 | 'ix' => array('acl_account',array('acl_location','acl_account'),array('acl_appname','acl_account')), |
---|
| 49 | 'uc' => array() |
---|
| 50 | ), |
---|
| 51 | 'phpgw_accounts' => array( |
---|
| 52 | 'fd' => array( |
---|
| 53 | 'account_id' => array('type' => 'auto','nullable' => False), |
---|
| 54 | 'account_lid' => array('type' => 'varchar','precision' => '25','nullable' => False), |
---|
| 55 | 'account_pwd' => array('type' => 'varchar','precision' => '100','nullable' => False), |
---|
| 56 | 'account_firstname' => array('type' => 'varchar','precision' => '50'), |
---|
| 57 | 'account_lastname' => array('type' => 'varchar','precision' => '50'), |
---|
| 58 | 'account_lastlogin' => array('type' => 'int','precision' => '4'), |
---|
| 59 | 'account_lastloginfrom' => array('type' => 'varchar','precision' => '255'), |
---|
| 60 | 'account_lastpwd_change' => array('type' => 'int','precision' => '4'), |
---|
| 61 | 'account_status' => array('type' => 'char','precision' => '1','nullable' => False,'default' => 'A'), |
---|
| 62 | 'account_expires' => array('type' => 'int','precision' => '4'), |
---|
| 63 | 'account_type' => array('type' => 'char','precision' => '1'), |
---|
| 64 | 'person_id' => array('type' => 'int','precision' => '4'), |
---|
| 65 | 'account_primary_group' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'), |
---|
| 66 | 'account_email' => array('type' => 'varchar','precision' => '100') |
---|
| 67 | ), |
---|
| 68 | 'pk' => array('account_id'), |
---|
| 69 | 'fk' => array(), |
---|
| 70 | 'ix' => array(), |
---|
| 71 | 'uc' => array('account_lid') |
---|
| 72 | ), |
---|
| 73 | 'phpgw_preferences' => array( |
---|
| 74 | 'fd' => array( |
---|
| 75 | 'preference_owner' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 76 | 'preference_app' => array('type' => 'varchar','precision' => '25','nullable' => False), |
---|
| 77 | 'preference_value' => array('type' => 'text','nullable' => False) |
---|
| 78 | ), |
---|
| 79 | 'pk' => array('preference_owner','preference_app'), |
---|
| 80 | 'fk' => array(), |
---|
| 81 | 'ix' => array(), |
---|
| 82 | 'uc' => array() |
---|
| 83 | ), |
---|
| 84 | 'phpgw_sessions' => array( |
---|
| 85 | 'fd' => array( |
---|
| 86 | 'session_id' => array('type' => 'varchar','precision' => '128','nullable' => False), |
---|
| 87 | 'session_lid' => array('type' => 'varchar','precision' => '128'), |
---|
| 88 | 'session_ip' => array('type' => 'varchar','precision' => '32'), |
---|
| 89 | 'session_logintime' => array('type' => 'int','precision' => '4'), |
---|
| 90 | 'session_dla' => array('type' => 'int','precision' => '4'), |
---|
| 91 | 'session_action' => array('type' => 'varchar','precision' => '255'), |
---|
| 92 | 'session_flags' => array('type' => 'char','precision' => '2') |
---|
| 93 | ), |
---|
| 94 | 'pk' => array(), |
---|
| 95 | 'fk' => array(), |
---|
| 96 | 'ix' => array(array('session_flags','session_dla')), |
---|
| 97 | 'uc' => array('session_id') |
---|
| 98 | ), |
---|
| 99 | 'phpgw_app_sessions' => array( |
---|
| 100 | 'fd' => array( |
---|
| 101 | 'sessionid' => array('type' => 'varchar','precision' => '128','nullable' => False), |
---|
| 102 | 'loginid' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 103 | 'app' => array('type' => 'varchar','precision' => '25','nullable' => False), |
---|
| 104 | 'location' => array('type' => 'varchar','precision' => '128','nullable' => False), |
---|
| 105 | 'content' => array('type' => 'longtext'), |
---|
| 106 | 'session_dla' => array('type' => 'int','precision' => '4') |
---|
| 107 | ), |
---|
| 108 | 'pk' => array('sessionid','loginid','app','location'), |
---|
| 109 | 'fk' => array(), |
---|
| 110 | 'ix' => array(), |
---|
| 111 | 'uc' => array() |
---|
| 112 | ), |
---|
| 113 | 'phpgw_access_log' => array( |
---|
| 114 | 'fd' => array( |
---|
| 115 | 'sessionid' => array('type' => 'char','precision' => '32','nullable' => False), |
---|
| 116 | 'loginid' => array('type' => 'varchar','precision' => '30','nullable' => False), |
---|
| 117 | 'ip' => array('type' => 'varchar','precision' => '30','nullable' => False), |
---|
| 118 | 'li' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 119 | 'lo' => array('type' => 'int','precision' => '4','nullable' => True,'default' => '0'), |
---|
| 120 | 'account_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0') |
---|
| 121 | ), |
---|
| 122 | 'pk' => array(), |
---|
| 123 | 'fk' => array(), |
---|
| 124 | 'ix' => array(), |
---|
| 125 | 'uc' => array() |
---|
| 126 | ), |
---|
| 127 | 'phpgw_hooks' => array( |
---|
| 128 | 'fd' => array( |
---|
| 129 | 'hook_id' => array('type' => 'auto','nullable' => False), |
---|
| 130 | 'hook_appname' => array('type' => 'varchar','precision' => '255'), |
---|
| 131 | 'hook_location' => array('type' => 'varchar','precision' => '255'), |
---|
| 132 | 'hook_filename' => array('type' => 'varchar','precision' => '255') |
---|
| 133 | ), |
---|
| 134 | 'pk' => array('hook_id'), |
---|
| 135 | 'ix' => array(), |
---|
| 136 | 'fk' => array(), |
---|
| 137 | 'uc' => array() |
---|
| 138 | ), |
---|
| 139 | 'phpgw_languages' => array( |
---|
| 140 | 'fd' => array( |
---|
| 141 | 'lang_id' => array('type' => 'varchar','precision' => '5','nullable' => False), |
---|
| 142 | 'lang_name' => array('type' => 'varchar','precision' => '50','nullable' => False) |
---|
| 143 | ), |
---|
| 144 | 'pk' => array('lang_id'), |
---|
| 145 | 'fk' => array(), |
---|
| 146 | 'ix' => array(), |
---|
| 147 | 'uc' => array() |
---|
| 148 | ), |
---|
| 149 | 'phpgw_lang' => array( |
---|
| 150 | 'fd' => array( |
---|
| 151 | 'lang' => array('type' => 'varchar','precision' => '5','nullable' => False,'default' => ''), |
---|
| 152 | 'app_name' => array('type' => 'varchar','precision' => '100','nullable' => False,'default' => 'common'), |
---|
| 153 | 'message_id' => array('type' => 'varchar','precision' => '255','nullable' => False,'default' => ''), |
---|
| 154 | 'content' => array('type' => 'text') |
---|
| 155 | ), |
---|
| 156 | 'pk' => array('lang','app_name','message_id'), |
---|
| 157 | 'fk' => array(), |
---|
| 158 | 'ix' => array(), |
---|
| 159 | 'uc' => array() |
---|
| 160 | ), |
---|
| 161 | 'phpgw_nextid' => array( |
---|
| 162 | 'fd' => array( |
---|
| 163 | 'id' => array('type' => 'int','precision' => '4','nullable' => True), |
---|
| 164 | 'appname' => array('type' => 'varchar','precision' => '25','nullable' => False) |
---|
| 165 | ), |
---|
| 166 | 'pk' => array(), |
---|
| 167 | 'fk' => array(), |
---|
| 168 | 'ix' => array(), |
---|
| 169 | 'uc' => array('appname') |
---|
| 170 | ), |
---|
| 171 | 'phpgw_categories' => array( |
---|
| 172 | 'fd' => array( |
---|
| 173 | 'cat_id' => array('type' => 'auto','precision' => '4','nullable' => False), |
---|
| 174 | 'cat_main' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'), |
---|
| 175 | 'cat_parent' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'), |
---|
| 176 | 'cat_level' => array('type' => 'int','precision' => '2','nullable' => False,'default' => '0'), |
---|
| 177 | 'cat_owner' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'), |
---|
| 178 | 'cat_access' => array('type' => 'varchar','precision' => '7'), |
---|
| 179 | 'cat_appname' => array('type' => 'varchar','precision' => '50','nullable' => False), |
---|
| 180 | 'cat_name' => array('type' => 'varchar','precision' => '150','nullable' => False), |
---|
| 181 | 'cat_description' => array('type' => 'varchar','precision' => '255','nullable' => False), |
---|
| 182 | 'cat_data' => array('type' => 'text'), |
---|
| 183 | 'last_mod' => array('type' => 'int','precision' => '8','nullable' => False) |
---|
| 184 | ), |
---|
| 185 | 'pk' => array('cat_id'), |
---|
| 186 | 'fk' => array(), |
---|
| 187 | 'ix' => array(array('cat_appname','cat_owner','cat_parent','cat_level')), |
---|
| 188 | 'uc' => array() |
---|
| 189 | ), |
---|
| 190 | 'phpgw_addressbook' => array( |
---|
| 191 | 'fd' => array( |
---|
| 192 | 'id' => array('type' => 'auto','nullable' => False), |
---|
| 193 | 'lid' => array('type' => 'varchar','precision' => '32'), |
---|
| 194 | 'tid' => array('type' => 'char','precision' => '1'), |
---|
| 195 | 'owner' => array('type' => 'int','precision' => '8'), |
---|
| 196 | 'access' => array('type' => 'varchar','precision' => '7'), |
---|
| 197 | 'cat_id' => array('type' => 'varchar','precision' => '32'), |
---|
| 198 | 'fn' => array('type' => 'varchar','precision' => '64'), |
---|
| 199 | 'n_family' => array('type' => 'varchar','precision' => '64'), |
---|
| 200 | 'n_given' => array('type' => 'varchar','precision' => '64'), |
---|
| 201 | 'n_middle' => array('type' => 'varchar','precision' => '64'), |
---|
| 202 | 'n_prefix' => array('type' => 'varchar','precision' => '64'), |
---|
| 203 | 'n_suffix' => array('type' => 'varchar','precision' => '64'), |
---|
| 204 | 'sound' => array('type' => 'varchar','precision' => '64'), |
---|
| 205 | 'bday' => array('type' => 'varchar','precision' => '32'), |
---|
| 206 | 'note' => array('type' => 'text'), |
---|
| 207 | 'tz' => array('type' => 'varchar','precision' => '8'), |
---|
| 208 | 'geo' => array('type' => 'varchar','precision' => '32'), |
---|
| 209 | 'url' => array('type' => 'varchar','precision' => '128'), |
---|
| 210 | 'pubkey' => array('type' => 'text'), |
---|
| 211 | 'org_name' => array('type' => 'varchar','precision' => '64'), |
---|
| 212 | 'org_unit' => array('type' => 'varchar','precision' => '64'), |
---|
| 213 | 'title' => array('type' => 'varchar','precision' => '64'), |
---|
| 214 | 'adr_one_street' => array('type' => 'varchar','precision' => '64'), |
---|
| 215 | 'adr_one_locality' => array('type' => 'varchar','precision' => '64'), |
---|
| 216 | 'adr_one_region' => array('type' => 'varchar','precision' => '64'), |
---|
| 217 | 'adr_one_postalcode' => array('type' => 'varchar','precision' => '64'), |
---|
| 218 | 'adr_one_countryname' => array('type' => 'varchar','precision' => '64'), |
---|
| 219 | 'adr_one_type' => array('type' => 'varchar','precision' => '32'), |
---|
| 220 | 'label' => array('type' => 'text'), |
---|
| 221 | 'adr_two_street' => array('type' => 'varchar','precision' => '64'), |
---|
| 222 | 'adr_two_locality' => array('type' => 'varchar','precision' => '64'), |
---|
| 223 | 'adr_two_region' => array('type' => 'varchar','precision' => '64'), |
---|
| 224 | 'adr_two_postalcode' => array('type' => 'varchar','precision' => '64'), |
---|
| 225 | 'adr_two_countryname' => array('type' => 'varchar','precision' => '64'), |
---|
| 226 | 'adr_two_type' => array('type' => 'varchar','precision' => '32'), |
---|
| 227 | 'tel_work' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 228 | 'tel_home' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 229 | 'tel_voice' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 230 | 'tel_fax' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 231 | 'tel_msg' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 232 | 'tel_cell' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 233 | 'tel_pager' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 234 | 'tel_bbs' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 235 | 'tel_modem' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 236 | 'tel_car' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 237 | 'tel_isdn' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 238 | 'tel_video' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'), |
---|
| 239 | 'tel_prefer' => array('type' => 'varchar','precision' => '32'), |
---|
| 240 | 'email' => array('type' => 'varchar','precision' => '64'), |
---|
| 241 | 'email_type' => array('type' => 'varchar','precision' => '32','default' => 'INTERNET'), |
---|
| 242 | 'email_home' => array('type' => 'varchar','precision' => '64'), |
---|
| 243 | 'email_home_type' => array('type' => 'varchar','precision' => '32','default' => 'INTERNET'), |
---|
| 244 | 'last_mod' => array('type' => 'int','precision' => '8','nullable' => False) |
---|
| 245 | ), |
---|
| 246 | 'pk' => array('id'), |
---|
| 247 | 'fk' => array(), |
---|
| 248 | 'ix' => array(array('tid','owner','access','n_family','n_given','email'),array('tid','cat_id','owner','access','n_family','n_given','email')), |
---|
| 249 | 'uc' => array() |
---|
| 250 | ), |
---|
| 251 | 'phpgw_addressbook_extra' => array( |
---|
| 252 | 'fd' => array( |
---|
| 253 | 'contact_id' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 254 | 'contact_owner' => array('type' => 'int','precision' => '8'), |
---|
| 255 | 'contact_name' => array('type' => 'varchar','precision' => '255','nullable' => False), |
---|
| 256 | 'contact_value' => array('type' => 'text') |
---|
| 257 | ), |
---|
| 258 | 'pk' => array('contact_id','contact_name'), |
---|
| 259 | 'fk' => array(), |
---|
| 260 | 'ix' => array(), |
---|
| 261 | 'uc' => array() |
---|
| 262 | ), |
---|
| 263 | 'phpgw_log' => array( |
---|
| 264 | 'fd' => array( |
---|
| 265 | 'log_id' => array('type' => 'auto','precision' => '4','nullable' => False), |
---|
| 266 | 'log_date' => array('type' => 'timestamp','nullable' => False), |
---|
| 267 | 'log_user' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 268 | 'log_app' => array('type' => 'varchar','precision' => '50','nullable' => False), |
---|
| 269 | 'log_severity' => array('type' => 'char','precision' => '1','nullable' => False) |
---|
| 270 | ), |
---|
| 271 | 'pk' => array('log_id'), |
---|
| 272 | 'fk' => array(), |
---|
| 273 | 'ix' => array(), |
---|
| 274 | 'uc' => array() |
---|
| 275 | ), |
---|
| 276 | 'phpgw_log_msg' => array( |
---|
| 277 | 'fd' => array( |
---|
| 278 | 'log_msg_log_id' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 279 | 'log_msg_seq_no' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 280 | 'log_msg_date' => array('type' => 'timestamp','nullable' => False), |
---|
| 281 | 'log_msg_tx_fid' => array('type' => 'varchar','precision' => '4','nullable' => True), |
---|
| 282 | 'log_msg_tx_id' => array('type' => 'varchar','precision' => '4','nullable' => True), |
---|
| 283 | 'log_msg_severity' => array('type' => 'char','precision' => '1','nullable' => False), |
---|
| 284 | 'log_msg_code' => array('type' => 'varchar','precision' => '30','nullable' => False), |
---|
| 285 | 'log_msg_msg' => array('type' => 'text','nullable' => False), |
---|
| 286 | 'log_msg_parms' => array('type' => 'text','nullable' => False), |
---|
| 287 | 'log_msg_file' => array('type' => 'varchar','precision' => '255','nullable' => False), |
---|
| 288 | 'log_msg_line' => array('type' => 'int','precision' => '4','nullable' => False) |
---|
| 289 | ), |
---|
| 290 | 'pk' => array('log_msg_log_id','log_msg_seq_no'), |
---|
| 291 | 'fk' => array(), |
---|
| 292 | 'ix' => array(), |
---|
| 293 | 'uc' => array() |
---|
| 294 | ), |
---|
| 295 | 'phpgw_interserv' => array( |
---|
| 296 | 'fd' => array( |
---|
| 297 | 'server_id' => array('type' => 'auto','nullable' => False), |
---|
| 298 | 'server_name' => array('type' => 'varchar','precision' => '64','nullable' => True), |
---|
| 299 | 'server_host' => array('type' => 'varchar','precision' => '255','nullable' => True), |
---|
| 300 | 'server_url' => array('type' => 'varchar','precision' => '255','nullable' => True), |
---|
| 301 | 'trust_level' => array('type' => 'int','precision' => '4'), |
---|
| 302 | 'trust_rel' => array('type' => 'int','precision' => '4'), |
---|
| 303 | 'username' => array('type' => 'varchar','precision' => '64','nullable' => True), |
---|
| 304 | 'password' => array('type' => 'varchar','precision' => '255','nullable' => True), |
---|
| 305 | 'admin_name' => array('type' => 'varchar','precision' => '255','nullable' => True), |
---|
| 306 | 'admin_email' => array('type' => 'varchar','precision' => '255','nullable' => True), |
---|
| 307 | 'server_mode' => array('type' => 'varchar','precision' => '16','nullable' => False,'default' => 'xmlrpc'), |
---|
| 308 | 'server_security' => array('type' => 'varchar','precision' => '16','nullable' => True) |
---|
| 309 | ), |
---|
| 310 | 'pk' => array('server_id'), |
---|
| 311 | 'fk' => array(), |
---|
| 312 | 'ix' => array(), |
---|
| 313 | 'uc' => array() |
---|
| 314 | ), |
---|
| 315 | 'phpgw_vfs' => array( |
---|
| 316 | 'fd' => array( |
---|
| 317 | 'file_id' => array('type' => 'auto','nullable' => False), |
---|
| 318 | 'owner_id' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 319 | 'createdby_id' => array('type' => 'int','precision' => '4'), |
---|
| 320 | 'modifiedby_id' => array('type' => 'int','precision' => '4'), |
---|
| 321 | 'created' => array('type' => 'date','nullable' => False,'default' => '1970-01-01'), |
---|
| 322 | 'modified' => array('type' => 'date'), |
---|
| 323 | 'size' => array('type' => 'int','precision' => '4'), |
---|
| 324 | 'mime_type' => array('type' => 'varchar','precision' => '64'), |
---|
| 325 | 'deleteable' => array('type' => 'char','precision' => '1','default' => 'Y'), |
---|
| 326 | 'comment' => array('type' => 'varchar','precision' => '255'), |
---|
| 327 | 'app' => array('type' => 'varchar','precision' => '25'), |
---|
| 328 | 'directory' => array('type' => 'varchar','precision' => '255'), |
---|
| 329 | 'name' => array('type' => 'varchar','precision' => '128','nullable' => False), |
---|
| 330 | 'link_directory' => array('type' => 'varchar','precision' => '255'), |
---|
| 331 | 'link_name' => array('type' => 'varchar','precision' => '128'), |
---|
| 332 | 'version' => array('type' => 'varchar','precision' => '30','nullable' => False,'default' => '0.0.0.0'), |
---|
| 333 | 'content' => array('type' => 'longtext') |
---|
| 334 | ), |
---|
| 335 | 'pk' => array('file_id'), |
---|
| 336 | 'fk' => array(), |
---|
| 337 | 'ix' => array(array('directory','name','mime_type')), |
---|
| 338 | 'uc' => array() |
---|
| 339 | ), |
---|
| 340 | 'phpgw_history_log' => array( |
---|
| 341 | 'fd' => array( |
---|
| 342 | 'history_id' => array('type' => 'auto','precision' => '4','nullable' => False), |
---|
| 343 | 'history_record_id' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 344 | 'history_appname' => array('type' => 'varchar','precision' => '64','nullable' => False), |
---|
| 345 | 'history_owner' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 346 | 'history_status' => array('type' => 'char','precision' => '2','nullable' => False), |
---|
| 347 | 'history_new_value' => array('type' => 'text','nullable' => False), |
---|
| 348 | 'history_timestamp' => array('type' => 'timestamp','nullable' => False,'default' => 'current_timestamp'), |
---|
| 349 | 'history_old_value' => array('type' => 'text','nullable' => False) |
---|
| 350 | ), |
---|
| 351 | 'pk' => array('history_id'), |
---|
| 352 | 'fk' => array(), |
---|
| 353 | 'ix' => array(array('history_appname','history_record_id','history_status','history_timestamp')), |
---|
| 354 | 'uc' => array() |
---|
| 355 | ), |
---|
| 356 | 'phpgw_async' => array( |
---|
| 357 | 'fd' => array( |
---|
| 358 | 'id' => array('type' => 'varchar','precision' => '255','nullable' => False), |
---|
| 359 | 'next' => array('type' => 'int','precision' => '4','nullable' => False), |
---|
| 360 | 'times' => array('type' => 'varchar','precision' => '255','nullable' => False), |
---|
| 361 | 'method' => array('type' => 'varchar','precision' => '80','nullable' => False), |
---|
| 362 | 'data' => array('type' => 'text','nullable' => False), |
---|
| 363 | 'account_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0') |
---|
| 364 | ), |
---|
| 365 | 'pk' => array('id'), |
---|
| 366 | 'fk' => array(), |
---|
| 367 | 'ix' => array(), |
---|
| 368 | 'uc' => array() |
---|
| 369 | ) |
---|
| 370 | ); |
---|
| 371 | ?> |
---|