-- MySQL dump 8.22 -- -- Host: localhost Database: callid --------------------------------------------------------- -- Server version 3.23.56 -- -- Current Database: callid -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ callid; USE callid; -- -- Table structure for table 'calls' -- CREATE TABLE calls ( id mediumint(8) unsigned NOT NULL auto_increment, timestamp timestamp(14) NOT NULL, msnnr decimal(10,0) unsigned zerofill default NULL, phonenr decimal(10,0) unsigned zerofill default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Table structure for table 'names' -- CREATE TABLE names ( id mediumint(8) unsigned NOT NULL auto_increment, phonenr decimal(10,0) unsigned zerofill default NULL, name varchar(75) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM;