[交友会员]麦群网整站程序 (081122终结版)_myqun081122(phpizabi).rar

CREATE TABLE IF NOT EXISTS `##PREFIX##video` ( `id` int(11) NOT NULL auto_increment, `videoid` varchar(250) NOT NULL default '', `date` int(64) NOT NULL default '0', `category` varchar(250) NOT NULL default '', `title` varchar(250) NOT NULL default '', `description` longtext NOT NULL, `user` int(10) NOT NULL default '0', `username` varchar(250) NOT NULL default '', `rating` longtext NOT NULL, `rating_hits` int(10) NOT NULL default '0', `rating_avg` int(10) NOT NULL default '0', `views` int(10) NOT NULL default '0', `processed` tinyint(1) NOT NULL default '0', UNIQUE KEY `id` (`id`), FULLTEXT KEY `title` (`title`,`description`)) TYPE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `##PREFIX##newsfeed` ( `id` int(13) NOT NULL auto_increment, `user` int(13) NOT NULL default '0', `username` varchar(255) NOT NULL default 'Nobody', `date` int(32) NOT NULL default '0', `text` longtext NOT NULL, `type` varchar(255) NOT NULL default '', `friendUsername` varchar(255) NOT NULL default '', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `##PREFIX##news` ( `id` int(10) unsigned NOT NULL auto_increment, `title` longtext NOT NULL, `body` longtext NOT NULL, `date` int(32) NOT NULL default '0', `allowuser` varchar(7) default '0', `allowguest` varchar(7) default '0', PRIMARY KEY (`id`)) TYPE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `##PREFIX##confess` ( `id` int(11) NOT NULL auto_increment, `date` int(32) NOT NULL default '0', `body` longtext NOT NULL, `user` int(32) NOT NULL default '0', UNIQUE KEY `id` (`id`)) TYPE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `##PREFIX##blogs` (`id` int(11) NOT NULL auto_increment, `user` int(10) NOT NULL default '0', `date` int(32) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `body` longtext NOT NULL, `views` int(10) NOT NULL default '0', `comments` int(10) NOT NULL default '0', UNIQUE KEY `id` (`id`), FULLTEXT KEY `title` (`title`,`body`)) TYPE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `##PREFIX##comments` ( `id` int(11) NOT NULL auto_increment, `user` int(10) NOT NULL default '0', `date` int(32) NOT NULL default '0', `parent` int(10) NOT NULL default '0', `relative` varchar(64) NOT NULL default '0', `polarity` char(1) NOT NULL default '', `type` varchar(100) NOT NULL default '', `title` varchar(250) NOT NULL default '', `body` longtext NOT NULL, UNIQUE KEY `id` (`id`)) TYPE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `##PREFIX##events` ( `id` int(11) NOT NULL auto_increment, `user` int(32) NOT NULL default '0', `active` int(1) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `location` varchar(250) NOT NULL default '', `body` longtext NOT NULL, `date` int(32) NOT NULL default '0', `set_date` int(32) NOT NULL default '0', `display` varchar(250) NOT NULL default '', `mainpicture` varchar(250) NOT NULL default '', UNIQUE KEY `id` (`id`), FULLTEXT KEY `title` (`title`,`location`,`body`)) TYPE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `##PREFIX##help` ( `id` int(11) NOT NULL auto_increment, `origin` varchar(250) NOT NULL default '', `title` varchar(250) NOT NULL default '', `body` longtext NOT NULL, `username` varchar(250) NOT NULL default '', UNIQUE KEY `id` (`id`), FULLTEXT KEY `origin` (`origin`,`title`,`body`)) TYPE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `##PREFIX##inkspot` ( `id` int(11) NOT NULL auto_increment, `subject` int(32) NOT NULL default '0', `topic` varchar(250) NOT NULL default '', `user` int(10) NOT NULL default '0', `origin` tinyint(1) NOT NULL default '0', `origin_user` int(10) NOT NULL default '0', `body` longtext NOT NULL, `locked` tinyint(1) NOT NULL default '0', `date` int(64) NOT NULL default '0', `view_count` int(32) NOT NULL default '0', `read_array` longtext NOT NULL, UNIQUE KEY `id` (`id`), FULLTEXT KEY `topic` (`topic`,`body`)) TYPE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `##PREFIX##messages` ( `id` int(11) NOT NULL auto_increment, `to` int(5) NOT NULL default '0', `from` int(5) NOT NULL default '0', `attachment` varchar(250) NOT NULL default '', `subject` varchar(250) NOT NULL default '', `body` longtext NOT NULL, `box` varchar(100) NOT NULL default '', `date` int(64) NOT NULL default '0', `read` int(1) NOT NULL default '0', `sent_copy` int(1) NOT NULL default '0', UNIQUE KEY `id` (`id`), KEY `TO READ` (`to`,`read`)) TYPE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `##PREFIX##users` ( `id` int(11) NOT NULL auto_increment, `token` varchar(64) NOT NULL default '', `last_load` int(32) NOT NULL default '0', `act_history` longtext NOT NULL, `ip` varchar(20) default NULL, `last_login` int(32) NOT NULL default '0', `turename` varchar(64) NOT NULL default '', `username` varchar(32) NOT NULL default '', `password` varchar(64) NOT NULL default '', `email` varchar(100) NOT NULL default '', `email_verified` tinyint(1) NOT NULL default '0', `xian` varchar(64) NOT NULL default '', `city` varchar(64) NOT NULL default '', `state` varchar(64) NOT NULL default '', `livexian` varchar(64) NOT NULL default '', `livecity` varchar(64) NOT NULL default '', `livestate` varchar(64) NOT NULL default '', `country` varchar(64) NOT NULL default '', `zipcode` varchar(32) NOT NULL default '', `tel` varchar(50) NOT NULL default '', `mobile` varchar(50) NOT NULL default '', `skype` varchar(32) NOT NULL default '', `qq` varchar(50) NOT NULL default '', `msn` varchar(100) NOT NULL default '', `latitude` float NOT NULL default '0', `longitude` float NOT NULL default '0', `timezone` varchar(32) NOT NULL default '', `birthdate` varchar(32) NOT NULL default '', `astrologic_sign` varchar(32) NOT NULL default '', `horoscope` longtext NOT NULL, `horoscope_date` int(64) NOT NULL default '0', `age` int(3) NOT NULL default '0', `gender` varchar(32) NOT NULL default '', `language` varchar(100) NOT NULL default '', `use_theme` varchar(250) NOT NULL default '', `description` longtext NOT NULL, `quote` varchar(250) NOT NULL default '', `header` longtext NOT NULL, `notepad_body` longtext NOT NULL, `profile_data` longtext NOT NULL, `ta_edu` varchar(64) NOT NULL default '', `ta_marry` varchar(64) NOT NULL default '', `ta_children` varchar(64) NOT NULL default '', `ta_children2` varchar(64) NOT NULL default '', `ta_pic` varchar(64) NOT NULL default '', `ta_drink` varchar(64) NOT NULL default '', `ta_smoke` varchar(64) NOT NULL default '', `ta_high` varchar(64) NOT NULL default '', `ta_weight` varchar(64) NOT NULL default '', `ta_body` varchar(64) NOT NULL default '', `ta_salary` varchar(64) NOT NULL default '', `ta_house` varchar(64) NOT NULL default '', `mailboxes` longtext NOT NULL, `pictures` longtext NOT NULL, `mainpicture` varchar(100) NOT NULL default '', `contacts` longtext NOT NULL, `relationship_requests` longtext NOT NULL, `block` longtext NOT NULL, `profile_views` longtext NOT NULL, `profile_votes` longtext NOT NULL, `pictures_votes` longtext NOT NULL, `favorites` longtext NOT NULL, `nudges` longtext NOT NULL, `settings` longtext NOT NULL, `spam_reports` longtext NOT NULL, `abuse_reports` longtext NOT NULL, `account_type` int(32) NOT NULL default '0', `account_expire` int(64) NOT NULL default '0', `registration_date` int(64) NOT NULL default '0', `registration_reference` varchar(250) NOT NULL default '', `active` tinyint(1) NOT NULL default '0', `disable_until` int(64) NOT NULL default '0', `is_moderator` tinyint(1) NOT NULL default '0', `is_administrator` tinyint(1) NOT NULL default '0', `is_superadministrator` tinyint(1) NOT NULL default '0', UNIQUE KEY `id` (`id`), FULLTEXT KEY `username` (`username`,`city`,`state`,`country`,`zipcode`,`gender`,`quote`,`header`,`profile_data`)) TYPE=MyISAM AUTO_INCREMENT=1 ; INSERT INTO `##PREFIX##help` (`id`, `origin`, `title`, `body`, `username`) VALUES (1, 'chat.chatroom', 'Chat Commands', 'The