Datenbank Schema hinzugefügt
authorSandro Knauß <knauss@netzguerilla.net>
Wed, 21 Dec 2011 22:06:44 +0100
changeset 87 d28afc9c6516
parent 75 c6a281dafa7a
child 89 48da990ddf8d
Datenbank Schema hinzugefügt
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;