· 8 years ago · Mar 03, 2018, 01:20 AM
1ALTER TABLE users ADD basic_admin VARCHAR(255) NOT NULL;
2ALTER TABLE users ADD user_rating double NOT NULL;
3ALTER TABLE `users` ADD `visit` int(10) unsigned NOT NULL DEFAULT '0';
4ALTER TABLE users ADD marital VARCHAR(255) NOT NULL;
5ALTER TABLE users ADD education VARCHAR(255) NOT NULL;
6ALTER TABLE users ADD myfav VARCHAR(255) NOT NULL;
7ALTER TABLE users ADD religion VARCHAR(255) NOT NULL;
8ALTER TABLE users ADD country VARCHAR(255) NOT NULL;
9ALTER TABLE users ADD state VARCHAR(255) NOT NULL;
10ALTER TABLE users ADD life VARCHAR(255) NOT NULL;
11ALTER TABLE users ADD mytell VARCHAR(255) NOT NULL;
12ALTER TABLE users ADD myemail VARCHAR(255) NOT NULL;
13ALTER TABLE users ADD myphone VARCHAR(255) NOT NULL;
14ALTER TABLE users ADD mycar VARCHAR(255) NOT NULL;
15ALTER TABLE users ADD policy_ism VARCHAR(255) NOT NULL;
16ALTER TABLE users ADD smok VARCHAR(255) NOT NULL;
17ALTER TABLE users ADD military VARCHAR(255) NOT NULL;
18ALTER TABLE users ADD scale VARCHAR(255) NOT NULL;
19ALTER TABLE users ADD size VARCHAR(255) NOT NULL;
20ALTER TABLE users ADD occupation VARCHAR(255) NOT NULL;
21ALTER TABLE users ADD interests VARCHAR(255) NOT NULL;
22ALTER TABLE users ADD shout VARCHAR(255) NOT NULL;
23ALTER TABLE users ADD status VARCHAR(255) NOT NULL DEFAULT '0';
24ALTER TABLE users ADD note VARCHAR(255) NOT NULL;
25ALTER TABLE `users` ADD `donate` TINYINT( 1 ) NOT NULL DEFAULT '0';
26ALTER TABLE `users` ADD `ip` VARCHAR( 255 ) NOT NULL AFTER `is_network_admin`;
27ALTER TABLE `users` ADD `viewprivacy` ENUM( 'Public', 'Private' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default 'Public' ;
28ALTER TABLE `users` ADD `frndlist_privacy` ENUM( 'Public', 'Private' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default 'Public' ;
29ALTER TABLE `users` ADD `online_privacy` ENUM( 'Public', 'Private' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default 'Public' ;
30ALTER TABLE `users` ADD `birthdate_shown` ENUM( 'Public', 'Private' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default 'Public' ;
31ALTER TABLE `users` ADD `comet_shown` ENUM( 'Public', 'Private' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL default 'Public' ;
32ALTER TABLE `users` ADD `mob_hidden` TINYINT( 1 ) NOT NULL DEFAULT '0';
33ALTER TABLE `users` ADD `no_play` TINYINT( 1 ) NOT NULL DEFAULT '0';
34ALTER TABLE `users` ADD `mobile` VARCHAR( 6 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ;
35ALTER TABLE `users` ADD `numobile` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ;
36ALTER TABLE `users` ADD `camobile` INT( 11 ) NOT NULL ;
37ALTER TABLE `users` ADD `my_poke` ENUM( 'Public', 'Private' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ;
38ALTER TABLE users ADD myeyes VARCHAR(255) NOT NULL;
39ALTER TABLE `users` ADD `db_cm_shown` TINYINT( 1 ) NOT NULL DEFAULT '0' ;
40ALTER TABLE `users` ADD `prv_search` TINYINT( 1 ) NOT NULL;
41ALTER TABLE `users` ADD `db_tab_shown` TINYINT( 1 ) NOT NULL;
42
43ALTER TABLE users_details ADD prof_donbaler VARCHAR(255) NOT NULL;
44ALTER TABLE users_details ADD prof_avat VARCHAR(255) NOT NULL;
45
46ALTER TABLE `groups` ADD `term` VARCHAR( 255 ) NOT NULL AFTER `about_me` ;
47ALTER TABLE `groups` ADD `active` INT( 10 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `num_followers` ;
48
49ALTER TABLE `posts` ADD `dis_comment` SMALLINT( 5 ) NOT NULL ;
50ALTER TABLE `posts` ADD `feedback` SMALLINT( 10 ) NOT NULL NOT NULL default '0' ;
51ALTER TABLE `posts` ADD `peruse` SMALLINT( 10 ) NOT NULL NOT NULL default '0' ;
52ALTER TABLE `posts` ADD `status` SMALLINT( 10 ) NOT NULL ;
53
54ALTER TABLE settings ADD MAINTENANCE VARCHAR(255) NOT NULL;
55ALTER TABLE `applications` ADD `fa_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ;
56
57
58CREATE TABLE `password` (
59 `pass` varchar(32) collate utf8_persian_ci NOT NULL
60) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;
61INSERT INTO `password` (`pass`) VALUES ('e10adc3949ba59abbe56e057f20f883e');
62 UPDATE `riznameh_amir2011tes`.`password` SET `pass` = MD5( 'e10adc3949ba59abbe56e057f20f883e' ) WHERE `password`.`pass` = 'e10adc3949ba59abbe56e057f20f883e' LIMIT 1 ;
63
64CREATE TABLE `cometchat` (
65 `id` int(10) unsigned NOT NULL auto_increment,
66 `from` varchar(255) NOT NULL,
67 `to` varchar(255) NOT NULL,
68 `message` text NOT NULL,
69 `sent` int(10) unsigned NOT NULL,
70 `read` int(10) unsigned NOT NULL,
71 `direction` int(10) unsigned NOT NULL default '0',
72 PRIMARY KEY (`id`),
73 KEY `to` (`to`),
74 KEY `from` (`from`),
75 KEY `direction` (`direction`),
76 KEY `read` (`read`),
77 KEY `sent` (`sent`)
78) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
79
80CREATE TABLE `cometchat_chatroommessages` (
81 `id` int(10) unsigned NOT NULL auto_increment,
82 `userid` int(10) unsigned NOT NULL,
83 `chatroomid` int(10) unsigned NOT NULL,
84 `message` text NOT NULL,
85 `sent` int(10) unsigned NOT NULL,
86 PRIMARY KEY (`id`),
87 KEY `userid` (`userid`),
88 KEY `chatroomid` (`chatroomid`),
89 KEY `sent` (`sent`)
90) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
91
92CREATE TABLE `cometchat_chatrooms` (
93 `id` int(10) unsigned NOT NULL auto_increment,
94 `name` varchar(255) NOT NULL,
95 `lastactivity` int(10) unsigned NOT NULL,
96 `createdby` int(10) unsigned NOT NULL,
97 PRIMARY KEY (`id`),
98 KEY `lastactivity` (`lastactivity`),
99 KEY `createdby` (`createdby`)
100) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
101
102CREATE TABLE `cometchat_chatrooms_users` (
103 `userid` int(10) unsigned NOT NULL,
104 `chatroomid` int(10) unsigned NOT NULL,
105 `lastactivity` int(10) unsigned NOT NULL,
106 PRIMARY KEY (`userid`),
107 KEY `chatroomid` (`chatroomid`),
108 KEY `lastactivity` (`lastactivity`)
109) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
110
111CREATE TABLE `cometchat_status` (
112 `userid` int(10) unsigned NOT NULL,
113 `message` text NOT NULL,
114 `status` varchar(10) NOT NULL,
115 PRIMARY KEY (`userid`)
116) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
117
118DROP TABLE IF EXISTS `cometchat_videochatsessions`;
119CREATE TABLE `cometchat_videochatsessions` (
120 `username` varchar(255) NOT NULL,
121 `identity` varchar(255) NOT NULL,
122 PRIMARY KEY (`username`),
123 KEY `username` (`username`)
124) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
125
126CREATE TABLE `forum_question` (
127 `id` int(4) NOT NULL auto_increment,
128 `topic` varchar(255) NOT NULL default '',
129 `detail` longtext NOT NULL,
130 `name` varchar(65) NOT NULL default '',
131 `email` varchar(65) NOT NULL default '',
132 `datetime` varchar(25) NOT NULL default '',
133 `view` int(4) NOT NULL default '0',
134 `reply` int(4) NOT NULL default '0',
135 PRIMARY KEY (`id`)
136) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
137
138CREATE TABLE `forum_answer` (
139 `question_id` int(4) NOT NULL default '0',
140 `a_id` int(4) NOT NULL default '0',
141 `a_name` varchar(65) NOT NULL default '',
142 `a_email` varchar(65) NOT NULL default '',
143 `a_answer` longtext NOT NULL,
144 `a_datetime` varchar(25) NOT NULL default '',
145 EY `a_id` (`a_id`)
146) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
147
148CREATE TABLE `pokes` (
149 `id` int(10) unsigned NOT NULL auto_increment,
150 `who` varchar(200) character set utf8 collate utf8_unicode_ci NOT NULL,
151 `whom` varchar(200) character set utf8 collate utf8_unicode_ci NOT NULL,
152 `sdate` int(10) unsigned NOT NULL,
153 `whoid` int(10) unsigned NOT NULL,
154 `see` int(10) unsigned NOT NULL,
155 PRIMARY KEY (`id`)
156) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;
157
158RENAME TABLE `cometchat` to `cometchat_messages_old`;
159DROP TABLE IF EXISTS `cometchat`;
160CREATE TABLE `cometchat` (
161 `id` int(10) unsigned NOT NULL auto_increment,
162 `from` int(10) unsigned NOT NULL,
163 `to` int(10) unsigned NOT NULL,
164 `message` text NOT NULL,
165 `sent` int(10) unsigned NOT NULL default '0',
166 `read` tinyint(1) unsigned NOT NULL default '0',
167 `direction` tinyint(1) unsigned NOT NULL default '0',
168 PRIMARY KEY (`id`),
169 KEY `to` (`to`),
170 KEY `from` (`from`),
171 KEY `direction` (`direction`),
172 KEY `read` (`read`),
173 KEY `sent` (`sent`)
174) ENGINE=InnoDB DEFAULT CHARSET=utf8;
175
176DROP TABLE IF EXISTS `cometchat_announcements`;
177CREATE TABLE `cometchat_announcements` (
178 `id` int(10) unsigned NOT NULL auto_increment,
179 `announcement` text NOT NULL,
180 `time` int(10) unsigned NOT NULL,
181 `to` int(10) signed NOT NULL,
182 PRIMARY KEY (`id`),
183 KEY `to` (`to`),
184 KEY `time` (`time`)
185) ENGINE=InnoDB DEFAULT CHARSET=utf8;
186
187DROP TABLE IF EXISTS `cometchat_chatroommessages`;
188CREATE TABLE `cometchat_chatroommessages` (
189 `id` int(10) unsigned NOT NULL auto_increment,
190 `userid` int(10) unsigned NOT NULL,
191 `chatroomid` int(10) unsigned NOT NULL,
192 `message` text NOT NULL,
193 `sent` int(10) unsigned NOT NULL,
194 PRIMARY KEY (`id`),
195 KEY `userid` (`userid`),
196 KEY `chatroomid` (`chatroomid`),
197 KEY `sent` (`sent`)
198) ENGINE=InnoDB DEFAULT CHARSET=utf8;
199
200DROP TABLE IF EXISTS `cometchat_chatrooms`;
201CREATE TABLE `cometchat_chatrooms` (
202 `id` int(10) unsigned NOT NULL auto_increment,
203 `name` varchar(255) NOT NULL,
204 `lastactivity` int(10) unsigned NOT NULL,
205 `createdby` int(10) unsigned NOT NULL,
206 `password` varchar(255) NOT NULL,
207 `type` tinyint(1) unsigned NOT NULL,
208 PRIMARY KEY (`id`),
209 KEY `lastactivity` (`lastactivity`),
210 KEY `createdby` (`createdby`),
211 KEY `type` (`type`)
212) ENGINE=InnoDB DEFAULT CHARSET=utf8;
213
214DROP TABLE IF EXISTS `cometchat_chatrooms_users`;
215CREATE TABLE `cometchat_chatrooms_users` (
216 `userid` int(10) unsigned NOT NULL,
217 `chatroomid` int(10) unsigned NOT NULL,
218 `lastactivity` int(10) unsigned NOT NULL,
219 PRIMARY KEY (`userid`),
220 KEY `chatroomid` (`chatroomid`),
221 KEY `lastactivity` (`lastactivity`)
222) ENGINE=InnoDB DEFAULT CHARSET=utf8;
223
224DROP TABLE IF EXISTS `cometchat_status`;
225CREATE TABLE `cometchat_status` (
226 `userid` int(10) unsigned NOT NULL,
227 `message` text,
228 `status` enum('available','away','busy','invisible','offline') default NULL,
229 `typingto` int(10) unsigned default NULL,
230 `typingtime` int(10) unsigned default NULL,
231 PRIMARY KEY (`userid`),
232 KEY `typingto` (`typingto`),
233 KEY `typingtime` (`typingtime`)
234) ENGINE=InnoDB DEFAULT CHARSET=utf8;
235
236DROP TABLE IF EXISTS `cometchat_videochatsessions`;
237CREATE TABLE `cometchat_videochatsessions` (
238 `username` varchar(255) NOT NULL,
239 `identity` varchar(255) NOT NULL,
240 `timestamp` int(10) unsigned default 0,
241 PRIMARY KEY (`username`),
242 KEY `username` (`username`),
243 KEY `identity` (`identity`),
244 KEY `timestamp` (`timestamp`)
245) ENGINE=InnoDB DEFAULT CHARSET=utf8;
246
247CREATE TABLE `users_theme` (
248 `user_id` int(10) unsigned NOT NULL,
249 `user_bg_color` varchar(6) collate utf8_persian_ci NOT NULL,
250 `user_bg_image` varchar(100) collate utf8_persian_ci NOT NULL,
251 `user_bg_repeat` varchar(9) collate utf8_persian_ci NOT NULL,
252 `user_bg_attachment` varchar(6) collate utf8_persian_ci NOT NULL,
253 `user_bg_position` varchar(13) collate utf8_persian_ci NOT NULL,
254 `user_bg_fontcolor` varchar(6) collate utf8_persian_ci NOT NULL,
255 `user_bg_afontcolor` varchar(6) collate utf8_persian_ci NOT NULL,
256 `user_bg_menucolor` varchar(6) collate utf8_persian_ci NOT NULL,
257 `user_bg_fmenucolor` varchar(6) collate utf8_persian_ci NOT NULL,
258 `user_version` int(10) unsigned NOT NULL,
259 `user_hash` varchar(32) collate utf8_persian_ci NOT NULL,
260 `user_bg_enable` tinyint(1) unsigned NOT NULL,
261 PRIMARY KEY (`user_id`)
262) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;
263
264CREATE TABLE `users_advertise` (
265`user_id` int( 10 ) unsigned NOT NULL ,
266`user_ads_image` varchar( 255 ) COLLATE utf8_persian_ci NOT NULL ,
267`user_ads_url` varchar( 255 ) COLLATE utf8_persian_ci NOT NULL ,
268`user_ads_alt` varchar( 255 ) COLLATE utf8_persian_ci NOT NULL ,
269`user_ads_pay` varchar( 255 ) COLLATE utf8_persian_ci NOT NULL ,
270`user_ads_des` varchar( 255 ) COLLATE utf8_persian_ci NOT NULL ,
271`user_ads_hash` varchar(32) collate utf8_persian_ci NOT NULL,
272`user_ads_enable` tinyint(1) unsigned NOT NULL,
273`user_ads_version` int(10) unsigned NOT NULL,
274PRIMARY KEY ( `user_id` )
275) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_persian_ci;
276
277CREATE TABLE IF NOT EXISTS `admin_polls` (
278 `poll_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
279 `poll_question` varchar(300) COLLATE utf8_persian_ci NOT NULL,
280 `poll_answers` text COLLATE utf8_persian_ci NOT NULL,
281 `poll_enabled` tinyint(1) unsigned NOT NULL,
282 PRIMARY KEY (`poll_id`)
283) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=5 ;
284
285CREATE TABLE IF NOT EXISTS `admin_polls_answers` (
286 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
287 `poll_id` int(10) unsigned NOT NULL,
288 `user_id` int(10) unsigned NOT NULL,
289 `answer_id` tinyint(3) unsigned NOT NULL,
290 PRIMARY KEY (`id`)
291) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=443 ;
292
293ALTER TABLE `users` ADD `gmap` VARCHAR( 255 ) NOT NULL ;
294
295CREATE TABLE IF NOT EXISTS `users_theme` (
296 `user_id` int(10) unsigned NOT NULL,
297 `user_bg_color` varchar(6) COLLATE utf8_persian_ci NOT NULL DEFAULT 'c0deed',
298 `user_bg_image` varchar(100) COLLATE utf8_persian_ci NOT NULL,
299 `user_bg_mp3` varchar(255) COLLATE utf8_persian_ci NOT NULL,
300 `user_bg_repeat` varchar(9) COLLATE utf8_persian_ci NOT NULL DEFAULT 'repeat-x',
301 `user_bg_attachment` varchar(6) COLLATE utf8_persian_ci NOT NULL DEFAULT 'fixed',
302 `user_bg_position` varchar(13) COLLATE utf8_persian_ci NOT NULL DEFAULT 'left top',
303 `user_hash` varchar(32) COLLATE utf8_persian_ci NOT NULL,
304 `user_bg_enable` tinyint(1) unsigned NOT NULL DEFAULT '0',
305 `user_version` int(10) unsigned NOT NULL,
306 `user_bg_fontcolor` varchar(6) COLLATE utf8_persian_ci NOT NULL DEFAULT '000',
307 `user_bg_afontcolor` varchar(6) COLLATE utf8_persian_ci NOT NULL DEFAULT '1975e1',
308 `user_bg_fmenucolor` varchar(6) COLLATE utf8_persian_ci NOT NULL DEFAULT '1975e1',
309 `user_bg_menucolor` varchar(6) COLLATE utf8_persian_ci NOT NULL DEFAULT 'eee',
310 PRIMARY KEY (`user_id`)
311) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;
312
313CREATE TABLE IF NOT EXISTS `users_bannerads` (
314 `ads_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
315 `ads_uid` mediumint(8) unsigned NOT NULL,
316 `ads_title` varchar(100) COLLATE utf8_persian_ci NOT NULL,
317 `ads_url` varchar(150) COLLATE utf8_persian_ci NOT NULL,
318 `ads_image` varchar(50) COLLATE utf8_persian_ci NOT NULL,
319 `ads_expire` int(10) unsigned NOT NULL,
320 `ads_description` tinytext COLLATE utf8_persian_ci NOT NULL,
321 `ads_status` tinyint(1) unsigned NOT NULL,
322 PRIMARY KEY (`ads_id`)
323) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=1 ;