From 6e90e8acafe0e692253e11ee4843688547148a9d Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 3 Jun 2016 16:06:11 +0800 Subject: [PATCH] sql/Office.sql --- sql/Office.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) diff --git a/sql/Office.sql b/sql/Office.sql index e69de29b..22450413 100644 --- a/sql/Office.sql +++ b/sql/Office.sql @@ -0,0 +1,21 @@ + +CREATE TABLE Office ( + id int(11) NOT NULL auto_increment, + + PRIMARY KEY (id) +); + + +ALTER TABLE Office ADD COLUMN company_id int(11) NOT NULL default '0'; +ALTER TABLE Office ADD COLUMN name varchar(64) NOT NULL DEFAULT ''; +ALTER TABLE Office ADD COLUMN address text ; +ALTER TABLE Office ADD COLUMN address2 TEXT; +ALTER TABLE Office ADD COLUMN address3 TEXT; +ALTER TABLE Office ADD COLUMN phone varchar(32) NOT NULL DEFAULT ''; +ALTER TABLE Office ADD COLUMN fax varchar(32) NOT NULL DEFAULT ''; +ALTER TABLE Office ADD COLUMN email varchar(128) NOT NULL DEFAULT ''; +ALTER TABLE Office ADD COLUMN role varchar(32) NOT NULL DEFAULT ''; +ALTER TABLE Office ADD COLUMN country VARCHAR(4) NULL; + +ALTER TABLE Office ADD COLUMN display_name VARCHAR(4) NULL; + -- 2.39.2