CREATE TABLE banner  (
  ban_no int(255) AUTO_INCREMENT PRIMARY KEY,
  ban_pic varchar(255),
  ban_title varchar(255),
  ban_state varchar(255),
  ban_freq varchar(255),
  ban_order_no int(255),
   SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE'
) 

CREATE TABLE category  (
  cate_no int(255) AUTO_INCREMENT PRIMARY KEY,
  cate_name varchar(255),
  cate_level varchar(255),
  cate_uplevel_no varchar(255),
  cate_state varchar(255),
  cate_order_no varchar(255),
  SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE fix  (
  fix_no int(255) AUTO_INCREMENT PRIMARY KEY,
  fix_menu varchar(255),
  fix_title varchar(255),
  fix_content longtext,
  fix_order_no int(255),
   SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE'
) 

修改Log:代號/修改時間/修改來源/來源IP/修改人員/修改Control名稱/動作/修改資訊代號/修改內容
create table log(
       log_no int(255) AUTO_INCREMENT PRIMARY KEY,
       log_date varchar(255),
       log_ip varchar(255),
       log_source varchar(255),
       log_person varchar(255),
       log_control varchar(255),
       log_action varchar(255),
       log_data_no varchar(255),
       log_content longtext,

       SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
       SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
       State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE news  (
  news_no int(255) AUTO_INCREMENT PRIMARY KEY,
  news_date varchar(255),
  news_title varchar(255),
  news_content longtext,
  news_pic varchar(255),
  news_order_no int(255),
   SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE'
)

CREATE TABLE product  (
  pro_no int(255) AUTO_INCREMENT PRIMARY KEY,
  pro_cate_no varchar(255),
  pro_hot varchar(255),
  pro_name varchar(255),
  pro_id varchar(255),
  pro_price varchar(100),
  pro_sprice varchar(100),
  pro_pic1 varchar(255),
  pro_pic2 varchar(255),
  pro_pic3 varchar(255),
  pro_pic4 varchar(255),
  pro_size varchar(255),
  pro_weight varchar(255),
  pro_wheel_size varchar(255),
  pro_desc longtext,
  pro_fix longtext,
  pro_youtube longtext,
  pro_file varchar(255),
  pro_file_name varchar(255),
  pro_buy longtext,
  pro_state varchar(255),
  pro_order_no int(255),
  SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

管理者帳號:代號/職稱/主管/名稱/暱稱/帳號/E-mail/手機/大頭照/全身照/Googleid/系統選單/推播Token/備註/狀態/順序
最高權限/切換人員/
create table user(
       user_no int(255) AUTO_INCREMENT PRIMARY KEY,
	   user_sco_no int(255),
       user_leader varchar(255),
       user_name varchar(255),
       user_nickname varchar(255),
       user_id varchar(255),
       user_email varchar(255),
       user_mobile varchar(255),
       user_pic varchar(255),
       user_pic2 varchar(255),
       user_google_id varchar(255),
       user_menu_no varchar(255),
       user_token varchar(255),
       user_note longtext,
       user_state varchar(255),
       user_order_no int(255),
			
       ModifyMax varchar(255),
       UserChange varchar(255),
							
	   SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
       SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
       State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

職稱權限設定:代號/職稱/系統選單/最高權限/切換人員/順序
create table scope(
       sco_no int(255) AUTO_INCREMENT PRIMARY KEY,
       sco_class varchar(255),
       sco_menu_no varchar(255),
       sco_order_no int(255),
       
       ModifyMax varchar(255),
       
       UserChange varchar(255),       
       
       SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
       SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
       State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

總公司系統選單:代號/系統/名稱/連結/標題/背景圖片/相關連結/連結方式/類別名稱/階層/上一層代號/順序
create table webmenu(
       menu_no int(255) AUTO_INCREMENT PRIMARY KEY,
       menu_system varchar(255),
       menu_name varchar(255),
       menu_link varchar(255),
       menu_title varchar(255),
       menu_pic varchar(255),
       menu_related longtext,
       menu_target varchar(255),
   	   menu_class varchar(255),
       menu_level varchar(255),
       menu_uplevel_no varchar(255),
       menu_order_no int(255),
							
	     SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
       SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
       State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;