#!/usr/bin/perl -Tw
#
-# $Id: fs-setup,v 1.28 2000-10-30 10:47:26 ivan Exp $
+# $Id: fs-setup,v 1.34 2001-04-09 23:05:16 ivan Exp $
#
# ivan@sisd.com 97-nov-8,9
#
# 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
'custnum', 'int', '', '',
'_date', @date_type,
'charged', @money_type,
- 'owed', @money_type,
'printed', 'int', '', '',
],
'primary_key' => 'invnum',
'custnum', 'int', '', '',
'_date', @date_type,
'amount', @money_type,
- 'credited', @money_type,
'otaker', 'varchar', '', 8,
'reason', 'varchar', '', 255,
],
'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' => [ [] ],
'prepaynum', 'int', '', '',
'identifier', 'varchar', '', $char_d,
'amount', @money_type,
+ 'seconds', 'int', 'NULL', '',
],
'primary_key' => 'prepaynum',
'unique' => [ ['identifier'] ],
'port' => {
'columns' => [
'portnum', 'int', '', '',
- 'ip', 'varchar', NULL, 15,
- 'nasport' 'int', NULL, '',
+ 'ip', 'varchar', 'NULL', 15,
+ 'nasport', 'int', 'NULL', '',
'nasnum', 'int', '', '',
],
'primary_key' => 'portnum',
'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' ] ],
'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' => [],