** Kapital Version 1 Database. Stop trying to mess with it! **(u81 $ $'$tablepaymentspayments10CREATE TABLE payments(payment_id INTEGER PRIMARY KEY, invoice_id int4, customer_id int4, created timestamp, payment_type varchar, payment_amount int4, check_number varchar, cc_name varch xc  *-ctableinvoice_numberinvoice_number23create table invoice_number(next_invoice_number int4)t 03tableinvoice_email_loginvoice_email_log30CREATE TABLE invoice_email_log( email_id INTEGER PRIMARY KEY, invoice_id int4, customer_id int4, sent_time timestamp, to_address varchar, balance_due int4, notice varc { $36{indexidx_invoice_customer_idinvoice_master41create index idx_invoice_customer_id on invoice_master (customer_id)*u  14uindexidx_doc_invoice_idinvoice_documents47CREATE INDEX idx_doc_invoice_id on invoice_documents(invoice_id)Gxtotal FROM invoice_items|XH$  DefaultB?Account Credits, bill_city varchar, bill_state varchar, bill_state_other varchar, bill_zip varchar, bill_country varchar, customer_status varchar, ship_address_same bool, ship_name varchar, ship_street1 varchar, ship_street2 varchar, ship_city varchar, ship_state varchar, ship_state_other varchar, ship_zip varchar, ship_country varchar, cc_name varchar, cc_number varchar, cc_exp_month int4, cc_exp_year int4, cc_cvv2 int4, contact_name varchar, contact_title varchar, contact_email varchar, contact_ph1 varchar, contact_ph2 varchar, contact_fax varchar, customer_notes text, balance_forward bool, finance_rate int4, penalize bool, misc1 varchar, misc2 varchar, misc3 varchar, category_id int4, credit int4, mail_list bool, penalty_type varchar, paper_invoice bool, email_invoice bool, invoice_template varchar, tax_rate varchar, auto_charge_card bool, tax_rate2 varchar) &/11000000Rent Hoarding City..................................... Trichy Area....................................Palakarai Width..................................25 ft Height..............................6 %11000000LabourErection Charge per sq feet Rs.4.00 Total charge Rs.3500.00 Vat @ 4% Rs. 140.00 13640000fPint4, taxable bool)6jjlw  )+-/16011785708541178570854I150PendingUnivercellChennai--UnivercellChennai--772975000772975077297500Ne3mber varchar, customer_name varchar, customer_email varchar, bill_street1 varchar, bill_street2 varchar, bill_city varchar, bill_state varchar, bill_state_other varchar, bill_zip varchar, bill_country varchar, ship_name varchar, ship_street1 varchar, ship_street2 varchar, ship_city varchar, ship_state varchar, ship_state_other varchar, ship_zip varchar, ship_country varchar, invoice_notes text, subtotal int4, tax int4, shipping int4, total int4, balance_due int4, recur_master int4, recur_type varchar, next_invoice int4, recur_error bool, past_due bool, ship_option int4, po varchar, terms varchar, salesman varchar, pay_by varchar, invoice_date timestamp, ship_other varchar, emailed_on timestamp, printed_on timestamp, ship_address_same bool, tax_rate int4, template varchar, last_invoice int4, recur_days int4, print_due_date bool, tax2 int4, tax_rate2 varchar)ar, cc_street1 varchar, cc_street2 varchar, cc_city varchar, cc_state varchar, cc_zip varchar, cc_country varchar, cc_number varchar, cc_exp_month varchar, cc_exp_year varchar, cc_cvv2 varchar, cc_auth_id varchar, notes varchar, void bool, transaction_log text, payment_applied int4, credit_id int4)|n "$ntablecategoriescategories3CREATE TABLE categories ( category_id INTEGER PRIMARY KEY, category_name)In &(ntablecustomerscustomers4CREATE TABLE customers (customer_id INTEGER PRIMARY KEY, created timestamp, updated timestamp, customer_number varchar, customer_name varchar, bill_street1 varchar, bill_street2 varchar (*tableinvoice_itemsinvoice_items6CREATE TABLE invoice_items ( item_id INTEGER PRIMARY KEY, invoice_id int4, product_id int4, product_name varchar, sku varchar, description varchar, quantity int4, price int4, cost  !02tableinvoice_masterinvoice_master8CREATE TABLE invoice_master( invoice_id INTEGER PRIMARY KEY, customer_id int4, created timestamp, updated timestamp, invoice_number varchar, status varchar, customer_nu   $' tableproductsproducts14CREATE TABLE products ( product_id INTEGER PRIMARY KEY, category_id int4,status varchar,product_name varchar,sku varchar,description varchar,stock int4,low_limit int4,price int4,cost int4,shipp) $')tablesettingssettings16CREATE TABLE settings ( company_name varchar, company_address1 varchar, company_address2 varchar, company_city varchar, company_state varchar, company_state_other varchar, company_zip varhW *-Wtableinvoice_bannerinvoice_banner19CREATE TABLE invoice_banner (banner text)u  &)utableship_optionsship_options20CREATE TABLE ship_options(ship_id INTEGER PRIMARY KEY, option_name varchar)@HPO  "%Otabledb_versiondb_version21CREATE TABLE db_version (version varchar)g  47tablecustomer_categoriescustomer_categories22CREATE TABLE customer_categories (category_id INTEGER PRIMARY KEY,category_name varchar)T;B?+,-/13579;999999ActiveAccount Credit00000ftPyB@%+4moqsuuwy1ActiveRent Hoarding City..................................... Area.................................... Width.................................. Height................................. Total Area4[BA'OQSUWWY[1ActiveLabourErection Charge per sq feet Total charge 0000ffDing int4,taxable bool,service bool)efix varchar, invoice_font varchar, invoice_cc_email varchar, invoice_payment_print bool, date_mask varchar, cc_partner varchar, invoice_mode varchar, email_type varchar, email_type_noprompt varchar, invoice_text_banner varchar, inc_name bool, inc_address bool, inc_contact bool, inc_webpage bool, inc_email bool, inc_phone bool, inc_fax bool, invoice_save_customer bool, tax_rate2 varchar, tax_text2 varchar, always_show_tax2 bool, apply_tax2_tax1 bool, tax_shipping bool, default_invoice_template varchar, default_payment_type varchar, encoding varchar, default_payment_terms varchar, smtp_auth_type varchar, invoice_title varchar, title2 varchar)( !$+2Obq'(Kreativ India 123 C 5th crossThillai NagarTrichyAKTamil Nadu620 018Indiadefault@yourcompany.commail.yourserver.com25100000100000Manual - No Internet Gatewayprocessor_usernameprocessor_passccemail@yourcompany.com0.00tffftftICfMM-DD-YYYYHTMLEmbedded HTMLfKreativ Indiaffffffff0.00fffDetailedCheckISO-8859-1On ReceiptLOGININVOICE None$  1.3.88|$  Default 151|g  ,/gtablecustomer_numbercustomer_number25create table customer_number(next_customer_number int4) ,/tablebalance_forwardbalance_forward26CREATE TABLE balance_forward( parent_invoice_id int4, child_invoice_id int4) 03tableinvoice_documentsinvoice_documents27CREATE TABLE invoice_documents ( document_id INTEGER PRIMARY KEY, invoice_id int4, file_name varchar, email bool): ,/tablecustomer_creditcustomer_credit28CREATE TABLE customer_credit( credit_id INTEGER PRIMARY KEY, customer_id int4, created date, amount int4, description varchar, refunded bool, refunded_on timestamp)w ,/tablecustomer_refundcustomer_refund29CREATE TABLE customer_refund( refund_id INTEGER PRIMARY KEY, customer_id int4, created date, amount int4, description varchar, canceled bool, canceled_on timestamp)wP 10|har)x` "%`indexidx_cust_idcustomers33create unique index idx_cust_id on customers (customer_id)_ $'_indexidx_cust_namecustomers34create index idx_cust_name on customers (customer_name)`f #&findexidx_cust_numcustomers35create unique index idx_cust_num on customers (customer_number)|c $'cindexidx_product_idproducts36create unique index idx_product_id on products (product_id)|Hb &)bindexidx_product_nameproducts37create index idx_product_name on products (product_name)|q %.1qindexidx_products_category_idproducts38create index idx_products_category_id on products (category_id)F` )7:indexidx_invoice_items_invoice_idinvoice_items39create index idx_invoice_items_invoice_id on invoice_items (invoice_id):x #25xindexidx_invoice_invoice_idinvoice_master40create index idx_invoice_invoice_id on invoice_master (invoice_id)X $b0G4Zq8~B? <b0G4Zq9B@ b0G4Zq91BAX@cAccount CreditB? cRent B@@ (cLabourBA$T b0G4Zq8~B? <b0G1XB@@@ b0G1XBABA8 b0G1X b0G1X b0G1X b000Wl .1lindexidx_invoice_statusinvoice_master43create index idx_invoice_status on invoice_master (status){ $36{indexidx_invoice_balance_dueinvoice_master44create index idx_invoice_balance_due on invoice_master (balance_due)xV %(Vindexidx_product_skuproducts45create index idx_product_sku on products(sku)5 '7:indexidx_parent_balance_forwardbalance_forward46create index idx_parent_balance_forward on balance_forward(parent_invoice_id)$ cPending$ b0G4zV9MT8cB?%cHoardingB@cErectionBAon,p.stock as stock,p.low_limit as low_limit,p.price as price,p.cost as cost,p.shipping as shipping,p.taxable as taxable,p.service as service,c.category_name as category_name FROM products as p,categories as c WHERE c.category_id = p.category_id! 35viewinvoice_item_detailinvoice_item_detail0create view invoice_item_detail as select *,(quantity * price) as line_total FROM invoice_items|"  /1viewproduct_detailproduct_detail0CREATE view product_detail AS SELECT p.product_id as product_id,p.category_id as category_id,p.status as status, p.product_name as product_name,p.sku as sku,p.description as descripti0( $'tablesettingssettings17CREATE TABLE settings ( company_name varchar, company_address1 varchar, company_address2 varchar, company_city varchar, company_state varchar, company_state_other varchar, company_zip var2X' "25tablesettings_backupsettings_backup57CREATE TABLE settings_backup ( company_name varchar, company_address1 varchar, company_address2 varchar, company_city varchar, company_state varchar, company_state_other varc\char, company_country varchar, company_phone varchar, company_fax varchar, company_email varchar, company_website varchar, contact_name varchar, invoice_banner varchar, c_search_field varchar, c_search_type varchar, i_search_field varchar, i_search_type varchar, p_search_field varchar, p_search_type varchar, invoice_email_subject varchar, invoice_email_from varchar, invoice_email_server varchar, invoice_email_port varchar, max_customer_number int4, max_invoice_number int4, payment_processor varchar, cc_username varchar, cc_password varchar, cc_email varchar, cc_avs_match varchar, cc_cvv2_match bool, cc_auto_void_mismatch bool, tax_rate varchar, email_message text, text_invoice bool, invoice_footer varchar, email_username varchar, email_password varchar, check_updates bool, invoice_random bool, customer_random bool, email_paid_invoices bool, email_unpaid_invoices bool, auto_charge_cards bool, invoice_note text, tax_text varchar, invoice_prefix varchar, customer_prver1178571776f1None11784960001178496000t0.00Detailed00t00.00........................... Lights.................................. Rent Per Month Per Sq Feet. Total Rent Charge For Months0000ffdiadefault@yourcompany.commail.yourserver.com25100000100000Manual - No Internet Gatewayprocessor_usernameprocessor_passccemail@yourcompany.com0.00tffftftICfMM-DD-YYYYHTMLEmbedded HTMLfKreativ Indiaffffffff0.00fffDetailedCheckISO-8859-1On ReceiptLOGININVOICE...35 ft Total Area...........................875 sq ft Lights..................................Yes Rent Per Month Per Sq Feet.Rs.25.00 Total Rent Charge For 3 Months Rs.65,625.00 Service tax @ 12.24% Rs. 8032.50 173657500fvarchar, customer_prefix varchar, invoice_font varchar, invoice_cc_email varchar, invoice_payment_print bool, date_mask varchar, cc_partner varchar, invoice_mode varchar, email_type varchar, email_type_noprompt varchar, invoice_text_banner varchar, inc_name bool, inc_address bool, inc_contact bool, inc_webpage bool, inc_email bool, inc_phone bool, inc_fax bool, invoice_save_customer bool, tax_rate2 varchar, tax_text2 varchar, always_show_tax2 bool, apply_tax2_tax1 bool, tax_shipping bool, default_invoice_template varchar, default_payment_type varchar, encoding varchar, default_payment_terms varchar, smtp_auth_type varchar, invoice_title varchar)759% ")0M`o %Kreativ India 123 C 5th crossThillai NagarTrichyAKTamil Nadu620 018In5