SET SESSION sql_mode = '';
insert into jin_user set id=1,signature='44E241BF140EA4C0',registered=1,regtime=now(),email='matt@jvmanager.com',passwd='04746573740d86cb5a2d39fb3419507a',name='Site Administrator',fname='Site',lname='Administrator';

insert into jin_role set id=1,title='Supervisor',priv_supervisor=1;
insert into jin_user_role set id=1,role_id=1,role_title='Supervisor',user_id=1;

insert into jin_role set id=3,title='Standard Customer and Affiliate',priv_auth_profile_login=1,priv_auth_profile_member=1,priv_auth_profile_affpgates=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,priv_member_promote_royalties=1,priv_member_promote_payroyalties=1;
INSERT INTO `jin_role` (`id`, `title`, `needapproval`, `enhanced_mode`, `priv_supervisor`, `priv_auth_profile_login`, `priv_auth_profile_merchant`, `priv_auth_profile_smtpservers`, `priv_auth_profile_apicenter`, `priv_auth_profile_security`, `priv_auth_profile_member`, `priv_auth_profile_pgates`, `priv_auth_profile_affpgates`, `priv_master_store_packages`, `priv_master_store_products`, `priv_master_store_funnels`, `priv_master_store_oneclickords`, `priv_master_store_minisites`, `priv_master_store_jvproducts`, `priv_master_store_specprices`, `priv_master_store_shopcarts`, `priv_master_store_otos`, `priv_master_store_downloads`, `priv_master_store_brandpdfs`, `priv_master_store_memberships`, `priv_master_store_quests`, `priv_master_store_extscripts`, `priv_master_store_taxes`, `priv_master_store_shippings`, `priv_master_customers_sales`, `priv_master_customers_jvmsubs`, `priv_master_customers_actsubs`, `priv_master_customers_memberships`, `priv_master_customers_quests`, `priv_master_customers_extscripts`, `priv_master_customers_shipdue`, `priv_master_customers_tracklinks`, `priv_master_affiliates_users`, `priv_master_affiliates_affprogs`, `priv_master_affiliates_campaigns`, `priv_master_affiliates_series`, `priv_master_affiliates_commissions`, `priv_master_affiliates_paycomms`, `priv_master_affiliates_royalties`, `priv_master_users_all`, `priv_master_users_massmail`, `priv_master_users_massuserop`, `priv_master_users_roles`, `priv_master_users_specusers`, `priv_master_users_customfields`, `priv_master_users_downlines`, `priv_master_users_import`, `priv_master_users_invite`, `priv_master_users_approve`, `priv_master_users_insignia`, `priv_master_tools_stats`, `priv_master_tools_templates`, `priv_master_tools_emails`, `priv_master_tools_customtags`, `priv_master_tools_forms`, `priv_master_tools_bans`, `priv_master_tools_coupons`, `priv_master_tools_rewards`, `priv_master_tools_shorturls`, `priv_master_tools_export`, `priv_master_tools_pieces`, `priv_master_tools_dbbackup`, `priv_master_tools_satelliteinstallations`, `priv_master_plugins_invoicepdfs`, `priv_master_plugins_promogen`, `priv_master_plugins_sponsorships`, `priv_master_plugins_supros`, `priv_master_plugins_banners`, `priv_master_plugins_linkdirs`, `priv_master_plugins_alerts`, `priv_master_plugins_testimonials`, `priv_master_plugins_followupman`, `priv_master_plugins_jvevents`, `priv_master_plugins_affinbs`, `priv_master_plugins_pages`, `priv_master_plugins_geoforce`, `priv_master_plugins_blogpub`, `priv_master_plugins_bcastnews`, `priv_master_plugins_certman`, `priv_master_plugins_clouds`, `priv_master_plugins_multrec`, `priv_master_plugins_reminders`, `priv_master_plugins_helptickets`, `priv_master_plugins_metaaffs`, `priv_master_plugins_contseries`, `priv_master_plugins_lessonman`, `priv_master_plugins_surveys`, `priv_master_plugins_trackurls`, `priv_master_plugins_ezinepoints`, `priv_member_account_purchases`, `priv_member_account_mems`, `priv_member_account_jvmsubs`, `priv_member_account_ccupdate`, `priv_member_account_points`, `priv_member_account_helptickets`, `priv_member_account_backlink`, `priv_member_account_surveys`, `priv_member_promote_dashboard`, `priv_member_promote_affprogs`, `priv_member_promote_links`, `priv_member_promote_campaigns`, `priv_member_promote_sales`, `priv_member_promote_commissions`, `priv_member_promote_jvproducts`, `priv_member_promote_royalties`, `priv_member_promote_payroyalties`, `priv_member_downline_view`, `priv_member_downline_massmail`, `priv_member_downline_commissions`, `priv_member_downline_refer`, `priv_spec_maildownlinenofooter`, `priv_spec_yourcommissionseecustomer`, `priv_spec_yourcommissionseezero`, `priv_spec_autoresowncust`, `priv_spec_autoresrefcust`, `limit_massmailnumber`, `limit_massmailperiod`, `limit_memberships`, `limit_labels`)
VALUES
	(4, 'Demo mode', 0, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 'add', 'add', 'add', 'add', 'add', '', 'add', 'add', 'add', 'add', 'add', 'add', 'add', 'add', '', '', 'add', '', '', 'add', 'add', 'add', '', '', '', 'add', '', '', '', '', '', 'add', '', '', 'add', 'add', '', 'add', '', '', '', '', '', '', '', 'add', '', '', 'add', '', 'add', '', '', '', '', 'add', '', '', 'add', '', 'add', '', 'add', '', 'add', '', 'add', 'add', '', 'add', '', '', '', 'add', 'add', 'add', 'add', 'add', '', 'add', 'add', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', 0, 0, 0, 0, 0, '', 'day', '', '');


insert into jin_merchant_settings set id=1, currency='USD', autoassign_roles=3, refsale_autocancel_period=30, ccupdate_request_intervals='3,-15,-10,-5,-1';

insert into jin_jvevent_rights (id, title) values (1, 'Can be sold');
insert into jin_jvevent_rights (id, title) values (2, 'Sales page included');
insert into jin_jvevent_rights (id, title) values (3, 'Can be given away');
insert into jin_jvevent_rights (id, title) values (4, 'Can be added to free membership sites');
insert into jin_jvevent_rights (id, title) values (5, 'Can be added to paid membership sites');
insert into jin_jvevent_rights (id, title) values (6, 'Can be offered as a bonus');
insert into jin_jvevent_rights (id, title) values (7, 'Can be packaged with other products');
insert into jin_jvevent_rights (id, title) values (8, 'Can be offered through auction sites');
insert into jin_jvevent_rights (id, title) values (9, 'Can be customized');
insert into jin_jvevent_rights (id, title) values (10, 'Can be edited completely and your name put on it');
insert into jin_jvevent_rights (id, title) values (11, 'Can be broken down into smaller articles');
insert into jin_jvevent_rights (id, title) values (12, 'Can be added to an e-course or autoresponder');
insert into jin_jvevent_rights (id, title) values (13, 'Can be used as web content');
insert into jin_jvevent_rights (id, title) values (14, 'Can sell Resale Rights');
insert into jin_jvevent_rights (id, title) values (15, 'Can sell Master Resale Rights');
insert into jin_jvevent_rights (id, title) values (16, 'Can sell Private Label Rights');
insert into jin_jvevent_rights (id, title) values (17, 'Can sell Transferable Master Resale Rights');
insert into jin_jvevent_rights (id, title) values (18, 'Can sell Transferable Private Label Rights');

insert into jin_shipping_group set id=1, title='Default Shipping Group';
