projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Clean up in en_US-demo.sql and en_US-new.sql. @apmuthu.
[fa-stable.git]
/
sql
/
en_US-demo.sql
diff --git
a/sql/en_US-demo.sql
b/sql/en_US-demo.sql
index 284281b4180e6747e77c6ba1621026dfea684243..d536e000ee7605c42b1a1b6ec91f73c148804c9d 100644
(file)
--- a/
sql/en_US-demo.sql
+++ b/
sql/en_US-demo.sql
@@
-1366,7
+1366,6
@@
CREATE TABLE `0_refs` (
-- Data of table `0_refs` --
INSERT INTO `0_refs` VALUES
-- Data of table `0_refs` --
INSERT INTO `0_refs` VALUES
-('1', '0', '001/2012'),
('1', '1', '001/2018'),
('1', '10', '001/2018'),
('5', '10', '001/2019'),
('1', '1', '001/2018'),
('1', '10', '001/2018'),
('5', '10', '001/2019'),
@@
-1947,7
+1946,7
@@
DROP TABLE IF EXISTS `0_tag_associations`;
CREATE TABLE `0_tag_associations` (
`record_id` varchar(15) NOT NULL,
`tag_id` int(11) NOT NULL,
CREATE TABLE `0_tag_associations` (
`record_id` varchar(15) NOT NULL,
`tag_id` int(11) NOT NULL,
-
UNIQUE KEY `record_id`
(`record_id`,`tag_id`)
+
PRIMARY KEY
(`record_id`,`tag_id`)
) ENGINE=InnoDB ;
-- Data of table `0_tag_associations` --
) ENGINE=InnoDB ;
-- Data of table `0_tag_associations` --