[Mon Sep 19 15:26:03 2011] StartLog OK profile installer.profile.delavo.install [Mon Sep 19 15:26:03 2011] MySQLCheck OK [Mon Sep 19 15:26:03 2011] FileExists OK delavo/jin.cgi [Mon Sep 19 15:26:03 2011] FileMkdir OK delavo [Mon Sep 19 15:26:05 2011] ArchUnzip OK /home/resale/public_html/delavo/delavo.zip /home/resale/public_html/delavo/delavo/ [Mon Sep 19 15:26:10 2011] MySQLImport SQL OK: # JIN SQL SCHEMA # # USER create table jin_user ( id int(11) not null primary key, owner_id int(11) not null, signature char(16) not null, registered int(1) not null default 0, ownership_id int(11) not null, referer_id int(11) not null default 0, regtime datetime null, sestime datetime null, reg_ip varchar(32) not null default '', points int(11) not null default 0, email varchar(255) not null, passwd varchar(255) not null, fname varchar(255) not null default '', lname varchar(255) not null default '', name varchar(255) not null default '', address varchar(255) not null default '', city varchar(255) not null default '', state varchar(255) not null default '', zipcode varchar(255) not null default '', country varchar(255) not null default '', url varchar(255) not null default '', company varchar(255) not null default '', phone varchar(255) not null default '', checks varchar(255) not null default '', tax_id varchar(255) not null default '', pg_paypal_email varchar(255) not null default '', cb_aff_id varchar(150) not null default '', no_admin_mail int(1) not null default 0, no_upline_mail int(1) not null default 0, # gone in v1.14 2008-06-01 # sitename varchar(255) not null default '', # turboaffid varchar(255) not null default '', # help_url_forum varchar(255) not null default '', # help_url_helpdesk varchar(255) not null default '', admin_notes text not null default '', ext_id int(11) not null default 0, unique key(owner_id,email), key(email), key(reg_ip) ) [Mon Sep 19 15:26:11 2011] MySQLImport SQL OK: create table jin_merchant_settings ( id int(11) not null primary key, owner_id int(11) not null, sitename varchar(255) not null default '', from_name varchar(255) not null default '', from_email varchar(255) not null default '', turboaffid varchar(255) not null default '', help_url_forum varchar(255) not null default '', help_url_helpdesk varchar(255) not null default '', # gone in v1.14 2008-06-01 # pg_paypal_email varchar(255) not null default '', autoresp_ma2cust_ids varchar(255) not null default '', autoresp_me2cust_ids varchar(255) not null default '', autoresp_me2refered_ids varchar(255) not null default '', # gone in v1.12 2008-02-10 # welcomem_ma2cust_ids varchar(255) not null default '', # welcomem_me2refered_ids varchar(255) not null default '', email_ma2cust text not null default '', email_me2refered text not null default '', email_for_errormsg text not null default '', # gone in v1.14 2008-06-01 # no_admin_mail int(1) not null default 0, # no_upline_mail int(1) not null default 0, currency char(3) not null, limit_user_reg_ip int(4) not null default 0, aff_cookie_mode int(1) not null default 0, welcome_screen text not null default '', labelling text not null default '', key(owner_id) ) [Mon Sep 19 15:26:11 2011] MySQLImport SQL OK: # # ROLES create table jin_role ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', autoassign int(1) not null default 0, needapproval int(1) not null default 0, priv_supervisor int(1) not null default 0, # gone in v1.18 2008-12-17 # priv_master_store_pgates int(1) not null default 0, priv_master_store_packages int(1) not null default 0, priv_master_store_products int(1) not null default 0, priv_master_store_minisites int(1) not null default 0, priv_master_store_jvproducts int(1) not null default 0, priv_master_store_specprices int(1) not null default 0, priv_master_store_shopcarts int(1) not null default 0, priv_master_store_otos int(1) not null default 0, priv_master_store_downloads int(1) not null default 0, priv_master_store_brandpdfs int(1) not null default 0, priv_master_store_memberships int(1) not null default 0, # gone in v2.0 # priv_master_store_lmems int(1) not null default 0, # priv_master_store_rmems int(1) not null default 0, # priv_master_store_cmsmems int(1) not null default 0, priv_master_store_quests int(1) not null default 0, priv_master_store_extscripts int(1) not null default 0, priv_master_store_taxes int(1) not null default 0, priv_master_store_shippings int(1) not null default 0, priv_master_customers_sales int(1) not null default 0, # gone in v2.0 # priv_master_customers_orders int(1) not null default 0, priv_master_customers_actsubs int(1) not null default 0, priv_master_customers_memberships int(1) not null default 0, # gone in v2.0 # priv_master_customers_lmems int(1) not null default 0, # priv_master_customers_rmems int(1) not null default 0, # priv_master_customers_cmsmems int(1) not null default 0, priv_master_customers_quests int(1) not null default 0, priv_master_customers_extscripts int(1) not null default 0, priv_master_customers_jvmsubs int(1) not null default 0, priv_master_customers_shipdue int(1) not null default 0, priv_master_affiliates_users int(1) not null default 0, priv_master_affiliates_affprogs int(1) not null default 0, priv_master_affiliates_series int(1) not null default 0, priv_master_affiliates_commissions int(1) not null default 0, priv_master_affiliates_paycomms int(1) not null default 0, priv_master_resellers_users int(1) not null default 0, priv_master_resellers_settings int(1) not null default 0, priv_master_resellers_resprogs int(1) not null default 0, priv_master_resellers_royalties int(1) not null default 0, priv_master_users_all int(1) not null default 0, priv_master_users_massmail int(1) not null default 0, priv_master_users_massuserop int(1) not null default 0, priv_master_users_roles int(1) not null default 0, priv_master_users_specusers int(1) not null default 0, priv_master_users_downlines int(1) not null default 0, priv_master_users_import int(1) not null default 0, priv_master_users_invite int(1) not null default 0, priv_master_users_approve int(1) not null default 0, priv_master_tools_stats int(1) not null default 0, priv_master_tools_templates int(1) not null default 0, priv_master_tools_emails int(1) not null default 0, priv_master_tools_customtags int(1) not null default 0, priv_master_tools_forms int(1) not null default 0, priv_master_tools_bans int(1) not null default 0, priv_master_tools_coupons int(1) not null default 0, priv_master_tools_rewards int(1) not null default 0, priv_master_tools_shorturls int(1) not null default 0, priv_master_tools_export int(1) not null default 0, # gone in v2.0 # priv_master_tools_exportpieces int(1) not null default 0, # priv_master_tools_importpieces int(1) not null default 0, # priv_master_tools_exportcomms int(1) not null default 0, priv_master_tools_pieces int(1) not null default 0, priv_master_tools_apiuser int(1) not null default 0, # gone in v2.0 # priv_master_tools_extscripts int(1) not null default 0, priv_master_plugins_invoicepdfs int(1) not null default 0, priv_master_plugins_promogen int(1) not null default 0, priv_master_plugins_sponsorships int(1) not null default 0, priv_master_plugins_supros int(1) not null default 0, priv_master_plugins_banners int(1) not null default 0, priv_master_plugins_linkdirs int(1) not null default 0, priv_master_plugins_alerts int(1) not null default 0, priv_master_plugins_testimonials int(1) not null default 0, priv_master_plugins_followupman int(1) not null default 0, priv_master_plugins_jvevents int(1) not null default 0, priv_master_plugins_affinbs int(1) not null default 0, priv_master_plugins_pages int(1) not null default 0, priv_master_plugins_geoforce int(1) not null default 0, priv_master_plugins_blogpub int(1) not null default 0, priv_master_plugins_bcastnews int(1) not null default 0, priv_master_plugins_certman int(1) not null default 0, priv_master_plugins_clouds int(1) not null default 0, priv_master_plugins_multrec int(1) not null default 0, priv_master_plugins_reminders int(1) not null default 0, priv_master_plugins_helptickets int(1) not null default 0, priv_master_plugins_metaaffs int(1) not null default 0, priv_member_account_purchases int(1) not null default 0, priv_member_account_mems int(1) not null default 0, priv_member_account_jvmsubs int(1) not null default 0, priv_member_account_points int(1) not null default 0, priv_member_account_helptickets int(1) not null default 0, priv_member_promote_affprogs int(1) not null default 0, priv_member_promote_links int(1) not null default 0, priv_member_promote_campaigns int(1) not null default 0, priv_member_promote_commissions int(1) not null default 0, priv_member_promote_jvproducts int(1) not null default 0, priv_member_resell_resprogs int(1) not null default 0, priv_member_resell_royalties int(1) not null default 0, priv_member_resell_payroyalties int(1) not null default 0, priv_member_downline_view int(1) not null default 0, priv_member_downline_massmail int(1) not null default 0, priv_member_downline_commissions int(1) not null default 0, priv_member_downline_refer int(1) not null default 0, priv_spec_maildownlinenofooter int(1) not null default 0, priv_spec_yourcommissionseecustomer int(1) not null default 0, priv_spec_autoresowncust int(1) not null default 0, priv_spec_autoresrefcust int(1) not null default 0, limit_products varchar(50) not null default '', limit_packages varchar(50) not null default '', limit_minisites varchar(50) not null default '', limit_shopcarts varchar(50) not null default '', limit_members varchar(50) not null default '', limit_roles varchar(50) not null default '', limit_massmailnumber varchar(50) not null default '', limit_massmailperiod varchar(50) not null default '', limit_dlvuploadone int(6) not null default 0, limit_dlvuploadall int(6) not null default 0, limit_memberships varchar(255) not null default '', key(owner_id) ) [Mon Sep 19 15:26:11 2011] MySQLImport SQL OK: create table jin_user_role ( id int(11) not null primary key, owner_id int(11) not null, role_id int(11) not null, role_title varchar(255) not null, user_id int(11) not null, sale_id int(11) not null default 0, expires date null, expired int(1) not null default 0, notapproved int(1) not null default 0, key(owner_id,user_id), key(owner_id,role_id), key(owner_id,sale_id) ) [Mon Sep 19 15:26:11 2011] MySQLImport SQL OK: # # TEMPLATES # tmpl_type - если группа шаблонов была автосоздана из системного скина, то здесь его имя. # Будет исп. для подгрузки новых скинов и для восстановления из дефолта. # Если скина нет, восстановление дефолта идет из системного шаблона. # Восстановление дефолта доступно для каждого template по отдельности, # хотя скин задается для всей группы. И еще - те группы, у которых есть tmpl_type, # их нельзя удалить или переименовать, они считаются защищенными. Хотя # редактировать шаблоны в них можно. create table jin_template ( id int(11) not null primary key, owner_id int(11) not null, group_id int(11) not null, group_type varchar(30) not null default '', group_title varchar(255) not null default '', group_active int(1) not null default 0, group_skin varchar(50) not null default '', tmpl_type varchar(30) not null default '', scope varchar(30) not null default '', html_head text not null default '', body_attr varchar(255) not null default '', template longtext not null default '', key(owner_id,scope,group_type), key(owner_id,group_id), key(owner_id,group_active) ) [Mon Sep 19 15:26:13 2011] MySQLImport SQL OK: # # PRODUCTS create table jin_product ( id int(11) not null primary key, owner_id int(11) not null, type int(11) not null default 0, is_deleted int(1) not null default 0, resprog_user_resprog_id int(1) not null default 0, resprog_base_prod_id int(1) not null default 0, # gone in v1.17 2007-10-20 # resprog_locked_main_fs varchar(255) not null default '', # resprog_hidden_dlv_fs varchar(255) not null default '', jvent_user_id int(11) not null default 0, jvent_status varchar(50) not null default '', jvent_commission varchar(50) not null default '', title varchar(255) not null default '', descr text not null default '', price decimal(8,2) not null default '0', autochecked int(1) not null default 0, date_availtill date null, time_availtill time null, period_validity int(11) not null default 0, limit_sales_max varchar(50) not null default '', limit_sales_done varchar(50) not null default '', no_renew int(1) not null default 0, no_cust_salelist int(1) not null default 0, no_thank_you_email int(1) not null default 0, specusers int(11) not null default 0, specusers_excuse text not null default '', specprice text not null default '', specprices_plan int(11) not null default 0, # gone in jin-2-1 # specprice_users int(11) not null default 0, master_prods varchar(50) not null default '', master_memberships varchar(100) not null default '', # gone in v2.0 # master_lmems varchar(100) not null default '', # master_rmems varchar(100) not null default '', # master_cmsmems varchar(100) not null default '', embed_prods varchar(100) not null default '', embed_prods_recur varchar(100) not null default '', send_cust_login_data int(1) not null default 0, owner_name varchar(255) not null default '', owner_email varchar(255) not null default '', commission_aff varchar(255) not null default '', commission_charity varchar(255) not null default '', # gone in v2 2009-01-20 # commission_charity_uids varchar(50) not null default '', # commission_charity_pbase int(1) not null default 0, period_guarantee int(11) not null default 0, period_guarantee_no4recur int(1) not null default 0, comm_recur_stop int(3) not null default 0, quickresell_enabled int(1) not null default 0, quickresell_commission_royalty varchar(50) not null default '', quickresell_price_min varchar(10) not null default '', quickresell_price_max varchar(10) not null default '', quickresell_instructions text not null default '', shopcart_enabled int(1) not null default 0, shopcart_image_url varchar(255) not null default '', rating_total int(11) not null default 0, rating_votes int(11) not null default 0, rating_last_ip varchar(50) not null default '', points_obtain_cust varchar(50) not null default '', points_obtain_cust_recur int(1) not null default 0, points_obtain_aff varchar(50) not null default '', points_obtain_aff_recur int(1) not null default 0, points_price varchar(50) not null default '', pointscomm_aff int(1) not null default 0, pointscomm_jvpartner int(1) not null default 0, dlv_instructions text not null default '', dlv_otos varchar(255) not null default '', dlv_downloads varchar(255) not null default '', dlv_downloads_expire varchar(50) not null default '', dlv_brandpdfs varchar(255) not null default '', dlv_memberships varchar(255) not null default '', # gone in v2.0 # dlv_lmems varchar(255) not null default '', # dlv_rmems varchar(255) not null default '', # dlv_cmsmems varchar(255) not null default '', dlv_roles varchar(255) not null default '', dlv_affprogs varchar(255) not null default '', dlv_resprogs varchar(255) not null default '', dlv_quests varchar(255) not null default '', dlv_extscripts varchar(255) not null default '', dlv_coupons varchar(255) not null default '', dlv_points varchar(255) not null default '', pgates varchar(255) not null default '', pg_use_ext_recur varchar(255) not null default '', pg_use_int_recur varchar(255) not null default '', pg_recur_period_l varchar(10) not null default '', pg_recur_period_u char(1) not null default '', pg_recur_numinst varchar(10) not null default '', pg_recur_trial_l varchar(10) not null default '', pg_recur_trial_u char(1) not null default '', pg_recur_trial_amount varchar(15) not null default '', # gone in v1.7 2007-09-09 # jvmsub_use_with varchar(255) not null default '', # jvmsub_trial_length varchar(50) not null default '', # jvmsub_trial_unit char(1) not null default '', # jvmsub_trial_price varchar(50) not null default '', # jvmsub_subscr_numinst varchar(50) not null default '', # jvmsub_subscr_length varchar(50) not null default '', # jvmsub_subscr_unit char(1) not null default '', pg_2checkout_pid varchar(50) not null default '', pg_clickbank_linknumber varchar(50) not null default '', pg_subscr_cancel_nodelay int(1) not null default 0, # gone in v1.7 2007-09-09 # pg_manual_use int(1) not null default 0, # pg_manual_message text not null default '', # # pg_paypal_use int(1) not null default 0, # pg_paypal_email varchar(255) not null default '', # # pg_paypal_recur int(1) not null default 0, # pg_paypal_recur_length varchar(50) not null default '', # pg_paypal_recur_unit CHAR(1) NOT NULL DEFAULT '', # pg_paypal_recur_number varchar(50) not null default '', # pg_paypal_recur_reattempt int(1) not null default 0, # pg_paypal_trial_length varchar(50) not null default '', # pg_paypal_trial_unit CHAR(1) NOT NULL DEFAULT '', # pg_paypal_trial_price varchar(50) not null default '', # # pg_paypal_fwdipn_url varchar(255) not null default '', # pg_paypal_fwdipn_numtry int(11) not null default 0, # # pg_2c_use int(1) not null default 0, # pg_2c_sid varchar(255) not null default '', # pg_2c_secret varchar(255) not null default '', # # pg_cb_use int(1) not null default 0, # pg_cb_nickname varchar(255) not null default '', # # pg_mb_use int(1) not null default 0, # pg_mb_email varchar(255) not null default '', # pg_mb_recur int(1) not null default 0, # pg_mb_recur_amount varchar(255) not null default '', # pg_mb_recur_start date null, # pg_mb_recur_end date null, # pg_mb_recur_period varchar(255) not null default '', # # pg_an_use int(1) not null default 0, # pg_an_x_login varchar(255) not null default '', # pg_an_txn_key varchar(255) not null default '', # pg_an_recur int(1) not null default 0, # pg_an_recur_length varchar(10) not null default '', # pg_an_recur_unit varchar(10) not null default '', # pg_an_recur_number varchar(10) not null default '', # pg_an_trial_amount varchar(20) not null default '', # pg_an_trial_number varchar(10) not null default '', # # pg_lp_use int(1) not null default 0, # pg_lp_storename varchar(255) not null default '', # pg_lp_certfile varchar(255) not null default '', # pg_lp_recur int(1) not null default 0, # pg_lp_recur_numinst varchar(50) not null default '', # pg_lp_recur_length varchar(50) not null default '', # pg_lp_recur_unit char(1) not null default '', key(owner_id,type,is_deleted), key(resprog_user_resprog_id), fulltext(title,descr) ) [Mon Sep 19 15:26:13 2011] MySQLImport SQL OK: create table jin_oto ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', descr longtext not null default '', paylink_url varchar(255) not null default '', paylink_title varchar(255) not null default '', next_oto_link_title varchar(255) not null default '', links_style varchar(30) not null default '', key(owner_id) ) [Mon Sep 19 15:26:14 2011] MySQLImport SQL OK: create table jin_package ( id int(11) not null primary key, owner_id int(11) not null, label varchar(255) not null default '', type int(11) not null default 0, title varchar(255) not null default '', homepage varchar(255) not null default '', locked int(1) not null default 0, locked_ext varchar(255) not null default '', autoresp_ids varchar(255) not null default '', # gone in v1.12 2008-02-10 # welcomem_ids varchar(255) not null default '', email_welcome text not null default '', affprogs varchar(255) not null default '', quickresell_affprogs varchar(255) not null default '', no_aff_area int(1) not null default 0, commission_perclick varchar(50) not null default '', tmpl_group_id int(11) not null default 0, minisite_tmpl_group_id int(11) not null default 0, promo_window_width int(11) not null default 0, promo_window_height int(11) not null default 0, aff_customtags varchar(255) not null default '', signature char(2) not null default '', aweber_yes int(1) not null default 0, aweber_settings text not null default '', # gone in v1.16 2008-09-09 # aweber_url varchar(80) not null default '', # aweber_data text not null default '', pgates varchar(255) not null default '', bypass int(1) not null default 0, html_head text not null default '', html_foot text not null default '', pay_now_text varchar(255) not null default '', shipping int(1) not null default 0, geoforce_enabled int(1) not null default 0, geoforce_ids varchar(255) not null default '', geoforce_limited_sales int(1) not null default 0, invoicepdfs varchar(255) not null default '', use_terms int(1) not null default 0, notifysale_yes int(1) not null default 0, notifysale_settings text not null default '', key(owner_id,type) ) [Mon Sep 19 15:26:15 2011] MySQLImport SQL OK: create table jin_package_product ( prod_id int(11) not null, pack_id int(11) not null, cat_id int(11) not null, upsell int(1) not null default 0, tstamp timestamp, key(prod_id,pack_id,cat_id), key(pack_id,cat_id) ) [Mon Sep 19 15:26:15 2011] MySQLImport SQL OK: create table jin_package_hit ( tstamp timestamp, pack_id integer not null default 0, camp_id varchar(255) not null default '', aff_user_id integer not null default 0, coo char(16) not null, referer varchar(255) not null default '', ip varchar(50) not null default '', key(pack_id,camp_id,coo), key(camp_id) ) [Mon Sep 19 15:26:15 2011] MySQLImport SQL OK: create table jin_package_hit_ipcache ( tstamp timestamp, pack_id integer not null default 0, ip varchar(50) not null default '', key(pack_id,ip) ) [Mon Sep 19 15:26:15 2011] MySQLImport SQL OK: # # AFFILIATE PROGRAM create table jin_affprog ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null, commission_special varchar(255) not null default '', autoassign int(1) not null default 0, needapproval int(1) not null default 0, autoresp_ids varchar(255) not null default '', # gone in v1.12 2008-02-10 # welcomem_ids varchar(255) not null default '', email_welcome text not null default '', comm100 int(1) not null default 0, key(owner_id) ) [Mon Sep 19 15:26:15 2011] MySQLImport SQL OK: create table jin_user_affprog ( id int(11) not null primary key, owner_id int(11) not null, ctime datetime null, affprog_id int(11) not null, affprog_title varchar(255) not null, user_id int(11) not null, sale_id int(11) not null default 0, expires date null, expired int(1) not null default 0, notapproved int(1) not null default 0, key(owner_id,user_id), key(owner_id,affprog_id) ) [Mon Sep 19 15:26:15 2011] MySQLImport SQL OK: # # RESELLING PROGRAM create table jin_resprog ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null, prods varchar(255) not null default '', commission_royalty varchar(50) not null default '', # gone in v1.17 2007-10-20 # locked_main varchar(255) not null default '', limit_sales_max int(11) null, key(owner_id) ) [Mon Sep 19 15:26:15 2011] MySQLImport SQL OK: create table jin_resprog_settings ( id int(11) not null primary key, owner_id int(11) not null, sched_payment_type varchar(10) not null default '', sched_payment_day int(11) not null default 0, sched_payment_start date null, sched_payment_period int(11) not null default 0, sched_report int(11) not null default 0, sched_grace int(11) not null default 0, sched_remind int(11) not null default 0, key(owner_id) ) [Mon Sep 19 15:26:15 2011] MySQLImport SQL OK: create table jin_user_resprog ( id int(11) not null primary key, owner_id int(11) not null, ctime datetime null, resprog_id int(11) not null, resprog_title varchar(255) not null, user_id int(11) not null, sale_id int(11) not null default 0, expires date null, expired int(1) not null default 0, disabled int(1) not null default 0, limit_sales_max int(11) null, limit_sales_done int(11) null, key(owner_id,user_id), key(owner_id,resprog_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # # AUTORESPONDERS and other mailings create table jin_autoresponder ( id int(11) not null primary key, owner_id int(11) not null, email varchar(255) not null, subject varchar(255) not null default '', admin_notes text not null default '', key(owner_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # gone in v1.12 2008-02-10 #create table jin_welcomemail #( # id int(11) not null primary key, # owner_id int(11) not null, # # subject varchar(255) not null default '', # message text not null default '', # # key(owner_id) #); # # ORDERS, SALES create table jin_order ( id int(11) not null primary key, owner_id int(11) not null, ctime datetime null, signature char(8) not null default '', sequence text not null default '', complete int(1) not null default 0, pack_id int(11) not null default 0, pack_title varchar(255) not null default '', aff_user_id int(11) not null default 0, aff_camp_id varchar(255) not null default '', user_id int(11) not null default 0, user_email varchar(255) not null, user_fname varchar(255) not null, user_lname varchar(255) not null, user_name varchar(255) not null, user_address varchar(255) not null default '', user_city varchar(255) not null default '', user_state varchar(255) not null default '', user_zipcode varchar(255) not null default '', user_country varchar(255) not null default '', user_phone varchar(255) not null default '', user_company varchar(255) not null default '', key(owner_id,user_id), key(owner_id,aff_user_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: create table jin_sale ( id int(11) not null primary key, owner_id int(11) not null, tstamp datetime null, ctime datetime null, signature char(8) not null default '', descr varchar(255) not null default '', amount varchar(50) not null, amount_prod varchar(50) not null default '', amount_discount varchar(50) not null default '', amount_tax_pc varchar(50) not null default '', amount_tax_embed int(1) not null default 0, amount_tax varchar(50) not null default '', amount_shipping varchar(50) not null default '', amount_comms varchar(50) not null default '', prod_id int(11) not null default 0, prod_title varchar(255) not null default '', numprod int(11) not null default 0, paid int(1) not null default 0, txn_pgate_type varchar(30) not null default '', txn_code varchar(255) not null default '', # gone in v1.7 2007-09-09 # pgate_processed int(1) not null default 0, # gone in v1.7 2007-09-09 # cci varchar(30) not null default '', order_id int(11) not null default 0, user_id int(11) not null default 0, aff_user_id int(11) not null default 0, aff_camp_id varchar(255) not null default '', metaaff_id int(11) not null default 0, container_sale_id int(11) not null default 0, old_sale_id int(11) not null default 0, refund_deadline date null, refunded int(1) not null default 0, remote_ip varchar(255) not null default '', subscr_id varchar(255) not null default '', subscr_not_initial int(1) not null default 0, subscr_inst_number int(11) not null default 0, subscr_descr_more varchar(255) not null default '', no_renew int(1) not null default 0, no_cust_salelist int(1) not null default 0, oto_shown int(11) not null default 0, aweber_done int(1) not null default 0, is_quickresell int(1) not null default 0, download_ctime datetime null, coupon_code char(16) not null default 0, coupon_discount varchar(50) not null default '', points_cashed varchar(50) not null default '', points_earned varchar(50) not null default '', shipping_id int(11) not null default 0, shipping_subid varchar(255) not null default '', specprice_descr varchar(100) not null default '', admin_notes text not null default '', key(owner_id,subscr_id), key(owner_id,order_id), key(owner_id,user_id), key(owner_id,aff_user_id), key(owner_id,txn_code), key(aff_camp_id,paid), key(prod_id), key(owner_id,container_sale_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: create table jin_syslog ( ctime datetime null, seq int(11) not null, name varchar(255) not null default '', message varchar(255) not null default '', type char(1) not null default '', key(name) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: create table jin_paylog ( ctime datetime null, type varchar(10) not null default '', pgtxn_id int(11) not null default 0, # gone in v1.7 2007-09-09 # sale_id int(11) not null default 0, data text not null default '', # gone in v1.7 2007-09-09 # key(sale_id), key(pgtxn_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: create table jin_download ( id int(11) not null primary key, owner_id int(11) not null, resprog_base_obj_id int(11) not null, signature char(8) not null default '', title varchar(255) not null default '', url varchar(255) not null default '', username varchar(255) not null default '', password varchar(255) not null default '', comment varchar(255) not null, key(owner_id), key(resprog_base_obj_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # # INVITATIONS create table jin_invitation ( id int(11) not null primary key, owner_id int(11) not null, signature char(8) not null default '', title varchar(255) not null default '', grant_roles varchar(255) not null default '', grant_affprogs varchar(255) not null default '', promo_affprogs varchar(255) not null default '', commission_refer varchar(255) not null default '', key(owner_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # # COMMISSIONS create table jin_commission ( id int(11) not null primary key, owner_id int(11) not null, ctime datetime null, type varchar(50) not null, descr varchar(255) not null default '', amount varchar(50) not null, tier int(1) not null default 0, pay_deadline date null, paid int(1) not null default 0, cancel_deadline date null, cancelled int(1) not null default 0, sale_id int(11) not null default 0, ben_user_id int(11) not null default 0, ben_user_name varchar(255) not null default '', key(owner_id,sale_id), key(owner_id,ben_user_id), key(ben_user_id) # search by "any" owner_id ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # # INTERNAL SUBSCRIPTIONS create table jin_jvmsub ( id int(11) not null primary key, owner_id int(11) not null, subscr_id varchar(50) not null default '', user_id int(11) not null default 0, init_sale_id integer not null, startdate date null, active int(1) not null, cancelled int(1) not null default 0, canceldate date null, period_l varchar(20) not null default '', period_u varchar(20) not null default '', numinst varchar(20) not null default '', trial_l varchar(20) not null default '', trial_u char(1) not null default '', trial_amount varchar(20) not null default '', period_amount varchar(20) not null default '', key(owner_id,init_sale_id), key(owner_id,active) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # # CAMPAIGNS create table jin_campaign ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', enabled int(1) not null default 0, key(owner_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # # SPONSORSHIPS create table jin_sponsor ( id int(11) not null primary key, owner_id int(11) not null, sort int(11) not null default 0, title varchar(255) not null default '', url varchar(255) not null default '', expire date null, key(owner_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: create table jin_sponsor_cfg ( id int(11) not null primary key, owner_id int(11) not null, orderurl varchar(255) not null default '', key(owner_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # # COUPONS create table jin_coupon ( id int(11) not null primary key, owner_id int(11) not null, hidden int(1) not null default 0, parent_coupon_id int(11) not null, active int(1) not null default 0, exhausted int(1) not null default 0, otc_all int(1) not null default 0, otc_selected varchar(255) not null default '', otc_existing int(1) not null default 0, otc_existing_since date null, otc_existing_pack varchar(255) not null default '', otc_existing_prod varchar(255) not null default '', otc_memberships varchar(255) not null default '', # gone in v2.0 # otc_lmems varchar(255) not null default '', # otc_rmems varchar(255) not null default '', # otc_cmsmems varchar(255) not null default '', otc_new int(1) not null default 0, otc_new_pack varchar(255) not null default '', otc_new_prod varchar(255) not null default '', ota_all int(1) not null default 0, ota_selected varchar(255) not null default '', ota_group varchar(255) not null default '', ota_existing int(1) not null default 0, ota_existing_since date null, ota_new int(1) not null default 0, for_all int(1) not null default 0, for_pack varchar(255) not null default '', for_prod varchar(255) not null default '', coupon varchar(255) not null default 0, discount varchar(50) not null default '', limit_amount int(11) not null default 0, valid_from date null, valid_until date null, number integer not null default 0, usage_cust integer not null default 0, usage_aff integer not null default 0, email_cust text not null default '', email_aff text not null default '', notes text not null default '', KEY(owner_id,hidden), key(coupon), key(parent_coupon_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: create table jin_coupon_use ( coupon_id int(11) not null default 0, cust_user_id int(11) not null default 0, aff_user_id int(11) not null default 0, key(coupon_id), key(cust_user_id), key(aff_user_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # # REWARD PROGRAMS create table jin_reward ( id int(11) not null primary key, owner_id int(11) not null, active int(1) not null default 0, type varchar(20) not null default '', notes text not null default '', multiply int(11) not null default 0, valid_from date null, valid_until date null, cust_all int(1) not null default 0, cust_selected varchar(255) not null default '', cust_existing int(1) not null default 0, cust_existing_since date null, cust_existing_pack varchar(255) not null default '', cust_existing_prod varchar(255) not null default '', cust_new int(1) not null default 0, cust_new_pack varchar(255) not null default '', cust_new_prod varchar(255) not null default '', cust_paid_min varchar(20) not null default '', cust_paid_max varchar(20) not null default '', aff_all int(1) not null default 0, aff_selected varchar(255) not null default '', aff_group varchar(255) not null default '', aff_registered_after date null, aff_generate_min varchar(20) not null default '', aff_generate_max varchar(20) not null default '', KEY(owner_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: create table jin_user_point_history ( id int(11) not null primary key, owner_id int(11) not null, user_id int(11) not null, otime datetime, points_before int(11) not null, points_after int(11) not null, comment varchar(255) not null default '', key(owner_id,user_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # # BANS create table jin_ban ( id int(11) not null primary key, owner_id int(11) not null, banlist longtext not null default '', key(owner_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # # SHORT URLS create table jin_short_url ( id int(11) not null primary key, owner_id int(11) not null, alias varchar(255) not null default '', url varchar(255) not null default '', admin_notes text not null default '', key(owner_id) ) [Mon Sep 19 15:26:16 2011] MySQLImport SQL OK: # # STATISTIC REPORTS create table jin_stats_report ( id int(11) not null primary key, owner_id int(11) not null, signature char(16) not null, type varchar(50) not null default '', title varchar(255) not null default '', search varchar(255) not null default '', key(owner_id), key(signature) ) [Mon Sep 19 15:26:17 2011] MySQLImport SQL OK: # # MASSMAIL create table jin_massmail_counter ( user_id int(11) not null, tstamp timestamp, key(user_id) ) [Mon Sep 19 15:26:17 2011] MySQLImport SQL OK: create table jin_massmail_job ( job_id char(16) not null, cdate datetime null, fdate datetime null, ldate datetime null, user_id int(11) not null, subject varchar(255) not null default '', scheduled int(1) not null default 0, emails_num int(11) not null default 0, emails_sent int(11) not null default 0, complete int(1) not null default 0, key(job_id), key(scheduled,complete), key(user_id,scheduled,complete) ) [Mon Sep 19 15:26:17 2011] MySQLImport SQL OK: create table jin_massmail_jobitem ( job_id char(16) not null, seq int(11) not null default 0, sent int(1) not null default 0, failed varchar(100) not null default '', format varchar(50) not null default '', subject varchar(255) not null default '', message text not null default '', user_id int(11) not null, user_signature char(16) not null, user_name varchar(255) not null default '', user_email varchar(255) not null default '', user_passwd varchar(255) not null default '', key(job_id,seq), key(job_id,sent,seq) ) [Mon Sep 19 15:26:17 2011] MySQLImport SQL OK: create table jin_massmail_settings ( id int(11) not null primary key, owner_id int(11) not null, portion_size int(11) not null default 0, key(owner_id) ) [Mon Sep 19 15:26:17 2011] MySQLImport SQL OK: # # SHOPCART create table jin_shopcart_category ( id int(11) not null primary key, owner_id int(11) not null, pack_id int(11) not null, parent_id int(11) not null, title varchar(255) not null, seq int(11) not null, path_id varchar(255) not null default '', path_seq varchar(255) not null default '', level int(11) not null, key(owner_id,pack_id,parent_id), key(owner_id,pack_id,path_seq) ) [Mon Sep 19 15:26:17 2011] MySQLImport SQL OK: # # SPECIAL CUSTOMERS create table jin_specusers ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', notes text not null default '', u_all int(1) not null default 0, u_selected varchar(255) not null default '', u_since date null, u_cust_new int(1) not null default 0, u_cust_packs varchar(255) not null default '', u_cust_prods varchar(255) not null default '', u_affprogs varchar(255) not null default '', u_roles varchar(255) not null default '', u_memberships varchar(255) not null default '', # gone in v2.0 # u_rmems varchar(255) not null default '', # u_lmems varchar(255) not null default '', # u_cmsmems varchar(255) not null default '', u_paid_min varchar(20) not null default '', u_paid_max varchar(20) not null default '', u_generated_min varchar(20) not null default '', u_generated_max varchar(20) not null default '', u_count_sales_from date null, u_count_sales_until date null, KEY(owner_id) ) [Mon Sep 19 15:26:18 2011] MySQLImport SQL OK: # # PROMO GENERATOR create table jin_promogen_template ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', template text not null default '', type varchar(255) not null default '', file varchar(255) not null default '', is_default int(1) not null default 0, KEY(owner_id,type) ) [Mon Sep 19 15:26:18 2011] MySQLImport SQL OK: create table jin_promogen ( id int(11) not null primary key, owner_id int(11) not null, type varchar(20) not null default '', seq int(11) not null, template int(11) not null, title varchar(255) not null default '', instructions longtext not null default '', subject varchar(255) not null default '', message longtext not null default '', imageUrl varchar(255) not null default '', url varchar(255) not null default '', description longtext not null default '', keywords varchar(255) not null default '', KEY(owner_id) ) [Mon Sep 19 15:26:18 2011] MySQLImport SQL OK: # # TAXES create table jin_tax ( id int(11) not null primary key, owner_id int(11) not null, percent decimal(3,1) not null default 0, embedded int(1) not null default 0, country varchar(50) not null default '', state varchar(50) not null default '', key(owner_id) ) [Mon Sep 19 15:26:18 2011] MySQLImport SQL OK: # # JVM ALERTS & API & IPN forward create table jin_alert_cfg ( id int(11) not null primary key, owner_id int(11) not null, ad text not null default '', key(owner_id) ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: create table jin_alert_msg ( id int(11) not null primary key, owner_id int(11) not null, ptime datetime null, specusers int(11) not null default 0, title varchar(255) not null default '', message text not null default '', key(owner_id) ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: create table jin_alert_sync ( id int(11) not null primary key, last_sync_time datetime ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: create table jin_api_user ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', secret varchar(255) not null default '', secure int(1) not null default 0, specusers int(11) not null default 0, u_all int(1) not null default 0, u_selected varchar(255) not null default '', u_since date null, u_cust_new int(1) not null default 0, u_cust_packs varchar(255) not null default '', u_cust_prods varchar(255) not null default '', u_affprogs varchar(255) not null default '', u_roles varchar(255) not null default '', u_memberships varchar(255) not null default '', # gone in v2.0 # u_rmems varchar(255) not null default '', # u_lmems varchar(255) not null default '', # u_cmsmems varchar(255) not null default '', u_paid_min varchar(20) not null default '', u_paid_max varchar(20) not null default '', u_generated_min varchar(20) not null default '', u_generated_max varchar(20) not null default '', u_count_sales_from date null, u_count_sales_until date null, key(owner_id) ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: create table jin_ipn_forward ( id int(11) not null primary key, owner_id int(11) not null, pgtxn_id int(11) not null default 0, url varchar(255) not null, params text not null default '', trials int(3) not null default 3 ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: # # FORM EDITOR create table jin_form_editor ( id int(11) not null primary key, owner_id int(11) not null, code varchar(50) not null, obj_id int(11) not null default 0, data text not null default '', key(owner_id,obj_id,code) ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: # # EXT SCRIPTS create table jin_ext_script ( id int(11) not null primary key, owner_id int(11) not null, resprog_base_obj_id int(11) not null, title varchar(255) not null, url varchar(255) not null, plugin varchar(50) not null, cfgtext text not null default '', email_create text not null default '', email_delete text not null default '', key(owner_id) ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: # # UPGRADABLE AFFILIATE PROGRAMS create table jin_affprog_series ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null, key(owner_id) ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: create table jin_affprog_series_step ( id int(11) not null primary key, owner_id int(11) not null, ctime datetime null, series_id int(11) not null default 0, affprog_id int(11) not null default 0, upgrade_type varchar(20) not null default '', upgrade_amount varchar(20) not null default '', upgrade_period_n varchar(10) not null default '', upgrade_period_u char(1) not null default 0, downgrade_type varchar(20) not null default '', downgrade_amount varchar(20) not null default '', downgrade_period_n varchar(10) not null default '', downgrade_period_u char(1) not null default 0, email_upgrade text not null default '', email_downgrade text not null default '', key(owner_id,series_id) ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: create table jin_affprog_series_history ( id int(11) not null primary key, owner_id int(11) not null, user_id int(11) not null, series_id int(11) not null, otime datetime, affprog_id_before int(11) not null, affprog_title_before varchar(255) not null default '', affprog_id_after int(11) not null, affprog_title_after varchar(255) not null default '', comment varchar(255) not null default '', key(owner_id,user_id) ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: # # PGATES create table jin_pgate ( id int(11) not null primary key, owner_id int(11) not null, type varchar(50) not null default '', title varchar(50) not null default '', settings text not null default '' ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: create table jin_pgtxn ( id int(11) not null primary key, owner_id int(11) not null, txn_code varchar(255) not null default '', processed int(1) not null default 0, successful int(1) not null default 0, pgate_id int(11) not null default 0, pgate_type varchar(30) not null default '', order_id int(11) not null default 0, sale_id int(11) not null default 0, key(owner_id,order_id,sale_id), key(owner_id,txn_code) ) [Mon Sep 19 15:26:19 2011] MySQLImport SQL OK: # # EMBEDDED EMAIL create table jin_embedded_email ( id int(11) not null primary key, owner_id int(11) not null, signature text not null default '', footermassmail text not null default '', footerdownline text not null default '', user_register text not null default '', user_remindpasswd text not null default '', user_changeemail text not null default '', user_import text not null default '', user_logindata text not null default '', approvals_affprog_due text not null default '', approvals_affprog_approved text not null default '', approvals_affprog_rejected text not null default '', approvals_role_due text not null default '', approvals_role_approved text not null default '', approvals_role_rejected text not null default '', sale_paidcustomer text not null default '', sale_paidadmin text not null default '', sale_paidowner text not null default '', sale_echeckfailed text not null default '', # gone in v1.12 2008-02-14 # access_lmem text not null default '', # access_rmem text not null default '', # access_cmsmem text not null default '', access_minisite text not null default '', comm_created text not null default '', comm_createdrecur text not null default '', comm_referral text not null default '', comm_refunded text not null default '', comm_royalty_due text not null default '', comm_royalty_overdue text not null default '', comm_royalty_superoverdue text not null default '', jventure_product_added text not null default '', jventure_product_modified text not null default '', jventure_product_reqmod text not null default '', jventure_product_approved text not null default '', # gone in v1.12 2008-02-20 # coupon_cust text not null default '', # coupon_aff text not null default '', key(owner_id) ) [Mon Sep 19 15:26:20 2011] MySQLImport SQL OK: # # QUESTIONNAIRES create table jin_quest ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', instructions text not null default '', blocking int(1) not null default 0, from_customer int(1) not null default 0, notify_emails varchar(255) not null default '', notify_create text not null default '', notify_delete text not null default '', trigger_url varchar(255) not null default '', trigger_secret varchar(255) not null default '', trigger_method varchar(10) not null default '', key(owner_id) ) [Mon Sep 19 15:26:20 2011] MySQLImport SQL OK: create table jin_quest_item ( id int(11) not null primary key, owner_id int(11) not null, quest_id int(11) not null, title varchar(255) not null default '', mandatory int(1) not null default 0, type varchar(30) not null default '', customlist text not null default '', qsfield varchar(50) not null default '', seq int(11) not null default 0, key(owner_id,quest_id,seq) ) [Mon Sep 19 15:26:21 2011] MySQLImport SQL OK: create table jin_user_quest ( id int(11) not null primary key, owner_id int(11) not null, sale_id int(11) not null default 0, user_id int(11) not null default 0, quest_id int(11) not null, expires date null, expired int(1) not null default 0, userinput text not null default '', triggertext text not null default '', key(owner_id,user_id), key(owner_id,sale_id), key(owner_id,quest_id) ) [Mon Sep 19 15:26:21 2011] MySQLImport SQL OK: # # SHIPPING create table jin_shipping ( id int(11) not null primary key, owner_id int(11) not null, type varchar(50) not null default '', title varchar(50) not null default '', settings text not null default '', email_status text not null default '' ) [Mon Sep 19 15:26:21 2011] MySQLImport SQL OK: create table jin_shipping_due ( id int(11) not null primary key, owner_id int(11) not null, sale_id int(11) not null default 0, shipping_id int(11) not null, descr varchar(255) not null default '', fulfilled int(1) not null default 0, procid varchar(50) not null default '', status varchar(255) not null default '', key(owner_id,sale_id) ) [Mon Sep 19 15:26:21 2011] MySQLImport SQL OK: create table jin_testimonial_page ( id int(11) not null primary key, owner_id int(11) not null, tag varchar(255) not null default '', add_code varchar(255) not null default '', ipp int(11) not null default 0, photo_width int(11) not null default 0, template longtext not null default '', key(owner_id,tag) ) [Mon Sep 19 15:26:21 2011] MySQLImport SQL OK: create table jin_testimonial ( id int(11) not null primary key, owner_id int(11) not null, approved int(1) not null default 0, ctime datetime null, tag varchar(255) not null default '', name varchar(255) not null default '', email varchar(255) not null default '', image varchar(30) not null default '', website_title varchar(255) not null default '', website_url varchar(255) not null default '', testimonial text not null default '', videofile varchar(30) not null default '', player varchar(30) not null default '', youtube_id varchar(30) not null default '', url varchar(255) not null default '', key(owner_id,tag,approved) ) [Mon Sep 19 15:26:21 2011] MySQLImport SQL OK: create table jin_priceinc ( id int(11) not null primary key, owner_id int(11) not null, date_start date null, date_end date null, time_start time null, time_end time null, price_start decimal(8,2) not null default '0', price_end decimal(8,2) not null default '0', incr varchar(32) not null default '', period_l int(4) not null default 0, period_u varchar(15) not null default '', jsflow int(1) not null default 0, template text not null default '' ) [Mon Sep 19 15:26:22 2011] MySQLImport SQL OK: create table jin_followupman_series ( id int(11) not null primary key, owner_id int(11) not null, prods varchar(255) not null default '', title varchar(255) not null default '', from_name varchar(255) not null default '', from_email varchar(255) not null default '', double_optin int(1) not null default 0, hide_thank int(1) not null default 0, del_series varchar(255) not null default '', key(owner_id) ) [Mon Sep 19 15:26:22 2011] MySQLImport SQL OK: create table jin_followupman_series_message ( id int(11) not null primary key, owner_id int(11) not null, series_id int(11) not null default 0, delay int(11) not null default 0, message text not null default '', subject varchar(255) not null default '', seq int(3) not null, plain_text int(1) not null default 0, recur_yes int(1) not null default 0, recur_num int(8) not null default 0, recur_delay int(11) not null default 0, co_mode int(1) not null default 0, co_from_email varchar(255) not null default '', co_to_emails text not null default '', co_subject varchar(255) not null default '', co_message text not null default '', co_plain_text int(1) not null default 0, key(owner_id, series_id) ) [Mon Sep 19 15:26:22 2011] MySQLImport SQL OK: create table jin_followupman_user_series ( id int(11) not null primary key, owner_id int(11) not null, user_id int(11) not null default 0, message_id int(11) not null default 0, series_id int(11) not null default 0, stime datetime null, confirmed int(1) not null default 0, signature char(8) not null, optout int(1) not null default 0, optout_tstamp datetime null, sale_id int(11) not null default 0, key(owner_id, user_id), key(owner_id, sale_id), key(owner_id, series_id), key(confirmed, optout, message_id) ) [Mon Sep 19 15:26:22 2011] MySQLImport SQL OK: create table jin_followupman_template ( id int(11) not null primary key, owner_id int(11) not null, confirm_subscription text not null default '', key(owner_id) ) [Mon Sep 19 15:26:22 2011] MySQLImport SQL OK: create table jin_followupman_user_recur ( user_series_id int(11) not null default 0, message_id int(11) not null default 0, num int(8) not null default 0, stime datetime null, key(user_series_id), key(message_id) ) [Mon Sep 19 15:26:22 2011] MySQLImport SQL OK: create table jin_user_dlv ( id int(11) not null primary key, owner_id int(11) not null, ctime datetime null, type varchar(50) not null default '', obj_id int(11) not null, obj_title varchar(255) not null, user_id int(11) not null, sale_id int(11) not null default 0, expires date null, expired int(1) not null default 0, key(owner_id,type,obj_id), key(owner_id,user_id), key(owner_id,sale_id) ) [Mon Sep 19 15:26:22 2011] MySQLImport SQL OK: create table jin_brandpdf ( id int(11) not null primary key, owner_id int(11) not null, resprog_base_obj_id int(11) not null, title varchar(150) not null default '', filename varchar(150) not null default '', template longtext not null default '', key(owner_id), key(resprog_base_obj_id) ) [Mon Sep 19 15:26:23 2011] MySQLImport SQL OK: create table jin_invoicepdf ( id int(11) not null primary key, owner_id int(11) not null, title varchar(150) not null default '', template longtext not null default '', format varchar(10) not null default '', key(owner_id) ) [Mon Sep 19 15:26:23 2011] MySQLImport SQL OK: create table jin_terms ( id int(11) not null primary key, owner_id int(11) not null, terms longtext not null default '', key(owner_id) ) [Mon Sep 19 15:26:24 2011] MySQLImport SQL OK: create table jin_supro ( id int(11) not null primary key, owner_id int(11) not null, alias varchar(255) not null default '', url varchar(255) not null default '', username varchar(255) not null default '', password varchar(255) not null default '', limit_ips int(6) not null default 0, limit_ips_user int(6) not null default 0, limit_downloads int(6) not null default 0, limit_downloads_user int(6) not null default 0, limit_referer text not null default '', expires date null, admin_notes text not null default '', u_all int(1) not null default 0, u_selected varchar(255) not null default '', u_since date null, u_cust_new int(1) not null default 0, u_cust_packs varchar(255) not null default '', u_cust_prods varchar(255) not null default '', u_affprogs varchar(255) not null default '', u_roles varchar(255) not null default '', u_memberships varchar(255) not null default '', # gone in v2.0 # u_rmems varchar(255) not null default '', # u_lmems varchar(255) not null default '', # u_cmsmems varchar(255) not null default '', u_paid_min varchar(20) not null default '', u_paid_max varchar(20) not null default '', u_generated_min varchar(20) not null default '', u_generated_max varchar(20) not null default '', u_count_sales_from date null, u_count_sales_until date null, key(owner_id) ) [Mon Sep 19 15:26:24 2011] MySQLImport SQL OK: create table jin_supro_stat ( supro_id int(11) not null default 0, tstamp datetime null, ip varchar(32) not null default '', referer varchar(255) not null default '', user_id int(11) not null default 0, user_email varchar(255) not null default '', key(supro_id) ) [Mon Sep 19 15:26:25 2011] MySQLImport SQL OK: create table jin_jvevent ( id int(11) not null primary key, owner_id int(11) not null, signature char(8) not null default '', title varchar(255) not null default '', membership_id int(11) not null default 0, # gone in v2.0 # rmem_id int(11) not null default 0, rights varchar(255) not null default '', pagesize int(3) not null default 0, period_validity int(11) not null default 0, max_video_size int(6) not null default 0, max_image_size int(6) not null default 0, max_download_size int(6) not null default 0, def_user_image varchar(255) not null default '', user_image_width int(11) not null default 0, template_list longtext not null default '', template_submit longtext not null default '', style_id int(11) not null default 0, key(owner_id), key(signature) ) [Mon Sep 19 15:26:25 2011] MySQLImport SQL OK: create table jin_jvevent_prod ( id int(11) not null primary key, owner_id int(11) not null, signature char(8) not null default '', ctime datetime null, jvevent_id int(11) not null default 0, approved int(1) not null default 0, sortdate datetime null, title varchar(255) not null default '', url varchar(255) not null default '', descr text not null default '', price varchar(30) not null default '', cover_url varchar(255) not null default '', download_url varchar(255) not null default '', rights varchar(255) not null default '', partner_name varchar(255) not null default '', partner_email varchar(255) not null default '', partner_website_title varchar(255) not null default '', partner_website_url varchar(255) not null default '', testim_text text not null default '', testim_player varchar(30) not null default '', testim_youtube varchar(30) not null default '', testim_video_url varchar(255) not null default '', key(owner_id,jvevent_id,approved) ) [Mon Sep 19 15:26:25 2011] MySQLImport SQL OK: create table jin_jvevent_rights ( id int(11) not null primary key, title varchar(255) not null default '' ) [Mon Sep 19 15:26:25 2011] MySQLImport SQL OK: create table jin_style ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', width varchar(30) not null default '', bgcolor varchar(30) not null default '', font_color varchar(30) not null default '', font_style varchar(30) not null default '', font_size varchar(30) not null default '', css_class varchar(50) not null default '', css_style varchar(255) not null default '', key(owner_id) ) [Mon Sep 19 15:26:25 2011] MySQLImport SQL OK: create table jin_customtag ( id int(11) not null primary key, owner_id int(11) not null, label varchar(255) not null default '', tagname varchar(50) not null default '', comment varchar(255) not null default '', def_value text not null default '', unique key(owner_id,tagname) ) [Mon Sep 19 15:26:25 2011] MySQLImport SQL OK: create table jin_customtag_aff ( aff_user_id int(11) not null default 0, pack_id int(11) not null default 0, tag_id int(11) not null default 0, tag_value text not null default '', unique key(pack_id,tag_id,aff_user_id) ) [Mon Sep 19 15:26:25 2011] MySQLImport SQL OK: create table jin_linkdir ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', categories text not null default '', first_page_size int(11) not null default 0, style_id int(11) not null default 0, allow_visitors_links int(1) not null default 0, sponsor_membership int(11) not null default 0, # gone in v2.0 # sponsor_rmem int(11) not null default 0, sponsor_numlinks int(11) not null default 0, sponsor_orderlink varchar(255) not null default '', key(owner_id) ) [Mon Sep 19 15:26:26 2011] MySQLImport SQL OK: create table jin_linkdir_link ( id int(11) not null primary key, owner_id int(11) not null, signature char(16) not null, linkdir_id int(11) not null default 0, category varchar(255) not null default '', pdate datetime null, onhold int(1) not null default 0, title varchar(255) not null default '', url varchar(255) not null default '', descr text not null default '', email varchar(255) not null, key(owner_id,linkdir_id,onhold), key(owner_id,linkdir_id,email) ) [Mon Sep 19 15:26:26 2011] MySQLImport SQL OK: create table jin_banner ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', key(owner_id) ) [Mon Sep 19 15:26:26 2011] MySQLImport SQL OK: create table jin_banner_item ( id int(11) not null primary key, owner_id int(11) not null, banner_id int(11) not null default 0, title varchar(255) not null default '', url varchar(255) not null default '', weight varchar(10) not null default '', image varchar(255) not null default '', html_text text not null default '', key(owner_id, banner_id) ) [Mon Sep 19 15:26:26 2011] MySQLImport SQL OK: create table jin_banner_stat ( banner_id int(11) not null default 0, item_id int(11) not null default 0, referer varchar(255) not null default '', views int(11) not null default 0, clicks int(11) not null default 0, key(banner_id, item_id, referer) ) [Mon Sep 19 15:26:26 2011] MySQLImport SQL OK: create table jin_affinb ( id int(11) not null primary key, owner_id int(11) not null, aff_id int(11) not null default 0, pack_id int(11) not null default 0, active int(1) not null default 0, descr longtext not null default '', html_delivery longtext not null default '', email_delivery text not null default '', key(owner_id,aff_id,pack_id) ) [Mon Sep 19 15:26:26 2011] MySQLImport SQL OK: create table jin_affinb_cfg ( id int(11) not null primary key, owner_id int(11) not null, affprogs varchar(255) not null default '', key(owner_id) ) [Mon Sep 19 15:26:26 2011] MySQLImport SQL OK: create table jin_affinb_template ( id int(11) not null primary key, owner_id int(11) not null, template longtext not null default '', key(owner_id) ) [Mon Sep 19 15:26:26 2011] MySQLImport SQL OK: create table jin_quickresell ( id int(11) not null primary key, owner_id int(11) not null, prod_id int(11) not null default 0, price decimal(8,2) not null default '0', pgates varchar(255) not null default '', key(owner_id,prod_id), key(prod_id) ) [Mon Sep 19 15:26:29 2011] MySQLImport SQL OK: create table jin_membership ( id int(11) not null primary key, owner_id int(11) not null, type varchar(50) not null, resprog_base_obj_id int(11) not null, # jincms.ext_script custom_int int(11) not null, # jin_lmem.path, jin_rmem.ftp_serv, jin_cms.path custom_v1 varchar(255) not null, # jin_rmem.ftp_user custom_v2 varchar(255) not null, # jin_rmem.ftp_pass custom_v3 varchar(255) not null, # jin_rmem.ftp_dir custom_v4 varchar(255) not null, url varchar(255) not null, comment varchar(255) not null, insecure int(1) not null default 0, use_altauth int(1) not null default 0, email_access text not null default '', email_delete text not null default '', key(owner_id), key(resprog_base_obj_id) ) [Mon Sep 19 15:26:29 2011] MySQLImport SQL OK: create table jin_page ( id int(11) not null primary key, owner_id int(11) not null, label varchar(255) not null default '', group_id int(11) not null default 0, group_title varchar(255) not null default '', group_tmpl_id int(11) not null default 0, group_protection varchar(10) not null default '', group_mems varchar(255) not null default '', group_menu text not null default '', url varchar(255) not null default '', title varchar(255) not null default '', tmpl_id int(11) not null default 0, protection varchar(10) not null default '', type varchar(20) not null default '', content longtext not null default '', template longtext not null default '', key(owner_id,group_id), key(owner_id,url) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_geoforce ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', country varchar(10) not null default '', state varchar(10) not null default '', user_id int(11) not null default 0, user_order_link varchar(255) not null default '', key(owner_id,user_id), key(owner_id,country,state) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_blogpub ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', url varchar(255) not null default '', custom int(1) not null default 0, blog_type varchar(30) not null default '', login_url varchar(255) not null default '', login_params text not null default '', pub_url varchar(255) not null default '', pub_params text not null default '', username varchar(255) not null, password varchar(255) not null, format int(1) not null default 0, key(owner_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_bcastnews ( id int(11) not null primary key, owner_id int(11) not null, display_on_ws int(1) not null default 0, display_mode int(3) not null default 0, display_mode_value int(3) not null default 0, secret_word varchar(50) not null default '', template text not null default '', template_one_msg text not null default '', key(owner_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_bcastnews_message ( id int(11) not null primary key, owner_id int(11) not null, pdate datetime null, message_brief text not null default '', message_full text not null default '', author varchar(50) not null default '', key(owner_id,pdate) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_bcastnews_feeder ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', url varchar(255) not null default '', secret_word varchar(50) not null default '', user_id int(11) not null default 0, membership_id int(11) not null default 0, key(owner_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_shopcart_review ( id int(11) not null primary key, owner_id int(11) not null, prod_id int(11) not null default 0, approved int(1) not null default 0, pdate datetime null, message text not null default '', author_name varchar(50) not null default '', author_email varchar(255) not null default '', key(owner_id,prod_id,approved) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_shopcart_settings ( id int(11) not null primary key, owner_id int(11) not null, pack_id int(11) not null default 0, review_moderation int(1) not null default 0, review_pagesize int(11) not null default 0, catalog_img_width int(11) not null default 0, catalog_pagesize int(11) not null default 0, prodinfo_img_width int(11) not null default 0, gallery_img_height int(11) not null default 0, key(owner_id,pack_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_certman ( id int(11) not null primary key, owner_id int(11) not null, membership_id int(11) not null default 0, date_color varchar(11) not null default '', date_font int(8) not null default 0, date_format varchar(30) not null default '', date_x int(8) not null default 0, date_y int(8) not null default 0, id_color varchar(11) not null default '', id_font int(8) not null default 0, id_x int(8) not null default 0, id_y int(8) not null default 0, name_color varchar(11) not null default '', name_font int(8) not null default 0, name_x int(8) not null default 0, name_y int(8) not null default 0, copyright varchar(255) not null default '', url varchar(255) not null default '', template longtext not null default '', width int(8) not null default 0, height int(8) not null default 0, key(owner_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_specprices ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', settings text not null default '', key(owner_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_cloud_page ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', pre_moderation int(1) not null default 0, pagesize int(3) not null default 0, remain_on_top_days int(3) not null default 0, status_list varchar(255) not null default '', template longtext not null default '', css_style text not null default '', key(owner_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_cloud ( id int(11) not null primary key, owner_id int(11) not null, signature char(8) not null default '', cloud_page_id int(11) not null, user_id int(11) not null, ctime datetime null, approved int(1) not null default 0, title varchar(255) not null default '', message text not null default '', status varchar(50) not null default '', votes_for int(11) not null default 0, votes_against int(11) not null default 0, rating int(11) not null default 0, starred_by_users text not null default '', key(owner_id,cloud_page_id,ctime), key(owner_id,cloud_page_id,rating,ctime) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_cloud_comment ( id int(11) not null primary key, owner_id int(11) not null, signature char(8) not null default '', ctime datetime null, cloud_id int(11) not null, user_id int(11) not null, message text not null default '', key(owner_id,cloud_id,ctime) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_cloud_starred ( cloud_id int(11) not null default 0, user_id int(11) not null default 0, key(cloud_id,user_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_reminder ( id int(11) NOT NULL primary key, owner_id int(11) NOT NULL, type varchar(100) NOT NULL default '', title varchar(255) NOT NULL default '', comment text NOT NULL, event_date datetime default NULL, remind_date datetime default NULL, recurring tinyint(2) NOT NULL default '0', recur_until datetime default NULL, key(owner_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_reminder_type ( owner_id int(11) NOT NULL default '0', title varchar(100) NOT NULL default '', key(owner_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_helpticket ( id int(11) not null primary key, owner_id int(11) not null, thread_id int(11) not null default 0, user_id int(11) not null default 0, subject varchar(255) not null default '', message text not null default '', ctime datetime null, ftime datetime null, status int(8) not null default 0, category varchar(255) not null default '', key(owner_id,thread_id,status,ctime) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_helpticket_settings ( id int(11) not null primary key, owner_id int(11) not null, template longtext not null default '', categories text not null default '', support_emails text not null default '', staff_emails text not null default '', admin_name varchar(255) not null default '', admin_signature text not null default '', key(owner_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: create table jin_metaaff ( id int(11) not null primary key, owner_id int(11) not null, title varchar(255) not null default '', aff_selected varchar(255) not null default '', aff_group varchar(255) not null default '', key(owner_id) ) [Mon Sep 19 15:26:30 2011] MySQLImport OK [Mon Sep 19 15:26:30 2011] FileCopy OK delavo/kit.main/sql/jin-init.sql to delavo/SQL-INIT [Mon Sep 19 15:26:30 2011] DataModify OK delavo/SQL-INIT [email='matt\@jvmanager\.com'] [email='orlando.paolo@gmail.com'] [Mon Sep 19 15:26:30 2011] MySQLImport skipCrit negative [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: insert into jin_user set id=1,owner_id=1,signature='44E241BF140EA4C0',registered=1,ownership_id=1,regtime=now(),sestime=now(),email='orlando.paolo@gmail.com',passwd='04746573740d86cb5a2d39fb3419507a',name='Site Administrator',fname='Site',lname='Administrator' [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: insert into jin_role set id=1,owner_id=1,title='Supervisor',priv_supervisor=1 [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: insert into jin_user_role set id=1,owner_id=1,role_id=1,role_title='Supervisor',user_id=1 [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: insert into jin_role set id=3,owner_id=1,title='Standard Customer and Affiliate',autoassign=1,priv_member_account_purchases=1,priv_member_account_mems=1,priv_member_account_jvmsubs=1,priv_member_account_points=1,priv_member_account_helptickets=1,priv_member_promote_affprogs=1,priv_member_promote_links=1,priv_member_promote_campaigns=1,priv_member_promote_commissions=1,priv_member_promote_jvproducts=1 [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (1, 'Can be sold') [Mon Sep 19 15:26:30 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (2, 'Sales page included') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (3, 'Can be given away') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (4, 'Can be added to free membership sites') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (5, 'Can be added to paid membership sites') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (6, 'Can be offered as a bonus') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (7, 'Can be packaged with other products') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (8, 'Can be offered through auction sites') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (9, 'Can be customized') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (10, 'Can be edited completely and your name put on it') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (11, 'Can be broken down into smaller articles') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (12, 'Can be added to an e-course or autoresponder') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (13, 'Can be used as web content') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (14, 'Can sell Resale Rights') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (15, 'Can sell Master Resale Rights') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (16, 'Can sell Private Label Rights') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (17, 'Can sell Transferable Master Resale Rights') [Mon Sep 19 15:26:31 2011] MySQLImport SQL OK: insert into jin_jvevent_rights (id, title) values (18, 'Can sell Transferable Private Label Rights') [Mon Sep 19 15:26:31 2011] MySQLImport OK [Mon Sep 19 15:26:31 2011] FileRemove OK delavo/SQL-INIT [Mon Sep 19 15:26:31 2011] DataModify OK delavo/.htaccess [/jin\)\$] [/delavo)$] [Mon Sep 19 15:26:31 2011] DataModify OK delavo/aff.js [var\s*jvmSysURL\s*=\s*'[^']*'] [var jvmSysURL = 'http://www.resalerightshome.com/delavo/delavo'] [Mon Sep 19 15:26:31 2011] DataScan OK delavo/kit.main/LANGUAGE [(.+)] [$Tmp{Language}] [en] [Mon Sep 19 15:26:31 2011] FileCopy OK delavo/kit.hostconf/config/hostconf_db.conf.en.comp.pl is not copied into itself [Mon Sep 19 15:26:31 2011] FileCopy OK delavo/kit.hostconf/config/hostconf_mailer.conf.en.comp.pl is not copied into itself [Mon Sep 19 15:26:31 2011] DataModify OK delavo/kit.hostconf/config/hostconf_db.conf.en.comp.pl [dsource\s*\=>\s*'[^']*'] [dsource => 'DBI:mysql:database=resale_delavo;host=localhost'] [Mon Sep 19 15:26:31 2011] DataModify OK delavo/kit.hostconf/config/hostconf_db.conf.en.comp.pl [dbuser\s*\=>\s*'[^']*'] [dbuser => 'resale_delavo'] [Mon Sep 19 15:26:31 2011] DataModify OK delavo/kit.hostconf/config/hostconf_db.conf.en.comp.pl [dbpass\s*\=>\s*'[^']*'] [dbpass => 'lotito1234'] [Mon Sep 19 15:26:31 2011] FileCopy OK delavo/kit.main/main.cgi to delavo/jin.cgi [Mon Sep 19 15:26:31 2011] FileChmod OK delavo/jin.cgi 0755 [Mon Sep 19 15:26:31 2011] FileChmod OK delavo/helpticket.pl 0755 [Mon Sep 19 15:26:31 2011] DataModify OK delavo/helpticket.pl [http\:\/\/localhost\/minima\/jin] [http://www.resalerightshome.com/delavo/delavo] [Mon Sep 19 15:26:31 2011] DataModify OK delavo/zen-loader/config.jin [(Language\s+)en] [Language en] [Mon Sep 19 15:26:31 2011] FilePasstree OK delavo/skins/headfoot/delavo/img.en [.+] [copy($_, "../img/$_")] [Mon Sep 19 15:26:31 2011] FilePasstree OK delavo/php/ [\.php$] [chmod 0644, $_] [Mon Sep 19 15:26:31 2011] FilePasstree OK delavo/mce/ [\.php$] [chmod 0644, $_] [Mon Sep 19 15:26:34 2011] CallURL OK http://www.resalerightshome.com/delavo/delavo/action/Jin/Update/init_templates.txt?set_skins=headfoot/delavo,packord/delavord,shopcart/delavosc [Mon Sep 19 15:26:34 2011] TstampFile OK delavo/install.tstamp [Mon Sep 19 15:26:34 2011] EndLog OK