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

CREATE TABLE `Modules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `packname` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `version` varchar(30) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `release` int(10) unsigned NOT NULL,
  `description` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1

CREATE TABLE `Modules` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `packname` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `display_name` varchar(255) CHARACTER SET utf8 NOT NULL, `version` varchar(30) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `release` int(10) unsigned NOT NULL, `description` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `icon` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1