1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

CREATE TABLE `anon_ftp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dom_id` int(10) unsigned NOT NULL,
  `max_conn` int(10) unsigned DEFAULT NULL,
  `bandwidth` int(10) unsigned DEFAULT NULL,
  `incoming` enum('false','true') NOT NULL DEFAULT 'false',
  `incoming_readable` enum('false','true') NOT NULL DEFAULT 'false',
  `incoming_subdirs` enum('false','true') NOT NULL DEFAULT 'false',
  `status` enum('false','true') NOT NULL DEFAULT 'false',
  `quota` bigint(20) unsigned DEFAULT '1048576',
  `display_login` enum('false','true') NOT NULL DEFAULT 'false',
  `login_text` text CHARACTER SET utf8,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dom_id` (`dom_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `anon_ftp` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `dom_id` int(10) unsigned NOT NULL, `max_conn` int(10) unsigned DEFAULT NULL, `bandwidth` int(10) unsigned DEFAULT NULL, `incoming` enum('false','true') NOT NULL DEFAULT 'false', `incoming_readable` enum('false','true') NOT NULL DEFAULT 'false', `incoming_subdirs` enum('false','true') NOT NULL DEFAULT 'false', `status` enum('false','true') NOT NULL DEFAULT 'false', `quota` bigint(20) unsigned DEFAULT '1048576', `display_login` enum('false','true') NOT NULL DEFAULT 'false', `login_text` text CHARACTER SET utf8, PRIMARY KEY (`id`), UNIQUE KEY `dom_id` (`dom_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1