From 55a68e4aabe10db4d9c3ab1bb8befd2f9f4b9008 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Sat, 29 Jan 2005 12:34:12 +0000
Subject: registration codes

---
 FS/bin/freeside-setup | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

(limited to 'FS/bin/freeside-setup')

diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup
index c867a721f..24b0685de 100755
--- a/FS/bin/freeside-setup
+++ b/FS/bin/freeside-setup
@@ -1209,6 +1209,26 @@ sub tables_hash_hack {
       'index'       => [ [ 'countrycode' ], [ 'regionnum' ] ],
     },
 
+    'reg_code' => {
+      'columns' => [
+        'codenum',   'serial',    '', '',
+        'code',      'varchar',   '', $char_d,
+        'agentnum',  'int',       '', '',
+      ],
+      'primary_key' => 'codenum',
+      'unique'      => [ [ 'agentnum', 'code' ] ],
+      'index'       => [ [ 'agentnum' ] ],
+    },
+
+    'reg_code_pkg' => {
+      'columns' => [
+        'codenum',   'int',    '', '',
+        'pkgpart',   'int',    '', '',
+      ],
+      'primary_key' => '',
+      'unique'      => [ [ 'codenum', 'pkgpart' ] ],
+      'index'       => [ [ 'codenum' ] ],
+    },
 
   );
 
-- 
cgit v1.2.1