PHP Classes

File: conf/create_table.sql

Recommend this page to a friend!
  Classes of Ghali Ahmed   DG   conf/create_table.sql   Download  
File: conf/create_table.sql
Role: Auxiliary data
Content type: text/plain
Description: Create table named "utilisateurs" to test the exemple dont forget to chage the config data with your connexion parametre
Class: DG
Display database query results in HTML tables
Author: By
Last change:
Date: 16 years ago
Size: 1,173 bytes
 

Contents

Class file image Download 
-- 
-- Structure de la table `utilisateurs`
-- 

CREATE TABLE `utilisateurs` (
  `identifiant` int(11) NOT NULL auto_increment,
  `nom` varchar(32) default NULL,
  `prenom` varchar(32) default NULL,
  `login` varchar(16) default NULL,
  `passwd` varchar(255) default NULL,
  `actif` int(11) default NULL,
  `niveau_user` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`identifiant`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- 
-- Contenu de la table `utilisateurs`
-- 

INSERT INTO `utilisateurs` (`identifiant`, `nom`, `prenom`, `login`, `passwd`, `actif`, `niveau_user`) VALUES 
(7, 'yamen', 'yamen2', 'Yoyo2', 'eca2bd22b72e095cbc32fd6c17893692', 1, ''),
(8, 'yamen2', 'yamen2', 'Yoyo2', 'eca2bd22b72e095cbc32fd6c17893692', 1, ''),
(9, 'yamen2', 'yamen2', 'Yoyo2', 'eca2bd22b72e095cbc32fd6c17893692', 1, ''),
(10, 'yamen2', 'yamen2', 'Yoyo2', 'eca2bd22b72e095cbc32fd6c17893692', 1, ''),
(11, 'yamen2', 'yamen2', 'Yoyo2', 'eca2bd22b72e095cbc32fd6c17893692', 1, ''),
(12, 'yamen2', 'yamen2', 'Yoyo2', 'eca2bd22b72e095cbc32fd6c17893692', 1, ''),
(13, 'yamen2', 'yamen2', 'Yoyo2', 'eca2bd22b72e095cbc32fd6c17893692', 1, '');