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
_______________________________________________
Phpcompta est un logiciel libre de comptabilité en ligne
(http://www.phpcompta.eu)
Phpcompta-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
