From a5bf5c02babdfdb6c4541200f3db1c51a9aefdb9 Mon Sep 17 00:00:00 2001 From: "jiil.hyoun" Date: Thu, 6 Dec 2012 17:31:09 +0900 Subject: [PATCH] [Title] add user_id in projects table [Type] Feature [Module] Toolchain / [Priority] Minor [Jira#] [Redmine#] [Problem] [Cause] [Solution] [TestCase] Change-Id: Ib333caedc7c06588cb8fbd85e169958d2ef34dd7 --- src/build_server/CommonProject.rb | 2 ++ 1 file changed, 2 insertions(+) diff --git a/src/build_server/CommonProject.rb b/src/build_server/CommonProject.rb index efdba93..7c639b5 100644 --- a/src/build_server/CommonProject.rb +++ b/src/build_server/CommonProject.rb @@ -169,9 +169,11 @@ class CommonProject db.do "CREATE TABLE projects ( id INTEGER PRIMARY KEY #{inc}, distribution_id INTEGER NOT NULL, + user_id INTEGER, name VARCHAR(32) NOT NULL, ptype VARCHAR(32) NOT NULL, password VARCHAR(32), + CONSTRAINT fk_projects_users1 FOREIGN KEY ( user_id ) REFERENCES users ( id ), CONSTRAINT fk_projects_distributions1 FOREIGN KEY ( distribution_id ) REFERENCES distributions ( id ) )#{post_fix}" db.do "CREATE TABLE project_os ( -- 2.34.1