Mbe: Restore recent backup
@rtohoun asked for a restore of a recent GG backup to GG-CE.
Missing tables
The taxonomy_cwr
table is missing from your schema. Please add it to your copy of the database:
CREATE TABLE [dbo].[taxonomy_cwr](
[taxonomy_cwr_id] [int] IDENTITY(1,1) NOT NULL,
[taxonomy_species_id] [int] NOT NULL,
[crop_name] [nvarchar](100) NOT NULL,
[display_name] [nvarchar](100) NULL,
[crop_common_name] [nvarchar](100) NULL,
[is_crop] [nvarchar](1) NOT NULL,
[genepool_code] [nvarchar](20) NULL,
[is_graftstock_genepool] [nvarchar](1) NOT NULL,
[trait_class_code] [nvarchar](20) NULL,
[is_potential] [nvarchar](1) NOT NULL,
[breeding_type_code] [nvarchar](20) NULL,
[breeding_usage] [nvarchar](100) NULL,
[ontology_trait_identifier] [nvarchar](20) NULL,
[citation_id] [int] NULL,
[note] [nvarchar](max) NULL,
[created_date] [datetime2](7) NOT NULL,
[created_by] [int] NOT NULL,
[modified_date] [datetime2](7) NULL,
[modified_by] [int] NULL,
[owned_date] [datetime2](7) NOT NULL,
[owned_by] [int] NOT NULL,
CONSTRAINT [PK_taxonomy_cwr] PRIMARY KEY CLUSTERED
(
[taxonomy_cwr_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[taxonomy_cwr] ADD DEFAULT ('N') FOR [is_graftstock_genepool]
GO
ALTER TABLE [dbo].[taxonomy_cwr] WITH CHECK ADD CONSTRAINT [fk_tcwr_cit] FOREIGN KEY([citation_id])
REFERENCES [dbo].[citation] ([citation_id])
GO
ALTER TABLE [dbo].[taxonomy_cwr] CHECK CONSTRAINT [fk_tcwr_cit]
GO
ALTER TABLE [dbo].[taxonomy_cwr] WITH CHECK ADD CONSTRAINT [fk_tcwr_created] FOREIGN KEY([created_by])
REFERENCES [dbo].[cooperator] ([cooperator_id])
GO
ALTER TABLE [dbo].[taxonomy_cwr] CHECK CONSTRAINT [fk_tcwr_created]
GO
ALTER TABLE [dbo].[taxonomy_cwr] WITH CHECK ADD CONSTRAINT [fk_tcwr_modified] FOREIGN KEY([modified_by])
REFERENCES [dbo].[cooperator] ([cooperator_id])
GO
ALTER TABLE [dbo].[taxonomy_cwr] CHECK CONSTRAINT [fk_tcwr_modified]
GO
ALTER TABLE [dbo].[taxonomy_cwr] WITH CHECK ADD CONSTRAINT [fk_tcwr_owned] FOREIGN KEY([owned_by])
REFERENCES [dbo].[cooperator] ([cooperator_id])
GO
ALTER TABLE [dbo].[taxonomy_cwr] CHECK CONSTRAINT [fk_tcwr_owned]
GO
ALTER TABLE [dbo].[taxonomy_cwr] WITH CHECK ADD CONSTRAINT [fk_tcwr_ts] FOREIGN KEY([taxonomy_species_id])
REFERENCES [dbo].[taxonomy_species] ([taxonomy_species_id])
GO
ALTER TABLE [dbo].[taxonomy_cwr] CHECK CONSTRAINT [fk_tcwr_ts]
GO