Artifact 677d51b542590ec164f66f82bf95c206df1492e6

Ticket change [677d51b542] - Ticket 665995e480 no such table: vvar status still Open with 1 other change by rwilson on 2009-09-23 05:39:29.

D 2009-09-23T05:39:29
J +comment \n\n<hr><i>rwilson\sadded\son\s2009-09-23\s05:39:29:</i><br>\nit\sis\snot\shardware\srelated.\s\sfor\ssome\sreason\sfossil\sis\snot\sable\sopen\sa\srepository\sin\sthe\s'my\sdocuments'\sfolder.\s\sodd.\s\sit\sis\sable\sto\screate\sthe\s_FOSSIL_\sfile\sin\s'my\sdocuments'\sbut\sit\sdoesn't\sappear\sto\screate\sthe\sentire\sfile.\r\n\r\n<pre>\r\nPS\sC:\\fossil>\sfossil\snew\sp:\\backup\\test.f\r\nproject-id:\s711304708008228f835ddfed439613f3179944d6\r\nserver-id:\s\sacdf9cf7de168d7d9a08f18b360b1ed1c5e9b422\r\nadmin-user:\sron\swilson\s(initial\spassword\sis\s"36625a")\r\nPS\sC:\\fossil>\smd\snospaces\r\nPS\sC:\\fossil>\scd\snospaces\r\nPS\sC:\\fossil\\nospaces>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\fossil\\nospaces>\scd\s..\r\nPS\sC:\\fossil>\smd\s"one\sspace"\r\nPS\sC:\\fossil>\scd\s'one\sspace'\r\nPS\sC:\\fossil\\one\sspace>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\fossil\\one\sspace>\scd\s'C:\\Documents\sand\sSettings'\r\nPS\sC:\\Documents\sand\sSettings>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\Documents\sand\sSettings>\scd\s'ron\swilson'\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson>\scd\s'My\sDocuments'\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\sfossil\sopen\sp:\\backup\\test.f\r\nC:\\WINDOWS\\system32\\fossil.exe:\sno\ssuch\stable:\svvar\r\nREPLACE\sINTO\svvar(name,value)\sVALUES('repository','p:\\backup\\test.f')\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\sls\r\n\s\s\s\sDirectory:\sMicrosoft.PowerShell.Core\\FileSystem::C:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments\r\nMode\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\sLastWriteTime\s\s\s\s\sLength\sName\r\n----\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s-------------\s\s\s\s\s------\s----\r\n-a---\s\s\s\s\s\s\s\s\s9/23/2009\s\s\s1:35\sAM\s\s\s\s\s\s\s7168\s_FOSSIL_\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\ssqlite3\s_FOSSIL_\r\nSQLite\sversion\s3.6.1\r\nEnter\s".help"\sfor\sinstructions\r\nEnter\sSQL\sstatements\sterminated\swith\sa\s";"\r\nsqlite>\s.schema\r\nCREATE\sTABLE\svfile(\r\n\s\sid\sINTEGER\sPRIMARY\sKEY,\r\n\s\svid\sINTEGER\sREFERENCES\sblob,\r\n\s\schnged\sINT\sDEFAULT\s0,\r\n\s\sdeleted\sBOOLEAN\sDEFAULT\s0,\r\n\s\srid\sINTEGER,\r\n\s\smrid\sINTEGER,\r\n\s\smtime\sINTEGER,\r\n\s\spathname\sTEXT,\r\n\s\sorigname\sTEXT,\r\n\s\sUNIQUE(pathname,vid)\r\n);\r\nCREATE\sTABLE\svmerge(\r\n\s\sid\sINTEGER\sREFERENCES\svfile,\r\n\s\smerge\sINTEGER,\r\n\s\sUNIQUE(id,\smerge)\r\n);\r\nCREATE\sTABLE\svvar(\r\n\s\sname\sTEXT\sPRIMARY\sKEY\sNOT\sNULL,\r\n\s\svalue\sCLOB,\r\n\s\sCHECK(\stypeof(name)='text'\sAND\slength(name)>=1\s)\r\n);\r\nsqlite>\s.quit\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>cd\s..\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson>\smd\s'my\sdocuments2'\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson>\scd\s'my\sdocuments2'\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\my\sdocuments2>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\my\sdocuments2>cd\s'..\\My\sDocuments'\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\smd\stest\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\scd\stest\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments\\test>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments\\test>\r\n</pre>
K 665995e4806e119cc5eb62abdc4df5214324a7f3
U rwilson
Z 957eab88d7093b25473b1636a352b036