Defining relation between tables

From: Date: Tue, 30 Sep 2003 00:31:26 +0000
Subject: Defining relation between tables
Groups: php.db php.db 
Request: Send a blank email to php-db+get-30753@lists.php.net to get a copy of this message
Hi ; I am a new programmer of PHP4.3.3 an MySql 3.23 . In MyPhpAdmin CREATE DATABASE phpmyadmin; GRANT SELECT,INSERT,DELETE ON phpmyadmin.* to 'local host user'; enter the databasename in $cfg['Servers'][$i]['pmadb'] (this works) But the statement below dosen't work at all. >CREATE TABLE PMA_bookmark ( id int(11) DEFAULT '0' NOT NULL auto_increment, dbase varchar(255) NOT NULL, user varchar(255) NOT NULL, label varchar(255) NOT NULL, query text NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM COMMENT='Bookmarks'; enter the tablename in $cfg['Servers'][$i]['bookmarktable'] > CREATE TABLE PMA_relation ( master_db varchar(64) NOT NULL default '', master_table varchar(64) NOT NULL default '', master_field varchar(64) NOT NULL default '', foreign_db varchar(64) NOT NULL default '', foreign_table varchar(64) NOT NULL default '', foreign_field varchar(64) NOT NULL default '', PRIMARY KEY (master_db, master_table, master_field), KEY foreign_field (foreign_db, foreign_table) ) TYPE=MyISAM COMMENT='Relation table'; put the relation table name in $cfg['Servers'][$i]['relation'] >CREATE TABLE PMA_table_info ( db_name varchar(64) NOT NULL default '', table_name varchar(64) NOT NULL default '', display_field varchar(64) NOT NULL default '', PRIMARY KEY (db_name, table_name) ) TYPE=MyISAM COMMENT='Table information for phpMyAdmin'; put the table name in $cfg['Servers'][$i]['table_info'] >CREATE TABLE PMA_column_comments ( id int(5) unsigned NOT NULL auto_increment, db_name varchar(64) NOT NULL default '', table_name varchar(64) NOT NULL default '', column_name varchar(64) NOT NULL default '', comment varchar(255) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY db_name (db_name, table_name, column_name) ) TYPE=MyISAM COMMENT='Comments for Columns'; put the table name in $cfg['Servers'][$i]['column_comments'] in the CONFIG.INC.PHP $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; // Database used for Relation, Bookmark and PDF Features // - leave blank for no support $cfg['Servers'][$i]['bookmarktable'] = 'PMA_bookmark'; // Bookmark table - leave blank for no bookmark support $cfg['Servers'][$i]['relation'] = 'PMA_relation'; // table to describe the relation between links (see doc) // - leave blank for no relation-links support $cfg['Servers'][$i]['table_info'] = 'PMA_table_info'; // table to describe the display fields // - leave blank for no display fields support $cfg['Servers'][$i]['table_coords'] = 'PMA_table_coords'; // table to describe the tables position for the PDF // schema - leave blank for no PDF schema support $cfg['Servers'][$i]['pdf_pages'] = 'PMA_pdf_pages'; // table to describe pages of relationpdf // - leave blank if you don't want to use this $cfg['Servers'][$i]['column_comments'] = 'PMA_column_comments'; // table to store columncomments // - leave blank if you don't want to use this Inspite of every things have done when I try to use the tables in the one of a database MyPhpAdmin sends this message so I can't define any relation between two tables. first ; The message is something like this "The extra features that were used to work with the related tables, were deactivated." second;PMA Database ... ok relation Table ... not activated. table_info ... not activated table_coords ... not activated pdf_pages ... not activated creating PDF ... not activated column_comments ... not activated show of column comment : not activated Please help me. thanks for your attentions.

« previous php.db (#30753) next »