NYCPHP Meetup

[Nasir Zubair]

Latest one is 2.5.3. See if using that gives you the option. Of course
you'll have to install it first ;) http://www.phpmyadmin.net/


- Nasir

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


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

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