-- ---------------------------- -- Table structure for `news` -- ---------------------------- DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `id` int(11) NOT NULL auto_increment, `title` text NOT NULL, `full` longtext NOT NULL, `short` longtext, `author` text NOT NULL, `date` text, `cat` text NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `users` -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `user` varchar(100) NOT NULL, `pass` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, UNIQUE KEY `user` (`user`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;