E18GQ5rL

1CREATE TABLE IF NOT EXISTS `comments` (
2`id` int(11) NOT NULL,
3  `name` varchar(50) NOT NULL,
4  `admin` varchar(50) NOT NULL,
5  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
6  `comment` text NOT NULL
7) ENGINE=InnoDB DEFAULT CHARSET=latin1;
8
9-- --------------------------------------------------------
10
11--
12-- Tabellenstruktur für Tabelle `panellog`
13--
14
15CREATE TABLE IF NOT EXISTS `panellog` (
16`id` int(11) NOT NULL,
17  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
18  `name` varchar(50) NOT NULL,
19  `target` varchar(50) NOT NULL,
20  `type` varchar(50) NOT NULL,
21  `logvalues` text NOT NULL
22) ENGINE=InnoDB DEFAULT CHARSET=latin1;
23
24--
25-- Indizes der exportierten Tabellen
26--
27
28--
29-- Indizes für die Tabelle `comments`
30--
31ALTER TABLE `comments`
32 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`);
33
34--
35-- Indizes für die Tabelle `panellog`
36--
37ALTER TABLE `panellog`
38 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`);
39
40--
41-- AUTO_INCREMENT für exportierte Tabellen
42--
43
44--
45-- AUTO_INCREMENT für Tabelle `comments`
46--
47ALTER TABLE `comments`
48MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
49--
50-- AUTO_INCREMENT für Tabelle `panellog`
51--
52ALTER TABLE `panellog`
53MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;