# HG changeset patch # User Sandro Knauß # Date 1324501604 -3600 # Node ID d28afc9c6516fbc67ee1fc3e20620aa75523ab50 # Parent c6a281dafa7aec6a7ef15c02d8af2a19949fa93f Datenbank Schema hinzugefügt diff -r c6a281dafa7a -r d28afc9c6516 iro.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/iro.sql Wed Dec 21 22:06:44 2011 +0100 @@ -0,0 +1,15 @@ +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;