Anonyme 19853
| Posté : 28-12-2003 19:23
en effet
faut les activer comment?
là encore cela semble simple
creer la base phpmyadmin
puis executer la requete ci dessous
ensuite faudra modifier le fichier config.inc.php qui est dans le rep phpmyadmin
en transformant les lignes (elles sont repetees trois fois)
et miracle......
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; // 'phpmyadmin' - see scripts/create_tables.sql
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; // 'PMA_bookmark'
$cfg['Servers'][$i]['relation'] = 'pma_relation'; // 'PMA_relation'
$cfg['Servers'][$i]['table_info'] = 'pma_table_info'; // 'PMA_table_info'
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; // 'PMA_table_coords'
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; // 'PMA_pdf_pages'
$cfg['Servers'][$i]['column_info'] = 'pma_column_info'; // 'PMA_column_info'
$cfg['Servers'][$i]['history'] = 'pma_history'; // 'PMA_history'
#
# Base de données: `phpmyadmin`
#
# --------------------------------------------------------
#
# Structure de la table `pma_bookmark`
#
CREATE TABLE `pma_bookmark` (
`id` int(11) NOT NULL auto_increment,
`dbase` varchar(255) NOT NULL default '',
`user` varchar(255) NOT NULL default '',
`label` varchar(255) NOT NULL default '',
`query` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='Bookmarks' AUTO_INCREMENT=1 ;
#
# Contenu de la table `pma_bookmark`
#
# --------------------------------------------------------
#
# Structure de la table `pma_column_info`
#
CREATE TABLE `pma_column_info` (
`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 '',
`mimetype` varchar(255) NOT NULL default '',
`transformation` varchar(255) NOT NULL default '',
`transformation_options` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
) TYPE=MyISAM COMMENT='Comments for Columns' AUTO_INCREMENT=1 ;
#
# Contenu de la table `pma_column_info`
#
# --------------------------------------------------------
#
# Structure de la table `pma_history`
#
CREATE TABLE `pma_history` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`username` varchar(64) NOT NULL default '',
`db` varchar(64) NOT NULL default '',
`table` varchar(64) NOT NULL default '',
`timevalue` timestamp(14) NOT NULL,
`sqlquery` text NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`,`db`,`table`,`timevalue`)
) TYPE=MyISAM COMMENT='SQL history' AUTO_INCREMENT=1 ;
#
# Contenu de la table `pma_history`
#
# --------------------------------------------------------
#
# Structure de la table `pma_pdf_pages`
#
CREATE TABLE `pma_pdf_pages` (
`db_name` varchar(64) NOT NULL default '',
`page_nr` int(10) unsigned NOT NULL auto_increment,
`page_descr` varchar(50) NOT NULL default '',
PRIMARY KEY (`page_nr`),
KEY `db_name` (`db_name`)
) TYPE=MyISAM COMMENT='PDF Relationpages for PMA' AUTO_INCREMENT=4 ;
#
# Contenu de la table `pma_pdf_pages`
#
INSERT INTO `pma_pdf_pages` VALUES ('phpmyadmin', 1, 'essai');
INSERT INTO `pma_pdf_pages` VALUES ('notes', 3, 'esai');
# --------------------------------------------------------
#
# Structure de la table `pma_relation`
#
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';
#
# Contenu de la table `pma_relation`
#
# --------------------------------------------------------
#
# Structure de la table `pma_table_coords`
#
CREATE TABLE `pma_table_coords` (
`db_name` varchar(64) NOT NULL default '',
`table_name` varchar(64) NOT NULL default '',
`pdf_page_number` int(11) NOT NULL default '0',
`x` float unsigned NOT NULL default '0',
`y` float unsigned NOT NULL default '0',
PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`)
) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output';
#
# Contenu de la table `pma_table_coords`
#
# --------------------------------------------------------
#
# Structure de la table `pma_table_info`
#
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';
#
# Contenu de la table `pma_table_info`
#
|
|
|