Просмотр архива AppMarket

# Dump of table activations
#
------------------------------------------------------------

CREATE TABLE
`activations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
`user_id` int(10) unsigned NOT NULL,
  `code` varchar(255) COLLATE
utf8_unicode_ci NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
 
`completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT
NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL
DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dump of table persistences
#
------------------------------------------------------------

CREATE TABLE
`persistences` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
`user_id` int(10) unsigned NOT NULL,
  `code` varchar(255) COLLATE
utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT
'0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT
'0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY
`persistences_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;

# Dump of table reminders
#
------------------------------------------------------------

CREATE TABLE
`reminders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id`
int(10) unsigned NOT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci
NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `completed_at`
timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT
'0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT
'0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci;

# Dump of table roles
#
------------------------------------------------------------

CREATE TABLE
`roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `slug`
varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255)
COLLATE utf8_unicode_ci NOT NULL,
  `permissions` text COLLATE
utf8_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00
00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00
00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique`
(`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
Dump of table role_users
#
------------------------------------------------------------

CREATE TABLE
`role_users` (
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10)
unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
 
`updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY
(`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;

# Dump of table throttle
#
------------------------------------------------------------

CREATE TABLE
`throttle` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id`
int(10) unsigned DEFAULT NULL,
  `type` varchar(255) COLLATE
utf8_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci
DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00
00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00
00:00:00',
  PRIMARY KEY (`id`),
  KEY `throttle_user_id_index`
(`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;

# Dump of table users
#
------------------------------------------------------------

CREATE TABLE
`users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email`
varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255)
COLLATE utf8_unicode_ci NOT NULL,
  `permissions` text COLLATE
utf8_unicode_ci,
  `last_login` timestamp NULL DEFAULT NULL,
  `first_name`
varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name`
varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp
NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL
DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY
`users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;