sql-schema-playground-python-random.sql

-- Create the Customers table
CREATE TABLE Customers (
  CustomerID INT PRIMARY KEY,
  CustomerName VARCHAR(255),
  ContactName VARCHAR(255),
  Country VARCHAR(255)
);

-- Insert sample data into the Customers table
INSERT INTO Customers (CustomerID, CustomerName, ContactName, Country)
VALUES
  (1, 'Alfreds Futterkiste', 'Maria Anders', 'Germany'),
  (2, 'Berglunds snabbkop', 'Christina Berglund', 'Sweden'),
  (3, 'Centro comercial Moctezuma', 'Francisco Chang', 'Mexico'),
  (4, 'ErnstX Handle', 'Roland Mendel', 'Austria'), -- Modified this line
  (5, 'John Smith', 'John Doe', 'USA'),
  (6, 'Jonathan Doe', 'Jane Doe', 'USA'),
  (7, 'Anna Nerg', 'Anna Bell', 'USA'),
  (8, 'Central Park', 'Park Ranger', 'USA'),
  (9, 'Commercial Centre', 'Centre Manager', 'USA'),
  (10, 'Ernst A Handle', 'Ernst A', 'Austria');

-- Create the Users table
CREATE TABLE Users (
  UserID INT PRIMARY KEY,
  Email VARCHAR(255)
);

-- Insert sample data into the Users table
INSERT INTO Users (UserID, Email)
VALUES
  (1, '[email protected]'),
  (2, '[email protected]'),
  (3, '[email protected]'),
  (4, '[email protected]');

-- Create the Contacts table
CREATE TABLE Contacts (
  ContactID INT PRIMARY KEY,
  PhoneNumber VARCHAR(255)
);

-- Insert sample data into the Contacts table
INSERT INTO Contacts (ContactID, PhoneNumber)
VALUES
  (1, '(123) 456-7890'),
  (2, '(123) 555-7890'),
  (3, '(456) 123-7890'),
  (4, '(789) 123-4567');