1 В избранное 0 Ответвления 0

OSCHINA-MIRROR/jiaH-yjcms

Присоединиться к Gitlife
Откройте для себя и примите участие в публичных проектах с открытым исходным кодом с участием более 10 миллионов разработчиков. Приватные репозитории также полностью бесплатны :)
Присоединиться бесплатно
В этом репозитории не указан файл с открытой лицензией (LICENSE). При использовании обратитесь к конкретному описанию проекта и его зависимостям в коде.
Клонировать/Скачать
db.sql 18 КБ
Копировать Редактировать Web IDE Исходные данные Просмотреть построчно История
jiaHey Отправлено 28.03.2018 11:57 39d32ce
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626
-- phpMyAdmin SQL Dump
-- version 4.7.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: 2018-03-28 16:47:37
-- 服务器版本: 5.6.35
-- PHP Version: 7.1.8
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `cms`
--
-- --------------------------------------------------------
--
-- 表的结构 `admin_menu`
--
CREATE TABLE `admin_menu` (
`id` int(10) UNSIGNED NOT NULL,
`parent_id` int(11) NOT NULL DEFAULT '0',
`order` int(11) NOT NULL DEFAULT '0',
`title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`uri` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `admin_menu`
--
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `created_at`, `updated_at`) VALUES
(1, 0, 1, '首页', 'fa-bar-chart', '/', NULL, '2018-03-28 07:58:59'),
(2, 0, 2, '后台管理', 'fa-tasks', NULL, NULL, '2018-03-28 07:51:28'),
(3, 2, 3, '用户管理', 'fa-users', 'auth/users', NULL, '2018-03-28 07:51:33'),
(4, 2, 4, '角色管理', 'fa-user', 'auth/roles', NULL, '2018-03-28 07:51:43'),
(5, 2, 5, '权限管理', 'fa-ban', 'auth/permissions', NULL, '2018-03-28 07:51:51'),
(6, 2, 6, '菜单管理', 'fa-bars', 'auth/menu', NULL, '2018-03-28 07:51:56'),
(7, 2, 7, '后台操作', 'fa-history', 'auth/logs', NULL, '2018-03-28 07:52:05'),
(8, 0, 0, '模块管理', 'fa-battery-4', 'menu', '2018-03-28 07:59:36', '2018-03-28 07:59:36');
-- --------------------------------------------------------
--
-- 表的结构 `admin_operation_log`
--
CREATE TABLE `admin_operation_log` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(11) NOT NULL,
`path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`ip` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
`input` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `admin_permissions`
--
CREATE TABLE `admin_permissions` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`http_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`http_path` text COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `admin_permissions`
--
INSERT INTO `admin_permissions` (`id`, `name`, `slug`, `http_method`, `http_path`, `created_at`, `updated_at`) VALUES
(1, 'All permission', '*', '', '*', NULL, NULL),
(2, 'Dashboard', 'dashboard', 'GET', '/', NULL, NULL),
(3, 'Login', 'auth.login', '', '/auth/login\r\n/auth/logout', NULL, NULL),
(4, 'User setting', 'auth.setting', 'GET,PUT', '/auth/setting', NULL, NULL),
(5, 'Auth management', 'auth.management', '', '/auth/roles\r\n/auth/permissions\r\n/auth/menu\r\n/auth/logs', NULL, NULL);
-- --------------------------------------------------------
--
-- 表的结构 `admin_roles`
--
CREATE TABLE `admin_roles` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `admin_roles`
--
INSERT INTO `admin_roles` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'Administrator', 'administrator', '2018-01-13 09:48:08', '2018-01-13 09:48:08');
-- --------------------------------------------------------
--
-- 表的结构 `admin_role_menu`
--
CREATE TABLE `admin_role_menu` (
`role_id` int(11) NOT NULL,
`menu_id` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `admin_role_menu`
--
INSERT INTO `admin_role_menu` (`role_id`, `menu_id`, `created_at`, `updated_at`) VALUES
(1, 2, NULL, NULL);
-- --------------------------------------------------------
--
-- 表的结构 `admin_role_permissions`
--
CREATE TABLE `admin_role_permissions` (
`role_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `admin_role_permissions`
--
INSERT INTO `admin_role_permissions` (`role_id`, `permission_id`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL);
-- --------------------------------------------------------
--
-- 表的结构 `admin_role_users`
--
CREATE TABLE `admin_role_users` (
`role_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `admin_role_users`
--
INSERT INTO `admin_role_users` (`role_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL);
-- --------------------------------------------------------
--
-- 表的结构 `admin_users`
--
CREATE TABLE `admin_users` (
`id` int(10) UNSIGNED NOT NULL,
`username` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `admin_users`
--
INSERT INTO `admin_users` (`id`, `username`, `password`, `name`, `avatar`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'admin', '$2y$10$KGazJI7mPswiOYTMEBbVgeixVbNKPVp00q7YV5vkfbpI5O769/tfm', 'Administrator', NULL, NULL, '2018-01-13 09:48:08', '2018-01-13 09:48:08');
-- --------------------------------------------------------
--
-- 表的结构 `admin_user_permissions`
--
CREATE TABLE `admin_user_permissions` (
`user_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `cms_config`
--
CREATE TABLE `cms_config` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`value` text COLLATE utf8mb4_unicode_ci,
`remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`menu_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `cms_friend`
--
CREATE TABLE `cms_friend` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `cms_menu`
--
CREATE TABLE `cms_menu` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`en_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`content` text COLLATE utf8mb4_unicode_ci,
`type` tinyint(4) NOT NULL DEFAULT '0',
`parentId` int(10) UNSIGNED DEFAULT '0',
`listTpl` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`newsTpl` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`newsEditShow` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`newsExtraEditShow` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`seoTitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`seoDes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`seoKey` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'zh-cn' COMMENT '语言',
`isShow` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
`sort` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `cms_menu`
--
INSERT INTO `cms_menu` (`id`, `title`, `url`, `en_title`, `content`, `type`, `parentId`, `listTpl`, `newsTpl`, `newsEditShow`, `newsExtraEditShow`, `pic`, `seoTitle`, `seoDes`, `seoKey`, `lang`, `isShow`, `sort`, `created_at`, `updated_at`) VALUES
(1, '首页', '/', NULL, NULL, 4, 0, 'index', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'zh-cn', 1, 0, '2018-01-13 09:55:53', '2018-01-13 09:55:53'),
(2, '文章列表', NULL, NULL, NULL, 4, 0, 'post', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'zh-cn', 1, 0, '2018-03-28 08:00:33', '2018-03-28 08:00:33');
-- --------------------------------------------------------
--
-- 表的结构 `cms_news`
--
CREATE TABLE `cms_news` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sub_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pic_detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`content` text COLLATE utf8mb4_unicode_ci,
`menu_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
`sort` int(11) NOT NULL DEFAULT '0',
`isShow` int(10) UNSIGNED NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `cms_news`
--
INSERT INTO `cms_news` (`id`, `title`, `sub_title`, `pic`, `pic_detail`, `content`, `menu_id`, `sort`, `isShow`, `created_at`, `updated_at`) VALUES
(1, '文字一', NULL, NULL, NULL, NULL, 2, 1, 0, '2018-03-28 08:45:29', '2018-03-28 08:45:29');
-- --------------------------------------------------------
--
-- 表的结构 `cms_news_extra`
--
CREATE TABLE `cms_news_extra` (
`id` int(10) UNSIGNED NOT NULL,
`news_id` int(10) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`content` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `cms_news_gallery`
--
CREATE TABLE `cms_news_gallery` (
`id` int(10) UNSIGNED NOT NULL,
`news_id` int(10) UNSIGNED NOT NULL,
`pic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`thumPic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `cms_news_tags`
--
CREATE TABLE `cms_news_tags` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `cms_resource`
--
CREATE TABLE `cms_resource` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `cms_r_menu_tags`
--
CREATE TABLE `cms_r_menu_tags` (
`menu_id` int(10) UNSIGNED NOT NULL,
`menu_tags_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `cms_r_news_tags`
--
CREATE TABLE `cms_r_news_tags` (
`news_id` int(10) UNSIGNED NOT NULL,
`news_tags_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `cms_slide`
--
CREATE TABLE `cms_slide` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`menu_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
`pic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`isShow` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 表的结构 `migrations`
--
CREATE TABLE `migrations` (
`id` int(10) UNSIGNED NOT NULL,
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 转存表中的数据 `migrations`
--
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2016_01_04_173148_create_admin_tables', 1);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `admin_menu`
--
ALTER TABLE `admin_menu`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `admin_operation_log`
--
ALTER TABLE `admin_operation_log`
ADD PRIMARY KEY (`id`),
ADD KEY `admin_operation_log_user_id_index` (`user_id`);
--
-- Indexes for table `admin_permissions`
--
ALTER TABLE `admin_permissions`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `admin_permissions_name_unique` (`name`);
--
-- Indexes for table `admin_roles`
--
ALTER TABLE `admin_roles`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `admin_roles_name_unique` (`name`);
--
-- Indexes for table `admin_role_menu`
--
ALTER TABLE `admin_role_menu`
ADD KEY `admin_role_menu_role_id_menu_id_index` (`role_id`,`menu_id`);
--
-- Indexes for table `admin_role_permissions`
--
ALTER TABLE `admin_role_permissions`
ADD KEY `admin_role_permissions_role_id_permission_id_index` (`role_id`,`permission_id`);
--
-- Indexes for table `admin_role_users`
--
ALTER TABLE `admin_role_users`
ADD KEY `admin_role_users_role_id_user_id_index` (`role_id`,`user_id`);
--
-- Indexes for table `admin_users`
--
ALTER TABLE `admin_users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `admin_users_username_unique` (`username`);
--
-- Indexes for table `admin_user_permissions`
--
ALTER TABLE `admin_user_permissions`
ADD KEY `admin_user_permissions_user_id_permission_id_index` (`user_id`,`permission_id`);
--
-- Indexes for table `cms_config`
--
ALTER TABLE `cms_config`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`);
--
-- Indexes for table `cms_friend`
--
ALTER TABLE `cms_friend`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `cms_menu`
--
ALTER TABLE `cms_menu`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `cms_news`
--
ALTER TABLE `cms_news`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `cms_news_extra`
--
ALTER TABLE `cms_news_extra`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `cms_news_gallery`
--
ALTER TABLE `cms_news_gallery`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `cms_news_tags`
--
ALTER TABLE `cms_news_tags`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `cms_resource`
--
ALTER TABLE `cms_resource`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `cms_r_menu_tags`
--
ALTER TABLE `cms_r_menu_tags`
ADD PRIMARY KEY (`menu_id`,`menu_tags_id`);
--
-- Indexes for table `cms_r_news_tags`
--
ALTER TABLE `cms_r_news_tags`
ADD PRIMARY KEY (`news_id`,`news_tags_id`);
--
-- Indexes for table `cms_slide`
--
ALTER TABLE `cms_slide`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- 在导出的表使用AUTO_INCREMENT
--
--
-- 使用表AUTO_INCREMENT `admin_menu`
--
ALTER TABLE `admin_menu`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- 使用表AUTO_INCREMENT `admin_operation_log`
--
ALTER TABLE `admin_operation_log`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `admin_permissions`
--
ALTER TABLE `admin_permissions`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- 使用表AUTO_INCREMENT `admin_roles`
--
ALTER TABLE `admin_roles`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `admin_users`
--
ALTER TABLE `admin_users`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `cms_config`
--
ALTER TABLE `cms_config`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cms_friend`
--
ALTER TABLE `cms_friend`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cms_menu`
--
ALTER TABLE `cms_menu`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `cms_news`
--
ALTER TABLE `cms_news`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `cms_news_extra`
--
ALTER TABLE `cms_news_extra`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cms_news_gallery`
--
ALTER TABLE `cms_news_gallery`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cms_news_tags`
--
ALTER TABLE `cms_news_tags`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cms_resource`
--
ALTER TABLE `cms_resource`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cms_slide`
--
ALTER TABLE `cms_slide`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

Опубликовать ( 0 )

Вы можете оставить комментарий после Вход в систему

1
https://api.gitlife.ru/oschina-mirror/jiaH-yjcms.git
git@api.gitlife.ru:oschina-mirror/jiaH-yjcms.git
oschina-mirror
jiaH-yjcms
jiaH-yjcms
master