$ 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.