ZbNpikb9

1--
2-- Tabellenstruktur für Tabelle `dd_deal_emails`
3--
4
5CREATE TABLE IF NOT EXISTS `dd_deal_emails` (
6  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
7  `title` varchar(150) NOT NULL COMMENT 'Title displayed in liste views',
8  `description` varchar(250) NOT NULL COMMENT 'Description displayed in list views',
9  `type` varchar(150) NOT NULL,
10  `text` text NOT NULL COMMENT 'e-mail body in raw text',
11  `text_html` text NOT NULL COMMENT 'e-mail body in html format',
12  `language` varchar(5) NOT NULL,
13  `locked_on` datetime NOT NULL,
14  `locked_by` int(11) NOT NULL,
15  `enabled` tinyint(1) NOT NULL,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;