Incorrect syntax near 'MODIFY'

Incorrect syntax near 'MODIFY'.

CREATE TABLE category (
  id int NOT NULL,
  name varchar(255) NOT NULL,
  sort_order int NOT NULL,
  status int NOT NULL DEFAULT '1',
)



CREATE TABLE product (
  id int NOT NULL,
  name varchar(255) NOT NULL,
   code  varchar(255) NOT NULL,
   brand  varchar(255) NOT NULL,
   price  float NOT NULL,
   title  varchar(255) DEFAULT NULL,
   description  text NOT NULL,
   category_id  int NOT NULL,
   sub_category_id  int NOT NULL,
   availability  int NOT NULL,
   is_featured  int NOT NULL,
   is_new  int NOT NULL,
   image  varchar(255) DEFAULT NULL,
   status  int NOT NULL DEFAULT '1'
) 


CREATE TABLE  product_order  (
   id  int NOT NULL,
   user_name  varchar(255) NOT NULL,
   user_phone  varchar(255) NOT NULL,
   user_comment  text NOT NULL,
   user_id  int DEFAULT NULL,
   date  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   products  text NOT NULL,
   status  int NOT NULL DEFAULT '1'
) 



CREATE TABLE  sub_category  (
   id  int NOT NULL,
   name  varchar(255) NOT NULL,
   sort_order  int NOT NULL,
   category_id  int NOT NULL,
   status  int NOT NULL DEFAULT '1'
)

CREATE TABLE  user  (
   id  int NOT NULL,
   first_name  varchar(55) NOT NULL,
   last_name  varchar(55) NOT NULL,
   email  varchar(255) NOT NULL,
   password  varchar(255) NOT NULL,
   birth  varchar(55) NOT NULL,
   company  varchar(255) NOT NULL,
   address  varchar(255) NOT NULL,
   city  varchar(255) NOT NULL,
   state  varchar(255) NOT NULL,
   postcode  int NOT NULL,
   country  varchar(255) NOT NULL,
   additional_info  text NOT NULL,
   phone  varchar(255) NOT NULL,
   date  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   status  int NOT NULL DEFAULT '1',
   role  varchar(255) DEFAULT NULL
) 

ALTER TABLE category
  ADD PRIMARY KEY ( id );

ALTER TABLE product 
  ADD PRIMARY KEY ( id );


ALTER TABLE  product_order 
  ADD PRIMARY KEY ( id );


ALTER TABLE  sub_category 
  ADD PRIMARY KEY ( id );


ALTER TABLE  "user" 
  ADD PRIMARY KEY ( "id" );

ALTER TABLE  "category"
  MODIFY  `id`  int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;


ALTER TABLE  "product" 
  MODIFY  `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;


ALTER TABLE  "product_order" 
  MODIFY  `id`  int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

ALTER TABLE  "sub_category" 
  MODIFY  `i`  int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;


ALTER TABLE  "user" 
  MODIFY  `id`  int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;