NYCPHP Meetup

[Nasir Zubair]

In that case you'll have to do it manually, using the following query:

ALTER TABLE [table name] TYPE = INNODB;

What version of PMA you are running? I have 2.4.0 and it show all supported
types, including InnoDB. Perhaps your mysql is running with "--skip-innodb"
switch.


-----Original Message-----
From: Phil Powell [mailto:soazine at erols.com] 
Sent: Wednesday, September 10, 2003 3:09 AM
To: NYPHP Talk
Subject: Re: [nycphp-talk] can't create foreign key constraints in schema
-HELP!


Let me preface it by saying I've done Oracle for almost 5 years... this is
brand new to me!!!

I checked using phpMySQLAdmin and InnoDB isn't given as a table type option
(only ISAM, Berkeley DB, Heap, myISAM and one other one I don't remember)..

You see, with Oracle, SQL Server and even Access, I've never had to specify
table type because I would always get - I guess - InnoDB and so foreign key
constraints were a normal part of table schema design..

Phil
----- Original Message ----- 
From: "Nasir Zubair" <lists at ny-tech.net>
To: "'NYPHP Talk'" <talk at lists.nyphp.org>
Sent: Wednesday, September 10, 2003 3:05 AM
Subject: RE: [nycphp-talk] can't create foreign key constraints in schema
-HELP!


> http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html states "In 
> MySQL Server 3.23.44 and up, InnoDB tables support checking of foreign 
> key constraints, including CASCADE, ON DELETE, and ON UPDATE."
>
> Looking at the schema you gave, you are not creating "innoDB" tables.
>
> For example, you will need to change the first table definition from 
> this:
>
> create table if not exists nnet_produkt_varegruppe ( 
> nnet_produkt_varegruppe_id int not null auto_increment, primary 
> key(nnet_produkt_varegruppe_id),
>       nnet_produkt_varegruppe_navn varchar(255) not null
> );
>
> To this:
>
> create table if not exists nnet_produkt_varegruppe ( 
> nnet_produkt_varegruppe_id int not null auto_increment, primary 
> key(nnet_produkt_varegruppe_id),
>       nnet_produkt_varegruppe_navn varchar(255) not null )TYPE=INNODB;
>
> When you leave off the "TYPE" in your table definition, mySQL assumes 
> it
to
> be "TYPE=MYISAM", which doesn't support foreign keys.
>
> More on table types: http://www.mysql.com/doc/en/Table_types.html
>
> Hope it helps :D
>
> - Nasir
>
> -----Original Message-----
> From: Phil Powell [mailto:soazine at erols.com]
> Sent: Wednesday, September 10, 2003 2:58 AM
> To: NYPHP Talk
> Subject: Re: [nycphp-talk] can't create foreign key constraints in 
> schema -HELP!
>
>
> You completely lost me. :(
>
> Phil
>
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk

_______________________________________________
talk mailing list
talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk