Advertisement
Guest User

Untitled

a guest
Feb 20th, 2021
21
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.37 KB | None | 0 0
  1. php artisan migrate
  2. "select * from information_schema.tables where table_schema = ? and table_name = ?"
  3. array:2 [
  4. 0 => "xlaravel"
  5. 1 => "migrations"
  6. ]
  7. "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"
  8. []
  9. Migration table created successfully.
  10. "select `migration` from `migrations` order by `batch` asc, `migration` asc"
  11. []
  12. "select max(`batch`) as aggregate from `migrations`"
  13. []
  14. "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"
  15. []
  16. "alter table `users` add unique `users_email_unique`(`email`)"
  17. []
  18. "insert into `migrations` (`migration`, `batch`) values (?, ?)"
  19. array:2 [
  20. 0 => "2014_10_12_000000_create_users_table"
  21. 1 => 1
  22. ]
  23. "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"
  24. []
  25. "alter table `password_resets` add index `password_resets_email_index`(`email`)"
  26. []
  27. "alter table `password_resets` add index `password_resets_token_index`(`token`)"
  28. []
  29. "insert into `migrations` (`migration`, `batch`) values (?, ?)"
  30. array:2 [
  31. 0 => "2014_10_12_100000_create_password_resets_table"
  32. 1 => 1
  33. ]
  34. "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"
  35. []
  36. "insert into `migrations` (`migration`, `batch`) values (?, ?)"
  37. array:2 [
  38. 0 => "2021_02_17_174504_create_articles_table"
  39. 1 => 1
  40. ]
  41. "select * from information_schema.tables where table_schema = ? and table_name = ?"
  42. array:2 [
  43. 0 => "xlaravel"
  44. 1 => "articles"
  45. ]
  46. "select column_name from information_schema.columns where table_schema = ? and table_name = ?"
  47. array:2 [
  48. 0 => "xlaravel"
  49. 1 => "articles"
  50. ]
  51. "alter table `articles` add `alias` varchar(100) not null default 'default'"
  52. []
  53. "insert into `migrations` (`migration`, `batch`) values (?, ?)"
  54. array:2 [
  55. 0 => "2021_02_18_105905_change_articles_table"
  56. 1 => 1
  57. ]
  58. "ALTER TABLE articles CHANGE alias alias VARCHAR(255) DEFAULT 'alias' NOT NULL COLLATE utf8_unicode_ci"
  59. []
  60. "insert into `migrations` (`migration`, `batch`) values (?, ?)"
  61. array:2 [
  62. 0 => "2021_02_18_112938_change_articles_table2"
  63. 1 => 1
  64. ]
  65. "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"
  66. []
  67. "insert into `migrations` (`migration`, `batch`) values (?, ?)"
  68. array:2 [
  69. 0 => "2021_02_28_150714_create_table_pages"
  70. 1 => 1
  71. ]
  72. Migrated: 2014_10_12_000000_create_users_table
  73. Migrated: 2014_10_12_100000_create_password_resets_table
  74. Migrated: 2021_02_17_174504_create_articles_table
  75. Migrated: 2021_02_18_105905_change_articles_table
  76. Migrated: 2021_02_18_112938_change_articles_table2
  77. Migrated: 2021_02_28_150714_create_table_pages
  78.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement