projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
depend on DBIx::DBSchema 0.26 for dbdef-create (for Pg 'public' schema fix) and 0...
[freeside.git]
/
FS
/
bin
/
freeside-setup
diff --git
a/FS/bin/freeside-setup
b/FS/bin/freeside-setup
index
74aa5e2
..
a2ef31e
100755
(executable)
--- a/
FS/bin/freeside-setup
+++ b/
FS/bin/freeside-setup
@@
-9,7
+9,7
@@
use Getopt::Std;
use Locale::Country;
use Locale::SubCountry;
use DBI;
use Locale::Country;
use Locale::SubCountry;
use DBI;
-use DBIx::DBSchema 0.2
1
;
+use DBIx::DBSchema 0.2
5
;
use DBIx::DBSchema::Table;
use DBIx::DBSchema::Column;
use DBIx::DBSchema::ColGroup::Unique;
use DBIx::DBSchema::Table;
use DBIx::DBSchema::Column;
use DBIx::DBSchema::ColGroup::Unique;
@@
-343,10
+343,11
@@
sub tables_hash_hack {
'type_pkgs' => {
'columns' => [
'type_pkgs' => {
'columns' => [
+ 'typepkgnum', 'serial', '', '',
'typenum', 'int', '', '',
'pkgpart', 'int', '', '',
],
'typenum', 'int', '', '',
'pkgpart', 'int', '', '',
],
- 'primary_key' => '',
+ 'primary_key' => '
typepkgnum
',
'unique' => [ ['typenum', 'pkgpart'] ],
'index' => [ ['typenum'] ],
},
'unique' => [ ['typenum', 'pkgpart'] ],
'index' => [ ['typenum'] ],
},
@@
-399,6
+400,7
@@
sub tables_hash_hack {
'cust_bill_pkg' => {
'columns' => [
'cust_bill_pkg' => {
'columns' => [
+ 'billpkgnum', 'serial', '', '',
'pkgnum', 'int', '', '',
'invnum', 'int', '', '',
'setup', @money_type,
'pkgnum', 'int', '', '',
'invnum', 'int', '', '',
'setup', @money_type,
@@
-407,7
+409,7
@@
sub tables_hash_hack {
'edate', @date_type,
'itemdesc', 'varchar', 'NULL', $char_d,
],
'edate', @date_type,
'itemdesc', 'varchar', 'NULL', $char_d,
],
- 'primary_key' => '',
+ 'primary_key' => '
billpkgnum
',
'unique' => [],
'index' => [ ['invnum'] ],
},
'unique' => [],
'index' => [ ['invnum'] ],
},
@@
-487,8
+489,9
@@
sub tables_hash_hack {
'ship_night', 'varchar', 'NULL', 20,
'ship_fax', 'varchar', 'NULL', 12,
'payby', 'char', '', 4,
'ship_night', 'varchar', 'NULL', 20,
'ship_fax', 'varchar', 'NULL', 12,
'payby', 'char', '', 4,
- 'payinfo', 'varchar', 'NULL', $char_d,
- 'paycvv', 'varchar', 'NULL', 4,
+ 'payinfo', 'varchar', 'NULL', 512,
+ 'paycvv', 'varchar', 'NULL', 512,
+ 'paymask', 'varchar', 'NULL', $char_d,
#'paydate', @date_type,
'paydate', 'varchar', 'NULL', 10,
'payname', 'varchar', 'NULL', $char_d,
#'paydate', @date_type,
'paydate', 'varchar', 'NULL', 10,
'payname', 'varchar', 'NULL', $char_d,
@@
-712,12
+715,13
@@
sub tables_hash_hack {
'pkg_svc' => {
'columns' => [
'pkg_svc' => {
'columns' => [
+ 'pkgsvcnum', 'serial', '', '',
'pkgpart', 'int', '', '',
'svcpart', 'int', '', '',
'quantity', 'int', '', '',
'primary_svc','char', 'NULL', 1,
],
'pkgpart', 'int', '', '',
'svcpart', 'int', '', '',
'quantity', 'int', '', '',
'primary_svc','char', 'NULL', 1,
],
- 'primary_key' => '',
+ 'primary_key' => '
pkgsvcnum
',
'unique' => [ ['pkgpart', 'svcpart'] ],
'index' => [ ['pkgpart'] ],
},
'unique' => [ ['pkgpart', 'svcpart'] ],
'index' => [ ['pkgpart'] ],
},
@@
-1057,10
+1061,11
@@
sub tables_hash_hack {
'part_svc_router' => {
'columns' => [
'part_svc_router' => {
'columns' => [
+ 'svcrouternum', 'serial', '', '',
'svcpart', 'int', '', '',
'routernum', 'int', '', '',
],
'svcpart', 'int', '', '',
'routernum', 'int', '', '',
],
- 'primary_key' => '',
+ 'primary_key' => '
svcrouternum
',
'unique' => [],
'index' => [],
},
'unique' => [],
'index' => [],
},
@@
-1107,11
+1112,12
@@
sub tables_hash_hack {
'virtual_field' => {
'columns' => [
'virtual_field' => {
'columns' => [
+ 'vfieldnum', 'serial', '', '',
'recnum', 'int', '', '',
'vfieldpart', 'int', '', '',
'value', 'varchar', '', 128,
],
'recnum', 'int', '', '',
'vfieldpart', 'int', '', '',
'value', 'varchar', '', 128,
],
- 'primary_key' => '',
+ 'primary_key' => '
vfieldnum
',
'unique' => [ [ 'vfieldpart', 'recnum' ] ],
'index' => [],
},
'unique' => [ [ 'vfieldpart', 'recnum' ] ],
'index' => [],
},
@@
-1178,6
+1184,7
@@
sub tables_hash_hack {
'rate_detail' => {
'columns' => [
'rate_detail' => {
'columns' => [
+ 'ratedetailnum', 'serial', '', '',
'ratenum', 'int', '', '',
'orig_regionnum', 'int', 'NULL', '',
'dest_regionnum', 'int', '', '',
'ratenum', 'int', '', '',
'orig_regionnum', 'int', 'NULL', '',
'dest_regionnum', 'int', '', '',
@@
-1186,7
+1193,7
@@
sub tables_hash_hack {
'sec_granularity', 'int', '', '',
#time period (link to table of periods)?
],
'sec_granularity', 'int', '', '',
#time period (link to table of periods)?
],
- 'primary_key' => '',
+ 'primary_key' => '
ratedetailnum
',
'unique' => [ [ 'ratenum', 'orig_regionnum', 'dest_regionnum' ] ],
'index' => [],
},
'unique' => [ [ 'ratenum', 'orig_regionnum', 'dest_regionnum' ] ],
'index' => [],
},
@@
-1227,10
+1234,11
@@
sub tables_hash_hack {
'reg_code_pkg' => {
'columns' => [
'reg_code_pkg' => {
'columns' => [
+ 'codepkgnum', 'serial', '', '',
'codenum', 'int', '', '',
'pkgpart', 'int', '', '',
],
'codenum', 'int', '', '',
'pkgpart', 'int', '', '',
],
- 'primary_key' => '',
+ 'primary_key' => '
codepkgnum
',
'unique' => [ [ 'codenum', 'pkgpart' ] ],
'index' => [ [ 'codenum' ] ],
},
'unique' => [ [ 'codenum', 'pkgpart' ] ],
'index' => [ [ 'codenum' ] ],
},