-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathreadcastly.sql
128 lines (106 loc) · 3.35 KB
/
readcastly.sql
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
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
-- ---
-- Globals
-- ---
-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- SET FOREIGN_KEY_CHECKS=0;
-- ---
-- Table 'Users'
--
-- ---
DROP TABLE IF EXISTS `Users`;
CREATE TABLE `Users` (
`id` INTEGER(11) NOT NULL AUTO_INCREMENT,
`email` VARCHAR(100) NOT NULL,
`password` VARCHAR(10) NOT NULL,
`first_name` VARCHAR(20) NOT NULL,
`last_name` VARCHAR(20) NULL,
`phone` VARCHAR(20) NOT NULL,
`voice_pref` INTEGER(1) NULL,
`avatar` VARCHAR(100) NOT NULL DEFAULT 'http://cdn.makeuseof.com/wp-content/uploads/2015/06/6_emoji.png?187d39 ',
PRIMARY KEY (`id`)
);
-- ---
-- Table 'Sources'
--
-- ---
DROP TABLE IF EXISTS `Sources`;
CREATE TABLE `Sources` (
`id` INTEGER(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(200) NOT NULL,
`homepage` VARCHAR(200) NOT NULL,
`most_read` VARCHAR(200) NULL DEFAULT NULL,
`image` VARCHAR(200) NULL DEFAULT NULL,
PRIMARY KEY (`id`)
);
-- ---
-- Table 'Articles'
--
-- ---
DROP TABLE IF EXISTS `Articles`;
CREATE TABLE `Articles` (
`id` INTEGER(11) NOT NULL AUTO_INCREMENT,
`url` VARCHAR(200) NOT NULL,
`title` VARCHAR(200) NOT NULL,
`author` VARCHAR(200) NULL,
`publication_date` DATE NULL,
`source_id` INTEGER(11) NOT NULL,
`text` TEXT NOT NULL,
`image` VARCHAR(200) NULL,
`excerpt` TEXT NULL,
`date_added` TIMESTAMP NOT NULL,
`word_count` INTEGER(11) NOT NULL,
`est_time` INTEGER(11) NULL,
`likes` INTEGER(11) NOT NULL DEFAULT 1,
`conversions` INTEGER(11) NOT NULL DEFAULT 0,
`created_by` INTEGER(11) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`source_id`) REFERENCES `Sources`(`id`),
FOREIGN KEY (`created_by`) REFERENCES `Users`(`id`)
);
-- ---
-- Table 'Articles-Users'
--
-- ---
DROP TABLE IF EXISTS `Articles-Users`;
CREATE TABLE `Articles-Users` (
`id` INTEGER(11) NOT NULL,
`article_id` INTEGER(11) NOT NULL,
`user_id` INTEGER(11) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`article_id`) REFERENCES `Articles`(`id`),
FOREIGN KEY (`user_id`) REFERENCES `Users`(`id`)
);
-- ---
-- Table 'Sources-Users'
--
-- ---
DROP TABLE IF EXISTS `Sources-Users`;
CREATE TABLE `Sources-Users` (
`id` INTEGER NOT NULL AUTO_INCREMENT,
`source_id` INTEGER(11) NOT NULL,
`user_id` INTEGER(11) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`source_id`) REFERENCES `Sources`(`id`),
FOREIGN KEY (`user_id`) REFERENCES `Users`(`id`)
);
-- ---
-- Table Properties
-- ---
-- ALTER TABLE `Articles` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ALTER TABLE `Users` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ALTER TABLE `Sources` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ALTER TABLE `Articles-Users` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ALTER TABLE `Sources-Users` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ---
-- Test Data
-- ---
-- INSERT INTO `Articles` (`id`,`url`,`title`,`author`,`publication_date`,`source_id`,`text`,`image`,`excerpt`,`date_added`,`word_count`,`est_time`,`likes`,`conversions`,`created_by`) VALUES
-- ('','','','','','','','','','','','','','','');
-- INSERT INTO `Users` (`id`,`email`,`password`,`first_name`,`last_name`,`avatar`) VALUES
-- ('','','','','','');
-- INSERT INTO `Sources` (`id`,`name`,`homepage`,`most_read`,`image`) VALUES
-- ('','','','','');
-- INSERT INTO `Articles-Users` (`id`,`article_id`,`user_id`) VALUES
-- ('','','');
-- INSERT INTO `Sources-Users` (`id`,`source_id`,`user_id`) VALUES
-- ('','','');