LqGSxsGR

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `bscom` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
6USE `bscom`;
7
8-- -----------------------------------------------------
9-- Table `bscom`.`users`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `bscom`.`users` (
12  `id` INT NOT NULL AUTO_INCREMENT ,
13  `login` VARCHAR(255) NULL ,
14  `first_name` VARCHAR(255) NULL ,
15  `last_name` VARCHAR(255) NULL ,
16  `email` VARCHAR(255) NULL ,
17  `city` VARCHAR(255) NULL ,
18  `state` VARCHAR(255) NULL ,
19  `handicap` INT(3) NULL ,
20  `crypted_password` VARCHAR(40) NULL ,
21  `salt` VARCHAR(40) NULL ,
22  `created_at` DATETIME NULL ,
23  `updated_at` DATETIME NULL ,
24  `remember_token` VARCHAR(255) NULL ,
25  `remember_token_expires_at` DATETIME NULL ,
26  `activation_code` VARCHAR(40) NULL ,
27  `activated_at` DATETIME NULL ,
28  `password_reset_code` VARCHAR(40) NULL ,
29  `enabled` TINYINT(1) NULL DEFAULT 1 ,
30  PRIMARY KEY (`id`) )
31ENGINE = InnoDB;
32
33
34-- -----------------------------------------------------
35-- Table `bscom`.`games`
36-- -----------------------------------------------------
37CREATE  TABLE IF NOT EXISTS `bscom`.`games` (
38  `id` INT NOT NULL AUTO_INCREMENT ,
39  `game_date` DATE NULL ,
40  `open` INT(2) NULL ,
41  `split` INT(2) NULL ,
42  `spare` INT(2) NULL ,
43  `strike` INT(2) NULL ,
44  `score` INT(3) NULL ,
45  `created_at` DATETIME NULL ,
46  `updated_at` DATETIME NULL ,
47  `league` TINYINT(1) NULL DEFAULT 0 ,
48  PRIMARY KEY (`id`) )
49ENGINE = InnoDB;
50
51
52-- -----------------------------------------------------
53-- Table `bscom`.`locations`
54-- -----------------------------------------------------
55CREATE  TABLE IF NOT EXISTS `bscom`.`locations` (
56  `id` INT NOT NULL AUTO_INCREMENT ,
57  `name` VARCHAR(255) NULL ,
58  `city` VARCHAR(255) NULL ,
59  `state` VARCHAR(255) NULL ,
60  `created_at` DATETIME NULL ,
61  `updated_at` DATETIME NULL ,
62  PRIMARY KEY (`id`) )
63ENGINE = InnoDB;
64
65
66-- -----------------------------------------------------
67-- Table `bscom`.`permissions`
68-- -----------------------------------------------------
69CREATE  TABLE IF NOT EXISTS `bscom`.`permissions` (
70  `id` INT NOT NULL AUTO_INCREMENT ,
71  `role_id` INT NOT NULL ,
72  `user_id` INT NOT NULL ,
73  `created_at` DATETIME NULL ,
74  `updated_at` DATETIME NULL ,
75  PRIMARY KEY (`id`) )
76ENGINE = InnoDB;
77
78
79-- -----------------------------------------------------
80-- Table `bscom`.`roles`
81-- -----------------------------------------------------
82CREATE  TABLE IF NOT EXISTS `bscom`.`roles` (
83  `id` INT NOT NULL AUTO_INCREMENT ,
84  `rolename` VARCHAR(255) NULL ,
85  `created_at` DATETIME NULL ,
86  `updated_at` DATETIME NULL ,
87  PRIMARY KEY (`id`) )
88ENGINE = InnoDB;
89
90
91-- -----------------------------------------------------
92-- Table `bscom`.`user_games`
93-- -----------------------------------------------------
94CREATE  TABLE IF NOT EXISTS `bscom`.`user_games` (
95  `game_id` INT NOT NULL ,
96  `location_id` INT NOT NULL ,
97  `user_id` INT NOT NULL ,
98  INDEX fk_user_id (`user_id` ASC) ,
99  INDEX fk_game_id (`game_id` ASC) ,
100  INDEX fk_location_id (`location_id` ASC) ,
101  CONSTRAINT `fk_user_id`
102    FOREIGN KEY (`user_id` )
103    REFERENCES `bscom`.`users` (`id` )
104    ON DELETE CASCADE
105    ON UPDATE NO ACTION,
106  CONSTRAINT `fk_game_id`
107    FOREIGN KEY (`game_id` )
108    REFERENCES `bscom`.`games` (`id` )
109    ON DELETE CASCADE
110    ON UPDATE NO ACTION,
111  CONSTRAINT `fk_location_id`
112    FOREIGN KEY (`location_id` )
113    REFERENCES `bscom`.`locations` (`id` )
114    ON DELETE NO ACTION
115    ON UPDATE NO ACTION)
116ENGINE = InnoDB;
117
118
119
120SET SQL_MODE=@OLD_SQL_MODE;
121SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
122SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;