$ cat ../sql-src/schema.sql
drop table if exists density;
create table density (
density_id integer not null auto_increment primary key,
density varchar(25) not null
);
drop table if exists startype;
create table startype (
startype_id integer not null auto_increment primary key,
startype varchar(10) not null
);
drop table if exists starsize;
create table starsize (
starsize_id integer not null auto_increment primary key,
starsize varchar(10) not null
);
drop table if exists sector;
create table sector (
sector_id integer not null auto_increment primary key,
name varchar(80) not null
);
drop table if exists subsector;
create table subsector (
subsector_id integer not null auto_increment primary key,
name varchar(80) not null default 'unnamed',
location char not null default 'A',
startx integer not null default 1,
starty integer not null default 1,
endx integer not null default 8,
endy integer not null default 10,
density integer not null
references density(density_id),
sector integer not null
references sector(sector_id)
);
####
$ cat schema.conf
schema_class RPG::Traveller::DB::Schema
use_moose 1
relationships v6
monikers v6
column_accessors v6
force_ascii 1
dsn dbi:mysql:host=mydatabasehost.mydomain.com;database=starmapper
user AUSER
pass APASSWORD
##
##
$ dbicdump schema.conf
Dumping manual schema for RPG::Traveller::DB::Schema to directory . ...
Schema dump completed.