CREATE TABLE REGISTERED_PROGRAMS(
PROGRAM_NUMBER INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, # 0 PROGRAM_NAME TEXT NOT NULL, # 1 PROGRAM_PATH TEXT NOT_NULL, # 2 PROGRAM_VERSION varchar(10), # 3 EXTRACT_TO varchar(50), # 4 USE_THIS_BUILD_SYSTEM varchar(10), # 5 USE_BUILD_DIRECTORY BIT, # 6 LICENCE varchar(50), # 7 PROGRAM_NAME_AND_PROGRAM_VERSION varchar(80), # 8 HOMEPAGE varchar(80), # 9 ARCHIVE_TYPE varchar(8), # 10 ARCHIVE_SIZE INT # 11
);