summaryrefslogtreecommitdiffstats
path: root/examples3/SQL/testdb_mysql.sql
diff options
context:
space:
mode:
authoraneejit1 <[email protected]>2022-07-28 15:46:19 +0000
committerSlávek Banko <[email protected]>2022-07-31 16:41:03 +0200
commit4978511ebb7e8d31dab64485d1ac87b6e004be81 (patch)
treea2da3161f070116baa15de7276c5c0c9ac855e8f /examples3/SQL/testdb_mysql.sql
parent5916692cf4c4df4f808e346c9bda1604960a0ff3 (diff)
downloadpytqt-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 <[email protected]> (cherry picked from commit e602246539fd7435aaeb440fcb7f852c92c8426b)
Diffstat (limited to 'examples3/SQL/testdb_mysql.sql')
-rw-r--r--examples3/SQL/testdb_mysql.sql57
1 files changed, 0 insertions, 57 deletions
diff --git a/examples3/SQL/testdb_mysql.sql b/examples3/SQL/testdb_mysql.sql
deleted file mode 100644
index 144d4c9..0000000
--- a/examples3/SQL/testdb_mysql.sql
+++ /dev/null
@@ -1,57 +0,0 @@
-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);