· 9 years ago · Jan 05, 2017, 04:16 AM
1./Almikgthy
2
3==================================
4
5Deepblue.lib.umich.edu - Leaked by Almikgthy ....
6==================================
7DROP DATABASE IF EXISTS august;
8CREATE SCHEMA IF NOT EXISTS august;
9USE august;
10
11-- -----------------------------------------------------
12-- Table `august`.`user`
13-- -----------------------------------------------------
14DROP TABLE IF EXISTS `august`.`user` ;
15
16CREATE TABLE IF NOT EXISTS `august`.`user` (
17 `id` INT NOT NULL AUTO_INCREMENT,
18 `username` VARCHAR(16) NOT NULL ,
19 `password` VARCHAR(60) NULL ,
20 `email` VARCHAR(60) NULL ,
21 `sms` VARCHAR(45) NULL ,
22 `points` INT NOT NULL DEFAULT 100,
23 `last_login` TIMESTAMP NOT NULL DEFAULT NOW(),
24 PRIMARY KEY (`id`) ) ENGINE=InnoDB;
25
26INSERT INTO `user` (`id`, `username`, `password`, `email`)
27 VALUES (1, 'peplin', '$2a$10$NFxXDzT.Ep2Hz8vQEdtyH.VBDSIPeuM/sUG3bYJGoE3MtNv3uJXu2', 'peplin@umich.edu');
28INSERT INTO `user` (`id`, `username`, `password`, `email`)
29 VALUES (2, 'august_mt', '$2a$10$NFxXDzT.Ep2Hz8vQEdtyH.VBDSIPeuM/sUG3bYJGoE3MtNv3uJXu2', 'august23@umich.edu');
30INSERT INTO `user` (`id`, `username`, `password`, `email`)
31 VALUES (3, 'august_web', '$2a$10$NFxXDzT.Ep2Hz8vQEdtyH.VBDSIPeuM/sUG3bYJGoE3MtNv3uJXu2', 'august23@umich.edu');
32INSERT INTO `user` (`id`, `username`, `password`, `email`)
33 VALUES (4, 'august_client', '$2a$10$NFxXDzT.Ep2Hz8vQEdtyH.VBDSIPeuM/sUG3bYJGoE3MtNv3uJXu2', 'august23@umich.edu');
34
35-- -----------------------------------------------------
36-- Table `august`.`galaxy_shape`
37-- -----------------------------------------------------
38DROP TABLE IF EXISTS `august`.`galaxy_shape` ;
39
40CREATE TABLE IF NOT EXISTS `august`.`galaxy_shape` (
41 `id` INT NOT NULL ,
42 `name` VARCHAR(45) NOT NULL ,
43 `texture` VARCHAR(120) NOT NULL ,
44 PRIMARY KEY (`id`) ) ENGINE=InnoDB;
45
46-- -----------------------------------------------------
47-- Data for table `august`.`galaxy_shape`
48-- -----------------------------------------------------
49SET AUTOCOMMIT=0;
50INSERT INTO `galaxy_shape` (`id`, `name`, `texture`) VALUES (0, 'Elliptical', '');
51INSERT INTO `galaxy_shape` (`id`, `name`, `texture`) VALUES (1, 'Spiral', '');
52INSERT INTO `galaxy_shape` (`id`, `name`, `texture`) VALUES (2, 'Dwarf', '');
53INSERT INTO `galaxy_shape` (`id`, `name`, `texture`) VALUES (3, 'Ring', '');
54INSERT INTO `galaxy_shape` (`id`, `name`, `texture`) VALUES (4, 'Lenticular', '');
55
56COMMIT;
57
58-- -----------------------------------------------------
59-- Table `august`.`preference`
60-- -----------------------------------------------------
61DROP TABLE IF EXISTS `august`.`preference` ;
62
63CREATE TABLE IF NOT EXISTS `august`.`preference` (
64 `id` INT NOT NULL ,
65 `description` VARCHAR(80) NOT NULL ,
66 `boolean` boolean NOT NULL ,
67 `numerical` boolean NOT NULL ,
68 PRIMARY KEY (`id`) ) ENGINE=InnoDB;
69
70-- -----------------------------------------------------
71-- Table `august`.`user_pref`
72-- -----------------------------------------------------
73DROP TABLE IF EXISTS `august`.`user_pref` ;
74
75CREATE TABLE IF NOT EXISTS `august`.`user_pref` (
76 `id` INT NOT NULL ,
77 `user_id` INT NOT NULL ,
78 `preference_id` INT NOT NULL ,
79 `boolean` boolean NULL ,
80 `text` VARCHAR(90) NULL ,
81 `numerical` INT NULL ,
82 PRIMARY KEY (id) ,
83 FOREIGN KEY (user_id) REFERENCES user(id)
84 ON DELETE CASCADE,
85 FOREIGN KEY (preference_id) REFERENCES preference(id)
86 ON DELETE CASCADE) ENGINE=InnoDB;
87
88-- -----------------------------------------------------
89-- Table `august`.`object`
90-- -----------------------------------------------------
91DROP TABLE IF EXISTS `august`.`object` ;
92
93CREATE TABLE IF NOT EXISTS `august`.`object` (
94 `id` INT NOT NULL AUTO_INCREMENT ,
95 `owner` INT,
96 `birth` TIMESTAMP NOT NULL DEFAULT NOW(),
97 `death` TIMESTAMP NULL DEFAULT NULL,
98 `name` VARCHAR(128) NULL DEFAULT NULL,
99 `parent` INT NULL DEFAULT 0,
100 `x` DOUBLE NOT NULL DEFAULT 0,
101 `y` DOUBLE NOT NULL DEFAULT 0,
102 `z` DOUBLE NOT NULL DEFAULT 0,
103 `velocity_magnitude` DOUBLE NOT NULL DEFAULT 0,
104 `velocity_vector_x` DOUBLE NOT NULL DEFAULT 0,
105 `velocity_vector_y` DOUBLE NOT NULL DEFAULT 0,
106 `velocity_vector_z` DOUBLE NOT NULL DEFAULT 0,
107 `accel_magnitude` DOUBLE NOT NULL DEFAULT 0,
108 `accel_vector_x` DOUBLE NOT NULL DEFAULT 0,
109 `accel_vector_y` DOUBLE NOT NULL DEFAULT 0,
110 `accel_vector_z` DOUBLE NOT NULL DEFAULT 0,
111 PRIMARY KEY (`id`) ,
112 FOREIGN KEY (owner) REFERENCES user(id)
113 ON DELETE CASCADE
114 ,
115 FOREIGN KEY (parent) REFERENCES object(id)
116 ON DELETE CASCADE
117 ) ENGINE=InnoDB;
118
119-- -----------------------------------------------------
120-- Data for table `august`.`object`
121-- -----------------------------------------------------
122INSERT INTO `object` (`name`, `owner`, `parent`)
123 VALUES ('The Universe', 1, NULL);
124
125-- -----------------------------------------------------
126-- Table `august`.`state`
127-- -----------------------------------------------------
128DROP TABLE IF EXISTS `august`.`state` ;
129
130CREATE TABLE IF NOT EXISTS `august`.`state` (
131 `id` INT NOT NULL ,
132 `name` VARCHAR(128) NOT NULL ,
133 PRIMARY KEY (`id`)
134 ) ENGINE=InnoDB;
135
136INSERT INTO `state` (`id`, `name`)
137 VALUES (1, 'Pulsar');
138INSERT INTO `state` (`id`, `name`)
139 VALUES (2, 'Supernova');
140INSERT INTO `state` (`id`, `name`)
141 VALUES (3, 'Black Hole');
142INSERT INTO `state` (`id`, `name`)
143 VALUES (4, 'Inert');
144INSERT INTO `state` (`id`, `name`)
145 VALUES (5, 'Forming');
146
147-- -----------------------------------------------------
148-- Table `august`.`link`
149-- -----------------------------------------------------
150DROP TABLE IF EXISTS `august`.`link` ;
151
152CREATE TABLE IF NOT EXISTS `august`.`link` (
153 `id` INT NOT NULL AUTO_INCREMENT ,
154 `first` INT NOT NULL ,
155 `second` INT NOT NULL ,
156 PRIMARY KEY (`id`) ,
157 FOREIGN KEY (first) REFERENCES object(id)
158 ON DELETE CASCADE
159 ,
160 FOREIGN KEY (second) REFERENCES object(id)
161 ON DELETE CASCADE
162 ) ENGINE=InnoDB;
163
164-- -----------------------------------------------------
165-- Table `august`.`star`
166-- -----------------------------------------------------
167DROP TABLE IF EXISTS `august`.`star` ;
168
169CREATE TABLE IF NOT EXISTS `august`.`star` (
170 `id` INT NOT NULL ,
171 `mass` DOUBLE NOT NULL ,
172 `radius` DOUBLE NOT NULL ,
173 `colorR` INT NOT NULL DEFAULT 255,
174 `colorG` INT NOT NULL DEFAULT 255,
175 `colorB` INT NOT NULL DEFAULT 255,
176 `luminosity` DOUBLE NOT NULL DEFAULT 255,
177 `frequency` DOUBLE NOT NULL DEFAULT .862,
178 `state` INT NOT NULL DEFAULT 5 ,
179 PRIMARY KEY (`id`) ,
180 FOREIGN KEY (id) REFERENCES object(id)
181 ON DELETE CASCADE,
182 FOREIGN KEY (state) REFERENCES state(id)
183 ON DELETE CASCADE
184 ) ENGINE=InnoDB;
185
186USE mysql;
187GRANT ALL PRIVILEGES ON august.* TO 'august'@'localhost'
188 IDENTIFIED BY 'fsotm00n!' WITH GRANT OPTION;
189FLUSH PRIVILEGES