i5m3aAmR

1
2# Add Comments
3
4#
5DROP TABLE IF EXISTS `phinguin_profiles`;
6CREATE TABLE `phinguin_profiles` (
7  id INT NOT NULL auto_increment,
8  is_team BOOLEAN NOT NULL,
9  in_team BOOLEAN NOT NULL,
10  team_id INT NOT NULL,
11  name VARCHAR(20) NOT NULL,
12  mail VARCHAR(50) NOT NULL,
13  password VARCHAR(50) NOT NULL,
14  activation_key VARCHAR(50) NOT NULL,
15  activated BOOLEAN NOT NULL,
16  active BOOLEAN NOT NULL,
17  location VARCHAR(50) NULL,
18  website VARCHAR(255) NULL,
19  about LONGTEXT NULL,
20  primary key (id)
21);
22
23#
24DROP TABLE IF EXISTS `phinguin_portraits`;
25CREATE TABLE `phinguin_portraits` (
26  id INT NOT NULL auto_increment,
27  profile_id INT NOT NULL,
28  path VARCHAR(255) NOT NULL,
29  label TINYTEXT NULL,
30  primary key (id)
31);
32
33#
34DROP TABLE IF EXISTS `phinguin_contacts`;
35CREATE TABLE `phinguin_contacts` (
36  id INT NOT NULL auto_increment,
37  profile_id INT NOT NULL,
38  contact_id INT NOT NULL,
39  is_friend BOOLEAN NOT NULL,
40  primary key (id)
41);
42
43#
44DROP TABLE IF EXISTS `phinguin_user_groups`;
45CREATE TABLE `phinguin_user_groups` (
46  id INT NOT NULL auto_increment,
47  name VARCHAR(20) NOT NULL,
48  description TINYTEXT NULL,
49  level INT NOT NULL,
50  primary key (id)
51);
52
53#
54DROP TABLE IF EXISTS `phinguin_terms`;
55CREATE TABLE `phinguin_terms` (
56  id INT NOT NULL auto_increment,
57  label VARCHAR(255) NOT NULL,
58  content LONGTEXT NOT NULL,
59  primary key (id)
60);
61
62#
63DROP TABLE IF EXISTS `phinguin_privacy_policies`;
64CREATE TABLE `phinguin_privacy_policies` (
65  id INT NOT NULL auto_increment,
66  label VARCHAR(255) NOT NULL,
67  content LONGTEXT NOT NULL,
68  primary key (id)
69);
70
71#
72DROP TABLE IF EXISTS `phinguin_blackboard_entries`;
73CREATE TABLE `phinguin_blackboard_entries` (
74  id INT NOT NULL auto_increment,
75  profile_id INT NOT NULL,
76  author_id INT NOT NULL,
77  message MEDIUMTEXT NOT NULL,
78  primary key (id)
79);
80
81#
82DROP TABLE IF EXISTS `phinguin_lists`;
83CREATE TABLE `phinguin_lists` (
84  id INT NOT NULL auto_increment,
85  profile_id INT NOT NULL,
86  belongs_to_group BOOLEAN NOT NULL,
87  group_id INT NOT NULL,
88  label VARCHAR(50) NOT NULL,
89  description TINYTEXT NULL,
90  primary key (id)
91);
92
93#
94DROP TABLE IF EXISTS `phinguin_groups`;
95CREATE TABLE `phinguin_groups` (
96  id INT NOT NULL auto_increment,
97  profile_id INT NOT NULL,
98  label VARCHAR(50) NOT NULL,
99  description TINYTEXT NULL,
100  primary key (id)
101);
102
103#
104DROP TABLE IF EXISTS `phinguin_list_permissions`;
105CREATE TABLE `phinguin_list_permissions` (
106  id INT NOT NULL auto_increment,
107  list_id INT NOT NULL,
108  user_group INT NOT NULL,
109  has_access BOOLEAN NOT NULL,
110  primary key (id)
111);
112
113#
114DROP TABLE IF EXISTS `phinguin_group_permissions`;
115CREATE TABLE `phinguin_group_permissions` (
116  id INT NOT NULL auto_increment,
117  group_id INT NOT NULL,
118  user_group INT NOT NULL,
119  has_access BOOLEAN NOT NULL,
120  primary key (id)
121);
122
123#
124DROP TABLE IF EXISTS `phinguin_messages`;
125CREATE TABLE `phinguin_messages` (
126  id INT NOT NULL auto_increment,
127  subject VARCHAR(100) NULL,
128  message LONGTEXT NOT NULL,
129  primary key (id)
130);
131
132#
133DROP TABLE IF EXISTS `phinguin_message_authorships`;
134CREATE TABLE `phinguin_message_authorships` (
135  id INT NOT NULL auto_increment,
136  message_id INT NOT NULL,
137  profile_id INT NOT NULL,
138  recipient_id INT NOT NULL,
139  primary key (id)
140);
141
142#
143DROP TABLE IF EXISTS `phinguin_team_invitations`;
144CREATE TABLE `phinguin_team_invitations` (
145  id INT NOT NULL auto_increment,
146  profile_id INT NOT NULL,
147  recipient_id INT NOT NULL,
148  message TINYTEXT NULL,
149  primary key (id)
150);
151
152#
153DROP TABLE IF EXISTS `phinguin_ignores`;
154CREATE TABLE `phinguin_ignores` (
155  id INT NOT NULL auto_increment,
156  banned BOOLEAN NOT NULL,
157  profile_id INT NOT NULL,
158  recipient_id INT NOT NULL,
159  reason TINYTEXT NULL,
160  primary key (id)
161);
162
163#
164DROP TABLE IF EXISTS `phinguin_blog_entries`;
165CREATE TABLE `phinguin_blog_entries` (
166  id INT NOT NULL auto_increment,
167  title VARCHAR(50) NOT NULL,
168  subtitle VARCHAR(50) NULL,
169  message LONGTEXT NOT NULL,
170  primary key (id)
171);
172
173#
174DROP TABLE IF EXISTS `phinguin_blog_comments`;
175CREATE TABLE `phinguin_blog_comments` (
176  id INT NOT NULL auto_increment,
177  entry_id INT NOT NULL,
178  author_id INT NOT NULL,
179  message MEDIUMTEXT NOT NULL,
180  primary key (id)
181);
182
183#
184DROP TABLE IF EXISTS `phinguin_tags`;
185CREATE TABLE `phinguin_tags` (
186  id INT NOT NULL auto_increment,
187  content VARCHAR(20) NOT NULL,
188  primary key (id)
189);
190
191#
192DROP TABLE IF EXISTS `phinguin_list_tags`;
193CREATE TABLE `phinguin_list_tags` (
194  id INT NOT NULL auto_increment,
195  list_id INT NOT NULL,
196  tag_id INT NOT NULL,
197  clicks INT NOT NULL,
198  primary key (id)
199);
200
201#
202DROP TABLE IF EXISTS `phinguin_group_tags`;
203CREATE TABLE `phinguin_group_tags` (
204  id INT NOT NULL auto_increment,
205  goup_id INT NOT NULL,
206  tag_id INT NOT NULL,
207  clicks INT NOT NULL,
208  primary key (id)
209);
210
211#
212DROP TABLE IF EXISTS `phinguin_items`;
213CREATE TABLE `phinguin_items` (
214  id INT NOT NULL auto_increment,
215  list_id INT NOT NULL,
216  parent_id INT NOT NULL,
217  content VARCHAR(50) NOT NULL,
218  primary key (id)
219);
220
221# 
222DROP TABLE IF EXISTS `phinguin_reminders`;
223CREATE TABLE `phinguin_reminders` (
224  id INT NOT NULL auto_increment,
225  item_id INT NOT NULL,
226  day INT NOT NULL,
227  month INT NOT NULL,
228  year INT NOT NULL,
229  hour INT NOT NULL,
230  minute INT NOT NULL,
231  primary key (id)
232);