CREATE TABLE goukei ( turisenn float default '0' not null, azukari float default '0' not null, nyuukinn float default '0' not null, shukkinn float default '0' not null, zeikinn float default '0' not null, uchizei float default '0' not null, hikazei float default '0' not null, uchizeitaishou float default '0' not null, sotozeitaishou float default '0' not null, goukeiid integer default '0' not null, hikazeiwaribiki float default '0' not null, uchizeitaishouwaribiki float default '0' not null, sotozeitaishouwaribiki float default '0' not null, point float default '0' not null, kakinn float default '0' not null, waribikiritsu smallint default '0' not null ); CREATE TABLE kakeurishori ( kakeurishoriid int identity(1,1) primary key, maindate datetime, tanntoushaid integer default '0' not null, nyushukkaid integer default '0' not null ); CREATE TABLE sethannbai ( sethannbaiid int identity(1,1) primary key, shouhinnid integer default '0' not null, groupid integer default '0' not null, groupmei varchar(50), nebikigaku float default '0' not null, barcodeno varchar(50), priority integer default '0' not null ); CREATE TABLE kokyaku ( kokyakuid int identity(1,1) primary key, cardid varchar(50), nyuukaidate datetime, kokyakumei varchar(50), kokyakumeikana varchar(50), email varchar(50), tel varchar(50), fax varchar(50), postcode varchar(50), address varchar(100), birthday datetime, sex varchar(50), pointstartdate datetime, bunnrui varchar(50), memo1 varchar(50), memo2 varchar(50), yuukoukigenn datetime, nebiki integer default '0' not null, pointtaishou smallint default '0' not null ); CREATE TABLE nyushukkamain ( nyushukkaid int identity(1,1) primary key, category varchar(50), maindate datetime, shainnid integer default '0' not null, kionn integer default '0' not null, dennpyouno integer default '0' not null, olddennpyouno integer default '0' not null, kokyakuid integer default '0' not null, tennki varchar(50), sex varchar(50), age integer default '0' not null, registerno integer default '0' not null, shiiresakiid integer default '0' not null, idounyushukkotennpo integer default '0' not null, subcategoryid integer default '0' not null, ichijihojigyoumuuketoridate datetime, ichibunyuukinn smallint default '0' not null, kyakusuu integer default '0' not null, ichijihojigyoumuhannbai smallint default '0' not null, seisannno integer default '0' not null, koumoku varchar(50), memo varchar(50) ); CREATE TABLE nyushukkasub ( nyushukkaid integer default '0' not null, shouhinnid integer default '0' not null, shouhinnmei varchar(100), nyuukasuu float default '0' not null, shukkasuu float default '0' not null, shoukei float default '0' not null, nebikigaku float default '0' not null, tanaoroshisuu float default '0' not null ); CREATE TABLE sethannbaisub ( nyushukkaid integer default '0' not null, groupid integer default '0' not null, nyuukasuu float default '0' not null, shukkasuu float default '0' not null, shoukei float default '0' not null, nebikigaku float default '0' not null ); CREATE TABLE seisann ( souuriagekosuu float default '0' not null, souuriagekinngaku float default '0' not null, jyunnuriagekennsuu float default '0' not null, jyunnuriagekinngaku float default '0' not null, waribikigoukei float default '0' not null, nebikigoukei float default '0' not null, uchizeikinngaku float default '0' not null, uchizeitaishou float default '0' not null, sotozeikinngaku float default '0' not null, sotozeitaishou float default '0' not null, hikazeitaishou float default '0' not null, hennpinnkennsuu float default '0' not null, hennpinnkinngaku float default '0' not null, gennkinnuriagekennsuu float default '0' not null, gennkinnuriagekinngaku float default '0' not null, kakeuriagekennsuu float default '0' not null, kakeuriagekinngaku float default '0' not null, carduriagekennsuu float default '0' not null, carduriagekennsuu1 float default '0' not null, carduriagekennsuu2 float default '0' not null, carduriagekennsuu3 float default '0' not null, carduriagekennsuu4 float default '0' not null, carduriagekennsuu5 float default '0' not null, carduriagekennsuu6 float default '0' not null, carduriagekennsuu7 float default '0' not null, carduriagekennsuu8 float default '0' not null, carduriagekennsuu9 float default '0' not null, carduriagekennsuu10 float default '0' not null, carduriagekennsuu11 float default '0' not null, carduriagekennsuu12 float default '0' not null, carduriagekennsuu13 float default '0' not null, carduriagekennsuu14 float default '0' not null, carduriagekennsuu15 float default '0' not null, carduriagekennsuu16 float default '0' not null, carduriagekennsuu17 float default '0' not null, carduriagekennsuu18 float default '0' not null, carduriagekennsuu19 float default '0' not null, carduriagekennsuu20 float default '0' not null, carduriagekinngaku float default '0' not null, carduriagekinngaku1 float default '0' not null, carduriagekinngaku2 float default '0' not null, carduriagekinngaku3 float default '0' not null, carduriagekinngaku4 float default '0' not null, carduriagekinngaku5 float default '0' not null, carduriagekinngaku6 float default '0' not null, carduriagekinngaku7 float default '0' not null, carduriagekinngaku8 float default '0' not null, carduriagekinngaku9 float default '0' not null, carduriagekinngaku10 float default '0' not null, carduriagekinngaku11 float default '0' not null, carduriagekinngaku12 float default '0' not null, carduriagekinngaku13 float default '0' not null, carduriagekinngaku14 float default '0' not null, carduriagekinngaku15 float default '0' not null, carduriagekinngaku16 float default '0' not null, carduriagekinngaku17 float default '0' not null, carduriagekinngaku18 float default '0' not null, carduriagekinngaku19 float default '0' not null, carduriagekinngaku20 float default '0' not null, shouhinnkennuriagekennsuu float default '0' not null, shouhinnkennuriagekennsuu1 float default '0' not null, shouhinnkennuriagekennsuu2 float default '0' not null, shouhinnkennuriagekennsuu3 float default '0' not null, shouhinnkennuriagekennsuu4 float default '0' not null, shouhinnkennuriagekennsuu5 float default '0' not null, shouhinnkennuriagekennsuu6 float default '0' not null, shouhinnkennuriagekennsuu7 float default '0' not null, shouhinnkennuriagekennsuu8 float default '0' not null, shouhinnkennuriagekennsuu9 float default '0' not null, shouhinnkennuriagekennsuu10 float default '0' not null, shouhinnkennuriagekennsuu11 float default '0' not null, shouhinnkennuriagekennsuu12 float default '0' not null, shouhinnkennuriagekennsuu13 float default '0' not null, shouhinnkennuriagekennsuu14 float default '0' not null, shouhinnkennuriagekennsuu15 float default '0' not null, shouhinnkennuriagekennsuu16 float default '0' not null, shouhinnkennuriagekennsuu17 float default '0' not null, shouhinnkennuriagekennsuu18 float default '0' not null, shouhinnkennuriagekennsuu19 float default '0' not null, shouhinnkennuriagekennsuu20 float default '0' not null, shouhinnkennuriagekinngaku float default '0' not null, shouhinnkennuriagekinngaku1 float default '0' not null, shouhinnkennuriagekinngaku2 float default '0' not null, shouhinnkennuriagekinngaku3 float default '0' not null, shouhinnkennuriagekinngaku4 float default '0' not null, shouhinnkennuriagekinngaku5 float default '0' not null, shouhinnkennuriagekinngaku6 float default '0' not null, shouhinnkennuriagekinngaku7 float default '0' not null, shouhinnkennuriagekinngaku8 float default '0' not null, shouhinnkennuriagekinngaku9 float default '0' not null, shouhinnkennuriagekinngaku10 float default '0' not null, shouhinnkennuriagekinngaku11 float default '0' not null, shouhinnkennuriagekinngaku12 float default '0' not null, shouhinnkennuriagekinngaku13 float default '0' not null, shouhinnkennuriagekinngaku14 float default '0' not null, shouhinnkennuriagekinngaku15 float default '0' not null, shouhinnkennuriagekinngaku16 float default '0' not null, shouhinnkennuriagekinngaku17 float default '0' not null, shouhinnkennuriagekinngaku18 float default '0' not null, shouhinnkennuriagekinngaku19 float default '0' not null, shouhinnkennuriagekinngaku20 float default '0' not null, nyuukinn float default '0' not null, shukkinn float default '0' not null, gennkinnaridaka float default '0' not null, regiaridaka float default '0' not null, gennkinnkabusoku float default '0' not null, currency1yen integer default '0' not null, currency5yen integer default '0' not null, currency10yen integer default '0' not null, currency50yen integer default '0' not null, currency100yen integer default '0' not null, currency500yen integer default '0' not null, currency1000yen integer default '0' not null, currency2000yen integer default '0' not null, currency5000yen integer default '0' not null, currency10000yen integer default '0' not null, checkdate datetime, seisannid int identity(1,1) primary key, kakinngaku float default '0' not null, ryougaekaisuu float default '0' not null, registerno varchar(50), memo varchar(255), seisannno integer default '0' not null ); CREATE TABLE shainn ( shainnid int identity(1,1) primary key, shainnmei varchar(50), shainnmeikana varchar(50), barcodeno varchar(50), password varchar(50) ); CREATE TABLE shiiresaki ( shiiresakiid int identity(1,1) primary key, shiiresakimei varchar(100), shiiresakimeikana varchar(100), email varchar(50), tel varchar(50), fax varchar(50), postcode varchar(50), address varchar(50), memo1 varchar(50), memo2 varchar(50), memo3 varchar(50) ); CREATE TABLE shouhinn ( shouhinnid int identity(1,1) primary key, shouhinnmei varchar(100), zaikokijyunn float default '0' not null, shiirekakaku float default '0' not null, shouhinnmeikana varchar(100), memo varchar(50), barcodeno varchar(50), shortcutkey smallint default '0' not null, hannbaikakaku float default '0' not null, bumonn varchar(50), shiiresaki varchar(50), tax varchar(50), kosuutanni varchar(50), tourokudate datetime, memo1 varchar(50), memo2 varchar(50), memo3 varchar(50), memo4 varchar(50), memo5 varchar(50), tennpono integer default '0' not null, nebikiwaribikitaishou smallint default '0' not null, pointtaishou smallint default '0' not null, macrofilepath varchar(50), picture image, picturename varchar(50) );