text: 
  CREATE TABLE IF NOT EXISTS `backup` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `type` INTEGER,
    `name` TEXT,
    `pid` INTEGER,
    `filename` TEXT,
    `size` INTEGER,
    `addtime` TEXT
  );
  
  CREATE TABLE IF NOT EXISTS `binding` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `pid` INTEGER,
    `domain` TEXT,
    `path` TEXT,
    `port` INTEGER,
    `addtime` TEXT
  );
  
  
  CREATE TABLE IF NOT EXISTS `crontab` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `name` TEXT,
    `type` TEXT,
    `where1` TEXT,
    `where_hour` INTEGER,
    `where_minute` INTEGER,
    `echo` TEXT,
    `addtime` TEXT,
    `status` INTEGER DEFAULT '1',
    `save` INTEGER DEFAULT '3',
    `backup_to` TEXT DEFAULT 'off', 
    `sname` TEXT,
    `sbody` TEXT,
    'stype' TEXT,
    `urladdress` TEXT
  );
  
  CREATE TABLE IF NOT EXISTS `firewall` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `port` TEXT,
    `ps` TEXT,
    `addtime` TEXT
  );
  
  INSERT INTO `firewall` (`id`, `port`, `ps`, `addtime`) VALUES
  (1, '80', '网站默认端口', '0000-00-00 00:00:00'),
  (2, '7200', 'WEB面板', '0000-00-00 00:00:00'),
  (3, '22', 'SSH远程管理服务', '0000-00-00 00:00:00'),
  (4, '888', 'phpMyAdmin默认端口', '0000-00-00 00:00:00'),
  (5, '3306', 'MySQL端口', '0000-00-00 00:00:00');
  
  
  
  CREATE TABLE IF NOT EXISTS `logs` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `type` TEXT,
    `log` TEXT,
    `addtime` TEXT
  );
  
  CREATE TABLE IF NOT EXISTS `sites` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `name` TEXT,
    `path` TEXT,
    `status` TEXT,
    `index` TEXT,
    `type_id` INTEGER,
    `ps` TEXT,
    `edate` TEXT,
    `addtime` TEXT
  );
  
  CREATE TABLE IF NOT EXISTS `site_types` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `name` TEXT
  );
  
  CREATE TABLE IF NOT EXISTS `domain` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `pid` INTEGER,
    `name` TEXT,
    `port` INTEGER,
    `addtime` TEXT
  );
  
  CREATE TABLE IF NOT EXISTS `users` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `username` TEXT,
    `password` TEXT,
    `login_ip` TEXT,
    `login_time` TEXT,
    `phone` TEXT,
    `email` TEXT
  );
  
  INSERT INTO `users` (`id`, `username`, `password`, `login_ip`, `login_time`, `phone`, `email`) VALUES
  (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '192.168.0.10', '2016-12-10 15:12:56', 0, '287962566@qq.com');
  
  
  CREATE TABLE IF NOT EXISTS `tasks` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `name` 			TEXT,
    `type`			TEXT,
    `status` 		TEXT,
    `addtime` 	TEXT,
    `start` 	  INTEGER,
    `end` 	    INTEGER,
    `execstr` 	TEXT
  );
  
  CREATE TABLE IF NOT EXISTS `panel` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `title` TEXT,
    `url` TEXT,
    `username` TEXT,
    `password` TEXT,
    `click` INTEGER,
    `addtime` INTEGER
  );
  