Galette

(problème de formatage, commentaire ré-édité ci-dessous)

--- pgsql.sql.orig      2012-10-08 10:38:53.984523421 +0200
+++ pgsql.sql   2012-10-08 10:49:53.466259233 +0200
@@ -85,6 +85,15 @@
     CACHE 1;

 -- Schema
+-- REMINDER: Create order IS important, dependencies first !!
+DROP TABLE IF EXISTS galette_statuts CASCADE;
+CREATE TABLE galette_statuts (
+  id_statut integer DEFAULT nextval('galette_statuts_id_seq'::text) NOT NULL,
+  libelle_statut  character varying(20) DEFAULT '' NOT NULL,
+  priorite_statut smallint DEFAULT '0' NOT NULL,
+  PRIMARY KEY (id_statut)
+);
+
 DROP TABLE IF EXISTS galette_adherents CASCADE;
 CREATE TABLE galette_adherents (
     id_adh integer DEFAULT nextval('galette_adherents_id_seq'::text) NOT NULL,
@@ -128,6 +137,24 @@
 -- add index for faster search on login_adh (auth)
 CREATE UNIQUE INDEX galette_adherents_login_adh_idx ON galette_adherents (login_adh);

+DROP TABLE IF EXISTS galette_types_cotisation CASCADE;
+CREATE TABLE galette_types_cotisation (
+  id_type_cotis integer DEFAULT nextval('galette_types_cotisation_id_seq'::text) NOT NULL,
+  libelle_type_cotis character varying(30) DEFAULT '' NOT NULL,
+  cotis_extension boolean DEFAULT FALSE,
+  PRIMARY KEY (id_type_cotis)
+);
+
+DROP TABLE IF EXISTS galette_transactions CASCADE;
+CREATE TABLE galette_transactions (
+    trans_id integer DEFAULT nextval('galette_transactions_id_seq'::text)  NOT NULL,
+    trans_date date DEFAULT '19010101' NOT NULL,
+    trans_amount real DEFAULT '0',
+    trans_desc character varying(150) NOT NULL DEFAULT '',
+    id_adh integer REFERENCES galette_adherents (id_adh) ON DELETE RESTRICT ON UPDATE CASCADE,
+    PRIMARY KEY (trans_id)
+);
+
 DROP TABLE IF EXISTS galette_cotisations;
 CREATE TABLE galette_cotisations (
     id_cotis integer DEFAULT nextval('galette_cotisations_id_seq'::text)  NOT NULL,
@@ -143,32 +170,6 @@
     PRIMARY KEY (id_cotis)
 );

-DROP TABLE IF EXISTS galette_transactions CASCADE;
-CREATE TABLE galette_transactions (
-    trans_id integer DEFAULT nextval('galette_transactions_id_seq'::text)  NOT NULL,
-    trans_date date DEFAULT '19010101' NOT NULL,
-    trans_amount real DEFAULT '0',
-    trans_desc character varying(150) NOT NULL DEFAULT '',
-    id_adh integer REFERENCES galette_adherents (id_adh) ON DELETE RESTRICT ON UPDATE CASCADE,
-    PRIMARY KEY (trans_id)
-);
-
-DROP TABLE IF EXISTS galette_statuts;
-CREATE TABLE galette_statuts (
-  id_statut integer DEFAULT nextval('galette_statuts_id_seq'::text) NOT NULL,
-  libelle_statut  character varying(20) DEFAULT '' NOT NULL,
-  priorite_statut smallint DEFAULT '0' NOT NULL,
-  PRIMARY KEY (id_statut)
-);
-
-DROP TABLE IF EXISTS galette_types_cotisation CASCADE;
-CREATE TABLE galette_types_cotisation (
-  id_type_cotis integer DEFAULT nextval('galette_types_cotisation_id_seq'::text) NOT NULL,
-  libelle_type_cotis character varying(30) DEFAULT '' NOT NULL,
-  cotis_extension boolean DEFAULT FALSE,
-  PRIMARY KEY (id_type_cotis)
-);
-
 DROP TABLE IF EXISTS galette_preferences;
 CREATE TABLE galette_preferences (
   id_pref integer DEFAULT nextval('galette_preferences_id_seq'::text) NOT NULL,

Loïs Taulelle a écrit :

1. Problème d'ordre dans les commandes SQL
   voir patch joint.

1. la page de connexion/création attends un résultat qui ne vient apparement jamais (postgresql-server 8.4.13)

à la page "Vérification de la base" de l'installeur, j'obtiens :

"Fatal error: Call to a member function getCode() on a non-object in /var/www/galette/lib/Galette/Core/Db.php on line 247"

Les tables et les séquences ont bien été crées.