NYCPHP Meetup

NYPHP.org

[nycphp-talk] can't create foreign key constraints in schema -HELP!

Nasir Zubair lists at ny-tech.net
Wed Sep 10 03:53:03 EDT 2003


Oh, it's just a bunch of php files. Just edit the config file and dump 'em
all into a subdirectory of your account ( via FTP).


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


Install it.. where? This is on a remote server that is approximately 5000
miles away!  And I don't even have telnet, much less SSH access.

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


> 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
>
>
> _______________________________________________
> 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





More information about the talk mailing list