INSERT INTO `articles` VALUES
(1, 'Welcome to sNews 1.7', 'welcome-to-snews-17', '
If you're seeing this article, you have installed sNews 1.7 and are connected to the database.

rnrn
It is strongly suggested that you login right away, the default username and password is "test" and "test", then go to the page "settings". At the bottom of that page you'll find "Change Username and Password". Do it and make the password hard to guess.

rnrn
After doing that, feel free to delete this article & start building your site.

rnrn
If you stumble along the way, check the Troubleshooting and FAQ page.  If you're still having trouble search the sNews CMS Forum before posting your question, it may already be answered.  Still lost? We'll be there to assist you in any way we can.

rnrn
Thank you for choosing sNews.  We hope you enjoy it as much as we do.

', NOW(), 1, 1, '', '', 'YES', 'YES', 'NO', 1, '', '', 'YES', 'NO', '1', 'YES', 'NO');

CREATE TABLE `extras` (
    `id` int(8) primary key auto_increment,
     `name` varchar(40) NOT NULL,
    `seftitle` varchar(100) default NULL,
    `description` varchar(100) NOT NULL
);
    INSERT INTO `extras` VALUES (1, 'Extra', 'extra', 'The default extra');

CREATE TABLE `categories` (
    `id` int(8) primary key auto_increment,
     `name` varchar(100) NOT NULL,
     `seftitle` varchar(100) NOT NULL,
     `description` varchar(255) NOT NULL,
     `published` varchar(4) NOT NULL default 'YES',
     `catorder` smallint(6) NOT NULL default '0',
     `subcat` int(8) NOT NULL default '0'
);
    INSERT INTO `categories` VALUES ('1', 'Uncategorized', 'uncategorized', '', 'YES', '1', '0');

CREATE TABLE `comments` (
     `id` int(11) primary key auto_increment,
     `articleid` int(11) default '0',
     `name` varchar(50),
     `url` varchar(100) NOT NULL,
     `comment` text,
     `time` datetime NOT NULL default '0000-00-00 00:00:00',
     `approved` varchar(5) NOT NULL default 'True'
);

CREATE TABLE `settings` (
     `id` int(8) primary key auto_increment,
     `name` varchar(20) NOT NULL,
     `value` varchar(255) NOT NULL
);
    INSERT INTO `settings` VALUES (1, 'website_title', 'sNews 1.7');
    INSERT INTO `settings` VALUES (2, 'home_sef', 'home');
    INSERT INTO `settings` VALUES (3, 'website_description', 'sNews CMS');
    INSERT INTO `settings` VALUES (4, 'website_keywords', 'new, site, snews');
    INSERT INTO `settings` VALUES (5, 'website_email', 'info@mydomain.com');
    INSERT INTO `settings` VALUES (6, 'contact_subject', 'Contact Form');
    INSERT INTO `settings` VALUES (7, 'language', 'EN');
    INSERT INTO `settings` VALUES (8, 'charset', 'UTF-8');
    INSERT INTO `settings` VALUES (9, 'date_format', 'd.m.Y. H:i');
    INSERT INTO `settings` VALUES (10, 'article_limit', '3');
    INSERT INTO `settings` VALUES (11, 'rss_limit', '5');
    INSERT INTO `settings` VALUES (12, 'display_page', '');
    INSERT INTO `settings` VALUES (13, 'display_new_on_home', '');
    INSERT INTO `settings` VALUES (14, 'display_pagination', '');
    INSERT INTO `settings` VALUES (15, 'num_categories', 'on');
    INSERT INTO `settings` VALUES (16, 'show_cat_names', '');
    INSERT INTO `settings` VALUES (17, 'approve_comments', '');
    INSERT INTO `settings` VALUES (18, 'mail_on_comments', '');
    INSERT INTO `settings` VALUES (19, 'comment_repost_timer', '20');
    INSERT INTO `settings` VALUES (20, 'comments_order', 'ASC');
    INSERT INTO `settings` VALUES (21, 'comment_limit', '30');
    INSERT INTO `settings` VALUES (22, 'enable_comments', 'NO');
    INSERT INTO `settings` VALUES (23, 'freeze_comments', 'NO');
    INSERT INTO `settings` VALUES (24, 'word_filter_enable', '');
    INSERT INTO `settings` VALUES (25, 'word_filter_file', '');
    INSERT INTO `settings` VALUES (26, 'word_filter_change', '');
    INSERT INTO `settings` VALUES (27, 'username', '098f6bcd4621d373cade4e832627b4f6');
    INSERT INTO `settings` VALUES (28, 'password', '098f6bcd4621d373cade4e832627b4f6');
    INSERT INTO `settings` VALUES (29, 'enable_extras', 'NO');
    INSERT INTO `settings` VALUES (30, 'last_date', NOW());
    INSERT INTO `settings` VALUES (31, 'file_extensions', 'phps,php,txt,inc,htm,html');
    INSERT INTO `settings` VALUES (32, 'allowed_files', 'php,htm,html,txt,inc,css,js,swf');
    INSERT INTO `settings` VALUES (33, 'allowed_images', 'gif,jpg,jpeg,png');

    -- SPECIAL KEYS

    ALTER TABLE `articles` ADD INDEX ( `show_on_home` );
    ALTER TABLE `comments` ADD INDEX ( `articleid` );