· 8 years ago · Jul 18, 2018, 05:10 PM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2CREATE TABLE IF NOT EXISTS `settings` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 `body` text COLLATE utf8_unicode_ci NOT NULL,
6 PRIMARY KEY (`id`)
7) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
8INSERT INTO `settings` (`id`, `subject`, `body`) VALUES
9(1, 'Subject', 'Body');