· 8 years ago · Jun 08, 2018, 07:50 PM
1+++ Constant.sql 2012-01-27 18:28:38 +0000
2@@ -1,7 +1,3 @@
3--- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (x86_64)
4---
5--- Host: db2.linux-foundation.org Database: lsb
6--- ------------------------------------------------------
7
8 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10@@ -13,29 +9,20 @@
11 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
14-
15---
16--- Not dumping tablespaces as no INFORMATION_SCHEMA.FILES table on this server
17---
18-
19---
20--- Table structure for table `Constant`
21---
22-
23 DROP TABLE IF EXISTS `Constant`;
24 /*!40101 SET @saved_cs_client = @@character_set_client */;
25 /*!40101 SET character_set_client = utf8 */;
26 CREATE TABLE `Constant` (
27- `Cid` int(10) unsigned NOT NULL auto_increment,
28- `Cname` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
29- `Ctype` enum('int','long','float','double','longdouble','string','macro','accessor','protector','flag','literal','Unknown','header_depend','version') NOT NULL default 'Unknown',
30- `Cheadgroup` int(10) unsigned NOT NULL default '0',
31- `Cdescription` varchar(255) NOT NULL default '',
32- `Ccandidatefor` varchar(255) default NULL,
33- PRIMARY KEY (`Cid`),
34+ `Cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
35+ `Cname` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
36+ `Ctype` enum('int','long','float','double','longdouble','string','macro','accessor','protector','flag','literal','Unknown','header_depend','version','limit') NOT NULL DEFAULT 'Unknown',
37+ `Cheadgroup` int(10) unsigned NOT NULL DEFAULT '0',
38+ `Cdescription` varchar(255) NOT NULL DEFAULT '',
39+ `Ccandidatefor` varchar(255) DEFAULT NULL,
40+ PRIMARY KEY (`Cid`),
41 UNIQUE KEY `k_Cname` (`Cname`,`Cheadgroup`),
42 KEY `k_Cheadgroup` (`Cheadgroup`,`Ctype`)
43-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
44+) ENGINE=MyISAM AUTO_INCREMENT=20672 DEFAULT CHARSET=latin1;
45 /*!40101 SET character_set_client = @saved_cs_client */;
46 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
47
48@@ -47,4 +34,3 @@
49 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
50 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
51
52--- Dump completed