Codice PHP:
CREATE TABLE IF NOT EXISTS `Old_Table_Users` (
`user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`username` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`displayname` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`photo_id` int(11) unsigned NOT NULL DEFAULT '0',
`status` text COLLATE utf8_unicode_ci,
`status_date` datetime DEFAULT NULL,
`password` char(32) COLLATE utf8_unicode_ci NOT NULL,
`salt` char(64) COLLATE utf8_unicode_ci NOT NULL,
`locale` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'auto',
`language` varchar(8) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'en_US',
`timezone` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'America/Los_Angeles',
`search` tinyint(1) NOT NULL DEFAULT '1',
`show_profileviewers` tinyint(1) NOT NULL DEFAULT '1',
`level_id` int(11) unsigned NOT NULL,
`invites_used` int(11) unsigned NOT NULL DEFAULT '0',
`extra_invites` int(11) unsigned NOT NULL DEFAULT '0',
`enabled` tinyint(1) NOT NULL DEFAULT '1',
`verified` tinyint(1) NOT NULL DEFAULT '0',
`approved` tinyint(1) NOT NULL DEFAULT '1',
`creation_date` datetime NOT NULL,
`creation_ip` varbinary(16) NOT NULL,
`modified_date` datetime NOT NULL,
`lastlogin_date` datetime DEFAULT NULL,
`lastlogin_ip` varbinary(16) DEFAULT NULL,
`update_date` int(11) DEFAULT NULL,
`member_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`view_count` int(11) unsigned NOT NULL DEFAULT '0',
`cover_id` int(11) unsigned DEFAULT NULL,
`cover_top` int(11) DEFAULT '0',
`rating` int(11) NOT NULL DEFAULT '0',
`like_count` int(11) NOT NULL DEFAULT '0',
`review_count` int(11) NOT NULL DEFAULT '0',
`member_of_day` tinyint(1) DEFAULT '0',
`note` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`user_id`),
UNIQUE KEY `EMAIL` (`email`),
UNIQUE KEY `USERNAME` (`username`),
KEY `MEMBER_COUNT` (`member_count`),
KEY `CREATION_DATE` (`creation_date`),
KEY `search` (`search`),
KEY `enabled` (`enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7734 ;
Codice PHP:
CREATE TABLE IF NOT EXISTS `New_Table_Users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(32) NOT NULL DEFAULT '',
`email` varchar(255) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`first_name` varchar(32) NOT NULL DEFAULT '',
`last_name` varchar(32) NOT NULL DEFAULT '',
`avatar` varchar(100) NOT NULL DEFAULT 'upload/photos/d-avatar.jpg',
`cover` varchar(100) NOT NULL DEFAULT 'upload/photos/d-cover.jpg',
`background_image` varchar(100) NOT NULL DEFAULT '',
`background_image_status` enum('0','1') NOT NULL DEFAULT '0',
`relationship_id` int(11) NOT NULL DEFAULT '0',
`address` varchar(100) NOT NULL DEFAULT '',
`working` varchar(32) NOT NULL DEFAULT '',
`working_link` varchar(32) NOT NULL DEFAULT '',
`about` text,
`school` varchar(32) NOT NULL DEFAULT '',
`gender` varchar(32) NOT NULL DEFAULT 'male',
`birthday` date NOT NULL DEFAULT '0000-00-00',
`country_id` int(11) NOT NULL DEFAULT '0',
`website` varchar(50) NOT NULL DEFAULT '',
`facebook` varchar(50) NOT NULL DEFAULT '',
`google` varchar(50) NOT NULL DEFAULT '',
`twitter` varchar(50) NOT NULL DEFAULT '',
`linkedin` varchar(32) NOT NULL DEFAULT '',
`youtube` varchar(100) NOT NULL DEFAULT '',
`vk` varchar(32) NOT NULL DEFAULT '',
`instagram` varchar(32) NOT NULL DEFAULT '',
`language` varchar(31) NOT NULL DEFAULT 'english',
`email_code` varchar(32) NOT NULL DEFAULT '',
`src` varchar(32) NOT NULL DEFAULT 'Undefined',
`ip_address` varchar(32) DEFAULT '',
`follow_privacy` enum('1','0') NOT NULL DEFAULT '0',
`post_privacy` varchar(255) NOT NULL DEFAULT 'ifollow',
`message_privacy` enum('1','0') NOT NULL DEFAULT '0',
`confirm_followers` enum('1','0') NOT NULL DEFAULT '0',
`show_activities_privacy` enum('0','1') NOT NULL DEFAULT '1',
`birth_privacy` enum('0','1','2') NOT NULL DEFAULT '0',
`visit_privacy` enum('0','1') NOT NULL DEFAULT '0',
`verified` enum('1','0') NOT NULL DEFAULT '0',
`lastseen` int(32) NOT NULL DEFAULT '0',
`showlastseen` enum('1','0') NOT NULL DEFAULT '1',
`emailNotification` enum('1','0') NOT NULL DEFAULT '1',
`e_liked` enum('0','1') NOT NULL DEFAULT '1',
`e_wondered` enum('0','1') NOT NULL DEFAULT '1',
`e_shared` enum('0','1') NOT NULL DEFAULT '1',
`e_followed` enum('0','1') NOT NULL DEFAULT '1',
`e_commented` enum('0','1') NOT NULL DEFAULT '1',
`e_visited` enum('0','1') NOT NULL DEFAULT '1',
`e_liked_page` enum('0','1') NOT NULL DEFAULT '1',
`e_mentioned` enum('0','1') NOT NULL DEFAULT '1',
`e_joined_group` enum('0','1') NOT NULL DEFAULT '1',
`e_accepted` enum('0','1') NOT NULL DEFAULT '1',
`e_profile_wall_post` enum('0','1') NOT NULL DEFAULT '1',
`status` enum('1','0') NOT NULL DEFAULT '0',
`active` enum('0','1','2') NOT NULL DEFAULT '0',
`admin` enum('0','1','2') NOT NULL DEFAULT '0',
`type` varchar(11) NOT NULL DEFAULT 'user',
`registered` varchar(32) NOT NULL DEFAULT '0/0000',
`start_up` enum('0','1') NOT NULL DEFAULT '0',
`start_up_info` enum('0','1') NOT NULL DEFAULT '0',
`startup_follow` enum('0','1') NOT NULL DEFAULT '0',
`startup_image` enum('0','1') NOT NULL DEFAULT '0',
`last_email_sent` int(32) NOT NULL DEFAULT '0',
`phone_number` varchar(32) NOT NULL DEFAULT '',
`sms_code` int(11) NOT NULL DEFAULT '0',
`is_pro` enum('0','1') NOT NULL DEFAULT '0',
`pro_time` int(11) NOT NULL DEFAULT '0',
`pro_type` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
`joined` int(11) NOT NULL DEFAULT '0',
`css_file` varchar(100) NOT NULL DEFAULT '',
`timezone` varchar(50) NOT NULL DEFAULT '',
`referrer` int(11) NOT NULL DEFAULT '0',
`balance` varchar(100) NOT NULL DEFAULT '0',
`paypal_email` varchar(100) NOT NULL DEFAULT '',
`notifications_sound` enum('0','1') NOT NULL DEFAULT '0',
`order_posts_by` enum('0','1') NOT NULL DEFAULT '1',
PRIMARY KEY (`user_id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`),
KEY `active` (`active`),
KEY `admin` (`admin`),
KEY `src` (`src`),
KEY `gender` (`gender`),
KEY `avatar` (`avatar`),
KEY `first_name` (`first_name`),
KEY `last_name` (`last_name`),
KEY `registered` (`registered`),
KEY `joined` (`joined`),
KEY `phone_number` (`phone_number`) USING BTREE,
KEY `referrer` (`referrer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;
mi sapete aiutare a importare dalla prima tabella gli utenti ma secondo i campi della seconda?
Rispondi quotando