1 DROP TABLE IF EXISTS `acounting`;

     2 CREATE TABLE `acounting` (

     3   `id` varchar(250) NOT NULL,

     4   `tel` varchar(60) NOT NULL DEFAULT '',

     5   `status` varchar(255) NOT NULL,

     6   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

     7   PRIMARY KEY (`id`,`tel`)

     8 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

     9 

    10 DROP TABLE IF EXISTS `job`;

    11 CREATE TABLE `job` (

    12   `id` varchar(250) NOT NULL,

    13   `user` varchar(50) NOT NULL,

    14   PRIMARY KEY (`id`)

    15 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;