-- Extra data that is not essential to the dump process but may be useful for
-- using the results
-- 
-- $Id$

drop table if exists professions;
create table professions (
	id integer primary key,
	name varchar(20));

insert into professions (id, name) values
	(1, 'Soldier'),
	(2, 'Martial Artist'),
	(3, 'Engineer'),
	(4, 'Fixer'),
	(5, 'Agent'),
	(6, 'Adventurer'),
	(7, 'Trader'),
	(8, 'Bureaucrat'),
	(9, 'Enforcer'),
	(10, 'Doctor'),
	(11, 'Nano-Technician'),
	(12, 'Meta-Physicist'),
	(14, 'Keeper'),
	(15, 'Shade');

drop table if exists expansions;
create table expansions (
	id integer primary key,
	name varchar(30));

insert into expansions (id, name) values
	(0, 'Notum Wars'),
	(1, 'Shadowlands'),
	(3, 'Alien Invasion'),
	(4, 'Alien Invasion preorder'),
	(5, 'Lost Eden'),
	(6, 'Lost Eden preorder'),
	(7, 'Legacy of Xan');

drop table if exists factions;
create table factions (
	id integer primary key,
	name varchar(10));

insert into factions (id, name) values
	(0, 'Neutral'),
	(1, 'Clan'),
	(2, 'Omni-Tek');

drop table if exists breeds;
create table breeds (
	id integer primary key,
	name varchar(10));

insert into breeds (id, name) values
	(1, 'Solitus'),
	(2, 'Opifex'),
	(3, 'Nanomage'),
	(4, 'Atrox'),
	(7, 'Robotic');
