3k0ENgTY

1-- *************************************************************
2-- PROJECT X
3-- Caio Victor Gonรงalves
4-- *************************************************************
5
6-- create the database
7DROP DATABASE IF EXISTS project x;
8CREATE DATABASE project x;
9
10-- select the database
11USE project x;
12
13-- create primary tables
14CREATE TABLE box_one
15(
16  	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
17	#INCLUDE IMAGE FILES ON THE FUTURE,
18  	#INCLUDE YOUR BOXES IN THE FUTURE,
19	box_name VARCHAR(255) NOT NULL,
20);
21
22CREATE TABLE objects
23(
24  	object_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
25  	#INCLUDE IMAGE FILES ON THE FUTURE,
26  	object_name VARCHAR(255) NOT NULL,
27	object_description TEXT NOT NULL,
28	objext_price INT
29);
30
31
32-- insert rows into the tables
33INSERT INTO objects(object_name, object_description, object_price) VALUES 
34('one','short description of my first item', 12345), 
35('two','short description of my second item', 2345),
36('three','short description of my third item', 345),
37;
38
39-- shows 5 items
40SELECT * FROM objects LIMIT 5;
41
42-- show 1 item
43SELECT * FROM objects LIMIT 1;
44
45-- create user
46CREATE USER x_tester@localhost 
47IDENTIFIED BY 'sesame';
48
49-- grant privileges to that user
50GRANT SELECT, INSERT, DELETE, UPDATE
51ON x.*
52TO x_tester@localhost;