Bugzilla – Attachment 112594 Details for
Bug 85190
REPORTBUILDER - cannot deal with MySQL bogus '0000-00-00' date and timestamps
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
sql dump
actiontypedump.sql (text/plain), 1.88 KB, created by
Alex Thurgood
on 2015-01-21 10:29:22 UTC
(
hide
)
Description:
sql dump
Filename:
MIME Type:
Creator:
Alex Thurgood
Created:
2015-01-21 10:29:22 UTC
Size:
1.88 KB
patch
obsolete
>-- MySQL dump 10.13 Distrib 5.6.20, for osx10.8 (x86_64) >-- >-- Host: 10.0.0.4 Database: ipdatabase >-- ------------------------------------------------------ >-- Server version 5.6.19-log > >/*!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 `action_type` >-- > >DROP TABLE IF EXISTS `action_type`; >/*!40101 SET @saved_cs_client = @@character_set_client */; >/*!40101 SET character_set_client = utf8 */; >CREATE TABLE `action_type` ( > `type` varchar(15) NOT NULL DEFAULT '', > `comments` varchar(40) DEFAULT NULL, > `action_type_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, > `chg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, > PRIMARY KEY (`action_type_id`) >) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; >/*!40101 SET character_set_client = @saved_cs_client */; > >-- >-- Dumping data for table `action_type` >-- > >LOCK TABLES `action_type` WRITE; >/*!40000 ALTER TABLE `action_type` DISABLE KEYS */; >INSERT INTO `action_type` VALUES ('A.94(3) EPC','Normal Examining Division communication',1,'0000-00-00 00:00:00'),('R.71(3) EPC','Intention to grant communication',2,'0000-00-00 00:00:00'),('R.51(6) EPC','Notice of grant communication\0',3,'2013-01-10 16:15:00'),('A.121 EPC','Further processing',4,'2013-01-10 16:56:28'); >/*!40000 ALTER TABLE `action_type` ENABLE KEYS */; >UNLOCK TABLES; > > >-- Dump completed on 2015-01-21 11:23:12
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 85190
:
108062
| 112594 |
112597
|
112603