Changeset 856

Timestamp:

06/24/08 11:50:16 (2 months ago)

Author:

rach

Message:

Card Group :
Schema DB
Creation and Edition

Files:

• trunk/admin/Public/A2B_entity_card_group.php (added)
• trunk/admin/Public/form_data/FG_var_card_group.inc (added)
• trunk/admin/Public/templates/default/main.tpl (modified) (1 diff)
• trunk/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql.sql (modified) (4 diffs)

trunk/admin/Public/templates/default/main.tpl

@@ -46 +46 @@
-        <ul>
-                <li><ul>
-atmenu=card&
+
-                                <li><a href="A2B_entity_card.php?form_action=ask-add&atmenu=card&stitle=Card&section=1">{php} echo gettext("Create Customers");{/php}</a></li>
-
+
+
+
-                                <li><a href="A2B_entity_card_multi.php?stitle=Card&section=1">{php} echo gettext("Generate Customers");{/php}</a></li>
-atmenu=sipfriend&
+
-                                <li><a href="A2B_entity_friend.php?form_action=ask-add&atmenu=sipfriend&stitle=SIP+Friends&section=1">{php} echo gettext("Create SIP-FRIEND");{/php}</a></li>
-                                <li><a href="A2B_entity_friend.php?atmenu=iaxfriend&stitle=IAX+Friends&section=1">{php} echo gettext("List IAX-FRIEND");{/php}</a></li>

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

@@ -816 +816 @@
-  creationdate timestamp NOT NULL default CURRENT_TIMESTAMP,
-  creator bigint(20) NOT NULL,
-`status`
+status
-  PRIMARY KEY  (id)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
@@ -824 +824 @@
-CREATE TABLE cc_ticket_comment (
-  id bigint(20) NOT NULL auto_increment,
-`date`
+date
-  id_ticket bigint(10) NOT NULL,
-  description text collate utf8_bin,
@@ -833 +833 @@
-
-
-`cc_config` ( `config_title`, `config_key`, `config_value`, `config_description`, `config_valuetype`
+cc_config ( config_title, config_key, config_value, config_description, config_valuetype
- VALUES ( 'Support Modules', 'support', '1', 'Enable or Disable the module of support', 1, 3, 'yes,no');
-
@@ -968 +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);     
-     
+--create group for the card     
+     
+CREATE TABLE cc_card_group (
+id INT NOT NULL AUTO_INCREMENT ,
+name CHAR( 30 ) NOT NULL collate utf8_bin ,
+id_agi_conf INT NOT NULL ,
+PRIMARY KEY ( id )
+) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+--insert default group
+
+INSERT INTO cc_card_group (
+id ,
+name ,
+id_agi_conf
+)
+VALUES (
+NULL , 'DEFAULT', '-1'
+);
+