Code Block |
---|
`access_details` text NOT NULL,
`comments` text NOT NULL,
`contact_id` int(10) unsigned NOT NULL DEFAULT '0',
`contact_name` varchar(50) NOT NULL DEFAULT '',
`dbus_identifier` varchar(255) NOT NULL DEFAULT '',
`description` text NOT NULL,
`domain` varchar(100) NOT NULL DEFAULT '',
`first_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`form_factor` varchar(50) NOT NULL DEFAULT '',
`fqdn` text NOT NULL,
`hostname` varchar(100) NOT NULL DEFAULT '',
`icon` varchar(50) NOT NULL DEFAULT '',
`invoice_id` int(10) unsigned DEFAULT NULL,
`last_seen_by` varchar(150) NOT NULL DEFAULT '',
`last_seen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_user` varchar(150) NOT NULL DEFAULT '',
`linked_sys` int(10) NOT NULL DEFAULT '0',
`man_asset_number` varchar(50) NOT NULL DEFAULT '',
`man_class` enum('desktop','laptop','tablet','workstation','server','virtual server','virtual desktop','','hypervisor') NOT NULL DEFAULT '',
`man_cluster_name` varchar(150) NOT NULL DEFAULT '',
`man_criticality` enum('critical','normal','low') NOT NULL DEFAULT 'normal',
`man_description` text NOT NULL,
`man_domain` varchar(100) NOT NULL DEFAULT '',
`man_environment` enum('production','dev','dr','eval','pre-prod','test','train','uat') NOT NULL DEFAULT 'production',
`man_form_factor` varchar(50) NOT NULL DEFAULT '',
`man_function` varchar(100) NOT NULL DEFAULT '',
`man_ip_address` varchar(30) NOT NULL DEFAULT '',
`man_lease_expiry_date` date NOT NULL DEFAULT '0000-00-00',
`man_location_id` int(10) unsigned NOT NULL DEFAULT '0',
`man_location_latitude` float(10,6) NOT NULL,
`man_location_level` varchar(100) NOT NULL DEFAULT '',
`man_location_longitude` float(10,6) NOT NULL,
`man_location_rack_position` varchar(100) NOT NULL DEFAULT '',
`man_location_rack_size` int(10) unsigned NOT NULL DEFAULT '0',
`man`contact_location_rack`name` varchar(10050) NOT NULL DEFAULT '',
`man`dbus_location_room`identifier` varchar(100255) NOT NULL DEFAULT '',
`man_location_suite``description` text NOT NULL,
`domain` varchar(100) NOT NULL DEFAULT '',
`man`first_manufacturer` varchar(50)timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`man`form_model`factor` varchar(50) NOT NULL DEFAULT '',
`man_oae_manage` enum('y','n')`fqdn` text NOT NULL DEFAULT 'y',
`man_org_id` int(10`hostname` varchar(100) unsigned NOT NULL DEFAULT '0',
`man_os_family``icon` varchar(50) NOT NULL DEFAULT '',
`man`invoice_os_group`id` varcharint(5010) NOTunsigned NULL DEFAULT ''NULL,
`man`last_osseen_name`by` varchar(100150) NOT NULL DEFAULT '',
`man`last_owner` varchar(100)seen` datetime NOT NULL DEFAULT '',
`man_patch_panel_port` varchar(45) NOT NULL DEFAULT '0000-00-00 00:00:00',
`man`last_patch_panel`user` varchar(45150) NOT NULL DEFAULT '',
`man`linked_picture`sys` varcharint(10010) NOT NULL DEFAULT '0',
`man_purchaseasset_amount`number` varchar(50) NOT NULL DEFAULT '',
`man_purchase_cost_center` varchar(50) NOT NULL DEFAULT '',
`man_purchase_date` dateclass` enum('desktop','laptop','tablet','workstation',
'server','virtual server','virtual desktop','','hypervisor') NOT NULL DEFAULT '0000-00-00',
`man_purchasecluster_invoice`name` varchar(50150) NOT NULL DEFAULT '',
`man_purchase_order_number` varchar(50criticality` enum('critical','normal','low') NOT NULL DEFAULT 'normal',
`man_purchase_service_contract_number` varchar(255)description` text NOT NULL DEFAULT '',
`man_purchase_vendor`domain` varchar(100) NOT NULL DEFAULT '',
`man_serial_imei`environment` varchar(100enum('production','dev','dr','eval',
'pre-prod','test','train','uat') NOT NULL DEFAULT 'production',
`man_serialform_sim`factor` varchar(10050) NOT NULL DEFAULT '',
`man_serial`function` varchar(250100) NOT NULL DEFAULT '',
`man_serviceip_network`address` varchar(10030) NOT NULL DEFAULT '',
`man_lease_serviceexpiry_number` varchar(100)date` date NOT NULL DEFAULT '0000-00-00',
`man_servicelocation_plan`id` varcharint(10010) unsigned NOT NULL DEFAULT '0',
`man_servicelocation_provider`latitude` varcharfloat(10010,6) NOT NULL DEFAULT '',
`man_servicelocation_type`level` varchar(100) NOT NULL DEFAULT '',
`man_status`location_longitude` enumfloat('production','deleted','lost','maintenance','retired','unallocated'10,6) NOT NULL DEFAULT 'production',
`man_switchlocation_rack_id`position` varchar(100) NOT NULL DEFAULT '',
`man_switchlocation_rack_port`size` varcharint(10010) unsigned NOT NULL DEFAULT '0',
`man_terminallocation_number`rack` intvarchar(10100) NOT NULL DEFAULT '0',
`man_type`location_room` varchar(100) NOT NULL DEFAULT '',
`man_unlocklocation_pin`suite` varchar(100) NOT NULL DEFAULT '',
`man_vm_group`manufacturer` varchar(15050) NOT NULL DEFAULT '',
`man_vm_server_name`model` varchar(15050) NOT NULL DEFAULT '',
`man_vmoae_system_id`manage` varchar(150enum('y','n') NOT NULL DEFAULT 'y',
`man_wallorg_port`id` varcharint(10010) unsigned NOT NULL DEFAULT '0',
`man_warrantyos_duration`family` intvarchar(550) unsigned NOT NULL DEFAULT '0',
`man_warrantyos_expires` dategroup` varchar(50) NOT NULL DEFAULT '0000-00-00',
`man_warrantyos_type`name` enum(varchar(100) NOT NULL DEFAULT '','24x7x365','9x5x5','Next Business Day'
`man_owner` varchar(100) NOT NULL DEFAULT '',
`manufacturer``man_patch_panel_port` varchar(5045) NOT NULL DEFAULT '',
`model``man_patch_panel` varchar(20045) NOT NULL DEFAULT '',
`nmap`man_type`picture` varchar(50100) NOT NULL DEFAULT '',
`nmis`man_export`purchase_amount` enum('true','false'varchar(50) NOT NULL DEFAULT 'false',
`nmis_group``man_purchase_cost_center` varchar(50) NOT NULL DEFAULT '',
`nmis`man_purchase_name` varchar(50)date` date NOT NULL DEFAULT '0000-00-00',
`nmis`man_purchase_role`invoice` varchar(50) NOT NULL DEFAULT '',
`os_family``man_purchase_order_number` varchar(50) NOT NULL DEFAULT '',
`os_group``man_purchase_service_contract_number` varchar(50255) NOT NULL DEFAULT '',
`os`man_purchase_name`vendor` varchar(100) NOT NULL DEFAULT '',
`os`man_serial_version`imei` varchar(50100) NOT NULL DEFAULT '',
`pc`man_dateserial_os_installation` datesim` varchar(100) NOT NULL DEFAULT '0000-00-00',
`pc`man_memory`serial` intvarchar(10250) NOT NULL DEFAULT '0',
`pc`man_numservice_processor`network` intvarchar(10100) NOT NULL DEFAULT '0',
`pc`man_osservice_bit`number` varchar(3100) NOT NULL DEFAULT '',
`printer`man_service_color`plan` varchar(5100) NOT NULL DEFAULT '',
`printer`man_service_duplex`provider` varchar(5100) NOT NULL DEFAULT '',
`printer`man_portservice_name`type` varchar(50100) NOT NULL DEFAULT '',
`printer`man_shared_name`status` varchar(50enum('production','deleted','lost','maintenance',
'retired','unallocated') NOT NULL DEFAULT 'production',
`printer`man_switch_shared`id` varchar(50100) NOT NULL DEFAULT '',
`serial``man_switch_port` varchar(250100) NOT NULL DEFAULT '',
`snmp`man_terminal_oid` textnumber` int(10) NOT NULL DEFAULT '0',
`sysContact``man_type` varchar(255100) NOT NULL DEFAULT '',
`sysDescr` text NOT NULL,
`sysLocation` varchar(255`man_unlock_pin` varchar(100) NOT NULL DEFAULT '',
`sysName``man_vm_group` varchar(255150) NOT NULL DEFAULT '',
`sysObjectID``man_vm_server_name` varchar(255150) NOT NULL DEFAULT '',
`system`man_vm_system_id` intvarchar(10150) unsigned NOT NULL AUTO_INCREMENT DEFAULT '',
`system`man_keywall_type`port` varchar(4100) NOT NULL DEFAULT '',
`system`man_warranty_key`duration` varcharint(2005) unsigned NOT NULL DEFAULT '0',
`sysUpTime` varchar(255)`man_warranty_expires` date NOT NULL DEFAULT '0000-00-00',
`timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`type` varchar(50`man_warranty_type` enum('','24x7x365','9x5x5',
'Next Business Day') NOT NULL DEFAULT '',
`uptime``manufacturer` varchar(50) NOT NULL DEFAULT '',
`uuid``model` varchar(100200) NOT NULL DEFAULT '', |
Code Block |
---|
`asset_number`
`nmap_type` varchar(50) NOT NULL DEFAULT '',
`attached_system_id` int(10) DEFAULT NULL,
`class` enum('desktop','laptop','tablet','workstation','server','virtual server','virtual desktop','hypervisor',''`nmis_export` enum('true','false') NOT NULL DEFAULT 'false',
`nmis_group` varchar(50) NOT NULL DEFAULT '',
`cluster`nmis_name` varchar(15050) NOT NULL DEFAULT '',
`cluster`nmis_type`role` varchar(15050) NOT NULL DEFAULT '',
`comments` text`os_family` varchar(50) NOT NULL DEFAULT '',
`contact`os_name`group` varchar(50) NOT NULL DEFAULT '',
`dbus`os_identifier`name` varchar(255100) NOT NULL DEFAULT '',
`description` text`os_version` varchar(50) NOT NULL DEFAULT '',
`dns_domain` varchar(100)`pc_date_os_installation` date NOT NULL DEFAULT '0000-00-00',
`dns`pc_hostname`memory` varcharint(10010) NOT NULL DEFAULT '0',
`domain` varchar(100`pc_num_processor` int(10) NOT NULL DEFAULT '0',
`environment` enum('production','dev','dr','eval','pre-prod','test','train','uat'`pc_os_bit` varchar(3) NOT NULL DEFAULT 'production',
`first`printer_seen` datetimecolor` varchar(5) NOT NULL DEFAULT '0000-00-00 00:00:00',
`form`printer_factor`duplex` varchar(505) NOT NULL DEFAULT '',
`fqdn` text`printer_port_name` varchar(50) NOT NULL,
`function` DEFAULT '',
`printer_shared_name` varchar(10050) NOT NULL DEFAULT '',
`hostname``printer_shared` varchar(10050) NOT NULL DEFAULT '',
`icon``serial` varchar(50250) NOT NULL DEFAULT '',
`id` int(10) unsigned `snmp_oid` text NOT NULL AUTO_INCREMENT,
`invoice_id``sysContact` intvarchar(10255) unsignedNOT NULL DEFAULT '',
`sysDescr` text NOT NULL,
`ip``sysLocation` varchar(45255) NOT NULL DEFAULT '',
`last_seen_by``sysName` varchar(150255) NOT NULL DEFAULT '',
`last_seen` datetime `sysObjectID` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00',
`last`system_user`id` varcharint(15010) unsigned NOT NULL DEFAULT ''AUTO_INCREMENT,
`lease`system_expirykey_date` datetype` varchar(4) NOT NULL DEFAULT '0000-00-00',
`location`system_id`key` intvarchar(10200) unsigned NOT NULL DEFAULT '0',
`location_latitude``sysUpTime` floatvarchar(10,6255) NOT NULL,
`location_level` varchar(100) DEFAULT '',
`timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`location_longitude``type` floatvarchar(10,650) NOT NULL DEFAULT '',
`location_rack_position``uptime` varchar(10050) NOT NULL DEFAULT '',
`location_rack_size` int(10) unsigned`uuid` varchar(100) NOT NULL DEFAULT '0', |
| Code Block |
---|
`asset_number`
`location_rack` varchar(10050) NOT NULL DEFAULT '',
`location`attached_system_room`id` varcharint(10010) NOTDEFAULT NULL,
DEFAULT`class` enum('desktop','laptop','tablet','workstation',
`location_suite` varchar(100'server','virtual server','virtual desktop','hypervisor','') NOT NULL DEFAULT '',
`manufacturer``cluster_name` varchar(100150) NOT NULL DEFAULT '',
`memory`cluster_count`type` intvarchar(10150) unsigned NOT NULL DEFAULT '0',
`model` varchar(200)`comments` text NOT NULL DEFAULT '',
`name``contact_name` varchar(10050) NOT NULL DEFAULT '',
`nmis`dbus_export`identifier` enum('y','n'varchar(255) NOT NULL DEFAULT 'n',
`nmis_group``description` text NOT NULL,
`dns_domain` varchar(50100) NOT NULL DEFAULT '',
`nmis`dns_name`hostname` varchar(50100) NOT NULL DEFAULT '',
`nmis_role``domain` varchar(50100) NOT NULL DEFAULT '',
`oae_manage``environment` enum('yproduction','n') NOT NULL DEFAULT 'y',
`org_id` int(10) unsigned dev','dr','eval',
'pre-prod','test','train','uat') NOT NULL DEFAULT '0production',
`os`first_bit` tinyint(3) unsigned seen` datetime NOT NULL DEFAULT '00000-00-00 00:00:00',
`os`form_family`factor` varchar(50) NOT NULL DEFAULT '',
`os_group` `fqdn` text NOT NULL,
`function` varchar(50100) NOT NULL DEFAULT '',
`os_installation_date` date`hostname` varchar(100) NOT NULL DEFAULT '0000-00-00',
`os_name``icon` varchar(10050) NOT NULL DEFAULT '',
`os_version``id` varcharint(5010) unsigned NOT NULL AUTO_INCREMENT,
`invoice_id` int(10) unsigned DEFAULT ''NULL,
`owner``ip` varchar(10045) NOT NULL DEFAULT '',
`patch`last_panelseen_port`by` intvarchar(10150) unsigned NOT NULL DEFAULT '0',
`patch`last_panel` varchar(45)seen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`printer`last_color`user` enum('y','n',''varchar(150) NOT NULL DEFAULT '',
`printer`lease_expiry_duplex` enum('y','n','')date` date NOT NULL DEFAULT '0000-00-00',
`printer`location_port_name`id` varcharint(5010) unsigned NOT NULL DEFAULT '0',
`printer`location_shared_name`latitude` varcharfloat(5010,6) NOT NULL DEFAULT '',
`printer`location_shared`level` varchar(50100) NOT NULL DEFAULT '',
`processor`location_count`longitude` tinyintfloat(310,6) unsigned NOT NULL DEFAULT '0',
`purchase`location_rack_amount`position` varchar(50100) NOT NULL DEFAULT '',
`purchase`location_costrack_center`size` varcharint(5010) unsigned NOT NULL DEFAULT '0',
`purchase`location_date` daterack` varchar(100) NOT NULL DEFAULT '0000-00-00',
`purchase`location_invoice`room` varchar(50100) NOT NULL DEFAULT '',
`purchase`location_order_number`suite` varchar(50100) NOT NULL DEFAULT '',
`purchase_service_contract_number``manufacturer` varchar(255100) NOT NULL DEFAULT '',
`purchase`memory_vendor`count` varcharint(10010) unsigned NOT NULL DEFAULT '0',
`serial_imei``model` varchar(100200) NOT NULL DEFAULT '',
`serial_sim``name` varchar(100) NOT NULL DEFAULT '',
`serial``nmis_export` varchar(200enum('y','n') NOT NULL DEFAULT 'n',
`service`nmis_network`group` varchar(10050) NOT NULL DEFAULT '',
`service`nmis_number`name` varchar(10050) NOT NULL DEFAULT '',
`service`nmis_plan`role` varchar(10050) NOT NULL DEFAULT '',
`service`oae_provider`manage` varchar(100) enum('y','n') NOT NULL DEFAULT 'y',
`service`org_type`id` varcharint(10010) unsigned NOT NULL DEFAULT '0',
`snmp_oid` text`os_bit` tinyint(3) unsigned NOT NULL DEFAULT '0',
`status``os_family` enum('production','deleted','lost','maintenance','retired','unallocated'varchar(50) NOT NULL DEFAULT 'production',
`switch`os_port`group` intvarchar(1050) unsigned NOT NULL DEFAULT '0',
`switch`os_systeminstallation_id` int(10) DEFAULT NULL,
`sysContact` varchar(255) date` date NOT NULL DEFAULT '0000-00-00',
`sysDescr` text NOT NULL,
`sysLocation` varchar(255`os_name` varchar(100) NOT NULL DEFAULT '',
`sysName``os_version` varchar(25550) NOT NULL DEFAULT '',
`sysObjectID``owner` varchar(255100) NOT NULL DEFAULT '',
`sysUpTime` varchar(255`patch_panel_port` int(10) unsigned NOT NULL DEFAULT '0',
`type``patch_panel` varchar(5045) NOT NULL DEFAULT '',
`unlock`printer_pin`color` varchar(100enum('y','n','') NOT NULL DEFAULT '',
`uptime``printer_duplex` varchar(50enum('y','n','') NOT NULL DEFAULT '',
`uuid``printer_port_name` varchar(10050) NOT NULL DEFAULT '',
`vm`printer_shared_group`name` varchar(15050) NOT NULL DEFAULT '',
`vm`printer_server_name`shared` varchar(15050) NOT NULL DEFAULT '',
`vm`processor_system_id`count` inttinyint(103) unsigned NOT NULL DEFAULT NULL'0',
`wall`purchase_port`amount` varchar(10050) NOT NULL DEFAULT '',
`purchase_cost_center` varchar(50) NOT NULL DEFAULT '',
`purchase_date` date NOT NULL DEFAULT '0000-00-00',
`purchase_invoice` varchar(50) NOT NULL DEFAULT '',
`warranty_duration` int(5) unsigned NOT NULL DEFAULT '0',
`warranty_expires` date NOT NULL DEFAULT '0000-00-00',
`warranty_type` enum('','24x7x365','9x5x5','Next Business Day') NOT NULL DEFAULT '',,
`purchase_order_number` varchar(50) NOT NULL DEFAULT '',
`purchase_service_contract_number` varchar(255) NOT NULL DEFAULT '',
`purchase_vendor` varchar(100) NOT NULL DEFAULT '',
`serial_imei` varchar(100) NOT NULL DEFAULT '',
`serial_sim` varchar(100) NOT NULL DEFAULT '',
`serial` varchar(200) NOT NULL DEFAULT '',
`service_network` varchar(100) NOT NULL DEFAULT '',
`service_number` varchar(100) NOT NULL DEFAULT '',
`service_plan` varchar(100) NOT NULL DEFAULT '',
`service_provider` varchar(100) NOT NULL DEFAULT '',
`service_type` varchar(100) NOT NULL DEFAULT '',
`snmp_oid` text NOT NULL,
`status` enum('production','deleted','lost','maintenance',
'retired','unallocated') NOT NULL DEFAULT 'production',
`switch_port` int(10) unsigned NOT NULL DEFAULT '0',
`switch_system_id` int(10) DEFAULT NULL,
`sysContact` varchar(255) NOT NULL DEFAULT '',
`sysDescr` text NOT NULL,
`sysLocation` varchar(255) NOT NULL DEFAULT '',
`sysName` varchar(255) NOT NULL DEFAULT '',
`sysObjectID` varchar(255) NOT NULL DEFAULT '',
`sysUpTime` varchar(255) NOT NULL DEFAULT '',
`type` varchar(50) NOT NULL DEFAULT '',
`unlock_pin` varchar(100) NOT NULL DEFAULT '',
`uptime` varchar(50) NOT NULL DEFAULT '',
`uuid` varchar(100) NOT NULL DEFAULT '',
`vm_group` varchar(150) NOT NULL DEFAULT '',
`vm_server_name` varchar(150) NOT NULL DEFAULT '',
`vm_system_id` int(10) unsigned DEFAULT NULL,
`wall_port` varchar(100) NOT NULL DEFAULT '',
`warranty_duration` int(5) unsigned NOT NULL DEFAULT '0',
`warranty_expires` date NOT NULL DEFAULT '0000-00-00',
`warranty_type` enum('','24x7x365','9x5x5',
'Next Business Day') NOT NULL DEFAULT '', |
|