Bugzilla – Attachment 117443 Details for
Bug 56242
Libreoffice Base should handle tables without a primary key better
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
This is the https://bugzilla.novell.com/attachment.cgi?id=251407 test case
bugtester.sql (text/plain), 3.02 KB, created by
Rolf Leggewie
on 2015-07-26 08:57:47 UTC
(
hide
)
Description:
This is the https://bugzilla.novell.com/attachment.cgi?id=251407 test case
Filename:
MIME Type:
Creator:
Rolf Leggewie
Created:
2015-07-26 08:57:47 UTC
Size:
3.02 KB
patch
obsolete
>-- MySQL dump 10.11 >-- >-- Host: rie Database: Rolf >-- ------------------------------------------------------ >-- Server version 5.0.51a-3ubuntu5.1-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 `transactions` >-- > >DROP TABLE IF EXISTS `transactions`; >SET @saved_cs_client = @@character_set_client; >SET character_set_client = utf8; >CREATE TABLE `transactions` ( > `guid` char(32) character set utf8 NOT NULL, > `currency_guid` char(32) character set utf8 NOT NULL, > `num` varchar(2048) character set utf8 NOT NULL, > `post_date` char(14) character set utf8 NOT NULL, > `enter_date` char(14) character set utf8 NOT NULL, > `description` varchar(2048) character set utf8 default NULL, > PRIMARY KEY (`guid`) >) ENGINE=MyISAM DEFAULT CHARSET=latin1; >SET character_set_client = @saved_cs_client; > >-- >-- Dumping data for table `transactions` >-- > >LOCK TABLES `transactions` WRITE; >/*!40000 ALTER TABLE `transactions` DISABLE KEYS */; >INSERT INTO `transactions` VALUES ('a9694df134b44dc843794a7534f5c7d5','d6c8ae086951e99defae8f5b966130b3','','20080413220000','20080812083602','Unitymedia'),('e77b91a13f38cd0dd3f5daf2c2d53acf','d6c8ae086951e99defae8f5b966130b3','','20080414220000','20080812083908','e-plus'); >/*!40000 ALTER TABLE `transactions` ENABLE KEYS */; >UNLOCK TABLES; > >-- >-- Table structure for table `transactions_ext` >-- > >DROP TABLE IF EXISTS `transactions_ext`; >SET @saved_cs_client = @@character_set_client; >SET character_set_client = utf8; >CREATE TABLE `transactions_ext` ( > `guid` char(32) character set utf8 NOT NULL, > `rf` tinyint(1) NOT NULL default '0' COMMENT 'VSt-taugliche Rechnung fehlt' >) ENGINE=MyISAM DEFAULT CHARSET=latin1; >SET character_set_client = @saved_cs_client; > >-- >-- Dumping data for table `transactions_ext` >-- > >LOCK TABLES `transactions_ext` WRITE; >/*!40000 ALTER TABLE `transactions_ext` DISABLE KEYS */; >INSERT INTO `transactions_ext` VALUES ('a9694df134b44dc843794a7534f5c7d5',0),('e77b91a13f38cd0dd3f5daf2c2d53acf',0); >/*!40000 ALTER TABLE `transactions_ext` 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 2008-11-11 19:49: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 56242
: 117443 |
117444