<?php


class ganryu_shop_boot_Install{

	function prepareHook($pluginFile){
		register_activation_hook($pluginFile, array($this, "install"));
	}

	function install(){
		error_log('install');
		require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
		global $wpdb;
		$charset_collate = $wpdb->get_charset_collate();
		
		$tbl = grys_tablename('item');
		
		$sql = "
	CREATE TABLE ${tbl} (
	itemid int not null auto_increment,
	itemcode varchar(50) not null,
	itemtype int not null,
	itemname varchar(1000),
	itemdetail text,
	keywords text,
	sozai varchar(100),
	gensan varchar(100),
	sizetabledata longtext,
	image varchar(50),
	images varchar(2000),
	price_min int not null,
	price_max int not null,
	subitem_ct int not null,
	point_rate int,
	relation_item varchar(500),
	is_close int not null,
	deleted int not null,
	create_date datetime,
	modify_date datetime,
	category_setup text,
	primary key (itemid)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );

		$tbl = grys_tablename('item_type');
		
		$sql = "
	CREATE TABLE ${tbl} (
	id int not null auto_increment,
	itemid int not null,
	itemtype int not null,
	valid int not null,
	primary key (id)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );


	$tbl = grys_tablename('subitem');
	
	$sql = "
		CREATE TABLE ${tbl} (
			subitemid int not null auto_increment,
			itemid int not null,
			category1 int not null,
			category2 int not null,
			category3 int not null,
			subprice int,
			stock_count int not null,
			stock_nolimit int,
			limit_count int,
			is_close int not null,
			deleted int not null,
			create_date datetime,
			modify_date datetime,
			primary key (subitemid),
			key (itemid, category1, category2, category3)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
	";
		
		error_log($sql);
		
		dbDelta( $sql );

		$tbl = grys_tablename('item_image');
		
		$sql = "
	CREATE TABLE ${tbl} (
		imageid int not null auto_increment,
		session varchar(100) not null,
		size varchar(100) not null,
		data longblob,
		opt text,
		expire_date datetime,
		valid int not null,
		primary key (imageid),
		unique key(session, size)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );



		$tbl = grys_tablename('purchase_log');
		
		$sql = "
	CREATE TABLE ${tbl} (
	purchaseid int not null auto_increment,
	purchasecode varchar(100) not null,
	userid int not null,
	paytype int not null,
	zip1 varchar(10),
	zip2 varchar(10),
	prefecture_code int,
	address_1 varchar(200),
	address_2 varchar(200),
	address_3 varchar(200),
	company_name varchar(200),
	tel1 varchar(100),
	tel2 varchar(100),
	tel3 varchar(100),
	address_name_sei varchar(100),
	address_name_mei varchar(100),
	address_name_kana_sei varchar(100),
	address_name_kana_mei varchar(100),
	memo text,
	status int not null comment '1:進行中,9:キャンセル',
	payment_status int not null comment '1: 支払待,2:支払済',
	deliv_status int not null comment '1:発送待ち,2:発送済',
	price_sum int not null,
	price_tax_sum int not null,
	count_sum int not null,
	tax_cost int not null,
	deliv_cost int not null,
	extra_cost int not null,
	pay_money int not null,
	pay_point int not null,
	get_point int not null,
	create_date datetime,
	payment_date datetime,
	deliv_date datetime,
	modify_date datetime,
	email varchar(500),
	payment_media int,
	primary key (purchaseid),
	unique key (purchasecode)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );



		$tbl = grys_tablename('purchase_item_log');
		
		$sql = "
	CREATE TABLE ${tbl} (
	id int not null auto_increment,
	purchaseid int not null,
	itemid int not null,
	subitemid int not null,
	category1 int not null,
	category2 int not null,
	category3 int not null,
	num int not null,
	price_unit int not null,
	price_total int not null,
	price_total_tax int not null,
	point_rate int not null,
	get_point int not null,
	primary key (id)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );
	
		error_log('do delta');

		$tbl = grys_tablename('item_category');
		

		$sql = "

	CREATE TABLE ${tbl} (
	cateid int not null auto_increment,
	itemid int not null,
	catepos int not null,
	ord int not null,
	catelabel varchar(200),
	image varchar(100),
	valid int not null,
	primary key(cateid),
	key (itemid)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};

		";
		error_log($sql);
		
		dbDelta( $sql );
	
		error_log('do delta');

		$tbl = grys_tablename('user_address');
		

		$sql = "

CREATE TABLE $tbl (
	addressid int not null auto_increment,
	userid int not null,
	zip1 varchar(10),
	zip2 varchar(10),
	prefecture_code int,
	address_1 varchar(200),
	address_2 varchar(200),
	address_3 varchar(200),
	company_name varchar(200),
	tel1 varchar(100),
	tel2 varchar(100),
	tel3 varchar(100),
	address_name_sei varchar(100),
	address_name_mei varchar(100),
	address_name_kana_sei varchar(100),
	address_name_kana_mei varchar(100),
	create_date datetime,
	modify_date datetime,
	lastuse_date datetime,
	valid int not null,
	ismain int,
	primary key (addressid),
	key (userid)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );
	
		error_log('do delta');


		$tbl = grys_tablename('purchase_deliv_log');
		
		

		$sql = "

CREATE TABLE $tbl (
	delivid int not null auto_increment,
	purchaseid int not null,
	delivno int not null,
	wish_day date,
	wish_time varchar(10),
	zip1 varchar(10),
	zip2 varchar(10),
	prefecture_code int,
	address_1 varchar(200),
	address_2 varchar(200),
	address_3 varchar(200),
	company_name varchar(200),
	tel1 varchar(100),
	tel2 varchar(100),
	tel3 varchar(100),
	address_name_sei varchar(100),
	address_name_mei varchar(100),
	address_name_kana_sei varchar(100),
	address_name_kana_mei varchar(100),
	itemcart text,
	valid int not null,
	primary key (delivid)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );
	
		error_log('do delta');




		$tbl = grys_tablename('user_point');
		

		$sql = "

CREATE TABLE $tbl (
	userid int not null,
	current_point int,
	primary key (userid)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );
	
		error_log('do delta');



		$tbl = grys_tablename('user_point_log');
		

		$sql = "

CREATE TABLE $tbl (
	logid int not null auto_increment,
	userid int not null,
	point_category varchar(100) not null,
	point_type varchar(100) not null,
	point_value int not null,
	point_name varchar(100),
	extent_info varchar(2000),
	create_date datetime not null,
	primary key (logid),
	key (userid)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );
	
		error_log('do delta');

		$tbl = grys_tablename('user_item_fav');
		

		$sql = "

CREATE TABLE $tbl (
	id int not null auto_increment,
	userid int not null,
	itemid int not null,
	valid int not null,
	create_date datetime not null,
	primary key (id),
	unique key (userid, itemid)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );
	
		error_log('do delta');


		$tbl = grys_tablename('config');
		

		$sql = "

CREATE TABLE $tbl (
	configid int not null auto_increment,
	configkey varchar(100) not null,
	value text,
	primary key (configid),
	unique key(configkey)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );
	
		error_log('do delta');


		$tbl = grys_tablename('session');
		

		$sql = "

CREATE TABLE $tbl (
	id int not null auto_increment,
	session_key varchar(50) not null,
	session_value longblob,
	update_date datetime,
	expire_date datetime,
	primary key (id),
	unique key (session_key),
	key(expire_date)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );
	
		error_log('do delta');


		$tbl = grys_tablename('share_sns');
		

		$sql = "

CREATE TABLE $tbl (
	shareid int not null auto_increment,
	userid int not null,
	articletype int not null comment '1:article',
	articleid int not null,
	sns varchar(10) not null,
	sharecode varchar(40) not null,
	valid int not null,
	primary key (shareid),
	unique key (sharecode),
	unique key (userid, articletype, articleid, sns)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );
	
		error_log('do delta');

		$tbl = grys_tablename('share_sns_log');
		

		$sql = "

CREATE TABLE $tbl (
	id int not null auto_increment,
	shareid int not null,
	userid int not null,
	uniq_session varchar(50),
	create_date_day date,
	create_date datetime,
	ip varchar(50),
	user_agent varchar(500),
	referer varchar(500),
	primary key (id),
	key (shareid)
	) ENGINE=InnoDB DEFAULT CHARSET=${charset_collate};
		";
		error_log($sql);
		
		dbDelta( $sql );
	
		error_log('do delta');



	}




}