1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE `module_fileserver_shares` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `description` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `path` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '',
  `writable` enum('false','true') NOT NULL DEFAULT 'false',
  `guest_ok` enum('false','true') NOT NULL DEFAULT 'false',
  `valid_users` enum('any','select') NOT NULL DEFAULT 'any',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE `module_fileserver_shares` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', `description` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', `path` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '', `writable` enum('false','true') NOT NULL DEFAULT 'false', `guest_ok` enum('false','true') NOT NULL DEFAULT 'false', `valid_users` enum('any','select') NOT NULL DEFAULT 'any', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1