gistfile1.sql

create table SOMEPROJECT_USERS(
	ID int not null auto_increment,
	NAME varchar(32),
	primary key (ID),
	key (NAME)
);

create table SOMEPROJECT_SHARES(
	ID int not null auto_increment,
	NAME varchar(32),
	primary key (ID),
	key (NAME)
);

create table SOMEPROJECT_LINKS(
	USER_ID int not null,
	SHARE_ID int not null,
	primary key (USER_ID, SHARE_ID),
	constraint FK_LINKS_TO_USERS foreign key (USER_ID) references SOMEPROJECT_USERS(ID),
	constraint FK_LINKS_TO_SHARES foreign key (SHARE_ID) references SOMEPROJECT_SHARES(ID)
);