几个sql

<pre name="code" class="sql">CREATE TABLE `id_temp_database` (
  `tablename` char(30) NOT NULL,
  `latest_id` int(4) DEFAULT NULL,
  `latest_time` char(20) DEFAULT NULL,
  `latest_url` char(100) DEFAULT NULL,
  `latest_text` char(200) DEFAULT NULL,
  PRIMARY KEY (`tablename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `id_temp_mq` (
  `name` char(50) NOT NULL,
  `size` int(4) DEFAULT NULL,
  `consumerCount` int(4) DEFAULT NULL,
  `enqueueCount` int(4) DEFAULT NULL,
  `dequeueCount` int(4) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `id_temp_sysinfo` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `top_sys_info_time` char(16) DEFAULT NULL,
  `top_running_time` char(16) DEFAULT NULL,
  `top_login_users` char(16) DEFAULT NULL,
  `top_load_average_1min` char(16) DEFAULT NULL,
  `top_load_average_5min` char(16) DEFAULT NULL,
  `top_load_average_15min` char(16) DEFAULT NULL,
  `tasks_total` char(16) DEFAULT NULL,
  `tasks_running` char(16) DEFAULT NULL,
  `tasks_sleeping` char(16) DEFAULT NULL,
  `tasks_stopped` char(16) DEFAULT NULL,
  `tasks_zombie` char(16) DEFAULT NULL,
  `cpu_user_using` char(16) DEFAULT NULL,
  `cpu_core_using` char(16) DEFAULT NULL,
  `cpu_sys_free` char(16) DEFAULT NULL,
  `cpu_sys_io` char(16) DEFAULT NULL,
  `mem_all` char(16) DEFAULT NULL,
  `mem_using_all` char(16) DEFAULT NULL,
  `mem_free_all` char(16) DEFAULT NULL,
  `mem_core_cache` char(16) DEFAULT NULL,
  `swap_all` char(16) DEFAULT NULL,
  `swap_using_all` char(16) DEFAULT NULL,
  `swap_free_all` char(16) DEFAULT NULL,
  `swap_cached_all` char(16) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `id_temp_sysproc` (
  `id` char(10) NOT NULL DEFAULT '',
  `user` char(10) DEFAULT NULL,
  `priority` char(10) DEFAULT NULL,
  `nice` char(10) DEFAULT NULL,
  `virtual_mem` char(10) DEFAULT NULL,
  `res` char(10) DEFAULT NULL,
  `shr` char(10) DEFAULT NULL,
  `status` char(10) DEFAULT NULL,
  `cpu` char(10) DEFAULT NULL,
  `mem` char(10) DEFAULT NULL,
  `time_used` char(16) DEFAULT NULL,
  `command` char(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;