CodeIgniter Migration for Admin Areas (India)
Worldwide
I have an ERP/School Management System built with PHP and CodeIgniter. The application stores address information using normalized relational database tables with foreign key relationships rather than free-text location fields. The countries table has already been populated with approximately 192 countries, so no country data is required. I need a CodeIgniter migration (preferred) or a MySQL SQL seed/insert script that populates the lower administrative levels for India. Existing Database Structure The following tables already exist: countries (already populated) states districts sub_districts These tables are linked using numeric IDs and foreign key relationships. Administrative Hierarchy The hierarchy should follow India's official administrative structure as closely as possible. India State District Sub-district (Tehsil, Taluk, Taluka, Mandal, Block, or the most appropriate official equivalent) The goal is to maintain a consistent four-level hierarchy used throughout the application. Application Flow The address selection process works as follows: User selects a Country. System loads the available States. User selects a State. System loads the corresponding Districts. User selects a District. System loads the available Sub-districts. User enters Address Line 1, Address Line 2, and any additional address details. Only the IDs of these administrative areas are stored within the database. Deliverables Please provide either: A CodeIgniter migration file (preferred) OR A MySQL SQL insert/seed script The deliverable should include: Complete list of Indian States Complete list of Districts Complete list of Sub-districts Correct parent-child relationships Proper foreign key mapping No duplicate records Clean, organized, and maintainable code Requirements Use official government or other well-maintained administrative datasets. Ensure the data is complete, accurate, and up to date. Parent-child relationships must be correctly mapped. The migration or SQL script should run without modification in a standard CodeIgniter project. Please Include in Your Proposal Estimated delivery time Your experience with PHP, CodeIgniter, and MySQL The administrative data source you intend to use Any assumptions made where administrative naming conventions may vary
- Not SureHourly
- < 1 monthDuration
- ExpertExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:15 to 20
- Last viewed by client:yesterday
- Interviewing:5
- Invites sent:4
- Unanswered invites:2
About the client
- South Africa7:18 AM
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by