3Xp7cdvZ

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               10.3.16-MariaDB - mariadb.org binary distribution
4-- Server OS:                    Win64
5-- HeidiSQL Version:             10.2.0.5599
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for buoi3
16CREATE DATABASE IF NOT EXISTS `buoi3` /*!40100 DEFAULT CHARACTER SET utf8 */;
17USE `buoi3`;
18
19-- Dumping structure for table buoi3.sanpham
20CREATE TABLE IF NOT EXISTS `sanpham` (
21  `idsp` int(11) NOT NULL AUTO_INCREMENT,
22  `tensp` varchar(32) NOT NULL DEFAULT '0',
23  `chitietsp` text NOT NULL DEFAULT '0',
24  `giasp` int(11) NOT NULL DEFAULT 0,
25  `hinhanhsp` varchar(64) NOT NULL DEFAULT '0',
26  `idtv` int(11) NOT NULL DEFAULT 0,
27  PRIMARY KEY (`idsp`),
28  KEY `idtv` (`idtv`),
29  CONSTRAINT `FK_sanpham_thanhvien` FOREIGN KEY (`idtv`) REFERENCES `thanhvien` (`id`) ON DELETE CASCADE
30) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
31
32-- Dumping structure for table buoi3.thanhvien
33CREATE TABLE IF NOT EXISTS `thanhvien` (
34  `id` int(11) NOT NULL AUTO_INCREMENT,
35  `tendangnhap` varchar(64) NOT NULL DEFAULT '0',
36  `matkhau` varchar(64) NOT NULL DEFAULT '0',
37  `gioitinh` varchar(5) NOT NULL DEFAULT '0',
38  `nghenghiep` varchar(24) NOT NULL DEFAULT '0',
39  `sothich` varchar(64) NOT NULL DEFAULT '0',
40  `hinhanh` varchar(191) NOT NULL DEFAULT '0',
41  PRIMARY KEY (`id`)
42) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;