[Phpcompta-dev] r267 - trunk/coprop/sql

[phpcompta-dev]

Author: danydb
Date: 2012-01-07 23:44:15 +0100 (Sat, 07 Jan 2012)
New Revision: 267

Added:
   trunk/coprop/sql/create_view_summary.sql
Removed:
   trunk/coprop/sql/create_view_summary.sql.sql
Log:
fix name

Copied: trunk/coprop/sql/create_view_summary.sql (from rev 266, 
trunk/coprop/sql/create_view_summary.sql.sql)
===================================================================
--- trunk/coprop/sql/create_view_summary.sql                            (rev 0)
+++ trunk/coprop/sql/create_view_summary.sql    2012-01-07 22:44:15 UTC (rev 
267)
@@ -0,0 +1,11 @@
+CREATE OR REPLACE VIEW coprop.summary AS
+ SELECT a.f_id AS lot_id, m.ad_value AS building_id, c.ad_value AS coprop_id
+   FROM fiche_detail a
+   JOIN fiche f1 ON f1.f_id = a.f_id
+   JOIN ( SELECT fd1.f_id, fd1.ad_value
+      FROM fiche_detail fd1
+     WHERE fd1.ad_id = 70) m ON m.f_id = a.f_id
+   JOIN ( SELECT fd1.f_id, fd1.ad_value
+   FROM fiche_detail fd1
+  WHERE fd1.ad_id = 71) c ON c.f_id = a.f_id
+  WHERE f1.fd_id = 8 AND a.ad_id = 1;
\ No newline at end of file

Deleted: trunk/coprop/sql/create_view_summary.sql.sql
===================================================================
--- trunk/coprop/sql/create_view_summary.sql.sql        2012-01-07 22:42:05 UTC 
(rev 266)
+++ trunk/coprop/sql/create_view_summary.sql.sql        2012-01-07 22:44:15 UTC 
(rev 267)
@@ -1,11 +0,0 @@
-CREATE OR REPLACE VIEW coprop.summary AS
- SELECT a.f_id AS lot_id, m.ad_value AS building_id, c.ad_value AS coprop_id
-   FROM fiche_detail a
-   JOIN fiche f1 ON f1.f_id = a.f_id
-   JOIN ( SELECT fd1.f_id, fd1.ad_value
-      FROM fiche_detail fd1
-     WHERE fd1.ad_id = 70) m ON m.f_id = a.f_id
-   JOIN ( SELECT fd1.f_id, fd1.ad_value
-   FROM fiche_detail fd1
-  WHERE fd1.ad_id = 71) c ON c.f_id = a.f_id
-  WHERE f1.fd_id = 8 AND a.ad_id = 1;
\ No newline at end of file