X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=README.remove_columns;fp=README.remove_columns;h=32d59811d84748e1456cd0e45853a963bc8697d7;hb=491bd4d5497b5c431ab35716425f4c95fd2c3696;hp=0000000000000000000000000000000000000000;hpb=17a01cef3f265688e6f8a1a4fec2d0abb3cf7397;p=unfold.git

diff --git a/README.remove_columns b/README.remove_columns
new file mode 100644
index 00000000..32d59811
--- /dev/null
+++ b/README.remove_columns
@@ -0,0 +1,7 @@
+sqlite> CREATE TEMPORARY TABLE portal_pendinguser_backup(id,first_name,last_name,email,password,keypair,authority_hrn);
+sqlite> INSERT INTO portal_pendinguser_backup SELECT id,first_name,last_name,email,password,keypair,authority_hrn FROM portal_pendinguser;
+sqlite> DROP TABLE portal_pendinguser;
+sqlite> CREATE TABLE portal_pendinguser(id,first_name,last_name,email,password,keypair,authority_hrn);
+sqlite> INSERT INTO portal_pendinguser SELECT id,first_name,last_name,email,password,keypair,authority_hrn FROM portal_pendinguser_backup;
+sqlite> DROP TABLE portal_pendinguser_backup;
+sqlite> COMMIT;