redisdog/src/cnphper.com/redisdog/sql.go

package main

var (
	Sql_Table_Syscfg = `
CREATE TABLE IF NOT EXISTS syscfg (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  cfg_key TEXT UNIQUE,
  cfg_value TEXT NOT NULL
)`
	Sql_Table_Accounts = `
CREATE TABLE IF NOT EXISTS accounts (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  account TEXT UNIQUE,
  name TEXT NOT NULL,
  password TEXT NOT NULL,
  last_login INTEGER NOT NULL DEFAULT 0,
  is_super INTEGER NOT NULL DEFAULT 0,
  disabled INTEGER NOT NULL DEFAULT 0
)`
	Sql_Table_Rediscfg = `
CREATE TABLE IF NOT EXISTS rediscfg (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  address TEXT UNIQUE,
  remark TEXT NOT NULL DEFAULT '',
  password TEXT NOT NULL DEFAULT '',
  max_connect_wait INTEGER NOT NULL DEFAULT 5,
  max_status_failed INTEGER NOT NULL DEFAULT 1,
  min_memory_free INTEGER NOT NULL DEFAULT 0,
  min_memory_free_pc INTEGER NOT NULL DEFAULT 0,
  max_memory_usage INTEGER NOT NULL DEFAULT 16000000000,
  max_connection INTEGER NOT NULL DEFAULT 1000,
  max_evi_increased INTEGER NOT NULL DEFAULT 1,
  max_qps INTEGER NOT NULL DEFAULT 50000,
  mail_list TEXT NOT NULL DEFAULT '',
  disabled INTEGER NOT NULL DEFAULT 0
)`
	Sql_Table_Syslog = `
CREATE TABLE IF NOT EXISTS syslog (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  account_id INTEGER NOT NULL,
  log_time INTEGER NOT NULL,
  log_msg TEXT COMMENT NOT NULL
)`
	Sql_Index_Syslog    = `CREATE INDEX IF NOT EXISTS idx_account ON syslog(account_id)`
	Sql_Table_Statuslog = `
CREATE TABLE IF NOT EXISTS statuslog (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  redis_id INTEGER NOT NULL,
  check_time INTEGER NOT NULL,
  status INTEGER NOT NULL DEFAULT 0,
  info TEXT NOT NULL DEFAULT '',
  memory_usage INTEGER NOT NULL DEFAULT 0,
  memory_usage_pc INTEGER NOT NULL DEFAULT 0,
  connection INTEGER NOT NULL DEFAULT 0,
  qps INTEGER NOT NULL DEFAULT 0,
  evi_increased INTEGER NOT NULL DEFAULT 0,
  UNIQUE (redis_id, check_time)
)`
	Sql_Table_Warnlog = `
CREATE TABLE IF NOT EXISTS warnlog (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  redis_id INTEGER NOT NULL,
  warn_time INTEGER NOT NULL,
  warn_msg TEXT NOT NULL,
  warn_status INTEGER NOT NULL DEFAULT 0,
  UNIQUE (redis_id, warn_time)
)`
	Sql_Table_Processlog = `
CREATE TABLE IF NOT EXISTS processlog (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  redis_id INTEGER NOT NULL,
  process_time INTEGER NOT NULL,
  process_info TEXT NOT NULL DEFAULT '',
  process_status INTEGER NOT NULL DEFAULT 0,
  UNIQUE (redis_id, process_time)
)`
	Sql_Values_Accounts = `INSERT OR IGNORE INTO accounts VALUES(NULL,'root','超管','bfa7db1d229563267ef3e0caf6712157',0,1,0)`
	Sql_Values_Syscfg   = `
INSERT OR IGNORE INTO syscfg VALUES
(NULL,'smtp_host','smtp.163.com'),
(NULL,'smtp_port','25'),
(NULL,'smtp_user',''),
(NULL,'smtp_pwd',''),
(NULL,'smtp_sender',''),
(NULL,'misc_check_delay','30'),
`
)