April, 2009Archive for

mysql schema…. finally

I know this has taken waaay to long to post. But here it is if anyone still wants it. # CREATE DATABASE voip; # USE voip; # # Table structure for table 'allocation' # # DROP TABLE IF EXISTS allocation; CREATE TABLE `allocation` ( `allocation_id` int(11) NOT NULL auto_increment, `asset_id` int(11) NOT NULL default '0', `site_id` int(11) NOT NULL default '0', `extension` int(11) NOT NULL default '0', PRIMARY KEY (`allocation_id`) ) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=latin1 COLLATE...