#!/bin/sh

#information professionnelle dans travail_pour

ALTER TABLE travail_pour ADD COLUMN tel_pro text ;
ALTER TABLE travail_pour ADD COLUMN fax_pro text ;

INSERT INTO structchamp (ref_structtable, nom, denomination, rang, ref_type_edition) VALUES
	((SELECT uid FROM structtable WHERE nom='travail_pour'),
	'tel_pro', 'téléphone professionnel', 25, 11);

INSERT INTO structchamp (ref_structtable, nom, denomination, rang, ref_type_edition) VALUES
	((SELECT uid FROM structtable WHERE nom='travail_pour'),
	'fax_pro', 'fax professionnel', 26, 11);