so Search.tsf and Search.rdf work

[freeside.git] / FS / bin / freeside-setup

diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup
index 38b9166..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 DBIx::DBSchema 0.21;
+use DBIx::DBSchema 0.25;
 use DBIx::DBSchema::Table;
 use DBIx::DBSchema::Column;
 use DBIx::DBSchema::ColGroup::Unique;
@@ -343,10 +343,11 @@ sub tables_hash_hack {
 
     'type_pkgs' => {
       'columns' => [
+        'typepkgnum', 'serial', '', '',
         'typenum',   'int',  '', '',
         'pkgpart',   'int',  '', '',
       ],
-      'primary_key' => '',
+      'primary_key' => 'typepkgnum',
       'unique' => [ ['typenum', 'pkgpart'] ],
       'index' => [ ['typenum'] ],
     },
@@ -399,6 +400,7 @@ sub tables_hash_hack {
 
     'cust_bill_pkg' => {
       'columns' => [
+        'billpkgnum', 'serial', '', '',
         'pkgnum',  'int', '', '',
         'invnum',  'int', '', '',
         'setup',   @money_type,
@@ -407,7 +409,7 @@ sub tables_hash_hack {
         'edate',   @date_type,
         'itemdesc', 'varchar', 'NULL', $char_d,
       ],
-      'primary_key' => '',
+      'primary_key' => 'billpkgnum',
       'unique' => [],
       'index' => [ ['invnum'] ],
     },
@@ -713,12 +715,13 @@ sub tables_hash_hack {
 
     'pkg_svc' => {
       'columns' => [
+        'pkgsvcnum',  'serial', '',  '',
         'pkgpart',    'int',    '',   '',
         'svcpart',    'int',    '',   '',
         'quantity',   'int',    '',   '',
         'primary_svc','char', 'NULL',  1,
       ],
-      'primary_key' => '',
+      'primary_key' => 'pkgsvcnum',
       'unique' => [ ['pkgpart', 'svcpart'] ],
       'index' => [ ['pkgpart'] ],
     },
@@ -1058,10 +1061,11 @@ sub tables_hash_hack {
 
     'part_svc_router' => {
       'columns' => [
+        'svcrouternum', 'serial', '', '',
         'svcpart', 'int', '', '',
        'routernum', 'int', '', '',
       ],
-      'primary_key' => '',
+      'primary_key' => 'svcrouternum',
       'unique'      => [],
       'index'       => [],
     },
@@ -1108,11 +1112,12 @@ sub tables_hash_hack {
 
     'virtual_field' => {
       'columns' => [
+        'vfieldnum', 'serial', '', '',
         'recnum', 'int', '', '',
         'vfieldpart', 'int', '', '',
         'value', 'varchar', '', 128,
       ],
-      'primary_key' => '',
+      'primary_key' => 'vfieldnum',
       'unique' => [ [ 'vfieldpart', 'recnum' ] ],
       'index' => [],
     },
@@ -1179,6 +1184,7 @@ sub tables_hash_hack {
 
     'rate_detail' => {
       'columns' => [
+        'ratedetailnum',   'serial', '', '',
         'ratenum',         'int',     '', '',
         'orig_regionnum',  'int', 'NULL', '',
         'dest_regionnum',  'int',     '', '',
@@ -1187,7 +1193,7 @@ sub tables_hash_hack {
         'sec_granularity', 'int',     '', '',
         #time period (link to table of periods)?
       ],
-      'primary_key' => '',
+      'primary_key' => 'ratedetailnum',
       'unique'      => [ [ 'ratenum', 'orig_regionnum', 'dest_regionnum' ] ],
       'index'       => [],
     },
@@ -1228,10 +1234,11 @@ sub tables_hash_hack {
 
     'reg_code_pkg' => {
       'columns' => [
+        'codepkgnum', 'serial', '', '',
         'codenum',   'int',    '', '',
         'pkgpart',   'int',    '', '',
       ],
-      'primary_key' => '',
+      'primary_key' => 'codepkgnum',
       'unique'      => [ [ 'codenum', 'pkgpart' ] ],
       'index'       => [ [ 'codenum' ] ],
     },