iro.sql
author Sandro Knauß <knauss@netzguerilla.net>
Sun, 19 Feb 2012 17:47:39 +0100
branchdevel
changeset 175 c29acd5fb841
parent 87 d28afc9c6516
permissions -rw-r--r--
splitting tests.job -> test.job, tests.tasks tests.job adding stati (setError,setStatus) tests

DROP TABLE IF EXISTS `acounting`;
CREATE TABLE `acounting` (
  `id` varchar(250) NOT NULL,
  `tel` varchar(60) NOT NULL DEFAULT '',
  `status` varchar(255) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`,`tel`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `job`;
CREATE TABLE `job` (
  `id` varchar(250) NOT NULL,
  `user` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;