2022
...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
| create table `salesforce`.`dbAccount` \\ \\ ( `AccountID` varchar(100) NOT NULL , \\ `AccountName` text NOT NULL , \\ `BillingStreet` text , \\ `BillingPostalCode` numeric(20) , \\ `AnnualRevenue` decimal(30,2) , \\ `CreatedDate` date , \\ `LastModifiedDate` datetime , \\ `NumberOfOfficeLocations` int , \\ PRIMARY KEY (`AccountID`) \\ ); \\ \\ create table `salesforce`.`dbaccountnew` \\ (`AccountID` varchar (100) NOT NULL, \\ `AccountName` varchar (300) NOT NULL, \\ `BillingAddress` varchar (500), \\ `AnnualRevenue` Decimal (50,2), \\ `CreatedDate` datetime , \\ `LastModifiedDate` datetime , \\ `NumberOfOfficeLocations` int, \\ PRIMARY KEY (`AccountID`) \\ ); | |
...