NyvA8jLM

1CREATE DATABASE IF NOT EXISTS Lietsu_Feedback;
2USE Lietsu_Feedback;
3
4
5
6
7
8CREATE TABLE IF NOT EXISTS feedback (
9    TicketID INT NOT NULL auto_increment,                       /*Kysely lomakkeen lähettämät tiedot*/
10    RoomID INT DEFAULT NULL,                                   /**/
11    Email VARCHAR(50) DEFAULT NULL,                           /**/
12    Recommend TINYINT(4) DEFAULT NULL,                       /**/
13    OpenFeedback varchar(5000) DEFAULT NULL,                /**/
14    SendDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, /**/
15    Shortage varchar(500) DEFAULT NULL,                   /**/
16    FixText varchar(2000) DEFAULT NULL,                  /**/
17    AnswerWish TINYINT(4) DEFAULT 0 NOT NULL,           /**/
18
19
20    Handler varchar(25) DEFAULT NULL,       /*Hallintapaneelin tietoja*/
21    StartDate timestamp NULL DEFAULT NULL, /**/
22    EndDate timestamp NULL DEFAULT NULL,  /**/
23    Actions varchar(5000) DEFAULT NULL,  /**/
24    Answer varchar(5000) DEFAULT NULL,  /**/
25    ReadStatus TINYINT(4) DEFAULT 0,   /**/
26    
27
28    CONSTRAINT PK_TicketID PRIMARY KEY (TicketID) /*Asetetaan primary key*/
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;