Cov txheej txheem:

CocktailMaker: 22 Kauj Ruam
CocktailMaker: 22 Kauj Ruam

Video: CocktailMaker: 22 Kauj Ruam

Video: CocktailMaker: 22 Kauj Ruam
Video: Raug Neeg Nchuav Lub Neej Vim Kev Ruam. 6/5/22 2024, Lub Xya hli ntuj
Anonim
CocktailMaker
CocktailMaker

Cocktails, ib txoj hauv kev zoo los xaus rau hnub nkees, lossis pib ua kev lom zem. Koj mus rau qhov bar, xaj kom haus zoo nkauj, zaum rov qab thiab tos kom cov sib xyaw saum ntuj tuaj txog. Thaum kawg ntawm qhov tsaus ntuj koj them tus nqi, taw qhia tus neeg muag khoom thiab koj tab tom taug kev. Tab sis dab tsi yog tias kuv tau hais rau koj muaj ib txoj hauv kev rau koj kom txaus siab rau tib lub cocktail qab uas tsis tau mus rau bar lossis txawm tias siv nyiaj ntau. Txhua yam nws yuav siv yog me ntsis ntawm koj lub sijhawm dawb thiab qee qhov kev muaj tswv yim. Khaws nyeem ntawv, thiab kuv yuav piav qhia ib qib zuj zus yuav ua li cas ua koj tus kheej lub tshuab cocktail hauv tsev.

Khoom siv

Rau rooj plaub

- MDF 6 hli tuab

- 2 x 374mm / 462mm

- 2 x 280mm / 462mm

- 2 x 174mm / 250 hli

- 1 x 162mm / 250 hli

- 1 x 150mm / 250 hli

- 1 x 180mm / 162mm

- 1 x 180 mm / 362 hli

- 1 x 362mm / 100 hli

- 1 x 374mm / 292 hli

- MDF 12 hli tuab

- 1 x 374mm / 292 hli

- 2x pob

- ntsia hlau

- ntoo kua nplaum

Rau electronics

- 1 x LCD zaub 16x2

1 x 5V 8-channel relayboard

- 1 x 12V DC 100W fais fab mov

- 1 x raspberry pi 3B+

- 8 x 12V DC Dosing Pump

- 1 x PCA8574p I2C I/O nthuav dav

- 1 x khob cij

- 1 x 330 Ohm resistor

2 x 470 Ohm resistor

- 1 x kev faib tawm ntsaws

- 1 x infrared teeb meem kev tiv thaiv kev zam

- 1 x ultrasonic module

- 1 x sib nqus qhov rooj qhov rooj

- tooj liab hlau

Ntxiv

- 1 x lub qhov me me

- 1 x hloov tau lub hau nutella

- 8m hloov tau raj 4 hli tuab

- 3 x khaub ncaws

- xim dawb

- 1 x cocktailshaker

Dej haus

- 1 x lub raj mis gin

- 1 x lub raj mis rum

- 1 x lub raj mis ntawm vodka

- 1 x lub raj mis ntawm tequila

- 1 x lub raj mis ntawm triple sec

- 1 x lub raj mis kua txiv qaub

- 1 x lub raj mis yooj yim phoov

- 1 x fwj tshuaj cola

(yeem)

- 8 lub raj mis sib npaug

Kauj Ruam 1: Kos Lub Qhov

Teeb duab Qhov
Teeb duab Qhov

Peb pib los ntawm kev ntsuas thiab kos cov qhov xav tau ntawm cov ntoo.

  • pem hauv ntej vaj huam sib luag (374mm/462mm)

    • 6.5 cm los ntawm sab saum toj, hauv nruab nrab ntawm lub vaj huam sib luag, peb kos lub qhov quav me me ntawm peb lub lcd zaub.
    • hauv qab, hauv nruab nrab ntawm lub vaj huam sib luag, peb kos lub duab plaub ntawm 25cm siab los ntawm 15cm dav rau lub qhov rooj.
  • rov qab vaj huam sib luag ntawm cov khoom siv hluav taws xob (362mm/100mm)

    kos 8 zaug saum npoo ntawm lub twj tso kua mis ntawm lub vaj huam sib luag no, kom txhua lub twj tso kua mis haum

  • vaj huam sib luag sab saum toj ntawm shaker chamber (180mm/162mm)

    • kos lub cirkel loj npaum li qhov kawg ntawm lub raj cua nyob hauv nruab nrab ntawm lub vaj huam sib luag
    • 3 cm los ntawm ntug ntawm sab luv, kos cov duab ntawm ob lub qhov xav tau rau cov qauv ultrasonic kom haum.
    • nyob rau sab xub ntiag sab xis, kos lub qhov me me, 1cm deb ntawm ob sab. Ob lub xov hlau tau txhaj los ntawm nws.
  • sab xis vaj huam sib luag ntawm shaker chamber (174mm/250mm)

    10 cm los hauv qab (sab luv), kos ob lub qhov xav tau rau lub ntsuas hluav taws xob kom haum (hauv nruab nrab)

Kauj Ruam 2: Pom/drilling lub Qhov

Pom/drilling qhov
Pom/drilling qhov
Pom/drilling qhov
Pom/drilling qhov

Tam sim no uas peb tau kos peb lub qhov, nws yog lub sijhawm siv qee lub tshuab hnyav thiab txiav/pom/laum lawv. Kuv tau siv lub laum yooj yooj yim thiab ib qho fretsaw, thiab hauv tsawg dua ib teev txoj haujlwm tau ua tiav.

Yog tias koj zoo li kuv, thiab muaj teeb meem pom ntawm kab kab, koj tuaj yeem siv cov ntawv tom qab los kho koj qhov ua yuam kev.

Kauj Ruam 3: Gluing Case

Gluing Case
Gluing Case
  • Rau sab nrauv

    • Pib los ntawm gluing lub vaj huam sib luag tom qab (qhov loj tshaj) mus rau hauv qab vaj huam sib luag (tuab tuab) ntawm 90-degree lub kaum ntse ntse.
    • Ntxiv ob sab (2 x 280mm/462mm).
    • Peb yuav tawm ntawm lub hauv ntej thiab sab saum toj qhib rau tam sim no
  • rau sab hauv

    • Pib los ntawm kev ua lub shaker chamber.

      • nplaum ob sab (2 x 174mm/250mm) mus rau tom qab vaj huam sib luag (162mm/250mm)
      • ntxiv lub vaj huam sib luag sab saum toj (180mm/162mm) nrog ob lub qhov rau lub ultrasonic module ntsib lub vaj huam sib luag tom qab. Lub vaj huam sib luag no yuav tsum npog ob sab ntawm tag nrho peb lub vaj huam sib luag.
  • rau cov khoom siv hluav taws xob

    kua nplaum lub cav tsav mus rau hauv qab vaj huam sib luag (362mm/180mm)

  • lo lub shaker chamber mus rau hauv nruab nrab ntawm lub hauv ntej ntawm lub tshuab (tawm 6mm rau pem hauv ntej vaj huam sib luag.
  • muab cov khoom siv hluav taws xob tso rau sab saum toj ntawm lub tshuab, 6mm ntawm sab xub ntiag. Lub motorpanel yuav tsum tau ntsib lub vaj huam sib luag tom qab.

Kauj Ruam 4: Schematics

Schematics
Schematics
Schematics
Schematics

Ua ntej peb pib txuas tag nrho cov khoom siv hluav taws xob, cia peb saib cov duab.

Kauj Ruam 5: Soldering Twj Tso Kua Mis

Soldering Twj Tso Kua Mis
Soldering Twj Tso Kua Mis

Nco ntsoov tias txhua thaj chaw tau txuas nrog. Txoj kev no peb tuaj yeem txuas lawv yooj yim rau hauv av ntawm lub zog xa khoom.

Kauj Ruam 6: Txuas Lub Relayboard rau Lub Twj Tso Kua Mis

Txuas lub Relayboard mus rau lub twj tso kua mis
Txuas lub Relayboard mus rau lub twj tso kua mis
  • Txuas txhua COM's ntawm daim ntawv xa tawm, yog li peb tuaj yeem txuas lawv tau yooj yim rau 12V ntawm lub zog xa khoom.
  • Txuas txhua NO ntawm daim ntawv txuas nrog lub twj sib txawv (+).

Kauj Ruam 7: Ntxiv Cov Khoom Siv Hluav Taws Xob thiab Raspberry Pi

Ntxiv Cov Khoom Siv Hluav Taws Xob thiab Raspberry Pi
Ntxiv Cov Khoom Siv Hluav Taws Xob thiab Raspberry Pi

Tsis txhob mloog lub vaj huam sib luag pem hauv ntej hauv daim duab, Kuv tsuas yog muab tso rau ntawd kom muaj lub tswv yim ntawm qhov chaw yuav muaj cov khoom siv hluav taws xob ntau npaum li cas.

  • txuas lub relayboard zoo li no

    • 5V rau 5V tus pin ntawm raspberry pi
    • GND rau GND ntawm raspberry pi
    • txhua tus IN rau GPIO tus pin ntawm raspberry pi
  • txuas cov GND cov koob ntawm lub twj tso kua mis nrog 0V ntawm lub zog xa hluav taws xob, thiab cov kab ntawm COM's ntawm cov khoom sib txuas nrog 12V ntawm lub zog hluav taws xob.
  • Tam sim no, yog tias koj ua ib tsab ntawv yooj yim uas qhib txhua qhov txuas nrog GPIO pins, koj tuaj yeem sim koj li kev siv tshuaj thiab kho ib qho yuam kev ua ntej yuav muaj ntau lub xov hlau nyob hauv qhov chaw. Txhua lub twj tso kua mis yuav tsum pib

Kauj Ruam 8: Ntxiv Infrared Sensor

Ntxiv Infrared Sensor
Ntxiv Infrared Sensor
Ntxiv Infrared Sensor
Ntxiv Infrared Sensor
Ntxiv Infrared Sensor
Ntxiv Infrared Sensor
  • ua ntej tshaj plaws kuv tau ua lub qhov nyob hauv nruab nrab ntawm cov khoom siv hluav taws xob, kom cov xaim hluav taws xob los ntawm chav shaker tuaj yeem nce.
  • pib los ntawm kev teeb tsa lub sensor kom raug

    • txuas VDD rau 3.3V ntawm raspberry pi
    • txuas GND rau GND ntawm raspberry pi
    • muab ib daim ntawv me me tso rau ntawm tus neeg txais thiab tus xa khoom
    • tso tus shaker li 5cm deb ntawm lub sensor
    • coj tus ntswj ntsia hlau thiab tig lub taub hau rau sab saum toj kom txog thaum OUT coj tawm mus.
    • sim txav lub shaker rov qab thiab saib seb lub sensor puas ua rau txav mus los. (OUT coj yuav tsum qhib thiab ntawm).
    • rov ua dua yog tias tsim nyog.
  • ntxig tus txais thiab tus xa tawm los ntawm lub qhov peb tau ua dhau los.
  • txuas OUT tus pin rau GPIO tus pin ntawm raspberry pi.

Kauj Ruam 9: Txuas Ultrasonic Module

Txuas Ultrasonic Module
Txuas Ultrasonic Module
Txuas Ultrasonic Module
Txuas Ultrasonic Module
  • ntxig tus qauv rau hauv lub qhov nyob rau sab saum toj ntawm lub shaker chamber peb tau ua dhau los.
  • txuas VCC nrog tsib volts ntawm raspberry pi.
  • txuas tus txhais nrog tus pin GPIO
  • ua qhov hluav taws xob sib txawv ntawm GND thiab ncha (raws li qhia hauv daim duab)
  • txuas GDN nrog GND ntawm raspberry pi.
  • txuas lub ncha nrog tus pin GPIO

yog tias koj tsis nkag siab kuv txhais li cas los ntawm kev siv hluav taws xob sib txawv, saib lwm qhov ntawm cov duab. nws ua kom ntseeg tau tias 5V ncha tau qis dua 3.3V.

Kauj Ruam 10: Nruab Qhov Rooj

Nruab Qhov Rooj
Nruab Qhov Rooj
Nruab Qhov Rooj
Nruab Qhov Rooj
  • Siv cov ntsia hlau me los txuas lub hinges rau lub qhov rooj thiab rau lub vaj huam sib luag pem hauv ntej.
  • ntiv tes ntiv tes kom yooj yim qhib lub qhov rooj.

Kauj Ruam 11: Nruab Qhov Rooj Qhov Rooj

Nruab qhov Qhov Rooj Hloov
Nruab qhov Qhov Rooj Hloov
Nruab qhov Qhov Rooj Hloov
Nruab qhov Qhov Rooj Hloov

Siv cov ntsia hlau los yog kua nplaum los txuas ob ntu ntawm lub qhov rooj hloov mus rau lub qhov rooj, thiab sab hauv ntawm lub qhov rooj shaker.

Kauj Ruam 12: Ua Tus Tuav Lub Raj

Ua tus tuav lub raj
Ua tus tuav lub raj
  • txiav yim daim raj ntawm kwv yees li 20cm
  • siv cov khoom ncig (Kuv siv lub hau nutella hloov tau) tuav lawv

Kauj Ruam 13: Ntxig rau Funnel

Ntxig rau Funnel
Ntxig rau Funnel
  • tso lub funnel rau hauv lub qhov kawg hauv lub vaj huam sib luag sab saum toj ntawm lub shaker chamber.
  • muab tus tuav lub raj tso rau hauv lub raj mis, thiab ruaj ntseg nws nrog cov khaub ncaws pegs.

Kauj Ruam 14: Txuas lub raj rau lub twj tso kua mis

Txuas cov Tub rau Twj Tso Kua Mis
Txuas cov Tub rau Twj Tso Kua Mis

txuas koj lwm sab ntawm lub raj xa mus rau sab xa dej ntawm lub twj tso kua mis.

Kauj Ruam 15: Txiav Tubes rau Lub Raj Dej

Txiav Tub Rau Lub Raj Dej
Txiav Tub Rau Lub Raj Dej
Txiav Tub Rau Lub Raj Dej
Txiav Tub Rau Lub Raj Dej
Txiav Tub Rau Lub Raj Dej
Txiav Tub Rau Lub Raj Dej
Txiav Tub Rau Lub Raj Dej
Txiav Tub Rau Lub Raj Dej

txiav ntau qhov sib txawv ntawm cov raj, kom txhua lub raj mis yuav txuas nrog lub twj tso kua mis. Txuas lawv mus rau sab tsis siv ntawm lub twj tso kua mis.

Kauj Ruam 16: Ntxiv Cov Faib Plug

Ntxiv qhov Distribution Plug
Ntxiv qhov Distribution Plug
Ntxiv qhov Distribution Plug
Ntxiv qhov Distribution Plug
  • txiav qhov txuas ntsaws
  • laum ib lub qhov nyob rau sab ntawm cov khoom siv hluav taws xob
  • muab txoj hlua hla lub qhov
  • txuas tus xov tooj txuas dua

Kauj Ruam 17: Txuas lub Lcd

Txuas lub Lcd
Txuas lub Lcd
  • txuas lub lcd raws li qhia hauv kab lus
  • siv I2C i/o nthuav dav, vim tias yuav tsis muaj GPIO koob txaus
  • qhov no tsuas yog lub sijhawm peb xav tau daim ntawv me me

Kauj Ruam 18: Kaw Cov Pem Hauv Ntej

tam sim no tias LCD (peb cov khoom tiv thaiv zaum kawg) txuas nrog, peb tuaj yeem lo lub vaj huam sib luag pem hauv ntej rau peb lub tshuab.

Kauj Ruam 19: Xim Xim

Painting
Painting
Painting
Painting
Painting
Painting
Painting
Painting

nco ntsoov npog cov ntoo uas tsis yog ntoo nrog kab xev, thiab pleev xim lub tshuab ua xim uas koj xaiv.

Kauj Ruam 20: Sau Lub Tshuab

Sau Lub Tshuab
Sau Lub Tshuab

Qhov kawg peb yuav tsum tau ua ua ntej peb tuaj yeem tso cov cai thiab txaus siab rau cov dej qab qab uas qab, yog sau lub tshuab nrog cawv, thiab qee cov khoom sib tov.

Kauj ruam 21: Tsim Database

Tsim cov Database
Tsim cov Database
Tsim cov Database
Tsim cov Database

ua kev sib txuas rau raspberry pi, thiab tsim cov ntaub ntawv.

Tsim cov ntaub ntawv yog tias tsis muaj 'cocktailmaker` / *! 40100 DEFAULT CHARACTER SET utf8 * /; SIV `cocktailmaker`; -MySQL dump 10.13 Faib 5.7.17, rau Win64 (x86_64)--Host: 127.0.0.1 Database: cocktailmaker ------------- ----------------------------------Server version 5.7.20-log

/ *! 40101 SET @OLD_CHARACTER_SET_CLIENT = @@ CHARACTER_SET_CLIENT */;

/ *! 40101 SET @OLD_CHARACTER_SET_RESULTS = @@ CHARACTER_SET_RESULTS */; / *! 40101 SET @OLD_COLLATION_CONNECTION = @@ COLLATION_CONNECTION */; / *! 40101 SET NAMES utf8 */; / *! 40103 SET @OLD_TIME_ZONE = @@ TIME_ZONE */; / *! 40103 SET TIME_ZONE = '+00:00' */; / *! 40014 SET @OLD_UNIQUE_CHECKS = @@ UNIQUE_CHECKS, UNIQUE_CHECKS = 0 */; / *! 40014 SET @OLD_FOREIGN_KEY_CHECKS = @@ FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0 */; / *! 40101 SET @OLD_SQL_MODE = @@ SQL_MODE, SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO' */; / *! 40111 SET @OLD_SQL_NOTES = @@ SQL_NOTES, SQL_NOTES = 0 */;

--

-Cov qauv rooj rau rooj `cocktaillogboek`-

QHOV TABLE YOG YOG TUS 'cocktaillogboek`;

/ *! 40101 SET @saved_cs_client = @@ character_set_client */; / *! 40101 SET character_set_client = utf8 */; TABLE CAB `cocktaillogboek` (` id_cocktail_log` int (11) TSIS NULL AUTO_INCREMENT, `aantal` tinyint (4) DEFAULT NULL,` datum `datetime DEFAULT CURRENT_TIMESTAMP,` cocktail_id` int (11) TSIS NULL,, `cocktail_id`), KEY` fk_Cocktaillogboek_Cocktails1_idx `(` cocktail_id`), CONSTRAINT `fk_Cocktaillogboek_Cocktails1` FOREIGN KEY (` cocktail_id`) อ้างอิง `cocktails` (` id_cocktail`` ไม่ ต้อง เสีย ก่อน) 5 DEFAULT CHARSET = utf8; / *! 40101 SET character_set_client = @saved_cs_client */;

--

-Dumping cov ntaub ntawv rau lub rooj `cocktaillogboek`-

LOCK TABLES `cocktaillogboek` Sau;

/ *! 40000 Hloov TABLE `cocktaillogboek` QHOV TSEEB KEYS */; INSERT INTO `cocktaillogboek` VALUES (1, 1, '2019-05-31 18:06:24', 1), (2, 1, '2019-05-31 18:06:24', 2), (3, 2, '2019-05-31 18:06:24', 1), (4, 2, '2019-05-31 18:06:24', 2); / *! 40000 TAB SIS TABLE `cocktaillogboek` QHIA KEYS */; Qhib TABLES;

--

-Cov qauv rooj rau rooj `cocktails`-

QHIA TABLE YOG YUAV TSUM muaj 'cocktails';

/ *! 40101 SET @saved_cs_client = @@ character_set_client */; / *! 40101 SET character_set_client = utf8 */; TABLE TABLE `cocktails` (` id_cocktail` int (11) NOT NULL AUTO_INCREMENT, `naam_cocktail` tinytext,` code_cocktail` varchar (45) DEFAULT NULL, `inhoud_cocktail` float DEFAULT NULL, PRIMARY KEY`) code_cocktail_UNIQUE` (`code_cocktail`)) ENGINE = InnoDB AUTO_INCREMENT = 3 DAWB CHARSET = utf8; / *! 40101 SET character_set_client = @saved_cs_client */;

--

Dumping cov ntaub ntawv rau lub rooj `cocktails`-

LOCK TABLES `cocktails` Sau ntawv;

/ *! 40000 QHOV TABLE `Cocktails` YOOJ YIM YOOJ YIM */; INSERT INTO 'cocktails' VALUES (1, 'cov kob ntev iced tshuaj yej', '1q3n2q3n3q3n4q3n5q3x6q3n8q2', 20), (2, 'tequila sunrise', '2q5x7q5x9q3', 13); / *! 40000 Hloov TABLE `cocktails` ENABLE KEYS */; Qhib TABLES;

--

-Cov qauv rooj rau rooj `dranken`-

QHIA TABLE YOG TUS NEEG YUAV TSUM `dranken`;

/ *! 40101 SET @saved_cs_client = @@ character_set_client */; / *! 40101 SET character_set_client = utf8 */; CREATE TABLE `dranken` (` id_drank` int (11) NOT NULL AUTO_INCREMENT, `naam_drank`tinytext,` tijd_per_centiliter `float DEFAULT NULL,` inhoud_drank` float DEFAULT NULL, `pomp_drank`TUSTUS (4) id_drank`)) ENGINE = InnoDB AUTO_INCREMENT = 12 DEFAULT CHARSET = utf8; / *! 40101 SET character_set_client = @saved_cs_client */;

--

-Dumping cov ntaub ntawv rau lub rooj `dranken`-

LOCK TABLES `dranken` WRITE;

/ *! 40000 Hloov TABLE `dranken` DISABLE KEYS */; INSERT INTO 'dranken' VALUES (1, 'gin', 20, 70, 1), (2, 'tequila', 20, 70, 2), (3, 'wodka', 20, 70, 3), (4, 'triple sec', 20, 70, 4), (5, 'rum', 20, 70, 5), (6, 'whiskey', 20, 70, NULL), (7, 'cola', 15, 100, 6), (8, 'sinaasappelsap', 25, 100, 7), (9, 'limoensap', 20, 100, 8), (10, 'grenadine', 30, 100, 9), (11, 'suikersiroop', 30, 100, 10); / *! 40000 Hloov TABLE `dranken` ENABLE KEYS */; Qhib TABLES;

--

-Cov qauv rooj rau rooj `dranken_cocktails`-

QHIA TABLE YOG TUS TSEV KAWM NTAWV `dranken_cocktails`;

/ *! 40101 SET @saved_cs_client = @@ character_set_client */; / *! 40101 SET character_set_client = utf8 */; TABLE CREATE TABLE `dranken_cocktails` (` Dranken_id_drank` int (11) NOT NULL, `Cocktail_id_cocktail` int (11) NOT NULL, PRIMARY KEY (` Dranken_id_drank`, `Cocktail_id_cocktail`), KEY` fock_kock fk_Dranken_has_Cocktail_Dranken1_idx` ('Dranken_id_drank`), constraint' fk_Dranken_has_Cocktail_Cocktail1` TXAWV TEB CHAWS TSEEM CEEB ('Cocktail_id_cocktail`) ua tim khawv' cocktails` ('id_cocktail`) RAU rho tawm TSIS UA RAU Hloov tshiab TSIS UA, constraint' fk_Dranken_has_Cocktail_Dranken1` TXAWV TEB CHAWS TSEEM CEEB ('Dranken_id_drank`) ua tim khawv' dranken` (`id_drank`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB DEFAULT CHARSET = utf8; / *! 40101 SET character_set_client = @saved_cs_client */;

--

-Dumping cov ntaub ntawv rau lub rooj `dranken_cocktails`-

LOCK TABLES `dranken_cocktails` Sau;

/ *! 40000 Hloov TABLE `dranken_cocktails` QHOV TSEEB KEYS */; / *! 40000 TABLETABLE `dranken_cocktails` ENABLE KEYS */; Qhib TABLES;

--

-Cov qauv rooj rau rooj `softs`-

QHIA TABLE YOG YOG TUS `softs`;

/ *! 40101 SET @saved_cs_client = @@ character_set_client */; / *! 40101 SET character_set_client = utf8 */; CREATE TABLE `softs` (`bruisend_drank` tinyint (4) DEFAULT NULL,` drank_id `int (11) TSIS NULL, KEY` fk_Softs_Dranken1_idx `(` drank_id`), CONSTRAINT `fk_Softs_Dranken1`FENE``CERE`K `(` id_drank`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB DEFAULT CHARSET = utf8; / *! 40101 SET character_set_client = @saved_cs_client */;

--

Dumping cov ntaub ntawv rau lub rooj `softs`-

LOCK TABLES `softs` WRITE;

/ *! 40000 TABLETABLE `softs` KEYLE KEYS */; INSERT INTO `softs` VALUES (1, 7), (0, 8), (0, 9), (0, 10), (0, 11); / *! 40000 Hloov TABLE `softs` ENABLE KEYS */; Qhib TABLES;

--

-Cov lus rooj rau rooj `plig`-

QHOV TABLE YOG TUS TSEV KAWM NTAWV `plig ';

/ *! 40101 SET @saved_cs_client = @@ character_set_client */; / *! 40101 SET character_set_client = utf8 */; CUAB TABLE `dab '(` cawv_percentage_drank` me metext, `soort_drank`tinytext,` drank_id `int (11) TSIS NULL, KEY` fk_Spirits_Dranken_idx `(` drank_id`), CONSTRAINT `fk_Spirits_Dranken`FENE``DEENE`K `(` id_drank`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB DEFAULT CHARSET = utf8; / *! 40101 SET character_set_client = @saved_cs_client */;

--

-Dumping cov ntaub ntawv rau lub rooj `plig`-

LOCK TABLES `spirit` WRITE;

/ *! 40000 QHOV TSEEB TSEV `sab ntsuj plig` QHOV TSEEB KEYS */; INSERT INTO `spirit 'VALUES (' 40 ',' gin ', 1), (' 35 ',' tequila ', 2), ('37.5', 'wodka', 3), ('40', 'triple sec ', 4), ('37.5', 'rum', 5), ('37.5 ',' whiskey ', 6); / *! 40000 TABLETABLE `dab 'ENABLE KEYS */; Qhib TABLES;

--

-Pov tseg cov xwm txheej rau database 'cocktailmaker'-

--

- Dumping cov txheej txheem rau database 'cocktailmaker'- / *! 40103 SET TIME_ZONE =@OLD_TIME_ZONE * /;

/ *! 40101 SET SQL_MODE =@OLD_SQL_MODE */;

/ *! 40014 SET FOREIGN_KEY_CHECKS =@OLD_FOREIGN_KEY_CHECKS */; / *! 40014 SET UNIQUE_CHECKS =@OLD_UNIQUE_CHECKS */; / *! 40101 SET CHARACTER_SET_CLIENT =@OLD_CHARACTER_SET_CLIENT */; / *! 40101 SET CHARACTER_SET_RESULTS =@OLD_CHARACTER_SET_RESULTS */; / *! 40101 SET COLLATION_CONNECTION =@OLD_COLLATION_CONNECTION */; / *! 40111 SET SQL_NOTES =@OLD_SQL_NOTES */;

-Dump tiav rau 2019-06-03 14:56:53

Kauj Ruam 22: Sau Txoj Cai

Sau Txoj Cai
Sau Txoj Cai

Ntau teev ntawm kev ua haujlwm tau mus rau txoj haujlwm no, hmoov zoo rau koj Kuv muaj github chaw cia khoom.

Nov yog qhov txuas rau cov cai.

Pom zoo: