小吃培训网站源码分享(2020最新小吃培训)

大家好,小吃培训网站源码分享相信很多的网友都不是很明白,包括2020最新小吃培训也是一样,不过没有关系,接下来就来为大家分享关于小吃培训网站源码分享和2020最新小吃培训的一些知识点,大家可以关注收藏,免得下次来找不到哦,下面我们开始吧!

开发语言:Python

框架:django

Python版本:python3.7.7

数据库:mysql5.7(一定要5.7版本)

数据库工具:Navicat11

开发软件:PyCharm

浏览器:谷歌浏览器

数据库:

DROPTABLEIFEXISTS`config`;

/*!40101SET@saved_cs_client=@@character_set_client*/;

/*!40101SETcharacter_set_client=utf8*/;

CREATETABLE`config`(

`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,

`name`varchar(100)NOTNULLCOMMENT&39;,

`value`varchar(100)DEFAULTNULLCOMMENT&39;,

PRIMARYKEY(`id`)

)ENGINE=InnoDBAUTO_INCREMENT=4DEFAULTCHARSET=utf8COMMENT=&39;;

/*!40101SETcharacter_set_client=@saved_cs_client*/;

–Dumpingdatafortable`config`

LOCKTABLES`config`WRITE;

/*!40000ALTERTABLE`config`DISABLEKEYS*/;

INSERTINTO`config`VALUES(1,&39;,&39;),(2,&39;,&39;),(3,&39;,&39;);

/*!40000ALTERTABLE`config`ENABLEKEYS*/;

UNLOCKTABLES;

–Tablestructurefortable`discusshandanmeijing`

DROPTABLEIFEXISTS`discusshandanmeijing`;

/*!40101SET@saved_cs_client=@@character_set_client*/;

/*!40101SETcharacter_set_client=utf8*/;

CREATETABLE`discusshandanmeijing`(

`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,

`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,

`refid`bigint(20)NOTNULLCOMMENT&39;,

`userid`bigint(20)NOTNULLCOMMENT&39;,

`nickname`varchar(200)DEFAULTNULLCOMMENT&39;,

`content`longtextNOTNULLCOMMENT&39;,

`reply`longtextCOMMENT&39;,

PRIMARYKEY(`id`)

)ENGINE=InnoDBAUTO_INCREMENT=107DEFAULTCHARSET=utf8COMMENT=&39;;

/*!40101SETcharacter_set_client=@saved_cs_client*/;

–Dumpingdatafortable`discusshandanmeijing`

LOCKTABLES`discusshandanmeijing`WRITE;

/*!40000ALTERTABLE`discusshandanmeijing`DISABLEKEYS*/;

INSERTINTO`discusshandanmeijing`VALUES(101,&39;,1,1,&39;,&39;,&39;),(102,&39;,2,2,&39;,&39;,&39;),(103,&39;,3,3,&39;,&39;,&39;),(104,&39;,4,4,&39;,&39;,&39;),(105,&39;,5,5,&39;,&39;,&39;),(106,&39;,6,6,&39;,&39;,&39;);

/*!40000ALTERTABLE`discusshandanmeijing`ENABLEKEYS*/;

UNLOCKTABLES;

–Tablestructurefortable`discusshandanmeishi`

DROPTABLEIFEXISTS`discusshandanmeishi`;

/*!40101SET@saved_cs_client=@@character_set_client*/;

/*!40101SETcharacter_set_client=utf8*/;

CREATETABLE`discusshandanmeishi`(

`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,

`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,

`refid`bigint(20)NOTNULLCOMMENT&39;,

`userid`bigint(20)NOTNULLCOMMENT&39;,

`nickname`varchar(200)DEFAULTNULLCOMMENT&39;,

`content`longtextNOTNULLCOMMENT&39;,

`reply`longtextCOMMENT&39;,

PRIMARYKEY(`id`)

)ENGINE=InnoDBAUTO_INCREMENT=117DEFAULTCHARSET=utf8COMMENT=&39;;

/*!40101SETcharacter_set_client=@saved_cs_client*/;

–Dumpingdatafortable`discusshandanmeishi`

LOCKTABLES`discusshandanmeishi`WRITE;

/*!40000ALTERTABLE`discusshandanmeishi`DISABLEKEYS*/;

INSERTINTO`discusshandanmeishi`VALUES(111,&39;,1,1,&39;,&39;,&39;),(112,&39;,2,2,&39;,&39;,&39;),(113,&39;,3,3,&39;,&39;,&39;),(114,&39;,4,4,&39;,&39;,&39;),(115,&39;,5,5,&39;,&39;,&39;),(116,&39;,6,6,&39;,&39;,&39;);

/*!40000ALTERTABLE`discusshandanmeishi`ENABLEKEYS*/;

UNLOCKTABLES;

–Tablestructurefortable`discussyonghufenxiang`

DROPTABLEIFEXISTS`discussyonghufenxiang`;

/*!40101SET@saved_cs_client=@@character_set_client*/;

/*!40101SETcharacter_set_client=utf8*/;

CREATETABLE`discussyonghufenxiang`(

`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,

`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,

`refid`bigint(20)NOTNULLCOMMENT&39;,

`userid`bigint(20)NOTNULLCOMMENT&39;,

`nickname`varchar(200)DEFAULTNULLCOMMENT&39;,

`content`longtextNOTNULLCOMMENT&39;,

`reply`longtextCOMMENT&39;,

PRIMARYKEY(`id`)

)ENGINE=InnoDBAUTO_INCREMENT=127DEFAULTCHARSET=utf8COMMENT=&39;;

/*!40101SETcharacter_set_client=@saved_cs_client*/;

–Dumpingdatafortable`discussyonghufenxiang`

LOCKTABLES`discussyonghufenxiang`WRITE;

/*!40000ALTERTABLE`discussyonghufenxiang`DISABLEKEYS*/;

INSERTINTO`discussyonghufenxiang`VALUES(121,&39;,1,1,&39;,&39;,&39;),(122,&39;,2,2,&39;,&39;,&39;),(123,&39;,3,3,&39;,&39;,&39;),(124,&39;,4,4,&39;,&39;,&39;),(125,&39;,5,5,&39;,&39;,&39;),(126,&39;,6,6,&39;,&39;,&39;);

/*!40000ALTERTABLE`discussyonghufenxiang`ENABLEKEYS*/;

UNLOCKTABLES;

–Tablestructurefortable`forum`

DROPTABLEIFEXISTS`forum`;

/*!40101SET@saved_cs_client=@@character_set_client*/;

/*!40101SETcharacter_set_client=utf8*/;

CREATETABLE`forum`(

`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,

`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,

`title`varchar(200)DEFAULTNULLCOMMENT&39;,

`content`longtextNOTNULLCOMMENT&39;,

`parentid`bigint(20)DEFAULTNULLCOMMENT&39;,

`userid`bigint(20)NOTNULLCOMMENT&39;,

`username`varchar(200)DEFAULTNULLCOMMENT&39;,

`isdone`varchar(200)DEFAULTNULLCOMMENT&39;,

PRIMARYKEY(`id`)

)ENGINE=InnoDBAUTO_INCREMENT=77DEFAULTCHARSET=utf8COMMENT=&39;;

/*!40101SETcharacter_set_client=@saved_cs_client*/;

–Dumpingdatafortable`forum`

LOCKTABLES`forum`WRITE;

/*!40000ALTERTABLE`forum`DISABLEKEYS*/;

INSERTINTO`forum`VALUES(71,&39;,&39;,&39;,0,1,&39;,&39;),(72,&39;,&39;,&39;,0,2,&39;,&39;),(73,&39;,&39;,&39;,0,3,&39;,&39;),(74,&39;,&39;,&39;,0,4,&39;,&39;),(75,&39;,&39;,&39;,0,5,&39;,&39;),(76,&39;,&39;,&39;,0,6,&39;,&39;);

/*!40000ALTERTABLE`forum`ENABLEKEYS*/;

UNLOCKTABLES;

–Tablestructurefortable`handanmeijing`

DROPTABLEIFEXISTS`handanmeijing`;

/*!40101SET@saved_cs_client=@@character_set_client*/;

/*!40101SETcharacter_set_client=utf8*/;

CREATETABLE`handanmeijing`(

`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,

`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,

`jingdianmingcheng`varchar(200)NOTNULLCOMMENT&39;,

`jingdianfenlei`varchar(200)NOTNULLCOMMENT&39;,

`jingdianxingji`varchar(200)DEFAULTNULLCOMMENT&39;,

`jingdiantupian`varchar(200)DEFAULTNULLCOMMENT&39;,

`menpiaojiage`int(11)NOTNULLCOMMENT&39;,

`suoshudiqu`varchar(200)DEFAULTNULLCOMMENT&39;,

`jutiweizhi`varchar(200)DEFAULTNULLCOMMENT&39;,

`yonghupingjia`varchar(200)NOTNULLCOMMENT&39;,

`yingyeshijian`varchar(200)DEFAULTNULLCOMMENT&39;,

`xuanchuanshipin`varchar(200)DEFAULTNULLCOMMENT&39;,

`zixunrexian`varchar(200)DEFAULTNULLCOMMENT&39;,

`jingdianjieshao`longtextCOMMENT&39;,

`clicktime`datetimeDEFAULTNULLCOMMENT&39;,

PRIMARYKEY(`id`)

)ENGINE=InnoDBAUTO_INCREMENT=47DEFAULTCHARSET=utf8COMMENT=&39;;

/*!40101SETcharacter_set_client=@saved_cs_client*/;

–Dumpingdatafortable`handanmeijing`

LOCKTABLES`handanmeijing`WRITE;

/*!40000ALTERTABLE`handanmeijing`DISABLEKEYS*/;

INSERTINTO`handanmeijing`VALUES(41,&39;,&39;,&39;,&39;,&39;,1,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(42,&39;,&39;,&39;,&39;,&39;,2,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(43,&39;,&39;,&39;,&39;,&39;,3,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(44,&39;,&39;,&39;,&39;,&39;,4,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(45,&39;,&39;,&39;,&39;,&39;,5,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(46,&39;,&39;,&39;,&39;,&39;,6,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;);

/*!40000ALTERTABLE`handanmeijing`ENABLEKEYS*/;

UNLOCKTABLES;

–Tablestructurefortable`handanmeishi`

DROPTABLEIFEXISTS`handanmeishi`;

/*!40101SET@saved_cs_client=@@character_set_client*/;

/*!40101SETcharacter_set_client=utf8*/;

CREATETABLE`handanmeishi`(

`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,

`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,

`meishimingcheng`varchar(200)NOTNULLCOMMENT&39;,

`meishifenlei`varchar(200)NOTNULLCOMMENT&39;,

`meishitupian`varchar(200)DEFAULTNULLCOMMENT&39;,

`meishikouwei`varchar(200)DEFAULTNULLCOMMENT&39;,

`suozaiquxian`varchar(200)DEFAULTNULLCOMMENT&39;,

`jutiweizhi`varchar(200)DEFAULTNULLCOMMENT&39;,

`yonghupingjia`varchar(200)NOTNULLCOMMENT&39;,

`meishitese`varchar(200)DEFAULTNULLCOMMENT&39;,

`meishishipin`varchar(200)DEFAULTNULLCOMMENT&39;,

`xiangqingjieshao`longtextCOMMENT&39;,

`faburiqi`dateDEFAULTNULLCOMMENT&39;,

`clicktime`datetimeDEFAULTNULLCOMMENT&39;,

PRIMARYKEY(`id`)

)ENGINE=InnoDBAUTO_INCREMENT=57DEFAULTCHARSET=utf8COMMENT=&39;;

/*!40101SETcharacter_set_client=@saved_cs_client*/;

–Dumpingdatafortable`handanmeishi`

LOCKTABLES`handanmeishi`WRITE;

/*!40000ALTERTABLE`handanmeishi`DISABLEKEYS*/;

INSERTINTO`handanmeishi`VALUES(51,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(52,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(53,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(54,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(55,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;),(56,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;,&39;);

/*!40000ALTERTABLE`handanmeishi`ENABLEKEYS*/;

UNLOCKTABLES;

–Tablestructurefortable`jingdianfenlei`

DROPTABLEIFEXISTS`jingdianfenlei`;

/*!40101SET@saved_cs_client=@@character_set_client*/;

/*!40101SETcharacter_set_client=utf8*/;

CREATETABLE`jingdianfenlei`(

`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,

`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,

`jingdianfenlei`varchar(200)NOTNULLCOMMENT&39;,

PRIMARYKEY(`id`),

UNIQUEKEY`jingdianfenlei`(`jingdianfenlei`)

)ENGINE=InnoDBAUTO_INCREMENT=27DEFAULTCHARSET=utf8COMMENT=&39;;

/*!40101SETcharacter_set_client=@saved_cs_client*/;

–Dumpingdatafortable`jingdianfenlei`

LOCKTABLES`jingdianfenlei`WRITE;

/*!40000ALTERTABLE`jingdianfenlei`DISABLEKEYS*/;

INSERTINTO`jingdianfenlei`VALUES(21,&39;,&39;),(22,&39;,&39;),(23,&39;,&39;),(24,&39;,&39;),(25,&39;,&39;),(26,&39;,&39;);

/*!40000ALTERTABLE`jingdianfenlei`ENABLEKEYS*/;

UNLOCKTABLES;

–Tablestructurefortable`meishifenlei`

DROPTABLEIFEXISTS`meishifenlei`;

/*!40101SET@saved_cs_client=@@character_set_client*/;

/*!40101SETcharacter_set_client=utf8*/;

CREATETABLE`meishifenlei`(

`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,

`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,

`meishifenlei`varchar(200)NOTNULLCOMMENT&39;,

PRIMARYKEY(`id`),

UNIQUEKEY`meishifenlei`(`meishifenlei`)

)ENGINE=InnoDBAUTO_INCREMENT=37DEFAULTCHARSET=utf8COMMENT=&39;;

/*!40101SETcharacter_set_client=@saved_cs_client*/;

–Dumpingdatafortable`meishifenlei`

LOCKTABLES`meishifenlei`WRITE;

/*!40000ALTERTABLE`meishifenlei`DISABLEKEYS*/;

INSERTINTO`meishifenlei`VALUES(31,&39;,&39;),(32,&39;,&39;),(33,&39;,&39;),(34,&39;,&39;),(35,&39;,&39;);

/*!40000ALTERTABLE`meishifenlei`ENABLEKEYS*/;

UNLOCKTABLES;

–Tablestructurefortable`news`

DROPTABLEIFEXISTS`news`;

/*!40101SET@saved_cs_client=@@character_set_client*/;

/*!40101SETcharacter_set_client=utf8*/;

CREATETABLE`news`(

`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,

`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,

`title`varchar(200)NOTNULLCOMMENT&39;,

`introduction`longtextCOMMENT&39;,

`picture`varchar(200)NOTNULLCOMMENT&39;,

`content`longtextNOTNULLCOMMENT&39;,

PRIMARYKEY(`id`)

)ENGINE=InnoDBAUTO_INCREMENT=97DEFAULTCHARSET=utf8COMMENT=&39;;

/*!40101SETcharacter_set_client=@saved_cs_client*/;

END,本文到此结束,如果可以帮助到大家,还望关注本站哦!

Published by

风君子

独自遨游何稽首 揭天掀地慰生平