Metadata-Version: 2.4
Name: plojrok
Version: 2.1.5.3
Summary: Tkinter project development helping library
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.6
Description-Content-Type: text/markdown

CREATE TABLE Books (
id INTEGER PRIMARY KEY AUTOINCREMENT,
ISBN text,
name text,
genre INTEGER REFERENCES Genres(id),
publisher INTEGER REFERENCES Publishers(id),
publish_year integer,
price real,
quantity integer,
sale_percent integer,
description text,
photo text
);

CREATE TABLE Genres (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name text
);

CREATE TABLE Publishers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name text,
town INTEGER REFERENCES Towns(id)
);
