Re: MySQL dogletesen lassu

Fri, 22 Jun 2007 04:34:56 -0700 

In article <[EMAIL PROTECTED]>,
        =?UTF-8?B?S292w6FjcyBBdHRpbGE=?= <[EMAIL PROTECTED]> writes:
> 
> S2lzcyBHYWJvciDDrXJ0YToKPgo+IElua2FiYiBhIGxvZ2JhbiBmZWxsZWx0IHBhbmFzeiB2ZXpl
> dCBueW9tcmEgYSBsb2Nrb2xhc3JvbC4KPiAgIApBenQgYWtrb3IgbcOpZyBuZW0gw61ydGFkIDop
...

Reszlet a scriptbol, ami felepiti az adatbazist a program installalasakor:

--
-- Table structure for table `alarms`
--

DROP TABLE IF EXISTS `alarms`;
CREATE TABLE `alarms` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `starttime` int(10) unsigned default NULL,
  `stoptime` int(10) unsigned default NULL,
  `profile` varchar(100) default NULL,
  `type` varchar(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `stoptime` (`stoptime`,`profile`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

(Tevedtem, vannak kulcsok.)

kissg
_________________________________________________
linux lista      -      [email protected]
http://mlf2.linux.rulez.org/mailman/listinfo/linux

válasz