adiUkvcm

1CREATE TABLE IF NOT EXISTS tabla_pk 
2(
3    col_idx1               INT NOT NULL,
4    col_idx2               INT NOT NULL,
5    col_int                INT NOT NULL,
6    col_varchar            VARCHAR(100),  
7    CONSTRAINT tabla_pk_PK01 PRIMARY KEY (col_idx1,col_idx2)
8)ENGINE=INNODB;
9	
10CREATE TABLE IF NOT EXISTS tabla_unique 
11(
12    col_idx1               INT NOT NULL,
13    col_idx2               INT NOT NULL,
14    col_int                INT NOT NULL,
15    col_varchar            VARCHAR(100),  
16    CONSTRAINT tabla_unique_AK01 UNIQUE (col_idx1,col_idx2)
17)ENGINE=INNODB;