Table Creation
In the project's portal database, create the following tables whose fields will be used by the sources of the douidefinition.xml:
AخA
1
CREATE TABLE tr3_hotel
2
(
3
hotelId CHAR(32) PRIMARY KEY NOT NULL,
4
name NVARCHAR(100) NOT NULL,
5
introduction NTEXT NULL,
6
description NTEXT NOT NULL,
7
image CHAR(32) NULL,
8
crowded INT NOT NULL DEFAULT 0,
9
cityId CHAR(32) NULL
10
)
11
CREATE TABLE tr3_city
12
(
13
cityId CHAR(32) PRIMARY KEY NOT NULL,
14
name NVARCHAR(100) NOT NULL,
15
state CHAR(2) NOT NULL
16
)