Deux pour mysql (j'ai séparé adh et cotis suite à une merde pour l'import) l'autre pour postgresql, en un seul morceau.
A+, Loïs -- <GruiicK> Un esprit malsaint, dans un porcin. -+- #linuxfr / ircnet -+-
INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(6, 4, 'BOND', 'James', 'shaker', 1, '1952-01-15', 'MI6', '', '00564', 'Londres', '', '', '', 'james.bond@xxxxxxxxxxxxxx', '', '', '', '', '', '', 'Agent secret', 'james', 'qxn1w6g', '2002-06-12', '1', '', '', '', '2004-06-11'); INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(10, 4, 'DE MESMAEKER', 'Aimé', 'contrats', 1, '1955-12-22', '42 boulevard des Alouettes', '', '45002', 'Niors', '', '', '', '', '', '', '', '', 'Pas cool', '', 'signeurs de contrats', 'aime', 'yrh5j2x', '2003-01-25', '1', '', '', '', '2005-01-24'); INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(2, 4, 'RUI', 'gick', 'gruiick', 1, '1969-12-20', '42, rue du savapalathet', '', '69002', 'Lyon', '', '', '', 'gruiick@xxxxxxxxxxxxx', '', '', '', '', '', '', 'imbécile', 'gruiick', 'gruiick', '1999-01-25', '1', '', '', '', '2005-01-29'); INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(11, 4, 'Longtarin', 'Joseph', '', 1, '1935-12-19', '22 boulevard des Parc-Mètres', '', '75001', 'Ballast', '', '', '', '', '', '', '', '', '', '', 'brigadier de Police', 'joseph.longtarin', 'c5pnsdc', '2003-11-14', '1', '', '', '', '2004-11-13'); INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(1, 4, 'LESPAMMEUR', 'Bob', '.i.', 1, '1973-01-25', '25 rue de la bite en bois', '', '69001', 'Lyon', '', '', '', 'bob@xxxxxxxxxxxxxx', 'http://www.lespammeur.com/', '', '', '', '', '', 'spammeur', 'bobo', 'toto', '2004-01-25', '1', '', '', '', '2005-01-24'); INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(7, 4, 'JEANNE', 'Mademoiselle', 'mamzelle_jeanne', 3, '1975-04-22', '22 boulevard des coeurs', '', '75005', 'PARIS', '', '', '', 'mademoiselle.jeanne@xxxxxxxxx', '', '', '', '', '', '', 'secrétaire de direction', 'jeanne', 'w03mxdy', '2003-07-07', '1', '', '', '', '2004-07-06'); INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(12, 4, 'GIRL', 'La', 'littlered', 3, '1943-02-26', '12 rue du Petit Chaperon Rouge', '', '69006', 'WildWolfy', '', '', '', 'la.girl@xxxxxxxxxxxxx', '', '', '', '', '', '', 'Danseuse', 'la.girl', 'qyq0j34', '2002-02-14', '1', '', '', '', '2004-02-14'); INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(8, 4, 'TEMPLAR', 'Simon', 'le_saint', 1, '1962-02-09', 'Cottage de la Sainte-Survie', '', '32001', 'Bougnis', '', '', '', 'simon.templar@xxxxxxxxxxx', '', '', '', '', '', '', 'mercenaire', 'lesaint', 'w5vw5eb', '1999-07-22', '1', '', '', '', '2004-07-30'); INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(15, 4, 'Zorglub', '', '', 1, NULL, 'Tout pres de chez vous', '', '89765', 'Bartabac', '', '', '', '', '', '', '', '', '', '', '', 'Zorglub', 'uxe9jdh', '2004-01-26', '1', '', '', '', '2003-02-27'); INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(3, 1, 'NEMARD', 'Jean', 'jn_69', 1, '1969-12-31', '8 rue des Lurons gays', '', '69069', 'Latex', '', '69 69 69 69 69', '', '', '', '', '', '', 'Yeeah!', '', 'sans', 'jn69', 'jn69', '2002-11-26', '1', '', '1', '', NULL); INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(9, 4, 'total', 'stereo', 'totalpop', 3, '2000-01-01', 'allée des cactus', '', '666667', 'popville', '', '100200300', 'msg', 'tar@xxxxxxxx', '', 'jabber?', 'jabber?', '', 'mais non tout est rouge dans w3m', '', 'disque joqueytte', 'cactus', 'flocks', '2004-01-25', '1', '', '', '', '2005-01-24'); INSERT INTO `adherents` (`id_adh`, `id_statut`, `nom_adh`, `prenom_adh`, `pseudo_adh`, `titre_adh`, `ddn_adh`, `adresse_adh`, `adresse2_adh`, `cp_adh`, `ville_adh`, `pays_adh`, `tel_adh`, `gsm_adh`, `email_adh`, `url_adh`, `icq_adh`, `msn_adh`, `jabber_adh`, `info_adh`, `info_public_adh`, `prof_adh`, `login_adh`, `mdp_adh`, `date_crea_adh`, `activite_adh`, `bool_admin_adh`, `bool_exempt_adh`, `bool_display_info`, `date_echeance`) VALUES(5, 7, 'Démonstration', 'Alexandre', 'Belgacom', 3, '1969-05-01', 'Appt 102', '', '69234', 'ST-GENISSE-LES OEILLÈRES', '', '', '', '', '', '', '', '', 'C\'est pas malin de mettre ses vraies données perso dans un site de démo...', '', '', 'ALEX', 'ALEX', '2003-04-20', '0', '', '', '', '2004-04-19');
INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(1, 1, 1, 25, '', 12, '2004-01-25'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(5, 5, 1, 250, '', 12, '2003-04-20'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(7, 6, 1, 25, '', 12, '2003-06-12'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(8, 7, 1, 25, '', 12, '2003-07-07'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(9, 8, 1, 10, '', 12, '1999-07-22'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(10, 8, 1, 25, '', 12, '2000-06-22'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(11, 8, 1, 25, '', 12, '2001-07-12'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(12, 8, 1, 10, '', 12, '2002-07-31'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(13, 8, 1, 25, '', 12, '2003-06-25'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(14, 9, 1, 7, 'n non vraiment tous les champs sont en rouge.^M ^M C'est à cause des fraises pour toujours. non?', 12, '2004-01-25'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(16, 10, 1, 25, '', 12, '2003-01-25'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(17, 10, 1, 25, '', 12, '2004-01-25'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(18, 11, 1, 25, '', 12, '2003-11-14'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(19, 12, 1, 25, '', 12, '2002-02-14'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(20, 12, 1, 25, '', 12, '2003-02-14'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(2, 2, 1, 35, '', 12, '2004-01-25'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(24, 15, 2, 0.2, '', 1, '2003-01-27'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(25, 3, 1, 25, '', 12, '2002-11-26'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(26, 2, 1, 25, '', 12, '1999-01-25'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(27, 2, 1, 25, '', 12, '2000-01-30'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(28, 2, 1, 25, '', 12, '2001-01-25'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(29, 2, 1, 25, '', 12, '2002-01-20'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(30, 2, 1, 25, '', 12, '2003-01-25'); INSERT INTO `cotisations` (`id_cotis`, `id_adh`, `id_type_cotis`, `montant_cotis`, `info_cotis`, `duree_mois_cotis`, `date_cotis`) VALUES(6, 6, 1, 25, '', 12, '2002-06-12');
/* -------------------------------------------------------- phpPgAdmin 2.2.1 DB Dump http://www.greatbridge.org/project/phppgadmin/ Host: localhost:5432 Database : galette-demo 2004-16-02 19:02:32 -------------------------------------------------------- */ /* -------------------------------------------------------- Sequences -------------------------------------------------------- */ CREATE SEQUENCE "adherents_id_seq" start 15 increment 1 maxvalue 2147483647 minvalue 1 cache 1; SELECT NEXTVAL('adherents_id_seq'); CREATE SEQUENCE "cotisations_id_seq" start 30 increment 1 maxvalue 2147483647 minvalue 1 cache 1; SELECT NEXTVAL('cotisations_id_seq'); CREATE SEQUENCE "logs_id_seq" start 33 increment 1 maxvalue 2147483647 minvalue 1 cache 1; SELECT NEXTVAL('logs_id_seq'); /* -------------------------------------------------------- Table structure for table "adherents" -------------------------------------------------------- */ CREATE TABLE "adherents" ( "id_adh" int4 DEFAULT nextval('adherents_id_seq'::text) NOT NULL, "id_statut" int4 DEFAULT '4' NOT NULL, "nom_adh" varchar(20) DEFAULT '' NOT NULL, "prenom_adh" varchar(20), "pseudo_adh" varchar(20), "titre_adh" int2 DEFAULT '0' NOT NULL, "ddn_adh" date, "adresse_adh" varchar(150) DEFAULT '' NOT NULL, "adresse2_adh" varchar(150), "cp_adh" varchar(10) DEFAULT '' NOT NULL, "ville_adh" varchar(50) DEFAULT '' NOT NULL, "pays_adh" varchar(50), "tel_adh" varchar(20), "gsm_adh" varchar(20), "email_adh" varchar(150), "url_adh" varchar(200), "icq_adh" varchar(20), "msn_adh" varchar(150), "jabber_adh" varchar(150), "info_adh" text, "info_public_adh" text, "prof_adh" varchar(150), "login_adh" varchar(20) DEFAULT '' NOT NULL, "mdp_adh" varchar(20) DEFAULT '' NOT NULL, "date_crea_adh" date NOT NULL, "activite_adh" char(1) DEFAULT '0' NOT NULL, "bool_admin_adh" char(1), "bool_exempt_adh" char(1), "bool_display_info" char(1), "date_echeance" date ); /* -------------------------------------------------------- Dumping data for table "adherents" -------------------------------------------------------- */ INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(6, 4, 'BOND', 'James', 'shaker', 1, '1952-01-15', 'MI6', '', '00564', 'Londres', '', '', '', 'james.bond@xxxxxxxxxxxxxx', '', '', '', '', '', '', 'Agent secret', 'james', 'qxn1w6g', '2002-06-12', '1', '', '', '', '2004-06-11'); INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(10, 4, 'DE MESMAEKER', 'Aimé', 'contrats', 1, '1955-12-22', '42 boulevard des Alouettes', '', '45002', 'Niors', '', '', '', '', '', '', '', '', 'Pas cool', '', 'signeurs de contrats', 'aime', 'yrh5j2x', '2003-01-25', '1', '', '', '', '2005-01-24'); INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(2, 4, 'RUI', 'gick', 'gruiick', 1, '1969-12-20', '42, rue du savapalathet', '', '69002', 'Lyon', '', '', '', 'gruiick@xxxxxxxxxxxxx', '', '', '', '', '', '', 'imbécile', 'gruiick', 'gruiick', '1999-01-25', '1', '', '', '', '2005-01-29'); INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(11, 4, 'Longtarin', 'Joseph', '', 1, '1935-12-19', '22 boulevard des Parc-Mètres', '', '75001', 'Ballast', '', '', '', '', '', '', '', '', '', '', 'brigadier de Police', 'joseph.longtarin', 'c5pnsdc', '2003-11-14', '1', '', '', '', '2004-11-13'); INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(1, 4, 'LESPAMMEUR', 'Bob', '.i.', 1, '1973-01-25', '25 rue de la bite en bois', '', '69001', 'Lyon', '', '', '', 'bob@xxxxxxxxxxxxxx', 'http://www.lespammeur.com/', '', '', '', '', '', 'spammeur', 'bobo', 'toto', '2004-01-25', '1', '', '', '', '2005-01-24'); INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(7, 4, 'JEANNE', 'Mademoiselle', 'mamzelle_jeanne', 3, '1975-04-22', '22 boulevard des coeurs', '', '75005', 'PARIS', '', '', '', 'mademoiselle.jeanne@xxxxxxxxx', '', '', '', '', '', '', 'secrétaire de direction', 'jeanne', 'w03mxdy', '2003-07-07', '1', '', '', '', '2004-07-06'); INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(12, 4, 'GIRL', 'La', 'littlered', 3, '1943-02-26', '12 rue du Petit Chaperon Rouge', '', '69006', 'WildWolfy', '', '', '', 'la.girl@xxxxxxxxxxxxx', '', '', '', '', '', '', 'Danseuse', 'la.girl', 'qyq0j34', '2002-02-14', '1', '', '', '', '2004-02-14'); INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(8, 4, 'TEMPLAR', 'Simon', 'le_saint', 1, '1962-02-09', 'Cottage de la Sainte-Survie', '', '32001', 'Bougnis', '', '', '', 'simon.templar@xxxxxxxxxxx', '', '', '', '', '', '', 'mercenaire', 'lesaint', 'w5vw5eb', '1999-07-22', '1', '', '', '', '2004-07-30'); INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(15, 4, 'Zorglub', '', '', 1, NULL, 'Tout pres de chez vous', '', '89765', 'Bartabac', '', '', '', '', '', '', '', '', '', '', '', 'Zorglub', 'uxe9jdh', '2004-01-26', '1', '', '', '', '2003-02-27'); INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(3, 1, 'NEMARD', 'Jean', 'jn_69', 1, '1969-12-31', '8 rue des Lurons gays', '', '69069', 'Latex', '', '69 69 69 69 69', '', '', '', '', '', '', 'Yeeah!', '', 'sans', 'jn69', 'jn69', '2002-11-26', '1', '', '1', '', NULL); INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(9, 4, 'total', 'stereo', 'totalpop', 3, '2000-01-01', 'allée des cactus', '', '666667', 'popville', '', '100200300', 'msg', 'tar@xxxxxxxx', '', 'jabber?', 'jabber?', '', 'mais non tout est rouge dans w3m', '', 'disque joqueytte', 'cactus', 'flocks', '2004-01-25', '1', '', '', '', '2005-01-24'); INSERT INTO "adherents" ("id_adh", "id_statut", "nom_adh", "prenom_adh", "pseudo_adh", "titre_adh", "ddn_adh", "adresse_adh", "adresse2_adh", "cp_adh", "ville_adh", "pays_adh", "tel_adh", "gsm_adh", "email_adh", "url_adh", "icq_adh", "msn_adh", "jabber_adh", "info_adh", "info_public_adh", "prof_adh", "login_adh", "mdp_adh", "date_crea_adh", "activite_adh", "bool_admin_adh", "bool_exempt_adh", "bool_display_info", "date_echeance") VALUES(5, 7, 'Démonstration', 'Alexandre', 'Belgacom', 3, '1969-05-01', 'Appt 102', '', '69234', 'ST-GENISSE-LES OEILLÈRES', '', '', '', '', '', '', '', '', 'C\'est pas malin de mettre ses vraies données perso dans un site de démo...', '', '', 'ALEX', 'ALEX', '2003-04-20', '0', '', '', '', '2004-04-19'); /* -------------------------------------------------------- Table structure for table "cotisations" -------------------------------------------------------- */ CREATE TABLE "cotisations" ( "id_cotis" int4 DEFAULT nextval('cotisations_id_seq'::text) NOT NULL, "id_adh" int4 DEFAULT '0' NOT NULL, "id_type_cotis" int4 DEFAULT '0' NOT NULL, "montant_cotis" float8 DEFAULT '0', "info_cotis" text, "duree_mois_cotis" int2 DEFAULT '12' NOT NULL, "date_cotis" date NOT NULL ); /* -------------------------------------------------------- Dumping data for table "cotisations" -------------------------------------------------------- */ INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(1, 1, 1, 25, '', 12, '2004-01-25'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(5, 5, 1, 250, '', 12, '2003-04-20'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(7, 6, 1, 25, '', 12, '2003-06-12'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(8, 7, 1, 25, '', 12, '2003-07-07'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(9, 8, 1, 10, '', 12, '1999-07-22'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(10, 8, 1, 25, '', 12, '2000-06-22'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(11, 8, 1, 25, '', 12, '2001-07-12'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(12, 8, 1, 10, '', 12, '2002-07-31'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(13, 8, 1, 25, '', 12, '2003-06-25'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(14, 9, 1, 7, 'n non vraiment tous les champs sont en rouge.^M ^M C'est à cause des fraises pour toujours. non?', 12, '2004-01-25'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(16, 10, 1, 25, '', 12, '2003-01-25'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(17, 10, 1, 25, '', 12, '2004-01-25'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(18, 11, 1, 25, '', 12, '2003-11-14'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(19, 12, 1, 25, '', 12, '2002-02-14'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(20, 12, 1, 25, '', 12, '2003-02-14'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(2, 2, 1, 35, '', 12, '2004-01-25'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(24, 15, 2, 0.2, '', 1, '2003-01-27'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(25, 3, 1, 25, '', 12, '2002-11-26'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(26, 2, 1, 25, '', 12, '1999-01-25'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(27, 2, 1, 25, '', 12, '2000-01-30'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(28, 2, 1, 25, '', 12, '2001-01-25'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(29, 2, 1, 25, '', 12, '2002-01-20'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(30, 2, 1, 25, '', 12, '2003-01-25'); INSERT INTO "cotisations" ("id_cotis", "id_adh", "id_type_cotis", "montant_cotis", "info_cotis", "duree_mois_cotis", "date_cotis") VALUES(6, 6, 1, 25, '', 12, '2002-06-12'); /* -------------------------------------------------------- Table structure for table "logs" -------------------------------------------------------- */ CREATE TABLE "logs" ( "id_log" int4 DEFAULT nextval('logs_id_seq'::text) NOT NULL, "date_log" timestamp NOT NULL, "ip_log" varchar(30) DEFAULT '' NOT NULL, "adh_log" varchar(41) DEFAULT '' NOT NULL, "text_log" text ); /* -------------------------------------------------------- Dumping data for table "logs" -------------------------------------------------------- */ INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(1, '2004-02-15 14:40:43+01', '80.14.222.212', 'Administrateur', 'Mise à jour de la fiche adhérent : TOTAL stereo'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(2, '2004-02-15 14:46:19+01', '80.14.222.212', 'Administrateur', 'Suppression d\'une contribution : LIGHT Dee'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(3, '2004-02-15 14:46:48+01', '80.14.222.212', 'Administrateur', 'Suppression d\'une contribution : APAPA Barnabé'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(4, '2004-02-15 14:48:06+01', '82.67.51.148', 'Administrateur', 'Identification'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(5, '2004-02-15 14:49:25+01', '80.14.222.212', 'Administrateur', 'Mise à jour de la fiche adhérent : APAPA Barnabé'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(6, '2004-02-15 14:49:37+01', '80.14.222.212', 'Administrateur', 'Suppression de la fiche adhérent (et cotisations) : APAPA Barnabé'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(7, '2004-02-15 14:50:48+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : BOND James'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(8, '2004-02-15 14:50:57+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : BOND James'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(9, '2004-02-15 14:51:24+01', '82.67.51.148', 'Administrateur', 'Mise à jour d\'une contribution : BOND James'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(10, '2004-02-15 14:53:23+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : DE MESMAEKER Aimé'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(11, '2004-02-15 14:55:04+01', '82.67.51.148', 'Administrateur', 'Suppression de la fiche adhérent (et cotisations) : LIGHT Dee'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(12, '2004-02-15 14:55:31+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : SALEM Mathieu'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(13, '2004-02-15 14:55:37+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : RUI gick'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(14, '2004-02-15 14:55:38+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : NEMARD Jean'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(15, '2004-02-15 14:55:39+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : LONGTARIN Joseph'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(16, '2004-02-15 14:55:42+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : LIGHT Dee'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(17, '2004-02-15 14:55:45+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : LESPAMMEUR Bob'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(18, '2004-02-15 14:55:48+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : JEANNE Mademoiselle'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(19, '2004-02-15 14:55:51+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : GIRL La'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(20, '2004-02-15 14:56:42+01', '82.67.51.148', 'Administrateur', 'Suppression de la fiche adhérent (et cotisations) : SALEM Mathieu'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(21, '2004-02-15 14:57:12+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : TEMPLAR Simon'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(22, '2004-02-15 14:58:30+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : ZORGLUB '); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(23, '2004-02-15 14:58:35+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : TOTAL stereo'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(24, '2004-02-15 14:58:41+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : NEMARD Jean'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(25, '2004-02-15 15:01:39+01', '82.67.51.148', 'Administrateur', 'Déconnexion'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(26, '2004-02-15 16:50:38+01', '80.14.222.212', 'Administrateur', 'Mise à jour de la fiche adhérent : DÉMONSTRATION Alexandre'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(27, '2004-02-15 17:33:55+01', '80.14.222.212', 'Administrateur', 'Envoi d\'un mailing intitulé : \"toto\" - 7 destinataires'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(28, '2004-02-15 17:35:31+01', '80.14.222.212', 'Administrateur', 'Mise à jour des préférences'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(29, '2004-02-15 17:35:45+01', '80.14.222.212', 'Administrateur', 'Déconnexion'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(30, '2004-02-15 21:19:06+01', '82.67.51.148', 'Administrateur', 'Identification'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(31, '2004-02-15 21:19:33+01', '82.67.51.148', 'Administrateur', 'Suppression d\'une contribution : TOTAL stereo'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(32, '2004-02-15 21:24:23+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : DÉMONSTRATION Alexandre'); INSERT INTO "logs" ("id_log", "date_log", "ip_log", "adh_log", "text_log") VALUES(33, '2004-02-15 21:24:48+01', '82.67.51.148', 'Administrateur', 'Mise à jour de la fiche adhérent : DÉMONSTRATION Alexandre'); /* -------------------------------------------------------- Table structure for table "preferences" -------------------------------------------------------- */ CREATE TABLE "preferences" ( "pref_nom" varchar(40) DEFAULT '' NOT NULL, "pref_adresse" varchar(150) DEFAULT '' NOT NULL, "pref_adresse2" varchar(150), "pref_cp" varchar(10) DEFAULT '' NOT NULL, "pref_ville" varchar(50) DEFAULT '' NOT NULL, "pref_pays" varchar(50), "pref_lang" varchar(20) DEFAULT '' NOT NULL, "pref_numrows" int4 DEFAULT '30' NOT NULL, "pref_log" char(1) DEFAULT '1' NOT NULL, "pref_email_nom" varchar(20) DEFAULT '' NOT NULL, "pref_email" varchar(150) DEFAULT '' NOT NULL, "pref_etiq_marges" int4 DEFAULT '0' NOT NULL, "pref_etiq_hspace" int4 DEFAULT '0' NOT NULL, "pref_etiq_vspace" int4 DEFAULT '0' NOT NULL, "pref_etiq_hsize" int4 DEFAULT '0' NOT NULL, "pref_etiq_vsize" int4 DEFAULT '0' NOT NULL, "pref_etiq_cols" int4 DEFAULT '0' NOT NULL, "pref_etiq_rows" int4 DEFAULT '0' NOT NULL, "pref_etiq_corps" int4 DEFAULT '0' NOT NULL, "pref_admin_login" varchar(20) DEFAULT '' NOT NULL, "pref_admin_pass" varchar(20) DEFAULT '' NOT NULL ); /* -------------------------------------------------------- Dumping data for table "preferences" -------------------------------------------------------- */ INSERT INTO "preferences" ("pref_nom", "pref_adresse", "pref_adresse2", "pref_cp", "pref_ville", "pref_pays", "pref_lang", "pref_numrows", "pref_log", "pref_email_nom", "pref_email", "pref_etiq_marges", "pref_etiq_hspace", "pref_etiq_vspace", "pref_etiq_hsize", "pref_etiq_vsize", "pref_etiq_cols", "pref_etiq_rows", "pref_etiq_corps", "pref_admin_login", "pref_admin_pass") VALUES('Galette', '-', '', '-', '-', '', 'french', 30, '1', 'Galette', 'demo@xxxxxxxxx', 10, 10, 5, 90, 35, 2, 7, 12, 'adminweb', 'adminweb'); /* -------------------------------------------------------- Table structure for table "statuts" -------------------------------------------------------- */ CREATE TABLE "statuts" ( "id_statut" int4 NOT NULL, "libelle_statut" varchar(20) DEFAULT '' NOT NULL, "priorite_statut" int2 DEFAULT '0' NOT NULL ); /* -------------------------------------------------------- Dumping data for table "statuts" -------------------------------------------------------- */ INSERT INTO "statuts" ("id_statut", "libelle_statut", "priorite_statut") VALUES(1, 'Président', 0); INSERT INTO "statuts" ("id_statut", "libelle_statut", "priorite_statut") VALUES(2, 'Trésorier', 10); INSERT INTO "statuts" ("id_statut", "libelle_statut", "priorite_statut") VALUES(4, 'Membre actif', 30); INSERT INTO "statuts" ("id_statut", "libelle_statut", "priorite_statut") VALUES(5, 'Membre bienfaiteur', 40); INSERT INTO "statuts" ("id_statut", "libelle_statut", "priorite_statut") VALUES(6, 'Membre fondateur', 50); INSERT INTO "statuts" ("id_statut", "libelle_statut", "priorite_statut") VALUES(3, 'Secrétaire', 20); INSERT INTO "statuts" ("id_statut", "libelle_statut", "priorite_statut") VALUES(7, 'Ancien', 60); INSERT INTO "statuts" ("id_statut", "libelle_statut", "priorite_statut") VALUES(8, 'Personne morale', 70); INSERT INTO "statuts" ("id_statut", "libelle_statut", "priorite_statut") VALUES(9, 'Non membre', 80); INSERT INTO "statuts" ("id_statut", "libelle_statut", "priorite_statut") VALUES(10, 'Vice-président', 5); /* -------------------------------------------------------- Table structure for table "types_cotisation" -------------------------------------------------------- */ CREATE TABLE "types_cotisation" ( "id_type_cotis" int4 NOT NULL, "libelle_type_cotis" varchar(30) DEFAULT '' NOT NULL ); /* -------------------------------------------------------- Dumping data for table "types_cotisation" -------------------------------------------------------- */ INSERT INTO "types_cotisation" ("id_type_cotis", "libelle_type_cotis") VALUES(1, 'Cotisation annuelle normale'); INSERT INTO "types_cotisation" ("id_type_cotis", "libelle_type_cotis") VALUES(2, 'Cotisation annuelle réduite'); INSERT INTO "types_cotisation" ("id_type_cotis", "libelle_type_cotis") VALUES(3, 'Cotisation entreprise'); INSERT INTO "types_cotisation" ("id_type_cotis", "libelle_type_cotis") VALUES(4, 'Donation en nature'); INSERT INTO "types_cotisation" ("id_type_cotis", "libelle_type_cotis") VALUES(5, 'Donation pécunière'); INSERT INTO "types_cotisation" ("id_type_cotis", "libelle_type_cotis") VALUES(6, 'Partenariat'); /* No Views found */ /* No Triggers found */ /* No Functions found */
Generated by mhonarc 2.6.8, Sat Feb 21 15:00:16 2004