diff options
author | Sebastian Reichel <sre@ring0.de> | 2012-10-02 01:05:51 +0200 |
---|---|---|
committer | Sebastian Reichel <sre@ring0.de> | 2012-10-02 01:05:51 +0200 |
commit | 186049b3ed33f025eeb87eb34c19a28e1d5ba70a (patch) | |
tree | 5d892564001404fe979e18eac0e65dfcad65ed5e /insert-prices.sql | |
parent | 9713c98dbceb54d8d00c186ba8f41f3a5befcfd1 (diff) | |
download | serial-barcode-scanner-186049b3ed33f025eeb87eb34c19a28e1d5ba70a.tar.bz2 |
restructure code, switch from GTK to Web based UI
- move barcode generation scripts into generation/
- move code to src/
- remove database analysis from invoice/graph
- put database creation sql files into sql/
- remove glade builder file
- add new templates/ directory, which contains files
used by the Web-UI
Diffstat (limited to 'insert-prices.sql')
-rw-r--r-- | insert-prices.sql | 183 |
1 files changed, 0 insertions, 183 deletions
diff --git a/insert-prices.sql b/insert-prices.sql deleted file mode 100644 index e72d0e1..0000000 --- a/insert-prices.sql +++ /dev/null @@ -1,183 +0,0 @@ -BEGIN TRANSACTION; -INSERT INTO prices (product, memberprice, guestprice) VALUES (4029764001807,150,250); -INSERT INTO prices (product, memberprice, guestprice) VALUES (5449000017888,150,240); -INSERT INTO prices (product, memberprice, guestprice) VALUES (5449000017895,150,240); -INSERT INTO prices (product, memberprice, guestprice) VALUES (5449000134264,150,240); -INSERT INTO prices (product, memberprice, guestprice) VALUES (5449000017918,150,240); -INSERT INTO prices (product, memberprice, guestprice) VALUES (5449000017932,150,240); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4104450004383,150,240); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4104450004086,150,240); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4104450005878,150,240); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686720028,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686310229,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686390085,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686386613,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686301265,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686313046,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686216125,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686312025,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4003586000491,100,130); -INSERT INTO prices (product, memberprice, guestprice) VALUES (8690504018568,40,60); -INSERT INTO prices (product, memberprice, guestprice) VALUES (40084107,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (7613032850340,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (40111315,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (5000159407236,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (5000159407397,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (5000159418539,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (40114606,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (7613032625474,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (40358802,40,60); -INSERT INTO prices (product, memberprice, guestprice) VALUES (40084015,30,40); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4047046003325,50,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4047046003356,50,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4047046003417,50,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4047046005008,50,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686128244,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686150689,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686309506,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686315101,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686367346,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4001686721445,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4003586000477,100,130); -INSERT INTO prices (product, memberprice, guestprice) VALUES (76222498,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (76222504,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (5000159407410,140,180); -INSERT INTO prices (product, memberprice, guestprice) VALUES (5000159418546,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (5000159418577,80,100); -INSERT INTO prices (product, memberprice, guestprice) VALUES (4007495314014,100,130); -COMMIT; -BEGIN TRANSACTION; -INSERT INTO "prices" VALUES(4029764001807,1340402400,78,250); -INSERT INTO "prices" VALUES(5449000017888,1340402400,103,250); -INSERT INTO "prices" VALUES(5449000017895,1340402400,86,250); -INSERT INTO "prices" VALUES(5449000134264,1340402400,103,250); -INSERT INTO "prices" VALUES(5449000017918,1340402400,86,250); -INSERT INTO "prices" VALUES(5449000017932,1340402400,86,250); -INSERT INTO "prices" VALUES(4104450004383,1340402400,82,250); -INSERT INTO "prices" VALUES(4047046003325,1340402400,15,100); -INSERT INTO "prices" VALUES(4047046003417,1340402400,15,100); -INSERT INTO "prices" VALUES(4047046005008,1340402400,31,110); -INSERT INTO "prices" VALUES(4001686128244,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686150689,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686216125,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686301265,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686386613,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686309506,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686310229,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686312025,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686313046,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686315101,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686367346,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686390085,1340402400,75,180); -INSERT INTO "prices" VALUES(4001686721445,1340402400,75,180); -INSERT INTO "prices" VALUES(4003586000477,1340402400,60,140); -INSERT INTO "prices" VALUES(4003586000491,1340402400,60,140); -INSERT INTO "prices" VALUES(4007495314014,1340402400,48,120); -INSERT INTO "prices" VALUES(76222498,1340402400,42,100); -INSERT INTO "prices" VALUES(76222504,1340402400,42,100); -INSERT INTO "prices" VALUES(7622300065478,1340402400,42,100); -INSERT INTO "prices" VALUES(7622300243876,1340402400,42,100); -INSERT INTO "prices" VALUES(5000159407410,1340402400,54,140); -INSERT INTO "prices" VALUES(5000159407236,1340402400,44,100); -INSERT INTO "prices" VALUES(40111315,1340402400,44,100); -INSERT INTO "prices" VALUES(7613032625474,1340402400,34,100); -INSERT INTO "prices" VALUES(40114606,1340402400,34,100); -INSERT INTO "prices" VALUES(7613032850340,1340402400,47,100); -INSERT INTO "prices" VALUES(40084107,1340402400,61,100); -INSERT INTO "prices" VALUES(5000159418539,1340402400,44,100); -INSERT INTO "prices" VALUES(5000159418546,1340402400,44,100); -INSERT INTO "prices" VALUES(5000159418577,1340402400,44,100); -INSERT INTO "prices" VALUES(40358802,1340402400,21,60); -INSERT INTO "prices" VALUES(40084015,1340402400,18,50); -INSERT INTO "prices" VALUES(5900951020704,1340402400,48,130); -COMMIT; -BEGIN TRANSACTION; -INSERT INTO "prices" VALUES(4029764001807,1340575200,150,250); -INSERT INTO "prices" VALUES(5449000017888,1340575200,150,240); -INSERT INTO "prices" VALUES(5449000017895,1340575200,150,240); -INSERT INTO "prices" VALUES(5449000134264,1340575200,150,240); -INSERT INTO "prices" VALUES(5449000017918,1340575200,150,240); -INSERT INTO "prices" VALUES(5449000017932,1340575200,150,240); -INSERT INTO "prices" VALUES(4104450004383,1340575200,150,240); -INSERT INTO "prices" VALUES(4001686310229,1340575200,140,180); -INSERT INTO "prices" VALUES(4001686390085,1340575200,140,180); -INSERT INTO "prices" VALUES(4001686386613,1340575200,140,180); -INSERT INTO "prices" VALUES(4001686301265,1340575200,140,180); -INSERT INTO "prices" VALUES(4001686313046,1340575200,140,180); -INSERT INTO "prices" VALUES(4001686216125,1340575200,140,180); -INSERT INTO "prices" VALUES(4001686312025,1340575200,140,180); -INSERT INTO "prices" VALUES(4003586000491,1340575200,100,130); -INSERT INTO "prices" VALUES(40084107,1340575200,80,100); -INSERT INTO "prices" VALUES(7613032850340,1340575200,80,100); -INSERT INTO "prices" VALUES(40111315,1340575200,80,100); -INSERT INTO "prices" VALUES(5000159407236,1340575200,80,100); -INSERT INTO "prices" VALUES(5000159418539,1340575200,80,100); -INSERT INTO "prices" VALUES(40114606,1340575200,80,100); -INSERT INTO "prices" VALUES(7613032625474,1340575200,80,100); -INSERT INTO "prices" VALUES(40358802,1340575200,40,60); -INSERT INTO "prices" VALUES(40084015,1340575200,30,40); -INSERT INTO "prices" VALUES(4047046003325,1340575200,50,100); -INSERT INTO "prices" VALUES(4047046003417,1340575200,50,100); -INSERT INTO "prices" VALUES(4047046005008,1340575200,50,100); -INSERT INTO "prices" VALUES(4001686128244,1340575200,140,180); -INSERT INTO "prices" VALUES(4001686150689,1340575200,140,180); -INSERT INTO "prices" VALUES(4001686309506,1340575200,140,180); -INSERT INTO "prices" VALUES(4001686315101,1340575200,140,180); -INSERT INTO "prices" VALUES(4001686367346,1340575200,140,180); -INSERT INTO "prices" VALUES(4001686721445,1340575200,140,180); -INSERT INTO "prices" VALUES(4003586000477,1340575200,100,130); -INSERT INTO "prices" VALUES(76222498,1340575200,80,100); -INSERT INTO "prices" VALUES(76222504,1340575200,80,100); -INSERT INTO "prices" VALUES(7622300243876,1340575200,80,100); -INSERT INTO "prices" VALUES(7622300065478,1340575200,80,100); -INSERT INTO "prices" VALUES(5000159407410,1340575200,140,180); -INSERT INTO "prices" VALUES(5000159418546,1340575200,80,100); -INSERT INTO "prices" VALUES(5000159418577,1340575200,80,100); -INSERT INTO "prices" VALUES(4007495314014,1340575200,100,130); -INSERT INTO "prices" VALUES(5900951020704,1340575200,130,160); -COMMIT; -BEGIN TRANSACTION; -INSERT INTO "prices" VALUES(4029764001807,1342648800,150,250); -INSERT INTO "prices" VALUES(5449000017888,1342648800,165,250); -INSERT INTO "prices" VALUES(5449000017895,1342648800,136,250); -INSERT INTO "prices" VALUES(5449000134264,1342648800,165,250); -INSERT INTO "prices" VALUES(5449000017918,1342648800,136,250); -INSERT INTO "prices" VALUES(5449000017932,1342648800,136,250); -INSERT INTO "prices" VALUES(4104450004383,1342648800,145,250); -INSERT INTO "prices" VALUES(4047046003325,1342648800,35,100); -INSERT INTO "prices" VALUES(4047046003417,1342648800,35,100); -INSERT INTO "prices" VALUES(4047046005008,1342648800,53,110); -INSERT INTO "prices" VALUES(4001686128244,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686150689,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686216125,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686301265,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686386613,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686309506,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686310229,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686312025,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686313046,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686315101,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686367346,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686390085,1342648800,130,180); -INSERT INTO "prices" VALUES(4001686721445,1342648800,130,180); -INSERT INTO "prices" VALUES(4003586000477,1342648800,110,140); -INSERT INTO "prices" VALUES(4003586000491,1342648800,105,140); -INSERT INTO "prices" VALUES(4007495314014,1342648800,82,120); -INSERT INTO "prices" VALUES(76222498,1342648800,71,100); -INSERT INTO "prices" VALUES(76222504,1342648800,71,100); -INSERT INTO "prices" VALUES(7622300065478,1342648800,71,100); -INSERT INTO "prices" VALUES(7622300243876,1342648800,71,100); -INSERT INTO "prices" VALUES(5000159407410,1342648800,92,140); -INSERT INTO "prices" VALUES(5000159407236,1342648800,75,100); -INSERT INTO "prices" VALUES(40111315,1342648800,75,100); -INSERT INTO "prices" VALUES(7613032625474,1342648800,58,100); -INSERT INTO "prices" VALUES(40114606,1342648800,58,100); -INSERT INTO "prices" VALUES(7613032850340,1342648800,80,100); -INSERT INTO "prices" VALUES(40084107,1342648800,80,100); -INSERT INTO "prices" VALUES(5000159418539,1342648800,75,100); -INSERT INTO "prices" VALUES(5000159418546,1342648800,75,100); -INSERT INTO "prices" VALUES(5000159418577,1342648800,75,100); -INSERT INTO "prices" VALUES(40358802,1342648800,36,60); -INSERT INTO "prices" VALUES(40084015,1342648800,30,50); -INSERT INTO "prices" VALUES(5900951020704,1342648800,83,130); -COMMIT; |