CREATE TABLE IF NOT EXISTS ENTVOIPACCTGROUP VoIP Account Group ATRVOIP

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
CREATE TABLE IF NOT EXISTS ENTVOIPACCTGROUP ( ### VoIP Account Group
ATRVOIPACCTGRID int(11) NOT NULL auto_increment, # VoIP Account Group ID
ATRVOIPACCTGRNAME varchar(60) NOT NULL default '', # Group Name
ATRVOIPACCTGRCMNT varchar(80) NOT NULL default '', # Group Description
ATRRESID int(11) NOT NULL default '0', # Reseller ID
ATRAGNTID int(11) NOT NULL default '0', # Agent ID
ATRINVMODE int(4) NOT NULL default '0', # default invoicing mode (0- none, 1-manual, 2-auto
ATRINVMDAY int(2) NOT NULL default '1', # default invoicing month day
ATRPAYMETHODID int(4) NOT NULL default '1', # payment method
ATRLOWBALANCELEVEL decimal(20,8) NOT NULL default '10.00', # low balance warning level
ATRNOTIFY int(8) NOT NULL default '0', # group notify flags (bit 0 - notify low balance)
ATRPREFIX varchar(20) NOT NULL default '', # incoming tech prefix for group
PRIMARY KEY (ATRVOIPACCTGRID),
UNIQUE KEY ATRVOIPACCTGRNAME (ATRVOIPACCTGRNAME)
) TYPE=MyISAM;