projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
326bef0
)
bigserial (bigint) keys for queue tables and h_ tables of things that already have...
author
Ivan Kohler
<ivan@freeside.biz>
Wed, 15 May 2013 05:50:46 +0000
(22:50 -0700)
committer
Ivan Kohler
<ivan@freeside.biz>
Wed, 15 May 2013 05:50:46 +0000
(22:50 -0700)
FS/FS/Schema.pm
patch
|
blob
|
history
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
ed23d31
..
1da302d
100644
(file)
--- a/
FS/FS/Schema.pm
+++ b/
FS/FS/Schema.pm
@@
-236,6
+236,12
@@
sub dbdef_dist {
}
}
+ my $historynum_type = ( $tableobj->column($tableobj->primary_key)->type
+ =~ /^(bigserial|bigint|int8)$/i
+ ? 'bigserial'
+ : 'serial'
+ );
+
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',
@@
-244,7
+250,7
@@
sub dbdef_dist {
'columns' => [
DBIx::DBSchema::Column->new( {
'name' => 'historynum',
'columns' => [
DBIx::DBSchema::Column->new( {
'name' => 'historynum',
- 'type' =>
'serial'
,
+ 'type' =>
$historynum_type
,
'null' => 'NOT NULL',
'length' => '',
'default' => '',
'null' => 'NOT NULL',
'length' => '',
'default' => '',
@@
-1533,7
+1539,7
@@
sub tables_hashref {
'gatewaynum', 'int', 'NULL', '', '', '',
#'cust_balance', @money_type, '', '',
'paynum', 'int', 'NULL', '', '', '',
'gatewaynum', 'int', 'NULL', '', '', '',
#'cust_balance', @money_type, '', '',
'paynum', 'int', 'NULL', '', '', '',
- 'jobnum',
'
int', 'NULL', '', '', '',
+ 'jobnum',
'big
int', 'NULL', '', '', '',
],
'primary_key' => 'paypendingnum',
'unique' => [ [ 'payunique' ] ],
],
'primary_key' => 'paypendingnum',
'unique' => [ [ 'payunique' ] ],
@@
-2664,7
+2670,7
@@
sub tables_hashref {
'queue' => {
'columns' => [
'queue' => {
'columns' => [
- 'jobnum',
'
serial', '', '', '', '',
+ 'jobnum',
'big
serial', '', '', '', '',
'job', 'varchar', '', 512, '', '',
'_date', 'int', '', '', '', '',
'status', 'varchar', '', $char_d, '', '',
'job', 'varchar', '', 512, '', '',
'_date', 'int', '', '', '', '',
'status', 'varchar', '', $char_d, '', '',
@@
-2683,10
+2689,10
@@
sub tables_hashref {
'queue_arg' => {
'columns' => [
'queue_arg' => {
'columns' => [
- 'argnum', '
serial',
'', '', '', '',
- 'jobnum',
'int',
'', '', '', '',
- 'frozen',
'char', 'NULL',
1, '', '',
- 'arg', 'text', 'NULL', '', '', '',
+ 'argnum', '
bigserial',
'', '', '', '',
+ 'jobnum',
'bigint',
'', '', '', '',
+ 'frozen',
'char', 'NULL',
1, '', '',
+ 'arg',
'text', 'NULL', '', '', '',
],
'primary_key' => 'argnum',
'unique' => [],
],
'primary_key' => 'argnum',
'unique' => [],
@@
-2695,9
+2701,9
@@
sub tables_hashref {
'queue_depend' => {
'columns' => [
'queue_depend' => {
'columns' => [
- 'dependnum',
'
serial', '', '', '', '',
- 'jobnum',
'
int', '', '', '', '',
- 'depend_jobnum', 'int', '', '', '', '',
+ 'dependnum',
'big
serial', '', '', '', '',
+ 'jobnum',
'big
int', '', '', '', '',
+ 'depend_jobnum', '
big
int', '', '', '', '',
],
'primary_key' => 'dependnum',
'unique' => [],
],
'primary_key' => 'dependnum',
'unique' => [],