-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtest_student.sql
60 lines (53 loc) · 11.1 KB
/
test_student.sql
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
53
54
55
56
57
58
59
60
CREATE DATABASE IF NOT EXISTS `test` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `test`;
-- MySQL dump 10.13 Distrib 5.7.9, for osx10.9 (x86_64)
--
-- Host: localhost Database: test
-- ------------------------------------------------------
-- Server version 5.7.11
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `student`
--
DROP TABLE IF EXISTS `student`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(45) NOT NULL,
`sname` varchar(45) DEFAULT NULL,
`comment` varchar(45) DEFAULT NULL,
`status` tinyint(1) DEFAULT NULL,
`student_role_id` int(11) DEFAULT NULL,
`create_time` int(11) DEFAULT NULL,
`last_login_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code_UNIQUE` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `student`
--
LOCK TABLES `student` WRITE;
/*!40000 ALTER TABLE `student` DISABLE KEYS */;
INSERT INTO `student` VALUES (3,'code2','test username',NULL,0,0,1469547135,0),(5,'745507392','student name 0','47f3c8bb-2daf-4903-8009-82350268dd1f',1,2,1469628163,0),(6,'745507432','student name 1','157f2382-11af-4158-83bb-4a3ddc2d0fee',1,1,1469628163,0),(7,'745507440','student name 2','8cd2b7f5-ffbf-472b-9ce9-2fa82b856096',1,3,1469628163,0),(8,'745507448','student name 3','e45a9445-3bff-4b07-99d3-0315bf311933',1,2,1469628163,0),(9,'745507456','student name 4','cb47d6c5-752f-4dd8-9c55-47d619800f2a',1,1,1469628163,0),(10,'745507464','student name 5','f3e0985f-1eb9-4092-90e0-80e75823a67f',1,3,1469628163,0),(11,'745507472','student name 6','da6a9197-8a38-44ff-bb25-5e661a621976',1,3,1469628163,0),(12,'745507488','student name 7','58602886-3c47-47de-aac8-cd66bed35a3a',1,1,1469628163,0),(13,'745507504','student name 8','69f5fc1b-f5a6-496b-bd74-da5796a55aa2',1,3,1469628163,0),(14,'745507512','student name 9','3e9832f0-7dd3-4539-ba69-c745163d5a4f',1,3,1469628163,0),(15,'745507520','student name 10','ef60497f-7785-45ac-b00b-7bb5c9834770',1,1,1469628163,0),(16,'745507528','student name 11','0feaa750-e21c-4246-b3b8-079f703cd981',1,1,1469628163,0),(17,'745507536','student name 12','d15ced8a-7e7a-4161-95ef-44b4cf3fa1e9',1,2,1469628163,0),(18,'745507544','student name 13','b39e97d6-f802-4d0a-9eea-3970107306c8',1,1,1469628163,0),(19,'745507552','student name 14','b0429570-7cfd-45e7-9d7e-98580e27f919',1,1,1469628163,0),(20,'745507560','student name 15','8a1bbf91-22a8-4340-b73a-c521b4629f7f',1,2,1469628163,0),(21,'745507568','student name 16','05ef22e2-b344-4b22-a625-c09e81cbff14',1,3,1469628163,0),(22,'745507576','student name 17','9d4f9618-c146-449d-a951-9672679c0be2',1,2,1469628163,0),(23,'745507577','student name 18','5da723dd-370a-49c2-87e9-d35af3a58c2c',1,1,1469628163,0),(24,'745507584','student name 19','2008539f-ef46-49e7-b181-5e25da8ee8df',1,3,1469628163,0),(25,'745507592','student name 20','e7ba6981-6b42-4a0b-a4c5-fe6d8ee453bb',1,1,1469628163,0),(26,'745507593','student name 21','40181873-c607-4f98-bcf1-87586ee61c02',1,2,1469628163,0),(27,'745507600','student name 22','69a0102f-177c-4526-9be2-a665681e2c22',1,3,1469628163,0),(28,'745507608','student name 23','2fdfa3eb-1e76-4360-8268-25e1450372df',1,1,1469628163,0),(29,'745507609','student name 24','d0519e33-a0fe-4201-a218-b79642a0a19f',1,2,1469628163,0),(30,'745507624','student name 25','d87cf00f-4f9f-412e-99ed-a0c652940bb4',1,2,1469628163,0),(31,'745507640','student name 26','bdab4c07-fd88-49cb-95c5-64e097fbf1f5',1,3,1469628163,0),(32,'745507648','student name 27','960f293c-8117-48e0-9634-4549bcbb0b0b',1,3,1469628163,0),(33,'745507649','student name 28','1d9d16b2-3e8b-40b2-b8e8-aee2484e7a68',1,3,1469628163,0),(34,'745507656','student name 29','85ffcfa2-c501-4712-bb80-fb05c4b89b19',1,1,1469628163,0),(35,'745507664','student name 30','d1efa933-314c-4bed-8d4f-92af025289e6',1,1,1469628163,0),(36,'745507665','student name 31','585a0ccc-2ea4-4230-a1c9-d729a6473989',1,1,1469628163,0),(37,'745507672','student name 32','031c6bd6-9dcb-4ba3-acb1-57f11e9926ff',1,3,1469628163,0),(38,'745507680','student name 33','bd34581e-2e1d-4f3a-b60e-371e34a4a2b2',1,2,1469628163,0),(39,'745507688','student name 34','88da54ec-feff-4310-9622-d579001aee67',1,2,1469628163,0),(40,'745507696','student name 35','3308df90-a8f9-486b-b860-da8c10068ec8',1,1,1469628163,0),(41,'745507697','student name 36','c74a30bf-60a3-45ef-8b65-a5321fc41c88',1,1,1469628163,0),(42,'745507704','student name 37','cd74acd4-5666-4992-b39b-0ee5e0305b77',1,1,1469628163,0),(43,'745507712','student name 38','a208074a-3010-4509-8183-12fb734f127f',1,3,1469628163,0),(44,'745507713','student name 39','b5ecb51f-a255-4d9a-81e9-05aa32ee83e1',1,2,1469628163,0),(45,'745507720','student name 40','c1dbc86e-b521-42c9-a96d-7c97a4274f96',1,3,1469628163,0),(46,'745507728','student name 41','e14f384f-8148-40fe-aff5-33eb38d7418b',1,3,1469628163,0),(47,'745507729','student name 42','f18f6d99-e8ff-4e39-ad8a-ce66aea50947',1,3,1469628163,0),(48,'745507736','student name 43','bfd3809e-270b-4161-ae51-ac55ca724354',1,2,1469628163,0),(49,'745507760','student name 44','23a5aac2-0b82-4321-adc7-8c455c4c8102',1,1,1469628163,0),(50,'745507768','student name 45','19fbb2b4-7b22-45ec-99fb-f7f11a116f91',1,2,1469628163,0),(51,'745507776','student name 46','7de9cbe1-0a14-4655-9b91-72231cba61f0',1,3,1469628163,0),(52,'745507792','student name 47','d74871f2-a26d-4eff-8b11-5eae014a40dd',1,3,1469628163,0),(53,'745507800','student name 48','0fc71cf2-0d0a-4c9d-8ec0-ab80fdbefc42',1,2,1469628163,0),(54,'745507801','student name 49','a80285f6-9915-458b-906f-c934c7094744',1,2,1469628163,0),(55,'745507816','student name 50','65b4ac83-400b-4e45-a4f6-3d671edc63f2',1,1,1469628163,0),(56,'745507817','student name 51','d9dfad4c-c189-492a-a1ca-c9e22e2d08d2',1,1,1469628163,0),(57,'745507824','student name 52','0e48a958-a920-4d05-9c19-4b4e6d1ea866',1,1,1469628163,0),(58,'745507832','student name 53','25f446ad-0b60-49fd-94df-874f8525e7d9',1,2,1469628163,0),(59,'745507833','student name 54','1b7a21bd-0b13-47dd-81f0-4694bfdb0106',1,2,1469628163,0),(60,'745507840','student name 55','4e00675d-972a-416b-8ce5-7f6bae76b1d2',1,2,1469628163,0),(61,'745507848','student name 56','57590781-2624-4823-ac27-2954793f7d9d',1,1,1469628163,0),(62,'745507856','student name 57','5126aa6e-ade0-4a41-a820-a160847ae9aa',1,2,1469628163,0),(63,'745507857','student name 58','5c039f80-35ad-4011-b301-1ffd306392a7',1,1,1469628163,0),(64,'745507864','student name 59','1fe4a995-e359-465e-bfdd-2c397c4891c3',1,3,1469628163,0),(65,'745507872','student name 60','6eaa47d8-4932-4f53-8041-1933649f7b7e',1,1,1469628163,0),(66,'745507873','student name 61','e7cab683-ade3-4b91-bafc-e235541d9ba4',1,3,1469628163,0),(67,'745507888','student name 62','9ac9ffd8-48e1-49ab-b22d-0f15647b33c0',1,2,1469628163,0),(68,'745507896','student name 63','2f987128-ac71-4ccf-8752-06ad9cf7c3c6',1,3,1469628163,0),(69,'745507904','student name 64','b13eea9a-9fb3-45d7-b241-fc6b214c7dc8',1,3,1469628163,0),(70,'745507912','student name 65','346b7b89-d7e6-4caf-8571-5d5fefd2d7f0',1,2,1469628163,0),(71,'745507920','student name 66','11a0a1d3-8d07-4399-8e5a-41d3783538c8',1,2,1469628163,0),(72,'745507928','student name 67','85b7ee67-facc-4362-86ea-5594b0a7e1d0',1,1,1469628163,0),(73,'745507936','student name 68','45a73a09-d90d-48a2-81d7-c4c2828b6219',1,3,1469628163,0),(74,'745507937','student name 69','0beff519-5871-4e93-836d-d8f07c059159',1,1,1469628163,0),(75,'745507944','student name 70','1b2517ed-ddab-4c75-98f7-3e5ce41bbfa3',1,1,1469628163,0),(76,'745507952','student name 71','34e9b503-0612-4b4b-8c04-b0209bc4f8f1',1,1,1469628163,0),(77,'745507953','student name 72','129ce46b-c1d3-408d-b628-c56e52636780',1,2,1469628163,0),(78,'745507960','student name 73','8705c148-7f31-4520-a3e9-196a7bb85b5f',1,2,1469628163,0),(79,'745507961','student name 74','a536887d-26ea-4f25-b67d-07728b703be0',1,3,1469628163,0),(80,'745507968','student name 75','2872d7fe-fcc0-4f4f-862b-78114d7757af',1,2,1469628163,0),(81,'745507976','student name 76','73c21604-50cd-4773-af6b-9c9b7885a453',1,1,1469628163,0),(82,'745507977','student name 77','7d03d617-174e-4797-86df-7643e4d8f4f5',1,3,1469628163,0),(83,'745507984','student name 78','b05eb166-bbf4-43f5-b578-fd9b22b13f57',1,1,1469628163,0),(84,'745507985','student name 79','967f75fd-5b7f-4195-9dc5-383419aef99a',1,3,1469628163,0),(85,'745507992','student name 80','5cc774de-f53f-48aa-9ec8-2c461c930bb9',1,2,1469628163,0),(86,'745507993','student name 81','1991fc73-a685-4564-8838-6138625ec623',1,1,1469628163,0),(87,'745508000','student name 82','7c217d05-a0d8-4f87-b61d-5353615568cb',1,1,1469628163,0),(88,'745508008','student name 83','816ac4a8-d4e4-4783-944c-0d77bd8996dd',1,2,1469628163,0),(89,'745508016','student name 84','3e0af53e-752e-4439-9413-14c9e7495b19',1,3,1469628163,0),(90,'745508024','student name 85','fcbfda88-4beb-473f-a2cb-016b2f905d1f',1,1,1469628163,0),(91,'745508040','student name 86','6bb0bd80-f7ec-4ea0-a480-1575246c0b94',1,3,1469628163,0),(92,'745508048','student name 87','972403ef-2cb8-4262-a906-d2d5192c4882',1,1,1469628163,0),(93,'745508056','student name 88','3aae58db-6f2d-43a5-96ed-e11bddc8d66f',1,3,1469628163,0),(94,'745508064','student name 89','5ac13b50-6f87-4c29-a4ff-60e6de99d46b',1,2,1469628163,0),(95,'745508065','student name 90','06711bc6-fe50-4f13-a7a2-2190e4b607bc',1,3,1469628163,0),(96,'745508072','student name 91','378767e3-1f0a-41a6-90f9-3dec0866ee8e',1,3,1469628163,0),(97,'745508080','student name 92','45a3a816-281d-49fa-b3ba-b5585b9ad67b',1,3,1469628163,0),(98,'745508088','student name 93','d5b66e63-0b69-408a-aa3c-afd18976eaea',1,1,1469628163,0),(99,'745508096','student name 94','d8f3d4ca-3971-4740-b13f-8253bf507836',1,1,1469628163,0),(100,'745508104','student name 95','add9a3af-5049-4b04-89c9-39df41c95602',1,3,1469628163,0),(101,'745508112','student name 96','688aa677-b5a6-4a29-8faf-7c1dd126e463',1,2,1469628163,0),(102,'745508113','student name 97','05241f96-76a7-4723-9251-5dc03e4efd2f',1,2,1469628163,0),(103,'745508120','student name 98','fd99407d-a030-4db7-bd75-74c42567e971',1,3,1469628163,0),(104,'745508128','student name 99','091e6998-9a30-4930-a6a9-f32df9da0122',1,2,1469628163,0);
/*!40000 ALTER TABLE `student` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2016-07-28 19:13:40