Login   Register  
PHP Classes
elePHPant
Icontem

File: exemple.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 2005-10-10 17:06
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');