b_ipol_dpd_location.sql 447 B

123456789101112131415161718
  1. create table IF NOT EXISTS b_ipol_dpd_location (
  2. ID INTEGER PRIMARY KEY AUTOINCREMENT,
  3. COUNTRY_CODE varchar(255) null,
  4. COUNTRY_NAME varchar(255) null,
  5. REGION_CODE varchar(255) null,
  6. REGION_NAME varchar(255) null,
  7. CITY_ID bigint UNSIGNED NOT NULL default '0',
  8. CITY_CODE varchar(255) null,
  9. CITY_NAME varchar(255) null,
  10. CITY_ABBR varchar(255) null,
  11. LOCATION_ID int not null default '0',
  12. IS_CASH_PAY char(1) not null default 'N'
  13. );