fAhTkrFj

1CREATE TABLE IF NOT EXISTS `users` (
2  `id` INT NOT NULL AUTO_INCREMENT,
3  `username` VARCHAR(255) NOT NULL,
4  `email` VARCHAR(255) NOT NULL,
5  `password` VARCHAR(255) NOT NULL,
6  `active` TINYINT(1) NOT NULL DEFAULT 0,
7  `key` VARCHAR(255) NULL,
8  `key_type` TINYINT(2) NULL,
9  `key_expire` TIMESTAMP NULL,
10  `level` TINYINT(10) NULL DEFAULT 0,
11  `created` TIMESTAMP NOT NULL DEFAULT NOW(),
12  `banned` TINYINT(1) NOT NULL DEFAULT 0,
13  PRIMARY KEY (`id`),
14  UNIQUE INDEX `id_UNIQUE` (`id` ASC) ,
15  UNIQUE INDEX `key_UNIQUE` (`key` ASC) )
16ENGINE = InnoDB;
17
18CREATE TABLE IF NOT EXISTS `trainers` (
19  `id` INT NOT NULL AUTO_INCREMENT,
20  `name` VARCHAR(255) NOT NULL,
21  `description` TEXT NOT NULL,
22  `instagram` VARCHAR(255) NULL,
23  `facebook` VARCHAR(255) NULL,
24  `website` VARCHAR(255) NULL,
25  `img` VARCHAR(255) NOT NULL,
26  `account` INT NULL,
27  PRIMARY KEY (`id`))
28ENGINE = InnoDB;
29
30CREATE TABLE IF NOT EXISTS `plans` (
31  `id` INT NOT NULL AUTO_INCREMENT,
32  `title` VARCHAR(255) NOT NULL,
33  `description` TEXT NOT NULL,
34  `price` FLOAT UNSIGNED NOT NULL,
35  `promotion` FLOAT NULL,
36  `image` VARCHAR(255) NOT NULL,
37  `trainer` INT NULL,
38  `duration` INT UNSIGNED NOT NULL,
39  PRIMARY KEY (`id`))
40ENGINE = InnoDB;
41
42CREATE TABLE IF NOT EXISTS `users_plans` (
43  `id` INT NOT NULL AUTO_INCREMENT,
44  `userid` INT NOT NULL,
45  `planid` INT NOT NULL,
46  `expire` DATETIME NOT NULL,
47  PRIMARY KEY (`id`))
48ENGINE = InnoDB;
49
50CREATE TABLE IF NOT EXISTS `exercise` (
51  `id` INT NOT NULL AUTO_INCREMENT,
52  `date` DATE NOT NULL,
53  `content` TEXT NOT NULL,
54  `info` TEXT NULL,
55  PRIMARY KEY (`id`))
56ENGINE = InnoDB;
57
58CREATE TABLE IF NOT EXISTS `exercises_to_plans` (
59  `id` INT NOT NULL AUTO_INCREMENT,
60  `planid` INT NOT NULL,
61  `exerciseis` INT NOT NULL,
62  PRIMARY KEY (`id`),
63  UNIQUE INDEX `id_UNIQUE` (`id` ASC) )
64ENGINE = InnoDB;
65
66CREATE TABLE IF NOT EXISTS `transactions` (
67  `id` INT NOT NULL AUTO_INCREMENT,
68  `transactionId` VARCHAR(255) NOT NULL,
69  `userid` INT NOT NULL,
70  `value` FLOAT NOT NULL,
71  `plans` TEXT NOT NULL,
72  `created` TIMESTAMP NOT NULL DEFAULT NOW(),
73  PRIMARY KEY (`id`),
74  UNIQUE INDEX `transactionId_UNIQUE` (`transactionId` ASC) ,
75  INDEX `transactionId_INDEX` (`transactionId` ASC) )
76ENGINE = InnoDB;