rtt.sqlite3 in rtt-0.0.0.35

- old
+ new
@@ -1,14 +1,9 @@
-SQLite format 3@  A4A-âö
-ûö&#
ÐìÐ"ChampionChampionfEmexEmext
¿ñàÎ¿
rtt_tasksS%rtt_projects#rtt_clients
rtt_users
-ôúô
-êê÷ChampionEmexÉûöñìçâÝØÓÎÉLE>71+%	
((z•P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)‚  %%„tablertt_projectsrtt_projectsCREATE TABLE "rtt_projects" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(50) DEFAULT 'default' NOT NULL, "description" VARCHAR(50) DEFAULT 'Default Project', "active" BOOLEAN DEFAULT 'f', "rate" FLOAT, "client_id" INTEGER NOT NULL)z!?%indexindex_rtt_projects_clientrtt_projectsCREATE INDEX "index_rtt_projects_client" ON "rtt_projects" ("client_id")z"=%indexunique_rtt_projects_namertt_projectsCREATE UNIQUE INDEX "unique_rtt_projects_name" ON "rtt_projects" ("name")‚h#…tablertt_tasksrtt_tasksCREATE TABLE "rtt_tasks" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT DEFAULT 'Default task' NOT NULL, "date" DATE, "start_at" TIMESTAMP, "end_at" TIMESTAMP, "active" BOOLEAN DEFAULT 'f', "accumulated_spent_time" FLOAT DEFAULT 0, "rate" FLOAT DEFAULT 0, "project_id" INTEGER NOT NULL, "user_id" INTEGER NOT NULL)
€óh$5	indexindex_rtt_tasks_userrtt_tasksCREATE INDEX "index_rtt_tasks_user" ON "rtt_tasks" ("user_id")q%;indexindex_rtt_tasks_projectrtt_tasksCREATE INDEX "index_rtt_tasks_project" ON "rtt_tasks" ("project_id")„
-&‡ctablertt_usersrtt_users	CREATE TABLE "rtt_users" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "nickname" VARCHAR(50) DEFAULT 'Default user' NOT NULL, "first_name" VARCHAR(50) DEFAULT '', "last_name" VARCHAR(50) DEFAULT '', "company" VARCHAR(50) DEFAULT '', "address" VARCHAR(50) DEFAULT '', "city" VARCHAR(50) DEFAULT '', "country" VARCHAR(50) DEFAULT '', "email" VARCHAR(50) DEFAULT '', "phone" VARCHAR(50) DEFAULT '', "zip" VARCHAR(50) DEFAULT '', "site" VARCHAR(50) DEFAULT '', "active" BOOLEAN DEFAULT 'f')
`ã`-!7)
-marklazzMarceloGiorgimarklazzPalermo 5626/302MontevideoUruguaymarklazz.uy@gmail.com+598 2 6000437www.marklazz.comt%









Default userf
•ˆz'?#indexunique_rtt_users_nicknamertt_usersCREATE UNIQUE INDEX "unique_rtt_users_nickname" ON "rtt_users" ("nickname")p(##ƒ'tablertt_clientsrtt_clients
CREATE TABLE "rtt_clients" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(50) DEFAULT 'default' NOT NULL, "description" VARCHAR(50) DEFAULT 'Default Client', "active" BOOLEAN DEFAULT 'f')v);#indexunique_rtt_clients_namertt_clientsCREATE UNIQUE INDEX "unique_rtt_clients_name" ON "rtt_clients" ("name")
-IJúôîèâÖÜÐÊÄ¾¸²¬¦ ”Žšˆ‚|vpjd^XLF@:4.("
-þøòìæàÚÔÎÈÂ¼¶°¤ªRž˜’Œ†€ztnhb\VPJDQPONMLKJIHGFEDC@A?=<;:9876543210/.-,+*)('&%$B"! 
-	
-âïâmarklazz%Default user
ÓãÓEmexEmext)defaultDefault Clientf
UUôs!Ùl
-!??Remove the Exclusivity checkbox and verbiage from the registration forms2010-06-242010-06-27T00:00:01+00:002010-06-27T00:13:02+00:00f?‚ƒ9D¥[f}a!??Graph labels for 12 months are overlapping2010-06-242010-06-27T00:00:01+00:002010-06-27T00:50:02+00:00f?¡È ÎQ)W+;!??Fixing failing specs for change on deals_controller related with sending email analysis2010-06-242010-06-27T00:00:01+00:002010-06-27T00:24:02+00:00f?‘Ê%*Ï5O!??As a developer, I want a special Rails env for testing emails so company staff don't receive them2010-06-232010-06-27T00:00:01+00:002010-06-27T01:22:02+00:00f?­)VÙ±ß`!??Admins can see and edit the kWh / kW entered by the customer2010-06-232010-06-27T00:00:01+00:002010-06-27T00:31:02+00:00f?–iozŽ!??On lockin page for NJ, show the selected adder, not the total2010-06-232010-06-27T00:00:01+00:002010-06-27T00:26:02+00:00f?’€0‹‘A”
-ëëôEmexdefault
-IJúôîèâÖÜÐÊÄ¾¸²¬¦ ”Žšˆ‚|vpjd^XLF@:4.("
-þøòìæàÚÔÎ°¤ªRž˜’†€ztnhb\VPJÈÂ¼¶ŒŒQPONMLKJIHGFEDC@A?=<;:9876543210/.-,+*)('&%$B"! 
-	
zónÃR­	!??Pricing refreshes are only based on the user's annual kWh2010-06-232010-06-27T00:00:01+00:002010-06-27T01:59:02+00:00f?µ(”«lØò")!??EMEX project should use the EFL from the Champion project for < 50kW customers2010-06-242010-06-27T00:00:01+00:002010-06-27T01:33:02+00:00f?°‰J¶ÍŽûoE!??Meeting with Jason and Bruno2010-06-242010-06-27T00:00:01+00:002010-06-27T00:15:02+00:00f?…[fÇ}ˆÒ(5!??When admins upload usage, the editable kWh & kW need to be updated based on the data2010-06-242010-06-27T00:00:01+00:002010-06-27T01:15:02+00:00f?ª¬/4·k!??Let affiliates create clients through the admin2010-06-252010-06-27T00:00:01+00:002010-06-27T01:38:02+00:00f?±lØï±2o!??SJE contract not being sent for customer #38057722010-06-252010-06-27T00:00:01+00:002010-06-27T00:41:02+00:00f?*Û6;ìHm!??Implement new version of Index Rates page for NJ2010-06-252010-06-27T00:00:01+00:002010-06-27T08:07:02+00:00f?Õ¥*Û6;õ
--»5ý¬f}!??Logged-in customers can't lock in rates that are expired2010-06-232010-06-27T00:00:01+00:002010-06-27T01:00:02+00:00f?¥VÙ±ßb5xW!??Index Pricing for logged-in customers2010-06-232010-06-27T00:00:01+00:002010-06-27T05:26:02+00:00f?Ìú°¼ÒàEo!??On the Variable Rates tab of the home page, when you enter an NJ zip, it doesn't take you to the Index Rates page2010-06-222010-06-27T00:00:01+00:002010-06-27T01:02:02+00:00f?¦å•m—,=!??On the homepage, when non-TX states are selected, the second tab should be 'Index Rates'2010-06-222010-06-27T00:00:01+00:002010-06-27T01:17:02+00:00f?«b:gêÂñ7S!??On Index Rates page, after selecting a term, the term gets reset if you change tabs above the graph2010-06-222010-06-27T00:00:01+00:002010-06-27T00:26:02+00:00f?’€0‹‘A”!??MCPE grid on home page should show proper pricing for non-TX states2010-06-222010-06-27T00:00:01+00:002010-06-27T01:34:02+00:00f?°¶ÍŽûÐ
††õ‘.“@#cmA!??On Index Rates page, learn2010-06-222010-06-27T00:00:01+00:002010-06-27T00:20:02+00:00f?ŒwØŽ™úÆ!??On the Index Rate lockin page, the rate shows with too much precision2010-06-222010-06-27T00:00:01+00:002010-06-27T01:10:02+00:00f?¨å•m› !??The index pricing page should display a dynamic graph of index pricing2010-06-222010-06-27T00:00:01+00:002010-06-27T00:09:02+00:00f?y¥¼}ê½c-!??Replace the MCPE2010-06-222010-06-27T00:00:01+00:002010-06-27T00:06:02+00:00f?q3õax9*9!??Replace the In the rateboard area, call the second tab 'Index Rates' for non-TX states2010-06-222010-06-27T00:00:01+00:002010-06-27T00:20:02+00:00f?ŒwØŽ™úÆ=_!??When you select New Jersey, then Variable Rates on the home page, leave and come back, it throws an error2010-06-222010-06-27T00:00:01+00:002010-06-27T00:19:02+00:00f?‹ÁÍ-ãå
ûcÞ"û©©($5!??The index pricing page should show the breakdown for the currently-selected supplier2010-06-182010-06-27T00:00:01+00:002010-06-27T02:47:02+00:00f?½±3õacw%U!??Helping Bruno on daily adapters task2010-06-182010-06-27T00:00:01+00:002010-06-27T00:30:02+00:00f?•X^io9"W!??Fix issue on contracts for Small commercials, replacing business name instead of full name on page 102010-06-182010-06-27T00:00:01+00:002010-06-27T00:19:02+00:00f?‹ÁÍ-ãå!k!??Let affiliates create clients through the admin2010-06-242010-06-27T00:00:01+00:002010-06-27T01:37:02+00:00f?±?Vƒš] !??The index pricing page should display a dynamic graph of index pricing2010-06-212010-06-27T00:00:01+00:002010-06-27T08:05:02+00:00f?ÕŽioz‡
q\»8¦!q-+?!??In states other than TX, the 'Variable Rates (MCPE)' tab should be called 'Index Pricing'2010-06-172010-06-27T00:00:01+00:002010-06-27T00:23:02+00:00f?^io|*k!??Index Pricing should be available in New Jersey2010-06-172010-06-27T00:00:01+00:002010-06-27T00:15:02+00:00f?…[fÇ}ˆÒ)!??Admins can't generate contracts for rates that have expired2010-06-172010-06-27T00:00:01+00:002010-06-27T01:41:02+00:00f?±õax9¥¿(g!??Finishing up the Champion Small Comm contract2010-06-172010-06-27T00:00:01+00:002010-06-27T02:00:02+00:00f?µVƒš[Ç'!!??Fixes for email template of contract for small commercial (Champion on Tx)2010-06-172010-06-27T00:00:01+00:002010-06-27T01:09:02+00:00f?¨Šå•h!&'!??When you go choose to see Index Pricing in NJ, you will see Gus's static page2010-06-182010-06-27T00:00:01+00:002010-06-27T00:11:02+00:00f?Vƒš[Ä
W\°mÒWy1Y!??Meeting with Jason about Index Pricing2010-06-152010-06-27T00:00:01+00:002010-06-27T01:12:02+00:00f?©›ö#¦‚0!??Developers can load historical index pricing for PSEG and JCPL in NJ2010-06-162010-06-27T00:00:01+00:002010-06-27T03:56:02+00:00f?Äú°¼Òà,/=!??System automatically downloads and imports new index pricing for PSEG and JCPL every day2010-06-162010-06-27T00:00:01+00:002010-06-27T02:17:02+00:00f?¸[ÇÞ &.!??Final adjustemnts for the looks of small commercial documents2010-06-162010-06-27T00:00:01+00:002010-06-27T03:22:02+00:00f?Áõa"‰)-7!??Bug for identifying small commercial (related with not uploading properly metered_kw)2010-06-162010-06-27T00:00:01+00:002010-06-27T01:02:02+00:00f?¦å•m—!,'!??When you go choose to see Index Pricing in NJ, you will see Gus's static page2010-06-172010-06-27T00:00:01+00:002010-06-27T01:43:02+00:00f?²Pg(”«p
˜cÔH¶$˜(p	7y!??Admins can set expiration dates for a customer's rates2010-06-142010-06-27T00:00:01+00:002010-06-27T03:35:02+00:00f?ÃÒÞ>õ6!??Generated contracts should show rates with 5 decimal places2010-06-142010-06-27T00:00:01+00:002010-06-27T01:14:02+00:00f?ªQ)VÙ±å5!??Admins can't generate contracts for rates that have expired2010-06-152010-06-27T00:00:01+00:002010-06-27T03:35:02+00:00f?ÃÒÞ>õ	4y!??Admins can set expiration dates for a customer's rates2010-06-152010-06-27T00:00:01+00:002010-06-27T03:20:02+00:00f?ÁÇ}ˆéŸ¬3!??Checking with Emex that Small commercial contracts are ok2010-06-152010-06-27T00:00:01+00:002010-06-27T00:30:02+00:00f?•X^io2!??Logged-in customers can see expiration dates that apply to their rates2010-06-152010-06-27T00:00:01+00:002010-06-27T01:08:02+00:00f?¨/4·¾
ÂV§¦3Â%o=E!??Add Exhibit to generated TOS2010-06-142010-06-27T00:00:01+00:002010-06-27T00:41:02+00:00f?*Û6;ìHq<I!??System generates a dynamic EFL2010-06-212010-06-27T00:00:01+00:002010-06-27T03:40:02+00:00f?ÃŽ™ú°¼"q;I!??System generates a dynamic EFL2010-06-222010-06-27T00:00:01+00:002010-06-27T03:14:02+00:00f?Á>õa:}!??Champion admins can't send contracts from the admin area2010-06-242010-06-27T00:00:01+00:002010-06-27T02:33:02+00:00f?»3õax9 ,9=!??System automatically downloads and imports new index pricing for PSEG and JCPL every day2010-06-172010-06-27T00:00:01+00:002010-06-27T01:18:02+00:00f?«½@EÈ›'83!??Zipcode lockins for Champion in TX should result in Small Comm contracts being sent2010-06-142010-06-27T00:00:01+00:002010-06-27T06:22:02+00:00f?Ðú€0‹‘D
>ŒïjÎ;Ç>Es!??Users can choose a supplier on the Index Rates page2010-06-292010-06-29T08:07:44-03:002010-06-29T09:12:52-03:00f?§(òTù“rDK!??Change text on Index Rates page2010-06-292010-06-29T06:35:42-03:002010-06-29T08:07:10-03:00f?°C•G|C!??Change IndexRate average calculation to use less sql queries2010-06-282010-06-28T00:00:01+00:002010-06-28T00:40:02+00:00f?œtÏÕ…àôB!??Move Service Zip on the Create Client form and tie other fields to it2010-06-282010-06-28T20:09:56-03:002010-06-28T21:05:12-03:00f?Ìü«[fRAk!??Rename fields on Create Client form for clarity2010-06-282010-06-28T09:24:47-03:002010-06-28T09:44:20-03:00f?‹Î…jø&ª@!??Customers viewing Index Pricing in NJ should see a live rateboard area2010-06-182010-06-28T00:00:01+00:002010-06-28T05:49:02+00:00f?Ïr(3Žr?K!??Change text on Index Rates page2010-06-282010-06-28T00:00:01+00:002010-06-28T06:40:02+00:00f?ÑÇLýX^
@‚ÿ^íZå@"L)!??The rateboards in the quote email should include an GRT column for PA accounts2010-06-302010-06-30T00:00:01+00:002010-06-30T00:48:02+00:00f?¡•m›õsKM!??Suppliers have GRT and SUT flags2010-06-302010-06-30T00:00:01+00:002010-06-30T00:58:02+00:00f?¤ ÎQ)VáJ!??System includes MCPE / Index Rates rateboard in quote emails2010-06-292010-06-29T19:43:42-03:002010-06-29T21:05:12-03:00f?Áôâ¿'r¶oIE!??Meeting with Jason and Bruno2010-06-292010-06-29T12:23:41-03:002010-06-29T12:43:27-03:00f?Œ"FÈÁÐH!!??Modify daily pricing adapter for Liberty to reflect changes on spreadsheet2010-06-292010-06-29T13:59:24-03:002010-06-29T14:22:17-03:00f?¹m¯]YÈŽGg!??System generates contracts for TriEagle in TX2010-06-292010-06-29T11:03:35-03:002010-06-29T11:24:47-03:00f?Ž,™‹ôI|F_!??Pretty up page 5 of the Champion contract2010-06-292010-06-29T09:15:13-03:002010-06-29T11:02:31-03:00f?³óÒ¾Y½
a[ÆUÝa(9zQ[!??Add tariffs to PPL's rate classes in PA2010-06-302010-06-30T00:00:01+00:002010-06-30T00:30:02+00:00f?•X^iovPS!??Index Rates tab not appearing in NJ2010-06-302010-06-30T00:00:01+00:002010-06-30T00:58:02+00:00f?¤ ÎQ)VáoOE!??Meeting with Bruno and Jason2010-06-302010-06-30T00:00:01+00:002010-06-30T00:14:02+00:00f?ƒïPr*N	!??Adding email_spec's for the Index Rate's table on quote emails2010-06-302010-06-30T00:00:01+00:002010-06-30T01:11:02+00:00f?©@EÈ Ê"M)!??The rateboards in the quote email should include an SUT column for NJ accounts2010-06-302010-06-30T00:00:01+00:002010-06-30T00:47:02+00:00f? ·½@K
+SQLite format 3@  °
+
l°-âöûöNK
ßß+defaultDefault Projectt
¿ñàÎ¿
rtt_tasks%rtt_projects#rtt_clients
rtt_users
+úú
+ôôdefault
ÈÈ6!?DFDF2012-02-262012-02-26T09:11:55-02:00t
((z•P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)‚ H%%„tablertt_projectsrtt_projectsCREATE TABLE "rtt_projects" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(50) DEFAULT 'default' NOT NULL, "description" VARCHAR(50) DEFAULT 'Default Project', "active" BOOLEAN DEFAULT 'f', "rate" FLOAT, "client_id" INTEGER NOT NULL)zI?%indexindex_rtt_projects_clientrtt_projectsCREATE INDEX "index_rtt_projects_client" ON "rtt_projects" ("client_id")zJ=%indexunique_rtt_projects_namertt_projectsCREATE UNIQUE INDEX "unique_rtt_projects_name" ON "rtt_projects" ("name")‚hK…tablertt_tasksrtt_tasksCREATE TABLE "rtt_tasks" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT DEFAULT 'Default task' NOT NULL, "date" DATE, "start_at" TIMESTAMP, "end_at" TIMESTAMP, "active" BOOLEAN DEFAULT 'f', "accumulated_spent_time" FLOAT DEFAULT 0, "rate" FLOAT DEFAULT 0, "project_id" INTEGER NOT NULL, "user_id" INTEGER NOT NULL)
€óhL5	indexindex_rtt_tasks_userrtt_tasksCREATE INDEX "index_rtt_tasks_user" ON "rtt_tasks" ("user_id")qM;indexindex_rtt_tasks_projectrtt_tasksCREATE INDEX "index_rtt_tasks_project" ON "rtt_tasks" ("project_id")„
+N‡ctablertt_usersrtt_users	CREATE TABLE "rtt_users" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "nickname" VARCHAR(50) DEFAULT 'Default user' NOT NULL, "first_name" VARCHAR(50) DEFAULT '', "last_name" VARCHAR(50) DEFAULT '', "company" VARCHAR(50) DEFAULT '', "address" VARCHAR(50) DEFAULT '', "city" VARCHAR(50) DEFAULT '', "country" VARCHAR(50) DEFAULT '', "email" VARCHAR(50) DEFAULT '', "phone" VARCHAR(50) DEFAULT '', "zip" VARCHAR(50) DEFAULT '', "site" VARCHAR(50) DEFAULT '', "active" BOOLEAN DEFAULT 'f')
ãã%









Default usert
	
•ˆzO?#indexunique_rtt_users_nicknamertt_usersCREATE UNIQUE INDEX "unique_rtt_users_nickname" ON "rtt_users" ("nickname")pP##ƒ'tablertt_clientsrtt_clients
CREATE TABLE "rtt_clients" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(50) DEFAULT 'default' NOT NULL, "description" VARCHAR(50) DEFAULT 'Default Client', "active" BOOLEAN DEFAULT 'f')vQ;#indexunique_rtt_clients_namertt_clientsCREATE UNIQUE INDEX "unique_rtt_clients_name" ON "rtt_clients" ("name")
+ïï%Default user
ãã)defaultDefault Clientt
+úú
+ôôdefault
+úú
\ No newline at end of file