jvm-2-80: alter table jvm_package modify commission varchar(50) not null default ''
jvm-2-80: alter table jvm_package modify commission_perclick varchar(50) not null default ''
jvm-2-80: alter table jvm_product modify commission varchar(50) not null default ''
jvm-2-80: alter table jvm_product modify charity_commission varchar(50) not null default ''
jvm-2-90: alter table jvm_purchase add camp_id varchar(50) not null
jvm-2-90: alter table jvm_purchase add order_id varchar(255) not null default ''
jvm-2-95: alter table jvm_product add mb_yes              INT(1) NOT NULL DEFAULT 0
jvm-2-95: alter table jvm_product add mb_email            VARCHAR(255) NOT NULL DEFAULT ''
jvm-2-95: alter table jvm_product add mb_subscr           INT(1) NOT NULL DEFAULT 0
jvm-2-95: alter table jvm_product add mb_rec_amount       VARCHAR(255) NOT NULL DEFAULT ''
jvm-2-95: alter table jvm_product add mb_rec_start        DATETIME NULL
jvm-2-95: alter table jvm_product add mb_rec_end          DATETIME NULL
jvm-2-95: alter table jvm_product add mb_rec_period       VARCHAR(255) NOT NULL DEFAULT ''
jvm-2-95: alter table jvm_product add sp_yes              INT(1) NOT NULL DEFAULT 0
jvm-2-95: alter table jvm_product add sp_email            VARCHAR(255) NOT NULL DEFAULT ''
jvm-2-95: alter table jvm_product add sp_subscr           INT(1) NOT NULL DEFAULT 0
jvm-2-95: alter table jvm_product add sp_recurrent_charge VARCHAR(30) NOT NULL DEFAULT ''
jvm-2-95: alter table jvm_product add sp_duration         VARCHAR(30) NOT NULL DEFAULT ''
jvm-2-95: alter table jvm_product add sp_trial_period     VARCHAR(30) NOT NULL DEFAULT ''
jvm-2-97: alter table jvm_product add f_deleted           INT(0) NOT NULL DEFAULT 0
jvm-3-00: alter table jvm_purchase add remote_ip          VARCHAR(50) NOT NULL DEFAULT ''
jvm-3-04: alter table jvm_speccomm add expire             DATE NULL
jvm-3-04: alter table jvm_product add speccomm_commission VARCHAR(50) NOT NULL DEFAULT ''
jvm-3-04: alter table jvm_product add speccomm_affgroup   INTEGER NOT NULL DEFAULT 0
jvm-3-04: alter table jvm_product add speccomm_expire     INTEGER NOT NULL DEFAULT 0
jvm-3-04: alter table jvm_purchase add buyer_aff_id       VARCHAR(20) NOT NULL DEFAULT ''
jvm-3-04: alter table jvm_product add paypal_trial_price  VARCHAR(20) NOT NULL DEFAULT ''
jvm-3-05: CREATE INDEX jvm_commission_pur_id ON jvm_commission(pur_id)
jvm-3-08: alter table jvm_user_affiliate add show_customers INTEGER NOT NULL DEFAULT 0
jvm-3-11: alter table jvm_conf_admin add subject_cust   VARCHAR(255) NOT NULL DEFAULT ''
jvm-3-11: alter table jvm_conf_admin add subject_aff   VARCHAR(255) NOT NULL DEFAULT ''
jvm-3-11: alter table jvm_user_affiliate add subject_subaff TEXT NOT NULL DEFAULT ''
jvm-3-11: alter table jvm_package add subject             VARCHAR(255) NOT NULL DEFAULT ''
jvm-3-11: alter table jvm_package add window_width        INT(11) NOT NULL DEFAULT 0
jvm-3-11: alter table jvm_package add window_height       INT(11) NOT NULL DEFAULT 0
jvm-3-11: alter table jvm_product add an_yes              INT(1) NOT NULL DEFAULT 0
jvm-3-11: alter table jvm_product add an_x_login          VARCHAR(30) NOT NULL DEFAULT ''
jvm-3-11: alter table jvm_package add templ_step1         TEXT NOT NULL DEFAULT ''
jvm-3-11: alter table jvm_package add templ_step2         TEXT NOT NULL DEFAULT ''
jvm-3-20: alter table jvm_conf_admin modify login         VARCHAR(50) NOT NULL DEFAULT 'test'
jvm-3-20: alter table jvm_conf_admin modify passwd        VARCHAR(50) NOT NULL DEFAULT '098f6bcd4621d373cade4e832627b4f6'
jvm-3-20: alter table jvm_conf_admin modify name          VARCHAR(255) NOT NULL DEFAULT 'Your Name'
jvm-3-20: alter table jvm_conf_admin modify email         VARCHAR(255) NOT NULL DEFAULT 'Your E-mail'
jvm-3-20: alter table jvm_conf_admin modify sitename      VARCHAR(255) NOT NULL DEFAULT 'The Site Name'
jvm-3-20: alter table jvm_conf_admin modify autoresp_cust VARCHAR(255) NOT NULL DEFAULT ''
jvm-3-20: alter table jvm_conf_admin modify autoresp_aff  VARCHAR(255) NOT NULL DEFAULT ''
jvm-3-20: alter table jvm_memsh modify email              VARCHAR(150) NOT NULL
jvm-3-20: alter table jvm_user_affiliate modify login     VARCHAR(50) NOT NULL
jvm-3-20: alter table jvm_user_affiliate modify passwd    VARCHAR(50) NOT NULL
jvm-3-20: alter table jvm_user_affiliate modify name      VARCHAR(255) NOT NULL DEFAULT ''
jvm-3-20: alter table jvm_user_affiliate modify email     VARCHAR(255) NOT NULL DEFAULT ''
jvm-3-20: alter table jvm_user_affiliate modify paypal_email  VARCHAR(255) NOT NULL DEFAULT ''
jvm-3-20: alter table jvm_user_affiliate modify autoresponder  VARCHAR(255) NOT NULL DEFAULT ''
jvm-3-20: alter table jvm_product add lp_yes              INT(1) NOT NULL DEFAULT 0
jvm-3-20: alter table jvm_product add lp_storename        VARCHAR(255) NOT NULL DEFAULT ''
jvm-3-20: alter table jvm_product add lp_subscr           INT(1) NOT NULL DEFAULT 0
jvm-3-20: alter table jvm_product add lp_subscr_unit      CHAR(1) NOT NULL DEFAULT ''
jvm-3-20: alter table jvm_product add lp_subscr_number    VARCHAR(20) NOT NULL DEFAULT ''
jvm-3-20: alter table jvm_product add lp_installments     VARCHAR(20) NOT NULL DEFAULT ''
jvm-3-20: alter table jvm_product add 2c_v2               INT(1) NOT NULL DEFAULT 0
jvm-3-20: alter table jvm_speccomm drop expire
jvm-3-20: alter table jvm_speccomm add memsh_assoc        INTEGER NOT NULL DEFAULT 0
jvm-3-20: alter table jvm_product drop speccomm_expire
jvm-3-20: alter table jvm_product add speccomm_affgroup2  INTEGER NOT NULL DEFAULT 0
jvm-3-20: alter table jvm_speccomm add move_to_affgroup   INTEGER NOT NULL DEFAULT 0
jvm-3-21: alter table jvm_affgroup add mail_per_period    INTEGER NOT NULL DEFAULT 0
jvm-3-21: alter table jvm_affgroup add mail_period        VARCHAR(10) NOT NULL DEFAULT 'week'
jvm-3-21: alter table jvm_affgroup add mail_footer        TEXT NOT NULL DEFAULT ''
jvm-3-21: alter table jvm_user_affiliate add no_upline_mail INT(1) NOT NULL DEFAULT 0
jvm-3-21: alter table jvm_package add enable_pay_to_aff   VARCHAR(255) NOT NULL DEFAULT ''
jvm-3-21: alter table jvm_purchase add external           INT(1) NOT NULL DEFAULT 0
jvm-3-21: alter table jvm_affgroup add enable_mail_downline INT(1) NOT NULL DEFAULT 0
jvm-3-21: alter table jvm_affgroup add enabled            INT(1) NOT NULL DEFAULT 1
jvm-3-21: alter table jvm_affgroup add enable_auto_accept INT(1) NOT NULL DEFAULT 1
jvm-3-22: alter table jvm_affgroup add show_customers     INTEGER NOT NULL DEFAULT 1
jvm-3-22: alter table jvm_shorten_url add owner_id        INTEGER NOT NULL DEFAULT 0
jvm-3-22: alter table jvm_product add f_exportable        INT(0) NOT NULL DEFAULT 1
jvm-3-22: alter table jvm_memsh add pur_id                INTEGER NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_rewardsa add owner_id           INTEGER NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_affgroup add owner_id           INTEGER NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_ban add owner_id                INTEGER NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_commission add owner_id         INTEGER NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_package add owner_id            INTEGER NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_product add owner_id            INTEGER NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_purchase add owner_id           INTEGER NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_speccomm add owner_id           INTEGER NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_user_affiliate add owner_id     INTEGER NOT NULL DEFAULT 1
jvm-4-00: create index owner_id on jvm_rewardsa(owner_id)
jvm-4-00: create index owner_id on jvm_affgroup(owner_id)
jvm-4-00: drop index enabled on jvm_ban
jvm-4-00: create index owner_id on jvm_ban(owner_id,enabled)
jvm-4-00: drop index aff_id on jvm_commission
jvm-4-00: create index owner_id on jvm_commission(owner_id,aff_id)
jvm-4-00: create index owner_id on jvm_package(owner_id)
jvm-4-00: create index owner_id on jvm_product(owner_id)
jvm-4-00: create index owner_id on jvm_purchase(owner_id)
jvm-4-00: drop index aff_id on jvm_speccomm
jvm-4-00: create index owner_id on jvm_speccomm(owner_id,aff_id)
jvm-4-00: drop index patron_id on jvm_user_affiliate
jvm-4-00: create index owner_id on jvm_user_affiliate(owner_id,patron_id)
jvm-4-00: alter table jvm_campaign add owner_id           INTEGER NOT NULL DEFAULT 1
jvm-4-00: create index owner_id on jvm_campaign(owner_id,aff_id)
jvm-4-00: alter table jvm_downline_mlcnt add owner_id     INTEGER NOT NULL DEFAULT 1
jvm-4-00: drop index aff_id on jvm_downline_mlcnt
jvm-4-00: create index owner_id on jvm_downline_mlcnt(owner_id,aff_id)
jvm-4-00: alter table jvm_shorten_url change owner_id aff_id INTEGER NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_shorten_url add owner_id        INTEGER NOT NULL DEFAULT 1
jvm-4-00: create index owner_id on jvm_shorten_url(owner_id,aff_id)
jvm-4-00: drop index owner_id on jvm_payment_processor
jvm-4-00: alter table jvm_payment_processor change owner_id aff_id INTEGER NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_payment_processor add owner_id  INTEGER NOT NULL DEFAULT 1
jvm-4-00: create index owner_id on jvm_payment_processor(owner_id,aff_id)
jvm-4-00: rename table jvm_conf_admin to jvm_user_admin
jvm-4-00: alter table jvm_product add ppap_yes            INT(1) NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_product add ppap_priv           TEXT NOT NULL DEFAULT ''
jvm-4-00: alter table jvm_product change memsh_expire validdays INTEGER NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_speccomm change memsh_assoc pur_id INTEGER NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_speccomm add expire             DATE NULL
jvm-4-00: alter table jvm_user_admin add priv           TEXT NOT NULL DEFAULT ''
jvm-4-00: alter table jvm_user_admin add expire         DATE NULL
jvm-4-00: alter table jvm_user_admin add owner_id           INTEGER NOT NULL DEFAULT 0
jvm-4-00: create index owner_id on jvm_user_admin(owner_id)
jvm-4-00: alter table jvm_user_admin add pur_id         INTEGER NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_package add templ_step1_c       TEXT NOT NULL DEFAULT ''
jvm-4-00: alter table jvm_package add templ_step2_c       TEXT NOT NULL DEFAULT ''
jvm-4-00: alter table jvm_product add export_yes          INT(1) NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_product add export_price        DECIMAL(7,2) NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_purchase add   buyer_reseller_id VARCHAR(20) NOT NULL DEFAULT ''
jvm-4-00: alter table jvm_memsh drop email
jvm-4-00: alter table jvm_memsh drop password
jvm-4-00: alter table jvm_memsh add cust_id INTEGER NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_purchase add   renew_pur_id       INTEGER NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_paylog drop id
jvm-4-00: alter table jvm_purchase add subscr_id          VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-00: alter table jvm_purchase add subscr_not_initial INT(1) NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_purchase add descr_more         VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-00: alter table jvm_purchase add fraud    INT(1) NOT NULL DEFAULT 0
jvm-4-00: alter table jvm_template add header_def                       INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add footer_def                       INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add purchase_go_def                  INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add purchase_first_def               INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add mail_purchase_paid_admin_def     INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add mail_purchase_paid_owner_def     INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add mail_purchase_comm_made_def      INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add mail_purchase_comm_refund_def    INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add mail_user_register_def           INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add mail_user_register_confirmed_def INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add mail_user_change_def             INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add mail_user_remindpasswd_def       INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add mail_user_imported_def           INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_package add templ_step1_def     INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_package add templ_step2_def     INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add mail_customer_password     TEXT NOT NULL DEFAULT ''
jvm-4-00: alter table jvm_template add mail_customer_password_c   TEXT NOT NULL DEFAULT ''
jvm-4-00: alter table jvm_template add mail_customer_password_def INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_template add mail_purchase_paid_customer      TEXT NOT NULL DEFAULT ''
jvm-4-00: alter table jvm_template add mail_purchase_paid_customer_c    TEXT NOT NULL DEFAULT ''
jvm-4-00: alter table jvm_template add mail_purchase_paid_customer_def  INT(1) NOT NULL DEFAULT 1
jvm-4-00: alter table jvm_user_admin add instructions_aff VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-05: alter table jvm_product add   no_renewal          INT(1) NOT NULL DEFAULT 0
jvm-4-05: alter table jvm_product add   no_customer_area          INT(1) NOT NULL DEFAULT 0
jvm-4-05: alter table jvm_purchase add   no_renewal          INT(1) NOT NULL DEFAULT 0
jvm-4-05: alter table jvm_purchase add   no_customer_area          INT(1) NOT NULL DEFAULT 0
jvm-4-05: alter table jvm_affgroup add   co_groups            VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-05: alter table jvm_product change speccomm_affgroup speccomm_obj_id     INTEGER NOT NULL DEFAULT 0
jvm-4-05: alter table jvm_product change speccomm_affgroup2 speccomm_move_to_affgroup INTEGER NOT NULL DEFAULT 0
jvm-4-05: alter table jvm_product add   speccomm_type       VARCHAR(30) NOT NULL DEFAULT 'affgroup'
jvm-4-05: alter table jvm_product add   sp_setup_fee        VARCHAR(30) NOT NULL DEFAULT ''
jvm-4-14: alter table jvm_product add paypal_ipn_forward_url     varchar(255) not null default ''
jvm-4-14: alter table jvm_product add paypal_ipn_forward_trials  int(3) not null default 3
jvm-4-14: alter table jvm_purchase_log rename to jvm_syslog
jvm-4-14: alter table jvm_syslog add type varchar(50) not null default 'PURCHASE'
jvm-4-14: drop index pur_id on jvm_syslog
jvm-4-14: alter table jvm_syslog change pur_id obj_id integer not null
jvm-4-15: alter table jvm_user_affiliate add welcome_subaff_subject VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-15: alter table jvm_affgroup add no_downline          INTEGER NOT NULL DEFAULT 0
jvm-4-15: alter table jvm_ban add  note                TEXT NOT NULL DEFAULT ''
jvm-4-20: alter table jvm_user_affiliate add stormpay_email  VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-20: alter table jvm_product add   limitorders         VARCHAR(50) NOT NULL DEFAULT ''
jvm-4-20: alter table jvm_product add   numorders         VARCHAR(50) NOT NULL DEFAULT ''
jvm-4-20: alter table jvm_product add  remmemsh_url        VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-20: alter table jvm_product add  remmemsh_serv   VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-20: alter table jvm_product add  remmemsh_user   VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-20: alter table jvm_product add  remmemsh_pass   VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-20: alter table jvm_product add  remmemsh_dir    VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-20: alter table jvm_template add  mail_purchase_comm_made_recur    TEXT NOT NULL DEFAULT ''
jvm-4-20: alter table jvm_template add  mail_purchase_comm_made_recur_c  TEXT NOT NULL DEFAULT ''
jvm-4-20: alter table jvm_template add  mail_purchase_comm_made_recur_def INT(1) NOT NULL DEFAULT 1
jvm-4-25: alter table jvm_product add garantee_no_for_recur INT(1) NOT NULL DEFAULT 0
jvm-4-26: alter table jvm_product add  jvmsub_use_with       VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-26: alter table jvm_product add  jvmsub_trial_length   VARCHAR(20) NOT NULL DEFAULT ''
jvm-4-26: alter table jvm_product add  jvmsub_trial_unit     CHAR(1) NOT NULL DEFAULT ''
jvm-4-26: alter table jvm_product add  jvmsub_trial_price    VARCHAR(20) NOT NULL DEFAULT ''
jvm-4-26: alter table jvm_product add  jvmsub_subscr_numinst VARCHAR(20) NOT NULL DEFAULT ''
jvm-4-26: alter table jvm_product add  jvmsub_subscr_length  VARCHAR(20) NOT NULL DEFAULT ''
jvm-4-26: alter table jvm_product add  jvmsub_subscr_unit    CHAR(1) NOT NULL DEFAULT ''
jvm-4-26: create index subscr_id on jvm_purchase(owner_id,subscr_id)
jvm-4-26: alter table jvm_purchase add subscr_inst_number INTEGER NULL
jvm-4-27: alter table jvm_product add   lp_certfile         VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-28: alter table jvm_product add   checked_by_default  INT(0) NOT NULL DEFAULT 0
jvm-4-29: alter table jvm_package add  f_jv                INT(1) NOT NULL DEFAULT 0
jvm-4-29: alter table jvm_package add  jv_min_price        DECIMAL(7,2) NOT NULL DEFAULT 0
jvm-4-29: alter table jvm_package add  jv_max_price        DECIMAL(7,2) NOT NULL DEFAULT 0
jvm-4-29: alter table jvm_package add  jv_max_num          INTEGER NULL
jvm-4-29: alter table jvm_package add  jv_status           VARCHAR(50) NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_package add  jv_status_notify    INT(1) NOT NULL DEFAULT 0
jvm-4-29: alter table jvm_package add  jv_admin_commission VARCHAR(50) NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_package add  jv_admin_paypal_address VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_product add  f_jv                INT(1) NOT NULL DEFAULT 0
jvm-4-29: alter table jvm_product add   jv_aff_id           INTEGER NOT NULL DEFAULT 0
jvm-4-29: alter table jvm_product add  jv_status           VARCHAR(50) NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_product add  jv_status_notify    INT(1) NOT NULL DEFAULT 0
jvm-4-29: alter table jvm_product add  jv_admin_commission VARCHAR(50) NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_product add  jv_admin_paypal_address VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_template add  mail_jv_package_activated        TEXT NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_template add  mail_jv_package_activated_c      TEXT NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_template add  mail_jv_package_activated_def    INT(1) NOT NULL DEFAULT 1
jvm-4-29: alter table jvm_template add  mail_jv_package_deactivated      TEXT NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_template add  mail_jv_package_deactivated_c    TEXT NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_template add  mail_jv_package_deactivated_def  INT(1) NOT NULL DEFAULT 1
jvm-4-29: alter table jvm_template add  mail_jv_product_approved         TEXT NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_template add  mail_jv_product_approved_c       TEXT NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_template add  mail_jv_product_approved_def     INT(1) NOT NULL DEFAULT 1
jvm-4-29: alter table jvm_template add  mail_jv_product_reqmod           TEXT NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_template add  mail_jv_product_reqmod_c         TEXT NOT NULL DEFAULT ''
jvm-4-29: alter table jvm_template add  mail_jv_product_reqmod_def       INT(1) NOT NULL DEFAULT 1
jvm-4-30: alter table jvm_affgroup add  allow_jv_package     int(1) not null default 0
jvm-4-30: alter table jvm_affgroup add  jv_package_instr_url varchar(255) not null default ''
jvm-4-31: alter table jvm_user_admin add  secure_url     VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-31: alter table jvm_template add  mail_jv_product_changed          TEXT NOT NULL DEFAULT ''
jvm-4-31: alter table jvm_template add  mail_jv_product_changed_c        TEXT NOT NULL DEFAULT ''
jvm-4-31: alter table jvm_template add  mail_jv_product_changed_def      INT(1) NOT NULL DEFAULT 1
jvm-4-31: alter table jvm_template add  affreg_header                    TEXT NOT NULL DEFAULT ''
jvm-4-31: alter table jvm_template add  affreg_header_c                  TEXT NOT NULL DEFAULT ''
jvm-4-31: alter table jvm_template add  affreg_header_def                INT(1) NOT NULL DEFAULT 1
jvm-4-31: alter table jvm_template add  affreg_footer                    TEXT NOT NULL DEFAULT ''
jvm-4-31: alter table jvm_template add  affreg_footer_c                  TEXT NOT NULL DEFAULT ''
jvm-4-31: alter table jvm_template add  affreg_footer_def                INT(1) NOT NULL DEFAULT 1
jvm-4-31: alter table jvm_affgroup add  templ_header         TEXT NOT NULL DEFAULT ''
jvm-4-31: alter table jvm_affgroup add  templ_header_c       TEXT NOT NULL DEFAULT ''
jvm-4-31: alter table jvm_affgroup add  templ_header_def     INT(1) NOT NULL DEFAULT 1
jvm-4-31: alter table jvm_affgroup add  templ_footer         TEXT NOT NULL DEFAULT ''
jvm-4-31: alter table jvm_affgroup add  templ_footer_c       TEXT NOT NULL DEFAULT ''
jvm-4-31: alter table jvm_affgroup add  templ_footer_def     INT(1) NOT NULL DEFAULT 1
jvm-4-31: alter table jvm_product add   available_till      DATETIME NULL
jvm-4-32: alter table jvm_template add  aff_hp_header                    TEXT NOT NULL DEFAULT ''
jvm-4-32: alter table jvm_template add  aff_hp_header_c                  TEXT NOT NULL DEFAULT ''
jvm-4-32: alter table jvm_template add  aff_hp_header_def                INT(1) NOT NULL DEFAULT 1
jvm-4-32: alter table jvm_template add  aff_hp_footer                    TEXT NOT NULL DEFAULT ''
jvm-4-32: alter table jvm_template add  aff_hp_footer_c                  TEXT NOT NULL DEFAULT ''
jvm-4-32: alter table jvm_template add  aff_hp_footer_def                INT(1) NOT NULL DEFAULT 1
jvm-4-32: alter table jvm_template add  cust_hp_header                    TEXT NOT NULL DEFAULT ''
jvm-4-32: alter table jvm_template add  cust_hp_header_c                  TEXT NOT NULL DEFAULT ''
jvm-4-32: alter table jvm_template add  cust_hp_header_def                INT(1) NOT NULL DEFAULT 1
jvm-4-32: alter table jvm_template add  cust_hp_footer                    TEXT NOT NULL DEFAULT ''
jvm-4-32: alter table jvm_template add  cust_hp_footer_c                  TEXT NOT NULL DEFAULT ''
jvm-4-32: alter table jvm_template add  cust_hp_footer_def                INT(1) NOT NULL DEFAULT 1
jvm-4-32: alter table jvm_product add no_reorder          INT(1) NOT NULL DEFAULT 0
jvm-4-32: alter table jvm_affgroup add   enable_cust_autoresp INT(1) NOT NULL DEFAULT 0
jvm-4-32: alter table jvm_user_affiliate add    autoresp_cust  VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-32: alter table jvm_user_affiliate add    subject_cust   TEXT NOT NULL DEFAULT ''
jvm-4-32: alter table jvm_product add  oto_title           varchar(255) not null default ''
jvm-4-32: alter table jvm_product add  oto_descr           text not null default ''
jvm-4-32: alter table jvm_product add  oto_paylink_url     varchar(255) not null default ''
jvm-4-32: alter table jvm_product add  oto_paylink_title   varchar(255) not null default ''
jvm-4-32: alter table jvm_product add  oto_paylink_style   varchar(30) not null default ''
jvm-4-32: alter table jvm_purchase add   oto_shown           INT(1) NOT NULL DEFAULT 0
jvm-4-32: CREATE TABLE jvm_privpack (id INTEGER NOT NULL PRIMARY KEY, owner_id INTEGER NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL, priv TEXT NOT NULL DEFAULT '', KEY(owner_id))
jvm-4-32: alter table jvm_user_admin add   pp_id          INTEGER NOT NULL DEFAULT 0
jvm-4-32: alter table jvm_product add  ppap_pp_id          INTEGER NOT NULL DEFAULT 0
jvm-4-32: update jvm_user_admin set pp_id=id where id!=1
jvm-4-32: insert into jvm_privpack (id,owner_id,name,priv) select id,owner_id,concat('Privilege package for Reseller #',id),priv from jvm_user_admin where id!=1
jvm-4-32: alter table jvm_user_admin add   active         INT(1) NOT NULL DEFAULT 1
jvm-4-33: alter table jvm_package add  sc_catz             VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-33: alter table jvm_package add  sc_descr            TEXT NOT NULL DEFAULT ''
jvm-4-33: alter table jvm_package add   sc_sortdate         DATETIME NULL
jvm-4-33: alter table jvm_purchase add  is_sc_consolidated INT(1) NOT NULL DEFAULT 0
jvm-4-33: alter table jvm_purchase add  is_sc       INT(1) NOT NULL DEFAULT 0
jvm-4-33: alter table jvm_template add  purchase_thank                   TEXT NOT NULL DEFAULT ''
jvm-4-33: alter table jvm_template add  purchase_thank_c                 TEXT NOT NULL DEFAULT ''
jvm-4-33: alter table jvm_template add  purchase_thank_def               INT(1) NOT NULL DEFAULT 1
jvm-4-33: alter table jvm_template add  sct                              TEXT NOT NULL DEFAULT ''
jvm-4-33: alter table jvm_template add  sct_c                            TEXT NOT NULL DEFAULT ''
jvm-4-33: alter table jvm_template add  sct_def                          INT(1) NOT NULL DEFAULT 1
jvm-4-34: create index email on jvm_user_admin(email)
jvm-4-34: create index email on jvm_user_affiliate(email)
jvm-4-34: alter table jvm_template add  mail_coupon_cust                 TEXT NOT NULL DEFAULT ''
jvm-4-34: alter table jvm_template add  mail_coupon_cust_c               TEXT NOT NULL DEFAULT ''
jvm-4-34: alter table jvm_template add  mail_coupon_cust_def             INT(1) NOT NULL DEFAULT 1
jvm-4-34: alter table jvm_template add  mail_coupon_aff                  TEXT NOT NULL DEFAULT ''
jvm-4-34: alter table jvm_template add  mail_coupon_aff_c                TEXT NOT NULL DEFAULT ''
jvm-4-34: alter table jvm_template add  mail_coupon_aff_def              INT(1) NOT NULL DEFAULT 1
jvm-4-34: alter table jvm_purchase add  coupon_code         char(16) not null default 0
jvm-4-34: alter table jvm_purchase add  coupon_discount     varchar(50) not null default ''
jvm-4-34: alter table jvm_package add  templ_thank         TEXT NOT NULL DEFAULT ''
jvm-4-34: alter table jvm_package add  templ_thank_c       TEXT NOT NULL DEFAULT ''
jvm-4-34: alter table jvm_package add  templ_thank_def     INT(1) NOT NULL DEFAULT ''
jvm-4-35: alter table jvm_product add  point_cust_obtain         integer null
jvm-4-35: alter table jvm_product add  point_cust_obtain_subscr  int(1) not null default 0
jvm-4-35: alter table jvm_product add  point_cust_cash           integer null
jvm-4-35: alter table jvm_product add  point_aff_obtain          integer null
jvm-4-35: alter table jvm_product add  point_aff_obtain_subscr   int(1) not null default 0
jvm-4-35: alter table jvm_purchase add   points_cashed       varchar(50) not null default ''
jvm-4-35: alter table jvm_product add  pointap_yes         int(1) not null default 0
jvm-4-35: alter table jvm_product add  pointap_amount      varchar(20) not null default ''
jvm-4-35: alter table jvm_package add   no_affiliate_area   int(1) not null default 0
jvm-4-35: alter table jvm_template add  purchase_go_inc                  TEXT NOT NULL DEFAULT ''
jvm-4-35: alter table jvm_template add  purchase_go_inc_c                TEXT NOT NULL DEFAULT ''
jvm-4-35: alter table jvm_template add  purchase_go_inc_def              INT(1) NOT NULL DEFAULT 1
jvm-4-35: alter table jvm_package add  templ_step1_inc     TEXT NOT NULL DEFAULT ''
jvm-4-35: alter table jvm_package add  templ_step1_inc_c   TEXT NOT NULL DEFAULT ''
jvm-4-35: alter table jvm_package add  templ_step1_inc_def INT(1) NOT NULL DEFAULT 1
jvm-4-35: alter table jvm_coupon_batch add  auto_code          varchar(255) not null default 0
jvm-4-35: alter table jvm_coupon_batch add  type               varchar(20) not null default ''
jvm-4-35: update jvm_coupon_batch set type='single' where type=''
jvm-4-35: alter table jvm_coupon modify code                varchar(255) not null not null
jvm-4-36: ALTER TABLE jvm_product ADD FULLTEXT searchIndex(title,descr)
jvm-4-36: alter table jvm_product add  get_username        VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-36: alter table jvm_product add  get_password        VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-36: alter table jvm_link add  username            VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-36: alter table jvm_link add  password            VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-36: alter table jvm_purchase add   points_earned       varchar(50) not null default ''
jvm-4-38: alter table jvm_user_customer add   name                varchar(255) not null default ''
jvm-4-38: alter table jvm_user_affiliate add     force_2tier INT(1) NOT NULL DEFAULT 0
jvm-4-38: alter table jvm_product add  avail_target_cust       integer not null default 0;
jvm-4-39: alter table jvm_product add   an_txn_key        VARCHAR(255) NOT NULL DEFAULT ''
jvm-4-42: alter table jvm_alert add type varchar(50) not null default 'admin'
jvm-4-42: alter table jvm_alert drop id
jvm-4-44: create index jvm_ban_type_ban on jvm_ban(owner_id,type,ban)
jvm-4-45: alter table jvm_product modify oto_descr longtext not null default ''
jvm-4-45: alter table jvm_oto modify descr longtext not null default ''
jvm-4-45: alter table jvm_memsh add owner_id INTEGER NOT NULL DEFAULT 1
jvm-4-45: alter table jvm_remmemsh add owner_id INTEGER NOT NULL DEFAULT 0
jvm-4-45: create table jvm_remmemsh_cpy select r.id,if(p.owner_id,p.owner_id,1) as owner_id,r.pur_id,r.url,r.cust_id,r.expire,r.ftp_server,r.ftp_username,r.ftp_password,r.ftp_directory from jvm_remmemsh as r left join jvm_purchase as p on p.id=r.pur_id
jvm-4-45: delete from jvm_remmemsh
jvm-4-45: insert into jvm_remmemsh (id,owner_id,pur_id,url,cust_id,expire,ftp_server,ftp_username,ftp_password,ftp_directory) select * from jvm_remmemsh_cpy
jvm-4-49: alter table jvm_product add 2c_secret           VARCHAR(255) NOT NULL DEFAULT ''