CREATE TABLE `news_tb` ( `id` int(5) NOT NULL auto_increment primary key, `subject_name` varchar(200) NOT NULL, `news_details` text NOT NULL, `date_news` date NOT NULL, `school_name` varchar(200) NOT NULL, `fullname` varchar(200) NOT NULL, `tel` varchar(200) NOT NULL, `number` varchar(200) NOT NULL, `email` varchar(100) NOT NULL, `file1_name` varchar(50) NOT NULL, `file2_name` varchar(50) NOT NULL, `file3_name` varchar(50) NOT NULL, `file4_name` varchar(50) NOT NULL, `file5_name` varchar(50) NOT NULL, `file6_name` varchar(50) NOT NULL, `file7_name` varchar(50) NOT NULL, `file8_name` varchar(50) NOT NULL, `file9_name` varchar(50) NOT NULL, `file10_name` varchar(50) NOT NULL, `file11_name` varchar(50) NOT NULL, `file12_name` varchar(50) NOT NULL, `file1_name_f` varchar(50) NOT NULL, `file2_name_f` varchar(50) NOT NULL, `mycontent` longtext NOT NULL, `open_total` int(5) NOT NULL, `txt_tmp1` text NOT NULL, `txt_tmp2` text NOT NULL, `datetime_send` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=tis620