633 | ao_server_daemon_hosts | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique primary key |
634 | ao_server_daemon_hosts | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the ao_server |
665 | ao_servers | server | 1.0a100 | | 0 | fkey | false | true | false | a reference to servers |
679 | ao_servers | daemon_bind | 1.0a100 | | 2 | fkey | true | false | false | the network bind info for the AOServ Daemon |
682 | ao_servers | pool_size | 1.0a100 | | 3 | int | false | false | false | the recommended connection pool size for the AOServ Master |
683 | ao_servers | distro_hour | 1.0a100 | | 4 | int | false | false | false | the hour the distribution will occur, in server time zone |
684 | ao_servers | last_distro_time | 1.0a100 | | 5 | time | true | false | false | the time the last distro check was started |
685 | ao_servers | failover_server | 1.0a100 | | 6 | fkey | true | false | false | the server that is currently running this server |
127 | aosh_commands | command | 1.0a100 | | 0 | string | false | true | true | the unique command |
134 | aosh_commands | syntax | 1.0a100 | | 5 | string | false | false | true | the syntax of the command |
332 | architectures | name | 1.0a100 | | 0 | string | false | true | true | the unique name of the architecture |
137 | backup_partitions | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
138 | backup_partitions | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server that stores the backup data |
140 | backup_partitions | path | 1.0a100 | | 2 | path | false | false | false | the full path to the root of the backup data |
143 | backup_partitions | enabled | 1.0a100 | | 3 | boolean | false | false | false | flags the partition as currently accepting new data |
153 | backup_retentions | days | 1.0a100 | | 0 | short | false | true | true | the number of days to keep the backup data |
154 | backup_retentions | display | 1.0a100 | | 1 | string | false | false | true | the text displayed for this time increment |
62 | bank_accounts | name | 1.0a100 | | 0 | string | false | true | false | the unique name of this account |
63 | bank_accounts | display | 1.0a100 | | 1 | string | false | false | false | the display name of this account |
64 | bank_accounts | bank | 1.0a100 | | 2 | string | false | false | false | the bank the account is with |
90 | bank_transaction_types | display | 1.0a100 | | 1 | string | false | false | false | the display value for the type |
91 | bank_transaction_types | description | 1.0a100 | | 2 | string | false | false | false | a description of the type |
72 | bank_transactions | time | 1.0a100 | | 1 | time | false | false | false | the time the transaction occured |
79 | bank_transactions | administrator | 1.0a100 | | 4 | username | false | false | false | the business_administrator who made this transaction |
80 | bank_transactions | type | 1.0a100 | | 5 | string | false | false | false | the type of transaction |
83 | bank_transactions | description | 1.0a100 | | 7 | string | false | false | false | a description of the transaction |
86 | bank_transactions | amount | 1.0a100 | | 9 | decimal_2 | false | false | false | the amount (negative for withdrawal) |
87 | bank_transactions | confirmed | 1.0a100 | | 10 | boolean | false | false | false | the confirmation status with bank |
69 | banks | name | 1.0a100 | | 0 | string | false | true | false | the unique name of the bank |
70 | banks | display | 1.0a100 | | 1 | string | false | false | false | the name that is displayed |
410 | blackhole_email_addresses | email_address | 1.0a100 | | 0 | fkey | false | true | false | the primary key of the email_address |
29 | business_administrators | username | 1.0a100 | | 0 | username | false | true | false | the unique identifier for this admin |
32 | business_administrators | name | 1.0a100 | | 2 | string | false | false | false | the name of this admin |
33 | business_administrators | title | 1.0a100 | | 3 | string | true | false | false | the admins title within their organization |
36 | business_administrators | is_preferred | 1.0a100 | | 5 | boolean | false | false | false | if true, customers is preferred |
37 | business_administrators | private | 1.0a100 | | 6 | boolean | false | false | false | indicates if the admin should not be listed in publicly available lists |
38 | business_administrators | created | 1.0a100 | | 7 | time | false | false | false | the time the admin entry was created |
39 | business_administrators | work_phone | 1.0a100 | | 8 | phone | false | false | false | the work phone number (if different than business) |
40 | business_administrators | home_phone | 1.0a100 | | 9 | phone | true | false | false | the home phone number |
41 | business_administrators | cell_phone | 1.0a100 | | 10 | phone | true | false | false | the cellular phone number |
42 | business_administrators | fax | 1.0a100 | | 11 | phone | true | false | false | the fax number (if different than business) |
43 | business_administrators | email | 1.0a100 | | 12 | email | false | false | false | the email address |
44 | business_administrators | address1 | 1.0a100 | | 13 | string | true | false | false | the street address (if different than business) |
45 | business_administrators | address2 | 1.0a100 | | 14 | string | true | false | false | the street address (if different than business) |
54 | business_administrators | disable_log | 1.0a100 | | 19 | fkey | true | false | false | indicates that this account is disabled |
96 | business_profiles | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique primary key |
97 | business_profiles | accounting | 1.0a100 | | 1 | accounting | false | false | false | the accounting code of the business |
98 | business_profiles | priority | 1.0a100 | | 2 | int | false | false | false | the highest priority profile is used |
99 | business_profiles | name | 1.0a100 | | 3 | string | false | false | false | the name of the business |
100 | business_profiles | private | 1.0a100 | | 4 | boolean | false | false | false | indicates if the business should not be listed
in publicly available lists |
101 | business_profiles | phone | 1.0a100 | | 5 | phone | false | false | false | the phone number |
102 | business_profiles | fax | 1.0a100 | | 6 | phone | true | false | false | the fax number |
103 | business_profiles | address1 | 1.0a100 | | 7 | string | false | false | false | the street address of the business |
104 | business_profiles | address2 | 1.0a100 | | 8 | string | true | false | false | the street address of the business |
113 | business_profiles | send_invoice | 1.0a100 | | 13 | boolean | false | false | false | indicates to send a monthly invoice via regular mail |
114 | business_profiles | created | 1.0a100 | | 14 | time | false | false | false | the time this entry was created |
115 | business_profiles | billing_contact | 1.0a100 | | 15 | string | false | false | false | the name to contact for billing information |
116 | business_profiles | billing_email | 1.0a100 | | 16 | string | false | false | false | the email address to notify for billing |
118 | business_profiles | technical_contact | 1.0a100 | | 18 | string | false | false | false | the name to contact for technical information |
119 | business_profiles | technical_email | 1.0a100 | | 19 | string | false | false | false | the email address to notify for technical |
15 | businesses | accounting | 1.0a100 | | 0 | accounting | false | true | false | the unique identifier for this business. |
16 | businesses | contract_version | 1.0a100 | | 1 | string | true | false | false | the version number of the contract |
17 | businesses | created | 1.0a100 | | 2 | time | false | false | false | the time the account was created |
18 | businesses | canceled | 1.0a100 | | 3 | time | true | false | false | the time the account was deactivated |
19 | businesses | cancel_reason | 1.0a100 | | 4 | string | true | false | false | the reason the account was canceled |
20 | businesses | parent | 1.0a100 | | 5 | accounting | true | false | false | the parent business to this one |
22 | businesses | can_add_businesses | 1.0a100 | | 7 | boolean | false | false | false | if <code>true</code> this business can create
and be the parent of other businesses |
25 | businesses | disable_log | 1.0a100 | | 9 | fkey | true | false | false | indicates the business is disabled |
26 | businesses | do_not_disable_reason | 1.0a100 | | 10 | string | true | false | false | a reason why we should not disable the account |
27 | businesses | auto_enable | 1.0a100 | | 11 | boolean | false | false | false | allows the account to be automatically reenabled
on payment |
28 | businesses | bill_parent | 1.0a100 | | 12 | boolean | false | false | false | if <code>true</code>, the parent business will
be charged for all resources used by this
account |
1 | business_servers | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
2 | business_servers | accounting | 1.0a100 | | 1 | accounting | false | false | false | the business |
3 | business_servers | server | 1.0a100 | | 2 | fkey | false | false | false | the server |
4 | business_servers | is_default | 1.0a100 | | 3 | boolean | false | false | false | if <code>true</code>, this is the default server. |
6 | business_servers | can_control_apache | 1.0a100 | | 4 | boolean | false | false | false | |
7 | business_servers | can_control_cron | 1.0a100 | | 5 | boolean | false | false | false | |
9 | business_servers | can_control_mysql | 1.0a100 | | 6 | boolean | false | false | false | |
10 | business_servers | can_control_postgresql | 1.0a100 | | 7 | boolean | false | false | false | |
11 | business_servers | can_control_xfs | 1.0a100 | | 8 | boolean | false | false | false | |
12 | business_servers | can_control_xvfb | 1.0a100 | | 9 | boolean | false | false | false | |
1012 | country_codes | name | 1.0a100 | | 1 | string | false | false | true | the name of the country |
1013 | country_codes | charge_com_supported | 1.0a100 | | 2 | boolean | false | false | true | if the country is supported by Charge.Com |
1014 | country_codes | charge_com_name | 1.0a100 | | 3 | string | true | false | true | the Charge.Com specific name |
1015 | credit_cards | pkey | 1.0a100 | | 0 | pkey | false | true | false | primary key value |
1017 | credit_cards | accounting | 1.0a100 | | 2 | accounting | false | false | false | the accounting code for the card |
1020 | credit_cards | card_info | 1.0a100 | | 4 | string | false | false | false | the masked card number |
1049 | credit_cards | created | 1.0a100 | | 22 | time | false | false | false | the time the card was added to the database |
1050 | credit_cards | created_by | 1.0a100 | | 23 | username | false | false | false | the business_administrator who added the card to the database |
1052 | credit_cards | use_monthly | 1.0a100 | | 25 | boolean | false | false | false | if <code>true</code> the card will be used monthly |
1053 | credit_cards | active | 1.0a100 | | 26 | boolean | false | false | false | if <code>true</code> the card is currently active |
1054 | credit_cards | deactivated_on | 1.0a100 | | 27 | time | true | false | false | the time the card was deactivated |
1055 | credit_cards | deactivate_reason | 1.0a100 | | 28 | string | true | false | false | the reason the card was deactivated |
1057 | credit_cards | description | 1.0a100 | | 29 | string | true | false | false | any comment or description |
1374 | cvs_repositories | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
1375 | cvs_repositories | path | 1.0a100 | | 1 | path | false | false | false | the full path to the repository |
1376 | cvs_repositories | linux_server_account | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the directory owner |
1377 | cvs_repositories | linux_server_group | 1.0a100 | | 3 | fkey | false | false | false | the pkey of the directory group |
1378 | cvs_repositories | mode | 1.0a100 | | 4 | octal_long | false | false | false | the directory permissions |
1379 | cvs_repositories | created | 1.0a100 | | 5 | time | false | false | false | the time the repository was created |
1382 | cvs_repositories | disable_log | 1.0a100 | | 6 | fkey | true | false | false | indicates that this repository is disabled |
57 | disable_log | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
58 | disable_log | time | 1.0a100 | | 1 | time | false | false | false | the time the stuff was disabled |
59 | disable_log | accounting | 1.0a100 | | 2 | accounting | false | false | false | the business whose resources are being disabled |
60 | disable_log | disabled_by | 1.0a100 | | 3 | username | false | false | false | the person who disabled the accounts |
61 | disable_log | disable_reason | 1.0a100 | | 4 | string | true | false | false | the optional reason the accounts were disabled |
1789 | distro_file_types | type | 1.0a100 | | 0 | string | false | true | false | the unique name of the type |
1790 | distro_file_types | description | 1.0a100 | | 1 | string | false | false | false | a description of the type of file |
1773 | distro_files | optional | 1.0a100 | | 3 | boolean | false | false | false | if the file is optional |
1774 | distro_files | type | 1.0a100 | | 4 | string | false | false | false | the type of file |
1775 | distro_files | mode | 1.0a100 | | 5 | octal_long | false | false | false | the mode (including file type bits) |
1780 | distro_files | size | 1.0a100 | | 8 | long | true | false | false | the length of the file |
1788 | distro_files | symlink_target | 1.0a100 | | 13 | string | true | false | false | the target if is a symbolic link |
365 | dns_forbidden_zones | zone | 1.0a100 | | 0 | zone | false | true | true | the zone (domain) that is forbidden |
366 | dns_records | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated pkey |
367 | dns_records | zone | 1.0a100 | | 1 | zone | false | false | false | the zone as found in dns_zones |
370 | dns_records | type | 1.0a100 | | 3 | string | false | false | false | the type as found in dns_types |
377 | dns_records | destination | 1.0a100 | | 9 | string | false | false | false | the destination, either IP address, hostname, or other value depending on the type of record |
393 | dns_tlds | description | 1.0a100 | | 1 | string | false | false | true | |
382 | dns_types | type | 1.0a100 | | 0 | string | false | true | true | the type |
383 | dns_types | description | 1.0a100 | | 1 | string | false | false | true | the description of the type |
390 | dns_types | param_ip | 1.0a100 | | 7 | boolean | false | false | true | flags if the parameter is a IP or a hostname |
394 | dns_zones | zone | 1.0a100 | | 0 | zone | false | true | false | the zone (domain) that is hosted |
395 | dns_zones | file | 1.0a100 | | 1 | string | false | false | false | the filename of the zone file |
398 | dns_zones | hostmaster | 1.0a100 | | 3 | string | false | false | false | the email address of the person in charge of the domain |
399 | dns_zones | serial | 1.0a100 | | 4 | long | false | false | false | the ever-incrementing serial number for the file |
401 | email_addresses | pkey | 1.0a100 | | 0 | pkey | false | true | false | the primary key |
402 | email_addresses | address | 1.0a100 | | 1 | string | false | false | false | address before the @ |
403 | email_addresses | domain | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the email domain |
427 | email_domains | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique key |
430 | email_domains | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server that is hosting the email |
433 | email_forwarding | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique key |
434 | email_forwarding | email_address | 1.0a100 | | 1 | fkey | false | false | false | the primary key of the email_address |
435 | email_forwarding | destination | 1.0a100 | | 2 | email | false | false | false | the destination of the email |
440 | email_list_addresses | pkey | 1.0a100 | | 0 | pkey | false | true | false | |
441 | email_list_addresses | email_address | 1.0a100 | | 1 | fkey | false | false | false | the primary key of the email_address |
442 | email_list_addresses | email_list | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the email list |
443 | email_lists | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique primary key |
444 | email_lists | path | 1.0a100 | | 1 | path | false | false | false | the complete path to the email list |
451 | email_lists | disable_log | 1.0a100 | | 4 | fkey | true | false | false | indicates that this list is disabled |
472 | email_pipe_addresses | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique key |
473 | email_pipe_addresses | email_address | 1.0a100 | | 1 | fkey | false | false | false | the primary key of the email_address |
474 | email_pipe_addresses | email_pipe | 1.0a100 | | 2 | fkey | false | false | false | the primary key of the email pipe |
475 | email_pipes | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
476 | email_pipes | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server the program resides on |
481 | email_pipes | disable_log | 1.0a100 | | 4 | fkey | true | false | false | indicates that this email pipe is disabled |
520 | email_smtp_relay_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
521 | email_smtp_relay_types | sendmail_config | 1.0a100 | | 1 | string | false | false | true | the config value used for sendmail |
522 | email_smtp_relay_types | qmail_config | 1.0a100 | | 2 | string | false | false | true | the config value used for qmail |
508 | email_smtp_relays | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique key |
511 | email_smtp_relays | ao_server | 1.0a100 | | 2 | fkey | true | false | false | the pkey of the server that the rule applies to |
514 | email_smtp_relays | type | 1.0a100 | | 4 | string | false | false | false | the type of entry |
515 | email_smtp_relays | created | 1.0a100 | | 5 | time | false | false | false | the time the entry was created |
516 | email_smtp_relays | last_refreshed | 1.0a100 | | 6 | time | false | false | false | the time the entry was last updated |
517 | email_smtp_relays | refresh_count | 1.0a100 | | 7 | int | false | false | false | the number of times the entry has been updated |
518 | email_smtp_relays | expiration | 1.0a100 | | 8 | time | true | false | false | the expiration time of the entry, or null if non-expiring |
519 | email_smtp_relays | disable_log | 1.0a100 | | 9 | fkey | true | false | false | indicates that the rule is disabled |
155 | failover_file_log | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique id |
156 | failover_file_log | replication | 1.0a100 | | 1 | fkey | false | false | false | the replication that was performed |
157 | failover_file_log | start_time | 1.0a100 | | 2 | time | false | false | false | the time the replication started |
158 | failover_file_log | end_time | 1.0a100 | | 3 | time | false | false | false | the time the replication finished |
159 | failover_file_log | scanned | 1.0a100 | | 4 | int | false | false | false | the number of files scanned |
160 | failover_file_log | updated | 1.0a100 | | 5 | int | false | false | false | the number of files updated |
161 | failover_file_log | bytes | 1.0a100 | | 6 | long | false | false | false | the number of bytes transferred |
162 | failover_file_log | is_successful | 1.0a100 | | 7 | boolean | false | false | false | keeps track of which passes completed successfully |
168 | failover_file_replications | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique id |
163 | failover_file_schedule | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique id |
164 | failover_file_schedule | replication | 1.0a100 | | 1 | fkey | false | false | false | the replication that will be started |
165 | failover_file_schedule | hour | 1.0a100 | | 2 | short | false | false | false | the hour of day (in server timezone) |
167 | failover_file_schedule | enabled | 1.0a100 | | 4 | boolean | false | false | false | |
188 | file_backup_settings | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
191 | file_backup_settings | path | 1.0a100 | | 2 | string | false | false | false | the path to control |
1521 | httpd_binds | net_bind | 1.0a100 | | 0 | fkey | false | true | false | the IP address, port, and protocol details |
1522 | httpd_binds | httpd_server | 1.0a100 | | 1 | fkey | false | false | false | the server that is listening on the address |
2446 | httpd_jboss_sites | tomcat_site | 1.0a100 | | 0 | pkey | false | true | false | the tomcat site |
2447 | httpd_jboss_sites | version | 1.0a100 | | 1 | fkey | false | false | false | reference to httpd_jboss_versions |
2448 | httpd_jboss_sites | jnp_bind | 1.0a100 | | 2 | fkey | false | false | false | reference to net_binds |
2449 | httpd_jboss_sites | webserver_bind | 1.0a100 | | 3 | fkey | false | false | false | reference to net_binds |
2450 | httpd_jboss_sites | rmi_bind | 1.0a100 | | 4 | fkey | false | false | false | reference to net_binds |
2451 | httpd_jboss_sites | hypersonic_bind | 1.0a100 | | 5 | fkey | false | false | false | reference to net_binds |
2452 | httpd_jboss_sites | jmx_bind | 1.0a100 | | 6 | fkey | false | false | false | reference to net_binds |
2453 | httpd_jboss_versions | version | 1.0a100 | | 0 | pkey | false | true | true | jboss version designator |
2454 | httpd_jboss_versions | tomcat_version | 1.0a100 | | 1 | fkey | false | false | true | version of tomcat associated with this jboss version |
2455 | httpd_jboss_versions | template_dir | 1.0a100 | | 2 | string | false | false | true | directory containing the install template |
2537 | httpd_jk_codes | code | 1.0a100 | | 0 | string | false | true | true | the unique, two-character code |
2493 | httpd_jk_protocols | protocol | 1.0a100 | | 0 | string | false | true | true | the protocol used, as found in protocols.protocol |
1523 | httpd_servers | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique number |
1524 | httpd_servers | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server that hosts the httpd |
1527 | httpd_servers | can_add_sites | 1.0a100 | | 3 | boolean | false | false | false | indicated that more sites may be added to the server |
2503 | httpd_shared_tomcats | pkey | 1.0a100 | | 0 | pkey | false | true | false | pkey for this jvm |
2504 | httpd_shared_tomcats | name | 1.0a100 | | 1 | string | false | false | false | unique name for this jvm |
2505 | httpd_shared_tomcats | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server on which this jvm resides |
2506 | httpd_shared_tomcats | version | 1.0a100 | | 3 | fkey | false | false | false | the tomcat version |
2507 | httpd_shared_tomcats | linux_server_account | 1.0a100 | | 4 | fkey | false | false | false | the account under which this tomcat runs |
2508 | httpd_shared_tomcats | linux_server_group | 1.0a100 | | 5 | fkey | false | false | false | the group to which this tomcat is assigned |
2517 | httpd_shared_tomcats | disable_log | 1.0a100 | | 6 | fkey | true | false | false | indicates that the JVM is disabled |
2518 | httpd_shared_tomcats | tomcat4_worker | 1.0a100 | | 7 | fkey | true | true | false | the httpd_worker for Tomcat version 4 |
2519 | httpd_shared_tomcats | tomcat4_shutdown_port | 1.0a100 | | 8 | fkey | true | true | false | the port that will shut down this JVM |
2520 | httpd_shared_tomcats | tomcat4_shutdown_key | 1.0a100 | | 9 | string | true | false | false | the key used to shut down the JVM |
2521 | httpd_shared_tomcats | is_manual | 1.0a100 | | 10 | boolean | false | false | false | the configuration files are manually maintained |
1639 | httpd_site_binds | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
1640 | httpd_site_binds | httpd_site | 1.0a100 | | 1 | fkey | false | false | false | the site that is being referenced |
1641 | httpd_site_binds | httpd_bind | 1.0a100 | | 2 | fkey | false | false | false | the IP and port information for the binding |
1643 | httpd_site_binds | access_log | 1.0a100 | | 4 | path | false | false | false | the file used for access logging |
1644 | httpd_site_binds | error_log | 1.0a100 | | 5 | path | false | false | false | the file used for error logging |
1649 | httpd_site_binds | disable_log | 1.0a100 | | 7 | fkey | true | false | false | indicates that this bind is disabled |
1650 | httpd_site_binds | predisable_config | 1.0a100 | | 8 | string | true | false | false | the config file before the site was disabled |
1651 | httpd_site_binds | is_manual | 1.0a100 | | 9 | boolean | false | false | false | the config file is manually maintained |
1634 | httpd_site_urls | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
1635 | httpd_site_urls | httpd_site_bind | 1.0a100 | | 1 | fkey | false | false | false | the site that is being referenced |
1638 | httpd_site_urls | is_primary | 1.0a100 | | 3 | boolean | false | false | false | flags if this is the primary hostname for a site.
A site must have one and only one primary hostname
at a time. This constraint is implemented by the
application code. |
1599 | httpd_sites | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server the site is hosted on |
1602 | httpd_sites | list_first | 1.0a100 | | 3 | boolean | false | false | false | if <code>true</code>, this site will be listed first in the Apache configs. This is normally used only for the "not found" site for each httpd_server. |
1609 | httpd_sites | server_admin | 1.0a100 | | 7 | email | false | false | false | the email address of the server administrator. This address is provided when an error occurs. The value is most often <code>webmaster@<i>domain.com</i></code> |
1619 | httpd_sites | disable_log | 1.0a100 | | 8 | fkey | true | false | false | indicates that the site is disabled |
1620 | httpd_sites | is_manual | 1.0a100 | | 9 | boolean | false | false | false | configuration of this server is performed manually |
1633 | httpd_static_sites | httpd_site | 1.0a100 | | 0 | fkey | false | true | false | the site that contains static content |
2473 | httpd_tomcat_contexts | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique key |
2474 | httpd_tomcat_contexts | tomcat_site | 1.0a100 | | 1 | fkey | false | false | false | the site this context is part of |
2475 | httpd_tomcat_contexts | class_name | 1.0a100 | | 2 | string | true | false | false | the className attribute |
2476 | httpd_tomcat_contexts | cookies | 1.0a100 | | 3 | boolean | false | false | false | the cookies attribute |
2477 | httpd_tomcat_contexts | cross_context | 1.0a100 | | 4 | boolean | false | false | false | the crossContext attribute |
2480 | httpd_tomcat_contexts | override | 1.0a100 | | 6 | boolean | false | false | false | the override attribute |
2481 | httpd_tomcat_contexts | path | 1.0a100 | | 7 | string | false | false | false | the path attribute |
2482 | httpd_tomcat_contexts | privileged | 1.0a100 | | 8 | boolean | false | false | false | the privileged attribute |
2483 | httpd_tomcat_contexts | reloadable | 1.0a100 | | 9 | boolean | false | false | false | the reloadable attribute |
2484 | httpd_tomcat_contexts | use_naming | 1.0a100 | | 10 | boolean | false | false | false | the useNaming attribute |
2485 | httpd_tomcat_contexts | wrapper_class | 1.0a100 | | 11 | string | true | false | false | the wrapperClass attribute |
2486 | httpd_tomcat_contexts | debug | 1.0a100 | | 12 | int | false | false | false | the debug attribute |
2487 | httpd_tomcat_contexts | work_dir | 1.0a100 | | 13 | path | true | false | false | the workDir attribute |
2530 | httpd_tomcat_sites | httpd_site | 1.0a100 | | 0 | fkey | false | true | false | the site that this Tomcat is running in |
2531 | httpd_tomcat_sites | version | 1.0a100 | | 1 | fkey | false | false | false | the version of tomcat that is being ran |
2528 | httpd_tomcat_shared_sites | tomcat_site | 1.0a100 | | 0 | pkey | false | true | false | the tomcat site |
2529 | httpd_tomcat_shared_sites | httpd_shared_tomcat | 1.0a100 | | 1 | fkey | false | false | false | the shared JVM |
2494 | httpd_tomcat_std_sites | tomcat_site | 1.0a100 | | 0 | fkey | false | true | false | the site that this Tomcat is running in |
2495 | httpd_tomcat_std_sites | tomcat4_shutdown_port | 1.0a100 | | 1 | fkey | true | true | false | the port that will shut down this JVM |
2496 | httpd_tomcat_std_sites | tomcat4_shutdown_key | 1.0a100 | | 2 | string | true | false | false | the key used to shut down the JVM |
2534 | httpd_tomcat_versions | version | 1.0a100 | | 0 | fkey | false | true | true | a reference to the tomcat details in the <code>technology_versions</code> table |
2535 | httpd_tomcat_versions | install_dir | 1.0a100 | | 1 | path | false | false | true | the directory the basic install files are located in |
2536 | httpd_tomcat_versions | requires_mod_jk | 1.0a100 | | 2 | boolean | false | false | true | indicates that this version of Tomcat requires the use of mod_jk |
989 | ip_addresses | created | 1.0a100 | | 6 | time | false | false | false | the time the IP address was added |
436 | linux_acc_addresses | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique, generated primary key |
437 | linux_acc_addresses | email_address | 1.0a100 | | 1 | fkey | false | false | false | reference to pkey of email_addresses |
766 | linux_account_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
767 | linux_account_types | description | 1.0a100 | | 1 | string | false | false | true | a description of the type |
768 | linux_account_types | is_email | 1.0a100 | | 2 | boolean | false | false | true | can email be associated with this account |
733 | linux_accounts | type | 1.0a100 | | 5 | string | false | false | false | the type of account |
734 | linux_accounts | shell | 1.0a100 | | 6 | path | false | false | false | the users shell preference |
735 | linux_accounts | created | 1.0a100 | | 7 | time | false | false | false | the time the account was created |
736 | linux_accounts | disable_log | 1.0a100 | | 8 | fkey | true | false | false | indicates that this account is disabled |
651 | linux_group_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
652 | linux_group_types | description | 1.0a100 | | 1 | string | false | false | true | a description of the type |
641 | linux_groups | type | 1.0a100 | | 2 | string | false | false | false | the type of group |
737 | linux_server_accounts | pkey | 1.0a100 | | 0 | pkey | false | true | false | the generated primary key |
740 | linux_server_accounts | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server the username is on |
744 | linux_server_accounts | home | 1.0a100 | | 4 | path | false | false | false | the home directory of the user on this machine |
751 | linux_server_accounts | autoresponder_from | 1.0a100 | | 5 | fkey | true | false | false | the pkey of the email address used for the autoresponder |
752 | linux_server_accounts | autoresponder_subject | 1.0a100 | | 6 | string | true | false | false | the subject of autoresponder messages |
753 | linux_server_accounts | autoresponder_path | 1.0a100 | | 7 | string | true | false | false | the full path of the autoresponder text file |
754 | linux_server_accounts | is_autoresponder_enabled | 1.0a100 | | 8 | boolean | false | false | false | flags if the autoresponder is enabled |
755 | linux_server_accounts | disable_log | 1.0a100 | | 9 | fkey | true | false | false | indicates the account is disabled |
756 | linux_server_accounts | predisable_password | 1.0a100 | | 10 | string | true | false | false | stores the password that was used before the account was disabled |
759 | linux_server_accounts | use_inbox | 1.0a100 | | 12 | boolean | false | false | false | email for this account will be stored in the inbox, otherwise it is just deleted |
760 | linux_server_accounts | trash_email_retention | 1.0a100 | | 13 | int | true | false | false | the number of days before messages in the Trash folder are automatically removed. |
642 | linux_server_groups | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique key |
645 | linux_server_groups | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the ao_server the group is on |
452 | majordomo_lists | email_list | 1.0a100 | | 0 | fkey | false | true | false | the email list that this majordomo_list represents |
453 | majordomo_lists | majordomo_server | 1.0a100 | | 1 | fkey | false | false | false | the majordomo_server that this list is part of |
454 | majordomo_lists | name | 1.0a100 | | 2 | string | false | false | false | the list name |
455 | majordomo_lists | listname_pipe_add | 1.0a100 | | 3 | fkey | false | true | false | the pipe address the list responds to. Example: test@aoindustries.com |
456 | majordomo_lists | listname_list_add | 1.0a100 | | 4 | fkey | false | true | false | the list address that accesses the raw list contents. Example: test-list@aoindustries.com |
457 | majordomo_lists | owner_listname_add | 1.0a100 | | 5 | fkey | false | true | false | the owner of the list. Example: owner-test@aoindustries.com |
458 | majordomo_lists | listname_owner_add | 1.0a100 | | 6 | fkey | false | true | false | the owner of the list. Example: test-owner@aoindustries.com |
459 | majordomo_lists | listname_approval_add | 1.0a100 | | 7 | fkey | false | true | false | the person who retrieves approval notifications. Example: test-approval@aoindustries.com |
460 | majordomo_lists | listname_request_pipe_add | 1.0a100 | | 8 | fkey | false | true | false | the address that Majordomo requests may be sent to. Example: test-request@aoindustries.com |
461 | majordomo_servers | domain | 1.0a100 | | 0 | fkey | false | true | false | the pkey of the domain that is hosted |
462 | majordomo_servers | linux_server_account | 1.0a100 | | 1 | fkey | false | false | false | the pkey of linux_server_account to run as |
463 | majordomo_servers | linux_server_group | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the linux_server_group to run as |
464 | majordomo_servers | version | 1.0a100 | | 3 | string | false | false | false | the version of Majordomo to use |
465 | majordomo_servers | majordomo_pipe_address | 1.0a100 | | 4 | fkey | false | false | false | the email_address to use as the majordomo |
466 | majordomo_servers | owner_majordomo_add | 1.0a100 | | 5 | fkey | false | false | false | the email_address that owns this majordomo list |
467 | majordomo_servers | majordomo_owner_add | 1.0a100 | | 6 | fkey | false | false | false | the email_address that owns this majordomo list |
470 | majordomo_versions | version | 1.0a100 | | 0 | string | false | true | true | the version number |
471 | majordomo_versions | created | 1.0a100 | | 1 | time | false | false | true | the time the version was added |
795 | master_hosts | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique primary key |
796 | master_hosts | username | 1.0a100 | | 1 | username | false | false | false | the unique username of the user |
778 | master_processes | authenticated_user | 1.0a100 | | 2 | username | true | false | false | |
779 | master_processes | effective_user | 1.0a100 | | 3 | username | true | false | false | |
780 | master_processes | daemon_server | 1.0a100 | | 4 | fkey | true | false | false | |
781 | master_processes | host | 1.0a100 | | 5 | ip_address | false | false | false | |
782 | master_processes | protocol | 1.0a100 | | 6 | string | false | false | false | |
784 | master_processes | is_secure | 1.0a100 | | 8 | boolean | false | false | false | |
785 | master_processes | connect_time | 1.0a100 | | 9 | time | false | false | false | |
786 | master_processes | use_count | 1.0a100 | | 10 | long | false | false | false | |
787 | master_processes | total_time | 1.0a100 | | 11 | interval | false | false | false | |
788 | master_processes | priority | 1.0a100 | | 12 | int | false | false | false | |
789 | master_processes | state | 1.0a100 | | 13 | string | false | false | false | |
790 | master_processes | command | 1.0a100 | | 14 | string | true | false | false | |
791 | master_processes | state_start_time | 1.0a100 | | 15 | time | false | false | false | |
792 | master_server_stats | name | 1.0a100 | | 0 | string | false | true | false | |
793 | master_server_stats | value | 1.0a100 | | 1 | string | true | false | false | |
794 | master_server_stats | description | 1.0a100 | | 2 | string | false | false | false | |
799 | master_servers | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique primary key |
800 | master_servers | username | 1.0a100 | | 1 | username | false | false | false | the unique username of the user |
801 | master_servers | server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server they may control |
802 | master_users | username | 1.0a100 | | 0 | username | false | true | false | the unique username of the user |
803 | master_users | is_active | 1.0a100 | | 1 | boolean | false | false | false | this level of access may be disabled |
804 | master_users | can_access_accounting | 1.0a100 | | 2 | boolean | false | false | false | if they can access accounting resources |
805 | master_users | can_access_bank_accounting | 1.0a100 | | 3 | boolean | false | false | false | if they can access bank account info |
806 | master_users | can_invalidate_tables | 1.0a100 | | 4 | boolean | false | false | false | if they can invalidate master tables |
807 | master_users | can_access_admin_web | 1.0a100 | | 5 | boolean | false | false | false | if they can access administrative web pages |
809 | master_users | is_dns_admin | 1.0a100 | | 6 | boolean | false | false | false | if they can access all DNS stuff |
211 | monthly_charges | pkey | 1.0a100 | | 0 | pkey | true | true | false | a unique, generated number for reference |
212 | monthly_charges | accounting | 1.0a100 | | 1 | accounting | false | false | false | the account code that is charged to |
215 | monthly_charges | type | 1.0a100 | | 3 | string | false | false | false | the type of charge, as found in transaction types |
216 | monthly_charges | description | 1.0a100 | | 4 | string | true | false | false | the description that is placed in the transaction |
217 | monthly_charges | quantity | 1.0a100 | | 5 | decimal_3 | false | false | false | the quantity |
220 | monthly_charges | created | 1.0a100 | | 7 | time | false | false | false | the time this entry was created |
221 | monthly_charges | created_by | 1.0a100 | | 8 | username | false | false | false | the business_administrator who created the entry |
222 | monthly_charges | active | 1.0a100 | | 9 | boolean | false | false | false | flags if this entry is active |
813 | mysql_databases | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique, generated primary key |
823 | mysql_db_users | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
824 | mysql_db_users | mysql_database | 1.0a100 | | 1 | fkey | false | false | false | the pkey in mysql_databases |
827 | mysql_db_users | select_priv | 1.0a100 | | 3 | boolean | false | false | false | the SELECT privilege |
828 | mysql_db_users | insert_priv | 1.0a100 | | 4 | boolean | false | false | false | the INSERT privilege |
829 | mysql_db_users | update_priv | 1.0a100 | | 5 | boolean | false | false | false | the UPDATE privilege |
830 | mysql_db_users | delete_priv | 1.0a100 | | 6 | boolean | false | false | false | the DELETE privilege |
831 | mysql_db_users | create_priv | 1.0a100 | | 7 | boolean | false | false | false | the CREATE privilege |
832 | mysql_db_users | drop_priv | 1.0a100 | | 8 | boolean | false | false | false | the DROP privilege |
833 | mysql_db_users | grant_priv | 1.0a100 | | 9 | boolean | false | false | false | the GRANT privilege |
834 | mysql_db_users | references_priv | 1.0a100 | | 10 | boolean | false | false | false | the REFERENCES privilege |
835 | mysql_db_users | index_priv | 1.0a100 | | 11 | boolean | false | false | false | the INDEX privilege |
836 | mysql_db_users | alter_priv | 1.0a100 | | 12 | boolean | false | false | false | the ALTER privilete |
887 | mysql_server_users | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
894 | mysql_server_users | disable_log | 1.0a100 | | 4 | fkey | true | false | false | indicates that this account is disabled |
895 | mysql_server_users | predisable_password | 1.0a100 | | 5 | string | true | false | false | the password used before the account was disabled |
858 | mysql_users | select_priv | 1.0a100 | | 1 | boolean | false | false | false | the SELECT privilege to all databases |
859 | mysql_users | insert_priv | 1.0a100 | | 2 | boolean | false | false | false | the INSERT privilege to all databases |
860 | mysql_users | update_priv | 1.0a100 | | 3 | boolean | false | false | false | the UPDATE privilege to all databases |
861 | mysql_users | delete_priv | 1.0a100 | | 4 | boolean | false | false | false | the DELETE privilege to all databases |
862 | mysql_users | create_priv | 1.0a100 | | 5 | boolean | false | false | false | the CREATE privilege to all databases |
863 | mysql_users | drop_priv | 1.0a100 | | 6 | boolean | false | false | false | the DROP privilege to all databases |
864 | mysql_users | reload_priv | 1.0a100 | | 7 | boolean | false | false | false | the RELOAD privilege to all databases |
865 | mysql_users | shutdown_priv | 1.0a100 | | 8 | boolean | false | false | false | the SHUTDOWN privilege to all databases |
866 | mysql_users | process_priv | 1.0a100 | | 9 | boolean | false | false | false | the PROCESS privilege to all databases |
867 | mysql_users | file_priv | 1.0a100 | | 10 | boolean | false | false | false | the FILE privilege to all databases |
868 | mysql_users | grant_priv | 1.0a100 | | 11 | boolean | false | false | false | the GRANT privilege to all databases |
869 | mysql_users | references_priv | 1.0a100 | | 12 | boolean | false | false | false | the REFERENCES privilege to all databases |
870 | mysql_users | index_priv | 1.0a100 | | 13 | boolean | false | false | false | the INDEX privilege to all databases |
871 | mysql_users | alter_priv | 1.0a100 | | 14 | boolean | false | false | false | the ALTER privilete to all databases |
886 | mysql_users | disable_log | 1.0a100 | | 29 | fkey | true | false | false | indicates that this account is disabled |
922 | net_binds | app_protocol | 1.0a100 | | 5 | string | false | false | false | the application protocol (<code>protocols</code>) |
930 | net_device_ids | name | 1.0a100 | | 0 | string | false | true | true | the unique name of the device |
931 | net_device_ids | is_loopback | 1.0a100 | | 1 | boolean | false | false | true | if the device is the loopback device |
932 | net_devices | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique, generated pkey |
937 | net_devices | description | 1.0a100 | | 3 | string | false | false | false | a description of the device |
940 | net_devices | gateway | 1.0a100 | | 5 | ip_address | true | false | false | the gateway IP address |
226 | notice_log | pkey | 1.0a100 | | 0 | pkey | false | true | false | |
227 | notice_log | create_time | 1.0a100 | | 1 | time | false | false | false | |
228 | notice_log | accounting | 1.0a100 | | 2 | accounting | false | false | false | |
229 | notice_log | billing_contact | 1.0a100 | | 3 | string | false | false | false | |
230 | notice_log | billing_email | 1.0a100 | | 4 | email | false | false | false | |
232 | notice_log | notice_type | 1.0a100 | | 5 | string | false | false | false | |
235 | notice_types | type | 1.0a100 | | 0 | string | false | true | true | |
236 | notice_types | description | 1.0a100 | | 1 | string | false | false | true | |
337 | operating_system_versions | pkey | 1.0a100 | | 0 | pkey | false | true | true | a generated, unique ID |
338 | operating_system_versions | operating_system | 1.0a100 | | 1 | string | false | false | true | the name of the OS |
339 | operating_system_versions | version_number | 1.0a100 | | 2 | string | false | false | true | the number of OS version |
340 | operating_system_versions | version_name | 1.0a100 | | 3 | string | false | false | true | the name of this OS release |
334 | operating_systems | name | 1.0a100 | | 0 | string | false | true | true | the unique name of the operating system |
335 | operating_systems | display | 1.0a100 | | 1 | string | false | false | true | the display version of the name |
336 | operating_systems | is_unix | 1.0a100 | | 2 | boolean | false | false | true | indicates that this is a Unix-based OS |
264 | packages | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique key |
267 | packages | accounting | 1.0a100 | | 2 | accounting | false | false | false | the accounting code of the business that pays for this package |
271 | packages | created | 1.0a100 | | 4 | time | false | false | false | |
272 | packages | created_by | 1.0a100 | | 5 | username | false | false | false | |
281 | packages | disable_log | 1.0a100 | | 6 | fkey | true | false | false | indicates that the package is disabled |
1171 | payment_types | name | 1.0a100 | | 0 | string | false | true | true | the name of the type |
1172 | payment_types | description | 1.0a100 | | 1 | string | false | false | true | a description of the type of payment |
1173 | payment_types | active | 1.0a100 | | 2 | boolean | false | false | true | indicates if payment is currently accepted via this method |
1174 | payment_types | allow_web | 1.0a100 | | 3 | boolean | false | false | true | indicates if payment is allowed via a web form |
1214 | postgres_databases | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique, generated primary key |
1217 | postgres_databases | postgres_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the PostgreSQL server |
1218 | postgres_databases | datdba | 1.0a100 | | 3 | fkey | false | false | false | the datdba for the database |
1219 | postgres_databases | encoding | 1.0a100 | | 4 | fkey | false | false | false | the pkey of the encoding system used for the database |
1220 | postgres_databases | is_template | 1.0a100 | | 5 | boolean | false | false | false | if true, this database is a template |
1221 | postgres_databases | allow_conn | 1.0a100 | | 6 | boolean | false | false | false | if true, this database is accepting connections |
1225 | postgres_encodings | pkey | 1.0a100 | | 0 | pkey | false | true | true | a generated unique key |
1226 | postgres_encodings | encoding | 1.0a100 | | 1 | string | false | false | true | the name of the encoding |
1227 | postgres_encodings | postgres_version | 1.0a100 | | 2 | fkey | false | false | true | the version of PostgreSQL |
1247 | postgres_server_users | pkey | 1.0a100 | | 0 | pkey | false | true | false | a unique, generated number |
1253 | postgres_server_users | disable_log | 1.0a100 | | 3 | fkey | true | false | false | indicates that this account is disabled |
1254 | postgres_server_users | predisable_password | 1.0a100 | | 4 | string | true | false | false | the password that was on the account before it was disabled |
1232 | postgres_servers | ao_server | 1.0a100 | | 2 | fkey | false | false | false | the pkey of the server that this database is hosted on |
1233 | postgres_servers | version | 1.0a100 | | 3 | fkey | false | false | false | the pkey of the PostgreSQL version |
1234 | postgres_servers | max_connections | 1.0a100 | | 4 | int | false | false | false | the maximum number of connections for the db |
1236 | postgres_servers | sort_mem | 1.0a100 | | 5 | int | false | false | false | the amount of shared memory used for sorting |
1237 | postgres_servers | shared_buffers | 1.0a100 | | 6 | int | false | false | false | the number of shared buffers |
1238 | postgres_servers | fsync | 1.0a100 | | 7 | boolean | false | false | false | indicates that writes are synchronous |
1242 | postgres_users | createdb | 1.0a100 | | 1 | boolean | false | false | false | usecreatedb flag |
1243 | postgres_users | trace | 1.0a100 | | 2 | boolean | false | false | false | usetrace flag |
1244 | postgres_users | super | 1.0a100 | | 3 | boolean | false | false | false | usesuper flag |
1245 | postgres_users | catupd | 1.0a100 | | 4 | boolean | false | false | false | usecatupd flag |
1246 | postgres_users | disable_log | 1.0a100 | | 5 | fkey | true | false | false | indicates that this account is disabled |
1255 | postgres_versions | version | 1.0a100 | | 0 | fkey | false | true | true | a reference to the PostgreSQL details in the <code>technology_versions</code> table |
550 | private_ftp_servers | logfile | 1.0a100 | | 1 | path | false | false | false | the file transfers are logged to |
553 | private_ftp_servers | email | 1.0a100 | | 3 | email | false | false | false | the email address the server reports |
555 | private_ftp_servers | created | 1.0a100 | | 4 | time | false | false | false | the time the server was added |
900 | protocols | protocol | 1.0a100 | | 0 | string | false | true | true | the unique name of the protocol |
904 | protocols | name | 1.0a100 | | 2 | string | false | false | true | the name of the service |
288 | resources | name | 1.0a100 | | 0 | string | false | true | true | the name of the specific resource |
1331 | schema_columns | type | 1.0a100 | | 6 | string | false | false | true | the type of data in the column |
1338 | schema_columns | description | 1.0a100 | | 10 | string | false | false | true | any description associated with the column |
1354 | schema_tables | name | 1.0a100 | | 1 | string | false | true | true | the unique name |
1358 | schema_tables | display | 1.0a100 | | 4 | string | false | false | true | the display name |
1361 | schema_tables | description | 1.0a100 | | 6 | string | false | false | true | the description of the table |
577 | server_farms | name | 1.0a100 | | 0 | string | false | true | false | the unique name of the farm |
578 | server_farms | description | 1.0a100 | | 1 | string | false | false | false | a description of the farm |
958 | servers | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated, unique ID |
960 | servers | farm | 1.0a100 | | 1 | string | false | false | false | the name of the farm the server is located in |
963 | servers | description | 1.0a100 | | 2 | string | false | false | false | a description of the servers purpose |
718 | shells | path | 1.0a100 | | 0 | path | false | true | true | the complete path to the executable |
719 | shells | is_login | 1.0a100 | | 1 | boolean | false | false | true | indicates if the shells gives process control |
720 | shells | is_system | 1.0a100 | | 2 | boolean | false | false | true | indicates that this shell is for internal use only |
537 | spam_email_messages | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated unique key |
538 | spam_email_messages | email_relay | 1.0a100 | | 1 | fkey | false | false | false | the relay that has been denied |
539 | spam_email_messages | time | 1.0a100 | | 2 | time | false | false | false | the time the message was added |
540 | spam_email_messages | message | 1.0a100 | | 3 | string | false | false | false | the message contents |
541 | system_email_aliases | pkey | 1.0a100 | | 0 | pkey | false | true | false | a generated primary key |
542 | system_email_aliases | ao_server | 1.0a100 | | 1 | fkey | false | false | false | the pkey of the server the entry is on |
543 | system_email_aliases | address | 1.0a100 | | 2 | string | false | false | false | the address (username only) to match |
544 | system_email_aliases | destination | 1.0a100 | | 3 | string | false | false | false | the destination, as found in /etc/aliases |
347 | technologies | name | 1.0a100 | | 1 | string | false | false | true | the name of the package |
348 | technologies | class | 1.0a100 | | 2 | string | false | false | true | the name of the group this package belongs to |
349 | technology_classes | name | 1.0a100 | | 0 | string | false | true | true | the name of the class |
350 | technology_classes | description | 1.0a100 | | 1 | string | false | false | true | a description of the class |
351 | technology_names | name | 1.0a100 | | 0 | string | false | true | true | the name of the package |
352 | technology_names | image_filename | 1.0a100 | | 1 | string | true | false | true | the name of the file containing the image |
353 | technology_names | image_width | 1.0a100 | | 2 | int | true | false | true | the width of the image |
354 | technology_names | image_height | 1.0a100 | | 3 | int | true | false | true | the height of the image |
355 | technology_names | image_alt | 1.0a100 | | 4 | string | true | false | true | the alt attribute of the image |
356 | technology_names | home_page_url | 1.0a100 | | 5 | url | true | false | true | the URL of the technology home page |
357 | technology_versions | pkey | 1.0a100 | | 0 | pkey | false | true | true | a generated unique key |
358 | technology_versions | name | 1.0a100 | | 1 | string | false | false | true | the name of the software package |
359 | technology_versions | version | 1.0a100 | | 2 | string | false | false | true | the version number of the package in #.##.##-## format |
360 | technology_versions | updated | 1.0a100 | | 3 | time | false | false | true | the time this package was last updated |
361 | technology_versions | owner | 1.0a100 | | 4 | username | false | false | false | the business_administrator who is responsible for maintaining this package |
1474 | ticket_priorities | priority | 1.0a100 | | 0 | string | false | true | true | |
1475 | ticket_stati | status | 1.0a100 | | 0 | string | false | true | true | |
1507 | ticket_types | type | 1.0a100 | | 0 | string | false | true | true | |
1478 | tickets | pkey | 1.0a100 | | 0 | pkey | false | true | false | |
1487 | tickets | ticket_type | 1.0a100 | | 7 | string | false | false | false | |
1493 | tickets | open_date | 1.0a100 | | 12 | time | false | false | false | |
1497 | tickets | client_priority | 1.0a100 | | 13 | string | false | false | false | |
1501 | tickets | status | 1.0a100 | | 15 | string | false | false | false | |
294 | transactions | time | 1.0a100 | | 0 | time | false | false | false | the time the transaction occured |
297 | transactions | accounting | 1.0a100 | | 2 | accounting | false | false | false | the identifier for the business (see businesses) |
298 | transactions | source_accounting | 1.0a100 | | 3 | accounting | false | false | false | the source of the charge to this account |
299 | transactions | username | 1.0a100 | | 4 | username | false | false | false | the identifier for the admin involved in the transaction (see business_administrators) |
300 | transactions | type | 1.0a100 | | 5 | string | false | false | false | the type of transaction |
301 | transactions | description | 1.0a100 | | 6 | string | false | false | false | description of the transaction |
302 | transactions | quantity | 1.0a100 | | 7 | decimal_3 | false | false | false | the number of times to charge the account |
305 | transactions | payment_type | 1.0a100 | | 9 | string | true | false | false | the type of payment made
check - check, check number will be in payment_info
money_order - money order
visa - visa card, last four in payment_info
mastercard - mastercard, last four in payment_info
amex - amex card, last four in payment_info
discover - discover card, last four in payment_info |
306 | transactions | payment_info | 1.0a100 | | 10 | string | true | false | false | the payment info, such as last four of credit card number of check number |
312 | transactions | payment_confirmed | 1.0a100 | | 13 | string | false | false | false | 'Y' if the payment is confirmed
'W' if waiting confirmation
'N' if confirmation failed |
125 | us_states | code | 1.0a100 | | 0 | string | false | true | true | the two-character code for the state |
126 | us_states | name | 1.0a100 | | 1 | string | false | false | true | the name of the state |
121 | usernames | username | 1.0a100 | | 0 | username | false | true | false | the unique username |
124 | usernames | disable_log | 1.0a100 | | 2 | fkey | true | false | false | indicates that the username is disabled |
1316 | aoserv_protocols | version | 1.0a101 | | 0 | string | false | true | true | the unique version number |
1317 | aoserv_protocols | created | 1.0a101 | | 1 | date | false | false | true | the time the version was added |
1318 | aoserv_protocols | comments | 1.0a101 | | 2 | string | false | false | true | any comments about this version |
145 | backup_reports | pkey | 1.0a101 | | 0 | pkey | false | true | false | a generated primary key |
146 | backup_reports | server | 1.0a101 | | 1 | fkey | false | false | false | the pkey of the server being backed-up |
147 | backup_reports | package | 1.0a101 | | 2 | fkey | false | false | false | the pkey of the package the data is assigned to |
148 | backup_reports | date | 1.0a101 | | 3 | date | false | false | false | the date the summary is for |
149 | backup_reports | file_count | 1.0a101 | | 4 | int | false | false | false | the number of files belong to this package on this server |
152 | backup_reports | disk_size | 1.0a101 | | 5 | long | false | false | false | the total number of bytes of disk space used |
783 | master_processes | aoserv_protocol | 1.0a101 | | 7 | string | true | false | false | |
21 | businesses | can_add_backup_server | 1.0a102 | | 6 | boolean | false | false | false | the business may add servers to the backup system |
1530 | httpd_servers | linux_server_account | 1.0a102 | | 4 | fkey | false | false | false | the account to run as |
1531 | httpd_servers | linux_server_group | 1.0a102 | | 5 | fkey | false | false | false | the group to run as |
1532 | httpd_servers | mod_php_version | 1.0a102 | | 6 | fkey | true | false | false | the version of mod_php to run |
1533 | httpd_servers | use_suexec | 1.0a102 | | 7 | boolean | false | false | false | indicates that the suexec wrapper will be used for CGI |
1534 | httpd_servers | package | 1.0a102 | | 8 | fkey | false | false | false | the package that owns the server |
1536 | httpd_servers | is_shared | 1.0a102 | | 9 | boolean | false | false | false | indicates that any user on the server may use this httpd instance |
582 | server_farms | owner | 1.0a102 | | 2 | fkey | false | false | false | the package that owns of the farm |
24 | businesses | can_see_prices | 1.0a103 | | 8 | boolean | false | false | false | if <code>false</code>, prices are filtered |
1537 | httpd_servers | use_mod_perl | 1.0a103 | | 10 | boolean | false | false | false | |
928 | net_binds | monitoring_enabled | 1.0a104 | | 6 | boolean | false | false | false | turns on monitoring of the port |
905 | protocols | is_user_service | 1.0a105 | | 3 | boolean | false | false | true | indicates that a user may add and remove this service |
333 | architectures | bits | 1.0a108 | | 1 | int | false | false | true | the number of bits used by the architecture |
1769 | distro_files | pkey | 1.0a108 | | 0 | pkey | false | true | false | the unique pkey |
1770 | distro_files | operating_system_version | 1.0a108 | | 1 | fkey | false | false | false | the OS version that contains the file |
1772 | distro_files | path | 1.0a108 | | 2 | path | false | false | false | the full path to the file |
341 | operating_system_versions | architecture | 1.0a108 | | 4 | string | false | false | true | the name of the architecture |
343 | operating_system_versions | display | 1.0a108 | | 5 | string | false | true | true | the full display name for this version |
344 | operating_system_versions | is_aoserv_daemon_supported | 1.0a108 | | 6 | boolean | false | false | true | can AOServ Daemon be ran on this OS |
362 | technology_versions | operating_system_version | 1.0a108 | | 5 | fkey | true | false | true | the version of the OS that this packages is installed |
837 | mysql_db_users | create_tmp_table_priv | 1.0a111 | | 13 | boolean | false | false | false | the Create_tmp_table_priv |
838 | mysql_db_users | lock_tables_priv | 1.0a111 | | 14 | boolean | false | false | false | the Lock_tables_priv |
898 | mysql_server_users | max_connections | 1.0a111 | | 8 | int | false | false | false | the maximum number of connections to this database server, 0 means unlimited |
872 | mysql_users | show_db_priv | 1.0a111 | | 15 | boolean | false | false | false | |
873 | mysql_users | super_priv | 1.0a111 | | 16 | boolean | false | false | false | |
874 | mysql_users | create_tmp_table_priv | 1.0a111 | | 17 | boolean | false | false | false | |
875 | mysql_users | lock_tables_priv | 1.0a111 | | 18 | boolean | false | false | false | |
876 | mysql_users | execute_priv | 1.0a111 | | 19 | boolean | false | false | false | |
877 | mysql_users | repl_slave_priv | 1.0a111 | | 20 | boolean | false | false | false | |
878 | mysql_users | repl_client_priv | 1.0a111 | | 21 | boolean | false | false | false | |
1004 | net_tcp_redirects | cps | 1.0a111 | | 1 | int | false | false | false | the maximum number of connections per second before the redirect is temporarily disabled |
1005 | net_tcp_redirects | cps_overload_sleep_time | 1.0a111 | | 2 | int | false | false | false | the number of seconds the service will be disabled |
1006 | net_tcp_redirects | destination_host | 1.0a111 | | 3 | hostname | false | false | false | the destination IP address or hostname, please note that hostnames are only resolved once on xinetd startup |
939 | net_devices | delete_route | 1.0a112 | | 4 | string | true | false | false | the default routing from the network scripts that should be removed |
942 | net_devices | network | 1.0a112 | | 6 | ip_address | true | false | false | the local network |
943 | net_devices | broadcast | 1.0a112 | | 7 | ip_address | true | false | false | the broadcast IP |
548 | private_ftp_servers | net_bind | 1.0a113 | | 0 | fkey | false | true | false | the root directory |
559 | private_ftp_servers | allow_anonymous | 1.0a113 | | 6 | boolean | false | false | false | enabled or disabled anonymous access to the server |
404 | email_attachment_blocks | pkey | 1.0a116 | | 0 | pkey | false | true | false | a unique, generated primary key |
405 | email_attachment_blocks | linux_server_account | 1.0a116 | | 1 | fkey | false | false | false | reference to the email inbox |
406 | email_attachment_blocks | extension | 1.0a116 | | 2 | string | false | false | false | the extension of the blocked files |
407 | email_attachment_types | extension | 1.0a116 | | 0 | string | false | true | true | the unique filename extension |
408 | email_attachment_types | description | 1.0a116 | | 1 | string | false | false | true | a brief description of the attachment type |
409 | email_attachment_types | is_default_block | 1.0a116 | | 2 | boolean | false | false | true | indicates that the type will be blocked by default |
55 | business_administrators | can_switch_users | 1.0a118 | | 20 | boolean | false | false | false | allows this person to switch users to any subaccounts |
698 | ao_servers | daemon_connect_bind | 1.0a119 | | 8 | fkey | true | false | false | the bind to connect to |
534 | email_sa_integration_modes | name | 1.0a120 | | 0 | string | false | true | true | the unique name of the mode |
535 | email_sa_integration_modes | display | 1.0a120 | | 1 | string | false | false | true | the display value for the mode |
536 | email_sa_integration_modes | sort_order | 1.0a120 | | 2 | int | false | false | true | |
761 | linux_server_accounts | junk_email_retention | 1.0a120 | | 14 | int | true | false | false | the number of days before messages in the Junk folder are automatically removed. |
762 | linux_server_accounts | sa_integration_mode | 1.0a120 | | 15 | string | false | false | false | the integration mode for SpamAssassin |
1257 | postgres_versions | minor_version | 1.0a121 | | 1 | string | false | false | true | the minor version for this version (used for installation at /usr/postgresql/<minor_version> |
237 | package_categories | name | 1.0a123 | | 0 | string | false | true | true | the category name |
239 | package_definition_limits | pkey | 1.0a123 | | 0 | pkey | false | true | false | the unique identifier for this limit |
240 | package_definition_limits | package_definition | 1.0a123 | | 1 | fkey | false | false | false | the pkey of the package definition |
241 | package_definition_limits | resource | 1.0a123 | | 2 | string | false | false | false | the resource name |
242 | package_definition_limits | soft_limit | 1.0a123 | | 3 | int | true | false | false | the number that may be used for additional charges are added, NULL means unlimited |
243 | package_definition_limits | hard_limit | 1.0a123 | | 4 | int | true | false | false | the maximum number that may be allocated, NULL means unlimited |
246 | package_definition_limits | additional_transaction_type | 1.0a123 | | 6 | string | true | false | false | |
247 | package_definitions | pkey | 1.0a123 | | 0 | pkey | false | true | false | the unique ID of the package definition |
251 | package_definitions | category | 1.0a123 | | 2 | string | false | false | false | the package category |
252 | package_definitions | name | 1.0a123 | | 3 | string | false | false | false | the name of the package |
253 | package_definitions | version | 1.0a123 | | 4 | string | false | false | false | the unique version of this package |
254 | package_definitions | display | 1.0a123 | | 5 | string | false | false | false | a short description for display use |
255 | package_definitions | description | 1.0a123 | | 6 | string | false | false | false | a description of the package definition |
258 | package_definitions | setup_fee_transaction_type | 1.0a123 | | 8 | string | true | false | false | |
261 | package_definitions | monthly_rate_transaction_type | 1.0a123 | | 10 | string | true | false | false | |
262 | package_definitions | active | 1.0a123 | | 11 | boolean | false | false | false | allows new accounts for this package |
263 | package_definitions | approved | 1.0a123 | | 12 | boolean | false | false | false | once approved a definition may be used for packages, but may not be modified |
270 | packages | package_definition | 1.0a123 | | 3 | fkey | false | false | false | the definition of the package |
313 | transaction_types | name | 1.0a123 | | 0 | string | false | true | true | the name of the type |
317 | transaction_types | is_credit | 1.0a123 | | 1 | boolean | false | false | true | indicates that this type of transaction represents payment or credit |
763 | linux_server_accounts | sa_required_score | 1.0a124 | | 16 | float | false | false | false | the minimum SpamAssassin score considered Junk |
1504 | tickets | contact_emails | 1.0a125 | | 17 | string | false | false | false | |
1505 | tickets | contact_phone_numbers | 1.0a125 | | 18 | string | false | false | false | |
1482 | tickets | accounting | 1.0a126 | | 3 | accounting | true | false | false | |
1485 | tickets | created_by | 1.0a126 | | 5 | username | true | false | false | |
381 | dns_records | ttl | 1.0a127 | | 11 | int | true | false | false | the time to live field |
400 | dns_zones | ttl | 1.0a127 | | 5 | int | false | false | false | |
1621 | httpd_sites | awstats_skip_files | 1.0a129 | | 10 | string | true | false | false | the SkipFiles setting for AWStats |
1538 | httpd_servers | timeout | 1.0a130 | | 11 | int | false | false | false | the timeout setting in seconds |
1499 | tickets | admin_priority | 1.10 | | 14 | string | true | false | false | |
704 | ao_servers | failover_batch_size | 1.12 | | 13 | int | false | false | false | the batch size used for failover replications coming from this server |
177 | failover_file_replications | retention | 1.13 | | 5 | short | false | false | false | the number of days backups will be kept |
182 | failover_file_replications | enabled | 1.15 | | 8 | boolean | false | false | false | the enabled flag for failovers |
1574 | httpd_site_authenticated_locations | pkey | 1.18 | | 0 | pkey | false | true | false | a generated primary key |
1575 | httpd_site_authenticated_locations | httpd_site | 1.18 | | 1 | fkey | false | false | false | the site that is being referenced |
1576 | httpd_site_authenticated_locations | path | 1.18 | | 2 | string | false | false | false | the path to protect, unique per httpd_site |
1577 | httpd_site_authenticated_locations | is_regular_expression | 1.18 | | 3 | boolean | false | false | false | regular expressions may be used, resulting in LocationMatch directives instead of Location |
1578 | httpd_site_authenticated_locations | auth_name | 1.18 | | 4 | string | false | false | false | the prompt given to the user during authentication |
1579 | httpd_site_authenticated_locations | auth_group_file | 1.18 | | 5 | path | false | false | false | the full path to the file containing the group list |
1580 | httpd_site_authenticated_locations | auth_user_file | 1.18 | | 6 | path | false | false | false | the full path to the file containing the user list |
1581 | httpd_site_authenticated_locations | require | 1.18 | | 7 | string | false | false | false | the require directive parameter(s) for Apache |
1652 | httpd_site_binds | redirect_to_primary_hostname | 1.19 | | 10 | boolean | false | false | false | tells that system to redirect any request that is not to either the IP address or the primary hostname to the primary hostname, while leaving the request path intact |
699 | ao_servers | time_zone | 1.2 | | 9 | string | true | false | false | the time zone setting for the server |
946 | net_devices | max_bit_rate | 1.2 | | 9 | long | true | false | false | the maximum bits per second for this network device |
721 | time_zones | name | 1.2 | | 0 | string | false | true | true | The unique name of this time zone |
772 | aoserv_permissions | name | 1.21 | | 0 | string | false | true | true | the unique name of the permission |
773 | aoserv_permissions | sort_order | 1.21 | | 1 | short | false | true | true | the sort order for the permission |
769 | business_administrator_permissions | pkey | 1.21 | | 0 | pkey | false | true | false | a generated primary key |
770 | business_administrator_permissions | username | 1.21 | | 1 | username | false | false | false | the username of the administrator with this permission |
771 | business_administrator_permissions | permission | 1.21 | | 2 | string | false | false | false | the name of the permission that has been granted |
1205 | encryption_keys | pkey | 1.23 | | 0 | pkey | false | true | false | a generated unique id |
1206 | encryption_keys | accounting | 1.23 | | 1 | accounting | false | false | false | the accounting code of the business that owns this key |
1207 | encryption_keys | id | 1.23 | | 2 | string | false | false | false | the id of the recipient who may decrypt the message |
1383 | signup_request_options | pkey | 1.23 | | 0 | pkey | false | true | false | a generate unique id |
1384 | signup_request_options | request | 1.23 | | 1 | fkey | false | false | false | the id of the request this option is part of |
1385 | signup_request_options | name | 1.23 | | 2 | string | false | false | false | the unique-per-request name of the option |
1386 | signup_request_options | value | 1.23 | | 3 | string | true | false | false | the value of the option |
1387 | signup_requests | pkey | 1.23 | | 0 | pkey | false | true | false | a generate unique id |
1390 | signup_requests | time | 1.23 | | 2 | time | false | false | false | the time the request was added |
1391 | signup_requests | ip_address | 1.23 | | 3 | ip_address | false | false | false | the IP address of the user who signed-up |
1392 | signup_requests | package_definition | 1.23 | | 4 | fkey | false | false | false | the pkey of the Package Definition requested |
1393 | signup_requests | business_name | 1.23 | | 5 | string | false | false | false | the name of the business |
1398 | signup_requests | business_address1 | 1.23 | | 8 | string | false | false | false | the street address of the business |
1399 | signup_requests | business_address2 | 1.23 | | 9 | string | true | false | false | the street address of the business |
1408 | signup_requests | ba_name | 1.23 | | 14 | string | false | false | false | the administrator's name |
1409 | signup_requests | ba_title | 1.23 | | 15 | string | true | false | false | the administrator's title |
1418 | signup_requests | ba_email | 1.23 | | 20 | email | false | false | false | the administrator's email address |
1419 | signup_requests | ba_address1 | 1.23 | | 21 | string | true | false | false | the street address of the administrator |
1420 | signup_requests | ba_address2 | 1.23 | | 22 | string | true | false | false | the street address of the administrator |
1429 | signup_requests | ba_username | 1.23 | | 27 | username | false | false | false | the username of the administrator |
1430 | signup_requests | billing_contact | 1.23 | | 28 | string | false | false | false | the name of the billing contact |
1431 | signup_requests | billing_email | 1.23 | | 29 | email | false | false | false | the email address of the billing contact |
1432 | signup_requests | billing_use_monthly | 1.23 | | 30 | boolean | false | false | false | if true, the credit_card will be used every month automatically |
1433 | signup_requests | billing_pay_one_year | 1.23 | | 31 | boolean | false | false | false | if true, one-year in advance will be charged to the credit_card and they will receive a credit for a free month |
1434 | signup_requests | encrypted_data | 1.23 | | 32 | string | false | false | false | the credit card details and password are stored encrypted |
1438 | signup_requests | completed_by | 1.23 | | 35 | username | true | false | false | the username of the person who completed this sign-up request |
1439 | signup_requests | completed_time | 1.23 | | 36 | time | true | false | false | the time this request was completed |
282 | packages | email_in_burst | 1.24 | | 7 | int | true | false | false | the maximum burst of inbound email before limiting begins |
283 | packages | email_in_rate | 1.24 | | 8 | float | true | false | false | the number of sustained inbound emails per second |
284 | packages | email_out_burst | 1.24 | | 9 | int | true | false | false | the maximum burst of outbound email before limiting begins |
285 | packages | email_out_rate | 1.24 | | 10 | float | true | false | false | the number of sustained outbound emails per second |
286 | packages | email_relay_burst | 1.24 | | 11 | int | true | false | false | the maximum burst of relay email before limiting begins |
287 | packages | email_relay_rate | 1.24 | | 12 | float | true | false | false | the number of sustained relay emails per second |
583 | server_farms | use_restricted_smtp_port | 1.26 | | 3 | boolean | false | false | false | outgoing servers should use restricted source ports (affects firewall rules) |
1224 | postgres_databases | enable_postgis | 1.27 | | 7 | boolean | false | false | false | indicates PostGIS is enabled on this database |
1258 | postgres_versions | postgis_version | 1.27 | | 2 | fkey | true | false | true | a reference to the PostGIS defails in the <code>technology_versions</code> table |
198 | failover_mysql_replications | pkey | 1.28 | | 0 | pkey | false | true | false | a generated, unique id |
202 | failover_mysql_replications | mysql_server | 1.28 | | 3 | fkey | false | false | false | the MySQL Server that is being replicated |
78 | bank_transactions | processor | 1.29 | | 3 | string | true | false | false | the credit card processor used by this transaction |
1175 | credit_card_processors | provider_id | 1.29 | | 0 | string | false | true | false | the unique ID of this processor |
1176 | credit_card_processors | accounting | 1.29 | | 1 | accounting | false | false | false | the accounting code of the business owning the merchant account |
1177 | credit_card_processors | class_name | 1.29 | | 2 | string | false | false | false | the classname of the Java code that connects to the merchant services provider |
1178 | credit_card_processors | param1 | 1.29 | | 3 | string | true | false | false | the optional parameters for the Java code that connects to the merchant services provider |
1179 | credit_card_processors | param2 | 1.29 | | 4 | string | true | false | false | the optional parameters for the Java code that connects to the merchant services provider |
1180 | credit_card_processors | param3 | 1.29 | | 5 | string | true | false | false | the optional parameters for the Java code that connects to the merchant services provider |
1181 | credit_card_processors | param4 | 1.29 | | 6 | string | true | false | false | the optional parameters for the Java code that connects to the merchant services provider |
1182 | credit_card_processors | enabled | 1.29 | | 7 | boolean | false | false | false | the enabled flag |
1183 | credit_card_processors | weight | 1.29 | | 8 | int | false | false | false | the weight used for multi-processor weighted transaction distribution |
1184 | credit_card_processors | description | 1.29 | | 9 | string | true | false | false | an optional description of the processor |
1064 | credit_card_transactions | pkey | 1.29 | | 0 | pkey | false | true | false | the unique ID of this transaction |
1065 | credit_card_transactions | processor_id | 1.29 | | 1 | string | false | false | false | the name of the processor used for this transaction |
1066 | credit_card_transactions | accounting | 1.29 | | 2 | accounting | false | false | false | the accounting code for the source of this transaction |
1067 | credit_card_transactions | group_name | 1.29 | | 3 | string | true | false | false | the application-provided grouping for this transaction |
1068 | credit_card_transactions | test_mode | 1.29 | | 4 | boolean | false | false | false | indicates this is a test transaction |
1069 | credit_card_transactions | duplicate_window | 1.29 | | 5 | int | false | false | false | the number of seconds for duplicate transaction detection |
1070 | credit_card_transactions | order_number | 1.29 | | 6 | string | true | false | false | the merchant-provided order number for this transaction |
1078 | credit_card_transactions | tax_exempt | 1.29 | | 9 | boolean | false | false | false | the taxExempt flag for this transaction |
1085 | credit_card_transactions | shipping_first_name | 1.29 | | 12 | string | true | false | false | the shipping first name |
1086 | credit_card_transactions | shipping_last_name | 1.29 | | 13 | string | true | false | false | the shipping last name |
1087 | credit_card_transactions | shipping_company_name | 1.29 | | 14 | string | true | false | false | the shipping company name |
1088 | credit_card_transactions | shipping_street_address1 | 1.29 | | 15 | string | true | false | false | the shipping address line 1 |
1089 | credit_card_transactions | shipping_street_address2 | 1.29 | | 16 | string | true | false | false | the shipping address line 2 |
1098 | credit_card_transactions | email_customer | 1.29 | | 21 | boolean | false | false | false | the flag indicating the API should generate an email to the customer |
1099 | credit_card_transactions | merchant_email | 1.29 | | 22 | email | true | false | false | the email address of the merchant |
1100 | credit_card_transactions | invoice_number | 1.29 | | 23 | string | true | false | false | the merchant-provided invoice number |
1101 | credit_card_transactions | purchase_order_number | 1.29 | | 24 | string | true | false | false | the merchant-provided purchase order number |
1102 | credit_card_transactions | description | 1.29 | | 25 | string | true | false | false | the merchant-provided description of this transaction |
1103 | credit_card_transactions | credit_card_created_by | 1.29 | | 26 | username | false | false | false | the business administrator account that provided this credit card |
1104 | credit_card_transactions | credit_card_principal_name | 1.29 | | 27 | string | true | false | false | the application-provided principal who provided this credit card |
1105 | credit_card_transactions | credit_card_accounting | 1.29 | | 28 | accounting | false | false | false | the accounting code of the business that provided this credit card |
1106 | credit_card_transactions | credit_card_group_name | 1.29 | | 29 | string | true | false | false | any application-specific grouping |
1107 | credit_card_transactions | credit_card_provider_unique_id | 1.29 | | 30 | string | true | false | false | the unique ID provided by the merchant services provider storage mechanism |
1108 | credit_card_transactions | credit_card_masked_card_number | 1.29 | | 31 | string | false | false | false | the masked card number |
1111 | credit_card_transactions | credit_card_first_name | 1.29 | | 34 | string | false | false | false | the first name of the card holder |
1112 | credit_card_transactions | credit_card_last_name | 1.29 | | 35 | string | false | false | false | the last name of the card holder |
1113 | credit_card_transactions | credit_card_company_name | 1.29 | | 36 | string | true | false | false | the company name for the credit card |
1114 | credit_card_transactions | credit_card_email | 1.29 | | 37 | email | true | false | false | the email address of the card holder |
1115 | credit_card_transactions | credit_card_phone | 1.29 | | 38 | phone | true | false | false | the phone number of the card holder |
1116 | credit_card_transactions | credit_card_fax | 1.29 | | 39 | phone | true | false | false | the fax number of the card holder |
1118 | credit_card_transactions | credit_card_customer_tax_id | 1.29 | | 41 | string | true | false | false | the tax ID of the card holder |
1119 | credit_card_transactions | credit_card_street_address1 | 1.29 | | 42 | string | false | false | false | the street address of the card holder (line 1) |
1120 | credit_card_transactions | credit_card_street_address2 | 1.29 | | 43 | string | true | false | false | the street address of the card holder (line 2) |
1129 | credit_card_transactions | credit_card_comments | 1.29 | | 48 | string | true | false | false | any comments associated with the credit card |
1130 | credit_card_transactions | authorization_time | 1.29 | | 49 | time | false | false | false | the time the authorization was attempted |
1131 | credit_card_transactions | authorization_username | 1.29 | | 50 | username | false | false | false | the username of the business_administrator account that processed the transaction |
1132 | credit_card_transactions | authorization_principal_name | 1.29 | | 51 | string | true | false | false | an application-provided identity of the user who initiated the transaction |
1133 | credit_card_transactions | authorization_communication_result | 1.29 | | 52 | string | true | false | false | the authorization communication result |
1134 | credit_card_transactions | authorization_provider_error_code | 1.29 | | 53 | string | true | false | false | the provider-specific error code |
1135 | credit_card_transactions | authorization_error_code | 1.29 | | 54 | string | true | false | false | the provider-neutral error code |
1136 | credit_card_transactions | authorization_provider_error_message | 1.29 | | 55 | string | true | false | false | the provider-specific error message |
1137 | credit_card_transactions | authorization_provider_unique_id | 1.29 | | 56 | string | true | false | false | the per-provider unique ID |
1143 | credit_card_transactions | authorization_provider_approval_result | 1.29 | | 62 | string | true | false | false | the provider-specific approval result |
1144 | credit_card_transactions | authorization_approval_result | 1.29 | | 63 | string | true | false | false | the provider-neutral approval result |
1145 | credit_card_transactions | authorization_provider_decline_reason | 1.29 | | 64 | string | true | false | false | the provider-specific decline reason |
1146 | credit_card_transactions | authorization_decline_reason | 1.29 | | 65 | string | true | false | false | the provider-neutral decline reason |
1147 | credit_card_transactions | authorization_provider_review_reason | 1.29 | | 66 | string | true | false | false | the provider-specific review reason |
1148 | credit_card_transactions | authorization_review_reason | 1.29 | | 67 | string | true | false | false | the provider-neutral review reason |
1149 | credit_card_transactions | authorization_provider_cvv_result | 1.29 | | 68 | string | true | false | false | the provider-specific CVV result |
1150 | credit_card_transactions | authorization_cvv_result | 1.29 | | 69 | string | true | false | false | the provider-neutral CVV result |
1151 | credit_card_transactions | authorization_provider_avs_result | 1.29 | | 70 | string | true | false | false | the provider-specific AVS result |
1152 | credit_card_transactions | authorization_avs_result | 1.29 | | 71 | string | true | false | false | the provider-neutral AVS result |
1153 | credit_card_transactions | authorization_approval_code | 1.29 | | 72 | string | true | false | false | the approval code |
1154 | credit_card_transactions | capture_time | 1.29 | | 73 | time | true | false | false | the time the capture was attempted |
1155 | credit_card_transactions | capture_username | 1.29 | | 74 | username | true | false | false | the username of the business_administrator account that processed the capture |
1156 | credit_card_transactions | capture_principal_name | 1.29 | | 75 | string | true | false | false | an application-provided identity of the user who initiated the capture |
1157 | credit_card_transactions | capture_communication_result | 1.29 | | 76 | string | true | false | false | the capture communication result |
1158 | credit_card_transactions | capture_provider_error_code | 1.29 | | 77 | string | true | false | false | the provider-specific error code |
1159 | credit_card_transactions | capture_error_code | 1.29 | | 78 | string | true | false | false | the provider-neutral error code |
1160 | credit_card_transactions | capture_provider_error_message | 1.29 | | 79 | string | true | false | false | the provider-specific error message |
1161 | credit_card_transactions | capture_provider_unique_id | 1.29 | | 80 | string | true | false | false | the per-provider unique ID |
1162 | credit_card_transactions | void_time | 1.29 | | 81 | time | true | false | false | the time the void was attempted |
1163 | credit_card_transactions | void_username | 1.29 | | 82 | username | true | false | false | the username of the business_administrator account that processed the void |
1164 | credit_card_transactions | void_principal_name | 1.29 | | 83 | string | true | false | false | an application-provided identity of the user who initiated the void |
1165 | credit_card_transactions | void_communication_result | 1.29 | | 84 | string | true | false | false | the void communication result |
1166 | credit_card_transactions | void_provider_error_code | 1.29 | | 85 | string | true | false | false | the provider-specific error code |
1167 | credit_card_transactions | void_error_code | 1.29 | | 86 | string | true | false | false | the provider-neutral error code |
1168 | credit_card_transactions | void_provider_error_message | 1.29 | | 87 | string | true | false | false | the provider-specific error message |
1169 | credit_card_transactions | void_provider_unique_id | 1.29 | | 88 | string | true | false | false | the per-provider unique ID |
1170 | credit_card_transactions | status | 1.29 | | 89 | string | false | false | false | the status of the transaction |
1016 | credit_cards | processor_id | 1.29 | | 1 | string | false | false | false | the unique ID of the merchant services provider that is storing the card number and expiration date |
1018 | credit_cards | group_name | 1.29 | | 3 | string | true | false | false | any application-specific grouping |
1023 | credit_cards | provider_unique_id | 1.29 | | 7 | string | false | false | false | the per-provider unique ID allowing use of this credit card for new transactions |
1027 | credit_cards | first_name | 1.29 | | 8 | string | false | false | false | the first name |
1028 | credit_cards | last_name | 1.29 | | 9 | string | false | false | false | the last name |
1029 | credit_cards | company_name | 1.29 | | 10 | string | true | false | false | the company name |
1030 | credit_cards | email | 1.29 | | 11 | email | true | false | false | the email address |
1031 | credit_cards | phone | 1.29 | | 12 | phone | true | false | false | the daytime phone number |
1032 | credit_cards | fax | 1.29 | | 13 | phone | true | false | false | the fax number |
1034 | credit_cards | customer_tax_id | 1.29 | | 15 | string | true | false | false | the social security number of employer identification number |
1036 | credit_cards | street_address1 | 1.29 | | 16 | string | false | false | false | the first line of the street address |
1037 | credit_cards | street_address2 | 1.29 | | 17 | string | true | false | false | the second line of the street address |
1051 | credit_cards | principal_name | 1.29 | | 24 | string | true | false | false | the application-provided principal name of the person added the card to the database |
308 | transactions | processor | 1.29 | | 11 | string | true | false | false | the credit card processor that handled the payment |
309 | transactions | credit_card_transaction | 1.29 | | 12 | fkey | true | false | false | the credit card transaction for this transaction |
345 | operating_system_versions | sort_order | 1.3 | | 7 | short | false | true | true | the default sort order |
1185 | credit_card_processors | encryption_from | 1.31 | | 10 | fkey | false | false | false | the from that will be used for encryption |
1186 | credit_card_processors | encryption_recipient | 1.31 | | 11 | fkey | false | false | false | the recipient that will be used for encryption |
1058 | credit_cards | encrypted_card_number | 1.31 | | 30 | string | true | false | false | the card number stored encrypted |
1059 | credit_cards | encryption_card_number_from | 1.31 | | 31 | fkey | true | false | false | the from that was used for card number encryption |
1060 | credit_cards | encryption_card_number_recipient | 1.31 | | 32 | fkey | true | false | false | the recipient that was used for card number encryption |
446 | email_lists | linux_server_account | 1.31 | | 2 | fkey | false | false | false | the linux_server_account that owns the list |
448 | email_lists | linux_server_group | 1.31 | | 3 | fkey | false | false | false | the linux_server_group that the list belongs to please note that ownership and server are derived from this value |
170 | failover_file_replications | server | 1.31 | | 1 | fkey | false | false | false | the pkey of the server that the files are coming from |
172 | failover_file_replications | backup_partition | 1.31 | | 2 | fkey | false | false | false | the pkey of the backup partition that the files are going to |
166 | failover_file_schedule | minute | 1.31 | | 3 | short | false | false | false | the minute (in server timezone) |
190 | file_backup_settings | replication | 1.31 | | 1 | fkey | false | false | false | the pkey of the failover_file_replication configured |
194 | file_backup_settings | backup_enabled | 1.31 | | 3 | boolean | false | false | false | the enabled flag for this prefix |
439 | linux_acc_addresses | linux_server_account | 1.31 | | 2 | fkey | false | false | false | reference to linux_server_accounts |
826 | mysql_db_users | mysql_server_user | 1.31 | | 2 | fkey | false | false | false | the pkey in mysql_server_users |
968 | servers | operating_system_version | 1.31 | | 3 | fkey | true | false | false | the version of operating system running on the server, if known |
972 | servers | package | 1.31 | | 4 | fkey | false | false | false | the package accountable for resources used by the server |
973 | servers | name | 1.31 | | 5 | string | false | false | false | the per-package unique name of the server (no special formatting required) |
1435 | signup_requests | encryption_from | 1.31 | | 33 | fkey | false | false | false | the from that was used for encryption |
1437 | signup_requests | encryption_recipient | 1.31 | | 34 | fkey | false | false | false | the recipient that was used for encryption |
974 | servers | monitoring_enabled | 1.32 | | 6 | boolean | false | false | false | enables/disables monitoring |
915 | net_binds | server | 1.33 | | 2 | fkey | false | false | false | the pkey of the server that this port is bound on |
934 | net_devices | server | 1.33 | | 1 | fkey | false | false | false | the pkey of the server that contains the device |
705 | ao_servers | monitoring_load_low | 1.35 | | 14 | float | true | false | false | the 5-minute load average that will trigger a low-level alert |
706 | ao_servers | monitoring_load_medium | 1.35 | | 15 | float | true | false | false | the 5-minute load average that will trigger a medium-level alert |
707 | ao_servers | monitoring_load_high | 1.35 | | 16 | float | true | false | false | the 5-minute load average that will trigger a high-level alert |
708 | ao_servers | monitoring_load_critical | 1.35 | | 17 | float | true | false | false | the 5-minute load average that will trigger a critical-level alert |
947 | net_devices | monitoring_bit_rate_low | 1.35 | | 10 | long | true | false | false | the 5-minute average that will trigger a low-level alert |
948 | net_devices | monitoring_bit_rate_medium | 1.35 | | 11 | long | true | false | false | the 5-minute average that will trigger a medium-level alert |
949 | net_devices | monitoring_bit_rate_high | 1.35 | | 12 | long | true | false | false | the 5-minute average that will trigger a high-level alert |
950 | net_devices | monitoring_bit_rate_critical | 1.35 | | 13 | long | true | false | false | the 5-minute average that will trigger a critical-level alert |
560 | physical_servers | server | 1.36 | | 0 | fkey | false | true | false | a reference to servers |
561 | physical_servers | rack | 1.36 | | 1 | fkey | true | false | false | the rack that houses this server |
562 | physical_servers | rack_units | 1.36 | | 2 | short | true | false | false | the number of rack units |
563 | physical_servers | ram | 1.36 | | 3 | int | true | false | false | the total number of megabytes of RAM in this server |
564 | physical_servers | processor_type | 1.36 | | 4 | string | true | false | false | the processor type |
565 | physical_servers | processor_speed | 1.36 | | 5 | int | true | false | false | the processor speed in MHz |
566 | physical_servers | processor_cores | 1.36 | | 6 | int | true | false | false | the total number of processor cores, hyperthreads are counted as different cores |
567 | physical_servers | max_power | 1.36 | | 7 | float | true | false | false | the number of amps this server consumes under peak load |
570 | processor_types | type | 1.36 | | 0 | string | false | true | true | the unique name of the type of processor |
571 | processor_types | sort_order | 1.36 | | 1 | short | false | true | true | the sort order of the processor, those sorted higher may be substituted for those sorted lower |
572 | racks | pkey | 1.36 | | 0 | pkey | false | true | false | the unique ID for the rack |
573 | racks | farm | 1.36 | | 1 | string | false | false | false | the server_farm housing the rack |
574 | racks | name | 1.36 | | 2 | string | false | false | false | the per-farm unique name |
575 | racks | max_power | 1.36 | | 3 | float | true | false | false | the maximum electrical load supported by the rack |
576 | racks | total_rack_units | 1.36 | | 4 | int | true | false | false | the number of rack units of physical space |
584 | virtual_disks | pkey | 1.36 | | 0 | pkey | false | true | false | a generated unique ID |
585 | virtual_disks | virtual_server | 1.36 | | 1 | fkey | false | false | false | the virtual server this disk belongs to |
586 | virtual_disks | device | 1.36 | | 2 | string | false | false | false | the per-virtual-server unique device, such as xvda or xvdb |
597 | virtual_disks | extents | 1.36 | | 5 | int | false | false | false | the total number of LVM extents for this device |
606 | virtual_servers | server | 1.36 | | 0 | fkey | false | true | false | the server that is virtualized |
607 | virtual_servers | primary_ram | 1.36 | | 1 | int | false | false | false | the amount of RAM required in primary mode in megabytes |
609 | virtual_servers | secondary_ram | 1.36 | | 3 | int | true | false | false | the amount of RAM required in primary mode in megabytes or 0 if secondary not required |
614 | virtual_servers | minimum_processor_architecture | 1.36 | | 6 | string | false | false | false | the minimum processor architecture, compatible architectures may be substituted |
628 | virtual_servers | primary_physical_server_locked | 1.36 | | 13 | boolean | false | false | false | indicates the primary server is locked and should not be moved by automated means |
630 | virtual_servers | secondary_physical_server_locked | 1.36 | | 14 | boolean | false | false | false | indicates the secondary server is locked and should not be moved by automated means |
568 | physical_servers | supports_hvm | 1.37 | | 8 | boolean | true | false | false | indicates supports full hardware virtualization |
631 | virtual_servers | requires_hvm | 1.37 | | 15 | boolean | false | false | false | indicates requires full hardware virtualization |
999 | ip_addresses | netmask | 1.38 | | 11 | string | false | false | false | the netmask of the local network |
817 | mysql_databases | mysql_server | 1.4 | | 2 | fkey | false | false | false | the pkey of the server that this database is hosted on |
839 | mysql_db_users | create_view_priv | 1.4 | | 15 | boolean | false | false | false | the Create_view_priv |
840 | mysql_db_users | show_view_priv | 1.4 | | 16 | boolean | false | false | false | the Show_view_priv |
841 | mysql_db_users | create_routine_priv | 1.4 | | 17 | boolean | false | false | false | the Create_routine_priv |
842 | mysql_db_users | alter_routine_priv | 1.4 | | 18 | boolean | false | false | false | the Alter_routine_priv |
843 | mysql_db_users | execute_priv | 1.4 | | 19 | boolean | false | false | false | the Execute_priv |
891 | mysql_server_users | mysql_server | 1.4 | | 2 | fkey | false | false | false | the pkey of the MySQL server |
896 | mysql_server_users | max_questions | 1.4 | | 6 | int | false | false | false | the maximum number of questions to this database server, 0 means unlimited |
897 | mysql_server_users | max_updates | 1.4 | | 7 | int | false | false | false | the maximum number of updates to this database server, 0 means unlimited |
899 | mysql_server_users | max_user_connections | 1.4 | | 9 | int | false | false | false | the maximum number of user connections to this database server, 0 means unlimited |
850 | mysql_servers | ao_server | 1.4 | | 2 | fkey | false | false | false | the pkey of the server that this database is hosted on |
851 | mysql_servers | version | 1.4 | | 3 | fkey | false | false | false | the pkey of the MySQL version |
852 | mysql_servers | max_connections | 1.4 | | 4 | int | false | false | false | the maximum number of connections for the db |
879 | mysql_users | create_view_priv | 1.4 | | 22 | boolean | false | false | false | |
880 | mysql_users | show_view_priv | 1.4 | | 23 | boolean | false | false | false | |
881 | mysql_users | create_routine_priv | 1.4 | | 24 | boolean | false | false | false | |
882 | mysql_users | alter_routine_priv | 1.4 | | 25 | boolean | false | false | false | |
883 | mysql_users | create_user_priv | 1.4 | | 26 | boolean | false | false | false | |
346 | technologies | pkey | 1.4 | | 0 | pkey | false | true | true | the unique identifier |
764 | linux_server_accounts | sa_discard_score | 1.40 | | 17 | int | true | false | false | the minimum SpamAssassin score that will be discarded instead of tagged or placed in the Junk folder |
593 | virtual_disks | minimum_disk_speed | 1.41 | | 3 | int | true | false | false | the minimum disk speed in RPM for the primary physical server |
598 | virtual_disks | weight | 1.41 | | 6 | short | false | false | false | the amount of primary disk I/O allocated to this virtual device on a scale of 1-1024 |
611 | virtual_servers | minimum_processor_type | 1.41 | | 5 | string | true | false | false | the minimum processor type |
615 | virtual_servers | minimum_processor_speed | 1.41 | | 7 | int | true | false | false | the minimum processor speed in MHz |
619 | virtual_servers | processor_cores | 1.41 | | 9 | short | false | false | false | the number of processor cores |
623 | virtual_servers | processor_weight | 1.41 | | 11 | short | false | false | false | the processor allocation weight on a scale of 1-1024 |
594 | virtual_disks | minimum_disk_speed_target | 1.43 | | 4 | int | true | false | false | the minimum disk speed in RPM for the primary physical server |
599 | virtual_disks | weight_target | 1.43 | | 7 | short | false | false | false | the amount of primary disk I/O allocated to this virtual device on a scale of 1-1024 |
608 | virtual_servers | primary_ram_target | 1.43 | | 2 | int | false | false | false | the amount of RAM required in primary mode in megabytes |
610 | virtual_servers | secondary_ram_target | 1.43 | | 4 | int | true | false | false | the amount of RAM required in primary mode in megabytes or 0 if secondary not required |
616 | virtual_servers | minimum_processor_speed_target | 1.43 | | 8 | int | true | false | false | the minimum processor speed in MHz |
620 | virtual_servers | processor_cores_target | 1.43 | | 10 | short | false | false | false | the number of processor cores |
624 | virtual_servers | processor_weight_target | 1.43 | | 12 | short | false | false | false | the processor allocation weight on a scale of 1-1024 |
1263 | brands | accounting | 1.44 | | 0 | accounting | false | true | false | |
1272 | brands | smtp_linux_server_account | 1.44 | | 5 | fkey | false | true | false | |
1274 | brands | smtp_password | 1.44 | | 7 | string | false | false | false | |
1275 | brands | imap_linux_server_account | 1.44 | | 8 | fkey | false | true | false | |
1277 | brands | imap_password | 1.44 | | 10 | string | false | false | false | |
1278 | brands | support_email_address | 1.44 | | 11 | fkey | false | true | false | |
1279 | brands | support_email_display | 1.44 | | 12 | string | false | true | false | |
1280 | brands | signup_email_address | 1.44 | | 13 | fkey | false | true | false | |
1281 | brands | signup_email_display | 1.44 | | 14 | string | false | true | false | |
1282 | brands | ticket_encryption_from | 1.44 | | 15 | fkey | false | false | false | |
1283 | brands | ticket_encryption_recipient | 1.44 | | 16 | fkey | false | false | false | |
1284 | brands | signup_encryption_from | 1.44 | | 17 | fkey | false | false | false | |
1285 | brands | signup_encryption_recipient | 1.44 | | 18 | fkey | false | false | false | |
1296 | brands | support_mailing_address1 | 1.44 | | 24 | string | true | false | false | |
1297 | brands | support_mailing_address2 | 1.44 | | 25 | string | true | false | false | |
1298 | brands | support_mailing_address3 | 1.44 | | 26 | string | true | false | false | |
1299 | brands | support_mailing_address4 | 1.44 | | 27 | string | true | false | false | |
1300 | brands | english_enabled | 1.44 | | 28 | boolean | false | false | false | |
1301 | brands | japanese_enabled | 1.44 | | 29 | boolean | false | false | false | |
1302 | brands | aoweb_struts_http_url_base | 1.44 | | 30 | string | false | false | false | |
1303 | brands | aoweb_struts_https_url_base | 1.44 | | 31 | string | false | false | false | |
1304 | brands | aoweb_struts_google_verify_content | 1.44 | | 32 | string | true | false | false | |
1305 | brands | aoweb_struts_noindex | 1.44 | | 33 | boolean | false | false | false | |
1306 | brands | aoweb_struts_google_analytics_new_tracking_code | 1.44 | | 34 | string | true | false | false | |
1307 | brands | aoweb_struts_signup_admin_address | 1.44 | | 35 | string | false | false | false | |
56 | business_administrators | support_code | 1.44 | | 21 | string | true | true | false | used to authenticate for email-based supprt |
1473 | languages | code | 1.44 | | 0 | string | false | true | true | the language code |
1314 | resellers | accounting | 1.44 | | 0 | accounting | false | true | false | |
1315 | resellers | ticket_auto_escalate | 1.44 | | 1 | boolean | false | false | false | |
1389 | signup_requests | brand | 1.44 | | 1 | accounting | false | false | false | the brand of the parent business for the new account |
1467 | ticket_action_types | type | 1.44 | | 0 | string | false | true | true | |
1468 | ticket_action_types | visible_admin_only | 1.44 | | 1 | boolean | false | false | true | |
1440 | ticket_actions | pkey | 1.44 | | 0 | pkey | false | true | false | |
1441 | ticket_actions | ticket | 1.44 | | 1 | fkey | false | false | false | |
1442 | ticket_actions | administrator | 1.44 | | 2 | username | true | false | false | |
1443 | ticket_actions | time | 1.44 | | 3 | time | false | false | false | |
1444 | ticket_actions | action_type | 1.44 | | 4 | string | false | false | false | |
1449 | ticket_actions | old_priority | 1.44 | | 7 | string | true | false | false | |
1450 | ticket_actions | new_priority | 1.44 | | 8 | string | true | false | false | |
1453 | ticket_actions | old_status | 1.44 | | 11 | string | true | false | false | |
1454 | ticket_actions | new_status | 1.44 | | 12 | string | true | false | false | |
1459 | ticket_actions | old_category | 1.44 | | 15 | fkey | true | false | false | |
1460 | ticket_actions | new_category | 1.44 | | 16 | fkey | true | false | false | |
1461 | ticket_actions | old_value | 1.44 | | 17 | string | true | false | false | |
1462 | ticket_actions | new_value | 1.44 | | 18 | string | true | false | false | |
1463 | ticket_actions | from_address | 1.44 | | 19 | email | true | false | false | |
1464 | ticket_actions | summary | 1.44 | | 20 | string | true | false | false | |
1465 | ticket_actions | details | 1.44 | | 21 | string | true | false | false | |
1466 | ticket_actions | raw_email | 1.44 | | 22 | string | true | false | false | |
1469 | ticket_assignments | pkey | 1.44 | | 0 | pkey | false | true | false | |
1470 | ticket_assignments | ticket | 1.44 | | 1 | fkey | false | false | false | |
1471 | ticket_assignments | reseller | 1.44 | | 2 | accounting | false | false | false | |
1472 | ticket_assignments | administrator | 1.44 | | 3 | username | false | false | false | |
1259 | ticket_brand_categories | pkey | 1.44 | | 0 | pkey | false | true | false | |
1260 | ticket_brand_categories | brand | 1.44 | | 1 | accounting | false | false | false | |
1261 | ticket_brand_categories | category | 1.44 | | 2 | fkey | false | false | false | |
1262 | ticket_brand_categories | enabled | 1.44 | | 3 | boolean | false | false | false | |
1311 | ticket_categories | pkey | 1.44 | | 0 | pkey | false | true | false | |
1312 | ticket_categories | parent | 1.44 | | 1 | fkey | true | false | false | |
1313 | ticket_categories | name | 1.44 | | 2 | string | false | false | false | |
1477 | ticket_stati | sort_order | 1.44 | | 1 | short | false | true | true | |
1480 | tickets | reseller | 1.44 | | 2 | accounting | false | false | false | |
1483 | tickets | language | 1.44 | | 4 | string | false | false | false | |
1486 | tickets | category | 1.44 | | 6 | fkey | true | false | false | |
1488 | tickets | from_address | 1.44 | | 8 | email | true | false | false | |
1489 | tickets | summary | 1.44 | | 9 | string | false | false | false | |
1491 | tickets | details | 1.44 | | 10 | string | true | false | false | |
1492 | tickets | raw_email | 1.44 | | 11 | string | true | false | false | |
250 | package_definitions | accounting | 1.45 | | 1 | accounting | false | false | false | the accounting code of the seller/reseller that supports this package |
1273 | brands | smtp_host | 1.46 | | 6 | hostname | true | false | false | |
1276 | brands | imap_host | 1.46 | | 9 | hostname | true | false | false | |
1479 | tickets | brand | 1.46 | | 1 | accounting | false | false | false | |
1451 | ticket_actions | old_type | 1.49 | | 9 | string | true | false | false | |
1452 | ticket_actions | new_type | 1.49 | | 10 | string | true | false | false | |
2456 | httpd_tomcat_data_sources | pkey | 1.5 | | 0 | pkey | false | true | false | a generated unique key |
2457 | httpd_tomcat_data_sources | tomcat_context | 1.5 | | 1 | fkey | false | false | false | the context this data source is for |
2458 | httpd_tomcat_data_sources | name | 1.5 | | 2 | string | false | false | false | the JNDI name |
2459 | httpd_tomcat_data_sources | driver_class_name | 1.5 | | 3 | string | false | false | false | fully qualified Java class name of the JDBC driver to be used |
2460 | httpd_tomcat_data_sources | url | 1.5 | | 4 | string | false | false | false | connection URL to be passed to our JDBC driver |
2461 | httpd_tomcat_data_sources | username | 1.5 | | 5 | string | false | false | false | database username to be passed to our JDBC driver |
2462 | httpd_tomcat_data_sources | password | 1.5 | | 6 | string | false | false | false | database password to be passed to our JDBC driver |
2463 | httpd_tomcat_data_sources | max_active | 1.5 | | 7 | int | false | false | false | the maximum number of active instances that can be allocated from this pool at the same time |
2464 | httpd_tomcat_data_sources | max_idle | 1.5 | | 8 | int | false | false | false | the maximum number of connections that can sit idle in this pool at the same time |
2465 | httpd_tomcat_data_sources | max_wait | 1.5 | | 9 | int | false | false | false | the maximum number of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception |
2466 | httpd_tomcat_data_sources | validation_query | 1.5 | | 10 | string | true | false | false | SQL query that can be used by the pool to validate connections before they are returned to the application. If specified, this query MUST be an SQL SELECT statement that returns at least one row. |
2467 | httpd_tomcat_parameters | pkey | 1.5 | | 0 | pkey | false | true | false | a generated unique key |
2468 | httpd_tomcat_parameters | tomcat_context | 1.5 | | 1 | fkey | false | false | false | the context this parameter is for |
2469 | httpd_tomcat_parameters | name | 1.5 | | 2 | string | false | false | false | the name of the context initialization parameter to be created |
2470 | httpd_tomcat_parameters | value | 1.5 | | 3 | string | false | false | false | the parameter value that will be presented to the application when requested by calling ServletContext.getInitParameter() |
2471 | httpd_tomcat_parameters | override | 1.5 | | 4 | boolean | false | false | false | set this to false if you do not want a <context-param> for the same parameter name, found in the web application deployment descriptor, to override the value specified here. By default, overrides are allowed. |
2472 | httpd_tomcat_parameters | description | 1.5 | | 5 | string | true | false | false | optional, human-readable description of this context initialization parameter |
13 | business_servers | can_vnc_console | 1.51 | | 10 | boolean | false | false | false | |
632 | virtual_servers | vnc_password | 1.51 | | 16 | string | false | true | false | the password for VNC console access or null to disable VNC access |
1308 | brands | aoweb_struts_vnc_bind | 1.52 | | 36 | fkey | false | true | false | |
1309 | brands | aoweb_struts_keystore_type | 1.53 | | 37 | string | false | false | false | |
1310 | brands | aoweb_struts_keystore_password | 1.53 | | 38 | string | false | false | false | |
844 | mysql_db_users | event_priv | 1.54 | | 20 | boolean | false | false | false | the Event_priv |
845 | mysql_db_users | trigger_priv | 1.54 | | 21 | boolean | false | false | false | the Trigger_priv |
884 | mysql_users | event_priv | 1.54 | | 27 | boolean | false | false | false | the Event_priv |
885 | mysql_users | trigger_priv | 1.54 | | 28 | boolean | false | false | false | the Trigger_priv |
203 | failover_mysql_replications | monitoring_seconds_behind_low | 1.56 | | 4 | int | true | false | false | the seconds behind where will trigger low alert level |
204 | failover_mysql_replications | monitoring_seconds_behind_medium | 1.56 | | 5 | int | true | false | false | the seconds behind where will trigger medium alert level |
205 | failover_mysql_replications | monitoring_seconds_behind_high | 1.56 | | 6 | int | true | false | false | the seconds behind where will trigger high alert level |
206 | failover_mysql_replications | monitoring_seconds_behind_critical | 1.56 | | 7 | int | true | false | false | the seconds behind where will trigger critical alert level |
523 | email_smtp_smart_host_domains | pkey | 1.57 | | 0 | pkey | false | true | false | a generated unique key |
524 | email_smtp_smart_host_domains | smart_host | 1.57 | | 1 | fkey | false | false | false | the Smart Host that is being configured |
527 | email_smtp_smart_host_domains | domain_out_burst | 1.57 | | 3 | int | true | false | false | the domain-specific email burst limit, null means unlimited |
528 | email_smtp_smart_host_domains | domain_out_rate | 1.57 | | 4 | float | true | false | false | the domain-specific email rate, null means unlimited |
529 | email_smtp_smart_hosts | net_bind | 1.57 | | 0 | fkey | false | true | false | a reference to the port that is being used as a Smart Host |
530 | email_smtp_smart_hosts | total_out_burst | 1.57 | | 1 | int | true | false | false | the aggregate email burst limit for all emails sent through this host, null means unlimited |
531 | email_smtp_smart_hosts | total_out_rate | 1.57 | | 2 | float | true | false | false | the sustained email rate for all emails sent through this host, null means unlimited |
532 | email_smtp_smart_hosts | default_domain_out_burst | 1.57 | | 3 | int | true | false | false | the default per-domain email burst limit when no domain-specific value is provided in email_smtp_smart_host_domains, null means unlimited |
533 | email_smtp_smart_hosts | default_domain_out_rate | 1.57 | | 4 | float | true | false | false | the default per-domain email rate when no domain-specific value is provided in email_smtp_smart_host_domains, null means unlimited |
929 | net_binds | monitoring_parameters | 1.58 | | 7 | string | true | false | false | the URL-encoded name=value pairs of monitoring parameters |
199 | failover_mysql_replications | ao_server | 1.59 | | 1 | fkey | true | false | false | the ao_server the receives the replication |
201 | failover_mysql_replications | replication | 1.59 | | 2 | fkey | true | false | false | the failover server that receives the replication |
174 | failover_file_replications | max_bit_rate | 1.61 | | 3 | long | true | false | false | the maximum bit rate for files being replicated |
197 | file_backup_settings | required | 1.62 | | 4 | boolean | false | false | false | indicates that backup pass will not be considered successful if file or path is missing |
569 | physical_servers | ups_type | 1.63 | | 9 | string | false | false | false | the type of UPS powering the server |
14 | business_servers | can_control_virtual_server | 1.64 | | 11 | boolean | false | false | false | |
2352 | ip_reputation_set_hosts | pkey | 1.65 | | 0 | long | false | true | false | a generated, unique key |
2357 | ip_reputation_set_hosts | good_reputation | 1.65 | | 3 | short | false | false | false | the current good reputation |
2358 | ip_reputation_set_hosts | bad_reputation | 1.65 | | 4 | short | false | false | false | the current bad repuation |
2384 | ip_reputation_set_networks | pkey | 1.65 | | 0 | long | false | true | false | a generated, unique key |
2389 | ip_reputation_set_networks | counter | 1.65 | | 3 | int | false | false | false | the reputation counter |
2390 | ip_reputation_sets | pkey | 1.65 | | 0 | pkey | false | true | false | a generated, unique key |
2391 | ip_reputation_sets | accounting | 1.65 | | 1 | accounting | false | false | false | the accounting code of the business |
2392 | ip_reputation_sets | identifier | 1.65 | | 2 | string | false | true | false | a globally unique identifier |
2393 | ip_reputation_sets | allow_subaccount_use | 1.65 | | 3 | boolean | false | false | false | allows subaccounts to use the set |
2394 | ip_reputation_sets | max_hosts | 1.65 | | 4 | int | false | false | false | the maximum number of individual hosts tracked |
2395 | ip_reputation_sets | max_uncertain_reputation | 1.65 | | 5 | short | false | false | false | the maximum reputation from uncertain sources |
2396 | ip_reputation_sets | max_definite_reputation | 1.65 | | 6 | short | false | false | false | the maximum reputation from definite sources |
2397 | ip_reputation_sets | network_prefix | 1.65 | | 7 | short | false | false | false | the network size, for example 24 for a /24 (class C) |
2398 | ip_reputation_sets | max_network_reputation | 1.65 | | 8 | short | false | false | false | the maximum reputation for a network |
2399 | ip_reputation_sets | host_decay_interval | 1.65 | | 9 | int | false | false | false | the number of seconds between each host decay |
2400 | ip_reputation_sets | last_host_decay | 1.65 | | 10 | time | false | false | false | the time the hosts were last decayed |
2401 | ip_reputation_sets | network_decay_interval | 1.65 | | 11 | int | false | false | false | the number of seconds between each network decay |
2402 | ip_reputation_sets | last_network_decay | 1.65 | | 12 | time | false | false | false | the time the networks were last decayed |
811 | master_users | is_router | 1.65 | | 7 | boolean | false | false | false | if they read all router stuff |
2359 | ip_reputation_limiter_limits | pkey | 1.66 | | 0 | pkey | false | true | false | a generated, unique key |
2360 | ip_reputation_limiter_limits | limiter | 1.66 | | 1 | fkey | false | false | false | the identifier of the limiter |
2361 | ip_reputation_limiter_limits | class | 1.66 | | 2 | string | false | false | false | the reputation class |
2362 | ip_reputation_limiter_limits | syn_per_ip_burst | 1.66 | | 3 | short | false | false | false | |
2363 | ip_reputation_limiter_limits | syn_per_ip_rate | 1.66 | | 4 | short | false | false | false | |
2364 | ip_reputation_limiter_limits | syn_per_ip_unit | 1.66 | | 5 | string | false | false | false | |
2365 | ip_reputation_limiter_limits | syn_per_ip_size | 1.66 | | 6 | short | false | false | false | |
2366 | ip_reputation_limiter_limits | syn_burst | 1.66 | | 7 | short | false | false | false | |
2367 | ip_reputation_limiter_limits | syn_rate | 1.66 | | 8 | short | false | false | false | |
2368 | ip_reputation_limiter_limits | syn_unit | 1.66 | | 9 | string | false | false | false | |
2369 | ip_reputation_limiter_limits | packet_per_ip_burst | 1.66 | | 10 | short | false | false | false | |
2370 | ip_reputation_limiter_limits | packet_per_ip_rate | 1.66 | | 11 | short | false | false | false | |
2371 | ip_reputation_limiter_limits | packet_per_ip_unit | 1.66 | | 12 | string | false | false | false | |
2372 | ip_reputation_limiter_limits | packet_per_ip_size | 1.66 | | 13 | short | false | false | false | |
2373 | ip_reputation_limiter_limits | packet_burst | 1.66 | | 14 | short | false | false | false | |
2374 | ip_reputation_limiter_limits | packet_rate | 1.66 | | 15 | short | false | false | false | |
2375 | ip_reputation_limiter_limits | packet_unit | 1.66 | | 16 | string | false | false | false | |
2380 | ip_reputation_limiter_sets | pkey | 1.66 | | 0 | pkey | false | true | false | a generated, unique key |
2381 | ip_reputation_limiter_sets | limiter | 1.66 | | 1 | fkey | false | false | false | the identifier of the limiter |
2382 | ip_reputation_limiter_sets | set | 1.66 | | 2 | fkey | false | false | false | the identifier of the set |
2383 | ip_reputation_limiter_sets | sort_order | 1.66 | | 3 | short | false | false | false | the per-limiter ordering |
2376 | ip_reputation_limiters | pkey | 1.66 | | 0 | pkey | false | true | false | a generated, unique key |
2377 | ip_reputation_limiters | net_device | 1.66 | | 1 | fkey | false | false | false | the identifier of the net_device that is protected |
2378 | ip_reputation_limiters | identifier | 1.66 | | 2 | string | false | false | false | the per-net_device unique identifier |
2379 | ip_reputation_limiters | description | 1.66 | | 3 | string | true | false | false | an optional description of the limiter |
2354 | ip_reputation_set_hosts | set | 1.66 | | 1 | fkey | false | false | false | the IP Reputation Set |
2386 | ip_reputation_set_networks | set | 1.66 | | 1 | fkey | false | false | false | the IP Reputation Set |
2356 | ip_reputation_set_hosts | host | 1.67 | | 2 | ip_address | false | false | false | the per-set unique IPv4 address |
2388 | ip_reputation_set_networks | network | 1.67 | | 2 | ip_address | false | false | false | the per-set unique IPv4 network address, with network bits zero |
2403 | ip_reputation_sets | last_reputation_added | 1.67 | | 13 | time | false | false | false | the time reputation was last added |
1539 | httpd_servers | max_concurrency | 1.68 | | 12 | int | false | false | false | the maximum number of processes/threads for this server instance |
678 | ao_servers | hostname | 1.69 | | 1 | domain_name | false | true | false | the unique hostname of the server |
703 | ao_servers | daemon_connect_address | 1.69 | | 12 | hostname | true | false | false | provides a specific hostname or address to use for connecting to AOServDaemon |
1265 | brands | nameserver1 | 1.69 | | 1 | domain_name | false | false | false | |
1267 | brands | nameserver2 | 1.69 | | 2 | domain_name | false | false | false | |
1269 | brands | nameserver3 | 1.69 | | 3 | domain_name | true | false | false | |
1271 | brands | nameserver4 | 1.69 | | 4 | domain_name | true | false | false | |
1287 | brands | support_toll_free | 1.69 | | 19 | phone | true | false | false | |
1289 | brands | support_day_phone | 1.69 | | 20 | phone | true | false | false | |
1291 | brands | support_emergency_phone1 | 1.69 | | 21 | phone | true | false | false | |
1293 | brands | support_emergency_phone2 | 1.69 | | 22 | phone | true | false | false | |
1295 | brands | support_fax | 1.69 | | 23 | phone | true | false | false | |
31 | business_administrators | password | 1.69 | | 1 | hashed_password | true | false | false | the encrypted password for this admin |
35 | business_administrators | birthday | 1.69 | | 4 | date | true | false | false | the admins birthday |
47 | business_administrators | city | 1.69 | | 15 | string | true | false | false | the city (if different than business) |
49 | business_administrators | state | 1.69 | | 16 | string | true | false | false | the state (if different than business) |
51 | business_administrators | country | 1.69 | | 17 | string | true | false | false | the country (if different than business) |
53 | business_administrators | zip | 1.69 | | 18 | string | true | false | false | the zip code (if different than business) |
106 | business_profiles | city | 1.69 | | 9 | string | false | false | false | the city |
108 | business_profiles | state | 1.69 | | 10 | string | true | false | false | the state or providence |
110 | business_profiles | country | 1.69 | | 11 | string | false | false | false | the two-character country code |
112 | business_profiles | zip | 1.69 | | 12 | string | true | false | false | the zip code |
1011 | country_codes | code | 1.69 | | 0 | string | false | true | true | the two-character code for the country |
1091 | credit_card_transactions | shipping_city | 1.69 | | 17 | string | true | false | false | the shipping city |
1093 | credit_card_transactions | shipping_state | 1.69 | | 18 | string | true | false | false | the shipping state |
1095 | credit_card_transactions | shipping_postal_code | 1.69 | | 19 | string | true | false | false | the shipping postal code |
1097 | credit_card_transactions | shipping_country_code | 1.69 | | 20 | string | true | false | false | the shipping two-digit ISO 3166-1 alpha-2 country code |
1122 | credit_card_transactions | credit_card_city | 1.69 | | 44 | string | false | false | false | the city of the card holder |
1124 | credit_card_transactions | credit_card_state | 1.69 | | 45 | string | true | false | false | the state/province/prefecture of the card holder |
1126 | credit_card_transactions | credit_card_postal_code | 1.69 | | 46 | string | true | false | false | the postal code of the card holder |
1128 | credit_card_transactions | credit_card_country_code | 1.69 | | 47 | string | false | false | false | the two-digit ISO 3166-1 alpha-2 country code of the card holder |
1040 | credit_cards | city | 1.69 | | 18 | string | false | false | false | the card holders city |
1043 | credit_cards | state | 1.69 | | 19 | string | true | false | false | the card holders state |
1046 | credit_cards | postal_code | 1.69 | | 20 | string | true | false | false | the card holders postal code |
1048 | credit_cards | country_code | 1.69 | | 21 | string | false | false | false | the two-character country code |
369 | dns_records | domain | 1.69 | | 2 | string | false | false | false | the first column in the zone files |
392 | dns_tlds | domain | 1.69 | | 0 | domain_name | false | true | true | the domain |
429 | email_domains | domain | 1.69 | | 1 | domain_name | false | false | false | the domain that is hosted in the email |
513 | email_smtp_relays | host | 1.69 | | 3 | hostname | false | false | false | the hostname or IP the rule applies to |
526 | email_smtp_smart_host_domains | domain | 1.69 | | 2 | domain_name | false | false | false | the specific domain that is being configured |
179 | failover_file_replications | connect_address | 1.69 | | 6 | hostname | true | false | false | an address or hostname that overrides regular AOServ connections for failovers |
181 | failover_file_replications | connect_from | 1.69 | | 7 | ip_address | true | false | false | an address that overrides regular AOServ connection source addresses for failovers |
1637 | httpd_site_urls | hostname | 1.69 | | 2 | domain_name | false | false | false | the hostname that this site responds to |
984 | ip_addresses | hostname | 1.69 | | 4 | domain_name | true | false | false | the reverse mapping for the hostname, null only allowed for the "0.0.0.0"" or "::" IP addresses |
728 | linux_accounts | office_location | 1.69 | | 2 | gecos | true | false | false | the location of the user |
730 | linux_accounts | office_phone | 1.69 | | 3 | gecos | true | false | false | the work phone number of the user |
732 | linux_accounts | home_phone | 1.69 | | 4 | gecos | true | false | false | the home phone number of the user |
758 | linux_server_accounts | created | 1.69 | | 11 | time | false | false | false | the time this account was added |
650 | linux_server_groups | created | 1.69 | | 4 | time | false | false | false | the time the group was added |
893 | mysql_server_users | host | 1.69 | | 3 | string | false | false | false | the host this user is allowed to connect from,
if this is not null, all access is restricted to these
hosts, otherwise the entries in mysql_db_users and
mysql_hosts are used. |
1003 | net_tcp_redirects | net_bind | 1.69 | | 0 | fkey | false | true | false | the pkey as found in net_binds |
234 | notice_log | transid | 1.69 | | 6 | fkey | true | false | false | |
1251 | postgres_server_users | postgres_server | 1.69 | | 2 | fkey | false | false | false | the pkey of the PostgreSQL server |
552 | private_ftp_servers | hostname | 1.69 | | 2 | domain_name | false | false | false | the hostname the server reports |
557 | private_ftp_servers | linux_server_account | 1.69 | | 5 | fkey | false | false | false | |
1395 | signup_requests | business_phone | 1.69 | | 6 | phone | false | false | false | the phone number of the business |
1397 | signup_requests | business_fax | 1.69 | | 7 | phone | true | false | false | the fax number of the business |
1401 | signup_requests | business_city | 1.69 | | 10 | string | false | false | false | the city of the business |
1403 | signup_requests | business_state | 1.69 | | 11 | string | true | false | false | the state or providence of the business |
1405 | signup_requests | business_country | 1.69 | | 12 | string | false | false | false | the two-character country code of the business |
1407 | signup_requests | business_zip | 1.69 | | 13 | string | true | false | false | the zip code of the business |
1411 | signup_requests | ba_work_phone | 1.69 | | 16 | string | false | false | false | the administrator's work phone |
1413 | signup_requests | ba_cell_phone | 1.69 | | 17 | string | true | false | false | the administrator's cell phone |
1415 | signup_requests | ba_home_phone | 1.69 | | 18 | string | true | false | false | the administrator's home phone |
1417 | signup_requests | ba_fax | 1.69 | | 19 | string | true | false | false | the administrator's fax number |
1422 | signup_requests | ba_city | 1.69 | | 23 | string | true | false | false | the city of the administrator |
1424 | signup_requests | ba_state | 1.69 | | 24 | string | true | false | false | the state or providence of the administrator |
1426 | signup_requests | ba_country | 1.69 | | 25 | string | true | false | false | the two-character country code of the administrator |
1428 | signup_requests | ba_zip | 1.69 | | 26 | string | true | false | false | the zip code of the administrator |
1446 | ticket_actions | old_accounting | 1.69 | | 5 | accounting | true | false | false | |
1448 | ticket_actions | new_accounting | 1.69 | | 6 | accounting | true | false | false | |
1502 | tickets | status_timeout | 1.69 | | 16 | time | true | false | false | |
1506 | tickets | internal_notes | 1.69 | | 19 | string | false | false | false | |
296 | transactions | transid | 1.69 | | 1 | pkey | false | true | false | the unique identifier for this transaction |
700 | ao_servers | jilter_bind | 1.7 | | 10 | fkey | true | false | false | the bind that sendmail uses to connect to jilter |
1791 | distro_report_types | name | 1.70 | | 0 | string | false | true | false | the unique name of the type |
1792 | distro_report_types | display | 1.70 | | 1 | string | false | false | false | a display value of the type of report |
951 | net_devices | monitoring_enabled | 1.70 | | 14 | boolean | false | false | false | indicates that this device should be monitored |
372 | dns_records | priority | 1.72 | | 4 | int | true | false | false | the priority for the entry |
373 | dns_records | weight | 1.72 | | 5 | int | true | false | false | the relative weight for records with the same priority |
374 | dns_records | port | 1.72 | | 6 | int | true | false | false | the TCP or UDP port on which the service is to be found |
385 | dns_types | has_priority | 1.72 | | 2 | boolean | false | false | true | flags which types have a priority |
386 | dns_types | has_weight | 1.72 | | 3 | boolean | false | false | true | flags which types have a weight |
387 | dns_types | has_port | 1.72 | | 4 | boolean | false | false | true | flags which types have a port |
604 | virtual_disks | verify_day_of_week | 1.72 | | 8 | int | false | false | false | the day of the week verification will begin |
605 | virtual_disks | verify_hour_of_day | 1.72 | | 9 | int | false | false | false | the hour of day verification will begin |
812 | master_users | is_cluster_admin | 1.73 | | 8 | boolean | false | false | false | if they can control cluster resources |
207 | failover_mysql_replications | max_alert_level | 1.74 | | 8 | string | false | false | false | the maximum alert level for all monitoring of this slave |
822 | mysql_databases | max_check_table_alert_level | 1.74 | | 4 | string | false | false | false | the maximum alert level created for the check table monitoring of this database |
1622 | httpd_sites | php_version | 1.78 | | 11 | fkey | true | false | false | the active version of PHP, if any |
363 | technology_versions | disable_time | 1.78 | | 6 | time | true | false | true | the time this version is no longer supported |
364 | technology_versions | disable_reason | 1.78 | | 7 | string | true | false | true | the reason this version is no longer supported |
701 | ao_servers | restrict_outbound_email | 1.8 | | 11 | boolean | false | false | false | controls if outbound email may only come from address hosted on this machine |
1784 | distro_files | file_sha256_0 | 1.80 | | 9 | long | true | false | false | the first 64 bits of SHA-256 hash if is a regular file |
1785 | distro_files | file_sha256_1 | 1.80 | | 10 | long | true | false | false | the second 64 bits of SHA-256 hash if is a regular file |
1786 | distro_files | file_sha256_2 | 1.80 | | 11 | long | true | false | false | the third 64 bits of SHA-256 hash if is a regular file |
1787 | distro_files | file_sha256_3 | 1.80 | | 12 | long | true | false | false | the fourth 64 bits of SHA-256 hash if is a regular file |
1623 | httpd_sites | enable_cgi | 1.80 | | 12 | boolean | false | false | false | CGI is enabled on this website |
636 | ao_server_daemon_hosts | host | 1.80.0 | | 2 | hostname | false | false | false | the hostname or IP address that is allowed to connect |
1779 | distro_files | linux_group | 1.80.0 | | 7 | group_id | false | false | false | the group of the file |
397 | dns_zones | package | 1.80.0 | | 2 | accounting | false | false | false | the package that owns the zones |
432 | email_domains | package | 1.80.0 | | 3 | accounting | false | false | false | the owner of the domain |
478 | email_pipes | command | 1.80.0 | | 2 | string | false | false | false | the complete command string to the email handling program |
480 | email_pipes | package | 1.80.0 | | 3 | accounting | false | false | false | the package that this program runs for |
510 | email_smtp_relays | package | 1.80.0 | | 1 | accounting | false | false | false | the package that owns this entry |
187 | failover_file_replications | quota_gid | 1.80.0 | | 9 | linux_id | true | false | false | the gid used on the backup_partition for quota reports, required if backup_partitions quotas are enabled, not allowed otherwise |
1604 | httpd_sites | package | 1.80.0 | | 4 | accounting | false | false | false | the package that the site is part of |
1608 | httpd_sites | linux_group | 1.80.0 | | 6 | group_id | false | false | false | the primary group that can edit the site content |
2479 | httpd_tomcat_contexts | doc_base | 1.80.0 | | 5 | path | false | false | false | the docBase attribute |
638 | linux_groups | name | 1.80.0 | | 0 | group_id | false | true | false | the name of the group |
640 | linux_groups | package | 1.80.0 | | 1 | accounting | false | false | false | the package of the group |
743 | linux_server_accounts | uid | 1.80.0 | | 3 | linux_id | false | false | false | the uid of the user on the machine |
644 | linux_server_groups | name | 1.80.0 | | 1 | group_id | false | false | false | the group name |
648 | linux_server_groups | gid | 1.80.0 | | 3 | linux_id | false | false | false | the gid on that machine |
798 | master_hosts | host | 1.80.0 | | 2 | hostname | false | false | false | the hostname or IP address they are allowed to connect from |
214 | monthly_charges | package | 1.80.0 | | 2 | accounting | false | false | false | the package that this is charged for |
815 | mysql_databases | name | 1.80.0 | | 1 | mysql_database_name | false | false | false | the name of the database |
819 | mysql_databases | package | 1.80.0 | | 3 | accounting | false | false | false | the package that this database is part of |
889 | mysql_server_users | username | 1.80.0 | | 1 | mysql_username | false | false | false | the username |
849 | mysql_servers | name | 1.80.0 | | 1 | mysql_server_name | false | false | false | the name of the server |
857 | mysql_users | username | 1.80.0 | | 0 | mysql_username | false | true | false | the username of the MySQL user |
913 | net_binds | package | 1.80.0 | | 1 | accounting | false | false | false | the package that owns the opened port |
920 | net_binds | port | 1.80.0 | | 4 | net_port | false | false | false | the port that is bound |
945 | net_devices | mac_address | 1.80.0 | | 8 | mac_address | true | true | false | the MAC address to be used on the device |
1009 | net_tcp_redirects | destination_port | 1.80.0 | | 4 | net_port | false | false | false | the remote port to connect to |
266 | packages | name | 1.80.0 | | 1 | accounting | false | true | false | the unique name of this package entry |
1216 | postgres_databases | name | 1.80.0 | | 1 | postgres_database_name | false | false | false | the name of the database |
1249 | postgres_server_users | username | 1.80.0 | | 1 | postgres_username | false | false | false | the username as found in postgres_users |
1231 | postgres_servers | name | 1.80.0 | | 1 | postgres_server_name | false | false | false | the name of the database |
1241 | postgres_users | username | 1.80.0 | | 0 | postgres_username | false | true | false | the username of the user |
903 | protocols | port | 1.80.0 | | 1 | net_port | false | false | true | the default port of the protocol |
1456 | ticket_actions | old_assigned_to | 1.80.0 | | 13 | username | true | false | false | |
1458 | ticket_actions | new_assigned_to | 1.80.0 | | 14 | username | true | false | false | |
123 | usernames | package | 1.80.0 | | 1 | accounting | false | false | false | the package name that this user is part of |
2523 | httpd_shared_tomcats | max_post_size | 1.80.1 | | 12 | int | true | false | false | the maxPostSize setting for this Tomcat |
2524 | httpd_shared_tomcats | unpack_wars | 1.80.1 | | 13 | boolean | false | false | false | the unpackWARs setting for this Tomcat |
2525 | httpd_shared_tomcats | auto_deploy | 1.80.1 | | 14 | boolean | false | false | false | the autoDeploy setting for this Tomcat |
1624 | httpd_sites | enable_ssi | 1.80.1 | | 13 | boolean | false | false | false | Server-side includes are enabled on this website |
1625 | httpd_sites | enable_htaccess | 1.80.1 | | 14 | boolean | false | false | false | .htaccess files are enabled on this website |
1626 | httpd_sites | enable_indexes | 1.80.1 | | 15 | boolean | false | false | false | Directory indexes are enabled on this website |
1627 | httpd_sites | enable_follow_symlinks | 1.80.1 | | 16 | boolean | false | false | false | Symbolic link following is enabled on this website (required for mod_rewrite) |
1628 | httpd_sites | enable_anonymous_ftp | 1.80.1 | | 17 | boolean | false | false | false | Enables the anonymous FTP area for this site. |
2498 | httpd_tomcat_std_sites | max_post_size | 1.80.1 | | 4 | int | true | false | false | the maxPostSize setting for this Tomcat |
2499 | httpd_tomcat_std_sites | unpack_wars | 1.80.1 | | 5 | boolean | false | false | false | the unpackWARs setting for this Tomcat |
2500 | httpd_tomcat_std_sites | auto_deploy | 1.80.1 | | 6 | boolean | false | false | false | the autoDeploy setting for this Tomcat |
726 | linux_accounts | name | 1.80.1 | | 1 | gecos | true | false | false | the full name of the user |
765 | linux_server_accounts | sudo | 1.80.1 | | 18 | string | true | false | false | the sudo setting or null when sudo not allowed |
952 | firewalld_zones | pkey | 1.81.0 | | 0 | pkey | false | true | false | a generated unique primary key |
953 | firewalld_zones | server | 1.81.0 | | 1 | fkey | false | false | false | the pkey of the server |
954 | firewalld_zones | name | 1.81.0 | | 2 | firewalld_zone_name | false | false | false | the name of the Firewalld zone |
955 | firewalld_zones | short | 1.81.0 | | 3 | string | true | false | false | the optional short name |
956 | firewalld_zones | description | 1.81.0 | | 4 | string | true | false | false | the optional description |
907 | net_bind_firewalld_zones | pkey | 1.81.0 | | 0 | pkey | false | true | false | a generated pkey |
908 | net_bind_firewalld_zones | net_bind | 1.81.0 | | 1 | fkey | false | false | false | the pkey of the port that is associated with the zone |
909 | net_bind_firewalld_zones | firewalld_zone | 1.81.0 | | 2 | fkey | false | false | false | the pkey of the zone this port is associated with |
411 | cyrus_imapd_binds | net_bind | 1.81.10 | | 0 | fkey | false | true | false | the IP address, port, and protocol details |
412 | cyrus_imapd_binds | cyrus_imapd_server | 1.81.10 | | 1 | fkey | false | false | false | the server that is listening on the address |
413 | cyrus_imapd_binds | servername | 1.81.10 | | 2 | domain_name | true | false | false | the servername for this bind |
414 | cyrus_imapd_binds | certificate | 1.81.10 | | 3 | fkey | true | false | false | the certificate used by this bind |
415 | cyrus_imapd_binds | allow_plaintext_auth | 1.81.10 | | 4 | boolean | true | false | false | allows plaintext authentication (PLAIN/LOGIN) on non-TLS links |
416 | cyrus_imapd_servers | ao_server | 1.81.10 | | 0 | fkey | false | true | false | the pkey of the server that runs this Cyrus IMAPD instance |
417 | cyrus_imapd_servers | sieve_net_bind | 1.81.10 | | 1 | fkey | true | true | false | the port the server binds to for sieve, if enabled |
418 | cyrus_imapd_servers | servername | 1.81.10 | | 2 | domain_name | true | false | false | the servername for this server |
419 | cyrus_imapd_servers | certificate | 1.81.10 | | 3 | fkey | false | false | false | the certificate used for this server |
420 | cyrus_imapd_servers | allow_plaintext_auth | 1.81.10 | | 4 | boolean | false | false | false | allows plaintext authentication (PLAIN/LOGIN) on non-TLS links |
421 | cyrus_imapd_servers | delete_duration | 1.81.10 | | 5 | float | true | false | false | the duration after which delayed delete folders are removed |
422 | cyrus_imapd_servers | delete_duration_unit | 1.81.10 | | 6 | string | true | false | false | the time unit for delete_duration, one of "d", "h", "m", "s" |
423 | cyrus_imapd_servers | expire_duration | 1.81.10 | | 7 | float | false | false | false | prune the duplicate database of entries older than expire-duration |
424 | cyrus_imapd_servers | expire_duration_unit | 1.81.10 | | 8 | string | true | false | false | the time unit for expire_duration, one of "d", "h", "m", "s" |
425 | cyrus_imapd_servers | expunge_duration | 1.81.10 | | 9 | float | true | false | false | the duration after which delayed expunge messages are removed |
426 | cyrus_imapd_servers | expunge_duration_unit | 1.81.10 | | 10 | string | true | false | false | the time unit for expunge_duration, one of "d", "h", "m", "s" |
1573 | httpd_servers | mod_wsgi | 1.81.10 | | 46 | boolean | true | false | false | manually enables or disables the mod_wsgi Apache module for this server instance |
1645 | httpd_site_binds | certificate | 1.81.10 | | 6 | fkey | true | false | false | the certificate used by this bind |
1653 | httpd_site_binds | include_site_config | 1.81.10 | | 11 | string | true | false | false | controls whether this bind includes the per-site configuration file |
482 | sendmail_binds | net_bind | 1.81.10 | | 0 | fkey | false | true | false | the IP address, port, and protocol details |
483 | sendmail_binds | sendmail_server | 1.81.10 | | 1 | fkey | false | false | false | the server that is listening on the address |
484 | sendmail_binds | servername | 1.81.10 | | 2 | string | true | false | false | the Name for DaemonPortOptions for this bind |
487 | sendmail_servers | ao_server | 1.81.10 | | 1 | fkey | false | false | false | the pkey of the server that runs this sendmail instance |
488 | sendmail_servers | name | 1.81.10 | | 2 | string | true | false | false | the name of the instance on the server, null for the default instance |
489 | sendmail_servers | package | 1.81.10 | | 3 | fkey | false | false | false | the package that owns the SSL certificate |
490 | sendmail_servers | hostname | 1.81.10 | | 4 | domain_name | true | false | false | the fully qualified hostname for Dw, Dm, and Dj |
491 | sendmail_servers | server_certificate | 1.81.10 | | 5 | fkey | false | false | false | the certificate used for this server |
492 | sendmail_servers | client_certificate | 1.81.10 | | 6 | fkey | false | false | false | the certificate used for this client |
493 | sendmail_servers | allow_plaintext_auth | 1.81.10 | | 7 | boolean | false | false | false | allows plaintext authentication (PLAIN/LOGIN) on non-TLS links |
494 | sendmail_servers | max_queue_children | 1.81.10 | | 8 | int | true | false | false | the value for confMAX_QUEUE_CHILDREN |
495 | sendmail_servers | nice_queue_run | 1.81.10 | | 9 | int | true | false | false | the value for confNICE_QUEUE_RUN |
496 | sendmail_servers | delay_la | 1.81.10 | | 10 | int | true | false | false | the value for confDELAY_LA |
497 | sendmail_servers | queue_la | 1.81.10 | | 11 | int | true | false | false | the value for confQUEUE_LA |
498 | sendmail_servers | refuse_la | 1.81.10 | | 12 | int | true | false | false | the value for confREFUSE_LA |
499 | sendmail_servers | max_daemon_children | 1.81.10 | | 13 | int | true | false | false | the value for confMAX_DAEMON_CHILDREN |
500 | sendmail_servers | bad_rcpt_throttle | 1.81.10 | | 14 | int | true | false | false | the value for confBAD_RCPT_THROTTLE |
501 | sendmail_servers | connection_rate_throttle | 1.81.10 | | 15 | int | true | false | false | the value for confCONNECTION_RATE_THROTTLE |
502 | sendmail_servers | max_message_size | 1.81.10 | | 16 | int | true | false | false | the value for confMAX_MESSAGE_SIZE |
503 | sendmail_servers | min_free_blocks | 1.81.10 | | 17 | int | true | false | false | the value for confMIN_FREE_BLOCKS |
1187 | ssl_certificate_names | pkey | 1.81.10 | | 0 | pkey | false | true | false | a generated primary key |
1188 | ssl_certificate_names | ssl_certificate | 1.81.10 | | 1 | fkey | false | false | false | the pkey of the SSL certificate this name is on |
1189 | ssl_certificate_names | is_common_name | 1.81.10 | | 2 | boolean | false | false | false | indicates this is the Common Name (CN) or a Subject Alt Name |
1190 | ssl_certificate_names | is_wildcard | 1.81.10 | | 3 | boolean | false | false | false | is a *.(domain) wildcard certificate |
1191 | ssl_certificate_names | domain | 1.81.10 | | 4 | domain_name | false | false | false | the domain name |
1197 | ssl_certificates | pkey | 1.81.10 | | 0 | pkey | false | true | false | a generated primary key |
1198 | ssl_certificates | ao_server | 1.81.10 | | 1 | fkey | false | false | false | the pkey of the server the SSL certificate is on |
1199 | ssl_certificates | package | 1.81.10 | | 2 | fkey | false | false | false | the package that owns the SSL certificate |
1200 | ssl_certificates | key_file | 1.81.10 | | 3 | path | false | false | false | the file holding the private key |
1201 | ssl_certificates | csr_file | 1.81.10 | | 4 | path | true | false | false | the file holding the CSR |
1202 | ssl_certificates | cert_file | 1.81.10 | | 5 | path | false | false | false | the file holding the public key |
1203 | ssl_certificates | chain_file | 1.81.10 | | 6 | path | true | false | false | the file holding the CA chain |
1204 | ssl_certificates | certbot_name | 1.81.10 | | 7 | string | true | false | false | the name of the certbot-managed Let's Encrypt certificate |
1540 | httpd_servers | monitoring_concurrency_low | 1.81.11 | | 13 | int | true | false | false | the concurrency that will trigger a low-level alert |
1541 | httpd_servers | monitoring_concurrency_medium | 1.81.11 | | 14 | int | true | false | false | the concurrency that will trigger a medium-level alert |
1542 | httpd_servers | monitoring_concurrency_high | 1.81.11 | | 15 | int | true | false | false | the concurrency that will trigger a high-level alert |
1543 | httpd_servers | monitoring_concurrency_critical | 1.81.11 | | 16 | int | true | false | false | the concurrency that will trigger a critical-level alert |
1582 | httpd_site_authenticated_locations | handler | 1.81.13 | | 8 | string | true | false | false | the optional handler for this location |
1642 | httpd_site_binds | name | 1.81.14 | | 3 | string | true | false | false | the name of the bind, null for the default bind |
1510 | httpd_site_bind_headers | pkey | 1.81.15 | | 0 | pkey | false | true | false | a generated primary key |
1511 | httpd_site_bind_headers | httpd_site_bind | 1.81.15 | | 1 | fkey | false | false | false | the site bind that is being referenced |
1512 | httpd_site_bind_headers | sort_order | 1.81.15 | | 2 | short | false | false | false | the per-bind unique sort ordering |
1513 | httpd_site_bind_headers | type | 1.81.15 | | 3 | string | false | false | false | the type of header, either "Header" or "RequestHeader" |
1514 | httpd_site_bind_headers | always | 1.81.15 | | 4 | boolean | false | false | false | the condition is either "onsuccess" (default, can be omitted) or "always" |
1515 | httpd_site_bind_headers | action | 1.81.15 | | 5 | string | false | false | false | the action to be performed |
1516 | httpd_site_bind_headers | header | 1.81.15 | | 6 | string | false | false | false | the header name, without any final colon |
1517 | httpd_site_bind_headers | value | 1.81.15 | | 7 | string | true | false | false | the header value, not used for all actions |
1518 | httpd_site_bind_headers | replacement | 1.81.15 | | 8 | string | true | false | false | the replacement value, only used for "edit" and "edit*" |
1519 | httpd_site_bind_headers | when | 1.81.15 | | 9 | string | true | false | false | optional control over when is this header directive is applied |
1520 | httpd_site_bind_headers | comment | 1.81.15 | | 10 | string | true | false | false | an optional comment describing the redirect |
1192 | ssl_certificate_other_uses | pkey | 1.81.16 | | 0 | pkey | false | true | false | a generated primary key |
1193 | ssl_certificate_other_uses | ssl_certificate | 1.81.16 | | 1 | fkey | false | false | false | the pkey of the SSL certificate this name is on |
1194 | ssl_certificate_other_uses | sort_order | 1.81.16 | | 2 | short | false | false | false | the per-certificate unique sort ordering |
1195 | ssl_certificate_other_uses | count | 1.81.16 | | 3 | int | false | false | false | the number of times this other resource uses the certificate |
1196 | ssl_certificate_other_uses | display | 1.81.16 | | 4 | string | false | false | false | a short display value, which will often follow the count when displayed |
690 | ao_servers | daemonDeviceId | 1.81.18 | | 7 | string | false | false | false | the device name the master connects to |
710 | ao_servers | uidMin | 1.81.18 | | 18 | linux_id | false | false | false | the min value for automatic uid selection in useradd |
712 | ao_servers | gidMin | 1.81.18 | | 19 | linux_id | false | false | false | the min value for automatic gid selection in groupadd |
713 | ao_servers | uidMax | 1.81.18 | | 20 | linux_id | false | false | false | the max value for automatic uid selection in useradd |
714 | ao_servers | gidMax | 1.81.18 | | 21 | linux_id | false | false | false | the max value for automatic gid selection in groupadd |
715 | ao_servers | lastUid | 1.81.18 | | 22 | linux_id | true | false | false | the last value for automatic uid selection in useradd, if any |
716 | ao_servers | lastGid | 1.81.18 | | 23 | linux_id | true | false | false | the last value for automatic gid selection in groupadd, if any |
1320 | aoserv_protocols | lastUsed | 1.81.18 | | 3 | date | true | false | true | the date this protocol was last used |
128 | aosh_commands | sinceVersion | 1.81.18 | | 1 | string | false | false | true | the first aoserv_protocol version having this command |
129 | aosh_commands | lastVersion | 1.81.18 | | 2 | string | true | false | true | the last aoserv_protocol version having this command |
131 | aosh_commands | table | 1.81.18 | | 3 | string | true | false | true | the name of the table the column is in, is a global command if the column is null |
133 | aosh_commands | description | 1.81.18 | | 4 | string | false | false | true | a short description of the command |
66 | bank_accounts | depositDelay | 1.81.18 | | 3 | int | false | false | false | the number of business days it takes for a deposit to be sent to the bank account |
68 | bank_accounts | withdrawalDelay | 1.81.18 | | 4 | int | false | false | false | the number of business days it takes for a withdrawal to be taken from the bank account |
89 | bank_transaction_types | name | 1.81.18 | | 0 | string | false | true | false | the name of the type |
93 | bank_transaction_types | isNegative | 1.81.18 | | 3 | boolean | false | false | false | if true the amount must be negative |
71 | bank_transactions | id | 1.81.18 | | 0 | pkey | false | true | false | a unique identifier for the transaction |
76 | bank_transactions | account | 1.81.18 | | 2 | string | false | false | false | the account the transaction is for |
82 | bank_transactions | expenseCategory | 1.81.18 | | 6 | string | true | false | false | the category in which this expense belongs |
85 | bank_transactions | checkNo | 1.81.18 | | 8 | string | true | false | false | the check number (if available) |
380 | dns_records | dhcpAddress | 1.81.18 | | 10 | fkey | true | false | false | the id of the IP address whos changes are followed |
95 | expense_categories | name | 1.81.18 | | 0 | string | false | true | false | a simple code used as primary key |
1598 | httpd_sites | id | 1.81.18 | | 0 | pkey | false | true | false | a generated primary key |
1601 | httpd_sites | name | 1.81.18 | | 2 | string | false | false | false | the name of the site, as used in the /var/www directory. |
2539 | httpd_workers | bind | 1.81.18 | | 0 | fkey | false | true | false | the network binding reservation and details |
2541 | httpd_workers | name | 1.81.18 | | 1 | string | false | false | false | the jk_code for the worker |
2544 | httpd_workers | tomcatSite | 1.81.18 | | 2 | fkey | true | false | false | the site that provides this worker (Tomcat 3 only) |
976 | ip_addresses | id | 1.81.18 | | 0 | pkey | false | true | false | a generated, unique key |
978 | ip_addresses | inetAddress | 1.81.18 | | 1 | ip_address | false | false | false | the IP address |
980 | ip_addresses | device | 1.81.18 | | 2 | fkey | true | false | false | the network_device that this IP address is routed through. May only be null for 0.0.0.0 |
982 | ip_addresses | isAlias | 1.81.18 | | 3 | boolean | false | false | false | indicates that the IP address is using IP aliasing on the network device |
987 | ip_addresses | package | 1.81.18 | | 5 | fkey | false | false | false | the package that the IP address is part of |
991 | ip_addresses | isAvailable | 1.81.18 | | 7 | boolean | false | false | false | a flag if the IP address is available |
993 | ip_addresses | isOverflow | 1.81.18 | | 8 | boolean | false | false | false | indicates that the IP address is shared by different accounts |
995 | ip_addresses | isDhcp | 1.81.18 | | 9 | boolean | false | false | false | the IP address is obtained via DHCP |
998 | ip_addresses | externalInetAddress | 1.81.18 | | 10 | ip_address | true | false | false | the external IP address, if different than ip_address |
2336 | IpAddressMonitoring | id | 1.81.18 | | 0 | fkey | false | true | false | id of ip_addresses |
2337 | IpAddressMonitoring | enabled | 1.81.18 | | 1 | boolean | false | false | false | indicates that this IP address should be monitored |
2338 | IpAddressMonitoring | pingMonitorEnabled | 1.81.18 | | 2 | boolean | false | false | false | if ping (ICMP ECHO) is available for monitoring, defaults to true |
2339 | IpAddressMonitoring | checkBlacklistsOverSmtp | 1.81.18 | | 3 | boolean | false | false | false | allows determining some types of blacklists over SMTP protocol |
2340 | IpAddressMonitoring | verifyDnsPtr | 1.81.18 | | 4 | boolean | false | false | false | enables monitoring of reverse DNS |
2341 | IpAddressMonitoring | verifyDnsA | 1.81.18 | | 5 | boolean | false | false | false | enables monitoring of forward DNS |
654 | linux_group_accounts | id | 1.81.18 | | 0 | pkey | false | true | false | a generated unique number |
657 | linux_group_accounts | group | 1.81.18 | | 1 | group_id | false | false | false | the linux group name |
662 | linux_group_accounts | isPrimary | 1.81.18 | | 3 | boolean | false | false | false | flag showing that this group is the user's primary group |
664 | linux_group_accounts | operatingSystemVersion | 1.81.18 | | 4 | fkey | true | false | false | the version of operating system where this group and user are associated, or null for all operating system versions |
847 | mysql_servers | bind | 1.81.18 | | 0 | fkey | false | true | false | the port the server binds to |
911 | net_binds | id | 1.81.18 | | 0 | pkey | false | true | false | a generated pkey |
917 | net_binds | ipAddress | 1.81.18 | | 3 | fkey | false | false | false | the id of the IP address that is bound to |
936 | net_devices | deviceId | 1.81.18 | | 2 | string | false | false | false | the name of the device |
1229 | postgres_servers | bind | 1.81.18 | | 0 | fkey | false | true | false | the port the server binds to |
1322 | schema_columns | id | 1.81.18 | | 0 | pkey | false | true | true | a generated unique pkey |
1324 | schema_columns | table | 1.81.18 | | 1 | string | false | false | true | the name of the table the column is in |
1326 | schema_columns | name | 1.81.18 | | 2 | string | false | false | true | the name of the column |
1327 | schema_columns | sinceVersion | 1.81.18 | | 3 | string | false | false | true | the first aoserv_protocol version this column was in |
1328 | schema_columns | lastVersion | 1.81.18 | | 4 | string | true | false | true | the last version containing this field |
1330 | schema_columns | index | 1.81.18 | | 5 | short | false | false | true | the index of the column |
1333 | schema_columns | isNullable | 1.81.18 | | 7 | boolean | false | false | true | if the value may be null |
1335 | schema_columns | isUnique | 1.81.18 | | 8 | boolean | false | false | true | if true, the value is unique across rows |
1337 | schema_columns | isPublic | 1.81.18 | | 9 | boolean | false | false | true | if the value is publicly accessible |
1342 | schema_foreign_keys | id | 1.81.18 | | 0 | pkey | false | true | true | a generated unique pkey |
1344 | schema_foreign_keys | column | 1.81.18 | | 1 | fkey | false | false | true | the column that references another column |
1346 | schema_foreign_keys | foreignColumn | 1.81.18 | | 2 | fkey | false | false | true | the referenced column |
1350 | schema_foreign_keys | sinceVersion | 1.81.18 | | 3 | string | false | false | true | the first aoserv_protocol version to have this reference |
1352 | schema_foreign_keys | lastVersion | 1.81.18 | | 4 | string | true | false | true | the last aoserv_protocol version to have this references, or null if not yet removed |
1353 | schema_tables | id | 1.81.18 | | 0 | pkey | false | true | true | a unique ID for the table |
1356 | schema_tables | sinceVersion | 1.81.18 | | 2 | string | false | false | true | the first aoserv_protocol version to have this table |
1357 | schema_tables | lastVersion | 1.81.18 | | 3 | string | true | false | true | the last aoserv_protocol version to have this table or null if still used |
1360 | schema_tables | isPublic | 1.81.18 | | 5 | boolean | false | false | true | if the data contained in the table is accessible to everybody |
1366 | schema_types | id | 1.81.18 | | 0 | pkey | false | true | true | the unique number |
1368 | schema_types | name | 1.81.18 | | 1 | string | false | true | true | the unique name |
1371 | schema_types | sinceVersion | 1.81.18 | | 2 | string | false | false | true | the first aoserv_protocol version this type was in |
1373 | schema_types | lastVersion | 1.81.18 | | 3 | string | true | false | true | the last version containing this type |
486 | sendmail_servers | id | 1.81.18 | | 0 | pkey | false | true | false | a generated unique number |
505 | sendmail_servers | clientAddrInet | 1.81.18 | | 18 | fkey | true | false | false | the Addr for ClientPortOptions with Family=inet |
507 | sendmail_servers | clientAddrInet6 | 1.81.18 | | 19 | fkey | true | false | false | the Addr for ClientPortOptions with Family=inet6 |
326 | WhoisHistory | id | 1.81.19 | | 0 | pkey | false | true | false | a unique, generated identifier |
327 | WhoisHistory | registrableDomain | 1.81.19 | | 1 | domain_name | false | false | false | the registrable domain that was queried |
328 | WhoisHistory | time | 1.81.19 | | 2 | time | false | false | false | the time the whois query was performed |
329 | WhoisHistory | exitStatus | 1.81.19 | | 3 | int | true | false | false | the exit status from the whois lookup, null on exception |
330 | WhoisHistory | output | 1.81.19 | | 4 | string | false | false | false | the output from the whois lookup |
331 | WhoisHistory | error | 1.81.19 | | 5 | string | false | false | false | the error from the whois lookup |
318 | WhoisHistoryAccount | id | 1.81.19 | | 0 | pkey | false | true | false | a unique, generated identifier |
319 | WhoisHistoryAccount | whoisHistory | 1.81.19 | | 1 | fkey | false | false | false | the id of the WhoisHistory |
320 | WhoisHistoryAccount | account | 1.81.19 | | 2 | accounting | false | false | false | the id of the Account |
117 | business_profiles | billingEmailFormat | 1.81.20 | | 17 | string | false | false | false | the format for billing notification emails |
120 | business_profiles | technicalEmailFormat | 1.81.20 | | 20 | string | false | false | false | the format for technical notification emails |
1590 | RewriteRule | id | 1.81.21 | | 0 | pkey | false | true | false | a generated primary key |
1591 | RewriteRule | virtualHost | 1.81.21 | | 1 | fkey | false | false | false | the VirtualHost this rule is applied to |
1592 | RewriteRule | sortOrder | 1.81.21 | | 2 | short | false | false | false | the per-VirtualHost unique sort ordering |
1593 | RewriteRule | pattern | 1.81.21 | | 3 | string | false | false | false | the per-VirtualHost pattern matched |
1594 | RewriteRule | substitution | 1.81.21 | | 4 | string | false | false | false | the rewrite substitution |
1595 | RewriteRule | flags | 1.81.21 | | 5 | string | true | false | false | the optional flags for the rule |
1596 | RewriteRule | comment | 1.81.21 | | 6 | string | true | false | false | an optional comment describing the rule |
1777 | distro_files | linux_account | 1.81.22 | | 6 | linux_username | false | false | false | the owner of the file |
546 | ftp_guest_users | username | 1.81.22 | | 0 | linux_username | false | true | false | the username that is a guest user |
1606 | httpd_sites | linux_account | 1.81.22 | | 5 | linux_username | false | false | false | the user the site "runs as" |
723 | linux_accounts | username | 1.81.22 | | 0 | linux_username | false | true | false | the unique username |
660 | linux_group_accounts | user | 1.81.22 | | 2 | linux_username | false | false | false | the linux account that is an alternate member |
739 | linux_server_accounts | username | 1.81.22 | | 1 | linux_username | false | false | false | the name of the user |
2488 | httpd_tomcat_contexts | server_xml_configured | 1.81.3 | | 14 | boolean | false | false | false | flag setting if the context is written into conf/server.xml |
717 | ao_servers | sftp_umask | 1.81.5 | | 24 | octal_long | true | false | false | the optional umask for the sftp-server |
1629 | httpd_sites | block_trace_track | 1.81.6 | | 18 | boolean | false | false | false | Enables the blocking of TRACE and TRACK HTTP methods on this site. |
1630 | httpd_sites | block_scm | 1.81.6 | | 19 | boolean | false | false | false | Enables the blocking of URL patterns associated with source control management systems. |
1631 | httpd_sites | block_core_dumps | 1.81.6 | | 20 | boolean | false | false | false | Enables the blocking of core dumps. |
1632 | httpd_sites | block_editor_backups | 1.81.6 | | 21 | boolean | false | false | false | Enables the blocking filename patterns associated with editor automatic backups. |
2489 | httpd_tomcat_site_jk_mounts | pkey | 1.81.6 | | 0 | pkey | false | true | false | a generated primary key |
2490 | httpd_tomcat_site_jk_mounts | httpd_tomcat_site | 1.81.6 | | 1 | fkey | false | false | false | the Tomcat site that is being mounted |
2491 | httpd_tomcat_site_jk_mounts | path | 1.81.6 | | 2 | string | false | false | false | the per-site unique pattern matched |
2492 | httpd_tomcat_site_jk_mounts | mount | 1.81.6 | | 3 | boolean | false | false | false | true for JkMount, false for JkUnMount |
2533 | httpd_tomcat_sites | block_webinf | 1.81.6 | | 2 | boolean | false | false | false | Blocks access to /META-INF and /WEB-INF at the Apache level. |
1544 | httpd_servers | mod_access_compat | 1.81.7 | | 17 | boolean | true | false | false | manually enables or disables the mod_access_compat Apache module for this server instance |
1545 | httpd_servers | mod_actions | 1.81.7 | | 18 | boolean | true | false | false | manually enables or disables the mod_actions Apache module for this server instance |
1546 | httpd_servers | mod_alias | 1.81.7 | | 19 | boolean | true | false | false | manually enables or disables the mod_alias Apache module for this server instance |
1547 | httpd_servers | mod_auth_basic | 1.81.7 | | 20 | boolean | true | false | false | manually enables or disables the mod_auth_basic Apache module for this server instance |
1548 | httpd_servers | mod_authn_core | 1.81.7 | | 21 | boolean | true | false | false | manually enables or disables the mod_authn_core Apache module for this server instance |
1549 | httpd_servers | mod_authn_file | 1.81.7 | | 22 | boolean | true | false | false | manually enables or disables the mod_authn_file Apache module for this server instance |
1550 | httpd_servers | mod_authz_core | 1.81.7 | | 23 | boolean | true | false | false | manually enables or disables the mod_authz_core Apache module for this server instance |
1551 | httpd_servers | mod_authz_groupfile | 1.81.7 | | 24 | boolean | true | false | false | manually enables or disables the mod_authz_groupfile Apache module for this server instance |
1552 | httpd_servers | mod_authz_host | 1.81.7 | | 25 | boolean | true | false | false | manually enables or disables the mod_authz_host Apache module for this server instance |
1553 | httpd_servers | mod_authz_user | 1.81.7 | | 26 | boolean | true | false | false | manually enables or disables the mod_authz_user Apache module for this server instance |
1554 | httpd_servers | mod_autoindex | 1.81.7 | | 27 | boolean | true | false | false | manually enables or disables the mod_autoindex Apache module for this server instance |
1555 | httpd_servers | mod_deflate | 1.81.7 | | 28 | boolean | true | false | false | manually enables or disables the mod_deflate Apache module for this server instance |
1556 | httpd_servers | mod_dir | 1.81.7 | | 29 | boolean | true | false | false | manually enables or disables the mod_dir Apache module for this server instance |
1557 | httpd_servers | mod_filter | 1.81.7 | | 30 | boolean | true | false | false | manually enables or disables the mod_filter Apache module for this server instance |
1558 | httpd_servers | mod_headers | 1.81.7 | | 31 | boolean | true | false | false | manually enables or disables the mod_headers Apache module for this server instance |
1559 | httpd_servers | mod_include | 1.81.7 | | 32 | boolean | true | false | false | manually enables or disables the mod_include Apache module for this server instance |
1560 | httpd_servers | mod_jk | 1.81.7 | | 33 | boolean | true | false | false | manually enables or disables the mod_jk Apache module for this server instance |
1561 | httpd_servers | mod_log_config | 1.81.7 | | 34 | boolean | true | false | false | manually enables or disables the mod_log_config Apache module for this server instance |
1562 | httpd_servers | mod_mime | 1.81.7 | | 35 | boolean | true | false | false | manually enables or disables the mod_mime Apache module for this server instance |
1563 | httpd_servers | mod_mime_magic | 1.81.7 | | 36 | boolean | true | false | false | manually enables or disables the mod_mime_magic Apache module for this server instance |
1564 | httpd_servers | mod_negotiation | 1.81.7 | | 37 | boolean | true | false | false | manually enables or disables the mod_negotiation Apache module for this server instance |
1565 | httpd_servers | mod_proxy | 1.81.7 | | 38 | boolean | true | false | false | manually enables or disables the mod_proxy Apache module for this server instance |
1566 | httpd_servers | mod_proxy_http | 1.81.7 | | 39 | boolean | true | false | false | manually enables or disables the mod_proxy_http Apache module for this server instance |
1567 | httpd_servers | mod_reqtimeout | 1.81.7 | | 40 | boolean | true | false | false | manually enables or disables the mod_reqtimeout Apache module for this server instance |
1568 | httpd_servers | mod_rewrite | 1.81.7 | | 41 | boolean | true | false | false | manually enables or disables the mod_rewrite Apache module for this server instance |
1569 | httpd_servers | mod_setenvif | 1.81.7 | | 42 | boolean | true | false | false | manually enables or disables the mod_setenvif Apache module for this server instance |
1570 | httpd_servers | mod_socache_shmcb | 1.81.7 | | 43 | boolean | true | false | false | manually enables or disables the mod_socache_shmcb Apache module for this server instance |
1571 | httpd_servers | mod_ssl | 1.81.7 | | 44 | boolean | true | false | false | manually enables or disables the mod_ssl Apache module for this server instance |
1572 | httpd_servers | mod_status | 1.81.7 | | 45 | boolean | true | false | false | manually enables or disables the mod_status Apache module for this server instance |
1526 | httpd_servers | name | 1.81.8 | | 2 | string | true | false | false | the name of the instance on the server, null for the default instance |
957 | firewalld_zones | fail2ban | 1.81.9 | | 5 | boolean | false | false | false | enables Fail2ban on services in this zone |
1109 | credit_card_transactions | creditCard.expirationMonth | 1.82.0 | | 32 | short | true | false | false | the card expiration month |
1110 | credit_card_transactions | creditCard.expirationYear | 1.82.0 | | 33 | short | true | false | false | the card expiration year |
1138 | credit_card_transactions | authorizationResult.providerReplacementMaskedCardNumber | 1.82.0 | | 57 | string | true | false | false | the provider-specific replacement masked card number |
1139 | credit_card_transactions | authorizationResult.replacementMaskedCardNumber | 1.82.0 | | 58 | string | true | false | false | the replacement masked card number |
1140 | credit_card_transactions | authorizationResult.providerReplacementExpiration | 1.82.0 | | 59 | string | true | false | false | the provider-specific replacement expiration date |
1141 | credit_card_transactions | authorizationResult.replacementExpirationMonth | 1.82.0 | | 60 | short | true | false | false | the replacement card expiration month |
1142 | credit_card_transactions | authorizationResult.replacementExpirationYear | 1.82.0 | | 61 | short | true | false | false | the replacement card expiration year |
1021 | credit_cards | expirationMonth | 1.82.0 | | 5 | short | true | false | false | the card expiration month |
1022 | credit_cards | expirationYear | 1.82.0 | | 6 | short | true | false | false | the card expiration year |
1117 | credit_card_transactions | creditCard.customerId | 1.82.1 | | 40 | string | true | false | false | the merchant-specific unique customer ID |
1033 | credit_cards | customerId | 1.82.1 | | 14 | string | true | false | false | the merchant-specific unique customer ID |
1074 | credit_card_transactions | amount | 1.83.0 | | 7 | money | false | false | false | the amount of the transaction |
1077 | credit_card_transactions | taxAmount | 1.83.0 | | 8 | money | true | false | false | the tax amount of the transaction |
1081 | credit_card_transactions | shippingAmount | 1.83.0 | | 10 | money | true | false | false | the shipping amount for this transaction |
1084 | credit_card_transactions | dutyAmount | 1.83.0 | | 11 | money | true | false | false | the duty amount for this transaction |
208 | Currency | currencyCode | 1.83.0 | | 0 | string | false | true | true | the ISO 4217 currency code of this currency |
209 | Currency | fractionDigits | 1.83.0 | | 1 | short | false | false | true | the number of fraction digits used with this currency |
210 | Currency | autoEnableMinimumPayment | 1.83.0 | | 2 | money | false | false | true | the minimum payment for auto-enabling accounts |
775 | master_processes | id | 1.83.0 | | 0 | SmallIdentifier | false | true | false | |
777 | master_processes | connectorId | 1.83.0 | | 1 | Identifier | true | false | false | |
219 | monthly_charges | rate | 1.83.0 | | 6 | money | false | false | false | the rate |
223 | NoticeLog.balance | id | 1.83.0 | | 0 | pkey | false | true | false | a generated primary key |
224 | NoticeLog.balance | noticeLog | 1.83.0 | | 1 | fkey | false | false | false | the ID of the NoticeLog this balance is part of |
225 | NoticeLog.balance | balance | 1.83.0 | | 2 | money | false | false | false | the balance for a single currency |
245 | package_definition_limits | additionalRate | 1.83.0 | | 5 | money | true | false | false | the monthly rate for those past the soft_limit |
257 | package_definitions | setupFee | 1.83.0 | | 7 | money | true | false | false | the setup fee for this package definition |
260 | package_definitions | monthlyRate | 1.83.0 | | 9 | money | true | false | false | the default monthly charge for this package |
304 | transactions | rate | 1.83.0 | | 8 | money | false | false | false | the amount per unit of quantity |
2527 | httpd_shared_tomcats | tomcatAuthentication | 1.83.2 | | 16 | boolean | false | false | false | the tomcatAuthentication setting for this Tomcat |
2502 | httpd_tomcat_std_sites | tomcatAuthentication | 1.83.2 | | 8 | boolean | false | false | false | the tomcatAuthentication setting for this Tomcat |
375 | dns_records | flag | 1.86.0 | | 7 | short | true | false | false | the CAA flag |
376 | dns_records | tag | 1.86.0 | | 8 | string | true | false | false | the CAA tag |
388 | dns_types | has_flag | 1.86.0 | | 5 | boolean | false | false | true | flags which types have a flag |
389 | dns_types | has_tag | 1.86.0 | | 6 | boolean | false | false | true | flags which types have a tag |
176 | failover_file_replications | use_compression | 1.9 | | 4 | boolean | false | false | false | when compression is enabled, chunk mode is used on mirroring, resulting in more CPU and disk, but less bandwidth |
2522 | httpd_shared_tomcats | maxParameterCount | 1.92.0 | | 11 | int | true | false | false | the maxParameterCount setting for this Tomcat |
2526 | httpd_shared_tomcats | undeployOldVersions | 1.92.0 | | 15 | boolean | false | false | false | the undeployOldVersions setting for this Tomcat |
2497 | httpd_tomcat_std_sites | maxParameterCount | 1.92.0 | | 3 | int | true | false | false | the maxParameterCount setting for this Tomcat |
2501 | httpd_tomcat_std_sites | undeployOldVersions | 1.92.0 | | 7 | boolean | false | false | false | the undeployOldVersions setting for this Tomcat |