Differential D8344 Diff 19854 resources/sql/patches/000.project.sql

Changeset View

Standalone View


create table {$NAMESPACE}_project.project (		create table {$NAMESPACE}_project.project (
id int unsigned not null auto_increment primary key,		id int unsigned not null auto_increment primary key,
name varchar(255) not null,		name varchar(255) not null,
unique key (name),		unique key (name),
phid varchar(64) binary not null,		phid varchar(64) binary not null,
authorPHID varchar(64) binary not null,		authorPHID varchar(64) binary not null,
dateCreated int unsigned not null,		dateCreated int unsigned not null,
dateModified int unsigned not null		dateModified int unsigned not null
Show All 13 Lines	create table {$NAMESPACE}_project.project_affiliation (
userPHID varchar(64) binary not null,		userPHID varchar(64) binary not null,
unique key (projectPHID, userPHID),		unique key (projectPHID, userPHID),
key (userPHID),		key (userPHID),
role varchar(255) not null,		role varchar(255) not null,
status varchar(32) not null,		status varchar(32) not null,
dateCreated int unsigned not null,		dateCreated int unsigned not null,
dateModified int unsigned not null		dateModified int unsigned not null
);		);