ya que realice esto y tengo un archivo en xml con la información de los contactos.
base de datos
nombre = phonebook
tabla= Contact
id
FirstName
LastName
Frequent<0>
Phone type
phonenumber INT
accountindex<1>
Group<6>
Primary<0>
Company
use phonebook;
SELECT * FROM Contact;
ALTER TABLE Contact ADD COLUMN Phone type VARCHAR(100);
CREATE TABLE Contact (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName VARCHAR(20) NOT NULL, LastName VARCHAR(20) NOT NULL, phonenumber INT UNSIGNED NOT NULL UNIQUE, accountindex INT, Group INT, Primary INT, Company VARCHAR(100));
ALTER TABLE Contact ADD COLUMN (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName VARCHAR(20) NOT NULL, LastName VARCHAR(20) NOT NULL, phonenumber INT UNSIGNED NOT NULL UNIQUE, accountindex INT, Group INT, Primary INT, Company VARCHAR(100));
ALTER TABLE Contact DROP COLUMN id;
ALTER TABLE Contact ADD COLUMN (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName VARCHAR(20) NOT NULL, LastName VARCHAR(20) NOT NULL, phonenumber INT UNSIGNED NOT NULL UNIQUE, accountindex INT );
ALTER TABLE Contact ADD COLUMN Group bigint(4);
ALTER TABLE Contact ADD COLUMN Company VARCHAR(30);
ALTER TABLE Contact ADD COLUMN Primary VARCHAR(2);
ALTER TABLE Contact MODIFY COLUMN Frequent VARCHAR(100) AFTER LastName;
id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| FirstName | varchar(100) | YES | | NULL | |
| LastName | varchar(20) | NO | | NULL | |
| Frequent | varchar(100) | YES | | NULL | |
| phonenumber | int(10) unsigned | NO | UNI | NULL | |
| accountindex | int(11) | YES | | NULL | |
| Company | varchar(30) | YES | | NULL
SELECT * FROM Contact;
INSERT INTO Contact VALUES ('1', 'Angel', 'Mujica', '0', '1411', '1', '******')
