X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=5d5bd4eabe6ee7f72b593986580d076f1be34c05;hp=c0bbd0ae4ac8a5a0ca28cc2f68e3299dbb12b315;hb=c9678906cb89a0c05a67d8118898202b64f84fd6;hpb=a87829a0945ad5199b8676756c3186a7139d086d

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index c0bbd0ae4..5d5bd4eab 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -2020,6 +2020,19 @@ sub tables_hashref {
       'unique' => [ ],
       'index' => [ ['phonenum'], ['vendor_order_id'] ],
     },
+
+    'dsl_device' => {
+      'columns' => [
+        'devicenum', 'serial',     '', '', '', '',
+        #part_device?  or our own part_dsl_device?
+        #'devicepart',   'int',     '', '', '', '',
+        'svcnum',       'int',     '', '', '', '', 
+        'mac_addr', 'varchar',     '', 12, '', '', 
+      ],
+      'primary_key' => 'devicenum',
+      'unique' => [ [ 'mac_addr' ], ],
+      'index'  => [ [ 'svcnum' ], ], # [ 'devicepart' ] ],
+    },
     
     'dsl_note' => {
       'columns' => [