Gecko [ 122.154.134.11 ]

Name	Size	Permission	Action
create_table.php	5.23 KB	-rw-r--r--
name_th.txt	30 B	-rw-r--r--

Code Editor : create_table.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );

//ส่วนการสร้างตารางระบบย่อย
$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_answer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `qtn_use_id` int(11) NOT NULL,
  `qtn_qq_id` int(11) NOT NULL,
  `qtn_qq_m_id` int(11) NOT NULL,
  `qtn_qq_mo_id` int(11) DEFAULT NULL,
  `qtn_value1` double DEFAULT NULL,
  `qtn_value2` varchar(150) DEFAULT NULL,
  `qtn_value3` varchar(250) DEFAULT NULL,
  `qtn_value4` int(11) DEFAULT NULL,
  `qtn_value5` int(11) DEFAULT NULL,
  `user_id` varchar(50) NOT NULL,
  `qtn_time` varchar(30) DEFAULT NULL,
  `school_code` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `school_code` (`school_code`),
  KEY `user_id` (`user_id`),
  KEY `qtn_use_id` (`qtn_use_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` varchar(13) NOT NULL,
  `p1` tinyint(4) NOT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_on` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `qtn_use_id` int(11) NOT NULL,
  `start` date NOT NULL,
  `stop` date NOT NULL,
  `rec_date` date NOT NULL,
  `officer` varchar(13) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_qq` (
  `qtn_qq_id` int(11) NOT NULL AUTO_INCREMENT,
  `qtn_id` int(11) NOT NULL,
  `qtn_qq_name` varchar(255) NOT NULL,
  `qtn_qq_num` int(11) NOT NULL,
  `qtn_op_id` int(11) NOT NULL,
  `officer` varchar(13) NOT NULL,
  `order_id` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`qtn_qq_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_qq_member` (
  `qtn_qq_m_id` int(11) NOT NULL AUTO_INCREMENT,
  `qtn_qq_id` int(11) NOT NULL,
  `qtn_qq_m_name` varchar(255) NOT NULL,
  `qtn_qq_m_num` varchar(255) DEFAULT NULL,
  `qtn_qq_m_min` int(11) NOT NULL DEFAULT '0',
  `qtn_qq_m_max` int(11) NOT NULL DEFAULT '0',
  `qtn_qq_m_total` int(11) NOT NULL DEFAULT '1',
  `qtn_op_id` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`qtn_qq_m_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_qq_member_other` (
  `qtn_qq_mo_id` int(11) NOT NULL AUTO_INCREMENT,
  `qtn_qq_m_id` int(11) NOT NULL,
  `qtn_qq_mo_name` varchar(255) NOT NULL,
  `qtn_qq_mo_type` varchar(255) NOT NULL,
  `qtn_qq_mo_ischeck` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`qtn_qq_mo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_qtn` (
  `qtn_id` int(11) NOT NULL AUTO_INCREMENT,
  `qtn_name` varchar(255) NOT NULL,
  `qtn_job` varchar(150) NOT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`qtn_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_school_group` (
  `grp_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(70) NOT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`grp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_school_in_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `grp_id` int(11) NOT NULL,
  `school_id` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_upload` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `qtn_use_id` int(11) NOT NULL,
  `qtn_qq_id` int(11) NOT NULL,
  `message` varchar(250) DEFAULT NULL,
  `file` varchar(150) DEFAULT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_use_qtn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `qtn_use_id` int(11) NOT NULL,
  `qtn_qq_id` int(11) NOT NULL,
  `school` varchar(20) NOT NULL,
  `upload_file` tinyint(4) DEFAULT '0',
  `user_id` varchar(30) DEFAULT NULL,
  `qtn_time` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `questionnaire_use_qtn_name` (
  `qtn_use_id` int(11) NOT NULL AUTO_INCREMENT,
  `qtn_id` int(11) NOT NULL,
  `qtn_use_name` varchar(255) NOT NULL,
  `qtn_desc` varchar(255) NOT NULL,
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  `status` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`qtn_use_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8" ;
$query = mysqli_query($connect,$sql_create);
?>

${this.title}

Code Editor : create_table.php