Fix varchar

HonaWeb SQL

CREATE TABLE LOAI_TRAI_CAY
(
  Ma_Loai_Trai_Cay VARCHAR(10) NOT NULL,
  Ten_Loai_Trai_Cay NVARCHAR(500) NOT NULL,
  Is_Deleted INT NOT NULL,
  PRIMARY KEY (Ma_Loai_Trai_Cay)
);

CREATE TABLE ADMIN
(
  Auto_ID VARCHAR(10) NOT NULL,
  Ten_Dang_Nhap NVARCHAR(500) NOT NULL,
  Mat_Khau NVARCHAR(500) NOT NULL,
  PRIMARY KEY (Auto_ID)
);

CREATE TABLE LOG_THANH_TOAN
(
  Auto_ID VARCHAR(10) NOT NULL,
  Thoi_Gian DATE NOT NULL,
  Tong_Tien INT NOT NULL,
  Ma_Don_Hang VARCHAR(10) NOT NULL,
  PRIMARY KEY (Auto_ID)
);

CREATE TABLE LOG_NHAP_TC
(
  Auto_ID VARCHAR(10) NOT NULL,
  Ma_Trai_Cay VARCHAR(10) NOT NULL,
  Thoi_Gian DATE NOT NULL,
  Tong_Tien INT NOT NULL,
  So_Luong_Nhap INT NOT NULL,
  PRIMARY KEY (Auto_ID)
);

CREATE TABLE TRAI_CAY
(
  Ma_Trai_Cay NVARCHAR(10) NOT NULL,
  Ten_Trai_Cay NVARCHAR(500) NOT NULL,
  So_Luong INT NOT NULL,
  Don_Gia INT NOT NULL,
  Don_Vi_Tinh NVARCHAR(500) NOT NULL,
  Xuat_Xu NVARCHAR(500),
  Mo_Ta NVARCHAR(max),
  Url_Anh NVARCHAR(max),
  Count INT NOT NULL,
  Is_Deleted INT NOT NULL,
  Loai_ID VARCHAR(10) NOT NULL,
  PRIMARY KEY (Ma_Trai_Cay),
  FOREIGN KEY (Loai_ID) REFERENCES LOAI_TRAI_CAY(Ma_Loai_Trai_Cay)
);

CREATE TABLE DON_HANG
(
  Ma_Don_Hang VARCHAR(10) NOT NULL,
  Ma_Chi_Tiet_DH VARCHAR(10) NOT NULL,
  Ngay_Dat DATE NOT NULL,
  Hinh_Thuc_Thanh_Toan INT NOT NULL,
  Bang_Chung_Thanh_Toan NVARCHAR(max),
  Tinh_Trang INT NOT NULL,
  PRIMARY KEY (Ma_Don_Hang),
);

CREATE TABLE CHI_TIET_DON_HANG
(
  Ma_Chi_Tiet_DH VARCHAR(10) NOT NULL,
  So_Luong_Xuat INT NOT NULL,
  Don_Gia_Xuat INT NOT NULL,
  Ma_Don_Hang VARCHAR(10) NOT NULL,
  Ma_Trai_Cay NVARCHAR(10) NOT NULL,
  PRIMARY KEY (Ma_Chi_Tiet_DH),
  FOREIGN KEY (Ma_Don_Hang) REFERENCES DON_HANG(Ma_Don_Hang),
  FOREIGN KEY (Ma_Trai_Cay) REFERENCES TRAI_CAY(Ma_Trai_Cay)
);

CREATE TABLE CHI_TIET_CHUYEN_HANG
(
  Ma_Chi_Tiet_CH VARCHAR(10) NOT NULL,
  Ho_Ten NVARCHAR(500) NOT NULL,
  So_Dien_Thoai NVARCHAR(20) NOT NULL,
  Dia_Chi_Nhan NVARCHAR(500) NOT NULL,
  Ma_Don_Hang VARCHAR(10) NOT NULL,
  PRIMARY KEY (Ma_Chi_Tiet_CH),
  FOREIGN KEY (Ma_Don_Hang) REFERENCES DON_HANG(Ma_Don_Hang)
);

insert into LOAI_TRAI_CAY (Ma_Loai_Trai_Cay, Ten_Loai_Trai_Cay, Is_Deleted) values ('LTC01', N'Miền Bắc',0);
insert into LOAI_TRAI_CAY (Ma_Loai_Trai_Cay, Ten_Loai_Trai_Cay, Is_Deleted) values ('LTC02', N'Miền Trung',0);
insert into LOAI_TRAI_CAY (Ma_Loai_Trai_Cay, Ten_Loai_Trai_Cay, Is_Deleted) values ('LTC03', N'Miền Nam',0);
insert into LOAI_TRAI_CAY (Ma_Loai_Trai_Cay, Ten_Loai_Trai_Cay, Is_Deleted) values ('LTC04', N'Nhập Khẩu',0);

insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC001', N'Boysenberry', 89, 420000, 'LTC04', 'kg', N'Không có', N'Colombia', 'https://www.randomlists.com/img/fruits/boysenberry.jpg', 500, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC002', N'Orange', 400, 70000, 'LTC04', 'kg', N'Không có', N'United States', 'https://www.randomlists.com/img/fruits/orange.jpg', 229, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC003', N'Pineapple', 20, 50000, 'LTC01', 'kg', N'Không có', N'Hà nội', 'https://www.randomlists.com/img/fruits/pineapple.jpg', 68, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC004', N'Tomato', 100, 27000, 'LTC03', 'kg', N'Không có', N'Đà lạt', 'https://www.randomlists.com/img/fruits/tomato.jpg', 606, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC005', N'Coconut', 20, 20000, 'LTC03', 'Kg', N'Không có', N'Long an', 'https://www.randomlists.com/img/fruits/coconut.jpg', 80, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC006', N'Banana', 39, 29000, 'LTC01', 'Kg', N'Không có', N'Hà nam', 'https://www.randomlists.com/img/fruits/banana.jpg', 19, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC007', N'Watermelon', 69, 17000, 'LTC03', 'Kg', N'Không có', N'Tiền giang', 'https://www.randomlists.com/img/fruits/watermelon.jpg', 640, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC008', N'Start Fruit', 40, 15000, 'LTC03', 'Kg', N'Không có', N'Long an', 'https://www.randomlists.com/img/fruits/star_fruit.jpg', 102, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC009', N'Lemon', 21, 473374, 'LTC03', 'Kg', N'Không có', N'Long an', 'https://www.randomlists.com/img/fruits/lemon.jpg', 75, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC010', N'Blueberry', 81, 100000, 'LTC04', 'Kg', N'Không có', N'United States', 'https://www.randomlists.com/img/fruits/blueberry.jpg', 98, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC011', N'Apple', 32, 35000, 'LTC02', 'Kg', N'Không có', N'Lâm đồng', 'https://www.randomlists.com/img/fruits/apple.jpg', 96, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC012', N'Blueberry', 130, 90000, 'LTC02', 'Kg', N'Không có', N'Đắc Lắc', 'https://www.randomlists.com/img/fruits/blueberry.jpg',62, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC013', N'Peach', 40, 76000, 'LTC01', 'Kg', N'Không có', N'Hà nội', 'https://www.randomlists.com/img/fruits/peach.jpg', 320, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC014', N'Peach', 80, 92000, 'LTC04', 'Kg', N'Không có', N'United States', 'https://www.randomlists.com/img/fruits/peach.jpg', 435, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC015', N'Peach', 120, 62000, 'LTC04', 'Kg', N'Không có', N'France', 'https://www.randomlists.com/img/fruits/peach.jpg', 234, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC016', N'Orange', 79, 16000, 'LTC03', 'Kg', N'Không có', N'Đồng tháp', 'https://www.randomlists.com/img/fruits/orange.jpg', 35, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC017', N'Kiwi', 38, 64000, 'LTC03', 'Kg', N'Không có', N'An giang', 'https://www.randomlists.com/img/fruits/kiwi.jpg', 92, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC018', N'Avocado', 50, 40000, 'LTC04', 'g', N'Không có', N'Portugal', 'https://www.randomlists.com/img/fruits/avocado.jpg', 45, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC019', N'Blackberry', 66, 56000, 'LTC04', 'Kg', N'Không có', N'Philippines', 'https://www.randomlists.com/img/fruits/blackberry.jpg', 10, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC020', N'Pomegranate', 69, 34000, 'LTC01', 'Kg', N'Không có', N'Điện biên', 'https://www.randomlists.com/img/fruits/pomegranate.jpg', 85, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC021', 'Dannie', 16, 291278, 'LTC04', 'g', 'Pail For Lid 1537', 'United States', 'http://dummyimage.com/250x250.png/ff4444/ffffff', 68, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC022', 'Shari', 20, 231457, 'LTC01', 'Kg', 'Bread - Italian Corn Meal Poly', 'Vietnam', 'http://dummyimage.com/250x250.png/dddddd/000000', 62, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC023', 'Avrit', 51, 325020, 'LTC02', 'g', 'Muffins - Assorted', 'Indonesia', 'http://dummyimage.com/250x250.png/cc0000/ffffff', 92, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC024', 'Isabelita', 87, 78811, 'LTC01', 'Kg', 'Beef - Prime Rib Aaa', 'France', 'http://dummyimage.com/250x250.png/dddddd/000000', 99, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC025', 'Cristie', 21, 79075, 'LTC04', 'Kg', 'Wine La Vielle Ferme Cote Du', 'Indonesia', 'http://dummyimage.com/250x250.png/5fa2dd/ffffff', 30, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC026', 'Peggie', 39, 352808, 'LTC01', 'Kg', 'Shopper Bag - S - 4', 'China', 'http://dummyimage.com/250x250.png/dddddd/000000', 55, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC027', 'Zara', 30, 373001, 'LTC03', 'g', 'Liquid Aminios Acid - Braggs', 'China', 'http://dummyimage.com/250x250.png/dddddd/000000', 100, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC028', 'Eadie', 25, 408189, 'LTC03', 'g', 'Sobe - Liz Blizz', 'Poland', 'http://dummyimage.com/250x250.png/dddddd/000000', 54, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC029', 'Christean', 70, 218932, 'LTC02', 'Kg', 'Cheese - Mozzarella', 'Philippines', 'http://dummyimage.com/250x250.png/cc0000/ffffff', 24, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC030', 'Cassaundra', 21, 356394, 'LTC02', 'g', 'Soup Campbells', 'Philippines', 'http://dummyimage.com/250x250.png/dddddd/000000', 61, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC031', 'Emmalynn', 86, 213829, 'LTC04', 'g', 'Cheese - Bocconcini', 'Zambia', 'http://dummyimage.com/250x250.png/cc0000/ffffff', 76, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC032', 'Taffy', 11, 341952, 'LTC04', 'g', 'Wine - Red, Marechal Foch', 'Indonesia', 'http://dummyimage.com/250x250.png/5fa2dd/ffffff', 54, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC033', 'Casie', 86, 440475, 'LTC01', 'g', 'Wine - Barossa Valley Estate', 'Sweden', 'http://dummyimage.com/250x250.png/ff4444/ffffff', 21, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC034', 'Marcella', 22, 325565, 'LTC03', 'Kg', 'Ecolab - Power Fusion', 'Canada', 'http://dummyimage.com/250x250.png/dddddd/000000', 66, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC035', 'Alexandra', 96, 27071, 'LTC01', 'g', 'Veal - Inside Round / Top, Lean', 'Thailand', 'http://dummyimage.com/250x250.png/5fa2dd/ffffff', 41, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC036', 'Kyla', 88, 450954, 'LTC01', 'g', 'Muffin Carrot - Individual', 'China', 'http://dummyimage.com/250x250.png/5fa2dd/ffffff', 99, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC037', 'Emelita', 92, 447655, 'LTC02', 'Kg', 'Onions - Green', 'Indonesia', 'http://dummyimage.com/250x250.png/ff4444/ffffff', 42, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC038', 'Aile', 90, 489872, 'LTC04', 'g', 'Cup - Paper 10oz 92959', 'China', 'http://dummyimage.com/250x250.png/5fa2dd/ffffff', 2, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC039', 'Halimeda', 10, 35258, 'LTC04', 'g', 'Food Colouring - Red', 'France', 'http://dummyimage.com/250x250.png/cc0000/ffffff', 4, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC040', 'Elora', 26, 183447, 'LTC04', 'Kg', 'Anchovy In Oil', 'China', 'http://dummyimage.com/250x250.png/dddddd/000000', 38, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC041', 'Genna', 67, 210950, 'LTC04', 'g', 'Pails With Lids', 'Portugal', 'http://dummyimage.com/250x250.png/5fa2dd/ffffff', 42, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC042', 'Ki', 58, 383817, 'LTC02', 'g', 'Shrimp - Black Tiger 13/15', 'China', 'http://dummyimage.com/250x250.png/cc0000/ffffff', 61, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC043', 'Blanche', 53, 463889, 'LTC03', 'g', 'Cheese Cloth', 'China', 'http://dummyimage.com/250x250.png/cc0000/ffffff', 49, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC044', 'Melisande', 77, 479530, 'LTC04', 'Kg', 'Soup Campbells Beef With Veg', 'Mexico', 'http://dummyimage.com/250x250.png/ff4444/ffffff', 58, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC045', 'Viv', 79, 328384, 'LTC04', 'Kg', 'Shichimi Togarashi Peppeers', 'Russia', 'http://dummyimage.com/250x250.png/dddddd/000000', 46, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC046', 'Yelena', 67, 128352, 'LTC03', 'Kg', 'Watercress', 'Russia', 'http://dummyimage.com/250x250.png/dddddd/000000', 48, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC047', 'Alla', 55, 298156, 'LTC01', 'g', 'Pears - Fiorelle', 'Russia', 'http://dummyimage.com/250x250.png/5fa2dd/ffffff', 4, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC048', 'Janella', 41, 83678, 'LTC01', 'g', 'V8 - Tropical Blend', 'China', 'http://dummyimage.com/250x250.png/ff4444/ffffff', 31, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC049', 'Patti', 56, 227190, 'LTC02', 'Kg', 'Sprite - 355 Ml', 'Indonesia', 'http://dummyimage.com/250x250.png/5fa2dd/ffffff', 68, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC050', 'Philomena', 100, 161366, 'LTC02', 'g', 'Pork Casing', 'Philippines', 'http://dummyimage.com/250x250.png/ff4444/ffffff', 23, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC051', 'Cinda', 72, 324852, 'LTC04', 'Kg', 'Garlic - Elephant', 'Malta', 'http://dummyimage.com/250x250.png/cc0000/ffffff', 86, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC052', 'Jasmine', 32, 135149, 'LTC04', 'Kg', 'Wine - Ruffino Chianti', 'Thailand', 'http://dummyimage.com/250x250.png/5fa2dd/ffffff', 95, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC053', 'Carol', 17, 123643, 'LTC04', 'g', 'Juice - Propel Sport', 'Russia', 'http://dummyimage.com/250x250.png/dddddd/000000', 50, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC054', 'Joelly', 58, 249379, 'LTC01', 'g', 'Nut - Walnut, Chopped', 'Greece', 'http://dummyimage.com/250x250.png/dddddd/000000', 87, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC055', 'Angelita', 31, 37577, 'LTC02', 'Kg', 'Cheese - Comte', 'China', 'http://dummyimage.com/250x250.png/5fa2dd/ffffff', 36, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC056', 'Prissie', 49, 65255, 'LTC02', 'Kg', 'Lettuce - Frisee', 'Sweden', 'http://dummyimage.com/250x250.png/dddddd/000000', 61, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC057', 'Lotte', 62, 145538, 'LTC03', 'Kg', 'Wine - Magnotta, White', 'Sweden', 'http://dummyimage.com/250x250.png/ff4444/ffffff', 27, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC058', 'Kendra', 44, 253476, 'LTC02', 'Kg', 'Ecolab - Orange Frc, Cleaner', 'Slovenia', 'http://dummyimage.com/250x250.png/dddddd/000000', 62, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC059', 'Eachelle', 86, 306016, 'LTC04', 'g', 'Table Cloth 81x81 Colour', 'Russia', 'http://dummyimage.com/250x250.png/cc0000/ffffff', 30, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC060', 'Thia', 21, 324420, 'LTC04', 'g', 'Maple Syrup', 'Indonesia', 'http://dummyimage.com/250x250.png/dddddd/000000', 34, 0);
insert into TRAI_CAY (Ma_Trai_Cay, Ten_Trai_Cay, So_Luong, Don_Gia, Loai_ID, Don_Vi_Tinh, Mo_Ta, Xuat_Xu, Url_Anh, Count, Is_Deleted) values ('TC061', 'Starr', 86, 453935, 'LTC01', 'g', 'Quinoa', 'Russia', 'http://dummyimage.com/250x250.png/ff4444/ffffff', 28, 0); 


insert into dbo.DON_HANG(Ma_Don_Hang,Ma_Chi_Tiet_DH,Ngay_Dat,Hinh_Thuc_Thanh_Toan,Tinh_Trang)
values('DH001','CTDH001','05/20/2019','1','0');
insert into dbo.DON_HANG(Ma_Don_Hang,Ma_Chi_Tiet_DH,Ngay_Dat,Hinh_Thuc_Thanh_Toan,Tinh_Trang)
values('DH002','CTDH002','05/20/2019','0','0');
insert into dbo.DON_HANG(Ma_Don_Hang,Ma_Chi_Tiet_DH,Ngay_Dat,Hinh_Thuc_Thanh_Toan,Tinh_Trang)
values('DH003','CTDH003','05/20/2019','1','0');
insert into dbo.DON_HANG(Ma_Don_Hang,Ma_Chi_Tiet_DH,Ngay_Dat,Hinh_Thuc_Thanh_Toan,Tinh_Trang)
values('DH004','CTDH004','05/20/2019','1','0');
insert into dbo.DON_HANG(Ma_Don_Hang,Ma_Chi_Tiet_DH,Ngay_Dat,Hinh_Thuc_Thanh_Toan,Tinh_Trang)
values('DH005','CTDH005','05/20/2019','0','0');
insert into dbo.DON_HANG(Ma_Don_Hang,Ma_Chi_Tiet_DH,Ngay_Dat,Hinh_Thuc_Thanh_Toan,Tinh_Trang)
values('DH006','CTDH006','05/20/2019','0','0');
insert into dbo.DON_HANG(Ma_Don_Hang,Ma_Chi_Tiet_DH,Ngay_Dat,Hinh_Thuc_Thanh_Toan,Tinh_Trang)
values('DH007','CTDH007','05/20/2019','1','0');
insert into dbo.DON_HANG(Ma_Don_Hang,Ma_Chi_Tiet_DH,Ngay_Dat,Hinh_Thuc_Thanh_Toan,Tinh_Trang)
values('DH008','CTDH008','05/20/2019','0','0');
insert into dbo.DON_HANG(Ma_Don_Hang,Ma_Chi_Tiet_DH,Ngay_Dat,Hinh_Thuc_Thanh_Toan,Tinh_Trang)
values('DH009','CTDH009','05/20/2019','1','0');
insert into dbo.DON_HANG(Ma_Don_Hang,Ma_Chi_Tiet_DH,Ngay_Dat,Hinh_Thuc_Thanh_Toan,Tinh_Trang)
values('DH010','CTDH010','05/20/2019','0','0');