设计一个简单的旅游网站数据库并且整理为数据库脚本语言

CREATE DATABASE tourism;

USE tourism;

CREATE TABLE users ( user_id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT NULL, phone_number VARCHAR(20) NOT NULL, address VARCHAR(100) NOT NULL, is_admin BOOLEAN NOT NULL DEFAULT 0 );

CREATE TABLE destinations ( destination_id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, description TEXT NOT NULL, image_url VARCHAR(100) NOT NULL, price DECIMAL(8,2) NOT NULL );

CREATE TABLE bookings ( booking_id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, destination_id INT NOT NULL, booking_date DATE NOT NULL, FOREIGN KEY (user_id) REFERENCES users(user_id), FOREIGN KEY (destination_id) REFERENCES destinations(destination_id) );