my $h_tableobj = DBIx::DBSchema::Table->new( {
name => "h_$table",
primary_key => 'historynum',
my $h_tableobj = DBIx::DBSchema::Table->new( {
name => "h_$table",
primary_key => 'historynum',
'atype', 'varchar', '', $char_d,
],
'primary_key' => 'typenum',
'atype', 'varchar', '', $char_d,
],
'primary_key' => 'typenum',
'closed', 'char', 'NULL', 1,
],
'primary_key' => 'invnum',
'closed', 'char', 'NULL', 1,
],
'primary_key' => 'invnum',
'disabled', 'char', 'NULL', 1,
],
'primary_key' => 'eventpart',
'disabled', 'char', 'NULL', 1,
],
'primary_key' => 'eventpart',
'closed', 'char', 'NULL', 1,
],
'primary_key' => 'crednum',
'closed', 'char', 'NULL', 1,
],
'primary_key' => 'crednum',
'comments', 'text', 'NULL', '',
],
'primary_key' => 'custnum',
'comments', 'text', 'NULL', '',
],
'primary_key' => 'custnum',
#'index' => [ ['last'], ['company'] ],
'index' => [ ['last'], [ 'company' ], [ 'referral_custnum' ] ],
},
#'index' => [ ['last'], ['company'] ],
'index' => [ ['last'], [ 'company' ], [ 'referral_custnum' ] ],
},
'dest', 'varchar', '', $char_d,
],
'primary_key' => 'destnum',
'dest', 'varchar', '', $char_d,
],
'primary_key' => 'destnum',
'tax', 'real', '', '', #tax %
],
'primary_key' => 'taxnum',
'tax', 'real', '', '', #tax %
],
'primary_key' => 'taxnum',
# 'unique' => [ ['taxnum'], ['state', 'county'] ],
# 'unique' => [ ['taxnum'], ['state', 'county'] ],
'closed', 'char', 'NULL', 1,
],
'primary_key' => 'paynum',
'closed', 'char', 'NULL', 1,
],
'primary_key' => 'paynum',
'address1', 'varchar', '', $char_d,
'address2', 'varchar', 'NULL', $char_d,
'city', 'varchar', '', $char_d,
'address1', 'varchar', '', $char_d,
'address2', 'varchar', 'NULL', $char_d,
'city', 'varchar', '', $char_d,
- 'state', 'varchar', '', $char_d,
+ 'state', 'varchar', 'NULL', $char_d,
'zip', 'varchar', '', 10,
'country', 'char', '', 2,
# 'trancode', 'int', '', '',
'zip', 'varchar', '', 10,
'country', 'char', '', 2,
# 'trancode', 'int', '', '',
'manual_flag', 'char', 'NULL', 1,
],
'primary_key' => 'pkgnum',
'manual_flag', 'char', 'NULL', 1,
],
'primary_key' => 'pkgnum',
'closed', 'char', 'NULL', 1,
],
'primary_key' => 'refundnum',
'closed', 'char', 'NULL', 1,
],
'primary_key' => 'refundnum',
'svcpart', 'int', '', '',
],
'primary_key' => 'svcnum',
'svcpart', 'int', '', '',
],
'primary_key' => 'svcnum',
'index' => [ ['svcnum'], ['pkgnum'], ['svcpart'] ],
},
'index' => [ ['svcnum'], ['pkgnum'], ['svcpart'] ],
},
'taxclass', 'varchar', 'NULL', $char_d,
],
'primary_key' => 'pkgpart',
'taxclass', 'varchar', 'NULL', $char_d,
],
'primary_key' => 'pkgpart',
'referral', 'varchar', '', $char_d,
],
'primary_key' => 'refnum',
'referral', 'varchar', '', $char_d,
],
'primary_key' => 'refnum',
'disabled', 'char', 'NULL', 1,
],
'primary_key' => 'svcpart',
'disabled', 'char', 'NULL', 1,
],
'primary_key' => 'svcpart',
'loc', 'char', 'NULL', 4, #NULL for legacy purposes
],
'primary_key' => 'popnum',
'loc', 'char', 'NULL', 4, #NULL for legacy purposes
],
'primary_key' => 'popnum',
'index' => [ [ 'npa', 'nxx' ], [ 'popnum' ] ],
},
'index' => [ [ 'npa', 'nxx' ], [ 'popnum' ] ],
},
],
'primary_key' => 'svcnum',
'unique' => [ ['domain'] ],
],
'primary_key' => 'svcnum',
'unique' => [ ['domain'] ],
'recdata', 'varchar', '', $char_d,
],
'primary_key' => 'recnum',
'recdata', 'varchar', '', $char_d,
],
'primary_key' => 'recnum',
'dst', 'varchar', 'NULL', $char_d,
],
'primary_key' => 'svcnum',
'dst', 'varchar', 'NULL', $char_d,
],
'primary_key' => 'svcnum',
'usersvc', 'int', '', '',
],
'primary_key' => 'svcnum',
'usersvc', 'int', '', '',
],
'primary_key' => 'svcnum',
],
'primary_key' => 'prepaynum',
'unique' => [ ['identifier'] ],
],
'primary_key' => 'prepaynum',
'unique' => [ ['identifier'] ],