sql

lisong · lisong · commit cb1b05163934 · 2016-08-03T14:52:42.000+08:00
diff --git a/README.md b/README.md
@@ -7,7 +7,8 @@ CodePushServer is a CodePush progam server! microsoft CodePush cloud is slow in
 ```shell
 $ cd /path/to/code-push-server
 $ mysql -uroot -e"create database codepush default charset utf8;"
-$ mysql -uroot codepush < ./codepush.sql
+$ mysql -uroot codepush < ./sql/codepush.sql
+$ mysql -uroot codepush < ./sql/codepush-v0.1.1.sql
 $ npm install
 ```
 
diff --git a/sql/codepush-v0.1.1.sql b/sql/codepush-v0.1.1.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `users` ADD `ack_code` VARCHAR(10)  NOT NULL  DEFAULT ''  AFTER `identical`;
+ALTER TABLE `user_tokens` ADD `name` VARCHAR(50)  NOT NULL  DEFAULT ''  AFTER `uid`;
+ALTER TABLE `user_tokens` ADD `is_session` TINYINT(3)  UNSIGNED  NOT NULL  DEFAULT '0' AFTER `description`;
diff --git a/sql/codepush.sql b/sql/codepush.sql

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	+ALTER TABLE `users` ADD `ack_code` VARCHAR(10) NOT NULL DEFAULT '' AFTER `identical`;
	`2`	+ALTER TABLE `user_tokens` ADD `name` VARCHAR(50) NOT NULL DEFAULT '' AFTER `uid`;
	`3`	+ALTER TABLE `user_tokens` ADD `is_session` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `description`;