-- Inserting test data into termendous
-- DB

INSERT INTO users
    (nickname, email, about, password, registered) VALUES
    ('john', 'lohn@john.com','good boy', 'test', '11.12.10');
INSERT INTO users
    (nickname, email, about, password, registered) VALUES
    ('paul', 'paul@paul.org', 'dadada', 'lala', '23.03.04');

INSERT INTO content
    (is_by, title,      is_for,     is_a,       submitted,  version,    rating,     content_desc) VALUES
    ('1',   'zenburn',  'xterm',    'theme',    '11.12.10', '0.1',      '0',        'zenburn theme for xterm and urxvt');
INSERT INTO content
    (is_by, title,  is_for,     is_a,       submitted,  version,     rating,    content_desc) VALUES
    ('2',   'choo', 'ncmpcpp',  'theme',    '24.04.04', '0.1',      '1',        'choo configuration for ncmpcpp');
INSERT INTO content
    (is_by, title,  is_for,     is_a,       submitted,  version,    rating,     content_desc) VALUES
    ('1',   'baka', 'xterm',    'theme',    '14.01.11', '0.1',      '3',        'baka xterm colorscheme');
INSERT INTO content
    (is_by, title,      is_for,     is_a,       submitted,  version, rating,    content_desc) VALUES
    ('2',   'colorize', 'grep',     'snippet',  '12.12.10', '0.5',   '5',       'a config snippet to colorize grep output');
INSERT INTO content
    (is_by, title,      is_for,     is_a,       submitted,  version, rating,    content_desc) VALUES
    ('1',   'shiny',    'xterm',    'theme',    '11.01.11', '0.1',   '3',       'a colorscheme');
INSERT INTO content
    (is_by, title,      is_for,     is_a,       submitted,  version, rating,    content_desc) VALUES
    ('2',   'tar',      'ranger',   'snippet',  '11.01.11', '0.2',   '5',       'archives handling for ranger');
INSERT INTO content
    (is_by, title,      is_for,     is_a,       submitted,  version, rating,    content_desc) VALUES
    ('2',   'musicos',  'ncmpcpp',  'theme',    '11.02.11', '0.1',   '2',       'monochrome colorscheme');
INSERT INTO content
    (is_by, title,      is_for,     is_a,       submitted,  version, rating,    content_desc) VALUES
    ('1',   'test',     'mc',       'theme',    '12.01.11', '0.2',   '5',       'theme for midnight commander');
INSERT INTO content
    (is_by, title,      is_for,     is_a,       submitted,  version, rating,    content_desc) VALUES
    ('2',   'awesome',  'dvtm',     'theme',    '11.02.11', '0.1',   '3',       'dvtm yellow');
INSERT INTO content
    (is_by, title,      is_for,     is_a,       submitted,  version, rating,    content_desc) VALUES
    ('1',   'helloworld','urxvt',   'snippet',  '11.03.11', '0.3',   '5',       'perl script for urxvt');
INSERT INTO content
    (is_by, title,      is_for,     is_a,       submitted,  version, rating,    content_desc) VALUES
    ('1',   'nada',     'mutt',     'theme',    '12.03.11', '0.4',   '3',       'colorscheme for mutt');
INSERT INTO content
    (is_by, title,      is_for,     is_a,       submitted,  version, rating,    content_desc) VALUES
    ('2',   'snip',     'mutt',     'snippet',  '11.03.11', '0.4',   '3',       'two accounts handling for mutt');

INSERT INTO comments
    (is_by, is_on, submitted, comment) VALUES
    ('1', '1', '12.12.10', 'it rocks!');
INSERT INTO comments
    (is_by, is_on, submitted, comment) VALUES
    ('2', '1', '12.12.10', 'default!');