toothpaste/sql/data.sql

-- initial data to insert into the tables: languages, irc channels, etc.

begin transaction;

---------------------------------------------------------------- channels -----

insert into channel values (default, '#emacs');
insert into channel values (default, '#haskell');
insert into channel values (default, '#haskell-beginners');
insert into channel values (default, '#python');
insert into channel values (default, '#ruby');
insert into channel values (default, '#scheme');
insert into channel values (default, '#freepost');
insert into channel values (default, '#fsf');
insert into channel values (default, '##philosophy');
insert into channel values (default, '##sailing');
insert into channel values (default, '##vegan');

--------------------------------------------------------------- languages -----

insert into language values (
    default,
    'haskell',
    'Haskell',
    default,
    true
);

insert into language values (
    default,
    'literatehaskell',
    'Literate Haskell',
    default,
    true
);

insert into language values (
    default,
    'agda',
    'Agda',
    default,
    true
);

insert into language values (
    default,
    'idris',
    'Idris',
    default,
    true
);

insert into language values (
    default,
    'elm',
    'Elm',
    default,
    true
);

insert into language values (
    default,
    'lisp',
    'Common Lisp',
    default,
    true
);

insert into language values (
    default,
    'elisp',
    'Emacs Lisp',
    default,
    true
);

insert into language values (
    default,
    'go',
    'Go',
    default,
    true
);

insert into language values (
    default,
    'python',
    'Python',
    default,
    true
);

insert into language values (
    default,
    'ruby',
    'Ruby',
    default,
    true
);

insert into language values (
    default,
    'scheme',
    'Scheme',
    default,
    true
);

insert into language values (
    default,
    'prolog',
    'Prolog',
    default,
    true
);

insert into language values (
    default,
    'bash',
    'Bash',
    default,
    true
);

insert into language values (
    default,
    'c',
    'C',
    default,
    true
);

insert into language values (
    default,
    'c++',
    'C++',
    default,
    true
);

insert into language values (
    default,
    'lua',
    'Lua',
    default,
    true
);

insert into language values (
    default,
    'perl',
    'Perl',
    default,
    true
);

insert into language values (
    default,
    'sql',
    'SQL',
    default,
    true
);

insert into language values (
    default,
    'tex',
    'TeX',
    default,
    true
);

insert into language values (
    default,
    'ocaml',
    'OCaml',
    default,
    true
);

insert into language values (
    default,
    'erlang',
    'Erlang',
    default,
    true
);

insert into language values (
    default,
    'xml',
    'XML',
    default,
    true
);

insert into language values (
    default,
    'json',
    'JSON',
    default,
    true
);

insert into language values (
    default,
    'yaml',
    'YAML',
    default,
    true
);

insert into language values (
    default,
    'turtle',
    'turtle',
    default,
    true
);

insert into language values (
    default,
    'heritage',
    'HERITAGE',
    default,
    true
);

commit;