Migration of Lavarel's commonly used statements

The content of this article is about Migration, a commonly used statement in Lavarel. It has a certain reference value. Now I share it with you. Friends in need can refer to it

Lavarel5.2 Mainly, the previous parts need to be operated frequently. As long as you master the commonly used statement functions, it will become much easier to implement them

1. Controller

2. Model

3. ##View

4. Route

5. Migration

##Migration Chapter

1. Create Migration

in Enter the command in the console

Command to create a table, we are used to naming it with behavior

php artisan make:migration create_users_table --create=users

Command to modify the table

php artisan make:migration add_votes_to_users_table --table=users

This way there will be more files in /database/migrations

2. Create a column

Schema::create('users', function ($table) {    $table->increments('id');    $table->string('name');
});

Corresponding command and type in the corresponding database

Auto-increment ID, type is bigint##$table->bigInteger('votes');$table->binary('data');##$table->boolean('confirmed');$table->char('name', 4);$table->date('created_at');$table->dateTime('created_at');##$table->decimal ('amount', 5, 2);$table- >double('column', 15, 8);$table->enum('choices', ['foo', 'bar']);$table->float('amount');$table->increments('id');Equivalent to the INTEGER type in the databaseEquivalent to the JSON type in the database##$table->jsonb('options');Equivalent to the JSONB type in the databaseEquivalent to the JSONB type in the database LONGTEXT type is equivalent to the MEDIUMINT type in the databaseEquivalent to the MEDIUMTEXT type in the databaseAdd an INTEGER type taggable_id column and a STRING type timestamps() but allows NULL values. column: VARCHAR(100) NULL.Add a column for soft deletion.Equivalent to VARCHAR in the database, with a lengthEquivalent to the TEXT type in the database##$table->time('sunrise ');##$table->tinyInteger('numbers');##$table->timestamp('added_on');Add column.##$table->uuid('id');

Command	Description
##$table->bigIncrements('id ');
Equivalent to the BIGINT type in the database
Equivalent to The BLOB type in the database
is equivalent to the BOOLEAN type in the database
Equivalent to the CHAR type in the database
Equivalent to the DATE type in the database
Equivalent to the DATETIME type in the database
Equivalent to the DECIMAL type in the database, with a precision and range
Equivalent to the DOUBLE type in the database, with precision, a total of 15 digits, 8 digits after the decimal point.
Equivalent to the ENUM type in the database
Equivalent to the FLOAT type in the database
Database primary key auto-increment ID	##$table-> integer('votes');
	$table->json('options');
##$table->longText('description');
$table->mediumInteger('numbers');
$table->mediumText('description');
$table->morphs('taggable');
taggable_type column	##$table->nullableTimestamps();Same as
##$table->rememberToken();	Add a remember_token
$table->smallInteger('votes');	Equivalent to the SMALLINT type in the database
$table->softDeletes();	deleted_at
$table->string('email');	Equivalent to the VARCHAR column in the database.
$table->string('name', 100);
$table ->text('description');
Equivalent to the TIME type in the database
Equivalent to the TINYINT type in the database
Equivalent to TIMESTAMP type in the database	##$table->timestamps();
created_at and updated_at
is equivalent to the UUID of the database	3.修改列 如果我们执行的是类似第二行命令的话 新生成migration里up方法的Create就会变成table，然后就可以在方法里写修改的一些代码 Schema::table('users', function ($table) { }); 我们将name列的尺寸从 25 增加到 50： $table->string('name', 50)->change(); 我们还可以修改该列允许 NULL 值： $table->string('name', 50)->nullable()->change(); 重命名列 $table->renameColumn('from', 'to'); 注意：暂不支持 enum类型的列的重命名。 删除列 $table->dropColumn('votes'); 1 删除多个列： $table->dropColumn(['votes', 'avatar', 'location']); 1 以上就是一些Migration的常用语句，学会Migration可以节省大量用命令行建表的时间 我把整个Lavarel系列的所有链接都更新了，欢迎大家点评 版权声明：本文为博主原创文章，未经博主允许不得转载。            https://blog.csdn.net/qq_32198277/article/details/52592769 The above is the detailed content of Migration of Lavarel's commonly used statements. For more information, please follow other related articles on the PHP Chinese website! Statement of this Website The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn Hot AI Tools Undresser.AI Undress AI-powered app for creating realistic nude photos AI Clothes Remover Online AI tool for removing clothes from photos. Undress AI Tool Undress images for free Clothoff.io AI clothes remover Video Face Swap Swap faces in any video effortlessly with our completely free AI face swap tool! Show More Hot Article Assassin's Creed Shadows: Seashell Riddle Solution 3 weeks ago By DDD What's New in Windows 11 KB5054979 & How to Fix Update Issues 2 weeks ago By DDD Where to find the Crane Control Keycard in Atomfall 3 weeks ago By DDD Assassin's Creed Shadows - How To Find The Blacksmith And Unlock Weapon And Armour Customisation 1 months ago By DDD Roblox: Dead Rails - How To Complete Every Challenge 3 weeks ago By DDD Show More Hot Tools Notepad++7.3.1 Easy-to-use and free code editor SublimeText3 Chinese version Chinese version, very easy to use Zend Studio 13.0.1 Powerful PHP integrated development environment Dreamweaver CS6 Visual web development tools SublimeText3 Mac version God-level code editing software (SublimeText3) Show More Hot Topics Where is the login entrance for gmail email? 7606 15 CakePHP Tutorial 1387 52 What is the format of the account name of steam 88 11 win11 activation key permanent 68 19 nyt connections hints and answers 29 135 Show More Related knowledge Learn the canvas framework and explain the commonly used canvas framework in detail Jan 17, 2024 am 11:03 AM Explore the Canvas framework: To understand what are the commonly used Canvas frameworks, specific code examples are required. Introduction: Canvas is a drawing API provided in HTML5, through which we can achieve rich graphics and animation effects. In order to improve the efficiency and convenience of drawing, many developers have developed different Canvas frameworks. This article will introduce some commonly used Canvas frameworks and provide specific code examples to help readers gain a deeper understanding of how to use these frameworks. 1. EaselJS framework Ea Spring Annotation Revealed: Analysis of Common Annotations Dec 30, 2023 am 11:28 AM Spring is an open source framework that provides many annotations to simplify and enhance Java development. This article will explain commonly used Spring annotations in detail and provide specific code examples. @Autowired: Autowired @Autowired annotation can be used to automatically wire beans in the Spring container. When we use the @Autowired annotation where dependencies are required, Spring will find matching beans in the container and automatically inject them. The sample code is as follows: @Auto 15 commonly used currency circle escape index technology analysis Mar 03, 2025 pm 05:48 PM In-depth analysis of the top 15 Bitcoin Escape Index: Market Outlook for 2025 This article deeply analyzes fifteen commonly used Bitcoin Escape Index, among which the Bitcoin Rhodl ratio, USDT current wealth management and altcoin seasonal index have reached the Escape Index in 2024, attracting market attention. How should investors deal with potential risks? Let us interpret these indicators one by one and explore reasonable response strategies. 1. Detailed explanation of key indicators AHR999 coin hoarding indicator: Created by ahr999, assisting Bitcoin fixed investment strategy. The current value is 1.21, which is in the wait-and-see range, so it is recommended to be cautious. Link to AHR999 Escape Top Indicator: A supplement to AHR999 Coin Hoarding Indicator, used to identify the top of the market. The current value is 2.48, this week What are the commonly used encryption algorithms in PHP? May 12, 2023 pm 06:51 PM With the development of the Internet, data security has become a serious issue that we must pay attention to in our daily work. Encryption becomes especially important when it comes to sensitive personal information or business data. In PHP development, some encryption algorithms are widely used. Let's take a look at the encryption algorithms commonly used in PHP. 1. Base64 encoding Base64 encoding is often used to transmit binary data in web pages or emails, because web pages or emails can only transmit string type data and cannot directly transmit binary data. Base64 is a solution Introduction to common data types in Oracle database Mar 08, 2024 am 09:45 AM Oracle database is a commonly used relational database management system that supports multiple data types to meet different needs. When using Oracle database, it is very important to understand the data types of the database. This article will introduce the commonly used data types in Oracle database, with specific code examples. 1. Numeric data type NUMBERNUMBER is the most commonly used numeric data type in Oracle database, used to store integers or floating point numbers. The NUMBER data type can specify precision What are the commonly used functions in Go language? Mar 28, 2024 pm 02:45 PM What are the commonly used functions in Go language? ——Explore commonly used functions and their usage in Go language. As a popular statically typed programming language, Go language is widely used in various fields, such as server-side development, network programming, cloud computing, etc. In the Go language, functions, as the basic code organization unit, are an important part of program running. This article will explore the commonly used functions and their usage in the Go language to help readers better grasp the core features of this language. 1. Function declaration and calling functions in Go language with the keyword "fun Laravel development: How to use Laravel Migration to manage database migrations? Jun 13, 2023 pm 03:20 PM In Laravel development, database management is a very important part. LaravelMigration provides a convenient way to manage database migration. Next, let us learn how to use LaravelMigration to manage database migration. What is LaravelMigration? LaravelMigration is a tool used to manage database migration. It can be used to record all modification operations on the database, including creation Which is more commonly used in DevOps: Ruby or Python? Aug 19, 2023 am 11:41 AM The field of software development has changed dramatically over a long period of time, and DevOps has become an essential part of the modern computer program delivery process. To streamline the process of developing and operating computer programs, DevOps fosters a culture of collaboration, continuous integration, and non-stop delivery. The choice of programming language plays an important role in efficient utilization of DevOps, and two well-known contenders in this field are Ruby and Python. Here, we’ll look at the choice, popularity, and use cases of Ruby and Python in DevOps environments. We'll investigate their unique features, advantages, and disadvantages to help you decide which language is best for your DevOps needs. Section 1: Ruby and Python See all articles Public welfare online PHP training，Help PHP learners grow quickly！ About us Disclaimer Sitemap © php.cn All rights reserved