--
-- Structure de la table `llx_prelevementpf_bank`
--
DROP TABLE IF EXISTS `llx_prelevementpf_bank`;
CREATE TABLE `llx_prelevementpf_bank` (
  `rowid` int(11) NOT NULL,
  `code` varchar(5) NOT NULL,
  `name` varchar(64) NOT NULL,
  `shortname` varchar(8) NOT NULL,
  `address` varchar(64) NOT NULL,
  `pobox` varchar(16) NOT NULL,
  `zipcode` varchar(5) NOT NULL,
  `town` varchar(32) NOT NULL,
  `fk_prelevementbank` int(11) 
);
--
-- Contenu de la table `llx_prelevementpf_bank`
--
INSERT INTO `llx_prelevementpf_bank` (`rowid`, `code`, `name`, `shortname`, `address`, `pobox`, `zipcode`, `town`, `fk_prelevementbank`) VALUES
(1, '12239', 'Banque de Tahiti', 'BT', '38, rue François Cardella', '1602', '98713', 'Papeete', 1),
(2, '12149', 'Banque de Polynésie', 'BP', '355, boulevard Pomare', '530', '98713', 'Papeete', 2),
(3, '17469', 'Banque Socredo', 'SOC', "115, rue Dumont d'Urville", '130', '98713', 'Papeete', 3),
(4, '14168', 'Centre de Chèques Postaux', 'CCP', '8, rue de la Reine Pomare IV', '605', '98713', 'Papeete', 2);
--
-- Index pour la table `llx_prelevementpf_bank`
--
ALTER TABLE `llx_prelevementpf_bank`
  ADD PRIMARY KEY (`rowid`);
--
-- AUTO_INCREMENT pour la table `llx_prelevementpf_bank`
--
ALTER TABLE `llx_prelevementpf_bank`
  MODIFY `rowid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
