1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| CREATE TABLE IF NOT EXISTS `infoappli` (
`name` varchar(20) COLLATE latin1_bin NOT NULL DEFAULT '',
`ansys` tinyint(4) DEFAULT NULL,
`autre` tinyint(4) DEFAULT NULL,
`cadence` tinyint(4) DEFAULT NULL,
`cadra` tinyint(4) DEFAULT NULL,
`fluent` tinyint(4) DEFAULT NULL,
`medusa` tinyint(4) DEFAULT NULL,
`mentor` tinyint(4) DEFAULT NULL,
`metaphase` tinyint(4) DEFAULT NULL,
`moldflow` tinyint(4) DEFAULT NULL,
`pcnetlink` tinyint(4) DEFAULT NULL,
`proengineer` tinyint(4) DEFAULT NULL,
`prointralink` tinyint(4) DEFAULT NULL,
`promecanica` tinyint(4) DEFAULT NULL,
`propdm` tinyint(4) DEFAULT NULL,
`samba` tinyint(4) DEFAULT NULL,
`ssh` tinyint(4) DEFAULT NULL,
`symphony` tinyint(4) DEFAULT NULL,
`visula` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`name`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin; |
Partager