zhangheng0027 commented on issue #30405:
URL:
https://github.com/apache/shardingsphere/issues/30405#issuecomment-1982182044
init sql
```sql
CREATE TABLE equipment_oee (
serial_no bigint NOT NULL,
equipment_id nvarchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL,
statistics_cycle nvarchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL,
statistics_time nvarchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL,
oee_ratio float DEFAULT NULL NULL,
availability float DEFAULT NULL NULL,
effectiveness_performance float DEFAULT NULL NULL,
quality_ratio float DEFAULT NULL NULL,
actual_production_time bigint DEFAULT NULL NULL,
plan_occupancy_time bigint DEFAULT NULL NULL,
beat_time float DEFAULT NULL NULL,
produced_quantity int DEFAULT NULL NULL,
good_quantity int DEFAULT NULL NULL,
CONSTRAINT PK_equipment_oee_serial_no PRIMARY KEY (serial_no)
);
```
conf
```yaml
dataSources:
master:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbcUrl: jdbc:sqlserver://localhost:1433;DatabaseName=oee;encrypt=false;
username: sa
password: Aa123456
props:
sql-show: true
rules:
- !SINGLE
tables:
- master.*
defaultDataSource: master
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
