123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687 |
- 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'),
- `
- )
|