git.cweiske.de
/
anoweco.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
remove auto_increment from sql dump
[anoweco.git]
/
data
/
schema.sql
diff --git
a/data/schema.sql
b/data/schema.sql
index 61eae79cc0136097ad1d47bedfcfa02790b451fb..25e7cada8436ea6bfac815a0f295ff13c24d2f0d 100644
(file)
--- a/
data/schema.sql
+++ b/
data/schema.sql
@@
-9,7
+9,7
@@
CREATE TABLE `comments` (
`comment_type` varchar(32) NOT NULL,
`comment_json` mediumtext NOT NULL,
PRIMARY KEY (`comment_id`)
`comment_type` varchar(32) NOT NULL,
`comment_json` mediumtext NOT NULL,
PRIMARY KEY (`comment_id`)
-) ENGINE=InnoDB
AUTO_INCREMENT=8
DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `users` (
CREATE TABLE `users` (
@@
-18,6
+18,6
@@
CREATE TABLE `users` (
`user_email` varchar(256) NOT NULL,
`user_imageurl` varchar(1024) NOT NULL,
PRIMARY KEY (`user_id`)
`user_email` varchar(256) NOT NULL,
`user_imageurl` varchar(1024) NOT NULL,
PRIMARY KEY (`user_id`)
-) ENGINE=InnoDB
AUTO_INCREMENT=2
DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;