xUB62tbn

1
2SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
3SET AUTOCOMMIT = 0;
4START TRANSACTION;
5SET time_zone = "+00:00";
6
7--
8-- Database: `madplan`
9--
10CREATE DATABASE IF NOT EXISTS `madplan` DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci;
11USE `madplan`;
12
13-- --------------------------------------------------------
14
15--
16-- Struktur for tabellen `mad_Madplan`
17--
18
19CREATE TABLE `mad_Madplan` (
20  `Dato` date NOT NULL,
21  `refOpskrift` int(11) NOT NULL,
22  `Note` longtext COLLATE latin1_danish_ci NOT NULL
23) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci;
24
25-- --------------------------------------------------------
26
27--
28-- Struktur for tabellen `mad_opskrifter`
29--
30
31CREATE TABLE `mad_Opskrifter` (
32  `OpskriftID` int(11) NOT NULL,
33  `Navn` varchar(50) COLLATE latin1_danish_ci NOT NULL,
34  `KategoriRef` int(11) NOT NULL,
35  `Personer` varchar(10) COLLATE latin1_danish_ci NOT NULL,
36  `Tilberedningstid` varchar(10) COLLATE latin1_danish_ci NOT NULL,
37  `Bedoemmelse` varchar(5) COLLATE latin1_danish_ci NOT NULL,
38  `Fremgang` longtext COLLATE latin1_danish_ci NOT NULL,
39  `ServeresMed` varchar(10) COLLATE latin1_danish_ci NOT NULL DEFAULT '0000000000' COMMENT 'Angiver med 0 eller 1 om retten kan serveres med Ris, Pasta, Kartofler, Brød, Salat mv.',
40  `Reference` varchar(255) COLLATE latin1_danish_ci NOT NULL,
41  `Billede_link` varchar(255) COLLATE latin1_danish_ci NOT NULL,
42  `Udvalgt` tinyint(1) NOT NULL DEFAULT '0',
43  `CDate` datetime NOT NULL,
44  `Skjult` tinyint(1) DEFAULT '0'
45) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci;
46
47--
48-- Indeks for tabel `mad_Madplan`
49--
50ALTER TABLE `mad_Madplan`
51  ADD KEY `Dato` (`Dato`),
52  ADD KEY `refOpskrift` (`refOpskrift`);
53
54--
55-- Indeks for tabel `mad_opskrifter`
56--
57ALTER TABLE `mad_Opskrifter`
58  ADD PRIMARY KEY (`OpskriftID`);
59
60
61--
62-- Tilføj AUTO_INCREMENT i tabel `mad_opskrifter`
63--
64ALTER TABLE `mad_Opskrifter`
65  MODIFY `OpskriftID` int(11) NOT NULL AUTO_INCREMENT;
66COMMIT;
67