forked from xiajingren/EFDynamicDatabaseBuilding
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmasterdb-mysql.sql
More file actions
52 lines (44 loc) · 3.74 KB
/
masterdb-mysql.sql
File metadata and controls
52 lines (44 loc) · 3.74 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50720
Source Host : localhost:3306
Source Database : masterdb
Target Server Type : MYSQL
Target Server Version : 50720
File Encoding : 65001
Date: 2020-02-27 12:01:25
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for enterprises
-- ----------------------------
DROP TABLE IF EXISTS `enterprises`;
CREATE TABLE `enterprises` (
`ID` char(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`Name` varchar(50) NOT NULL,
`DBName` varchar(100) NOT NULL,
`AdminAccount` varchar(20) NOT NULL,
`AdminPassword` varchar(50) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of enterprises
-- ----------------------------
INSERT INTO `enterprises` VALUES ('38576825-8f39-46b4-8ce1-ec93e853eaf4', '企业A', 'BusinessDB637183983275157595', 'aa', '123456');
INSERT INTO `enterprises` VALUES ('d20728ee-a3c1-46f7-97b8-2354e004a897', '企业B', 'BusinessDB637184000368269563', 'bb', '123456');
-- ----------------------------
-- Table structure for __migrationhistory
-- ----------------------------
DROP TABLE IF EXISTS `__migrationhistory`;
CREATE TABLE `__migrationhistory` (
`MigrationId` varchar(150) NOT NULL,
`ContextKey` varchar(300) NOT NULL,
`Model` longblob NOT NULL,
`ProductVersion` varchar(32) NOT NULL,
PRIMARY KEY (`MigrationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of __migrationhistory
-- ----------------------------
INSERT INTO `__migrationhistory` VALUES ('202002261408141_AutomaticMigration', 'XHZNL.EFDynamicDatabaseBuilding.MasterEntity.Migrations.Configuration', 0x1F8B0800000000000400CD586D6FDB3610FE3E60FF41E0E754B453145B03B98563C75DB03809EAB418F68D96CE0E318AD4482AB57FDB3EEC27ED2FECA8774BB663BB4D510408ACE3DD732FE23D77F67FFFFC1BBC5FC5C27B026DB89203D2F77BC40319AA88CBE580A476F1EA57F2FEDDCF3F055751BCF23E977AAF9D1E5A4A33208FD62617949AF0116266FC98875A19B5B07EA862CA2245CF7BBDB7B4DFA7801004B13C2FF8984ACB63C81EF071A46408894D9998AA088429E47832CB50BD5B168349580803F2C76F7FDEDEF85793F15A32F4356696CD9981CB940B17B43F65C682BE427CBB26DE50708631CE402C88C7A4549659CCE0E2938199D54A2E67090A98785827807A0B260C14995DD4EA8726D93B7749D2DAB0840A5363557C2460FF755135DA363FA9F6A4AA2AD635AF8FCB3AABED80A00074A2B94BBFEDEE6224B4533DAEF87E0D79E61D637856DD33BC8EEEEFCC1BA5C2A61A061252AB9938F3EED3B9E0E1EFB07E507F811CC85488667E98219E6D085074AF5502DAAE3FC2A2C8FA7A4C3CBA6947DB869559C326AFC6879447C4BB45DF6C2EA0BA3D74AFB9FB5F02E015C4E4893765AB1B904BFB38206FB0B1267C05512928403F498E5D893656A770B4D3F1E5336EFBBD17F13B8C622E8761A8B0DFF7783F7F39E7F7CC982F4A472F5CF280D61DD5ED33E437CBB8045D4496DFF6F1A593C3CA6EE938E4A7A2E94CE17F33D51C7706B6D3BE8678752839F3F9CDE6DE1675155F4DBC3467DE92A1E90E8A0EA62C49B0A00DCA2E24DE2CE7EBD1ABD9F17415E71834345B58AB8AB6F26495664B689DA26B8C74C2B5B125DD106F14C51DB5F6DBD851E9D25BB7E06D9EA9EB5FDAB8CFB9DD890CDAF651D77982A9C7206D5605A8A2DD60F48E71365999607A0BB78D944863B98B1FF759E71CD3B4CF258723943CD5C4286587A36CB24E136BF3E448C49A4A3A90F5511733A0AD37D5BE2EB4735F5A13A97D05F775705BA5F25E7572AB6383A27B9EDFBC3AED94AB100F8BF5C4A3AC95D6B3BF85EFCEFDECE3487070952E35A64CF205189B4F6DF2C6FFA5B5A2FD38EB1235261207EF4CDF7DF7587EEDEE219F980E1F99EE8CC2AF5A2DB6A266CBC537D81CB6829F9F88DD5E0C4EABC77173BF3B900E9DEACF0CF5BC1307249A2BCC278F7663253871EA77B921A0CDEF6EC1180C5FD610EE9B9C84D0355D0D5AEA5CCB852ADF04E6D88CA85469BDA829581661A986DAF2050B2D1E87604CB6C07D66227559C67388AEE55D6A93D40E8D81782ED6CD7C03BADF7FB6DA6CC61CDC25EEC97C8B14304C8E29C09DCC467C15F764CB5DDA01E16ECD0740794666B8C022DC725D21DD2A79205051BE31242023E4E50788138160E64ECED8139C121BEEA937B064E1BA64F8DD20CFBF88CDB20763CE969AC5A6C0A8EDDDEF11D4FD20F1EE7F85A056F1C2100000, '6.4.0');