Git Product home page Git Product logo

agilebill-zpanel's Introduction

AgileBill is a Flexible Billing and Invoicing Application for a number of 
markets, including Web Hosts, ISPs, VoIP Providers, and membership/subscription
type models.

It features numerious plugins for payment processing, provisioning, and interfacing
with a variety of 3rd-party applications and services.

Development began as early as 2002, and initially released commercially in 2004. 

The project was released to open source in November 26, 2008.

For support, the community group is located at:
	http://groups.google.com/group/agilebilloss

The project homepage is located here:
	http://agileco.com/agilebill-open-source-billing-software.htm

The bug tracking and feature requests are located here:
	http://github.com/tony-landis/agilebill/issues

The developer's personal website is:
	http://www.tonylandis.com

For a full list of features, see these version release announcement: 
	http://forum.agileco.com/forumdisplay.php?s=&f=26&page=1&pp=20&sort=lastpost&order=desc&daysprune=-1

An archive of the old user community is located at:
	http://forum.agileco.com

This software includes the functionality the two projects AgileVoice and AgileISP, websites:
	http://www.agilevoice.com
	http://www.agileisp.com

agilebill-zpanel's People

Contributors

vstock4481 avatar

Stargazers

avatar avatar avatar

Watchers

avatar avatar

Forkers

badtzhou mjsorribas devtrance surereddy

agilebill-zpanel's Issues

Install Problem

Hay,

i becom a error by install:

5 Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 11

ALTER TABLE a_module ADD INDEX parent (parent_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_module' doesn't exist

ALTER TABLE a_module ADD INDEX menu_display (menu_display)
Error (install_sql-3): Table 'altdeutsch_billing.a_module' doesn't exist

ALTER TABLE a_module ADD INDEX displays (status, menu_display)
Error (install_sql-3): Table 'altdeutsch_billing.a_module' doesn't exist

5 Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

ALTER TABLE a_module_method ADD INDEX module (module_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_module_method' doesn't exist

ALTER TABLE a_module_method ADD INDEX menu_display (menu_display)
Error (install_sql-3): Table 'altdeutsch_billing.a_module_method' doesn't exist

5 Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7

ALTER TABLE a_group_method ADD INDEX groups (group_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_group_method' doesn't exist

ALTER TABLE a_group_method ADD INDEX modules (module_id, method_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_group_method' doesn't exist

CREATE TABLE a_setup ( id INTEGER, site_id INTEGER, country_id INTEGER, language_id VARCHAR(16), currency_id INTEGER, weight_id INTEGER, theme_id VARCHAR(16), admin_theme_id VARCHAR(16), group_id INTEGER, affiliate_template_id INTEGER, affiliate_id INTEGER, reseller_id INTEGER, setup_email_id INTEGER, ssl_url TEXT, nonssl_url TEXT, login_expire INTEGER, cookie_name VARCHAR(32), cookie_expire INTEGER, session_ip_match TINYINT, error_reporting VARCHAR(16), site_name TEXT, site_email TEXT, time_format TEXT, date_format TEXT, date_time_format VARCHAR(128), decimal_place INTEGER, debug TINYINT, login_attempt_try INTEGER, login_attempt_time INTEGER, login_attempt_lock INTEGER, search_expire INTEGER, db_cache TINYINT, newsletter_registration TINYINT, default_account_status TINYINT, cache_sessions TINYINT, weblog TINYINT, site_address VARCHAR(128), site_city VARCHAR(32), site_state VARCHAR(16), site_zip VARCHAR(16), site_phone VARCHAR(32), site_fax VARCHAR(32), os TINYINT, auto_affiliate TINYINT, path_curl VARCHAR(64), show_ticket_link TINYINT, show_affiliate_link TINYINT, show_newsletter_link TINYINT, show_domain_link TINYINT, show_contact_link TINYINT, show_cart_link TINYINT, show_checkout_link TINYINT, show_product_link TINYINT, show_cat_block TINYINT, show_file_block TINYINT, show_static_block TINYINT, show_affiliate_code TINYINT, show_discount_code TINYINT, billing_weekday VARCHAR(2), grace_period VARCHAR(2), max_billing_notice VARCHAR(2), max_inv_gen_period VARCHAR(2), license_key VARCHAR(128), license_code LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 66

CREATE TABLE a_setup ( id INTEGER, site_id INTEGER, country_id INTEGER, language_id VARCHAR(16), currency_id INTEGER, weight_id INTEGER, theme_id VARCHAR(16), admin_theme_id VARCHAR(16), group_id INTEGER, affiliate_template_id INTEGER, affiliate_id INTEGER, reseller_id INTEGER, setup_email_id INTEGER, ssl_url TEXT, nonssl_url TEXT, login_expire INTEGER, cookie_name VARCHAR(32), cookie_expire INTEGER, session_ip_match TINYINT, error_reporting VARCHAR(16), site_name TEXT, site_email TEXT, time_format TEXT, date_format TEXT, date_time_format VARCHAR(128), decimal_place INTEGER, debug TINYINT, login_attempt_try INTEGER, login_attempt_time INTEGER, login_attempt_lock INTEGER, search_expire INTEGER, db_cache TINYINT, newsletter_registration TINYINT, default_account_status TINYINT, cache_sessions TINYINT, weblog TINYINT, site_address VARCHAR(128), site_city VARCHAR(32), site_state VARCHAR(16), site_zip VARCHAR(16), site_phone VARCHAR(32), site_fax VARCHAR(32), os TINYINT, auto_affiliate TINYINT, path_curl VARCHAR(64), show_ticket_link TINYINT, show_affiliate_link TINYINT, show_newsletter_link TINYINT, show_domain_link TINYINT, show_contact_link TINYINT, show_cart_link TINYINT, show_checkout_link TINYINT, show_product_link TINYINT, show_cat_block TINYINT, show_file_block TINYINT, show_static_block TINYINT, show_affiliate_code TINYINT, show_discount_code TINYINT, billing_weekday VARCHAR(2), grace_period VARCHAR(2), max_billing_notice VARCHAR(2), max_inv_gen_period VARCHAR(2), license_key VARCHAR(128), license_code LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_setup' doesn't exist

CREATE TABLE a_account ( id BIGINT, site_id INTEGER, date_orig BIGINT, date_last BIGINT, date_expire BIGINT, parent_id INTEGER, language_id VARCHAR(32), country_id INTEGER, affiliate_id VARCHAR(32), campaign_id INTEGER, reseller_id INTEGER, currency_id INTEGER, theme_id VARCHAR(32), username VARCHAR(128), password VARCHAR(128), inherit_group TINYINT, misc VARCHAR(128), status INTEGER, first_name VARCHAR(128), middle_name VARCHAR(128), last_name VARCHAR(128), title VARCHAR(128), email VARCHAR(255), company VARCHAR(255), address1 VARCHAR(128), address2 VARCHAR(128), city VARCHAR(32), state VARCHAR(32), zip VARCHAR(16), email_type TINYINT, invoice_delivery INTEGER, invoice_show_itemized TINYINT, invoice_grace INTEGER, invoice_advance_gen INTEGER, tax_id VARCHAR(64), max_child INTEGER )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 38

CREATE TABLE a_account ( id BIGINT, site_id INTEGER, date_orig BIGINT, date_last BIGINT, date_expire BIGINT, parent_id INTEGER, language_id VARCHAR(32), country_id INTEGER, affiliate_id VARCHAR(32), campaign_id INTEGER, reseller_id INTEGER, currency_id INTEGER, theme_id VARCHAR(32), username VARCHAR(128), password VARCHAR(128), inherit_group TINYINT, misc VARCHAR(128), status INTEGER, first_name VARCHAR(128), middle_name VARCHAR(128), last_name VARCHAR(128), title VARCHAR(128), email VARCHAR(255), company VARCHAR(255), address1 VARCHAR(128), address2 VARCHAR(128), city VARCHAR(32), state VARCHAR(32), zip VARCHAR(16), email_type TINYINT, invoice_delivery INTEGER, invoice_show_itemized TINYINT, invoice_grace INTEGER, invoice_advance_gen INTEGER, tax_id VARCHAR(64), max_child INTEGER )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX login (username, password)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX search (first_name, middle_name, last_name)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX company (company)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX email (email)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX affiliate (affiliate_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX campaign_id (campaign_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX country (country_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX region (city, state)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX city (city)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX state (state)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX postal (zip)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD INDEX idmain (id, site_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

ALTER TABLE a_account ADD FULLTEXT INDEX fulltext_user (first_name, last_name, email, company)
Error (install_sql-3): Table 'altdeutsch_billing.a_account' doesn't exist

CREATE TABLE a_account_memo ( id BIGINT, site_id INTEGER, date_orig BIGINT, staff_id BIGINT, account_id BIGINT, type VARCHAR(32), memo VARCHAR(255), misc VARCHAR(32) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

CREATE TABLE a_account_memo ( id BIGINT, site_id INTEGER, date_orig BIGINT, staff_id BIGINT, account_id BIGINT, type VARCHAR(32), memo VARCHAR(255), misc VARCHAR(32) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_account_memo' doesn't exist

ALTER TABLE a_account_memo ADD INDEX account (account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_account_memo' doesn't exist

ALTER TABLE a_account_memo ADD INDEX memo (memo)
Error (install_sql-3): Table 'altdeutsch_billing.a_account_memo' doesn't exist

CREATE TABLE a_account_group ( id BIGINT, site_id INTEGER, date_orig BIGINT, date_start BIGINT, date_expire BIGINT, group_id INTEGER, account_id BIGINT, service_id BIGINT, active TINYINT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 11

CREATE TABLE a_account_group ( id BIGINT, site_id INTEGER, date_orig BIGINT, date_start BIGINT, date_expire BIGINT, group_id INTEGER, account_id BIGINT, service_id BIGINT, active TINYINT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_account_group' doesn't exist

ALTER TABLE a_account_group ADD INDEX dates (date_start, date_expire)
Error (install_sql-3): Table 'altdeutsch_billing.a_account_group' doesn't exist

ALTER TABLE a_account_group ADD INDEX account (active, account_id, group_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_account_group' doesn't exist

ALTER TABLE a_account_group ADD INDEX service (service_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_account_group' doesn't exist

CREATE TABLE a_account_billing ( id INTEGER, site_id INTEGER, account_id BIGINT, checkout_plugin_id VARCHAR(32), plugin_data TEXT, name VARCHAR(32), notes VARCHAR(128), notify_count INTEGER, card_type VARCHAR(16), card_num TEXT, card_num4 VARCHAR(16), card_exp_month VARCHAR(16), card_exp_year VARCHAR(16), card_start_month VARCHAR(16), card_start_year VARCHAR(16), eft_check_acct_type VARCHAR(16), eft_trn VARCHAR(255), eft_check_acct VARCHAR(255), eft_check_checkno BIGINT, first_name VARCHAR(16), last_name VARCHAR(16), address1 VARCHAR(32), address2 VARCHAR(32), city VARCHAR(16), state VARCHAR(16), zip VARCHAR(16), country_id VARCHAR(16), phone VARCHAR(16), email VARCHAR(128), company VARCHAR(32), ssn VARCHAR(255), dl_no VARCHAR(255), dob VARCHAR(255) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 35

CREATE TABLE a_account_billing ( id INTEGER, site_id INTEGER, account_id BIGINT, checkout_plugin_id VARCHAR(32), plugin_data TEXT, name VARCHAR(32), notes VARCHAR(128), notify_count INTEGER, card_type VARCHAR(16), card_num TEXT, card_num4 VARCHAR(16), card_exp_month VARCHAR(16), card_exp_year VARCHAR(16), card_start_month VARCHAR(16), card_start_year VARCHAR(16), eft_check_acct_type VARCHAR(16), eft_trn VARCHAR(255), eft_check_acct VARCHAR(255), eft_check_checkno BIGINT, first_name VARCHAR(16), last_name VARCHAR(16), address1 VARCHAR(32), address2 VARCHAR(32), city VARCHAR(16), state VARCHAR(16), zip VARCHAR(16), country_id VARCHAR(16), phone VARCHAR(16), email VARCHAR(128), company VARCHAR(32), ssn VARCHAR(255), dl_no VARCHAR(255), dob VARCHAR(255) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_account_billing' doesn't exist

ALTER TABLE a_account_billing ADD INDEX account_id (site_id, account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_account_billing' doesn't exist

ALTER TABLE a_account_billing ADD INDEX checkout_plugin (site_id, checkout_plugin_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_account_billing' doesn't exist

ALTER TABLE a_account_billing ADD INDEX card_type (site_id, card_type)
Error (install_sql-3): Table 'altdeutsch_billing.a_account_billing' doesn't exist

ALTER TABLE a_account_billing ADD INDEX eft_type (site_id, eft_check_acct_type)
Error (install_sql-3): Table 'altdeutsch_billing.a_account_billing' doesn't exist

CREATE TABLE a_blocked_email ( id INTEGER, site_id INTEGER, date_orig BIGINT, date_last BIGINT, email VARCHAR(128), notes LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8

CREATE TABLE a_blocked_email ( id INTEGER, site_id INTEGER, date_orig BIGINT, date_last BIGINT, email VARCHAR(128), notes LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_blocked_email' doesn't exist

ALTER TABLE a_blocked_email ADD INDEX email (email)
Error (install_sql-3): Table 'altdeutsch_billing.a_blocked_email' doesn't exist

CREATE TABLE a_blocked_ip ( id INTEGER, site_id INTEGER, date_orig BIGINT, date_last BIGINT, ip VARCHAR(128), notes LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8

CREATE TABLE a_blocked_ip ( id INTEGER, site_id INTEGER, date_orig BIGINT, date_last BIGINT, ip VARCHAR(128), notes LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_blocked_ip' doesn't exist

ALTER TABLE a_blocked_ip ADD INDEX ip (ip)
Error (install_sql-3): Table 'altdeutsch_billing.a_blocked_ip' doesn't exist

CREATE TABLE a_cart ( id INTEGER, site_id INTEGER, date_orig BIGINT, account_id BIGINT, session_id VARCHAR(32), cart_type INTEGER, product_id INTEGER, product_attr LONGTEXT, quantity INTEGER, coupon VARCHAR(16), recurr_schedule INTEGER, host_type VARCHAR(16), domain_tld_id INTEGER, domain_name VARCHAR(128), domain_tld VARCHAR(16), domain_term INTEGER, cart_parent_id INTEGER, ad_hoc_sku VARCHAR(16), ad_hoc_name VARCHAR(128), ad_hoc_desc VARCHAR(255), ad_hoc_amount DOUBLE, ad_hoc_setup DOUBLE, ad_hoc_discount DOUBLE, ad_hoc_taxable TINYINT, service_id BIGINT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 27

CREATE TABLE a_cart ( id INTEGER, site_id INTEGER, date_orig BIGINT, account_id BIGINT, session_id VARCHAR(32), cart_type INTEGER, product_id INTEGER, product_attr LONGTEXT, quantity INTEGER, coupon VARCHAR(16), recurr_schedule INTEGER, host_type VARCHAR(16), domain_tld_id INTEGER, domain_name VARCHAR(128), domain_tld VARCHAR(16), domain_term INTEGER, cart_parent_id INTEGER, ad_hoc_sku VARCHAR(16), ad_hoc_name VARCHAR(128), ad_hoc_desc VARCHAR(255), ad_hoc_amount DOUBLE, ad_hoc_setup DOUBLE, ad_hoc_discount DOUBLE, ad_hoc_taxable TINYINT, service_id BIGINT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_cart' doesn't exist

ALTER TABLE a_cart ADD INDEX account (account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_cart' doesn't exist

ALTER TABLE a_cart ADD INDEX session (session_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_cart' doesn't exist

ALTER TABLE a_cart ADD INDEX parent (cart_parent_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_cart' doesn't exist

CREATE TABLE a_country ( id INTEGER, site_id INTEGER, name VARCHAR(128), description VARCHAR(128), notes VARCHAR(128), two_code VARCHAR(16), three_code VARCHAR(16) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

CREATE TABLE a_country ( id INTEGER, site_id INTEGER, name VARCHAR(128), description VARCHAR(128), notes VARCHAR(128), two_code VARCHAR(16), three_code VARCHAR(16) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_country' doesn't exist

CREATE TABLE a_currency ( id INTEGER, site_id INTEGER, name VARCHAR(128), status TINYINT, convert_array LONGTEXT, notes VARCHAR(128), symbol VARCHAR(16), three_digit VARCHAR(3) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

CREATE TABLE a_currency ( id INTEGER, site_id INTEGER, name VARCHAR(128), status TINYINT, convert_array LONGTEXT, notes VARCHAR(128), symbol VARCHAR(16), three_digit VARCHAR(3) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_currency' doesn't exist

CREATE TABLE a_checkout ( id INTEGER, site_id INTEGER, name VARCHAR(32), description VARCHAR(255), active TINYINT, checkout_plugin VARCHAR(32), plugin_data LONGTEXT, allow_recurring TINYINT, allow_new TINYINT, allow_trial TINYINT, total_minimum DOUBLE, total_maximum DOUBLE, max_decline_attempts INTEGER, manual_approval_all TINYINT, manual_approval_recur TINYINT, manual_approval_country LONGTEXT, manual_approval_group LONGTEXT, manual_approval_amount DOUBLE, manual_approval_currency LONGTEXT, default_when_currency LONGTEXT, default_when_country LONGTEXT, default_when_group LONGTEXT, default_when_amount DOUBLE, allowed_currencies LONGTEXT, email_template LONGTEXT, required_groups LONGTEXT, excluded_products LONGTEXT, graphic_url VARCHAR(128) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 30

CREATE TABLE a_checkout ( id INTEGER, site_id INTEGER, name VARCHAR(32), description VARCHAR(255), active TINYINT, checkout_plugin VARCHAR(32), plugin_data LONGTEXT, allow_recurring TINYINT, allow_new TINYINT, allow_trial TINYINT, total_minimum DOUBLE, total_maximum DOUBLE, max_decline_attempts INTEGER, manual_approval_all TINYINT, manual_approval_recur TINYINT, manual_approval_country LONGTEXT, manual_approval_group LONGTEXT, manual_approval_amount DOUBLE, manual_approval_currency LONGTEXT, default_when_currency LONGTEXT, default_when_country LONGTEXT, default_when_group LONGTEXT, default_when_amount DOUBLE, allowed_currencies LONGTEXT, email_template LONGTEXT, required_groups LONGTEXT, excluded_products LONGTEXT, graphic_url VARCHAR(128) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_checkout' doesn't exist

CREATE TABLE a_discount ( id BIGINT, site_id INTEGER, date_orig BIGINT, date_start BIGINT, date_expire BIGINT, status TINYINT, name VARCHAR(64), notes LONGTEXT, max_usage_account INTEGER, max_usage_global INTEGER, avail_account_id BIGINT, avail_product_id LONGTEXT, avail_group_id LONGTEXT, avail_tld_id LONGTEXT, new_status TINYINT, new_type TINYINT, new_rate DOUBLE, new_max_discount DOUBLE, new_min_cost DOUBLE, recurr_status TINYINT, recurr_type TINYINT, recurr_rate DOUBLE, recurr_max_discount DOUBLE, recurr_min_cost DOUBLE )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 26

CREATE TABLE a_discount ( id BIGINT, site_id INTEGER, date_orig BIGINT, date_start BIGINT, date_expire BIGINT, status TINYINT, name VARCHAR(64), notes LONGTEXT, max_usage_account INTEGER, max_usage_global INTEGER, avail_account_id BIGINT, avail_product_id LONGTEXT, avail_group_id LONGTEXT, avail_tld_id LONGTEXT, new_status TINYINT, new_type TINYINT, new_rate DOUBLE, new_max_discount DOUBLE, new_min_cost DOUBLE, recurr_status TINYINT, recurr_type TINYINT, recurr_rate DOUBLE, recurr_max_discount DOUBLE, recurr_min_cost DOUBLE )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_discount' doesn't exist

ALTER TABLE a_discount ADD INDEX start (date_start)
Error (install_sql-3): Table 'altdeutsch_billing.a_discount' doesn't exist

ALTER TABLE a_discount ADD INDEX expire (date_expire)
Error (install_sql-3): Table 'altdeutsch_billing.a_discount' doesn't exist

ALTER TABLE a_discount ADD INDEX status (status)
Error (install_sql-3): Table 'altdeutsch_billing.a_discount' doesn't exist

CREATE TABLE a_email_template ( id BIGINT, site_id INTEGER, setup_email_id INTEGER, name VARCHAR(128), priority TINYINT, shortcuts LONGTEXT, notes LONGTEXT, sql_1 LONGTEXT, sql_2 LONGTEXT, sql_3 LONGTEXT, status TINYINT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 13

CREATE TABLE a_email_template ( id BIGINT, site_id INTEGER, setup_email_id INTEGER, name VARCHAR(128), priority TINYINT, shortcuts LONGTEXT, notes LONGTEXT, sql_1 LONGTEXT, sql_2 LONGTEXT, sql_3 LONGTEXT, status TINYINT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_email_template' doesn't exist

ALTER TABLE a_email_template ADD INDEX name (name)
Error (install_sql-3): Table 'altdeutsch_billing.a_email_template' doesn't exist

CREATE TABLE a_email_template_translate ( id BIGINT, site_id INTEGER, email_template_id BIGINT, language_id VARCHAR(16), subject VARCHAR(255), message_text LONGTEXT, message_html LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

CREATE TABLE a_email_template_translate ( id BIGINT, site_id INTEGER, email_template_id BIGINT, language_id VARCHAR(16), subject VARCHAR(255), message_text LONGTEXT, message_html LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_email_template_translate' doesn't exist

ALTER TABLE a_email_template_translate ADD INDEX parent (email_template_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_email_template_translate' doesn't exist

ALTER TABLE a_email_template_translate ADD INDEX language (language_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_email_template_translate' doesn't exist

CREATE TABLE a_group ( id INTEGER, site_id INTEGER, date_orig BIGINT, date_start BIGINT, date_expire BIGINT, parent_id INTEGER, status TINYINT, pricing TINYINT, name VARCHAR(128), notes LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 12

CREATE TABLE a_group ( id INTEGER, site_id INTEGER, date_orig BIGINT, date_start BIGINT, date_expire BIGINT, parent_id INTEGER, status TINYINT, pricing TINYINT, name VARCHAR(128), notes LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_group' doesn't exist

ALTER TABLE a_group ADD INDEX pricing (date_expire)
Error (install_sql-3): Table 'altdeutsch_billing.a_group' doesn't exist

ALTER TABLE a_group ADD INDEX idx (status, parent_id, date_start, date_expire)
Error (install_sql-3): Table 'altdeutsch_billing.a_group' doesn't exist

CREATE TABLE a_invoice ( id INTEGER, site_id INTEGER, date_orig BIGINT, date_last BIGINT, parent_id INTEGER, type TINYINT, process_status TINYINT, billing_status TINYINT, refund_status TINYINT, suspend_billing TINYINT, print_status TINYINT, account_id BIGINT, account_billing_id INTEGER, affiliate_id VARCHAR(32), campaign_id INTEGER, custom_affiliate_status TINYINT, reseller_id VARCHAR(32), checkout_plugin_id INTEGER, checkout_plugin_data VARCHAR(255), tax_id INTEGER, tax_amt DOUBLE, discount_arr VARCHAR(255), discount_amt DOUBLE, recur_amt DOUBLE, total_amt DOUBLE, billed_amt DOUBLE, billed_currency_id INTEGER, actual_billed_amt DOUBLE, actual_billed_currency_id INTEGER, notice_count INTEGER, notice_max INTEGER, notice_next_date BIGINT, grace_period INTEGER, due_date BIGINT, recur_arr TEXT, notes TEXT, net_term_id TINYINT, net_term_date_last BIGINT, net_term_intervals INTEGER, ip VARCHAR(32) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 42

CREATE TABLE a_invoice ( id INTEGER, site_id INTEGER, date_orig BIGINT, date_last BIGINT, parent_id INTEGER, type TINYINT, process_status TINYINT, billing_status TINYINT, refund_status TINYINT, suspend_billing TINYINT, print_status TINYINT, account_id BIGINT, account_billing_id INTEGER, affiliate_id VARCHAR(32), campaign_id INTEGER, custom_affiliate_status TINYINT, reseller_id VARCHAR(32), checkout_plugin_id INTEGER, checkout_plugin_data VARCHAR(255), tax_id INTEGER, tax_amt DOUBLE, discount_arr VARCHAR(255), discount_amt DOUBLE, recur_amt DOUBLE, total_amt DOUBLE, billed_amt DOUBLE, billed_currency_id INTEGER, actual_billed_amt DOUBLE, actual_billed_currency_id INTEGER, notice_count INTEGER, notice_max INTEGER, notice_next_date BIGINT, grace_period INTEGER, due_date BIGINT, recur_arr TEXT, notes TEXT, net_term_id TINYINT, net_term_date_last BIGINT, net_term_intervals INTEGER, ip VARCHAR(32) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX orig (date_orig)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX last (date_last)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX parent (parent_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX billing (billing_status)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX process (process_status)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX suspend (suspend_billing)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX refund (refund_status)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX account (account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX affiliate (affiliate_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX campaign (campaign_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX reseller (reseller_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX amount (total_amt)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX due_date (due_date)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX checkout (checkout_plugin_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

ALTER TABLE a_invoice ADD INDEX tax (tax_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice' doesn't exist

CREATE TABLE a_invoice_commission ( id BIGINT, site_id INTEGER, date_orig BIGINT, date_last BIGINT, affiliate_commission_id INTEGER, invoice_id BIGINT, affiliate_id VARCHAR(32), commission DOUBLE, status TINYINT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 11

CREATE TABLE a_invoice_commission ( id BIGINT, site_id INTEGER, date_orig BIGINT, date_last BIGINT, affiliate_commission_id INTEGER, invoice_id BIGINT, affiliate_id VARCHAR(32), commission DOUBLE, status TINYINT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_invoice_commission' doesn't exist

ALTER TABLE a_invoice_commission ADD INDEX date (date_orig)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_commission' doesn't exist

ALTER TABLE a_invoice_commission ADD INDEX commission (affiliate_commission_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_commission' doesn't exist

ALTER TABLE a_invoice_commission ADD INDEX invoice (invoice_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_commission' doesn't exist

ALTER TABLE a_invoice_commission ADD INDEX affiliate (affiliate_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_commission' doesn't exist

ALTER TABLE a_invoice_commission ADD INDEX status (status)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_commission' doesn't exist

CREATE TABLE a_invoice_item ( id BIGINT, site_id INTEGER, date_orig BIGINT, parent_id BIGINT, account_id BIGINT, service_id BIGINT, invoice_id BIGINT, product_id BIGINT, charge_id BIGINT, sku VARCHAR(128), quantity INTEGER, item_type TINYINT, product_attr LONGTEXT, product_attr_cart LONGTEXT, product_name VARCHAR(128), total_amt DOUBLE, tax_amt DOUBLE, discount_amt DOUBLE, price_type TINYINT, price_base DOUBLE, price_setup DOUBLE, recurring_schedule INTEGER, domain_name VARCHAR(128), domain_tld VARCHAR(16), domain_term INTEGER, domain_type VARCHAR(16), date_start BIGINT, date_stop BIGINT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 30

CREATE TABLE a_invoice_item ( id BIGINT, site_id INTEGER, date_orig BIGINT, parent_id BIGINT, account_id BIGINT, service_id BIGINT, invoice_id BIGINT, product_id BIGINT, charge_id BIGINT, sku VARCHAR(128), quantity INTEGER, item_type TINYINT, product_attr LONGTEXT, product_attr_cart LONGTEXT, product_name VARCHAR(128), total_amt DOUBLE, tax_amt DOUBLE, discount_amt DOUBLE, price_type TINYINT, price_base DOUBLE, price_setup DOUBLE, recurring_schedule INTEGER, domain_name VARCHAR(128), domain_tld VARCHAR(16), domain_term INTEGER, domain_type VARCHAR(16), date_start BIGINT, date_stop BIGINT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_invoice_item' doesn't exist

ALTER TABLE a_invoice_item ADD INDEX parent (parent_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item' doesn't exist

ALTER TABLE a_invoice_item ADD INDEX invoice (invoice_id, site_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item' doesn't exist

ALTER TABLE a_invoice_item ADD INDEX product (product_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item' doesn't exist

ALTER TABLE a_invoice_item ADD INDEX accountid (account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item' doesn't exist

ALTER TABLE a_invoice_item ADD INDEX serviceid (service_id, site_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item' doesn't exist

ALTER TABLE a_invoice_item ADD INDEX invserviceid (service_id, invoice_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item' doesn't exist

ALTER TABLE a_invoice_item ADD INDEX sku (sku)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item' doesn't exist

ALTER TABLE a_invoice_item ADD INDEX domain (domain_name, domain_tld)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item' doesn't exist

ALTER TABLE a_invoice_item ADD INDEX dates (date_orig)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item' doesn't exist

ALTER TABLE a_invoice_item ADD INDEX charge (site_id, charge_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item' doesn't exist

CREATE TABLE a_invoice_item_tax ( id INTEGER, site_id INTEGER, date_orig BIGINT, invoice_id BIGINT, account_id BIGINT, invoice_item_id BIGINT, tax_id INTEGER, amount DOUBLE )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

CREATE TABLE a_invoice_item_tax ( id INTEGER, site_id INTEGER, date_orig BIGINT, invoice_id BIGINT, account_id BIGINT, invoice_item_id BIGINT, tax_id INTEGER, amount DOUBLE )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_invoice_item_tax' doesn't exist

ALTER TABLE a_invoice_item_tax ADD INDEX taxes (tax_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item_tax' doesn't exist

ALTER TABLE a_invoice_item_tax ADD INDEX invoice_id (invoice_id, invoice_item_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item_tax' doesn't exist

ALTER TABLE a_invoice_item_tax ADD INDEX dates (date_orig)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item_tax' doesn't exist

ALTER TABLE a_invoice_item_tax ADD INDEX accounts (account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item_tax' doesn't exist

CREATE TABLE a_invoice_item_discount ( id INTEGER, site_id INTEGER, date_orig BIGINT, invoice_id BIGINT, account_id BIGINT, invoice_item_id BIGINT, discount VARCHAR(64), amount DOUBLE )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

CREATE TABLE a_invoice_item_discount ( id INTEGER, site_id INTEGER, date_orig BIGINT, invoice_id BIGINT, account_id BIGINT, invoice_item_id BIGINT, discount VARCHAR(64), amount DOUBLE )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_invoice_item_discount' doesn't exist

ALTER TABLE a_invoice_item_discount ADD INDEX discounts (discount)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item_discount' doesn't exist

ALTER TABLE a_invoice_item_discount ADD INDEX invoice_id (invoice_id, invoice_item_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item_discount' doesn't exist

ALTER TABLE a_invoice_item_discount ADD INDEX dates (date_orig)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item_discount' doesn't exist

ALTER TABLE a_invoice_item_discount ADD INDEX accounts (account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_item_discount' doesn't exist

CREATE TABLE a_invoice_memo ( id BIGINT, site_id INTEGER, date_orig BIGINT, invoice_id VARCHAR(32), account_id BIGINT, type VARCHAR(32), memo VARCHAR(255), misc VARCHAR(32) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

CREATE TABLE a_invoice_memo ( id BIGINT, site_id INTEGER, date_orig BIGINT, invoice_id VARCHAR(32), account_id BIGINT, type VARCHAR(32), memo VARCHAR(255), misc VARCHAR(32) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_invoice_memo' doesn't exist

ALTER TABLE a_invoice_memo ADD INDEX invoice (invoice_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_memo' doesn't exist

ALTER TABLE a_invoice_memo ADD INDEX memo (memo)
Error (install_sql-3): Table 'altdeutsch_billing.a_invoice_memo' doesn't exist

CREATE TABLE a_login_lock ( id INTEGER, site_id INTEGER, account_id BIGINT, date_orig BIGINT, date_expire BIGINT, ip VARCHAR(32) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8

CREATE TABLE a_login_lock ( id INTEGER, site_id INTEGER, account_id BIGINT, date_orig BIGINT, date_expire BIGINT, ip VARCHAR(32) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_login_lock' doesn't exist

ALTER TABLE a_login_lock ADD INDEX account (account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_login_lock' doesn't exist

ALTER TABLE a_login_lock ADD INDEX expire (date_expire)
Error (install_sql-3): Table 'altdeutsch_billing.a_login_lock' doesn't exist

ALTER TABLE a_login_lock ADD INDEX ip (ip)
Error (install_sql-3): Table 'altdeutsch_billing.a_login_lock' doesn't exist

CREATE TABLE a_login_log ( id INTEGER, site_id INTEGER, date_orig BIGINT, account_id BIGINT, status TINYINT, ip VARCHAR(32) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8

CREATE TABLE a_login_log ( id INTEGER, site_id INTEGER, date_orig BIGINT, account_id BIGINT, status TINYINT, ip VARCHAR(32) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_login_log' doesn't exist

ALTER TABLE a_login_log ADD INDEX account (account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_login_log' doesn't exist

ALTER TABLE a_login_log ADD INDEX ip (ip)
Error (install_sql-3): Table 'altdeutsch_billing.a_login_log' doesn't exist

CREATE TABLE a_log_error ( id BIGINT, site_id INTEGER, date_orig BIGINT, account_id BIGINT, module VARCHAR(64), method VARCHAR(64), message LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

CREATE TABLE a_log_error ( id BIGINT, site_id INTEGER, date_orig BIGINT, account_id BIGINT, module VARCHAR(64), method VARCHAR(64), message LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_log_error' doesn't exist

CREATE TABLE a_newsletter ( id INTEGER, site_id INTEGER, group_avail VARCHAR(255), name VARCHAR(255), description LONGTEXT, notes LONGTEXT, active TINYINT, display_signup TINYINT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

CREATE TABLE a_newsletter ( id INTEGER, site_id INTEGER, group_avail VARCHAR(255), name VARCHAR(255), description LONGTEXT, notes LONGTEXT, active TINYINT, display_signup TINYINT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_newsletter' doesn't exist

CREATE TABLE a_net_term ( id INTEGER, site_id INTEGER, status TINYINT, group_avail LONGTEXT, checkout_id INTEGER, name VARCHAR(16), sku VARCHAR(16), fee_type TINYINT, fee DOUBLE, suspend_intervals INTEGER, enable_emails TINYINT, sweep_type INTEGER, terms INTEGER )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 15

CREATE TABLE a_net_term ( id INTEGER, site_id INTEGER, status TINYINT, group_avail LONGTEXT, checkout_id INTEGER, name VARCHAR(16), sku VARCHAR(16), fee_type TINYINT, fee DOUBLE, suspend_intervals INTEGER, enable_emails TINYINT, sweep_type INTEGER, terms INTEGER )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_net_term' doesn't exist

CREATE TABLE a_newsletter_subscriber ( id BIGINT, site_id INTEGER, date_orig BIGINT, newsletter_id BIGINT, email VARCHAR(128), html TINYINT, first_name VARCHAR(128), last_name VARCHAR(128) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

CREATE TABLE a_newsletter_subscriber ( id BIGINT, site_id INTEGER, date_orig BIGINT, newsletter_id BIGINT, email VARCHAR(128), html TINYINT, first_name VARCHAR(128), last_name VARCHAR(128) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_newsletter_subscriber' doesn't exist

CREATE TABLE a_product ( id INTEGER, site_id INTEGER, date_orig BIGINT, date_last BIGINT, sku VARCHAR(32), taxable TINYINT, active TINYINT, position INTEGER, cart_multiple TINYINT, group_avail LONGTEXT, avail_category_id VARCHAR(255), host TINYINT, host_server_id INTEGER, host_provision_plugin_data LONGTEXT, host_allow_domain TINYINT, host_allow_host_only TINYINT, host_discount_tld LONGTEXT, host_discount_tld_amt DOUBLE, discount TINYINT, discount_amount DOUBLE, price_type INTEGER, price_base DOUBLE, price_setup DOUBLE, price_group LONGTEXT, price_recurr_default INTEGER, price_recurr_type TINYINT, price_recurr_weekday INTEGER, price_recurr_week INTEGER, price_recurr_schedule TINYINT, price_recurr_cancel TINYINT, price_trial_length_type INTEGER, price_trial_length INTEGER, price_trial_prod INTEGER, assoc_req_prod LONGTEXT, assoc_req_prod_type INTEGER, assoc_grant_prod LONGTEXT, assoc_grant_group LONGTEXT, assoc_grant_group_type INTEGER, assoc_grant_group_days INTEGER, thumbnail VARCHAR(128), prod_plugin TINYINT, prod_plugin_file VARCHAR(128), prod_plugin_data LONGTEXT, price_recurr_modify TINYINT, modify_waive_setup TINYINT, modify_product_arr LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 48

CREATE TABLE a_product ( id INTEGER, site_id INTEGER, date_orig BIGINT, date_last BIGINT, sku VARCHAR(32), taxable TINYINT, active TINYINT, position INTEGER, cart_multiple TINYINT, group_avail LONGTEXT, avail_category_id VARCHAR(255), host TINYINT, host_server_id INTEGER, host_provision_plugin_data LONGTEXT, host_allow_domain TINYINT, host_allow_host_only TINYINT, host_discount_tld LONGTEXT, host_discount_tld_amt DOUBLE, discount TINYINT, discount_amount DOUBLE, price_type INTEGER, price_base DOUBLE, price_setup DOUBLE, price_group LONGTEXT, price_recurr_default INTEGER, price_recurr_type TINYINT, price_recurr_weekday INTEGER, price_recurr_week INTEGER, price_recurr_schedule TINYINT, price_recurr_cancel TINYINT, price_trial_length_type INTEGER, price_trial_length INTEGER, price_trial_prod INTEGER, assoc_req_prod LONGTEXT, assoc_req_prod_type INTEGER, assoc_grant_prod LONGTEXT, assoc_grant_group LONGTEXT, assoc_grant_group_type INTEGER, assoc_grant_group_days INTEGER, thumbnail VARCHAR(128), prod_plugin TINYINT, prod_plugin_file VARCHAR(128), prod_plugin_data LONGTEXT, price_recurr_modify TINYINT, modify_waive_setup TINYINT, modify_product_arr LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_product' doesn't exist

ALTER TABLE a_product ADD INDEX sku (sku)
Error (install_sql-3): Table 'altdeutsch_billing.a_product' doesn't exist

ALTER TABLE a_product ADD INDEX active (active)
Error (install_sql-3): Table 'altdeutsch_billing.a_product' doesn't exist

CREATE TABLE a_product_attr ( id INTEGER, site_id INTEGER, product_id INTEGER, name VARCHAR(32), description VARCHAR(255), sort_order INTEGER, collect_type INTEGER, collect_default VARCHAR(255), required TINYINT, price_base DOUBLE, price_setup DOUBLE, price_group LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 14

CREATE TABLE a_product_attr ( id INTEGER, site_id INTEGER, product_id INTEGER, name VARCHAR(32), description VARCHAR(255), sort_order INTEGER, collect_type INTEGER, collect_default VARCHAR(255), required TINYINT, price_base DOUBLE, price_setup DOUBLE, price_group LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_product_attr' doesn't exist

ALTER TABLE a_product_attr ADD INDEX product (product_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_product_attr' doesn't exist

ALTER TABLE a_product_attr ADD INDEX type (collect_type)
Error (install_sql-3): Table 'altdeutsch_billing.a_product_attr' doesn't exist

CREATE TABLE a_product_cat ( id INTEGER, site_id INTEGER, parent_id INTEGER, group_avail LONGTEXT, name VARCHAR(32), notes VARCHAR(255), status TINYINT, template VARCHAR(128), thumbnail VARCHAR(128), image VARCHAR(128), position INTEGER, max INTEGER )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 14

CREATE TABLE a_product_cat ( id INTEGER, site_id INTEGER, parent_id INTEGER, group_avail LONGTEXT, name VARCHAR(32), notes VARCHAR(255), status TINYINT, template VARCHAR(128), thumbnail VARCHAR(128), image VARCHAR(128), position INTEGER, max INTEGER )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_product_cat' doesn't exist

ALTER TABLE a_product_cat ADD INDEX status (status)
Error (install_sql-3): Table 'altdeutsch_billing.a_product_cat' doesn't exist

ALTER TABLE a_product_cat ADD INDEX position (position)
Error (install_sql-3): Table 'altdeutsch_billing.a_product_cat' doesn't exist

ALTER TABLE a_product_cat ADD INDEX name (name)
Error (install_sql-3): Table 'altdeutsch_billing.a_product_cat' doesn't exist

CREATE TABLE a_product_cat_translate ( id INTEGER, site_id INTEGER, product_cat_id INTEGER, language_id VARCHAR(16), name VARCHAR(128), description LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8

CREATE TABLE a_product_cat_translate ( id INTEGER, site_id INTEGER, product_cat_id INTEGER, language_id VARCHAR(16), name VARCHAR(128), description LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_product_cat_translate' doesn't exist

CREATE TABLE a_product_img ( id INTEGER, site_id INTEGER, product_id INTEGER, type TINYINT, url VARCHAR(255), name VARCHAR(128) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8

CREATE TABLE a_product_img ( id INTEGER, site_id INTEGER, product_id INTEGER, type TINYINT, url VARCHAR(255), name VARCHAR(128) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_product_img' doesn't exist

ALTER TABLE a_product_img ADD INDEX product (product_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_product_img' doesn't exist

CREATE TABLE a_product_translate ( id INTEGER, site_id INTEGER, product_id INTEGER, language_id VARCHAR(16), name VARCHAR(128), description_short LONGTEXT, description_full LONGTEXT, email_template LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

CREATE TABLE a_product_translate ( id INTEGER, site_id INTEGER, product_id INTEGER, language_id VARCHAR(16), name VARCHAR(128), description_short LONGTEXT, description_full LONGTEXT, email_template LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_product_translate' doesn't exist

ALTER TABLE a_product_translate ADD INDEX product (product_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_product_translate' doesn't exist

ALTER TABLE a_product_translate ADD INDEX language (language_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_product_translate' doesn't exist

ALTER TABLE a_product_translate ADD INDEX name (name)
Error (install_sql-3): Table 'altdeutsch_billing.a_product_translate' doesn't exist

CREATE TABLE a_search ( id BIGINT, site_id BIGINT, date_orig BIGINT, date_expire BIGINT, session_id VARCHAR(32), account_id BIGINT, module VARCHAR(64), full_sql LONGTEXT, order_by VARCHAR(255), limit_no INTEGER, results INTEGER )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 13

CREATE TABLE a_search ( id BIGINT, site_id BIGINT, date_orig BIGINT, date_expire BIGINT, session_id VARCHAR(32), account_id BIGINT, module VARCHAR(64), full_sql LONGTEXT, order_by VARCHAR(255), limit_no INTEGER, results INTEGER )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_search' doesn't exist

ALTER TABLE a_search ADD INDEX expire (date_expire)
Error (install_sql-3): Table 'altdeutsch_billing.a_search' doesn't exist

ALTER TABLE a_search ADD INDEX sess (session_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_search' doesn't exist

ALTER TABLE a_search ADD INDEX acct (account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_search' doesn't exist

ALTER TABLE a_search ADD INDEX module (module)
Error (install_sql-3): Table 'altdeutsch_billing.a_search' doesn't exist

CREATE TABLE a_session ( id VARCHAR(32), site_id INTEGER, date_orig BIGINT, date_last BIGINT, date_expire BIGINT, logged TINYINT, ip VARCHAR(128), theme_id VARCHAR(32), country_id INTEGER, language_id VARCHAR(32), currency_id INTEGER, weight_id INTEGER, account_id BIGINT, reseller_id INTEGER, affiliate_id VARCHAR(32), campaign_id INTEGER, discounts VARCHAR(255), groups VARCHAR(255) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 20

CREATE TABLE a_session ( id VARCHAR(32), site_id INTEGER, date_orig BIGINT, date_last BIGINT, date_expire BIGINT, logged TINYINT, ip VARCHAR(128), theme_id VARCHAR(32), country_id INTEGER, language_id VARCHAR(32), currency_id INTEGER, weight_id INTEGER, account_id BIGINT, reseller_id INTEGER, affiliate_id VARCHAR(32), campaign_id INTEGER, discounts VARCHAR(255), groups VARCHAR(255) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_session' doesn't exist

ALTER TABLE a_session ADD INDEX expire (date_expire)
Error (install_sql-3): Table 'altdeutsch_billing.a_session' doesn't exist

ALTER TABLE a_session ADD INDEX logged (logged)
Error (install_sql-3): Table 'altdeutsch_billing.a_session' doesn't exist

ALTER TABLE a_session ADD INDEX account (account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_session' doesn't exist

ALTER TABLE a_session ADD INDEX campaign (campaign_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_session' doesn't exist

CREATE TABLE a_session_auth_cache ( id BIGINT, site_id BIGINT, session_id VARCHAR(32), date_expire BIGINT, group_arr LONGTEXT, menu_arr LONGTEXT, module_arr LONGTEXT, method_arr LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

CREATE TABLE a_session_auth_cache ( id BIGINT, site_id BIGINT, session_id VARCHAR(32), date_expire BIGINT, group_arr LONGTEXT, menu_arr LONGTEXT, module_arr LONGTEXT, method_arr LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_session_auth_cache' doesn't exist

ALTER TABLE a_session_auth_cache ADD INDEX session_id (session_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_session_auth_cache' doesn't exist

ALTER TABLE a_session_auth_cache ADD INDEX expire (date_expire)
Error (install_sql-3): Table 'altdeutsch_billing.a_session_auth_cache' doesn't exist

CREATE TABLE a_setup_email ( id INTEGER, site_id INTEGER, account_id BIGINT, name VARCHAR(128), notes LONGTEXT, type TINYINT, from_name VARCHAR(128), from_email VARCHAR(128), cc_list LONGTEXT, bcc_list LONGTEXT, server VARCHAR(128), username VARCHAR(128), password VARCHAR(128), piping VARCHAR(4), piping_host VARCHAR(128), piping_username VARCHAR(128), piping_password VARCHAR(128), piping_action VARCHAR(4), queue TINYINT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 21

CREATE TABLE a_setup_email ( id INTEGER, site_id INTEGER, account_id BIGINT, name VARCHAR(128), notes LONGTEXT, type TINYINT, from_name VARCHAR(128), from_email VARCHAR(128), cc_list LONGTEXT, bcc_list LONGTEXT, server VARCHAR(128), username VARCHAR(128), password VARCHAR(128), piping VARCHAR(4), piping_host VARCHAR(128), piping_username VARCHAR(128), piping_password VARCHAR(128), piping_action VARCHAR(4), queue TINYINT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_setup_email' doesn't exist

CREATE TABLE a_setup_invoice ( id INTEGER, site_id INTEGER, bill_to_company TINYINT, invoice_currency VARCHAR(8), invoice_decimals INTEGER, items_summary_max INTEGER, news TEXT, page_type INTEGER, invoice_delivery INTEGER, invoice_show_itemized TINYINT, invoice_show_service_dates TINYINT, invoice_grace INTEGER, invoice_advance_gen INTEGER, invoice_terms INTEGER, invoice_pdf_plugin VARCHAR(16), contact_us_url VARCHAR(64), contact_us_phone VARCHAR(64), advance_notice INTEGER )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 20

CREATE TABLE a_setup_invoice ( id INTEGER, site_id INTEGER, bill_to_company TINYINT, invoice_currency VARCHAR(8), invoice_decimals INTEGER, items_summary_max INTEGER, news TEXT, page_type INTEGER, invoice_delivery INTEGER, invoice_show_itemized TINYINT, invoice_show_service_dates TINYINT, invoice_grace INTEGER, invoice_advance_gen INTEGER, invoice_terms INTEGER, invoice_pdf_plugin VARCHAR(16), contact_us_url VARCHAR(64), contact_us_phone VARCHAR(64), advance_notice INTEGER )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_setup_invoice' doesn't exist

CREATE TABLE a_service ( id BIGINT, site_id INTEGER, date_orig BIGINT, date_last BIGINT, parent_id BIGINT, invoice_id BIGINT, invoice_item_id BIGINT, account_id BIGINT, account_billing_id BIGINT, product_id BIGINT, sku VARCHAR(32), active TINYINT, bind TINYINT, type VARCHAR(16), suspend_billing TINYINT, price DOUBLE, price_type INTEGER, taxable TINYINT, queue VARCHAR(16), date_last_invoice BIGINT, date_next_invoice BIGINT, recur_type INTEGER, recur_schedule INTEGER, recur_weekday INTEGER, recur_week INTEGER, recur_schedule_change TINYINT, recur_cancel VARCHAR(16), group_grant LONGTEXT, group_type INTEGER, group_days INTEGER, host_server_id INTEGER, host_provision_plugin_data LONGTEXT, host_ip VARCHAR(16), host_username VARCHAR(128), host_password VARCHAR(128), domain_name VARCHAR(128), domain_tld VARCHAR(16), domain_term INTEGER, domain_type VARCHAR(16), domain_date_expire BIGINT, domain_host_tld_id INTEGER, domain_host_registrar_id INTEGER, prod_attr LONGTEXT, prod_attr_cart LONGTEXT, prod_plugin_name VARCHAR(128), prod_plugin_data LONGTEXT, recur_modify TINYINT, invoice_advance_notified TINYINT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 50

CREATE TABLE a_service ( id BIGINT, site_id INTEGER, date_orig BIGINT, date_last BIGINT, parent_id BIGINT, invoice_id BIGINT, invoice_item_id BIGINT, account_id BIGINT, account_billing_id BIGINT, product_id BIGINT, sku VARCHAR(32), active TINYINT, bind TINYINT, type VARCHAR(16), suspend_billing TINYINT, price DOUBLE, price_type INTEGER, taxable TINYINT, queue VARCHAR(16), date_last_invoice BIGINT, date_next_invoice BIGINT, recur_type INTEGER, recur_schedule INTEGER, recur_weekday INTEGER, recur_week INTEGER, recur_schedule_change TINYINT, recur_cancel VARCHAR(16), group_grant LONGTEXT, group_type INTEGER, group_days INTEGER, host_server_id INTEGER, host_provision_plugin_data LONGTEXT, host_ip VARCHAR(16), host_username VARCHAR(128), host_password VARCHAR(128), domain_name VARCHAR(128), domain_tld VARCHAR(16), domain_term INTEGER, domain_type VARCHAR(16), domain_date_expire BIGINT, domain_host_tld_id INTEGER, domain_host_registrar_id INTEGER, prod_attr LONGTEXT, prod_attr_cart LONGTEXT, prod_plugin_name VARCHAR(128), prod_plugin_data LONGTEXT, recur_modify TINYINT, invoice_advance_notified TINYINT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX date (site_id, date_orig)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX parent (site_id, parent_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX invoice (site_id, invoice_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX invoice_item (site_id, invoice_item_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX account (site_id, account_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX billing (site_id, account_billing_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX sku (site_id, sku)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX active (site_id, active)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX type (site_id, type)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX suspend (site_id, suspend_billing)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX price (site_id, price)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX price_type (site_id, price_type)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX queue (site_id, queue)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX date_next (site_id, date_next_invoice)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX recur_type (site_id, recur_type)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX server (site_id, host_server_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX username (site_id, host_username)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX domain (site_id, domain_name, domain_tld)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

ALTER TABLE a_service ADD INDEX domain_date_expire (site_id, domain_date_expire)
Error (install_sql-3): Table 'altdeutsch_billing.a_service' doesn't exist

CREATE TABLE a_service_memo ( id BIGINT, site_id INTEGER, date_orig BIGINT, staff_id BIGINT, service_id BIGINT, type VARCHAR(32), memo VARCHAR(255), misc VARCHAR(32) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

CREATE TABLE a_service_memo ( id BIGINT, site_id INTEGER, date_orig BIGINT, staff_id BIGINT, service_id BIGINT, type VARCHAR(32), memo VARCHAR(255), misc VARCHAR(32) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_service_memo' doesn't exist

ALTER TABLE a_service_memo ADD INDEX service (service_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_service_memo' doesn't exist

ALTER TABLE a_service_memo ADD INDEX memo (memo)
Error (install_sql-3): Table 'altdeutsch_billing.a_service_memo' doesn't exist

CREATE TABLE a_staff ( id INTEGER, site_id INTEGER, date_orig BIGINT, staff VARCHAR(16), account_id BIGINT, department_avail VARCHAR(255), nickname VARCHAR(128), notify_new TINYINT, notify_change TINYINT, signature LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 12

CREATE TABLE a_staff ( id INTEGER, site_id INTEGER, date_orig BIGINT, staff VARCHAR(16), account_id BIGINT, department_avail VARCHAR(255), nickname VARCHAR(128), notify_new TINYINT, notify_change TINYINT, signature LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_staff' doesn't exist

CREATE TABLE a_staff_department ( id INTEGER, site_id INTEGER, name VARCHAR(32), description LONGTEXT, default_staff_id BIGINT, contact_display TINYINT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8

CREATE TABLE a_staff_department ( id INTEGER, site_id INTEGER, name VARCHAR(32), description LONGTEXT, default_staff_id BIGINT, contact_display TINYINT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_staff_department' doesn't exist

CREATE TABLE a_static_relation ( id INTEGER, site_id VARCHAR(16), static_var_id BIGINT, module_id INTEGER, default_value LONGTEXT, description VARCHAR(255), required TINYINT, sort_order INTEGER )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10

CREATE TABLE a_static_relation ( id INTEGER, site_id VARCHAR(16), static_var_id BIGINT, module_id INTEGER, default_value LONGTEXT, description VARCHAR(255), required TINYINT, sort_order INTEGER )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_static_relation' doesn't exist

ALTER TABLE a_static_relation ADD INDEX var (static_var_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_static_relation' doesn't exist

ALTER TABLE a_static_relation ADD INDEX module (module_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_static_relation' doesn't exist

ALTER TABLE a_static_relation ADD INDEX sort_order (sort_order)
Error (install_sql-3): Table 'altdeutsch_billing.a_static_relation' doesn't exist

CREATE TABLE a_static_var ( id INTEGER, site_id INTEGER, name VARCHAR(255), description VARCHAR(255), input_format VARCHAR(128), validation_type VARCHAR(128), convert_type VARCHAR(128) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

CREATE TABLE a_static_var ( id INTEGER, site_id INTEGER, name VARCHAR(255), description VARCHAR(255), input_format VARCHAR(128), validation_type VARCHAR(128), convert_type VARCHAR(128) )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_static_var' doesn't exist

ALTER TABLE a_static_var ADD INDEX name (name)
Error (install_sql-3): Table 'altdeutsch_billing.a_static_var' doesn't exist

CREATE TABLE a_static_var_record ( id BIGINT, site_id BIGINT, record_id BIGINT, module_id INTEGER, static_var_id INTEGER, static_var_relation_id INTEGER, value LONGTEXT )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

CREATE TABLE a_static_var_record ( id BIGINT, site_id BIGINT, record_id BIGINT, module_id INTEGER, static_var_id INTEGER, static_var_relation_id INTEGER, value LONGTEXT )TYPE=MyISAM
Error (install_sql-2): Table 'altdeutsch_billing.a_static_var_record' doesn't exist

ALTER TABLE a_static_var_record ADD INDEX record (record_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_static_var_record' doesn't exist

ALTER TABLE a_static_var_record ADD INDEX module (module_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_static_var_record' doesn't exist

ALTER TABLE a_static_var_record ADD INDEX var (static_var_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_static_var_record' doesn't exist

ALTER TABLE a_static_var_record ADD INDEX relation (static_var_relation_id)
Error (install_sql-3): Table 'altdeutsch_billing.a_static_var_record' doesn't exist

CREATE TABLE a_tax ( id INTEGER, site_id INTEGER, country_id INTEGER, zone VARCHAR(128), description VARCHAR(255), rate DOUBLE, tax_id_collect TINYINT, tax_id_name VARCHAR(32), tax_id_req TINYINT, tax_id_exempt TINYINT, tax_id_regex VARCHAR(255) )TYPE=MyISAM
Error (install_sql-1): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 13

CREATE TABLE a_tax ( id INTEGER, site_id INTEGER, country_id INTEGER, zone VARCHAR(128), description VARCHAR(255), rate DOUBLE, tax_id_collect TINYINT, tax_id_name VARCHAR(32), tax_id_req TINYINT, tax_id_exempt TINYINT, tax_id_regex VARCHAR(255) )TYPE=MyISAM
Error (install_sql-2): Table 'a

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.