NYCPHP Meetup

[Phil Powell]

2.3.3 is what they're running.  Don't know if that version has any option
for InnoDB

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:25 AM
Subject: RE: [nycphp-talk] can't create foreign key constraints in
schema -HELP!


> 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
>
>
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk