+ 'part_svc_router' => {
+ 'columns' => [
+ 'svcpart', 'int', '', '',
+ 'routernum', 'int', '', '',
+ ],
+ 'primary_key' => '',
+ 'unique' => [],
+ 'index' => [],
+ },
+
+ 'part_router_field' => {
+ 'columns' => [
+ 'routerfieldpart', 'serial', '', '',
+ 'name', 'varchar', '', $char_d,
+ 'length', 'int', '', '',
+ 'check_block', 'text', 'NULL', '',
+ 'list_source', 'text', 'NULL', '',
+ ],
+ 'primary_key' => 'routerfieldpart',
+ 'unique' => [],
+ 'index' => [],
+ },
+
+ 'router_field' => {
+ 'columns' => [
+ 'routerfieldpart', 'int', '', '',
+ 'routernum', 'int', '', '',
+ 'value', 'varchar', '', 128,
+ ],
+ 'primary_key' => '',
+ 'unique' => [ [ 'routerfieldpart', 'routernum' ] ],
+ 'index' => [],
+ },
+
+ 'addr_block' => {
+ 'columns' => [
+ 'blocknum', 'int', '', '',
+ 'routernum', 'int', '', '',
+ 'ip_gateway', 'varchar', '', 15,
+ 'ip_netmask', 'int', '', '',
+ ],
+ 'primary_key' => 'blocknum',
+ 'unique' => [ [ 'blocknum', 'routernum' ] ],
+ 'index' => [],
+ },
+
+ 'part_sb_field' => {
+ 'columns' => [
+ 'sbfieldpart', 'int', '', '',
+ 'svcpart', 'int', '', '',
+ 'name', 'varchar', '', $char_d,
+ 'length', 'int', '', '',
+ 'check_block', 'text', 'NULL', '',
+ 'list_source', 'text', 'NULL', '',
+ ],
+ 'primary_key' => 'sbfieldpart',
+ 'unique' => [ [ 'sbfieldpart', 'svcpart' ] ],
+ 'index' => [],
+ },
+
+ 'sb_field' => {
+ 'columns' => [
+ 'sbfieldpart', 'int', '', '',
+ 'svcnum', 'int', '', '',
+ 'value', 'varchar', '', 128,
+ ],
+ 'primary_key' => '',
+ 'unique' => [ [ 'sbfieldpart', 'svcnum' ] ],
+ 'index' => [],
+ },
+
+ 'svc_broadband' => {
+ 'columns' => [
+ 'svcnum', 'int', '', '',
+ 'blocknum', 'int', '', '',
+ 'speed_up', 'int', '', '',
+ 'speed_down', 'int', '', '',
+ 'ip_addr', 'varchar', '', 15,
+ ],
+ 'primary_key' => 'svcnum',
+ 'unique' => [],
+ 'index' => [],
+ },