/*
----------------------------------------------------------------
 This script shows how to alter the schema of a table. 
 In this example, a primary key CustomerId is added into 
 	table Customers. This value of this collumn is
	managed by mySQL.
 Notes: the value of a primary key (e.g., CustomerId) is unique
 	in the table.
----------------------------------------------------------------	
*/

/* alter table Customers by adding a auto-incremented column */
ALTER TABLE Customers 
	ADD CustomerId INTEGER NOT NULL AUTO_INCREMENT,
	ADD PRIMARY KEY (CustomerId);