209.15.110.90 - BlackDragon

Windows NT MYOFFICEPLG2 6.2 build 9200 (Windows Server 2012 Standard Edition) i586
Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30
192.168.0.82
Cant read /etc/named.conf

URL to Upload

File Name

Upload Method

Upload from URL

File Name : install.php

<?php
include("../config.inc.php");

$sql_create="CREATE TABLE IF NOT EXISTS school_project (
  id int(11) NOT NULL AUTO_INCREMENT,
  code varchar(12) NOT NULL,
  name varchar(150) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS school_project_list (
  id int(11) NOT NULL AUTO_INCREMENT,
  code_project varchar(12) NOT NULL,
  schoolcode varchar(12) NOT NULL,
  year varchar(12) NOT NULL,
  detail varchar(255) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_code_project
ON school_project_list (code_project)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS achievement (
  id int(11) NOT NULL AUTO_INCREMENT,
  class tinyint(4) NOT NULL,
  year varchar(4) NOT NULL,
  schoolcode varchar(12) NOT NULL,
  thai float NOT NULL default '0',
  math float NOT NULL default '0',
  science float NOT NULL default '0',
  social float NOT NULL default '0',
  english float NOT NULL default '0',
  health float NOT NULL default '0',
  art float NOT NULL default '0',
  vocation float NOT NULL default '0',
  score_avg float NOT NULL default '0',
  noGroup varchar(3) NOT NULL,
  noArea varchar(3) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON achievement (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS achievement_score (
  id int(11) NOT NULL AUTO_INCREMENT,
  class tinyint(4) NOT NULL,
  year varchar(4) NOT NULL,
  area float NOT NULL default '0',
  obec float NOT NULL default '0',
  nation float NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS system_teams (
  id int(11) NOT NULL AUTO_INCREMENT,
  code varchar(2) NOT NULL COMMENT '1.บริหาร, 2.พัฒนา / 1.ประธาน 2.รอง 3.กรรมการ 4.เลขา 5.ผู้ช่วยเลขา' ,
  name varchar(100) NOT NULL,
  position varchar(200) NOT NULL,
  photo varchar(200) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS system_group (
  id int(11) NOT NULL AUTO_INCREMENT,
  code varchar(2) NOT NULL,
  name varchar(150) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS system_school (
  id int(11) NOT NULL AUTO_INCREMENT,
  smis varchar(20) NOT NULL,
  percode varchar(20) NOT NULL,
  ministry varchar(20) NOT NULL,
  schoolname varchar(255) NOT NULL,
  schoolname_eng varchar(255) NOT NULL,
  schoolgroup varchar(2) NOT NULL,
  muti varchar(10) NOT NULL,
  road varchar(100) NOT NULL,
  muban varchar(100) NOT NULL,
  tambon varchar(100) NOT NULL,
  amper varchar(100) NOT NULL,
  province varchar(100) NOT NULL,
  postcode varchar(100) NOT NULL,
  lat varchar(80) NOT NULL,
  lng varchar(80) NOT NULL,
  tel varchar(20) NOT NULL,
  email varchar(150) NOT NULL,
  website varchar(150) NOT NULL,
  statusID varchar(1) NOT NULL COMMENT '0=เลิก, 1=ปกติ, 2=ควบรวมทุกชั้น, 3-ควบรวมบางชั้น',
  statusDetail varchar(20) NOT NULL COMMENT 'เลิกสถานศึกษา=วันที่อนุมัติ, ควบรวม=รหัสโรงเรียนหลัก',
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS age (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON age (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS deformity (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON deformity (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS occasion (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON occasion (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS health (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON health (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS journeytype (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON journeytype (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS race (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON race (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS religion (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON religion (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS p6end (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON p6end (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS m3end (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON m3end (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS m6end (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON m6end (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS schoolmis (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a1r varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a2r varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  a3r varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  sum_ar varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p1r varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p2r varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p3r varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p4r varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p5r varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  p6r varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  sum_pr varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m1r varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m2r varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  m3r varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  sum_mr varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m4r varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m5r varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  m6r varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_hr varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  sum_r_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON schoolmis (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="RENAME TABLE achievement TO ONet, achievement_score TO ONet_score";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE ONet DROP type";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE system_school ADD length_km VARCHAR(10) NOT NULL AFTER lng" ;
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE system_school ADD maplink VARCHAR(255) NOT NULL AFTER length_km" ;
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE system_teams ADD status VARCHAR(1) NOT NULL AFTER photo" ;
$query = mysqli_query($connect,$sql_create);
$sql_create="CREATE TABLE IF NOT EXISTS child (
    id int(11) NOT NULL AUTO_INCREMENT,
    schoolcode varchar(12) NOT NULL,
    ed_year varchar(4) NOT NULL,
    person_id varchar(13) NOT NULL,
    sex tinyint(1) NOT NULL,
    prename varchar(20) NOT NULL,
    name varchar(50) NOT NULL,
    surename varchar(50) NOT NULL,
    birth_day varchar(10) NOT NULL,
    nationality  varchar(50) NOT NULL,
    house_number varchar(20) NOT NULL,
    noban varchar(10) NOT NULL,
    muti varchar(2) NOT NULL,
    muban varchar(20) NOT NULL,
    tambon varchar(20) NOT NULL,
    amper varchar(20) NOT NULL,
    province varchar(10) NOT NULL,
    id_fa varchar(13) NOT NULL,
    prename_fa varchar(20) NOT NULL,
    name_fa varchar(50) NOT NULL,
    surename_fa varchar(50) NOT NULL,
    id_ma varchar(13) NOT NULL,
    prename_ma varchar(20) NOT NULL,
    name_ma varchar(50) NOT NULL,
    surename_ma varchar(50) NOT NULL,
    id_par varchar(13) NOT NULL,
    prename_par varchar(20) NOT NULL,
    name_par varchar(50) NOT NULL,
    surename_par varchar(50) NOT NULL,
    abount varchar(20) NOT NULL,
    status varchar(20) NOT NULL,
    rec_date date NOT NULL,
    PRIMARY KEY  (id)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='ประชากรวัยเรียน' " ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS schoolmis_overview (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  areacode varchar(12) NOT NULL,
  schoolcode varchar(12) NOT NULL,
  schoolname varchar(255) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a1r varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a2r varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  a3r varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  sum_ar varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p1r varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p2r varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p3r varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p4r varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p5r varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  p6r varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  sum_pr varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m1r varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m2r varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  m3r varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  sum_mr varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m4r varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m5r varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  m6r varchar(10) NOT NULL,
  h1m varchar(10) NOT NULL,
  h1f varchar(10) NOT NULL,
  h1 varchar(10) NOT NULL,
  h1r varchar(10) NOT NULL,
  h2m varchar(10) NOT NULL,
  h2f varchar(10) NOT NULL,
  h2 varchar(10) NOT NULL,
  h2r varchar(10) NOT NULL,
  h3m varchar(10) NOT NULL,
  h3f varchar(10) NOT NULL,
  h3 varchar(10) NOT NULL,
  h3r varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_hr varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  sum_r_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='จำนวนนักเรียน ภาพรวมจังหวัด' ";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS heightage (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  h1m varchar(10) NOT NULL,
  h1f varchar(10) NOT NULL,
  h1 varchar(10) NOT NULL,
  h2m varchar(10) NOT NULL,
  h2f varchar(10) NOT NULL,
  h2 varchar(10) NOT NULL,
  h3m varchar(10) NOT NULL,
  h3f varchar(10) NOT NULL,
  h3 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='ภาวะโภชนาการ ความสูงตามเกณฑ์อายุ' ";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS weightheight (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(6) NOT NULL,
  schoolcode varchar(20) NOT NULL,
  type varchar(100) NOT NULL,
  a1m varchar(10) NOT NULL,
  a1f varchar(10) NOT NULL,
  a1 varchar(10) NOT NULL,
  a2m varchar(10) NOT NULL,
  a2f varchar(10) NOT NULL,
  a2 varchar(10) NOT NULL,
  a3m varchar(10) NOT NULL,
  a3f varchar(10) NOT NULL,
  a3 varchar(10) NOT NULL,
  sum_am varchar(10) NOT NULL,
  sum_af varchar(10) NOT NULL,
  sum_a varchar(10) NOT NULL,
  p1m varchar(10) NOT NULL,
  p1f varchar(10) NOT NULL,
  p1 varchar(10) NOT NULL,
  p2m varchar(10) NOT NULL,
  p2f varchar(10) NOT NULL,
  p2 varchar(10) NOT NULL,
  p3m varchar(10) NOT NULL,
  p3f varchar(10) NOT NULL,
  p3 varchar(10) NOT NULL,
  p4m varchar(10) NOT NULL,
  p4f varchar(10) NOT NULL,
  p4 varchar(10) NOT NULL,
  p5m varchar(10) NOT NULL,
  p5f varchar(10) NOT NULL,
  p5 varchar(10) NOT NULL,
  p6m varchar(10) NOT NULL,
  p6f varchar(10) NOT NULL,
  p6 varchar(10) NOT NULL,
  sum_pm varchar(10) NOT NULL,
  sum_pf varchar(10) NOT NULL,
  sum_p varchar(10) NOT NULL,
  m1m varchar(10) NOT NULL,
  m1f varchar(10) NOT NULL,
  m1 varchar(10) NOT NULL,
  m2m varchar(10) NOT NULL,
  m2f varchar(10) NOT NULL,
  m2 varchar(10) NOT NULL,
  m3m varchar(10) NOT NULL,
  m3f varchar(10) NOT NULL,
  m3 varchar(10) NOT NULL,
  sum_mm varchar(10) NOT NULL,
  sum_mf varchar(10) NOT NULL,
  sum_m varchar(10) NOT NULL,
  m4m varchar(10) NOT NULL,
  m4f varchar(10) NOT NULL,
  m4 varchar(10) NOT NULL,
  m5m varchar(10) NOT NULL,
  m5f varchar(10) NOT NULL,
  m5 varchar(10) NOT NULL,
  m6m varchar(10) NOT NULL,
  m6f varchar(10) NOT NULL,
  m6 varchar(10) NOT NULL,
  h1m varchar(10) NOT NULL,
  h1f varchar(10) NOT NULL,
  h1 varchar(10) NOT NULL,
  h2m varchar(10) NOT NULL,
  h2f varchar(10) NOT NULL,
  h2 varchar(10) NOT NULL,
  h3m varchar(10) NOT NULL,
  h3f varchar(10) NOT NULL,
  h3 varchar(10) NOT NULL,
  sum_hm varchar(10) NOT NULL,
  sum_hf varchar(10) NOT NULL,
  sum_h varchar(10) NOT NULL,
  sum_m_all varchar(10) NOT NULL,
  sum_f_all varchar(10) NOT NULL,
  sum_all varchar(10) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='ภาวะโภชนาการ น้ำหนักตามเกณฑ์ความสูง' ";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS best (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(4) NOT NULL,
  name varchar(255) NOT NULL,
  schoolcode varchar(12) NOT NULL,
  subject varchar(255) NOT NULL,
  guarantee varchar(255) NOT NULL,
  level varchar(100) NOT NULL,
  refer_file varchar(255) NOT NULL,
  refer_link varchar(255) NOT NULL,
  detail text,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Best Practices'";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS project (
  id int(11) NOT NULL AUTO_INCREMENT,
  code varchar(15) NOT NULL,
  name varchar(255) NOT NULL,
  refer_link varchar(255) NOT NULL,
  detail text NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='โครงการพิเศษ'";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS project_list (
  id int(11) NOT NULL AUTO_INCREMENT,
  projectID int(11) NOT NULL,
  year varchar(100) NOT NULL,
  schoolcode varchar(12) NOT NULL,
  level tinyint(1) NOT NULL,
  level_schoolcode varchar(12) NOT NULL,
  detail varchar(255) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='โรงเรียนในโครงการพิเศษ'";
$query = mysqli_query($connect,$sql_create);

$sql_create="DROP TABLE NT";
$query = mysqli_query($connect,$sql_create);
$sql_create="DROP TABLE NT_score";
$query = mysqli_query($connect,$sql_create);
$sql_create="DROP TABLE RT";
$query = mysqli_query($connect,$sql_create);
$sql_create="DROP TABLE RT_score";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS NT (
  id int(11) NOT NULL AUTO_INCREMENT,
  class tinyint(4) NOT NULL,
  year varchar(4) NOT NULL,
  schoolcode varchar(12) NOT NULL,
  score_1 float NOT NULL DEFAULT '0',
  score_2 float NOT NULL DEFAULT '0',
  score_3 float NOT NULL DEFAULT '0',
  score_4 float NOT NULL DEFAULT '0',
  score_1qa varchar(10) NOT NULL,
  score_2qa varchar(10) NOT NULL,
  score_3qa varchar(10) NOT NULL,
  score_4qa varchar(10) NOT NULL,
  noGroup varchar(3) NOT NULL,
  noArea varchar(3) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='ตารางคะแนน NT' ";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS NT_score (
  id int(11) NOT NULL AUTO_INCREMENT,
  class tinyint(4) NOT NULL,
  year varchar(4) NOT NULL,
  area float NOT NULL DEFAULT '0',
  province float NOT NULL DEFAULT '0',
  obec float NOT NULL DEFAULT '0',
  nation float NOT NULL DEFAULT '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='ตารางกำหนดคะแนนเฉลี่ย NT' ";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS RT (
  id int(11) NOT NULL AUTO_INCREMENT,
  class tinyint(4) NOT NULL,
  year varchar(4) NOT NULL,
  schoolcode varchar(12) NOT NULL,
  score_1 float NOT NULL DEFAULT '0',
  score_2 float NOT NULL DEFAULT '0',
  score_3 float NOT NULL DEFAULT '0',
  score_1qa varchar(10) NOT NULL,
  score_2qa varchar(10) NOT NULL,
  score_3qa varchar(10) NOT NULL,
  noGroup varchar(3) NOT NULL,
  noArea varchar(3) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='ตารางคะแนน RT' ";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS RT_score (
  id int(11) NOT NULL AUTO_INCREMENT,
  class tinyint(4) NOT NULL,
  year varchar(4) NOT NULL,
  area float NOT NULL DEFAULT '0',
  province float NOT NULL DEFAULT '0',
  obec float NOT NULL DEFAULT '0',
  nation float NOT NULL DEFAULT '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='ตารางกำหนดคะแนนเฉลี่ย RT' ";
$query = mysqli_query($connect,$sql_create);

$sql_create="DROP TABLE school_project";
$query = mysqli_query($connect,$sql_create);
$sql_create="DROP TABLE school_project_list";
$query = mysqli_query($connect,$sql_create);

$sql_create="ALTER TABLE age ADD h1m VARCHAR(10) NOT NULL AFTER m6";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE age ADD h1f VARCHAR(10) NOT NULL AFTER h1m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE age ADD h1 VARCHAR(10) NOT NULL AFTER h1f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE age ADD h2m VARCHAR(10) NOT NULL AFTER h1";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE age ADD h2f VARCHAR(10) NOT NULL AFTER h2m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE age ADD h2 VARCHAR(10) NOT NULL AFTER h2f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE age ADD h3m VARCHAR(10) NOT NULL AFTER h2";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE age ADD h3f VARCHAR(10) NOT NULL AFTER h3m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE age ADD h3 VARCHAR(10) NOT NULL AFTER h3f";
$query = mysqli_query($connect,$sql_create);

$sql_create="ALTER TABLE deformity ADD h1m VARCHAR(10) NOT NULL AFTER m6";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE deformity ADD h1f VARCHAR(10) NOT NULL AFTER h1m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE deformity ADD h1 VARCHAR(10) NOT NULL AFTER h1f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE deformity ADD h2m VARCHAR(10) NOT NULL AFTER h1";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE deformity ADD h2f VARCHAR(10) NOT NULL AFTER h2m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE deformity ADD h2 VARCHAR(10) NOT NULL AFTER h2f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE deformity ADD h3m VARCHAR(10) NOT NULL AFTER h2";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE deformity ADD h3f VARCHAR(10) NOT NULL AFTER h3m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE deformity ADD h3 VARCHAR(10) NOT NULL AFTER h3f";
$query = mysqli_query($connect,$sql_create);

$sql_create="ALTER TABLE health ADD h1m VARCHAR(10) NOT NULL AFTER m6";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE health ADD h1f VARCHAR(10) NOT NULL AFTER h1m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE health ADD h1 VARCHAR(10) NOT NULL AFTER h1f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE health ADD h2m VARCHAR(10) NOT NULL AFTER h1";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE health ADD h2f VARCHAR(10) NOT NULL AFTER h2m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE health ADD h2 VARCHAR(10) NOT NULL AFTER h2f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE health ADD h3m VARCHAR(10) NOT NULL AFTER h2";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE health ADD h3f VARCHAR(10) NOT NULL AFTER h3m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE health ADD h3 VARCHAR(10) NOT NULL AFTER h3f";
$query = mysqli_query($connect,$sql_create);

$sql_create="ALTER TABLE journeytype ADD h1m VARCHAR(10) NOT NULL AFTER m6";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE journeytype ADD h1f VARCHAR(10) NOT NULL AFTER h1m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE journeytype ADD h1 VARCHAR(10) NOT NULL AFTER h1f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE journeytype ADD h2m VARCHAR(10) NOT NULL AFTER h1";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE journeytype ADD h2f VARCHAR(10) NOT NULL AFTER h2m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE journeytype ADD h2 VARCHAR(10) NOT NULL AFTER h2f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE journeytype ADD h3m VARCHAR(10) NOT NULL AFTER h2";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE journeytype ADD h3f VARCHAR(10) NOT NULL AFTER h3m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE journeytype ADD h3 VARCHAR(10) NOT NULL AFTER h3f";
$query = mysqli_query($connect,$sql_create);

$sql_create="ALTER TABLE occasion ADD h1m VARCHAR(10) NOT NULL AFTER m6";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE occasion ADD h1f VARCHAR(10) NOT NULL AFTER h1m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE occasion ADD h1 VARCHAR(10) NOT NULL AFTER h1f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE occasion ADD h2m VARCHAR(10) NOT NULL AFTER h1";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE occasion ADD h2f VARCHAR(10) NOT NULL AFTER h2m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE occasion ADD h2 VARCHAR(10) NOT NULL AFTER h2f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE occasion ADD h3m VARCHAR(10) NOT NULL AFTER h2";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE occasion ADD h3f VARCHAR(10) NOT NULL AFTER h3m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE occasion ADD h3 VARCHAR(10) NOT NULL AFTER h3f";
$query = mysqli_query($connect,$sql_create);

$sql_create="ALTER TABLE race ADD h1m VARCHAR(10) NOT NULL AFTER m6";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE race ADD h1f VARCHAR(10) NOT NULL AFTER h1m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE race ADD h1 VARCHAR(10) NOT NULL AFTER h1f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE race ADD h2m VARCHAR(10) NOT NULL AFTER h1";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE race ADD h2f VARCHAR(10) NOT NULL AFTER h2m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE race ADD h2 VARCHAR(10) NOT NULL AFTER h2f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE race ADD h3m VARCHAR(10) NOT NULL AFTER h2";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE race ADD h3f VARCHAR(10) NOT NULL AFTER h3m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE race ADD h3 VARCHAR(10) NOT NULL AFTER h3f";
$query = mysqli_query($connect,$sql_create);

$sql_create="ALTER TABLE religion ADD h1m VARCHAR(10) NOT NULL AFTER m6";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE religion ADD h1f VARCHAR(10) NOT NULL AFTER h1m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE religion ADD h1 VARCHAR(10) NOT NULL AFTER h1f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE religion ADD h2m VARCHAR(10) NOT NULL AFTER h1";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE religion ADD h2f VARCHAR(10) NOT NULL AFTER h2m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE religion ADD h2 VARCHAR(10) NOT NULL AFTER h2f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE religion ADD h3m VARCHAR(10) NOT NULL AFTER h2";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE religion ADD h3f VARCHAR(10) NOT NULL AFTER h3m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE religion ADD h3 VARCHAR(10) NOT NULL AFTER h3f";
$query = mysqli_query($connect,$sql_create);

$sql_create="ALTER TABLE schoolmis ADD h1m VARCHAR(10) NOT NULL AFTER m6r";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis ADD h1f VARCHAR(10) NOT NULL AFTER h1m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis ADD h1 VARCHAR(10) NOT NULL AFTER h1f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis ADD h1r VARCHAR(10) NOT NULL AFTER h1";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis ADD h2m VARCHAR(10) NOT NULL AFTER h1r";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis ADD h2f VARCHAR(10) NOT NULL AFTER h2m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis ADD h2 VARCHAR(10) NOT NULL AFTER h2f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis ADD h2r VARCHAR(10) NOT NULL AFTER h2";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis ADD h3m VARCHAR(10) NOT NULL AFTER h2r";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis ADD h3f VARCHAR(10) NOT NULL AFTER h3m";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis ADD h3 VARCHAR(10) NOT NULL AFTER h3f";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis ADD h3r VARCHAR(10) NOT NULL AFTER h3";
$query = mysqli_query($connect,$sql_create);

$sql_create="ALTER TABLE achievement ADD type tinyint(4) NOT NULL AFTER id";
$query = mysqli_query($connect,$sql_create);

$sql_create="ALTER TABLE achievement COMMENT = 'ตารางคะแนนผลสัมฤทธิ์' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE achievement_score COMMENT = 'ตารางกำหนดคะแนนเฉลี่ย' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE age COMMENT = 'จำนวน นร.จำแนกตามอายุ' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE deformity COMMENT = 'จำนวน นร.พิการ' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE health COMMENT = 'น้ำหนักส่วนสูงเทียบเกณฑ์มาตรฐาน' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE journeytype COMMENT = 'จำนวน นร.ที่อยู่ห่างเกิน 3 กม.จำแนกตามการเดินทาง' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE m3end COMMENT = 'จำนวน นร.จบ ม.3' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE m6end COMMENT = 'จำนวน นร.จบ ม.6' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE occasion COMMENT = 'จำนวน นร.ด้อยโอกาส' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE p6end COMMENT = 'จำนวน นร.จบ ป.6' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE race COMMENT = 'จำนวน นร.จำแนกตามสัญชาติ' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE religion COMMENT = 'จำนวน นร.จำแนกตามศาสนา' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis COMMENT = 'จำนวน นร.จำแนกชั้น/เพศ' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE schoolmis_overview COMMENT = 'จำนวน นร.จำแนกชั้น/เพศ ภาพรวมจังหวัด' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE system_group COMMENT = 'ข้อมูลกลุ่มโรงเรียน' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE system_school COMMENT = 'ข้อมูลโรงเรียน' ";
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE system_teams COMMENT = 'รายชื่อคณะกรรมการ' ";
$query = mysqli_query($connect,$sql_create);

$sql_create="ALTER TABLE p6end ADD sum_m VARCHAR(10) NOT NULL AFTER type" ;
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE p6end ADD sum_f VARCHAR(10) NOT NULL AFTER sum_m" ;
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE m3end ADD sum_m VARCHAR(10) NOT NULL AFTER type" ;
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE m3end ADD sum_f VARCHAR(10) NOT NULL AFTER sum_m" ;
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE m6end ADD sum_m VARCHAR(10) NOT NULL AFTER type" ;
$query = mysqli_query($connect,$sql_create);
$sql_create="ALTER TABLE m6end ADD sum_f VARCHAR(10) NOT NULL AFTER sum_m" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS poor (
id int(11) NOT NULL AUTO_INCREMENT,
year varchar(6) NOT NULL,
schoolcode varchar(20) NOT NULL,
type varchar(100) NOT NULL,
a1m varchar(10) NOT NULL,
a1f varchar(10) NOT NULL,
a1 varchar(10) NOT NULL,
a2m varchar(10) NOT NULL,
a2f varchar(10) NOT NULL,
a2 varchar(10) NOT NULL,
a3m varchar(10) NOT NULL,
a3f varchar(10) NOT NULL,
a3 varchar(10) NOT NULL,
sum_am varchar(10) NOT NULL,
sum_af varchar(10) NOT NULL,
sum_a varchar(10) NOT NULL,
p1m varchar(10) NOT NULL,
p1f varchar(10) NOT NULL,
p1 varchar(10) NOT NULL,
p2m varchar(10) NOT NULL,
p2f varchar(10) NOT NULL,
p2 varchar(10) NOT NULL,
p3m varchar(10) NOT NULL,
p3f varchar(10) NOT NULL,
p3 varchar(10) NOT NULL,
p4m varchar(10) NOT NULL,
p4f varchar(10) NOT NULL,
p4 varchar(10) NOT NULL,
p5m varchar(10) NOT NULL,
p5f varchar(10) NOT NULL,
p5 varchar(10) NOT NULL,
p6m varchar(10) NOT NULL,
p6f varchar(10) NOT NULL,
p6 varchar(10) NOT NULL,
sum_pm varchar(10) NOT NULL,
sum_pf varchar(10) NOT NULL,
sum_p varchar(10) NOT NULL,
m1m varchar(10) NOT NULL,
m1f varchar(10) NOT NULL,
m1 varchar(10) NOT NULL,
m2m varchar(10) NOT NULL,
m2f varchar(10) NOT NULL,
m2 varchar(10) NOT NULL,
m3m varchar(10) NOT NULL,
m3f varchar(10) NOT NULL,
m3 varchar(10) NOT NULL,
sum_mm varchar(10) NOT NULL,
sum_mf varchar(10) NOT NULL,
sum_m varchar(10) NOT NULL,
m4m varchar(10) NOT NULL,
m4f varchar(10) NOT NULL,
m4 varchar(10) NOT NULL,
m5m varchar(10) NOT NULL,
m5f varchar(10) NOT NULL,
m5 varchar(10) NOT NULL,
m6m varchar(10) NOT NULL,
m6f varchar(10) NOT NULL,
m6 varchar(10) NOT NULL,
h1m varchar(10) NOT NULL,
h1f varchar(10) NOT NULL,
h1 varchar(10) NOT NULL,
h2m varchar(10) NOT NULL,
h2f varchar(10) NOT NULL,
h2 varchar(10) NOT NULL,
h3m varchar(10) NOT NULL,
h3f varchar(10) NOT NULL,
h3 varchar(10) NOT NULL,
sum_hm varchar(10) NOT NULL,
sum_hf varchar(10) NOT NULL,
sum_h varchar(10) NOT NULL,
sum_m_all varchar(10) NOT NULL,
sum_f_all varchar(10) NOT NULL,
sum_all varchar(10) NOT NULL,
PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='จำนวน นร.ขาดแคลน' " ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE INDEX idx_schoolcode
ON poor (schoolcode)";
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS person_retire (
  year varchar(4) NOT NULL,
  school varchar(255) NOT NULL,
  prename varchar(20) NOT NULL,
  name varchar(50) NOT NULL,
  surname varchar(50) NOT NULL,
  position varchar(100) NOT NULL,
  rec_date date DEFAULT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='ครูและบุคลากร เกษียณอายุ/ปี' " ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS person_position_sex (
  id int(11) NOT NULL AUTO_INCREMENT,
  schoolcode varchar(12) NOT NULL,
  po1_m varchar(10) NOT NULL COMMENT 'ผอ.ชาย',
  po1_f varchar(10) NOT NULL COMMENT 'ผอ.หญิง',
  po1_sum varchar(10) NOT NULL COMMENT 'ผอ',
  po2_m varchar(10) NOT NULL COMMENT 'รอง.ชาย',
  po2_f varchar(10) NOT NULL COMMENT 'รอง.หญิง',
  po2_sum varchar(10) NOT NULL COMMENT 'รอง',
  po3_m varchar(10) NOT NULL COMMENT 'ครู/ศน.ชาย',
  po3_f varchar(10) NOT NULL COMMENT 'ครู/ศน.หญิง',
  po3_sum varchar(10) NOT NULL COMMENT 'ครู/ศน',
  po4_m varchar(10) NOT NULL COMMENT '38ค.ชาย',
  po4_f varchar(10) NOT NULL COMMENT '38ค.หญิง',
  po4_sum varchar(10) NOT NULL COMMENT '38ค',
  po5_m varchar(10) NOT NULL COMMENT 'พนักงานราชการ.ชาย',
  po5_f varchar(10) NOT NULL COMMENT 'พนักงานราชการ.หญิง',
  po5_sum varchar(10) NOT NULL COMMENT 'พนักงานราชการ',
  po6_m varchar(10) NOT NULL COMMENT 'ลูกจ้างประจำ.ชาย',
  po6_f varchar(10) NOT NULL COMMENT 'ลูกจ้างประจำ.หญิง',
  po6_sum varchar(10) NOT NULL COMMENT 'ลูกจ้างประจำ',
  po7_m varchar(10) NOT NULL COMMENT 'ลูกจ้างชั่วคราว.ชาย',
  po7_f varchar(10) NOT NULL COMMENT 'ลูกจ้างชั่วคราว.หญิง',
  po7_sum varchar(10) NOT NULL COMMENT 'ลูกจ้างชั่วคราว',
  po8_m varchar(10) NOT NULL COMMENT 'อื่นๆ.ชาย',
  po8_f varchar(10) NOT NULL COMMENT 'อื่นๆ.หญิง',
  po8_sum varchar(10) NOT NULL COMMENT 'อื่นๆ',
  po_m varchar(10) NOT NULL COMMENT 'รวม.ชาย',
  po_f varchar(10) NOT NULL COMMENT 'รวม.หญิง',
  po_sum varchar(10) NOT NULL COMMENT 'รวม',
  rec_date date DEFAULT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='ครูและบุคลากร จำแนกตำแหน่งและเพศ' " ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS person_power (
  schoolcode varchar(12) NOT NULL,
  student FLOAT NOT NULL,
  room FLOAT NOT NULL,
  po_true FLOAT NOT NULL,
  rong_true FLOAT NOT NULL,
  kru_true FLOAT NOT NULL,
  sum_true FLOAT NOT NULL,
  po_jor18 FLOAT NOT NULL,
  rong_jor18 FLOAT NOT NULL,
  kru_jor18 FLOAT NOT NULL,
  sum_jor18 FLOAT NOT NULL,
  po_jor18_calculate FLOAT NOT NULL,
  rong_jor18_calculate FLOAT NOT NULL,
  kru_jor18_calculate FLOAT NOT NULL,
  sum_jor18_calculate FLOAT NOT NULL,
  po_kks FLOAT NOT NULL,
  rong_kks FLOAT NOT NULL,
  kru_kks FLOAT NOT NULL,
  sum_kks FLOAT NOT NULL,
  po_dif FLOAT NOT NULL,
  rong_dif FLOAT NOT NULL,
  kru_dif FLOAT NOT NULL,
  sum_dif FLOAT NOT NULL,
  percent_dif FLOAT NOT NULL,
  po_retire FLOAT NOT NULL,
  rong_retire FLOAT NOT NULL,
  kru_retire FLOAT NOT NULL,
  sum_retire FLOAT NOT NULL,
  po_after_retire FLOAT NOT NULL,
  rong_after_retire FLOAT NOT NULL,
  kru_after_retire FLOAT NOT NULL,
  sum_after_retire FLOAT NOT NULL,
  percent_dif_afterretire FLOAT NOT NULL,
  kru_go FLOAT NOT NULL,
  kru_come FLOAT NOT NULL,
  kru_employ_gov FLOAT NOT NULL,
  kru_employ_rate FLOAT NOT NULL,
  rec_date date DEFAULT NULL
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='แผนอัตรากำลัง' " ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS person_class (
  schoolcode varchar(12) NOT NULL,
  class1_m FLOAT NOT NULL COMMENT 'ชช.พิเศษ-ชาย',
  class1_f FLOAT NOT NULL COMMENT 'ชช.พิเศษ-หญิง',
  class1_sum FLOAT NOT NULL COMMENT 'ชช.พิเศษ-รวม',
  class2_m FLOAT NOT NULL COMMENT 'ชช.-ชาย',
  class2_f FLOAT NOT NULL COMMENT 'ชช.-หญิง',
  class2_sum FLOAT NOT NULL COMMENT 'ชช.-รวม',
  class3_m FLOAT NOT NULL COMMENT 'ชก.พิเศษ-ชาย',
  class3_f FLOAT NOT NULL COMMENT 'ชก.พิเศษ-หญิง',
  class3_sum FLOAT NOT NULL COMMENT 'ชก.พิเศษ-รวม',
  class4_m FLOAT NOT NULL COMMENT 'ชก.-ชาย',
  class4_f FLOAT NOT NULL COMMENT 'ชก.-หญิง',
  class4_sum FLOAT NOT NULL COMMENT 'ชก.-รวม',
  class5_m FLOAT NOT NULL COMMENT 'ไม่มี-ชาย',
  class5_f FLOAT NOT NULL COMMENT 'ไม่มี-หญิง',
  class5_sum FLOAT NOT NULL COMMENT 'ไม่มี-รวม',
  class_m FLOAT NOT NULL COMMENT 'รวม-ชาย',
  class_f FLOAT NOT NULL COMMENT 'รวม-หญิง',
  class_sum FLOAT NOT NULL COMMENT 'รวม',
  rec_date date DEFAULT NULL
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='ครูและบุคลากร จำแนกวิทยฐานะ' " ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS person_education (
  schoolcode varchar(12) NOT NULL,
  positioncode varchar(2) NOT NULL COMMENT 'รหัส 1.ผอ 2.รอง/ผช 3.ครู/ศน 4.38(ค) 5.พนง.ราชการ 6.ลจ.ประจำ 7.ลจ.ชั่วคราว',
  edu1_m FLOAT NOT NULL COMMENT 'ป.เอก-',
  edu1_f FLOAT NOT NULL COMMENT 'ป.เอก-',
  edu1_sum FLOAT NOT NULL COMMENT 'ป.เอก-รวม',
  edu2_m FLOAT NOT NULL COMMENT 'ป.โท-ชาย',
  edu2_f FLOAT NOT NULL COMMENT 'ป.โท-หญิง',
  edu2_sum FLOAT NOT NULL COMMENT 'ป.โท-รวม',
  edu3_m FLOAT NOT NULL COMMENT 'ป.ตรี-ชาย',
  edu3_f FLOAT NOT NULL COMMENT 'ป.ตรี-หญิง',
  edu3_sum FLOAT NOT NULL COMMENT 'ป.ตรี-รวม',
  edu4_m FLOAT NOT NULL COMMENT 'อนุปริญญา-ชาย',
  edu4_f FLOAT NOT NULL COMMENT 'อนุปริญญา-หญิง',
  edu4_sum FLOAT NOT NULL COMMENT 'อนุปริญญา-รวม',
  edu5_m FLOAT NOT NULL COMMENT 'ต่ำกว่าอนุ-ชาย',
  edu5_f FLOAT NOT NULL COMMENT 'ต่ำกว่าอนุ-หญิง',
  edu5_sum FLOAT NOT NULL COMMENT 'ต่ำกว่าอนุ-รวม',
  edu_m FLOAT NOT NULL COMMENT 'รวม-ชาย',
  edu_f FLOAT NOT NULL COMMENT 'รวม-หญิง',
  edu_sum FLOAT NOT NULL COMMENT 'รวม',
  rec_date date DEFAULT NULL
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='ครูและบุคลากร จำแนกวุฒิการศึกษา' " ;
$query = mysqli_query($connect,$sql_create);

$sql="CREATE TABLE IF NOT EXISTS statistic (
  id int(11) NOT NULL AUTO_INCREMENT,
  year varchar(4) NOT NULL,
  month varchar(2) NOT NULL,
  static_code varchar(10) NOT NULL,
  static_name varchar(255) NOT NULL,
  static_count float not null,
  PRIMARY KEY  (id)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='สถิติบริการ' " ;
$query = mysqli_query($connect,$sql_create);

if($query){
			echo "<center><img src='../images/ok.png' border=0 height=200>
			<meta http-equiv=refresh content=1;URL='../admin.php'></center>";
		}else{
			echo "<center><img src='../images/database-error.png' border=0 height=100>";
			echo "<br><a href='../admin.php'>ติดตั้งไม่สำเร็จ คลิกกลับ</a></center>";
		}
?>

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	drwxrwxrwx	2025-07-04 01:21:30
..	dir	-	0/0	drwxrwxrwx	2025-07-04 01:24:04
install.php	file	57.78 KB	0/0	-rw-rw-rw-	2024-12-04 09:20:36