PHP Classes

File: sql_script.sql

Recommend this page to a friend!
  Classes of Ghali Ahmed   sqlExec   sql_script.sql   Download  
File: sql_script.sql
Role: Auxiliary data
Content type: text/plain
Description: Create the table to see exempleand dont forget to configure the config file
Class: sqlExec
Compose and execute common types of MySQL queries
Author: By
Last change: Change description
Date: 16 years ago
Size: 1,296 bytes
 

Contents

Class file image Download 
-- Base de données: `test`
-- 
CREATE DATABASE `test` ;
-- --------------------------------------------------------

-- 
-- 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, '');