CREATE TABLE `Capacitor` ( `ComponentId` varchar(11) NOT NULL, `Class` varchar(48) NOT NULL DEFAULT 'Capacitor', `PartName` varchar(127) NOT NULL DEFAULT 'CAP', `Mounting` varchar(16) DEFAULT 'SMT', `Description` varchar(255) DEFAULT NULL, `Value` varchar(16) DEFAULT NULL, `Voltage` varchar(8) DEFAULT NULL, `Current` varchar(8) DEFAULT NULL, `Dielectric` varchar(8) DEFAULT NULL, `Accuracy` varchar(8) DEFAULT NULL, `Package` varchar(32) DEFAULT NULL, `PartCode` varchar(64) DEFAULT NULL, `Manufacturer` varchar(255) DEFAULT NULL, `MfgOrderCode` varchar(255) DEFAULT NULL, `Distributor` varchar(255) DEFAULT NULL, `DistOrderCode` varchar(255) DEFAULT NULL, `CostUSD` varchar(16) DEFAULT NULL, `CostGBP` varchar(16) DEFAULT NULL, `LibRef` varchar(127) DEFAULT NULL, `LibPath` varchar(255) DEFAULT NULL, `ModelRef` varchar(127) DEFAULT NULL, `ModelPath` varchar(255) DEFAULT NULL, PRIMARY KEY (`ComponentId`), UNIQUE KEY `Part_Name_Unique` (`PartName`) /*!80000 INVISIBLE */, UNIQUE KEY `ComponentId_UNIQUE` (`ComponentId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Altium component database for capacitors';