# Database Backup For 誰でもつくれるホームページ Series
# Copyright (c) 2005 LantechSoftware co.,ltd.
# http://www.919homepage.com/
#
# Database: meditate
#
# Backup Date: 2005/09/22 14:34:32

drop table if exists easy_account;
create table easy_account (
  seq_no tinyint(4) not null auto_increment,
  bank varchar(40) ,
  siten varchar(40) ,
  account varchar(40) ,
  btype varchar(40) ,
  o_name varchar(40) ,
  bank2 varchar(40) ,
  siten2 varchar(40) ,
  account2 varchar(40) ,
  btype2 varchar(40) ,
  o_name2 varchar(40) ,
  bank3 varchar(40) ,
  siten3 varchar(40) ,
  account3 varchar(40) ,
  btype3 varchar(40) ,
  o_name3 varchar(40) ,
  ykoza varchar(255) ,
  yubin varchar(255) ,
  ipcode varchar(40) ,
  shopcode varchar(40) ,
  ownermsg mediumtext ,
  SMTPname varchar(128) ,
  mailsubject varchar(128) ,
  mailheader mediumtext ,
  mailfooter mediumtext ,
  view_flag char(1) default '0' not null ,
  hikikae char(1) ,
  tax int(6) unsigned default '0' not null ,
  usedeliverycost char(1) ,
  input_name char(1) default '1' not null ,
  input_address char(1) default '1' not null ,
  input_tel char(1) default '1' not null ,
  input_email char(1) default '1' not null ,
  exchange_tax char(1) default '1' not null ,
  exchange_deli char(1) default '1' not null ,
  sendmail_admin char(1) default '0' not null ,
  sendmail_user char(1) default '0' not null ,
  usedelitax char(1) not null ,
  u_totle1 varchar(255) ,
  u_type1 char(1) default '1' not null ,
  u_message1 mediumtext ,
  u_totle2 varchar(255) ,
  u_type2 char(1) default '1' not null ,
  u_message2 mediumtext ,
  u_totle3 varchar(255) ,
  u_type3 char(1) default '1' not null ,
  u_message3 mediumtext ,
  u_totle4 varchar(255) ,
  u_type4 char(1) default '1' not null ,
  u_message4 mediumtext ,
  u_totle5 varchar(255) ,
  u_type5 char(1) default '1' not null ,
  u_message5 mediumtext ,
  kessai_mode char(1) default '0' not null ,
  reg_degichk char(1) default '0' not null ,
  ipcode2 varchar(40) ,
  PRIMARY KEY (seq_no)
);

insert into easy_account (seq_no, bank, siten, account, btype, o_name, bank2, siten2, account2, btype2, o_name2, bank3, siten3, account3, btype3, o_name3, ykoza, yubin, ipcode, shopcode, ownermsg, SMTPname, mailsubject, mailheader, mailfooter, view_flag, hikikae, tax, usedeliverycost, input_name, input_address, input_tel, input_email, exchange_tax, exchange_deli, sendmail_admin, sendmail_user, usedelitax, u_totle1, u_type1, u_message1, u_totle2, u_type2, u_message2, u_totle3, u_type3, u_message3, u_totle4, u_type4, u_message4, u_totle5, u_type5, u_message5, kessai_mode, reg_degichk, ipcode2) values ('1', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', '', '1', NULL, '0', NULL, '1', '1', '1', '1', '1', '1', '0', '0', '', NULL, '1', NULL, NULL, '1', NULL, NULL, '1', NULL, NULL, '1', NULL, NULL, '1', NULL, '0', '0', NULL);

drop table if exists easy_board_data;
create table easy_board_data (
  no int(20) not null auto_increment,
  parent_menu_id int(20) default '0' not null ,
  gnum int(20) default '0' not null ,
  gseq int(20) default '0' not null ,
  member_id varchar(15) not null ,
  level int(8) default '0' not null ,
  password varchar(255) not null ,
  name varchar(20) not null ,
  homepage varchar(255) not null ,
  email varchar(255) not null ,
  subject varchar(255) not null ,
  content text not null ,
  use_html char(1) not null ,
  file_name1 varchar(255) not null ,
  file_name2 varchar(255) not null ,
  s_file_name1 varchar(255) not null ,
  s_file_name2 varchar(255) not null ,
  down_count_file_1 int(20) default '0' not null ,
  down_count_file_2 int(20) default '0' not null ,
  read_count int(20) default '0' not null ,
  reg_ip varchar(17) not null ,
  reg_date int(13) default '0' not null ,
  status char(1) default '1' not null ,
  parent_no int(11) default '0' not null ,
  PRIMARY KEY (no),
  UNIQUE no (no),
  KEY status (status),
  KEY parent_menu_id (parent_menu_id),
  KEY gnum (gnum),
  KEY gseq (gseq)
);


drop table if exists easy_board_info;
create table easy_board_info (
  no int(11) not null auto_increment,
  parent_menu_id int(11) default '0' not null ,
  name varchar(255) not null ,
  skinname varchar(15) not null ,
  page_num int(3) default '0' not null ,
  cut_title_num tinyint(3) default '0' not null ,
  list_num int(3) default '0' not null ,
  use_preview_board char(1) not null ,
  use_reply char(1) not null ,
  use_comment char(1) not null ,
  use_file_upload char(1) not null ,
  use_user_level int(3) default '0' not null ,
  use_auto_link char(1) not null ,
  status char(1) default '1' not null ,
  orderby char(1) default '0' ,
  newres char(1) default '0' ,
  link_mail char(1) default '1' ,
  use_pass char(1) default '0' ,
  PRIMARY KEY (no)
);

insert into easy_board_info (no, parent_menu_id, name, skinname, page_num, cut_title_num, list_num, use_preview_board, use_reply, use_comment, use_file_upload, use_user_level, use_auto_link, status, orderby, newres, link_mail, use_pass) values ('1', '0', '掲示板', 'gray', '10', '0', '10', '', '1', '1', '
', '2', '1', '1', '0', '0', '1', '0');

drop table if exists easy_bonuspoint;
create table easy_bonuspoint (
  Seq_no int(11) not null auto_increment,
  user_id varchar(20) not null ,
  cash int(11) default '0' not null ,
  tr_date datetime default '0000-00-00 00:00:00' not null ,
  type char(1) not null ,
  PRIMARY KEY (Seq_no)
);


drop table if exists easy_box_data;
create table easy_box_data (
  no int(11) not null auto_increment,
  parent_box_list_id int(11) default '0' not null ,
  order_num int(11) default '0' not null ,
  content_type varchar(10) not null ,
  title varchar(255) not null ,
  banner_image varchar(255) not null ,
  banner_open_type varchar(30) not null ,
  banner_popup_width int(20) default '0' not null ,
  banner_popup_height int(20) default '0' not null ,
  banner_popup_show_navbar char(1) not null ,
  banner_popup_show_urlbar char(1) not null ,
  banner_popup_show_menubar char(1) not null ,
  banner_url varchar(255) not null ,
  text_image varchar(255) not null ,
  text_content mediumtext not null ,
  use_text_prview char(1) not null ,
  prv_cut_num int(13) default '0' not null ,
  top_editmode varchar(4) not null ,
  show_title char(1) ,
  PRIMARY KEY (no),
  KEY parent_box_list_id (parent_box_list_id)
);


drop table if exists easy_box_list;
create table easy_box_list (
  box_id int(11) not null auto_increment,
  parent_menu_id int(11) default '0' not null ,
  position_in_menu varchar(10) not null ,
  order_num int(11) default '0' not null ,
  box_type varchar(30) not null ,
  skin_name varchar(255) default '0' not null ,
  title varchar(255) not null ,
  banner_image varchar(255) not null ,
  banner_open_type varchar(30) not null ,
  banner_popup_width int(20) default '0' not null ,
  banner_popup_height int(20) default '0' not null ,
  banner_popup_show_navbar char(1) not null ,
  banner_popup_show_urlbar char(1) not null ,
  banner_popup_show_menubar char(1) not null ,
  banner_url varchar(255) not null ,
  PRIMARY KEY (box_id),
  KEY box_id (box_id)
);


drop table if exists easy_comment;
create table easy_comment (
  no int(20) not null auto_increment,
  parent_content_id int(20) default '0' not null ,
  content_num int(11) default '0' not null ,
  name varchar(20) not null ,
  password varchar(255) not null ,
  memo text not null ,
  reg_ip varchar(15) not null ,
  reg_date int(15) default '0' not null ,
  content_type varchar(255) not null ,
  del_flag char(1) default '0' not null ,
  PRIMARY KEY (no),
  KEY no (no, parent_content_id),
  KEY content_type (content_type)
);


drop table if exists easy_deliverycost;
create table easy_deliverycost (
  no int(20) not null auto_increment,
  prefecture varchar(10) default '0' not null ,
  cost int(6) unsigned default '0' ,
  PRIMARY KEY (no),
  UNIQUE no (no),
  KEY prefecture (prefecture)
);

insert into easy_deliverycost (no, prefecture, cost) values ('1', '北海道', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('2', '青森県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('3', '岩手県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('4', '宮城県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('5', '秋田県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('6', '山形県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('7', '福島県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('8', '茨城県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('9', '栃木県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('10', '群馬県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('11', '埼玉県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('12', '千葉県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('13', '東京都', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('14', '神奈川県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('15', '山梨県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('16', '静岡県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('17', '長野県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('18', '新潟県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('19', '富山県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('20', '石川県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('21', '福井県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('22', '岐阜県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('23', '愛知県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('24', '三重県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('25', '滋賀県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('26', '京都府', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('27', '大阪府', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('28', '兵庫県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('29', '奈良県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('30', '和歌山県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('31', '鳥取県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('32', '島根県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('33', '岡山県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('34', '広島県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('35', '山口県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('36', '徳島県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('37', '香川県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('38', '愛媛県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('39', '高知県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('40', '福岡県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('41', '佐賀県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('42', '長崎県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('43', '熊本県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('44', '大分県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('45', '宮崎県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('46', '鹿児島県', '0');
insert into easy_deliverycost (no, prefecture, cost) values ('47', '沖縄県', '0');

drop table if exists easy_diary_data;
create table easy_diary_data (
  no int(20) not null auto_increment,
  parent_menu_id int(11) default '0' not null ,
  title_text varchar(255) not null ,
  title_font_name varchar(255) not null ,
  title_font_size varchar(255) not null ,
  title_font_size_color varchar(20) not null ,
  page_content_1 mediumtext not null ,
  page_content_2 mediumtext not null ,
  order_num int(13) default '0' not null ,
  is_show char(1) not null ,
  read_count int(20) default '0' not null ,
  reg_ip varchar(15) not null ,
  reg_date int(15) default '0' not null ,
  page_content_mode1 varchar(4) not null ,
  page_content_mode2 varchar(4) not null ,
  PRIMARY KEY (no)
);


drop table if exists easy_diary_info;
create table easy_diary_info (
  no int(20) not null auto_increment,
  parent_menu_id int(11) default '0' not null ,
  skinname varchar(255) not null ,
  list_num tinyint(3) default '0' not null ,
  page_num tinyint(3) default '0' not null ,
  PRIMARY KEY (no)
);

insert into easy_diary_info (no, parent_menu_id, skinname, list_num, page_num) values ('1', '0', 'default', '10', '10');

drop table if exists easy_exchange;
create table easy_exchange (
  no int(20) not null auto_increment,
  from_kingaku int(8) unsigned default '0' ,
  to_kingaku int(8) unsigned default '0' ,
  tesuryo int(8) unsigned default '0' ,
  PRIMARY KEY (no),
  UNIQUE no (no)
);

insert into easy_exchange (no, from_kingaku, to_kingaku, tesuryo) values ('1', '0', '0', '0');
insert into easy_exchange (no, from_kingaku, to_kingaku, tesuryo) values ('2', '0', '0', '0');
insert into easy_exchange (no, from_kingaku, to_kingaku, tesuryo) values ('3', '0', '0', '0');
insert into easy_exchange (no, from_kingaku, to_kingaku, tesuryo) values ('4', '0', '0', '0');
insert into easy_exchange (no, from_kingaku, to_kingaku, tesuryo) values ('5', '0', '0', '0');
insert into easy_exchange (no, from_kingaku, to_kingaku, tesuryo) values ('6', '0', '0', '0');
insert into easy_exchange (no, from_kingaku, to_kingaku, tesuryo) values ('7', '0', '0', '0');
insert into easy_exchange (no, from_kingaku, to_kingaku, tesuryo) values ('8', '0', '0', '0');
insert into easy_exchange (no, from_kingaku, to_kingaku, tesuryo) values ('9', '0', '0', '0');
insert into easy_exchange (no, from_kingaku, to_kingaku, tesuryo) values ('10', '0', '0', '0');

drop table if exists easy_gallery_data;
create table easy_gallery_data (
  no int(20) not null auto_increment,
  parent_menu_id int(11) default '0' not null ,
  subject varchar(60) not null ,
  content text not null ,
  small_image varchar(255) not null ,
  preview_cut_num int(3) default '0' not null ,
  big_image varchar(255) not null ,
  read_count int(13) default '0' not null ,
  reg_ip varchar(17) not null ,
  reg_date int(13) default '0' not null ,
  status char(1) not null ,
  PRIMARY KEY (no)
);


drop table if exists easy_gallery_info;
create table easy_gallery_info (
  no int(20) not null auto_increment,
  parent_menu_id int(11) default '0' not null ,
  skinname varchar(255) not null ,
  list_num int(3) default '0' not null ,
  page_num int(3) default '0' not null ,
  list_cols_num int(3) default '3' not null ,
  first_mode varchar(20) default 'LIST' not null ,
  show_go_list char(1) default '1' not null ,
  comment char(1) default '1' not null ,
  PRIMARY KEY (no)
);

insert into easy_gallery_info (no, parent_menu_id, skinname, list_num, page_num, list_cols_num, first_mode, show_go_list, comment) values ('1', '0', 'default', '10', '9', '3', 'LIST', '1', '1');

drop table if exists easy_html_data;
create table easy_html_data (
  no int(11) not null auto_increment,
  parent_menu_id int(11) ,
  html_type char(1) ,
  show_mode char(1) ,
  content longtext ,
  html_file_name varchar(255) ,
  image_num int(11) ,
  pop_html_width int(11) default '0' not null ,
  pop_html_height tinyint(4) default '0' not null ,
  PRIMARY KEY (no)
);


drop table if exists easy_member_list;
create table easy_member_list (
  no int(20) not null auto_increment,
  user_id varchar(20) not null ,
  passwd varchar(100) not null ,
  name varchar(20) ,
  jumin_num varchar(18) ,
  birthday datetime ,
  homepage varchar(255) ,
  email varchar(255) ,
  job varchar(50) ,
  hobby varchar(50) ,
  zipcode varchar(9) ,
  home_address varchar(255) ,
  home_tel varchar(20) ,
  office_address varchar(255) ,
  office_tel varchar(255) ,
  handphone varchar(20) ,
  is_admin char(1) not null ,
  comment text ,
  regdate datetime ,
  name_first varchar(20) ,
  kana varchar(20) ,
  kana_first varchar(20) ,
  home_address2 varchar(255) ,
  home_fax varchar(20) ,
  prefecture varchar(20) ,
  PRIMARY KEY (no),
  UNIQUE user_id (user_id),
  KEY no (no, user_id)
);

insert into easy_member_list (no, user_id, passwd, name, jumin_num, birthday, homepage, email, job, hobby, zipcode, home_address, home_tel, office_address, office_tel, handphone, is_admin, comment, regdate, name_first, kana, kana_first, home_address2, home_fax, prefecture) values ('1', 'adminuser', '81dc9bdb52d04dc20036dbd8313ed055', 'Admin', '1231234', '1999-11-30 00:00:00', '', '', '会社員;大学生', '読書;映画鑑賞;音楽鑑賞', '', '', '', '', '', '', '1', '', '2002-12-20 18:42:29', NULL, NULL, NULL, NULL, NULL, NULL);
insert into easy_member_list (no, user_id, passwd, name, jumin_num, birthday, homepage, email, job, hobby, zipcode, home_address, home_tel, office_address, office_tel, handphone, is_admin, comment, regdate, name_first, kana, kana_first, home_address2, home_fax, prefecture) values ('2', 'maditate', '8a6291222743f26208faf4cb4969f56e', '葛城', '1620053', '1985-02-02 00:00:00', 'http://maditate.919homepage.com/admin', 'constitution906@yahoo.co.jp', '大学生', '音楽鑑賞', NULL, '', '', '', '', '090-9369-7320', '1', '', '2005-09-21 21:26:46', '真澄', 'カツラギ', 'マスミ', '', '', '東京都');

drop table if exists easy_member_optional_input;
create table easy_member_optional_input (
  no int(20) not null auto_increment,
  skinname varchar(255) not null ,
  check_jumin_num char(1) not null ,
  check_birthday char(1) not null ,
  check_homepage char(1) not null ,
  check_email char(1) not null ,
  check_job char(1) not null ,
  list_job varchar(255) not null ,
  check_hobby char(1) not null ,
  list_hobby varchar(255) not null ,
  check_zipcode char(1) not null ,
  check_home_address char(1) not null ,
  check_home_tel char(1) not null ,
  check_office_address char(1) not null ,
  check_office_tel char(1) not null ,
  check_handphone char(1) not null ,
  check_comment char(1) not null ,
  use_treaty char(1) default '1' not null ,
  treaty text not null ,
  signupinfo mediumtext ,
  disp_name char(1) default '1' ,
  disp_birthday char(1) default '1' ,
  disp_homepage char(1) default '1' ,
  disp_email char(1) default '1' ,
  disp_job char(1) default '1' ,
  disp_hobby char(1) default '1' ,
  disp_zipcode char(1) default '1' ,
  disp_home_address char(1) default '1' ,
  disp_home_tel char(1) default '1' ,
  disp_office_address char(1) default '1' ,
  disp_office_tel char(1) default '1' ,
  disp_handphone char(1) default '1' ,
  disp_comment char(1) default '1' ,
  check_home_fax char(1) default '0' ,
  disp_home_fax char(1) default '1' ,
  PRIMARY KEY (no)
);

insert into easy_member_optional_input (no, skinname, check_jumin_num, check_birthday, check_homepage, check_email, check_job, list_job, check_hobby, list_hobby, check_zipcode, check_home_address, check_home_tel, check_office_address, check_office_tel, check_handphone, check_comment, use_treaty, treaty, signupinfo, disp_name, disp_birthday, disp_homepage, disp_email, disp_job, disp_hobby, disp_zipcode, disp_home_address, disp_home_tel, disp_office_address, disp_office_tel, disp_handphone, disp_comment, check_home_fax, disp_home_fax) values ('1', 'default', '1', '1', '1', '1', '', '会社員;大学生;主婦
', '', '読書;映画鑑賞;音楽鑑賞', '1', '', '', '', '', '1', '', '1', '+-------------------------------------------------------+
                 ユーザ登録に関してのご注意
+-------------------------------------------------------+
ユーザ登録に関しての「約款内容」を入力します。', NULL, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1');

drop table if exists easy_menu_list;
create table easy_menu_list (
  menu_id int(11) not null auto_increment,
  parent_id int(11) default '0' not null ,
  location int(11) default '0' not null ,
  level int(11) default '0' not null ,
  status char(1) not null ,
  user_level char(1) default '0' not null ,
  parent_box_show char(1) default '1' not null ,
  menu_title varchar(255) not null ,
  menu_image varchar(255) not null ,
  browser_title varchar(255) not null ,
  top_html text not null ,
  bottom_html text not null ,
  main_content_type varchar(200) not null ,
  up_text_show char(1) ,
  down_text_show char(1) ,
  PRIMARY KEY (menu_id),
  KEY parent_id (parent_id)
);

insert into easy_menu_list (menu_id, parent_id, location, level, status, user_level, parent_box_show, menu_title, menu_image, browser_title, top_html, bottom_html, main_content_type, up_text_show, down_text_show) values ('0', '-1', '0', '0', '1', '0', '1', 'main', '', '', '<html>
<head>
<style>P {margin-top:2px;margin-bottom:2px;}</style>
</head>
<body>
<P align=center><FONT color=#3333ff size=7><STRONG></STRONG></FONT></P>
<P align=center>&nbsp;</P>
</body>
</html>', '<html>
<head>
<style>P {margin-top:2px;margin-bottom:2px;}</style>
</head>
<body>
<P>&nbsp;</P>
</body>
</html>', 'NEWS', NULL, NULL);

drop table if exists easy_news_data;
create table easy_news_data (
  no int(20) not null auto_increment,
  parent_menu_id int(11) default '0' not null ,
  title_text varchar(255) not null ,
  title_font_name varchar(255) not null ,
  title_font_size varchar(255) not null ,
  title_font_size_color varchar(20) not null ,
  title_icon_url varchar(255) not null ,
  small_title_image varchar(255) not null ,
  view_type int(3) default '0' not null ,
  preview_cut_num int(5) default '0' not null ,
  total_page int(5) default '0' not null ,
  page_content_1 mediumtext not null ,
  page_content_2 mediumtext not null ,
  page_content_3 mediumtext not null ,
  page_content_4 mediumtext not null ,
  page_content_5 mediumtext not null ,
  page_content_6 mediumtext not null ,
  page_content_7 mediumtext not null ,
  page_content_8 mediumtext not null ,
  page_content_9 mediumtext not null ,
  page_content_10 mediumtext not null ,
  order_num int(13) default '0' not null ,
  is_show char(1) not null ,
  read_count int(20) default '0' not null ,
  reg_ip varchar(15) not null ,
  reg_date int(15) default '0' not null ,
  page_content_mode1 varchar(4) not null ,
  page_content_mode2 varchar(4) not null ,
  page_content_mode3 varchar(4) not null ,
  page_content_mode4 varchar(4) not null ,
  page_content_mode5 varchar(4) not null ,
  page_content_mode6 varchar(4) not null ,
  page_content_mode7 varchar(4) not null ,
  page_content_mode8 varchar(4) not null ,
  page_content_mode9 varchar(4) not null ,
  page_content_mode10 varchar(4) not null ,
  PRIMARY KEY (no)
);


drop table if exists easy_news_info;
create table easy_news_info (
  no int(20) not null auto_increment,
  parent_menu_id int(11) default '0' not null ,
  skinname varchar(255) not null ,
  list_num tinyint(3) default '0' not null ,
  page_num tinyint(3) default '0' not null ,
  PRIMARY KEY (no)
);

insert into easy_news_info (no, parent_menu_id, skinname, list_num, page_num) values ('1', '0', 'default', '10', '10');

drop table if exists easy_order_detail;
create table easy_order_detail (
  seq_no int(11) not null auto_increment,
  order_num int(11) default '0' not null ,
  product_no int(11) default '0' not null ,
  bonus_point int(11) default '0' not null ,
  product_count int(11) default '0' ,
  buy_price bigint(11) default '0' not null ,
  user_sel1 varchar(255) ,
  user_sel2 varchar(255) ,
  in_tax char(1) default '0' ,
  PRIMARY KEY (seq_no)
);


drop table if exists easy_order_list;
create table easy_order_list (
  order_ts int(11) default '0' not null ,
  order_num int(11) not null auto_increment,
  order_id varchar(16) ,
  order_lastname varchar(20) not null ,
  order_firstname varchar(20) not null ,
  order_lastkana varchar(20) ,
  order_firstkana varchar(20) ,
  order_zipcode1 varchar(8) ,
  order_zipcode2 varchar(4) ,
  order_addr1 mediumtext not null ,
  order_addr2 mediumtext ,
  order_tel varchar(20) ,
  order_mail varchar(50) ,
  order_comment mediumtext ,
  delivery_lastname varchar(20) ,
  delivery_firstname varchar(20) ,
  delivery_lastkana varchar(20) ,
  delivery_firstkana varchar(20) ,
  delivery_zipcode1 varchar(8) ,
  delivery_zipcode2 varchar(4) ,
  delivery_addr1 mediumtext ,
  delivery_addr2 mediumtext ,
  delivery_tel varchar(20) ,
  pay_type int(4) default '0' not null ,
  order_flag char(1) not null ,
  order_time datetime default '0000-00-00 00:00:00' ,
  order_prefecture varchar(10) ,
  delivery_prefecture varchar(10) ,
  tax int(6) unsigned default '0' not null ,
  deliverycost int(6) unsigned default '0' not null ,
  order_fax varchar(20) ,
  exchange int(10) default '0' not null ,
  usedelitax char(1) not null ,
  u_totle1 varchar(255) ,
  u_message1 mediumtext ,
  u_totle2 varchar(255) ,
  u_message2 mediumtext ,
  u_totle3 varchar(255) ,
  u_message3 mediumtext ,
  u_totle4 varchar(255) ,
  u_message4 mediumtext ,
  u_totle5 varchar(255) ,
  u_message5 mediumtext ,
  PRIMARY KEY (order_num)
);


drop table if exists easy_popup_data;
create table easy_popup_data (
  no int(20) not null auto_increment,
  html_type varchar(5) not null ,
  title varchar(255) not null ,
  content text not null ,
  window_width varchar(10) not null ,
  window_height varchar(10) not null ,
  next_naver_open char(1) not null ,
  reg_date int(13) default '0' not null ,
  is_show char(1) not null ,
  PRIMARY KEY (no),
  KEY no (no)
);


drop table if exists easy_product_data;
create table easy_product_data (
  no int(11) not null auto_increment,
  parent_menu_id int(11) ,
  product_name varchar(255) ,
  product_intro text ,
  origin_value int(11) ,
  real_Value int(11) ,
  bonus_point int(11) ,
  product_detail longtext ,
  product_small_img varchar(255) ,
  product_big_img varchar(255) ,
  product_new_flag char(1) ,
  product_hot_flag char(1) ,
  product_cool_flag char(1) ,
  product_maker varchar(255) ,
  order_num int(13) ,
  is_show char(1) default '1' ,
  is_exist char(1) default '1' ,
  editmode1 varchar(4) ,
  editmode2 varchar(4) ,
  sold_out char(1) ,
  nodelcost char(1) ,
  sel_title1 varchar(255) ,
  sel_value1 mediumtext ,
  sel_tani1 varchar(255) ,
  sel_title2 varchar(255) ,
  sel_value2 mediumtext ,
  sel_tani2 varchar(255) ,
  sel_title3 varchar(255) ,
  sel_value3 mediumtext ,
  sel_tani3 varchar(255) ,
  sel_title4 varchar(255) ,
  sel_value4 mediumtext ,
  sel_tani4 varchar(255) ,
  sel_title5 varchar(255) ,
  sel_value5 mediumtext ,
  sel_tani5 varchar(255) ,
  in_tax char(1) default '0' ,
  PRIMARY KEY (no),
  KEY parent_menu_id (parent_menu_id)
);


drop table if exists easy_product_info;
create table easy_product_info (
  no int(20) not null auto_increment,
  parent_menu_id int(11) default '0' not null ,
  skinname varchar(255) not null ,
  list_num int(3) default '0' not null ,
  page_num int(3) default '0' not null ,
  list_cols_num int(5) default '3' not null ,
  first_mode varchar(20) not null ,
  show_go_list char(1) not null ,
  use_list_img_resize int(1) default '0' not null ,
  list_image_width int(5) default '0' not null ,
  list_image_height int(5) default '0' not null ,
  use_detail_img_resize int(1) default '0' not null ,
  detail_image_width int(5) default '0' not null ,
  detail_image_height int(5) default '0' not null ,
  show_product_maker char(1) not null ,
  show_origin_value char(1) not null ,
  show_real_Value char(1) not null ,
  show_bonus_point char(1) not null ,
  sold_out_string varchar(20) ,
  PRIMARY KEY (no)
);

insert into easy_product_info (no, parent_menu_id, skinname, list_num, page_num, list_cols_num, first_mode, show_go_list, use_list_img_resize, list_image_width, list_image_height, use_detail_img_resize, detail_image_width, detail_image_height, show_product_maker, show_origin_value, show_real_Value, show_bonus_point, sold_out_string) values ('1', '0', 'default', '10', '10', '3', 'LIST', '1', '0', '0', '0', '0', '0', '0', '', '', '', '', NULL);

drop table if exists easy_site_info;
create table easy_site_info (
  layout varchar(20) not null ,
  site_align varchar(50) not null ,
  site_total_width varchar(10) not null ,
  site_titleimage_width varchar(10) not null ,
  top_height varchar(10) not null ,
  left_width varchar(10) not null ,
  right_width varchar(10) not null ,
  bottom_height varchar(10) not null ,
  backgroundcolor varchar(255) not null ,
  backgroundimage varchar(255) not null ,
  backgroundimage_use char(1) not null ,
  text_color varchar(30) not null ,
  link_color varchar(30) not null ,
  visited_color varchar(30) not null ,
  hover_color varchar(30) not null ,
  hover_underline varchar(30) not null ,
  active_color varchar(30) not null ,
  menu_skin_name varchar(255) not null ,
  advance_mode char(1) not null ,
  menu_color varchar(255) not null ,
  menu_align varchar(255) default 'center' not null ,
  menu_color_text varchar(30) default '#000000' not null ,
  menu_color_text_mid varchar(30) default '#000000' not null ,
  menu_color_text_small varchar(30) default '#000000' not null ,
  menu_color_mid varchar(30) default '#ffffff' not null ,
  menu_color_small varchar(30) default '#ffffff' not null ,
  manual_style text not null ,
  logo_text varchar(255) not null ,
  logo_size varchar(20) default '2' not null ,
  logo_color varchar(255) not null ,
  logo_image varchar(255) not null ,
  logo_image_use char(1) not null ,
  title_text varchar(255) not null ,
  title_size varchar(20) default '2' not null ,
  title_color varchar(255) not null ,
  title_image varchar(255) not null ,
  title_image_use char(1) not null ,
  admin_email varchar(255) not null ,
  site_title varchar(255) not null ,
  site_meta_info mediumtext not null ,
  site_bottom_text text not null ,
  lastmodify int(16) default '0' not null ,
  sitemap_skin varchar(255) default 'gray' not null ,
  search_skin varchar(255) default 'gray' not null ,
  use_counter char(1) not null ,
  nemu_home char(1) default '1' not null ,
  nemu_cart char(1) default '1' not null ,
  nemu_search char(1) default '1' not null ,
  nemu_sitemap char(1) default '1' not null ,
  nemu_mail char(1) default '1' not null ,
  nemu_admin char(1) default '1' not null ,
  use_join char(1) default '1' not null ,
  site_keywords mediumtext ,
  leftbox_show char(1) ,
  rightbox_show char(1) ,
  menu_showalways char(1) default '0' 
);

insert into easy_site_info (layout, site_align, site_total_width, site_titleimage_width, top_height, left_width, right_width, bottom_height, backgroundcolor, backgroundimage, backgroundimage_use, text_color, link_color, visited_color, hover_color, hover_underline, active_color, menu_skin_name, advance_mode, menu_color, menu_align, menu_color_text, menu_color_text_mid, menu_color_text_small, menu_color_mid, menu_color_small, manual_style, logo_text, logo_size, logo_color, logo_image, logo_image_use, title_text, title_size, title_color, title_image, title_image_use, admin_email, site_title, site_meta_info, site_bottom_text, lastmodify, sitemap_skin, search_skin, use_counter, nemu_home, nemu_cart, nemu_search, nemu_sitemap, nemu_mail, nemu_admin, use_join, site_keywords, leftbox_show, rightbox_show, menu_showalways) values ('1', 'center', '780', '630', '80', '150', '150', '20', '#9999FF', '../files/meditate/crystall1.gif', '1', '#000066', '#9900FF', '#6600CC', '#6666CC', 'underline', '#329999', 'Aqua_blue', '0', '#FFFFFF', 'center', '#6633CC', '#323299', '#000000', 'undefined', 'undefined', '', 'ＭＡＤＩＴＡＴＥ', '18', '#330099', '../files/meditate/crystall.gif', '1', 'ＭＡＳＵＭＩのホームページ', '17', '#000066', '', '0', 'yourmailaddress@919homepage.com', '誰でもつくれるホームページ', '誰でもつくれるホームページ', '誰でもつくれるホームページ Copyright (C) 2004 LantechSoftware Co.,Ltd. All rights reserved. ', '0', 'gray', 'gray', '', '1', '1', '1', '1', '1', '1', '1', NULL, NULL, NULL, '');

drop table if exists easycounter;
create table easycounter (
  name varchar(30) not null ,
  count int(10) unsigned default '0' not null ,
  today int(10) unsigned default '0' not null ,
  yeday int(10) unsigned default '0' not null ,
  day int(10) unsigned default '0' not null ,
  chkstr varchar(60) not null ,
  PRIMARY KEY (name),
  UNIQUE name (name)
);

insert into easycounter (name, count, today, yeday, day, chkstr) values ('top', '0', '0', '0', '84', '127.0.0.1');


update easy_menu_list set menu_id='0' where menu_id='1';