Gecko [ 122.154.134.11 ]

Name	Size	Permission	Action
create_table.php	1.69 KB	-rwxr-xr-x
name_th.txt	33 B	-rwxr-xr-x

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 `news_mainitem` (
  `id` int(11) NOT NULL auto_increment,
  `code` int(11) NOT NULL,
  `mainitem` varchar(150) NOT NULL,
  `item_active` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$dbquery = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `news_news` (
  `id` int(11) NOT NULL auto_increment,
  `report_date` datetime NOT NULL,
  `news` varchar(250) NOT NULL,
  `file` varchar(150) NOT NULL,
  `section` int(11) NOT NULL,
  `mainitem_code` int(11) NOT NULL,
  `officer` varchar(13) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1";
$dbquery = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `news_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 AUTO_INCREMENT=1"; 
$dbquery = mysqli_query($connect,$sql_create);

$sql_create="CREATE TABLE IF NOT EXISTS `news_section` (
  `id` int(11) NOT NULL auto_increment,
  `code` tinyint(4) NOT NULL,
  `name` varchar(100) NOT NULL,
  `mainitem_code` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1"; 
$dbquery = mysqli_query($connect,$sql_create);

${this.title}

Code Editor : create_table.php