1 | -- MySQL dump 10.13 Distrib 5.1.72, for debian-linux-gnu (i486) |
2 | -- |
3 | -- Host: localhost Database: ican |
4 | -- ------------------------------------------------------ |
5 | -- Server version 5.1.72-2 |
6 | |
7 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
8 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
9 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
10 | /*!40101 SET NAMES utf8 */; |
11 | /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; |
12 | /*!40103 SET TIME_ZONE='+00:00' */; |
13 | /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
14 | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
15 | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; |
16 | /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
17 | |
18 | -- |
19 | -- Table structure for table `demotable` |
20 | -- |
21 | |
22 | DROP TABLE IF EXISTS `demotable`; |
23 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
24 | /*!40101 SET character_set_client = utf8 */; |
25 | [[CREATE TABLE `demotable` ( |
26 | `dt_id` int(11) NOT NULL AUTO_INCREMENT, |
27 | `dt_hello` text NOT NULL, |
28 | PRIMARY KEY (`dt_id`) |
29 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;]] |
30 | /*!40101 SET character_set_client = @saved_cs_client */; |
31 | |
32 | -- |
33 | -- Dumping data for table `demotable` |
34 | -- |
35 | |
36 | LOCK TABLES `demotable` WRITE; |
37 | /*!40000 ALTER TABLE `demotable` DISABLE KEYS */; |
38 | /*!40000 ALTER TABLE `demotable` ENABLE KEYS */; |
39 | UNLOCK TABLES; |
40 | |
41 | -- |
42 | -- Table structure for table `demotable2` |
43 | -- |
44 | |
45 | DROP TABLE IF EXISTS `demotable2`; |
46 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
47 | /*!40101 SET character_set_client = utf8 */; |
48 | [[CREATE TABLE `demotable2` ( |
49 | `dt2_a` int(11) NOT NULL, |
50 | `dt2_b` date NOT NULL, |
51 | `dt2_c` text NOT NULL |
52 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;]] |
53 | /*!40101 SET character_set_client = @saved_cs_client */; |
54 | |
55 | -- |
56 | -- Dumping data for table `demotable2` |
57 | -- |
58 | |
59 | LOCK TABLES `demotable2` WRITE; |
60 | /*!40000 ALTER TABLE `demotable2` DISABLE KEYS */; |
61 | /*!40000 ALTER TABLE `demotable2` ENABLE KEYS */; |
62 | UNLOCK TABLES; |
63 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
64 | |
65 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
66 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
67 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
68 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
69 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
70 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
71 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
72 | |
73 | -- Dump completed on 2015-08-20 15:22:28 |
Began life as a copy of #3000012
Snippet is not live.
Travelled to 14 computer(s): aoiabmzegqzx, bhatertpkbcr, cbybwowwnfue, ddnzoavkxhuk, gwrvuhgaqvyk, ishqpsrjomds, lpdgvwnxivlt, mqqgnosmbjvj, pyentgdyhuwx, pzhvpgtvlbxg, tslmcundralx, tvejysmllsmz, vouqrxazstgt, xrpafgyirdlv
No comments. add comment
| Snippet ID: | #2000522 |
| Snippet name: | create table statements marked |
| Eternal ID of this version: | #2000522/1 |
| Text MD5: | 1d2061a3c3efb23912daa9c64e213d7b |
| Author: | stefan |
| Category: | |
| Type: | New Tinybrain snippet |
| Public (visible to everyone): | Yes |
| Archived (hidden from active list): | No |
| Created/modified: | 2015-08-20 20:59:06 |
| Source code size: | 2526 bytes / 73 lines |
| Pitched / IR pitched: | No / Yes |
| Views / Downloads: | 635 / 202 |
| Referenced in: | [show references] |