projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Transactions Part I!!!
[freeside.git]
/
bin
/
fs-setup
diff --git
a/bin/fs-setup
b/bin/fs-setup
index
b0f4761
..
2a37fb8
100755
(executable)
--- a/
bin/fs-setup
+++ b/
bin/fs-setup
@@
-1,6
+1,6
@@
#!/usr/bin/perl -Tw
#
#!/usr/bin/perl -Tw
#
-# $Id: fs-setup,v 1.
28 2000-10-30 10:47:2
6 ivan Exp $
+# $Id: fs-setup,v 1.
34 2001-04-09 23:05:1
6 ivan Exp $
#
# ivan@sisd.com 97-nov-8,9
#
#
# ivan@sisd.com 97-nov-8,9
#
@@
-32,7
+32,25
@@
# fix radius attributes ivan@sisd.com 98-sep-27
#
# $Log: fs-setup,v $
# fix radius attributes ivan@sisd.com 98-sep-27
#
# $Log: fs-setup,v $
-# Revision 1.28 2000-10-30 10:47:26 ivan
+# Revision 1.34 2001-04-09 23:05:16 ivan
+# Transactions Part I!!!
+#
+# Revision 1.33 2001/02/03 14:03:50 ivan
+# time-based prepaid cards, session monitor. woop!
+#
+# Revision 1.32 2000/12/04 00:13:02 ivan
+# fix nas.last type
+#
+# Revision 1.31 2000/12/01 18:34:53 ivan
+# another tyop
+#
+# Revision 1.30 2000/12/01 18:33:32 ivan
+# tyop
+#
+# Revision 1.29 2000/11/07 15:00:37 ivan
+# session monitor
+#
+# Revision 1.28 2000/10/30 10:47:26 ivan
# nas.last can't be defined NULL if indexed
#
# Revision 1.26 2000/07/06 08:57:27 ivan
# nas.last can't be defined NULL if indexed
#
# Revision 1.26 2000/07/06 08:57:27 ivan
@@
-377,7
+395,6
@@
sub tables_hash_hack {
'custnum', 'int', '', '',
'_date', @date_type,
'charged', @money_type,
'custnum', 'int', '', '',
'_date', @date_type,
'charged', @money_type,
- 'owed', @money_type,
'printed', 'int', '', '',
],
'primary_key' => 'invnum',
'printed', 'int', '', '',
],
'primary_key' => 'invnum',
@@
-405,7
+422,6
@@
sub tables_hash_hack {
'custnum', 'int', '', '',
'_date', @date_type,
'amount', @money_type,
'custnum', 'int', '', '',
'_date', @date_type,
'amount', @money_type,
- 'credited', @money_type,
'otaker', 'varchar', '', 8,
'reason', 'varchar', '', 255,
],
'otaker', 'varchar', '', 8,
'reason', 'varchar', '', 255,
],
@@
-646,6
+662,7
@@
sub tables_hash_hack {
'shell', 'varchar', 'NULL', $char_d,
'quota', 'varchar', 'NULL', $char_d,
'slipip', 'varchar', 'NULL', 15, #four TINYINTs, bah.
'shell', 'varchar', 'NULL', $char_d,
'quota', 'varchar', 'NULL', $char_d,
'slipip', 'varchar', 'NULL', 15, #four TINYINTs, bah.
+ 'seconds', 'int', 'NULL', '', #uhhhh
],
'primary_key' => 'svcnum',
'unique' => [ [] ],
],
'primary_key' => 'svcnum',
'unique' => [ [] ],
@@
-727,6
+744,7
@@
sub tables_hash_hack {
'prepaynum', 'int', '', '',
'identifier', 'varchar', '', $char_d,
'amount', @money_type,
'prepaynum', 'int', '', '',
'identifier', 'varchar', '', $char_d,
'amount', @money_type,
+ 'seconds', 'int', 'NULL', '',
],
'primary_key' => 'prepaynum',
'unique' => [ ['identifier'] ],
],
'primary_key' => 'prepaynum',
'unique' => [ ['identifier'] ],
@@
-736,8
+754,8
@@
sub tables_hash_hack {
'port' => {
'columns' => [
'portnum', 'int', '', '',
'port' => {
'columns' => [
'portnum', 'int', '', '',
- 'ip', 'varchar',
NULL
, 15,
- 'nasport'
'int', NULL
, '',
+ 'ip', 'varchar',
'NULL'
, 15,
+ 'nasport'
, 'int', 'NULL'
, '',
'nasnum', 'int', '', '',
],
'primary_key' => 'portnum',
'nasnum', 'int', '', '',
],
'primary_key' => 'portnum',
@@
-751,9
+769,7
@@
sub tables_hash_hack {
'nas', 'varchar', '', $char_d,
'nasip', 'varchar', '', 15,
'nasfqdn', 'varchar', '', $char_d,
'nas', 'varchar', '', $char_d,
'nasip', 'varchar', '', 15,
'nasfqdn', 'varchar', '', $char_d,
-# 'last', 'timestamp', '', '',
-#change to above when move to DBIx::DBSchema!!!
- 'last', 'datetime', '', '',
+ 'last', 'int', '', '',
],
'primary_key' => 'nasnum',
'unique' => [ [ 'nas' ], [ 'nasip' ] ],
],
'primary_key' => 'nasnum',
'unique' => [ [ 'nas' ], [ 'nasip' ] ],
@@
-765,11
+781,8
@@
sub tables_hash_hack {
'sessionnum', 'int', '', '',
'portnum', 'int', '', '',
'svcnum', 'int', '', '',
'sessionnum', 'int', '', '',
'portnum', 'int', '', '',
'svcnum', 'int', '', '',
-# 'login', 'timestamp', '', '',
-# 'logout', 'timestamp', '', '',
-#change to above when move to DBIx::DBSchema!!!
- 'login', 'datetime', '', '',
- 'logout', 'datetime', NULL, '',
+ 'login', @date_type,
+ 'logout', @date_type,
],
'primary_key' => 'sessionnum',
'unique' => [],
],
'primary_key' => 'sessionnum',
'unique' => [],