PHP Classes

File: exemple.sql

Recommend this page to a friend!
  Classes of Pierre FAUQUE   Liste Class   exemple.sql   Download  
File: exemple.sql
Role: Auxiliary data
Content type: text/plain
Description: script to build the example tables
Class: Liste Class
Generate form select inputs from MySQL queries
Author: By
Last change:
Date: 18 years ago
Size: 5,511 bytes
 

Contents

Class file image Download
# Tables exemples pour tester la classe liste. # # NB: Tous les noms mentionnés dans la table cs_Adherents sont des noms fictifs. # Ils ont été inventés pour les besoins d'une base de donnée exemple servant # à l'apprentissage d'un SGBD : la gestion d'un club-sportif (tables cs_*). # Toute ressemblance avec... etc... serait fortuite :o) #----------------------------------------------------------- # Structure de la table `cs_Adherents` # drop table if exists cs_Adherents; create table cs_Adherents ( idadh int(11) not null auto_increment, nom varchar(25) not null default '', prenom varchar(35) default null, dnaiss date default '0000-00-00', adresse varchar(35) default null, cpostal varchar(5) default null, ville varchar(25) default null, tel varchar(14) default null, conjoint int(11) default null, profde int(11) default null, primary key (idadh) ) type=MyISAM comment='Table des adhérents'; # # Contenu de la table `cs_Adherents` # insert into cs_Adherents values ('1','DUPONT','Jean','1977-04-30','13 avenue Charles de Gaulle','94200','Maisons Alfort','01 45 36 29 99','0','1'), ('2','DUVAL','Henri','1979-04-21','53 rue des Gonesses','92120','Montrouge','01 66 52 89 03','0','0'), ('3','HOAREAU','Marianne','1951-08-27','10,rue de la gare','75010','Paris','01 55 21 32 67','21','5'), ('4','CHOTEAU','Bernadette','1950-06-12','47 Bd Durueil','92220','Bagneux','06 83 34 22 37','0','0'), ('5','ANQUEZ','Geneviève','1982-12-15','33,place Charles Gontier','75017','Paris','01 67 53 99 01','10','0'), ('6','DEVRIES','Annie','1983-07-16','3 bis rue de Denain','75009','Paris','01 45 74 20 81','0','0'), ('7','MOREAU','Chantal','1984-11-15','53 Quai Branly','75012','Paris','01 67 25 03 17','0','2'), ('8','BURET','Nicole','1955-03-16','12 avenue de Boulogne','75014','Paris','','0','0'), ('9','LEPIERRE','Paul','1955-02-18','14,rue des antilles','75020','Paris','06 45 23 88 17','11','0'), ('10','ANQUEZ','Marc','1981-01-07','33,place Charles Gontier','75017','Paris','01 67 53 99 01','5','2'), ('11','LEPIERRE','Rosie','1957-09-16','15,rue des antilles','75020','Paris','01 56 83 28 92','9','0'), ('12','GRONDIN','Joseph','1939-09-15','14,rue des Eglantines','92120','Montrouge','01 14 66 72 98','0','0'), ('13','PAYET','Joseph','1951-06-23','27 Bd Chenu','94410','Alfortville','06 38 84 25 07','0','0'), ('14','RAZAFINDRAKOTO','Jean','1968-05-26','178 rue des meuniers','75001','Paris','01 18 27 39 42','0','0'), ('15','CHENAUX','Emmanuelle','1948-03-16','13 avenue d\'Aubenas','75014','Paris','01 34 69 02 94','0','0'), ('16','FOURNIER','Denis','1966-10-16','156 rue du Fbg Saint-Antoine','75008','Paris','06 45 91 20 73','0','2'), ('17','MARCONI','Lucia','1941-02-18','97 rue de Rome','75018','Paris','','0','0'), ('18','BUZYNSKI','Georges','1955-04-26','127 Bd de Prague','75001','Paris','06 57 88 10 27','0','0'), ('19','DEVEMY','Gonzague','1983-01-19','18 Quai de la Seine','94200','Maisons Alfort','01 28 95 26 32','0','0'), ('20','CARPENTIER','Marc','1983-07-13','19 Bd de Waterloo','94210','Levallois','06 57 19 34 72','0','0'), ('21','DELAVAL','Pierre','1947-10-02','10,rue de la gare','75010','Paris','01 55 21 32 67','3','5'), ('22','DUCHATEAU','Guillaume','1974-07-18','47,rue de Dunkerque','75010','Paris','01 48 74 18 27','23','0'), ('23','CAO','Sue','1975-11-07','47,rue de Dunkerque','75010','Paris','01 48 74 18 27','22','0'), ('24','ROMBLEAU','Philippe','1972-05-17','18 bis rue de Rome','75018','Paris','','0','0'), ('25','CHINIARD','José','1985-12-14','17 avenue des accacias','75020','Paris','06 78 45 29 04','0','0'), ('26','DUCHMURTZ','Alain','1984-12-12','12 rue de la gare','75010','Paris','01 02 03 04 05','0','0'); #----------------------------------------------------------- # Structure de la table `cs_Cotisations` # drop table if exists cs_Cotisations; create table cs_Cotisations ( idcot int(11) not null auto_increment, libelle varchar(25) not null default '', montant decimal(6,2) not null default '0.00', obs varchar(30) default null, primary key (idcot) ) type=MyISAM comment='Table des cotisations'; # # Contenu de la table `cs_Cotisations` # insert into cs_Cotisations values ('1','Tarif normal','150.00','a/c 12/03/2001'), ('2','Tarif couple','130.00','a/c 30/04/2001'), ('3','Tarif jeune','120.00','a/c 30/04/2001'), ('4','Tarif vermeil','110.00','a/c 30/04/2001'); #----------------------------------------------------------- # Structure de la table `cs_Disciplines` # drop table if exists cs_Disciplines; create table cs_Disciplines ( iddisc int(11) not null auto_increment, libelle varchar(30) not null default '', licence decimal(6,2) not null default '0.00', unite varchar(20) not null default '', prix decimal(6,2) not null default '0.00', primary key (iddisc) ) type=MyISAM comment='Table des disciplines sportives'; # # Contenu de la table `cs_Disciplines` # insert into cs_Disciplines values ('1','Equitation','150.00','heure','15.00'), ('2','Tennis','110.00','heure','10.50'), ('3','Football','120.00','match','10.00'), ('4','Basket','85.00','match','10.00'), ('5','Escrime','150.00','heure','18.00'), ('6','Athlétisme','80.00','heure','12.50'), ('7','Musculation','80.00','heure','11.00'), ('8','chaise longue','150.00','heure','10.00'), ('9','Aviation','200.00','heure','50.00'), ('10','Tir à l\'arc','550.00','heure','10.00'), ('11','Natation','80.00','heure','10.00');