/*==============================================================*/
/* DBMS name:      MySQL 4.0                                    */
/* Created on:     15.11.2005 21:46:51                          */
/*==============================================================*/


drop table if exists address;

drop table if exists users;

/*==============================================================*/
/* Table: address                                               */
/*==============================================================*/
create table address
(
   id_address                     int                            not null,
   zip                            int,
   city                           varchar( 20 ),
   primary key (id_address)
)
type = InnoDB;

/*==============================================================*/
/* Table: users                                                 */
/*==============================================================*/
create table users
(
   id_user                        int                            not null,
   id_address                     int,
   primary key (id_user)
)
type = InnoDB;

/*==============================================================*/
/* Index: "Reference_1_FK"                                            */
/*==============================================================*/
create index Reference_1_FK
(
   id_address
);

alter table users add constraint FK_Reference_1 foreign key (id_address)
      references address (id_address) on delete restrict on update restrict;

 SQL-запрос:

/*==============================================================*//* Index: "Reference_1_FK" *//*==============================================================*/ CREATE INDEX Reference_1_FK(
id_address
)

Ответ MySQL: Документация