[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[4670] addons/1.3/colombia_general

Revision: 4670
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4670&view=rev
Author:   einhverfr
Date:     2012-04-24 06:58:03 +0000 (Tue, 24 Apr 2012)
Log Message:
-----------
Adding csv files for Colombia addon
moving schema change script ot the right place for same addon

Added Paths:
-----------
    addons/1.3/colombia_general/trunk/sql/
    addons/1.3/colombia_general/trunk/sql/csv/
    addons/1.3/colombia_general/trunk/sql/csv/city.csv
    addons/1.3/colombia_general/trunk/sql/csv/province.csv

Removed Paths:
-------------
    addons/1.3/colombia_general/sql/

Added: addons/1.3/colombia_general/trunk/sql/csv/city.csv
===================================================================
--- addons/1.3/colombia_general/trunk/sql/csv/city.csv	                        (rev 0)
+++ addons/1.3/colombia_general/trunk/sql/csv/city.csv	2012-04-24 06:58:03 UTC (rev 4670)
@@ -0,0 +1,556 @@
+05001,MEDELLÃN
+05002,ABEJORRAL
+05004,ABRIAQUÃ
+05021,ALEJANDRÃA
+05030,AMAGÃ
+05031,AMALFI
+05034,ANDES
+05036,ANGELÃPOLIS
+05038,ANGOSTURA
+05040,ANORÃ
+05042,SANTAFÃ DE ANTIOQUIA
+05044,ANZA
+05045,APARTADÃ
+05051,ARBOLETES
+05055,ARGELIA
+05059,ARMENIA
+05079,BARBOSA
+05086,BELMIRA
+05088,BELLO
+05091,BETANIA
+05093,BETULIA
+05101,CIUDAD BOLÃVAR
+05107,BRICEÃO
+05113,BURITICÃ
+05120,CÃCERES
+05125,CAICEDO
+05129,CALDAS
+05134,CAMPAMENTO
+05138,CAÃASGORDAS
+05142,CARACOLÃ
+05145,CARAMANTA
+05147,CAREPA
+05148,EL CARMEN DE VIBORAL
+05150,CAROLINA
+05154,CAUCASIA
+05172,CHIGORODÃ
+05190,CISNEROS
+05197,COCORNÃ
+05206,CONCEPCIÃN
+05209,CONCORDIA
+05212,COPACABANA
+05234,DABEIBA
+05237,DON MATÃAS
+05240,EBÃJICO
+05250,EL BAGRE
+05264,ENTRERRIOS
+05266,ENVIGADO
+05282,FREDONIA
+05284,FRONTINO
+05306,GIRALDO
+05308,GIRARDOTA
+05310,GÃMEZ PLATA
+05313,GRANADA
+05315,GUADALUPE
+05318,GUARNE
+05321,GUATAPE
+05347,HELICONIA
+05353,HISPANIA
+05360,ITAGUI
+05361,ITUANGO
+05364,JARDÃN
+05368,JERICÃ
+05376,LA CEJA
+05380,LA ESTRELLA
+05390,LA PINTADA
+05400,LA UNIÃN
+05411,LIBORINA
+05425,MACEO
+05440,MARINILLA
+05467,MONTEBELLO
+05475,MURINDÃ
+05480,MUTATÃ
+05483,NARIÃO
+05490,NECOCLÃ
+05495,NECHÃ
+05501,OLAYA
+05541,PEÃOL
+05543,PEQUE
+05576,PUEBLORRICO
+05579,PUERTO BERRÃO
+05585,PUERTO NARE
+05591,PUERTO TRIUNFO
+05604,REMEDIOS
+05607,RETIRO
+05615,RIONEGRO
+05628,SABANALARGA
+05631,SABANETA
+05642,SALGAR
+05647,SAN ANDRÃS DE CUERQUÃA
+05649,SAN CARLOS
+05652,SAN FRANCISCO
+05656,SAN JERÃNIMO
+05658,SAN JOSÃ DE LA MONTAÃA
+05659,SAN JUAN DE URABÃ
+05660,SAN LUIS
+05664,SAN PEDRO
+05665,SAN PEDRO DE URABA
+05667,SAN RAFAEL
+05670,SAN ROQUE
+05674,SAN VICENTE
+05679,SANTA BÃRBARA
+05686,SANTA ROSA DE OSOS
+05690,SANTO DOMINGO
+05697,EL SANTUARIO
+05736,SEGOVIA
+05756,SONSON
+05761,SOPETRÃN
+05789,TÃMESIS
+05790,TARAZÃ
+05792,TARSO
+05809,TITIRIBÃ
+05819,TOLEDO
+05837,TURBO
+05842,URAMITA
+05847,URRAO
+05854,VALDIVIA
+05856,VALPARAÃSO
+05858,VEGACHÃ
+05861,VENECIA
+05873,VIGÃA DEL FUERTE
+05885,YALÃ
+05887,YARUMAL
+05890,YOLOMBÃ
+05893,YONDÃ
+05895,ZARAGOZA
+08001,BARRANQUILLA
+08078,BARANOA
+08137,CAMPO DE LA CRUZ
+08141,CANDELARIA
+08296,GALAPA
+08372,JUAN DE ACOSTA
+08421,LURUACO
+08433,MALAMBO
+08436,MANATÃ
+08520,PALMAR DE VARELA
+08549,PIOJÃ
+08558,POLONUEVO
+08560,PONEDERA
+08573,PUERTO COLOMBIA
+08606,REPELÃN
+08634,SABANAGRANDE
+08638,SABANALARGA
+08675,SANTA LUCÃA
+08685,SANTO TOMÃS
+08758,SOLEDAD
+08770,SUAN
+08832,TUBARÃ
+08849,USIACURÃ
+11001,"BOGOTÃ, D.C."
+13001,CARTAGENA
+13006,ACHÃ
+13030,ALTOS DEL ROSARIO
+13042,ARENAL
+13052,ARJONA
+13062,ARROYOHONDO
+13074,BARRANCO DE LOBA
+13140,CALAMAR
+13160,CANTAGALLO
+13188,CICUCO
+13212,CÃRDOBA
+13222,CLEMENCIA
+13244,EL CARMEN DE BOLÃVAR
+13248,EL GUAMO
+13268,EL PEÃÃN
+13300,HATILLO DE LOBA
+13430,MAGANGUÃ
+13433,MAHATES
+13440,MARGARITA
+13442,MARÃA LA BAJA
+13458,MONTECRISTO
+13468,MOMPÃS
+13473,MORALES
+13549,PINILLOS
+13580,REGIDOR
+13600,RÃO VIEJO
+13620,SAN CRISTÃBAL
+13647,SAN ESTANISLAO
+13650,SAN FERNANDO
+13654,SAN JACINTO
+13655,SAN JACINTO DEL CAUCA
+13657,SAN JUAN NEPOMUCENO
+13667,SAN MARTÃN DE LOBA
+13670,SAN PABLO
+13673,SANTA CATALINA
+13683,SANTA ROSA
+13688,SANTA ROSA DEL SUR
+13744,SIMITÃ
+13760,SOPLAVIENTO
+13780,TALAIGUA NUEVO
+13810,TIQUISIO
+13836,TURBACO
+13838,TURBANÃ
+13873,VILLANUEVA
+13894,ZAMBRANO
+15001,TUNJA
+15022,ALMEIDA
+15047,AQUITANIA
+15051,ARCABUCO
+15087,BELÃN
+15090,BERBEO
+15092,BETÃITIVA
+15097,BOAVITA
+15104,BOYACÃ
+15106,BRICEÃO
+15109,BUENAVISTA
+15114,BUSBANZÃ
+15131,CALDAS
+15135,CAMPOHERMOSO
+15162,CERINZA
+15172,CHINAVITA
+15176,CHIQUINQUIRÃ
+15180,CHISCAS
+15183,CHITA
+15185,CHITARAQUE
+15187,CHIVATÃ
+15189,CIÃNEGA
+15204,CÃMBITA
+15212,COPER
+15215,CORRALES
+15218,COVARACHÃA
+15223,CUBARÃ
+15224,CUCAITA
+15226,CUÃTIVA
+15232,CHÃQUIZA
+15236,CHIVOR
+15238,DUITAMA
+15244,EL COCUY
+15248,EL6aSPINO
+15272,FIRAVITOBA
+15276,FLORESTA
+15293,GACHANTIVÃ
+15296,GAMEZA
+15299,GARAGOA
+15317,GUACAMAYAS
+15322,GUATEQUE
+15325,GUAYATÃ
+15332,GÃICÃN
+15362,IZA
+15367,JENESANO
+15368,JERICÃ
+15377,LABRANZAGRANDE
+15380,LA CAPILLA
+15401,LA VICTORIA
+15403,LA UVITA
+15407,VILLA DE LEYVA
+15425,MACANAL
+15442,MARIPÃ
+15455,MIRAFLORES
+15464,MONGUA
+15466,MONGUÃ
+15469,MONIQUIRÃ
+15476,MOTAVITA
+15480,MUZO
+15491,NOBSA
+15494,NUEVO COLÃN
+15500,OICATÃ
+15507,OTANCHE
+15511,PACHAVITA
+15514,PÃEZ
+15516,PAIPA
+15518,PAJARITO
+15522,PANQUEBA
+15531,PAUNA
+15533,PAYA
+15537,PAZ DE RÃO
+15542,PESCA
+15550,PISBA
+15572,PUERTO BOYACÃ
+15580,QUÃPAMA
+15599,RAMIRIQUÃ
+15600,RÃQUIRA
+15621,RONDÃN
+15632,SABOYÃ
+15638,SÃCHICA
+15646,SAMACÃ
+15660,SAN EDUARDO
+15664,SAN JOSÃ DE PARE
+15667,SAN LUIS DE GACENO
+15673,SAN MATEO
+15676,SAN MIGUEL DE SEMA
+15681,SAN PABLO DE BORBUR
+15686,SANTANA
+15690,SANTA MARÃA
+15693,SANTA ROSA DE VITERBO
+15696,SANTA SOFÃA
+15720,SATIVANORTE
+15723,SATIVASUR
+15740,SIACHOQUE
+15753,SOATÃ
+15755,SOCOTÃ
+15757,SOCHA
+15759,SOGAMOSO
+15761,SOMONDOCO
+15762,SORA
+15763,SOTAQUIRÃ
+15764,SORACÃ
+15774,SUSACÃN
+15776,SUTAMARCHÃN
+15778,SUTATENZA
+15790,TASCO
+15798,TENZA
+15804,TIBANÃ
+15806,TIBASOSA
+15808,TINJACÃ
+15810,TIPACOQUE
+15814,TOCA
+15816,TOGÃÃ
+15820,TÃPAGA
+15822,TOTA
+15832,TUNUNGUÃ
+15835,TURMEQUÃ
+15837,TUTA
+15839,TUTAZÃ
+15842,UMBITA
+15861,VENTAQUEMADA
+15879,VIRACACHÃ
+15897,ZETAQUIRA
+17001,MANIZALES
+17013,AGUADAS
+17042,ANSERMA
+17050,ARANZAZU
+17088,BELALCÃZAR
+17174,CHINCHINÃ
+17272,FILADELFIA
+17380,LA DORADA
+17388,LA MERCED
+17433,MANZANARES
+17442,MARMATO
+17444,MARQUETALIA
+17446,MARULANDA
+17486,NEIRA
+17495,NORCASIA
+17513,PÃCORA
+17524,PALESTINA
+17541,PENSILVANIA
+17614,RIOSUCIO
+17616,RISARALDA
+17653,SALAMINA
+17662,SAMANÃ
+17665,SAN JOSÃ
+17777,SUPÃA
+17867,VICTORIA
+17873,VILLAMARÃA
+17877,VITERBO
+18001,FLORENCIA
+18029,ALBANIA
+18094,BELÃN DE LOS ANDAQUIES
+18150,CARTAGENA DEL CHAIRÃ
+18205,CURILLO
+18247,EL DONCELLO
+18256,EL PAUJIL
+18410,LA MONTAÃITA
+18460,MILÃN
+18479,MORELIA
+18592,PUERTO RICO
+18610,SAN JOSÃ DEL FRAGUA
+18753,SAN VICENTE DEL CAGUÃN
+18756,SOLANO
+18785,SOLITA
+18860,VALPARAÃSO
+19001,POPAYÃN
+19022,ALMAGUER
+19050,ARGELIA
+19075,BALBOA
+19100,BOLÃVAR
+19110,BUENOS AIRES
+19130,CAJIBÃO
+19137,CALDONO
+19142,CALOTO
+19212,CORINTO
+19256,EL TAMBO
+19290,FLORENCIA
+19300,GUACHENÃ
+19318,GUAPI
+19355,INZÃ
+19364,JAMBALÃ
+19392,LA SIERRA
+19397,LA VEGA
+19418,LÃPEZ
+19450,MERCADERES
+19455,MIRANDA
+19473,MORALES
+19513,PADILLA
+19517,PAEZ
+19532,PATÃA
+19533,PIAMONTE
+19548,PIENDAMÃ
+19573,PUERTO TEJADA
+19585,PURACÃ
+19622,ROSAS
+19693,SAN SEBASTIÃN
+19698,SANTANDER DE QUILICHAO
+19701,SANTA ROSA
+19743,SILVIA
+19760,SOTARA
+19780,SUÃREZ
+19785,SUCRE
+19807,TIMBÃO
+19809,TIMBIQUÃ
+19821,TORIBIO
+19824,TOTORÃ
+19845,VILLA RICA
+20001,VALLEDUPAR
+20011,AGUACHICA
+20013,AGUSTÃN CODAZZI
+20032,ASTREA
+20045,BECERRIL
+20060,BOSCONIA
+20175,CHIMICHAGUA
+20178,CHIRIGUANÃ
+20228,CURUMANÃ
+20238,EL COPEY
+20250,EL PASO
+20295,GAMARRA
+20310,GONZÃLEZ
+20383,LA GLORIA
+20400,LA JAGUA DE IBIRICO
+20443,MANAURE
+20517,PAILITAS
+20550,PELAYA
+20570,PUEBLO BELLO
+20614,RÃO DE ORO
+20621,LA PAZ
+20710,SAN ALBERTO
+20750,SAN DIEGO
+20770,SAN MARTÃN
+20787,TAMALAMEQUE
+23001,MONTERÃA
+23068,AYAPEL
+23079,BUENAVISTA
+23090,CANALETE
+23162,CERETÃ
+23168,CHIMÃ
+23182,CHINÃ
+23189,CIÃNAGA DE ORO
+23300,COTORRA
+23350,LA APARTADA
+23417,LORICA
+23419,LOS CÃRDOBAS
+23464,MOMIL
+23466,MONTELÃBANO
+23500,MOÃITOS
+23555,PLANETA RICA
+23570,PUEBLO NUEVO
+23574,PUERTO ESCONDIDO
+23580,PUERTO LIBERTADOR
+23586,PURÃSIMA
+23660,SAHAGÃN
+23670,SAN ANDRÃS SOTAVENTO
+23672,SAN ANTERO
+23675,SAN BERNARDO DEL VIENTO
+23678,SAN CARLOS
+23686,SAN PELAYO
+23807,TIERRALTA
+23855,VALENCIA
+25001,AGUA DE DIOS
+25019,ALBÃN
+25035,ANAPOIMA
+25040,ANOLAIMA
+25053,ARBELÃEZ
+25086,BELTRÃN
+25095,BITUIMA
+25099,BOJACÃ
+25120,CABRERA
+25123,CACHIPAY
+25126,CAJICÃ
+25148,CAPARRAPÃ
+25151,CAQUEZA
+25154,CARMEN DE CARUPA
+25168,CHAGUANÃ
+25175,CHÃA
+25178,CHIPAQUE
+25181,CHOACHÃ
+25183,CHOCONTÃ
+25200,COGUA
+25214,COTA
+25224,CUCUNUBÃ
+25245,EL COLEGIO
+25258,EL PEÃÃN
+25260,EL ROSAL
+25269,FACATATIVÃ
+25279,FOMEQUE
+25281,FOSCA
+25286,FUNZA
+25288,FÃQUENE
+25290,FUSAGASUGÃ
+25293,GACHALA
+25295,GACHANCIPÃ
+25297,GACHETÃ
+25299,GAMA
+25307,GIRARDOT
+25312,GRANADA
+25317,GUACHETÃ
+25320,GUADUAS
+25322,GUASCA
+25324,GUATAQUÃ
+25326,GUATAVITA
+25328,GUAYABAL DE SIQUIMA
+25335,GUAYABETAL
+25339,GUTIÃRREZ
+25368,JERUSALÃN
+25372,JUNÃN
+25377,LA CALERA
+25386,LA MESA
+25394,LA PALMA
+25398,LA PEÃA
+25402,LA VEGA
+25407,LENGUAZAQUE
+25426,MACHETA
+25430,MADRID
+25436,MANTA
+25438,MEDINA
+25473,MOSQUERA
+25483,NARIÃO
+25486,NEMOCÃN
+25488,NILO
+25489,NIMAIMA
+25491,NOCAIMA
+25506,VENECIA
+25513,PACHO
+25518,PAIME
+25524,PANDI
+25530,PARATEBUENO
+25535,PASCA
+25572,PUERTO SALGAR
+25580,PULÃ
+25592,QUEBRADANEGRA
+25594,QUETAME
+25596,QUIPILE
+25599,APULO
+25612,RICAURTE
+25645,SAN ANTONIO DEL TEQUENDAMA
+25649,SAN BERNARDO
+25653,SAN CAYETANO
+25658,SAN FRANCISCO
+25662,SAN JUAN DE RÃO SECO
+25718,SASAIMA
+25736,SESQUILÃ
+25740,SIBATÃ
+25743,SILVANIA
+25745,SIMIJACA
+25754,SOACHA
+25758,SOPÃ
+25769,SUBACHOQUE
+25772,SUESCA
+25777,SUPATÃ
+25779,SUSA
+25781,SUTATAUSA
+25785,TABIO
+25793,TAUSA
+25797,TENA
+25799,TENJO
+25805,TIBACUY
+25807,TIBIRITA
+25815,TOCAIMA
+25817,TOCANCIPÃ
\ No newline at end of file

Added: addons/1.3/colombia_general/trunk/sql/csv/province.csv
===================================================================
--- addons/1.3/colombia_general/trunk/sql/csv/province.csv	                        (rev 0)
+++ addons/1.3/colombia_general/trunk/sql/csv/province.csv	2012-04-24 06:58:03 UTC (rev 4670)
@@ -0,0 +1,33 @@
+Amazonas,91
+Antioquia,05
+Arauca,81
+AtlÃntico,08
+Bogotà D.C.,11
+BolÃvar,13
+BoyacÃ,15
+Caldas,17
+CaquetÃ,18
+Casanare,85
+Cauca,19
+Cesar,20
+ChocÃ,27
+CÃrdoba,23
+Cundinamarca,25
+GuainÃa,94
+Guaviare,95
+Huila,41
+La Guajira,44
+Magdalena,47
+Meta,50
+NariÃo,52
+Norte de Santander,54
+Putumayo,86
+QuindÃo,63
+Risaralda,66
+San AndrÃs,88
+Santander,68
+Sucre,70
+Tolima,73
+Valle del Cauca,76
+VaupÃs,97
+Vichada,99
\ No newline at end of file

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.