~primes2h/+junk/ubuntu-qa-website

« back to all changes in this revision

Viewing changes to update-db.sql

  • Committer: Stéphane graber
  • Date: 2008-05-10 10:16:30 UTC
  • mto: (72.3.27 devel)
  • mto: This revision was merged to the branch mainline in revision 115.
  • Revision ID: stgraber@ubuntu.com-20080510101630-0pt8c7w0rf2uw5yb
Clear update-db.sql, add mini-sample.sql and mini-htaccess

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
DELETE FROM qapoll_entry_point_menu_entry WHERE id=4 or id=24 or id=25 or id=26;
2
 
 
3
 
INSERT INTO qapoll_entry_point_menu_entry (name, url, is_suffix, menu_id, user_id, status, ordering, userrole, adminrole) VALUES('My dashboard','/contributor/%username%/','TRUE','2','-1','0','2','TRUE','FALSE');
4
 
 
5
 
UPDATE qatracker_testcase SET status='1' WHERE title='Wubi (Windows installer)' AND (productid='17' OR productid='18' OR productid='27' OR productid='28');
6
 
 
7
 
 
8
 
CREATE TABLE qapoll_choice_bookmark (
9
 
                                id serial, 
10
 
                                userid integer NOT NULL, 
11
 
                                choiceid integer NOT NULL, 
12
 
                                date timestamp without time zone NOT NULL,
13
 
                                PRIMARY KEY (id)
14
 
                                );
15