Changeset 862
- Timestamp:
- 07/07/08 08:55:07 (2 months ago)
- Files:
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql.sql
r860 r862 773 773 774 774 -- add reseller field in cc_card 775 -- DELIMITER //776 -- CREATE TRIGGER `after_ins_cc_card` AFTER INSERT ON `cc_card`775 -- DELIMITER // 776 -- CREATE TRIGGER `after_ins_cc_card` AFTER INSERT ON `cc_card` 777 777 -- FOR EACH ROW begin 778 778 -- … … 780 780 -- insert into cc_logrefill(credit,card_id,reseller_id) values(NEW.credit,NEW.id,NEW.reseller); 781 781 -- end 782 -- //783 -- DELIMITER ;782 -- // 783 -- DELIMITER ; 784 784 785 785 … … 940 940 ALTER TABLE cc_card ADD id_agent INT NOT NULL DEFAULT '0'; 941 941 942 -- Add card id field in CDR to authorize filtering by agent942 -- Add card id field in CDR to authorize filtering by agent 943 943 944 944 ALTER TABLE cc_call ADD card_id BIGINT( 20 ) NOT NULL AFTER username ; 945 945 946 946 CREATE TABLE cc_agent_tariffgroup ( 947 id_agent BIGINT( 20 ) NOT NULL ,948 id_tariffgroup INT( 11 ) NOT NULL947 id_agent BIGINT( 20 ) NOT NULL , 948 id_tariffgroup INT( 11 ) NOT NULL 949 949 ) ENGINE=MyISAM; 950 950 951 ALTER TABLE cc_tariffgroup_plan 952 DROP PRIMARY KEY, 953 ADD PRIMARY KEY( 954 idtariffgroup, 955 idtariffplan); 956 957 --Add new configuration payment agent 958 959 INSERT INTO cc_config ( 960 id , 961 config_title , 962 config_key , 963 config_value , 964 config_description , 965 config_valuetype , 966 config_group_id , 967 config_listvalues 968 )VALUES (NULL , 'Payment Amount', 'purchase_amount_agent', '100:200:500:1000', 'define the different amount of purchase that would be available.', '0', '5', NULL); 969 970 --create group for the card 971 951 ALTER TABLE cc_tariffgroup_plan DROP PRIMARY KEY, 952 ADD PRIMARY KEY( idtariffgroup, idtariffplan); 953 954 955 956 -- Add new configuration payment agent 957 958 INSERT INTO cc_config ( id, config_title, config_key, config_value, config_description, config_valuetype, config_group_id, config_listvalues) VALUES (NULL , 'Payment Amount', 'purchase_amount_agent', '100:200:500:1000', 'define the different amount of purchase that would be available.', '0', '5', NULL); 959 960 961 -- create group for the card 962 972 963 CREATE TABLE cc_card_group ( 973 id INT NOT NULL AUTO_INCREMENT ,974 name CHAR( 30 ) NOT NULL collate utf8_bin ,975 id_agi_conf INT NOT NULL ,976 PRIMARY KEY ( id )964 id INT NOT NULL AUTO_INCREMENT , 965 name CHAR( 30 ) NOT NULL collate utf8_bin , 966 id_agi_conf INT NOT NULL , 967 PRIMARY KEY ( id ) 977 968 ) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 978 969 979 --insert default group 980 981 INSERT INTO cc_card_group (id ,name ,id_agi_conf) 982 VALUES ('1' , 'DEFAULT', '-1');970 971 -- insert default group 972 973 INSERT INTO cc_card_group (id ,name ,id_agi_conf) VALUES ('1' , 'DEFAULT', '-1'); 983 974 984 975 ALTER TABLE cc_card ADD id_group INT NOT NULL DEFAULT '1'; 985 976 986 --create 977 978 -- new table for the free minutes/calls package 987 979 988 980 CREATE TABLE cc_logpackage ( 989 id BIGINT NOT NULL AUTO_INCREMENT , 990 call_id BIGINT NOT NULL , 991 package_id INT NOT NULL , 992 username CHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL , 993 card_id BIGINT NOT NULL , 994 time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 995 PRIMARY KEY ( id ) 996 ) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 997 998 999 CREATE TABLE cc_package_group ( 1000 id INT NOT NULL AUTO_INCREMENT , 1001 name CHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL , 1002 description MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NULL, 1003 PRIMARY KEY ( id ) 981 id BIGINT NOT NULL AUTO_INCREMENT , 982 call_id BIGINT NOT NULL , 983 package_id INT NOT NULL , 984 username CHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL , 985 card_id BIGINT NOT NULL , 986 time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 987 PRIMARY KEY ( id ) 1004 988 ) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 1005 989 1006 CREATE TABLE cc_packgroup_package ( 1007 packagegroup_id INT NOT NULL , 1008 package_id INT NOT NULL , 1009 PRIMARY KEY ( packagegroup_id , package_id ) 990 991 CREATE TABLE cc_package_group ( 992 id INT NOT NULL AUTO_INCREMENT , 993 name CHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL , 994 description MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NULL, 995 PRIMARY KEY ( id ) 996 ) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 997 998 999 CREATE TABLE cc_packgroup_package ( 1000 packagegroup_id INT NOT NULL , 1001 package_id INT NOT NULL , 1002 PRIMARY KEY ( packagegroup_id , package_id ) 1010 1003 ) ENGINE = MYISAM ; 1011 1004 1012 1005 1013 1014 package_id INT NOT NULL ,1015 rate_id INT NOT NULL ,1016 PRIMARY KEY ( package_id , rate_id )1006 CREATE TABLE cc_package_rate ( 1007 package_id INT NOT NULL , 1008 rate_id INT NOT NULL , 1009 PRIMARY KEY ( package_id , rate_id ) 1017 1010 ) ENGINE = MYISAM ; 1018 1011 1019 1020 NSERT INTO cc_config ( 1021 id , 1022 config_title , 1023 config_key , 1024 config_value , 1025 config_description , 1026 config_valuetype , 1027 config_group_id , 1028 config_listvalues 1029 ) 1030 VALUES ( 1031 NULL , 'Max Time For Unlimited Calls', 'maxtime_tounlimited_calls', '5400', 'For unlimited calls, limit the duration: amount in seconds .', '0', '11', NULL 1032 ), ( 1033 NULL , 'Max Time For Free Calls', 'maxtime_tofree_calls', '5400', 'For free calls, limit the duration: amount in seconds .', '0', '11', NULL 1034 ); 1012 INSERT INTO cc_config ( id , config_title , config_key , config_value , config_description , config_valuetype , config_group_id , config_listvalues ) VALUES ( NULL , 'Max Time For Unlimited Calls', 'maxtime_tounlimited_calls', '5400', 'For unlimited calls, limit the duration: amount in seconds .', '0', '11', NULL), (NULL , 'Max Time For Free Calls', 'maxtime_tofree_calls', '5400', 'For free calls, limit the duration: amount in seconds .', '0', '11', NULL); 1013 1014
