Kirill Solomko
30553b2c47
TT#25452 add call_id column for voicemail and faxserver
...
* add call_id for voicemail_spool
* add call_id for voip_fax_journal
Change-Id: I08b7677945cc5d29e65c138f60e972feb1487198
8 years ago
Guillem Jover
8a19769ca7
TT#19710 Use strict and warnings everywhere
...
Except when Sipwise::Base is used which implies these.
Change-Id: I8a31cfd4b73513509587f31d81b2e53868972b1b
8 years ago
Guillem Jover
e099b045cd
TT#19710 Use parent instead of base
...
The latter is very heavy-weight and its use is discouraged.
Change-Id: I05fd8d0f75db2c572035c4b81a8861711199b3a0
8 years ago
Guillem Jover
c98d125970
TT#19710 Remove autogenerated comments
...
Change-Id: I29ba75e64b39bd32a8be95a94fbb0238cf03ad7a
8 years ago
Guillem Jover
354976a4d6
TT#19710 Add DESCRIPTION section to all modules
...
This has been done with the following perl one-liner:
,---
perl -p -i -E 'if (m/->table\("([^"]*)"\)/) { $table = $1 };\
if (m/^=head1 COMPON/) { print "=head1 DESCRIPTION\n\n\
This module is a schema class for the NGCP database table \"$table\".\n\n" };'
`---
Change-Id: I030d073754f6622f66c8169c1a0cf4187462052e
8 years ago
Guillem Jover
fc4598e8b8
TT#19710 Add AUTHOR and LICENSE POD sections
...
This has been injected with a sed script of the following form:
,--- pod.sed ---
$a\
=head1 AUTHOR\
…\
=head1 LICENSE\
…
`---
Change-Id: I09bee06296199d2b2db7bd1bfbf50dc174ed90f2
8 years ago
Guillem Jover
fb7d1fdc7f
TT#19710 Do not return an explicit undef
...
Change-Id: I0518860d89a2299e323b31870ec394532ab5d8c4
Warned-by: perlcritic
8 years ago
Guillem Jover
a4fdeb08ce
TT#19710 Do not use implicit newlines
...
Use HERE-docs instead.
Change-Id: I46ae8007b3bf6eb8766cee6afc2d685638fc292a
8 years ago
Guillem Jover
676acdf115
TT#19710 Switch from deprecated use vars to our
...
Change-Id: I7a4adc00543b3a9939bd18d4db7b17dfaf2f52fc
8 years ago
Guillem Jover
9cbfb6357f
TT#19710 Convert from MS-DOS to Unix style newlines
...
Change-Id: If2132e8d29d4cd4f60fec3c53bec363a95079914
8 years ago
Gerhard Jungwirth
dfb9215b1b
TT#23775 do not load TryCatch
...
since it's not used in the codebase of NGCP::Schema and it has Moose
as a dependency. With this change, Moose will not be loaded as a dependency
of NGCP::Schema at all.
Change-Id: I01cb68486395e68fc1519b61ff86f5972bd283f8
8 years ago
Gerhard Jungwirth
824bb3102b
TT#23774 remove Moose completely
...
and clean up the dependencies by throwing out libraries we
don't use
Change-Id: Ia88a9d9f9d6744178ee382fb4a2311c1608cef32
8 years ago
Rene Krenn
37939b5ca1
TT#23277 change lnp_number type from enum to string
...
Change-Id: Ic9358f8b41b6447bea0c0107bf77039b85df848a
8 years ago
Rene Krenn
4f3b81722a
TT#22469 TT#22467 TT#22468 lnp number "type" columns
...
Change-Id: I340e259984bdfcb2d6461b8556b5a02c3a60991e
8 years ago
Rene Krenn
8d433cd4bb
TT#20334 TT#21092 sipwise_mam ResultSet
...
relation ends to implement performance-critical joins
of the form "sipwise_mam.username =
concat(voip_subscriber.username,'@',voip_domain.domain)"
are added to provisionin_voip_subscriber, to
have proper on-clause operands in place (and prevent
"unknown column .. in on clause" error in an elegant
way).
resultset require to join voip_domain explicitly.
Change-Id: I4e20c4232f73c7e4286b96da5ded73455a417131
8 years ago
Rene Krenn
6dbc911d7f
TT#12311 DateTime::Format::MySQL, safe for leap seconds
...
Change-Id: Id65aa4e39fc0e40e9b97c45c6aeca70f52acad6a
8 years ago
Kirill Solomko
36bfc880f6
TT#19459 add voip_cf_source_sets.mode
...
* values: whitelist, blacklist
* default: whitelist
Change-Id: Ibb43ecf03787f2276dc535afb404ac395a8891f2
8 years ago
Rene Krenn
5affe56e97
TT#14755 call list suppressions
...
Change-Id: I12e2480695a629f95433b1c34ba0bad0aa5f97e1
8 years ago
Gerhard Jungwirth
e769581e45
TT#17258 add active flag to reminders
...
Change-Id: I9497ad6c8b42dbedb12c972448c4ad52f49e494b
8 years ago
Gerhard Jungwirth
b61cd27024
TT#13784 add stopper flag to peering rules
...
Change-Id: Ibbf70cb3f146f96e749fd97f5b173cfa6a65f170
8 years ago
Kirill Solomko
438a62fcb0
TT#12593 add voip_fax_preferences t38, ecm columns
...
* add provisioning.voip_fax_preferences t38 column
* add provisioning.voip_fax_preferences ecm column
Change-Id: I7950b72ffb278a78a92ac909607ef2ba9611ca8a
8 years ago
Kirill Solomko
36701bec86
TT#12661 add voip_fax_data schema
...
- add support for provisioning.voip_fax_data
Change-Id: I9d823d81cfacdbb9cd5be27dce91b34543f3ae7d
8 years ago
Rene Krenn
aeaf59aed4
TT#14235 fix fraud query empty daily notify and lock
...
Change-Id: I9387f7d48d06c5be961180ee767d0c6993fcc5b4
8 years ago
Andreas Granig
8cb779ea7e
TT#8704 Implement peer probing.
...
* Add probe column to voip_peer_hosts
Change-Id: I7c2b6a1605d9880f28434c9ad6a5082ace486389
8 years ago
Rene Krenn
2ef47d963e
TT#13754 edr tags for primary aliases
...
Change-Id: Idd188e3a01e38ea597de5dc52ebac886b22a3347
8 years ago
Andreas Granig
528614f96e
TT#13277 Implement panel interface for call rec
...
Allows you to see/delete recorded calls and listen to the streams.
Change-Id: I57d02796990a127eaae82ed60c960a0f89343e59
8 years ago
Gerhard Jungwirth
3fecfca1f4
TT#4335 subscriber profile left join relation
...
for subscriber api of reminders
Change-Id: Ib17cdd434807944ee56401d8fcb3d9877b94a15c
8 years ago
Andreas Granig
17a5cdaa2d
TT#12601 New column to store salted bcrypt hash
...
Change-Id: I55e12b1f0e8782759c311ad6a7f880d80858643a
8 years ago
Rene Krenn
6dc66aeeff
TT#9850 drop foreign keys of billing.voip_intercept
...
Change-Id: I2afc13aa8bf2a20566560a2cf2a8d9af9bababa7
8 years ago
Irina Peshinskaya
ee61638327
TT#9212 Add cid and key autoprov params to enum
...
Change-Id: Ied507b6752a2468bafc53c7e64db4f0b218c2dec
8 years ago
Rene Krenn
088a4074fa
TT#6735 TT#5850 refactor "profile" events to track number changes
...
Change-Id: Id648f8283e1164b23a9aacb59b35ef33d310b970
8 years ago
Kirill Solomko
2433052dae
TT#5826 add contact.timezone, add timezone views
...
* add voip_subscriber_timezone (view)
* add voip_contract_timezone (view)
* add voip_reseller_timezone (view)
Change-Id: Ib61df3627b7f8f06753beb0652a297c45cd043ad
8 years ago
Irina Peshinskaya
84d5bcef26
TT#9212 Add grandstream enums
...
Change-Id: I74ab77711c3a11dd765b2d3e7265e48a72716937
8 years ago
Rene Krenn
1b98bb0fbc
TT#9714 susbcriber first non-prim alias for edr records
...
Change-Id: I9b033a66507c94459fbf11c0f5592ebad91c81a0
8 years ago
Andreas Granig
8ad362065c
TT#2371 Add coding and pcc options to sms journal.
...
Required to mark and forward sms based on 3rd party call control.
Change-Id: I366f3e3cd9aace7732f63438127fa5163807cac7
8 years ago
Rene Krenn
34b77a65da
TT#6735 TT#7030 TT#5850 accountin.events entity-attribute-value models
...
Change-Id: I5b336f291a2c449ecd1f678ab7405a0bde4c318f
8 years ago
Irina Peshinskaya
e95561ac82
TT#5954 Add announcement relation to cf destination
...
Change-Id: Id4c5073e2dc2d6712cebdb235929fb12a71a4a43
9 years ago
Rene Krenn
2c2b1961e1
TT#5559 events datetime inflate
...
+ fix writing hires seconds
Change-Id: I6f7f19b05c0a068c8cb7c349d5ddb263a6c5859d
9 years ago
Andreas Granig
fd3f6c6627
TT#2371 Add sms forward options
...
Change-Id: I14b6c166aef9eeee55b775bfd30143f11c53737e
9 years ago
Kirill Solomko
07ed8a1e48
TT#5004 add autoprov_firmwares_data schema
...
* also remove data col from autoprof_firmwares
Change-Id: Ic0ee9ca8afa31d15c7d5c395bb829ed7e596f714
9 years ago
Kirill Solomko
bb1690cccc
TT#7169 fix contract_fraud_events virtual sql
...
* GROUP only by contract_id in the billing_mapping
INNER JOIN to have only 1 record per contract_id
with the most recent start_time
- (if there is only one record with NULL start_time
(the default one) it is properly fetched
Change-Id: I0d312eb6685d109e99affd91249ae312d919a59d
9 years ago
Kirill Solomko
e933215b48
TT#5549 add voip_fax_journal caller_uuid, caller_uuid
...
Change-Id: I071dd4275329222171d8b554eebb10982195259c
9 years ago
Rene Krenn
4ebb5b9bc3
MT#20639 billing.contacts "status" column
...
Change-Id: Ie294128df9a79d4a7ad14848865739415d665c2a
9 years ago
Gerhard Jungwirth
49d653ace0
TT#2369 add table sms_journal
...
Change-Id: I7a4f6deed9df0ffb8481c6956b60ef2bd4d7b513
9 years ago
Gerhard Jungwirth
d404f40e7b
MT#3591 enable view search utf8 characters
...
Change-Id: Ib5ff4924af17620432a776079acee0fc7f77b623
9 years ago
Rene Krenn
645635ea5e
MT#20027 porting number history
...
-drop all misleading lnp_number unique keys again
-retain lnp_provider delete cascade restrict
-lnp_numbers_actual dbix virtual view
+groupwise maximums solely by "number"
(no lnp_provider_id!)
Change-Id: If075ddc445825140151855ff3cc64aa63404645e
9 years ago
Gerhard Jungwirth
a69dfcb6db
TT#2395 add anumber upn rewrite tables
...
Change-Id: Iecc36c437d200bac1b3e3fb9da3936ea5e98ead3
9 years ago
Andreas Granig
9a24751ce0
TT#3991 Add ncos level flag for intra-pbx calls
...
If set and a call is done within a pbx customer, the call is blocked
in blacklist, and is allowed in whitelist.
Change-Id: I8b5cb3f8ed73ce7df6871121568a32fae2b6c8c6
9 years ago
Andreas Granig
6777cf289e
TT#2766 Implement inbound peering rules.
...
Change-Id: If7e2d3ec75d20328e408d095c1ea276dc5959921
9 years ago
Irina Peshinskaya
d8e3297eef
TT#2452 Add device profile preferences result set
...
Change-Id: Ida987aca2df686869c9f0f4831dca340a63c3d7d
9 years ago
Irina Peshinskaya
9bd5a308c2
TT#2452 Add device preferences result set
...
Change-Id: I4f16e59b6bdba68d5e278e9d0052372683ddba83
9 years ago
Irina Peshinskaya
aac1f8c8b2
MT#18499 Add missed contract_pref column into voip_preferences tables
...
Change-Id: I25d5440826297fb25c1b80a19a0c1b2fdc6dba28
9 years ago
Gerhard Jungwirth
7241d0216a
TT#2393 new tables voip_cf_source* for anumber cfs
...
callforwards based on the caller number
Change-Id: If961a329b6cd9564f73faa7e1d24d0f0f76426be
9 years ago
Irina Peshinskaya
6bf510969e
MT#21269 Add snom_redirect enum value to the prov tables
...
Change-Id: Ib9a4763b75cc4ec738122838bf7402349617773e
9 years ago
Andreas Granig
bc1cb2bf18
MT#21543 Add new emergency mapping tables
...
Change-Id: I3e3f48f7a2ac7fb5d6688ad25b8349ccc00c7b06
9 years ago
Rene Krenn
14c8888bfc
MT#20023 MT#20027 lnp numbers unique constraint and cascade delete restriction
...
Change-Id: I8262c7c4390680e455bb9aef330e245f639ebf1f
9 years ago
Gerhard Jungwirth
3693093e5a
MT#19795 rtc_sessions deprecate network tag
...
by adding the default value. Not specifying the network tag anymore, will now
have no negative effect, but specifying it won't break things either. Thus
making it effectively backwards-compatible according to the new company-guideline
supporting rollbacks.
This description in ngcp-schema is purely cosmetical.
Change-Id: I59f1be63fa037271840957b08551b65261152a0b
9 years ago
Andreas Granig
3dae8a8810
MT#19457 Add lnp authoritative and skip_rewrite
...
Authoritative is rejecting call with 404 if number is not assigned
to local subscriber.
Skip Rewrite is skipping lnp rewrite rules.
Change-Id: I2a308f712712adcd1075b249ab704e47daca1007
9 years ago
Kirill Solomko
c75d506f27
MT#18865 fix inflate_column for voip_fax_journal.time
...
Change-Id: I9d06bb6b0df13947c5834cc2d78987ae0496076c
9 years ago
Kirill Solomko
c01dc8b3bd
MT#18499 added voip_contract_loctions, voip_contract_location_blocks
...
Change-Id: If24db5454ab4c30a6302d99a76391c36c5c0f2cc
9 years ago
Andreas Granig
956fcfb092
MT#16777 Add lnp rwr and lnp routing number
...
Change-Id: Ia027187c045c0602ece538534a3bb142d73467fc
9 years ago
Kirill Solomko
50e273c2ab
MT#18381 added contract_fraud_events virtual table
...
Change-Id: I77ab4698fade8e9af15db63fc143a5063727dd2a
9 years ago
Kirill Solomko
a0d1fc21b8
MT#14675 changed default config to /etc/ngcp-panel/provisioning.conf
...
Change-Id: I2a23d6f4c44ecd8cdf9475abe61de22645947edc
9 years ago
Gerhard Jungwirth
322bf002f5
MT#15883 adapt rtcsessions table
...
Change-Id: I2ad3be5ccf814569be228b24a052b8f00c3da6fa
9 years ago
Kirill Solomko
933d3b8d2b
MT#14679 new voip_mail_to_fax tables, new voip_fax_journal table
...
Change-Id: I2d8d3b26613582a77a211fa469ce08548071f949
9 years ago
Andreas Granig
2a5e53e0a6
MT#16895 Add prefix to lnp_providers table
...
Change-Id: I0eb2ffd200a81804a22717560331132bc33a85ed
10 years ago
Gerhard Jungwirth
6b1e4c9d14
MT#15883 add rtc "reverse" relationships
...
Change-Id: I388e1d7b7396fc4de07b241d5057982910ba9c1b
10 years ago
Gerhard Jungwirth
ba2214fcbc
MT#15883 add rtc tables
...
Change-Id: Ic38f1e4d1b41f9879a79af0c696eb236d975551a
10 years ago
Irina Peshinskaya
8682847259
MT#16321 More narrow conditions for subquery to improve billing_mappings speed
...
Change-Id: I4c86b84b1e49edcdcadd134f9e2acb0792f02822
10 years ago
Andreas Granig
ce027db188
MT#16465 Remove Moose and others where possible
...
Change-Id: I904160e13fe0bb0608ee672c6b294ec2cd7dbed8
10 years ago
Rene Krenn
94f650f638
MT#16171 cdr 'subscriber' relationship with custom join cond
...
Change-Id: Ie6dbcf5018e8181e284dba2fc1f719fee832de6c
10 years ago
Rene Krenn
09a386f82f
MT#15477 topup_log resultset
...
+removed timestamp inflation fixup code from
all resultsets
+resultset renamed to topup_logS
Change-Id: Ic97aad9ea2c75e67e93a4ad6e48e55395786511a
10 years ago
Rene Krenn
33142b4570
MT#15367 rateomat updates CDRs with zones_history.id, not .bz_id
...
retriggered+2
Change-Id: I15b6b01996a018e601936ff1150586c9a0915519
10 years ago
Irina Peshinskaya
4ec4080244
MT#14477 Link provisioning.voip_subscribers to kamailio.subscriber
...
Change-Id: I1e0985b3201b66fbe899b584ce141bbe11b27a3a
10 years ago
Kirill Solomko
35cafa15d9
MT#12707 - malicious_calls: add source field
...
Change-Id: I280a05087db2fe048c1a51f15172d6bc360e5039
10 years ago
Rene Krenn
8295f2b4c6
MT#14255 add balance underrun detection ts columns
...
+add "hour" balance interval enum value
Change-Id: I719dc96e4f05b84475f0d9f7305f79653396bd8b
10 years ago
Kirill Solomko
0aff34d2f9
MT#12707 - add malicious_calls schema
...
Change-Id: I7353bf1f415f11d1567938bc6f69ca79b40111f2
10 years ago
Rene Krenn
048c7bc73d
MT#14301 remove prof package 'status' field
...
+cleanup
Change-Id: I90d66da38ce2c8bcae244f8bcb67c0135e6ada1b
10 years ago
Rene Krenn
76a96049c8
MT#13903 model update - 'topup_interval' mode
...
Change-Id: I852ca9a5896428cda52fd8f649ef683af33432db
10 years ago
Rene Krenn
83e94b3ecf
MT#13903 package_id and relationships for vouchers
...
+and topup counters
Change-Id: I1ab584bd2b96e0ecc9df8d3036c19319a88c090a
10 years ago
Rene Krenn
26632809f6
MT#13903 fix invoices-balances relationship
...
make it bidirectional, otherwise DBIx complains with "Unable to resolve relationship from .. to ..: column .. .invoice_id not loaded from storage (or not passed to new() prior to insert()). Maybe you forgot to call ->discard_changes to get defaults from the db."
Change-Id: Iccf1ac66da27379844249e61f4ace1a3d2979f19
10 years ago
Rene Krenn
046f2d8455
MT#12643 billing networks
...
+billing networks, profile packages
+service charge and "topup" balance interval start mode added to profile package
+profile package <-> customer relationship
+delete cascade and relationship joins revised
Change-Id: I5cb58c810e90ec7550549ccc4d71bbce855fe851
10 years ago
Irina Peshinskaya
2082b7c6d2
MT#13531 create link to email_templates for resellers
...
Change-Id: I85aab671096a756d2ff0b30c88d04707469f497e
10 years ago
Irina Peshinskaya
7edb284b74
MT#13369 Extend enum for lineranges positions
...
Change-Id: I286184c52a7cc08084d8ecb15af60b211fac921a
10 years ago
Andreas Granig
2df7fc00c9
MT#13201 Add billing_data acl to admins
...
Change-Id: I207b75af90db43e6da7e40b526b62769e23abe83
10 years ago
Irina Peshinskaya
3a804ffb66
MT#7227 Temporary location for not unique billing_fees
...
Change-Id: I602d073b8d36383f267ee4ed6a18efbbf188b46d
10 years ago
Kirill Solomko
d69debe54a
MT#11225 - add billing_profiles.fraud_use_reseller_rates
...
Change-Id: I393c567b0ee8aa955187c72f816f5baa8fd0c1a4
10 years ago
Irina Peshinskaya
8ac49c00b5
MT#11791 Increase costs precisions to 6 number after point
...
To enable accounting using low prices
Change-Id: Iff76500920eafb409458bb69e44075be1d89d01f
10 years ago
Andreas Granig
2afdeeee4f
MT#12385 Add reseller_id to EDR head.
...
Change-Id: I2a6845f0a6a7b4d2adc0f7493f1a1138b977795c
10 years ago
Rene Krenn
55180f55cb
MT#11917 Align journal to db schema
...
Change-Id: Iffa441161e13e46a045ff7214ba661eb39e6ac1f
10 years ago
Irina Peshinskaya
368eb45649
MT#11549 View is too slowly, use other sql variant, so remove view
...
This reverts commit 6e41b8f515
.
Change-Id: I59f9217129e1125adc356547000b7a6b67fe84ae
10 years ago
Irina Peshinskaya
cefcb12bf0
MT#11147 Link phone to the some extensions of the same model
...
Change-Id: I6c346cf8c32daaf4186f37c00f64fe6b7ac3f4c3
10 years ago
Rene Krenn
347ff4d65b
MT#11917 Add journaling table
10 years ago
Irina Peshinskaya
1fb4179c37
MT#11147 Fix copy-pasted relationship
...
Change-Id: I7e6642f56c016d376638961a1f78ef10276306fd
10 years ago
Irina Peshinskaya
b4e58a7bf1
MT#11549 Use view with alias group_concat to search by aliases
...
Change-Id: I118a013f21697019e8047dc73b992b12b9dc34ac
10 years ago
Irina Peshinskaya
fe69f9ad2c
MT#11147 Fix extensions_num field name
10 years ago
Irina Peshinskaya
37778fb6e3
MT#11147 Add num extensions
10 years ago
Irina Peshinskaya
e9588a939e
MT#11147 Rename extension type basic to phone
10 years ago
Irina Peshinskaya
00fd2b3e93
MT#11147 Changes for device model-extension reference
10 years ago
Irina Peshinskaya
232a8569e6
MT#11147 Schema for device model and extension reference
10 years ago
Andreas Granig
2e381bbc09
MT#10879 Set uuid as mailbox user if no number.
...
mailbox field needs to be increased for that to work.
10 years ago
Andreas Granig
67989fab7c
MT#10885 Prevent foreign key deletion by schema.
...
Should be handled in mysql directly, not by schema.
10 years ago
Kirill Solomko
f84a0ea3aa
MT#10169 - add voip_peer_hosts.enabled, voip_peer_rules.enabled, voip_rewrite_rules.enabled
...
Change-Id: I5c44aa3b73bc2c954ee38ec5f8e5a86116352bbb
10 years ago
Irina Peshinskaya
5b8a539be2
MT#10715 Ngcp schema changes for Polycom bootstrap
10 years ago
Andreas Granig
7a23695a43
MT#10587 Add autoprov_field_devices.encryption_key
11 years ago
Andreas Granig
a09d9aa78a
MT#10199 Add subscriber profile preferences.
11 years ago
Andreas Granig
5879605b9d
MT#10199 Add subscriber profile preferences.
11 years ago
Irina Peshinskaya
641cbfbea0
MT#9177 Change linksys to yealink in enums
11 years ago
Irina Peshinskaya
17c40c1241
MT#9177 Add bootstrap_uri and fix tables relations
11 years ago
Kirill Solomko
b712efcdd4
MT#8645 - add billing_profiles status, create_timestamp,
...
modify_timestamp, terminate_timestamp
add billing_mappings contract_active "belongs_to" relation
11 years ago
Andreas Granig
83ed0fee85
MT#9177 Rework autoprov vendor credentials.
11 years ago
Irina Peshinskaya
6b19d8e12b
MT#9177 Fix vendors enum for contract credentials.
11 years ago
Irina Peshinskaya
5befb25cad
MT#9177 Move vendor credentials to db
11 years ago
Irina Peshinskaya
7959d2b56f
MT#9177 Add bootstrap_method into device.
11 years ago
Irina Peshinskaya
97018216b4
MT#9177 Rename sync_type to bootstrap_method
11 years ago
Irina Peshinskaya
ec0861874b
MT#9177 Fix incomplete commit with centralised parameter table
11 years ago
Irina Peshinskaya
ed6b6df5fc
MT#9177 Fix for the centralized parameters table
11 years ago
Irina Peshinskaya
83f8e088be
MT#9177 More generic sync_type and don't use vendor as sync_type marker.
11 years ago
Irina Peshinskaya
f61fde45a8
MT#9177 Clear off table from specific tables schema.
11 years ago
Irina Peshinskaya
1e7fd6c04e
MT#9177 Fix comments for sync tables.
11 years ago
Irina Peshinskaya
722fd5ed72
MT#9177 Schema for provisioning with centralized table. Draft.
11 years ago
Irina Peshinskaya
ceea3ff4eb
MT#9177 Version of separate table per sync model.
...
Not sure that it will be really good model.
Just save before change to all models properties in one table.
11 years ago
Andreas Granig
5bdcf019eb
MT#9565 Expose cdr src/dst gpp params
11 years ago
Andreas Granig
2cc146fc70
MT#9277 Fix billing voucher schema.
11 years ago
Andreas Granig
81085d3306
MT#9277 Add voucher schema.
11 years ago
Irka
d70a8d329c
MT#8371 Optimize select actual billing_mappings with virtual view
11 years ago
Andreas Granig
030117ef80
MT#8613 Update voip_intercept schema
11 years ago
Gerhard Jungwirth
9564862b0e
MT#8397 Remove dependency MooseX::FileAttribute
...
cause its not pacakaged in Debian
11 years ago
Andreas Granig
a95679e56b
MT#8299 Add pbx device model annotations
11 years ago
Irka
b5443053fd
MT#8433 Don't clear contract_balances on invoice deletion.
...
As far as I remember it is rudiment of old invoicing schema,
when balance supposed to be changed on invoice issue. Web interfaces
allows to remove invoices, it led to removed balance => fixed.
11 years ago
Irka
1af2e8be28
MT#5879 Clean up code and db from invoice templates activity flag
11 years ago
Irina Peshinskaya
1917f7efb4
MT#7867 Changes for invoice template per customer.
11 years ago
Andreas Granig
917ce48990
MT#7793 Add accounting.events schema.
11 years ago
Andreas Granig
3daadc6194
MT#7545 Allow multiple pbx groups per subscriber
11 years ago
Andreas Granig
e0ca5cf7d2
MT#7679 Add random and circular hunt policies.
11 years ago
Andreas Granig
9b66a2d420
MT#6827 Fix pbx device profile relation.
11 years ago
Irina Peshinskaya
5a1a07811b
MT#5879 Remove country_name wrapper.
11 years ago
Irina Peshinskaya
041207b98f
MT#5879 Set invoices data column size to 16M.
11 years ago
Irina Peshinskaya
f5fca0819c
MT#5879 Add sent marker into invoices and country_name into contacts.
...
Country_name as a method to wrap country code into full name.
11 years ago
Irina Peshinskaya
20887f5dba
MT#5789 Add invoice email template relationship into contracts.
11 years ago
Andreas Granig
0f7460d61b
MT#7471 Add contract preferences schema.
11 years ago
Andreas Granig
85049c3ccc
MT#5879 Rework invoice-relevant tables.
11 years ago
Andreas Granig
0167baa629
MT#7377 Add is_pbx_pilot to prov subscriber
11 years ago
Andreas Granig
9a255c41b5
MT#5879 Cleanup invoice tables and add gpp contact
...
Drop unnecessary invoice template tables.
Provide proper columns in invoice and invoice templates table.
Add general purpose columns to contacts.
11 years ago
Andreas Granig
3f1ff593d4
MT#5879 Add VAT number to contacts.
11 years ago
Andreas Granig
a860b52c15
MT#5879 Fix reseller relation for invoice tmpl
11 years ago
Andreas Granig
5203c511fc
MT#7199 add iban and bic fields.
11 years ago
Andreas Granig
a1acf5d1e1
MT#6827 Deprecate linerange_num field.
11 years ago
Gerhard Jungwirth
08570826e2
MT#3955 Add relation to cdr-billing_zones_history
...
- destination_customer_billing_zones_history
11 years ago
Andreas Granig
5482b463c0
MT#7039 Add provisioning relations to location
11 years ago