CardStorageManager/database.sql at master · Vinicius-Borges7/CardStorageManager · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
create database if not exists cs;
USE cs;

CREATE TABLE IF NOT EXISTS users(
	id INT(15) NOT NULL AUTO_INCREMENT,
	name VARCHAR(30) NOT NULL,
	pass VARCHAR(12) NOT NULL,
	email VARCHAR(30) NOT NULL,
	type VARCHAR(10) NOT NULL,

	primary key(id)
);

CREATE TABLE IF NOT EXISTS itemPokemon(
	id INT(15) NOT NULL AUTO_INCREMENT,
	name VARCHAR(30) NOT NULL,
	cardType VARCHAR(10) NOT NULL, /* pokemon, supporter or item */
	pokeType VARCHAR(10) NOT NULL, /* fire, water, grass, etc */
	extras VARCHAR(30),	/* allies, fullart, etc */
	quality VARCHAR(12) NOT NULL,
	rarity VARCHAR(30),
	price float4 NOT NULL,
	owner INT(30) NOT NULL,

	primary key(id)
);

CREATE TABLE IF NOT EXISTS itemMagic(
	id INT(15) NOT NULL AUTO_INCREMENT,
	name VARCHAR(30) NOT NULL,
	cardType VARCHAR(10) NOT NULL, /* monster, spell, etc*/
	color VARCHAR(50) NOT NULL,
	category VARCHAR(30),
	quality VARCHAR(12) NOT NULL,
	rarity VARCHAR(30),
	price float4 NOT NULL,
	owner INT(30) NOT NULL,

	primary key(id)
);

CREATE TABLE IF NOT EXISTS itemYugioh(
	id INT(15) NOT NULL AUTO_INCREMENT,
	name VARCHAR(30) NOT NULL,
	cardType VARCHAR(10) NOT NULL,	/* sincro, pendulum, xyz, etc */
	cardCategory VARCHAR(30),	/* dragon, speelcaster, machine, quick spell, etc */
	quality VARCHAR(12) NOT NULL,
	rarity VARCHAR(30),
	price float4 NOT NULL,
	owner INT(30) NOT NULL,

	primary key(id)
);


CREATE TABLE IF NOT EXISTS itemBakugan(
	id INT(15) NOT NULL AUTO_INCREMENT,
	name VARCHAR(30) NOT NULL,
	cardType VARCHAR(10) NOT NULL,
	pyrus int(15),
	aquos int(15),
	ventus int(15),
	subterra int(15),
	haos int(15),
	darkus int(15),
	quality VARCHAR(12) NOT NULL,
	rarity VARCHAR(30),
	price float4 NOT NULL,
	owner INT(30) NOT NULL,

	primary key(id)
);

CREATE TABLE IF NOT EXISTS itemVanguard(
	id INT(15) NOT NULL AUTO_INCREMENT,
	name VARCHAR(30) NOT NULL,
	cardType VARCHAR(10) NOT NULL,
	gauge VARCHAR(30) NOT NULL,
	quality VARCHAR(12) NOT NULL,
	rarity VARCHAR(30),
	price float4 NOT NULL,
	owner INT(30) NOT NULL,

	primary key(id)
);