1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
$query1 = "DROP TABLE IF EXISTS `grh`.`grh_users`;";
$query2 = "CREATE TABLE `grh`.`grh_users` (
`ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 255 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
`email` varchar( 255 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
`phone` varchar( 255 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
`phone2` varchar( 255 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
`mobile` varchar( 255 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
`realname` varchar( 255 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
`firstname` varchar( 255 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
PRIMARY KEY ( `ID` ) ,
UNIQUE KEY `name` ( `name` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =2;";
$query3 = "INSERT INTO `grh`.`grh_users`
SELECT ID,name,email,phone,phone2,mobile,realname,firstname FROM `glpi`.`glpi_users`";
$result1 = mysql_query($query1) or die(mysql_error());
$result2 = mysql_query($query2) or die(mysql_error());
$result3 = mysql_query($query3) or die(mysql_error()); |
Partager