Commit | Line | Data |
---|---|---|
cc9dc1dd | 1 | DROP TABLE IF EXISTS payment_bankaccounts; |
f56ceafe DB |
2 | CREATE TABLE payment_bankaccounts ( |
3 | id integer PRIMARY KEY auto_increment, | |
4 | asso_id integer NOT NULL, | |
5 | account varchar(23) NOT NULL, | |
6 | owner varchar(100) NOT NULL, | |
7 | status set('new','used','old') NOT NULL default 'new' | |
aaec4238 | 8 | ) ENGINE=InnoDB, CHARSET=utf8; |
f56ceafe DB |
9 | |
10 | #INSERT INTO payment_bankaccounts VALUES (NULL,,"30002004690000008524R29","Amis de l'Espace Dirigea","used"); | |
11 | INSERT INTO payment_bankaccounts VALUES (NULL,239,"10207001172019602580784","ASCCX","used"); | |
12 | INSERT INTO payment_bankaccounts VALUES (NULL,42,"14707000010892101692291","AX (BPLC)","used"); | |
13 | INSERT INTO payment_bankaccounts VALUES (NULL,42,"30066109310001022770164","AX (CIC)","used"); | |
14 | INSERT INTO payment_bankaccounts VALUES (NULL,42,"30002004200000009372U74","AX (LCL)","used"); | |
15 | INSERT INTO payment_bankaccounts VALUES (NULL,31,"10107001820002105034095","Binet Point Gamma","used"); | |
16 | INSERT INTO payment_bankaccounts VALUES (NULL,73,"30003020600003729601589","GTX","used"); | |
17 | INSERT INTO payment_bankaccounts VALUES (NULL,246,"20041000012241609M02035","Humanix - Jacques Bellev","used"); | |
aaec4238 FB |
18 | #INSERT INTO payment_bankaccounts VALUES (NULL,,"10107001820092105033751","Kes des élèves","used"); |
19 | INSERT INTO payment_bankaccounts VALUES (NULL,214,"30003022160005198020072","Khomiss (Aurélien Lajoie","used"); | |
f56ceafe DB |
20 | #INSERT INTO payment_bankaccounts VALUES (NULL,,"30003021900002011521283","Maison des X","used"); |
21 | INSERT INTO payment_bankaccounts VALUES (NULL,181,"10107001820012105055968","Raid Polytechnique 2004","used"); | |
22 | INSERT INTO payment_bankaccounts VALUES (NULL,165,"20041010123576371A03369","Sabix","used"); | |
23 | INSERT INTO payment_bankaccounts VALUES (NULL,11,"30002089410000023857R03","X-eConfiance 'Mathieu Be","used"); | |
24 | INSERT INTO payment_bankaccounts VALUES (NULL,251,"30003022200005041343575","X-Achats 'Francois Rena","used"); | |
25 | INSERT INTO payment_bankaccounts VALUES (NULL,252,"30002008190000045217G86","X-Automobile 'F. Tronel","used"); | |
26 | INSERT INTO payment_bankaccounts VALUES (NULL,6,"30002005940000434521B52","X-Aviation 'Francis Fouq","used"); | |
27 | INSERT INTO payment_bankaccounts VALUES (NULL,96,"30003041110003726598647","X-Biotech (M.O.Bevierre)","used"); | |
28 | INSERT INTO payment_bankaccounts VALUES (NULL,57,"15589335720697076254012","X-Bordelais (T Leblond)","used"); | |
29 | INSERT INTO payment_bankaccounts VALUES (NULL,4,"30003005080003728293253","X-Consult","used"); | |
30 | INSERT INTO payment_bankaccounts VALUES (NULL,18,"30066100210001067980188","X-Environnement (P Worbe","used"); | |
31 | INSERT INTO payment_bankaccounts VALUES (NULL,3,"30003031900005066357935","X-Finance - Ariane Chaze","used"); | |
32 | INSERT INTO payment_bankaccounts VALUES (NULL,7,"30002004200000009372U74","X-Gaziers - Compte AX LC","used"); | |
33 | INSERT INTO payment_bankaccounts VALUES (NULL,21,"30588610978071800010189","X-Golf (Guy Marchand)","used"); | |
34 | INSERT INTO payment_bankaccounts VALUES (NULL,202,"30003034210005003887246","X-HEC CapInvest (A Santo","used"); | |
35 | INSERT INTO payment_bankaccounts VALUES (NULL,174,"30002006840000005831S15","X-Mer","used"); | |
36 | INSERT INTO payment_bankaccounts VALUES (NULL,166,"30066108700001028630170","X-Mines au Feminin","used"); | |
37 | INSERT INTO payment_bankaccounts VALUES (NULL,219,"30002004200000009372U74","X-Nucleaire - Compte AX","used"); | |
38 | INSERT INTO payment_bankaccounts VALUES (NULL,82,"30003038320005055982303","X-Pierre (Quoc-Giao Tran","used"); | |
39 | INSERT INTO payment_bankaccounts VALUES (NULL,233,"30002004200000009372U74","X-PI - Compte AX LCL","used"); | |
40 | INSERT INTO payment_bankaccounts VALUES (NULL,248,"12548029983443030151039","X-Renouvelables 'Jerome","used"); | |
41 | INSERT INTO payment_bankaccounts VALUES (NULL,179,"30066106410001050600128","X-Sursaut H Levy-Lambert","used"); | |
42 | INSERT INTO payment_bankaccounts VALUES (NULL,223,"30066100410001126780124","X-Theatre","used"); | |
43 | ||
cc9dc1dd | 44 | DROP TABLE IF EXISTS payment_reconcilations; |
f56ceafe DB |
45 | CREATE TABLE payment_reconcilations ( |
46 | id INTEGER PRIMARY KEY auto_increment, | |
47 | method_id INTEGER NOT NULL, | |
48 | period_start DATE NOT NULL, | |
49 | period_end DATE NOT NULL, | |
77b81d91 | 50 | recongroup_id INTEGER DEFAULT NULL, |
f56ceafe DB |
51 | status ENUM('pending','transfering','closed') NOT NULL DEFAULT 'pending', |
52 | payment_count INTEGER NOT NULL, | |
53 | sum_amounts DECIMAL(9,2) NOT NULL, # transaction amount, before taking the commission | |
54 | sum_commissions DECIMAL(9,2) NOT NULL, | |
55 | comments text NOT NULL | |
aaec4238 | 56 | ) ENGINE=InnoDB, CHARSET=utf8; |
f56ceafe | 57 | |
cc9dc1dd | 58 | DROP TABLE IF EXISTS payment_transfers; |
f56ceafe | 59 | CREATE TABLE payment_transfers ( |
77b81d91 DB |
60 | id INTEGER PRIMARY KEY auto_increment, |
61 | recongroup_id INTEGER NOT NULL, | |
62 | payment_id INTEGER NOT NULL, | |
f56ceafe | 63 | amount DECIMAL(9,2) NOT NULL, |
77b81d91 | 64 | account_id INTEGER DEFAULT NULL, |
f56ceafe | 65 | message VARCHAR(255) NOT NULL, |
77b81d91 | 66 | date DATE DEFAULT NULL # NULL = not done |
aaec4238 | 67 | ) ENGINE=InnoDB, CHARSET=utf8; |
f56ceafe | 68 | |
77b81d91 DB |
69 | ALTER TABLE payment_methods ADD short_name VARCHAR(10) NOT NULL; |
70 | ALTER TABLE payment_methods ADD flags SET('deferred_com') DEFAULT ''; | |
71 | UPDATE payment_methods SET short_name='paypal', flags='' WHERE id=1; | |
72 | UPDATE payment_methods SET short_name='bplc2', flags='deferred_com' WHERE id=2; | |
454e7b4a FB |
73 | |
74 | -- vim:set syntax=mysql: | |
77b81d91 | 75 |