diff options
| author | aneejit1 <aneejit1@gmail.com> | 2022-07-28 15:46:19 +0000 | 
|---|---|---|
| committer | Slávek Banko <slavek.banko@axis.cz> | 2022-07-31 16:41:03 +0200 | 
| commit | 4978511ebb7e8d31dab64485d1ac87b6e004be81 (patch) | |
| tree | a2da3161f070116baa15de7276c5c0c9ac855e8f /examples/SQL/testdb_mysql.sql | |
| parent | 5916692cf4c4df4f808e346c9bda1604960a0ff3 (diff) | |
| download | pytqt-4978511ebb7e8d31dab64485d1ac87b6e004be81.tar.gz pytqt-4978511ebb7e8d31dab64485d1ac87b6e004be81.zip | |
Remove Qt V2 support and example files
Build files for pyuic2 have been removed along with the examples for
version 2 of Qt and the build/configure scripts have been amended
accordingly. The "examples3" directory has been renamed to just
"examples".
Signed-off-by: aneejit1 <aneejit1@gmail.com>
(cherry picked from commit e602246539fd7435aaeb440fcb7f852c92c8426b)
Diffstat (limited to 'examples/SQL/testdb_mysql.sql')
| -rw-r--r-- | examples/SQL/testdb_mysql.sql | 57 | 
1 files changed, 57 insertions, 0 deletions
| diff --git a/examples/SQL/testdb_mysql.sql b/examples/SQL/testdb_mysql.sql new file mode 100644 index 0000000..144d4c9 --- /dev/null +++ b/examples/SQL/testdb_mysql.sql @@ -0,0 +1,57 @@ +drop database testdb; +create database testdb; +use testdb; + +create table people (id integer primary key auto_increment, +                     name char(40)); + +create table staff (id integer primary key auto_increment, +                    forename char(40), +                    surname char(40), +                    salary float(10,2), +                    statusid integer); + +create table status (id integer primary key, +                     name char(30)); + +create table creditors (id integer primary key auto_increment, +                        forename char(40), +                        surname char(40), +                        city char(30)); + +create table prices (id integer primary key, +                     name char(40), +                     price float); + +create table invoiceitem (id integer primary key auto_increment,  +                          pricesid integer, +                          quantity integer, +                          paiddate date); + +insert into staff (forename, surname, salary, statusid) values +            ("Hugo", "Hurtig", 123450.50, 0), +            ("Alfred E.", "Neumann", 56780.90, 1), +            ("Agate", "Schnell-Fertig", 12340.56, 2), +            ("Emil", "Dotterschreck", -5670.23, 3), +            ("Eugen", "Nutzlos", -7833.56, 3), +            ("Harald", "Schmidt", -150000.0, 3), +            ("Urmel", "auf dem Eis", 7778.0, 2); + +insert into status (id, name) values +            (0, 'Chief'), +            (1, 'Programmer'), +            (2, 'Secretary'), +            (3, 'Driver'); + +insert into prices (id, name, price) values +            (0, "Waschbecken", 150.25), +            (1, "Wellensittich", 27.95), +            (2, "Roter Papagei", 850.0), +            (3, "Spam & Eggs", -7.50), +            (4, "Renault Espace", 9000.0), +            (5, "Tux, der Pinguin", 65.35), +            (6, "Makroskop", 985000.0), +            (7, "Regenbaum", 1235.65), +            (8, "Bluterguß", 23.95), +            (9, "Weltmeisterschaft", 2.95), +            (10, "Premiere Dekoder", -185.75); | 
