istio.io/istio@v0.0.0-20240520182934-d79c90f27776/samples/bookinfo/src/mysql/mysqldb-init.sql (about)

     1  # Initialize a mysql db with a 'test' db and be able test productpage with it.
     2  # mysql -h 127.0.0.1 -ppassword < mysqldb-init.sql
     3  
     4  CREATE DATABASE test;
     5  USE test;
     6  
     7  CREATE TABLE `ratings` (
     8    `ReviewID` INT NOT NULL,
     9    `Rating` INT,
    10    PRIMARY KEY (`ReviewID`)
    11  );
    12  INSERT INTO ratings (ReviewID, Rating) VALUES (1, 5);
    13  INSERT INTO ratings (ReviewID, Rating) VALUES (2, 4);