[Phpcompta-dev] r683 - trunk/transform/sql

[phpcompta-dev]

Author: danydb
Date: 2014-02-01 16:17:43 +0100 (Sat, 01 Feb 2014)
New Revision: 683

Modified:
   trunk/transform/sql/install.sql
Log:
add column r_type to table request

Modified: trunk/transform/sql/install.sql
===================================================================
--- trunk/transform/sql/install.sql     2014-02-01 15:17:14 UTC (rev 682)
+++ trunk/transform/sql/install.sql     2014-02-01 15:17:43 UTC (rev 683)
@@ -1,9 +1,7 @@
-create schema transform;
-
+create schema transform;
 create table transform.request(
-       r_id bigserial primary key,
-        r_date timestamp default now()
-);
+       r_id bigserial primary key
+       );
 create table transform.version(
        v_id bigint primary key,
        v_note text);
@@ -13,7 +11,7 @@
        r_id bigint references transform.request(r_id) on update cascade on 
delete cascade,
        rp_listing_id text,
        rp_issued text,
-       rp_type text
+       rp_type text,
        rp_name text,
        rp_street text,
        rp_postcode text,
@@ -46,4 +44,9 @@
        c_amount_vat text,
        c_amount_novat text,
        c_issuedby char(2) default 'BE'
-);
\ No newline at end of file
+)
+
+alter table transform.request add         r_date date
+alter table transform.request alter r_date set default now()
+alter table transform.request add         r_type text 
+



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu