Changeset 868

Show
Ignore:
Timestamp:
07/08/08 06:45:35 (2 months ago)
Author:
rach
Message:

correction bug script db mysql

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

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

    r862 r868  
    946946CREATE TABLE cc_agent_tariffgroup ( 
    947947        id_agent BIGINT( 20 ) NOT NULL , 
    948         id_tariffgroup INT( 11 ) NOT NULL 
     948        id_tariffgroup INT( 11 ) NOT NULL, 
     949        PRIMARY KEY ( id_agent,id_tariffgroup ) 
    949950) ENGINE=MyISAM; 
    950951 
    …… 
    978979-- new table for the free minutes/calls package 
    979980 
    980 CREATE TABLE cc_logpackage ( 
    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 ) 
    988 ) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 
    989  
    990981 
    991982CREATE TABLE cc_package_group ( 


Google