· 4 years ago · May 20, 2021, 02:22 AM
1CREATE TABLE IF NOT EXISTS `npwd_phone_contacts` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `identifier` varchar(48) DEFAULT NULL,
4 `avatar` varchar(512) DEFAULT NULL,
5 `number` varchar(12) DEFAULT NULL,
6 `display` varchar(255) NOT NULL DEFAULT '',
7 PRIMARY KEY (id)
8);
9
10CREATE TABLE IF NOT EXISTS `npwd_twitter_tweets` (
11 `id` int NOT NULL AUTO_INCREMENT,
12 `message` varchar(1000) NOT NULL,
13 `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
14 `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
15 `likes` int NOT NULL DEFAULT '0',
16 `identifier` varchar(48) NOT NULL,
17 `visible` tinyint NOT NULL DEFAULT '1',
18 `images` varchar(1000) DEFAULT '',
19 `retweet` int DEFAULT NULL,
20 PRIMARY KEY (`id`)
21);
22
23
24CREATE TABLE IF NOT EXISTS `npwd_twitter_profiles` (
25 `id` int NOT NULL AUTO_INCREMENT,
26 `profile_name` varchar(90) NOT NULL,
27 `identifier` varchar(48) NOT NULL,
28# Default Profile avatar can be set here
29 `avatar_url` varchar(255) DEFAULT 'https://beta.iodine.gg/QrEvq.png',
30 `bio` varchar(512) DEFAULT NULL,
31 `location` varchar(45) DEFAULT NULL,
32 `job` varchar(45) DEFAULT NULL,
33 `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
34 `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
35 PRIMARY KEY (`id`),
36 UNIQUE KEY `profile_name_UNIQUE` (`profile_name`)
37);
38
39CREATE TABLE IF NOT EXISTS `npwd_twitter_likes` (
40 `id` int NOT NULL AUTO_INCREMENT,
41 `profile_id` int NOT NULL,
42 `tweet_id` int NOT NULL,
43 PRIMARY KEY (`id`),
44 UNIQUE KEY `unique_combination` (`profile_id`,`tweet_id`),
45 KEY `profile_idx` (`profile_id`),
46 KEY `tweet_idx` (`tweet_id`),
47 CONSTRAINT `profile` FOREIGN KEY (`profile_id`) REFERENCES `npwd_twitter_profiles` (`id`),
48 CONSTRAINT `tweet` FOREIGN KEY (`tweet_id`) REFERENCES `npwd_twitter_tweets` (`id`) ON DELETE CASCADE
49);
50
51CREATE TABLE IF NOT EXISTS `npwd_match_profiles` (
52 `id` int NOT NULL AUTO_INCREMENT,
53 `identifier` varchar(48) NOT NULL,
54 `name` varchar(90) NOT NULL,
55 `image` varchar(255) NOT NULL,
56 `bio` varchar(512) DEFAULT NULL,
57 `location` varchar(45) DEFAULT NULL,
58 `job` varchar(45) DEFAULT NULL,
59 `tags` varchar(255) NOT NULL DEFAULT '',
60 `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
61 `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
62 PRIMARY KEY (`id`),
63 UNIQUE KEY `name_UNIQUE` (`name`),
64 UNIQUE KEY `identifier_UNIQUE` (`identifier`)
65);
66
67CREATE TABLE IF NOT EXISTS `npwd_match_views` (
68 `id` int NOT NULL AUTO_INCREMENT,
69 `identifier` varchar(48) NOT NULL,
70 `profile` int NOT NULL,
71 `liked` tinyint DEFAULT '0',
72 `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
73 `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
74 PRIMARY KEY (`id`),
75 KEY `match_profile_idx` (`profile`),
76 CONSTRAINT `match_profile` FOREIGN KEY (`profile`) REFERENCES `npwd_match_profiles` (`id`)
77);
78
79CREATE TABLE IF NOT EXISTS `npwd_notes` (
80 `id` int(11) NOT NULL AUTO_INCREMENT,
81 `identifier` varchar(48) NOT NULL,
82 `title` varchar(255) NOT NULL,
83 `content` varchar(255) NOT NULL,
84 PRIMARY KEY (id)
85);
86
87CREATE TABLE IF NOT EXISTS `npwd_marketplace_listings` (
88 `id` int(11) NOT NULL AUTO_INCREMENT,
89 `identifier` varchar(48) DEFAULT NULL,
90 `username` varchar(255) DEFAULT NULL,
91 `name` varchar(50) DEFAULT NULL,
92 `number` varchar(255) NOT NULL,
93 `title` varchar(255) DEFAULT NULL,
94 `url` varchar(255) DEFAULT NULL,
95 `description` varchar(255) NOT NULL,
96 `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
97 `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
98 PRIMARY KEY (id)
99);
100
101CREATE TABLE IF NOT EXISTS `npwd_marketplace_reports` (
102 `id` int(11) NOT NULL AUTO_INCREMENT,
103 `listing_id` int(11) DEFAULT NULL,
104 `profile` varchar(255) DEFAULT NULL,
105 PRIMARY KEY (id)
106);
107
108CREATE TABLE IF NOT EXISTS `npwd_twitter_reports` (
109 `id` int NOT NULL AUTO_INCREMENT,
110 `profile_id` int NOT NULL,
111 `tweet_id` int NOT NULL,
112 PRIMARY KEY (`id`),
113 UNIQUE KEY `unique_combination` (`profile_id`,`tweet_id`),
114 KEY `profile_idx` (`profile_id`),
115 KEY `tweet_idx` (`tweet_id`),
116 CONSTRAINT `report_profile` FOREIGN KEY (`profile_id`) REFERENCES `npwd_twitter_profiles` (`id`),
117 CONSTRAINT `report_tweet` FOREIGN KEY (`tweet_id`) REFERENCES `npwd_twitter_tweets` (`id`) ON DELETE CASCADE
118);
119
120CREATE TABLE IF NOT EXISTS `npwd_messages_groups` (
121 `id` int NOT NULL AUTO_INCREMENT,
122 `user_identifier` varchar(48) NOT NULL,
123 `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
124 `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
125 `group_id` varchar(512) NOT NULL,
126 `participant_identifier` varchar(48) NOT NULL,
127 `label` varchar(60) DEFAULT '',
128 `unreadCount` int(11) NOT NULL DEFAULT 0,
129 PRIMARY KEY (`id`)
130);
131
132CREATE TABLE IF NOT EXISTS `npwd_messages_labels` (
133 `id` int NOT NULL AUTO_INCREMENT,
134 `user_identifier` varchar(48) NOT NULL,
135 `label` varchar(60) NOT NULL,
136 `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
137 `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
138 `group_id` varchar(512) NOT NULL,
139 PRIMARY KEY (`id`)
140);
141
142CREATE TABLE IF NOT EXISTS `npwd_messages` (
143 `id` int NOT NULL AUTO_INCREMENT,
144 `message` varchar(512) NOT NULL,
145 `user_identifier` varchar(48) NOT NULL,
146 `group_id` varchar(512) NOT NULL,
147 `isRead` tinyint NOT NULL DEFAULT '0',
148 `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
149 `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
150 `visible` tinyint NOT NULL DEFAULT '1',
151 PRIMARY KEY (`id`)
152);
153
154CREATE TABLE IF NOT EXISTS `npwd_calls` (
155 `id` int(11) NOT NULL AUTO_INCREMENT,
156 `identifier` varchar(48) DEFAULT NULL,
157 `transmitter` varchar(255) NOT NULL,
158 `receiver` varchar(255) NOT NULL,
159 `is_accepted` tinyint(4) DEFAULT 0,
160 `start` varchar(255) DEFAULT NULL,
161 end varchar(255) DEFAULT NULL,
162 PRIMARY KEY (id)
163);
164
165CREATE TABLE IF NOT EXISTS npwd_phone_gallery (
166 `id` int(11) NOT NULL AUTO_INCREMENT,
167 `identifier` varchar(48) DEFAULT NULL,
168 `image` varchar(255) DEFAULT NULL,
169 PRIMARY KEY (id)
170);
171