Ошибка тут:
Result: near "BETWEEN": syntax erro
CONSTRAINT LearningYears CHECK(BETWEEN 1 AND 6),CONSTRAINT LearningYears CHECK(LearningYears >= 1 AND LearningYears <=6),Execution finished with errors.
Result: near "FOREIGN": syntax error
At line 1:
CREATE TABLE Groups(
ID_Group IDENTITY PRIMARY KEY,
GroupName CHAR(8) NOT NULL UNIQUE,
Year BYTE NOT NULL DEFAULT 1
CONSTRAINT LearningYears CHECK(LearningYears >= 1 AND LearningYears <=6),
Department INT FOREIGNCREATE TABLE Groups(
ID_Group IDENTITY PRIMARY KEY,
GroupName CHAR(8) NOT NULL UNIQUE,
Year BYTE NOT NULL DEFAULT 1,
Department INT FOREIGN KEY REFERENCES Departmets(ID_Dep)
ON DELETE NO ACTION
ON UPDATE CASCADE),
Monitor INT NOT NULL FOREIGN KEY
REFERENCES Students(ID_Stud)
ON DELETE SET NULL
ON UPDATE CASCADE);Execution finished with errors.
Result: near "FOREIGN": syntax error
At line 1:
CREATE TABLE Groups(
ID_Group IDENTITY PRIMARY KEY,
GroupName CHAR(8) NOT NULL UNIQUE,
Year BYTE NOT NULL DEFAULT 1,
Department INT FOREIGНужно полистать конфигурацию вашего sshd сервере на винде и посмотреть где он считает должны быть публичные ключи пользователя
<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:app="http://schemas.android.com/apk/res-auto"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:visibility="visible"
tools:context=".MainActivity">
<TextView
android:id="@+id/helloText"
android:layout_width="0dp"
android:layout_height="wrap_content"
android:text="@string/helloWorld"
android:textColor="@color/purple_700"
android:textSize="40sp"
android:visibility="invisible"
app:layout_constraintBottom_toBottomOf="parent"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintHorizontal_bias="0.5"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toBottomOf="@+id/startButton"
app:layout_constraintVertical_bias="0.796" />
<ImageButton
android:id="@+id/startButton"
style="@style/Base.Widget.AppCompat.Button.Borderless.Colored"
android:layout_width="0dp"
android:layout_height="wrap_content"
android:layout_marginEnd="76dp"
android:contentDescription="@string/helloWorld"
android:onClick="onStartButtonClick"
android:visibility="visible"
app:layout_constraintBottom_toBottomOf="parent"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintHorizontal_bias="1.0"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent"
app:srcCompat="@drawable/button"
tools:srcCompat="@drawable/button" />
</androidx.constraintlayout.widget.ConstraintLayout>