gVb0tpC8

1# MySQL Creation Querys
2
3# ## 
4DROP TABLE IF EXISTS `profiles`;
5CREATE TABLE `profiles` (
6	id INT NOT NULL AUTO_INCREMENT,
7	fname VARCHAR(20) NOT NULL,
8	lname VARCHAR(20) NOT NULL,
9	birthday VARCHAR(10) NOT NULL,
10	about LONGTEXT NOT NULL,
11	email VARCHAR(100) NOT NULL,
12	password VARCHAR(32) NOT NULL,
13	last_login TIMESTAMP NOT NULL,
14	PRIMARY KEY(id)
15);
16
17# ## 
18DROP TABLE IF EXISTS `portraits`;
19CREATE TABLE `portraits` (
20	id INT NOT NULL AUTO_INCREMENT,
21	profile_id INT NOT NULL,
22	thumb_url VARCHAR(255) NOT NULL,
23	full_url VARCHAR(255) NOT NULL,
24	PRIMARY KEY(id)
25);
26
27# ## 
28DROP TABLE IF EXISTS `wall_posts`;
29CREATE TABLE `wall_posts` (
30	id INT NOT NULL AUTO_INCREMENT,
31	profile_id INT NOT NULL,
32	content LONGTEXT NOT NULL,
33	date VARCHAR(10) NOT NULL,
34	time VARCHAR(5) NOT NULL,
35	PRIMARY KEY(id)
36);
37
38# ## 
39DROP TABLE IF EXISTS `friendships`;
40CREATE TABLE `friendships` (
41	id INT NOT NULL AUTO_INCREMENT,
42	from INT NOT NULL,
43	to INT NOT NULL,
44	PRIMARY KEY(id)
45);
46
47# ## 
48DROP TABLE IF EXISTS `guestbook_entries`;
49CREATE TABLE `guestbook_entrys` (
50	id INT NOT NULL AUTO_INCREMENT,
51	name VARCHAR(20) NOT NULL,
52	message LONGTEXT NOT NULL,
53	date VARCHAR(10) NOT NULL,
54	time VARCHAR(5) NOT NULL,
55	ip VARCHAR(32) NOT NULL,
56	PRIMARY KEY(id)
57);
58
59# ## 
60DROP TABLE IF EXISTS `board_topics`;
61CREATE TABLE `board_topics` (
62	id INT NOT NULL AUTO_INCREMENT,
63	profile_id INT NOT NULL,
64	caption VARCHAR(45) NOT NULL,
65	posts INT NOT NULL,
66	date VARCHAR(10) NOT NULL,
67	time VARCHAR(5) NOT NULL,
68	PRIMARY KEY(id)
69);
70
71# ## 
72DROP TABLE IF EXISTS `board_posts`;
73CREATE TABLE `board_posts` (
74	id INT NOT NULL AUTO_INCREMENT,
75	profile_id INT NOT NULL,
76	content LONGTEXT NOT NULL,
77	date VARCHAR(10) NOT NULL,
78	time VARCHAR(5) NOT NULL,
79	PRIMARY KEY(id)
80);
81
82# ## 
83DROP TABLE IF EXISTS `private_messages`;
84CREATE TABLE `private_messages` (
85	id INT NOT NULL AUTO_INCREMENT,
86	subject VARCHAR(100) NOT NULL,
87	content LONGTEXT NOT NULL,
88	read BOOLEAN NOT NULL,
89	date VARCHAR(10) NOT NULL,
90	time VARCHAR(5) NOT NULL,
91	PRIMARY KEY(id)
92);
93
94# ## 
95DROP TABLE IF EXISTS `message_authorships`;
96CREATE TABLE `message_authorships` (
97	id INT NOT NULL AUTO_INCREMENT,
98	from INT NOT NULL,
99	to INT NOT NULL,
100	message_id INT NOT NULL,
101	PRIMARY KEY(id)
102);
103
104# ## 
105DROP TABLE IF EXISTS `galleries`;
106CREATE TABLE `gallerys` (
107	id INT NOT NULL AUTO_INCREMENT,
108	name VARCHAR(100) NOT NULL,
109	desc LONGTEXT NOT NULL,
110	PRIMARY KEY(id)
111);
112
113# ## 
114DROP TABLE IF EXISTS `images`;
115CREATE TABLE `images` (
116	id INT NOT NULL AUTO_INCREMENT,
117	gallery_id INT NOT NULL,
118	thumb_url VARCHAR(255) NOT NULL,
119	full_url VARCHAR(255) NOT NULL,
120	PRIMARY KEY(id)
121);
122
123# ## 
124DROP TABLE IF EXISTS `image_comments`;
125CREATE TABLE `image_comments` (
126	id INT NOT NULL AUTO_INCREMENT,
127	profile_id INT NOT NULL,
128	content LONGTEXT NOT NULL,
129	date VARCHAR(10) NOT NULL,
130	time VARCHAR(5) NOT NULL,
131	PRIMARY KEY(id)
132);
133
134# ## 
135DROP TABLE IF EXISTS `blog_entrys`;
136CREATE TABLE `blog_entrys` (
137	id INT NOT NULL AUTO_INCREMENT,
138	subject VARCHAR(100) NOT NULL
139	content LONGTEXT(100) NOT NULL
140	date VARCHAR(10) NOT NULL,
141	time VARCHAR(5) NOT NULL,
142	PRIMARY KEY(id)
143);
144
145# ## 
146DROP TABLE IF EXISTS `blog_comments`;
147CREATE TABLE `blog_comments` (
148	id INT NOT NULL AUTO_INCREMENT,
149	profile_id INT NOT NULL,
150	name VARCHAR(45) NOT NULL,
151	content LONGTEXT(100) NOT NULL
152	date VARCHAR(10) NOT NULL,
153	time VARCHAR(5) NOT NULL,
154	ip VARCHAR(32) NOT NULL,
155	PRIMARY KEY(id)
156);