99 lines
12 KiB
SQL
Executable File
99 lines
12 KiB
SQL
Executable File
CREATE TABLE db.Staffappchild(id BIGINT NOT NULL AUTO_INCREMENT, status VARCHAR(400), full_name VARCHAR(400), note VARCHAR(400), nationality VARCHAR(400), coupon VARCHAR(400), supllier VARCHAR(400), visa VARCHAR(400), application_code VARCHAR(400), phone_number VARCHAR(400), email_field VARCHAR(400), supplier_acknowledged VARCHAR(400), entry_date Date, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Pending_customer(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), application_code VARCHAR(400), nationality VARCHAR(400), onetomanyextension VARCHAR(400), passport_number int, filter_btn VARCHAR(400), reset_btn VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Staff_application(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), filter_btn VARCHAR(400), nationality VARCHAR(400), onetomanyextension VARCHAR(400), passport_number int, application_code VARCHAR(400), reset_btn VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Pending_customer_child(id BIGINT NOT NULL AUTO_INCREMENT, phone_number VARCHAR(400), note VARCHAR(400), supplier_acknowledged VARCHAR(400), full_name VARCHAR(400), application_code VARCHAR(400), coupon VARCHAR(400), email_id VARCHAR(400), visa VARCHAR(400), supplier VARCHAR(400), nationality VARCHAR(400), status VARCHAR(400), entry_date Date, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Pending_agent_child(id BIGINT NOT NULL AUTO_INCREMENT, agent VARCHAR(400), full_name VARCHAR(400), supplier_acknowledged VARCHAR(400), phone_number VARCHAR(400), note VARCHAR(400), nationality VARCHAR(400), email_id VARCHAR(400), visa VARCHAR(400), supplier VARCHAR(400), application_code VARCHAR(400), action VARCHAR(400), entry_date Date, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Pending_agent(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), application_code VARCHAR(400), onetomanyextension VARCHAR(400), passport_number int, filter_btn VARCHAR(400), reset_btn VARCHAR(400), nationality VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Processing_customer_child(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), status VARCHAR(400), phone_number VARCHAR(400), note VARCHAR(400), supplier_acknowledged VARCHAR(400), application_code VARCHAR(400), coupon VARCHAR(400), email_id VARCHAR(400), visa VARCHAR(400), supplier VARCHAR(400), entry_date Date, nationality VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Processing_customer(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), nationality VARCHAR(400), onetomanyextension VARCHAR(400), application_code VARCHAR(400), passport_number int, filter_btn VARCHAR(400), reset_btn VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Processing_agent(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), application_code VARCHAR(400), onetomanyextension VARCHAR(400), passport_number int, filter_btn VARCHAR(400), reset_btn VARCHAR(400), nationality VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Processing_agent_child(id BIGINT NOT NULL AUTO_INCREMENT, agent VARCHAR(400), phone_number VARCHAR(400), note VARCHAR(400), supplier_acknowledged VARCHAR(400), application_code VARCHAR(400), nationality VARCHAR(400), email_id VARCHAR(400), visa VARCHAR(400), supplier VARCHAR(400), entry_date Date, name VARCHAR(400), status VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Refund_child(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), status VARCHAR(400), phone_number VARCHAR(400), note VARCHAR(400), supplier_acknowledged VARCHAR(400), application_code VARCHAR(400), nationality VARCHAR(400), email_id VARCHAR(400), visa VARCHAR(400), supplier VARCHAR(400), transction_id int, entry_date Date, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Refund(id BIGINT NOT NULL AUTO_INCREMENT, application_code VARCHAR(400), onetomanyextension VARCHAR(400), filter_btn int, reset_btn VARCHAR(400), nationality VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Rejected_child(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), status VARCHAR(400), supplier_acknowledged VARCHAR(400), action VARCHAR(400), email_id VARCHAR(400), phone VARCHAR(400), note VARCHAR(400), application_code VARCHAR(400), visa VARCHAR(400), supplier VARCHAR(400), entry_date Date, nationality VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Rejected(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), application_code VARCHAR(400), onetomanyextension VARCHAR(400), passport_number int, filter_btn VARCHAR(400), reset_btn VARCHAR(400), nationality VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Completed_or_archive_child(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), status VARCHAR(400), agent VARCHAR(400), phone_number VARCHAR(400), note VARCHAR(400), supplier_acknowledged VARCHAR(400), application_code VARCHAR(400), coupon VARCHAR(400), email_id VARCHAR(400), visa VARCHAR(400), supplier VARCHAR(400), entry_date Date, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Completed_or_archive(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), application_code VARCHAR(400), onetomanyextension VARCHAR(400), number_field int, filter_btn VARCHAR(400), reset_btn VARCHAR(400), nationality VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Deleted_child(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), agent VARCHAR(400), phone_number VARCHAR(400), supplier_acknowledged VARCHAR(400), application_code VARCHAR(400), email_id VARCHAR(400), supplier VARCHAR(400), status VARCHAR(400), entry_date Date, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Deleted(id BIGINT NOT NULL AUTO_INCREMENT, application_code VARCHAR(400), onetomanyextension VARCHAR(400), filter_btn VARCHAR(400), reset_btn VARCHAR(400), nationality VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Upload_visa(id BIGINT NOT NULL AUTO_INCREMENT, rejected_visa VARCHAR(400), fileupload_visa VARCHAR(400), application VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Cost_sheet_upload(id BIGINT NOT NULL AUTO_INCREMENT, passport_number int, cost_sheet_upload VARCHAR(400), cost int, date Date, nationality VARCHAR(400), name VARCHAR(400), passport_type VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Visa_billing(id BIGINT NOT NULL AUTO_INCREMENT, visa_entry_type VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Visa_duration(id BIGINT NOT NULL AUTO_INCREMENT, visa_duration VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Visa_processing_time(id BIGINT NOT NULL AUTO_INCREMENT, visa_processing_time VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Visa_prices(id BIGINT NOT NULL AUTO_INCREMENT, cost int, visa_entry_type VARCHAR(400), visa_duration VARCHAR(400), total_price int, visa_processing VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Xero_invoices(id BIGINT NOT NULL AUTO_INCREMENT, agent VARCHAR(400), filter_btn VARCHAR(400), payed VARCHAR(400), onetomanyextension VARCHAR(400), invoice_sent VARCHAR(400), reset_btn VARCHAR(400), customer VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Xero_invoices_line(id BIGINT NOT NULL AUTO_INCREMENT, agent VARCHAR(400), send_invoice_btn VARCHAR(400), payed VARCHAR(400), total_price int, invoice_number int, show_btn VARCHAR(400), show_pdf_btn VARCHAR(400), invoice_sent VARCHAR(400), invoice_id int, coustomer VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Sage_pay(id BIGINT NOT NULL AUTO_INCREMENT, status VARCHAR(400), vpstxid VARCHAR(400), application_code VARCHAR(400), created VARCHAR(400), amount int, vendercode VARCHAR(400), txauthno int, expiry_date Date, last4digit int, card_type VARCHAR(400), banckauthcode VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Agent_report_line(id BIGINT NOT NULL AUTO_INCREMENT, status VARCHAR(400), full_name VARCHAR(400), agent VARCHAR(400), visa_processing_time VARCHAR(400), passport_number int, total_price int, visa_duration VARCHAR(400), invoice_created VARCHAR(400), nationality VARCHAR(400), application_code VARCHAR(400), visa_entry_type VARCHAR(400), invoice_id int, entry_date Date, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Agent_report(id BIGINT NOT NULL AUTO_INCREMENT, entry_date_form Date, full_name VARCHAR(400), agent VARCHAR(400), filter_btn VARCHAR(400), application_code VARCHAR(400), onetomanyextension VARCHAR(400), entry_date_to Date, passport_number int, reset_btn VARCHAR(400), date_field Date, invoice_created VARCHAR(400), nationality VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Supplier_report_line(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), agent VARCHAR(400), visa_processing_time VARCHAR(400), application_code VARCHAR(400), nationality VARCHAR(400), total_price int, visa_entry_type VARCHAR(400), passport_number int, visa_duration VARCHAR(400), supplier VARCHAR(400), entry_date Date, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Supplier_report(id BIGINT NOT NULL AUTO_INCREMENT, entry_date_form Date, full_name VARCHAR(400), application_code VARCHAR(400), onetomanyextension VARCHAR(400), entry_date_to Date, supplier VARCHAR(400), passport_number int, filter_btn VARCHAR(400), reset_btn VARCHAR(400), nationality VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Customer_report(id BIGINT NOT NULL AUTO_INCREMENT, full_name VARCHAR(400), phone_number VARCHAR(400), email_id VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Refferere_report_line(id BIGINT NOT NULL AUTO_INCREMENT, status VARCHAR(400), full_name VARCHAR(400), agent VARCHAR(400), visa_processing_time VARCHAR(400), passport_number int, cost VARCHAR(400), total_price VARCHAR(400), visa_duration VARCHAR(400), invoice_created VARCHAR(400), application_code VARCHAR(400), nationality VARCHAR(400), visa_entry_type VARCHAR(400), entry_date Date, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Refferere_report(id BIGINT NOT NULL AUTO_INCREMENT, onetomanyextension VARCHAR(400), entry_date_to Date, entry_date_from Date, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Emails(id BIGINT NOT NULL AUTO_INCREMENT, code VARCHAR(400), subject VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Visa_status(id BIGINT NOT NULL AUTO_INCREMENT, visa_status VARCHAR(400), price VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Nationality(id BIGINT NOT NULL AUTO_INCREMENT, visa_status VARCHAR(400), nationality VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Status(id BIGINT NOT NULL AUTO_INCREMENT, status VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Notification(id BIGINT NOT NULL AUTO_INCREMENT, notification VARCHAR(400), code VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Coupon(id BIGINT NOT NULL AUTO_INCREMENT, active VARCHAR(400), code VARCHAR(400), coupon_validity Date, coupon_discount int, PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Sage_pays(id BIGINT NOT NULL AUTO_INCREMENT, vender_id int, url VARCHAR(400), password VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Xero(id BIGINT NOT NULL AUTO_INCREMENT, customer_key VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.S_m_s(id BIGINT NOT NULL AUTO_INCREMENT, user VARCHAR(400), api_id int, password VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Refrreres_line(id BIGINT NOT NULL AUTO_INCREMENT, company VARCHAR(400), first_name VARCHAR(400), email VARCHAR(400), country VARCHAR(400), last_name VARCHAR(400), city VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Refrreres(id BIGINT NOT NULL AUTO_INCREMENT, company VARCHAR(400), first_name VARCHAR(400), onetomanyextension VARCHAR(400), last_name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Site(id BIGINT NOT NULL AUTO_INCREMENT, snapshot VARCHAR(400), isdefault VARCHAR(400), enable VARCHAR(400), enable_form Date, host VARCHAR(400), relative_path VARCHAR(400), enable_to Date, local VARCHAR(400), name VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Media(id BIGINT NOT NULL AUTO_INCREMENT, media VARCHAR(400), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Groupss(id BIGINT NOT NULL AUTO_INCREMENT, agent bit(1), staff bit(1), supplier bit(1), admin bit(1), name bit(1), PRIMARY KEY (id));
|
|
|
|
CREATE TABLE db.Paget(id BIGINT NOT NULL AUTO_INCREMENT, all_pages_link VARCHAR(400), PRIMARY KEY (id));
|
|
|