· 8 years ago · Aug 01, 2018, 05:32 PM
1CREATE TABLE IF NOT EXISTS `settingsedit` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
4 `sitename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 `description` text COLLATE utf8_unicode_ci NOT NULL,
6 `keywords` text COLLATE utf8_unicode_ci NOT NULL,
7 `sitename2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
8 `locale2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
9 `author` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
10 PRIMARY KEY (`id`)
11) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
12
13--
14-- Sťahujem dáta pre tabuľku `settingsedit`
15--
16
17INSERT INTO `settingsedit` (`id`, `locale`, `sitename`, `description`, `keywords`, `sitename2`, `locale2`, `author`) VALUES
18(1, 'cs', 'Unknown title', '', '', '', 'Czech', 'Marcel "Hopyers" KriÅ¡tofÃk');