Open the menu

    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
    )