Changeset 689

Timestamp:

04/29/08 12:27:15 (8 months ago)

Author:

stavros

Message:

trigger for pgsql as requested at r688

Files:

• trunk/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql.sql (modified) (1 diff)
• trunk/DataBase/psql/UPDATE-a2billing-v1.3.0-to-v1.4.0-pgsql.sql (modified) (1 diff)

trunk/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql.sql

@@ -772 +772 @@
-
-
--- ??????? got to do the same for postgresql, anyone :D
-DELIMITER //
-CREATE TRIGGER `a2billing`.`after_ins_cc_card` AFTER INSERT ON `a2billing`.`cc_card`

trunk/DataBase/psql/UPDATE-a2billing-v1.3.0-to-v1.4.0-pgsql.sql

@@ -773 +773 @@
-
-CREATE TRIGGER cc_ratecard_validate_regex BEFORE INSERT OR UPDATE ON cc_ratecard FOR EACH ROW EXECUTE PROCEDURE cc_ratecard_validate_regex();
+
+
+CREATE OR REPLACE FUNCTION after_ins_cc_card_logrefill() RETURNS TRIGGER AS $$
+  BEGIN
+        INSERT INTO cc_logrefill (credit,card_id,reseller_id) VALUES (NEW.credit,NEW.id,NEW.reseller);
+  END
+$$ LANGUAGE plpgsql;
+
+CREATE TRIGGER after_ins_cc_card AFTER INSERT ON cc_card FOR EACH ROW EXECUTE PROCEDURE after_ins_cc_card_logrefill();