· 8 years ago · Jan 12, 2018, 10:32 PM
1CREATE DATABASE `puistosairaala` DEFAULT CHARACTER SET utf8 COLLATE utf8_swedish_ci;
2USE `puistosairaala`;
3
4-- --------------------------------------------------------
5
6--
7-- Table structure for table `contact`
8--
9
10CREATE TABLE IF NOT EXISTS `contact` (
11 `ID` int(64) NOT NULL auto_increment,
12 `Name` varchar(64) collate utf8_swedish_ci default NULL,
13 `Phone` varchar(32) collate utf8_swedish_ci default NULL,
14 `Message` varchar(512) collate utf8_swedish_ci default NULL,
15 `Added` datetime default NULL,
16 `Replied` datetime default NULL,
17 `Status` int(11) default NULL,
18 PRIMARY KEY (`ID`)
19) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=1 ;