Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- php artisan migrate
- "select * from information_schema.tables where table_schema = ? and table_name = ?"
- array:2 [
- 0 => "xlaravel"
- 1 => "migrations"
- ]
- "create table `migrations` (`id` int unsigned not null auto_increment primary key, `migration` varchar(255) not null, `batch` int not null) default character set utf8 collate utf8_unicode_ci"
- []
- Migration table created successfully.
- "select `migration` from `migrations` order by `batch` asc, `migration` asc"
- []
- "select max(`batch`) as aggregate from `migrations`"
- []
- "create table `users` (`id` int unsigned not null auto_increment primary key, `name` varchar(255) not null, `email` varchar(255) not null, `password` varchar(255) not null, `remember_token` varchar(100) null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8 collate utf8_unicode_ci"
- []
- "alter table `users` add unique `users_email_unique`(`email`)"
- []
- "insert into `migrations` (`migration`, `batch`) values (?, ?)"
- array:2 [
- 0 => "2014_10_12_000000_create_users_table"
- 1 => 1
- ]
- "create table `password_resets` (`email` varchar(255) not null, `token` varchar(255) not null, `created_at` timestamp null) default character set utf8 collate utf8_unicode_ci"
- []
- "alter table `password_resets` add index `password_resets_email_index`(`email`)"
- []
- "alter table `password_resets` add index `password_resets_token_index`(`token`)"
- []
- "insert into `migrations` (`migration`, `batch`) values (?, ?)"
- array:2 [
- 0 => "2014_10_12_100000_create_password_resets_table"
- 1 => 1
- ]
- "create table `articles` (`id` int unsigned not null auto_increment primary key, `name` varchar(100) not null, `text` text not null, `img` varchar(255) not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8 collate utf8_unicode_ci"
- []
- "insert into `migrations` (`migration`, `batch`) values (?, ?)"
- array:2 [
- 0 => "2021_02_17_174504_create_articles_table"
- 1 => 1
- ]
- "select * from information_schema.tables where table_schema = ? and table_name = ?"
- array:2 [
- 0 => "xlaravel"
- 1 => "articles"
- ]
- "select column_name from information_schema.columns where table_schema = ? and table_name = ?"
- array:2 [
- 0 => "xlaravel"
- 1 => "articles"
- ]
- "alter table `articles` add `alias` varchar(100) not null default 'default'"
- []
- "insert into `migrations` (`migration`, `batch`) values (?, ?)"
- array:2 [
- 0 => "2021_02_18_105905_change_articles_table"
- 1 => 1
- ]
- "ALTER TABLE articles CHANGE alias alias VARCHAR(255) DEFAULT 'alias' NOT NULL COLLATE utf8_unicode_ci"
- []
- "insert into `migrations` (`migration`, `batch`) values (?, ?)"
- array:2 [
- 0 => "2021_02_18_112938_change_articles_table2"
- 1 => 1
- ]
- "create table `pages` (`id` int unsigned not null auto_increment primary key, `name` varchar(255) not null, `text` text not null, `alias` text not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8 collate utf8_unicode_ci"
- []
- "insert into `migrations` (`migration`, `batch`) values (?, ?)"
- array:2 [
- 0 => "2021_02_28_150714_create_table_pages"
- 1 => 1
- ]
- Migrated: 2014_10_12_000000_create_users_table
- Migrated: 2014_10_12_100000_create_password_resets_table
- Migrated: 2021_02_17_174504_create_articles_table
- Migrated: 2021_02_18_105905_change_articles_table
- Migrated: 2021_02_18_112938_change_articles_table2
- Migrated: 2021_02_28_150714_create_table_pages
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement