Mysql company

CREATE TABLE company (

Comp_code_id int (10) NOT NULL auto_increment

Org_id char (10)

Mfg_comp_code char (20)

Mfg_comp_name char (50)

Process_plant_code char (20)

Process_plant_name char (50)

Max_turnover_sum decimal (18,2)

Prod_capacity decimal (18,2)

Wh_cubage decimal (18,2)

Wh_acreage decimal (18,2)

File_id char (20)

PRIMARY KEY (`comp_code_ id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE [company] (

[comp_code_id] [int] IDENTITY (1,1) NOT NULL

[org_id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__company__comp_co__68D28DBC] DEFAULT (')

[mfg_comp_code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__company__mfg_com__69C6B1F5] DEFAULT (')

[mfg_comp_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__company__mfg_com__6ABAD62E] DEFAULT (')

[process_plant_code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__company__process__6BAEFA67] DEFAULT (')

[process_plant_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__company__process__6CA31EA0] DEFAULT (')

[max_turnover_sum] [numeric] (18,6) NOT NULL CONSTRAINT [DF__company__max_tur__6D9742D9] DEFAULT (0)

[prod_capacity] [numeric] (18,6) NOT NULL CONSTRAINT [DF__company__prod_ca__6E8B6712] DEFAULT (0)

[wh_cubage] [numeric] (18,6) NOT NULL CONSTRAINT [DF__company__wh_cuba__6F7F8B4B] DEFAULT (0)

[wh_acreage] [numeric] (18,6) NOT NULL CONSTRAINT [DF__company__wh_acre__7073AF84] DEFAULT (0)

[file_id] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_company_file_id] DEFAULT (')

CONSTRAINT [PK_company_comp_code_id] PRIMARY KEY CLUSTERED

(

[comp_code_id]

) ON [PRIMARY]

) ON [PRIMARY]

GO

[@ more@]