File manager - Edit - /home/custbahd/cornerstoneassetmanagers.com/application-forms/submit/sql.sql
Back
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: May 16, 2024 at 06:04 PM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `cornerstone` -- -- -------------------------------------------------------- -- -- Table structure for table `fund_investment` -- CREATE TABLE `fund_investment` ( `id` int(11) NOT NULL, `code` text NOT NULL, `cat` text NOT NULL, `surname1` text NOT NULL, `surname2` text NOT NULL, `surname3` text NOT NULL, `othername1` text NOT NULL, `othername2` text NOT NULL, `othername3` text NOT NULL, `dob1` date NOT NULL, `dob2` date NOT NULL, `dob3` date NOT NULL, `passport1` text NOT NULL, `passport2` text NOT NULL, `passport3` text NOT NULL, `nin1` text NOT NULL, `nin2` text NOT NULL, `nin3` text NOT NULL, `nationality1` text NOT NULL, `nationality2` text NOT NULL, `nationality3` text NOT NULL, `residence1` text NOT NULL, `residence2` text NOT NULL, `residence3` text NOT NULL, `email1` text NOT NULL, `email2` text NOT NULL, `email3` text NOT NULL, `po_box1` text NOT NULL, `po_box2` text NOT NULL, `po_box3` text NOT NULL, `emp_status1` text NOT NULL, `emp_status2` text NOT NULL, `emp_status3` text NOT NULL, `employer1` text NOT NULL, `employer2` text NOT NULL, `employer3` text NOT NULL, `occupation1` text NOT NULL, `occupation2` text NOT NULL, `occupation3` text NOT NULL, `industry1` text NOT NULL, `industry2` text NOT NULL, `industry3` text NOT NULL, `tin1` text NOT NULL, `tin2` text NOT NULL, `tin3` text NOT NULL, `phone1` text NOT NULL, `phone2` text NOT NULL, `phone3` text NOT NULL, `house1` text NOT NULL, `house2` text NOT NULL, `house3` text NOT NULL, `road1` text NOT NULL, `road2` text NOT NULL, `road3` text NOT NULL, `city1` text NOT NULL, `city2` text NOT NULL, `city3` text NOT NULL, `auth_sign` text NOT NULL, `e_name` text NOT NULL, `e_phone` text NOT NULL, `e_relations` text NOT NULL, `source_funds` text NOT NULL, `source_funds_specify` text NOT NULL, `bank_name` text NOT NULL, `bank_branch` text NOT NULL, `ac_name` text NOT NULL, `ac_number` text NOT NULL, `auth_sign1` text NOT NULL, `auth_sign2` text NOT NULL, `auth_sign3` text NOT NULL, `ug_fund` text NOT NULL, `us_fund` text NOT NULL, `org_name` text NOT NULL, `org_reg_no` text NOT NULL, `org_tin_no` text NOT NULL, `org_inc_date` date NOT NULL, `org_reg_country` text NOT NULL, `org_business_nature` text NOT NULL, `org_email` text NOT NULL, `org_po_box` text NOT NULL, `org_industry` text NOT NULL, `org_building_floor` text NOT NULL, `org_city` text NOT NULL, `org_road` text NOT NULL, `org_contact_person` text NOT NULL, `org_mobile` text NOT NULL, `risk1` text NOT NULL, `risk2` text NOT NULL, `risk3` text NOT NULL, `risk4` text NOT NULL, `risk5` text NOT NULL, `risk6` text NOT NULL, `risk7` text NOT NULL, `confirm_name` text NOT NULL, `confirm_signature` text NOT NULL, `final_name1` text NOT NULL, `final_name2` text NOT NULL, `final_name3` text NOT NULL, `final_signature1` text NOT NULL, `final_signature2` text NOT NULL, `final_signature3` text NOT NULL, `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `fund_investment` -- ALTER TABLE `fund_investment` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `fund_investment` -- ALTER TABLE `fund_investment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 1.33 |
proxy
|
phpinfo
|
Settings