[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r703 - trunk/transform/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r703 - trunk/transform/sql |
Date: |
Sat, 8 Feb 2014 14:49:01 +0100 (CET) |
Author: danydb
Date: 2014-02-08 14:49:01 +0100 (Sat, 08 Feb 2014)
New Revision: 703
Modified:
trunk/transform/sql/install.sql
Log:
Correct install script
Modified: trunk/transform/sql/install.sql
===================================================================
--- trunk/transform/sql/install.sql 2014-02-08 13:48:48 UTC (rev 702)
+++ trunk/transform/sql/install.sql 2014-02-08 13:49:01 UTC (rev 703)
@@ -1,6 +1,11 @@
-create schema transform;
+begin;
+create schema transform;
create table transform.request(
- r_id bigserial primary key
+ r_id bigserial primary key,
+ r_date date default now(),
+ r_type text,
+ r_start_date date ,
+ r_end_date date
);
create table transform.version(
v_id bigint primary key,
@@ -18,39 +23,34 @@
rp_city text,
rp_email text,
rp_phone text,
- rp_countrycode char(2) not null
+ rp_countrycode char(2) default null
);
create table transform.intervat_declarant
(
d_id bigserial primary key,
r_id bigint references transform.request(r_id) on update cascade on
delete cascade,
- d_name text,
- d_street text,
- d_postcode text,
- d_city text,
- d_email text,
- d_phone text,
- d_vat_number text,
+ d_name text not null,
+ d_street text not null,
+ d_postcode text not null,
+ d_city text not null,
+ d_email text not null,
+ d_phone text not null,
+ d_vat_number text not null,
d_countrycode char(2) not null,
- d_periode text
+ d_periode text not null
);
create table transform.intervat_client
(
c_id bigserial primary key,
d_id bigint references transform.intervat_declarant on update cascade
on delete cascade,
c_name text,
+ c_comment text,
c_vatnumber text,
- c_amount_vat text,
- c_amount_novat text,
+ c_amount_vat text default '0',
+ c_amount_novat text default '0',
c_issuedby char(2) default 'BE'
-)
+);
-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 ;
-ALTER TABLE transform.request ADD COLUMN r_start_date date;
-ALTER TABLE transform.request ADD COLUMN r_end_date date;
-alter table transform.intervat_client add column c_comment text;
-alter table transform.intervat_representative alter rp_countrycode drop not
null;
-
+insert into transform.version values(1,'Installation plugin');
+commit;
\ No newline at end of file
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r703 - trunk/transform/sql,
phpcompta-dev <=