大家好,小吃培训网站源码分享相信很多的网友都不是很明白,包括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,本文到此结束,如果可以帮助到大家,还望关注本站哦!
