deploy/resource_customizations/db.atlasgo.io/AtlasSchema/testdata/degraded.yaml

apiVersion: db.atlasgo.io/v1alpha1
kind: AtlasSchema
metadata:
  annotations:
    kubectl.kubernetes.io/last-applied-configuration: |
      {"apiVersion":"db.atlasgo.io/v1alpha1","kind":"AtlasSchema","metadata":{"annotations":{},"name":"atlasschema-mysql","namespace":"default"},"spec":{"schema":{"sql":"create table users (\n  id int not null auto_increment,\n  name varchar(255) not null,\n  email varchar(255) unique not null,\n  short_bio varchar(255) not null,\n  primary key (id)\n);\n"},"urlFrom":{"secretKeyRef":{"key":"url","name":"mysql-credentials"}}}}
  creationTimestamp: "2023-11-15T14:33:18Z"
  generation: 2
  name: atlasschema-mysql
  namespace: default
  resourceVersion: "46659"
  uid: 54a4cdfc-e4f9-4c3d-934c-e08b6122e38a
spec:
  schema:
    sql: |
      xcreate table users (
        id int not null auto_increment,
        name varchar(255) not null,
        email varchar(255) unique not null,
        short_bio varchar(255) not null,
        primary key (id)
      );
  urlFrom:
    secretKeyRef:
      key: url
      name: mysql-credentials
status:
  conditions:
    - lastTransitionTime: "2023-11-15T14:38:41Z"
      message: |-
        Error: sql/migrate: read migration directory state: sql/migrate: execute: executing statement "xcreate table users (\n  id int not null auto_increment,\n  name varchar(255) not null,\n  email varchar(255) unique not null,\n  short_bio varchar(255) not null,\n  primary key (id)\n);" from version "schema": Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xcreate table users (
          id int not null auto_increment,
          name varchar(255) not ' at line 1
      reason: ApplyingSchema
      status: "False"
      type: Ready
  last_applied: 1700058814
  observed_hash: ddfe666707ddf5c2cc7625c2a0de89da51e54fc7caa6403db307146430d20d85