CREATE TABLE goukei ( turisenn double default '0' not null, azukari double default '0' not null, nyuukinn double default '0' not null, shukkinn double default '0' not null, zeikinn double default '0' not null, uchizei double default '0' not null, hikazei double default '0' not null, uchizeitaishou double default '0' not null, sotozeitaishou double default '0' not null, goukeiid integer default '0' not null, hikazeiwaribiki double default '0' not null, uchizeitaishouwaribiki double default '0' not null, sotozeitaishouwaribiki double default '0' not null, point double default '0' not null, kakinn double default '0' not null, waribikiritsu smallint default '0' not null ); CREATE TABLE kakeurishori ( kakeurishoriid int primary key auto_increment, maindate datetime, tanntoushaid integer default '0' not null, nyushukkaid integer default '0' not null ); CREATE TABLE sethannbai ( sethannbaiid int primary key auto_increment, shouhinnid integer default '0' not null, groupid integer default '0' not null, groupmei varchar(50), nebikigaku double default '0' not null, barcodeno varchar(50), priority integer default '0' not null ); CREATE TABLE kokyaku ( kokyakuid int primary key auto_increment, 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 primary key auto_increment, 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 double default '0' not null, shukkasuu double default '0' not null, shoukei double default '0' not null, nebikigaku double default '0' not null, tanaoroshisuu double default '0' not null ); CREATE TABLE sethannbaisub ( nyushukkaid integer default '0' not null, groupid integer default '0' not null, nyuukasuu double default '0' not null, shukkasuu double default '0' not null, shoukei double default '0' not null, nebikigaku double default '0' not null ); CREATE TABLE seisann ( souuriagekosuu double default '0' not null, souuriagekinngaku double default '0' not null, jyunnuriagekennsuu double default '0' not null, jyunnuriagekinngaku double default '0' not null, waribikigoukei double default '0' not null, nebikigoukei double default '0' not null, uchizeikinngaku double default '0' not null, uchizeitaishou double default '0' not null, sotozeikinngaku double default '0' not null, sotozeitaishou double default '0' not null, hikazeitaishou double default '0' not null, hennpinnkennsuu double default '0' not null, hennpinnkinngaku double default '0' not null, gennkinnuriagekennsuu double default '0' not null, gennkinnuriagekinngaku double default '0' not null, kakeuriagekennsuu double default '0' not null, kakeuriagekinngaku double default '0' not null, carduriagekennsuu double default '0' not null, carduriagekennsuu1 double default '0' not null, carduriagekennsuu2 double default '0' not null, carduriagekennsuu3 double default '0' not null, carduriagekennsuu4 double default '0' not null, carduriagekennsuu5 double default '0' not null, carduriagekennsuu6 double default '0' not null, carduriagekennsuu7 double default '0' not null, carduriagekennsuu8 double default '0' not null, carduriagekennsuu9 double default '0' not null, carduriagekennsuu10 double default '0' not null, carduriagekennsuu11 double default '0' not null, carduriagekennsuu12 double default '0' not null, carduriagekennsuu13 double default '0' not null, carduriagekennsuu14 double default '0' not null, carduriagekennsuu15 double default '0' not null, carduriagekennsuu16 double default '0' not null, carduriagekennsuu17 double default '0' not null, carduriagekennsuu18 double default '0' not null, carduriagekennsuu19 double default '0' not null, carduriagekennsuu20 double default '0' not null, carduriagekinngaku double default '0' not null, carduriagekinngaku1 double default '0' not null, carduriagekinngaku2 double default '0' not null, carduriagekinngaku3 double default '0' not null, carduriagekinngaku4 double default '0' not null, carduriagekinngaku5 double default '0' not null, carduriagekinngaku6 double default '0' not null, carduriagekinngaku7 double default '0' not null, carduriagekinngaku8 double default '0' not null, carduriagekinngaku9 double default '0' not null, carduriagekinngaku10 double default '0' not null, carduriagekinngaku11 double default '0' not null, carduriagekinngaku12 double default '0' not null, carduriagekinngaku13 double default '0' not null, carduriagekinngaku14 double default '0' not null, carduriagekinngaku15 double default '0' not null, carduriagekinngaku16 double default '0' not null, carduriagekinngaku17 double default '0' not null, carduriagekinngaku18 double default '0' not null, carduriagekinngaku19 double default '0' not null, carduriagekinngaku20 double default '0' not null, shouhinnkennuriagekennsuu double default '0' not null, shouhinnkennuriagekennsuu1 double default '0' not null, shouhinnkennuriagekennsuu2 double default '0' not null, shouhinnkennuriagekennsuu3 double default '0' not null, shouhinnkennuriagekennsuu4 double default '0' not null, shouhinnkennuriagekennsuu5 double default '0' not null, shouhinnkennuriagekennsuu6 double default '0' not null, shouhinnkennuriagekennsuu7 double default '0' not null, shouhinnkennuriagekennsuu8 double default '0' not null, shouhinnkennuriagekennsuu9 double default '0' not null, shouhinnkennuriagekennsuu10 double default '0' not null, shouhinnkennuriagekennsuu11 double default '0' not null, shouhinnkennuriagekennsuu12 double default '0' not null, shouhinnkennuriagekennsuu13 double default '0' not null, shouhinnkennuriagekennsuu14 double default '0' not null, shouhinnkennuriagekennsuu15 double default '0' not null, shouhinnkennuriagekennsuu16 double default '0' not null, shouhinnkennuriagekennsuu17 double default '0' not null, shouhinnkennuriagekennsuu18 double default '0' not null, shouhinnkennuriagekennsuu19 double default '0' not null, shouhinnkennuriagekennsuu20 double default '0' not null, shouhinnkennuriagekinngaku double default '0' not null, shouhinnkennuriagekinngaku1 double default '0' not null, shouhinnkennuriagekinngaku2 double default '0' not null, shouhinnkennuriagekinngaku3 double default '0' not null, shouhinnkennuriagekinngaku4 double default '0' not null, shouhinnkennuriagekinngaku5 double default '0' not null, shouhinnkennuriagekinngaku6 double default '0' not null, shouhinnkennuriagekinngaku7 double default '0' not null, shouhinnkennuriagekinngaku8 double default '0' not null, shouhinnkennuriagekinngaku9 double default '0' not null, shouhinnkennuriagekinngaku10 double default '0' not null, shouhinnkennuriagekinngaku11 double default '0' not null, shouhinnkennuriagekinngaku12 double default '0' not null, shouhinnkennuriagekinngaku13 double default '0' not null, shouhinnkennuriagekinngaku14 double default '0' not null, shouhinnkennuriagekinngaku15 double default '0' not null, shouhinnkennuriagekinngaku16 double default '0' not null, shouhinnkennuriagekinngaku17 double default '0' not null, shouhinnkennuriagekinngaku18 double default '0' not null, shouhinnkennuriagekinngaku19 double default '0' not null, shouhinnkennuriagekinngaku20 double default '0' not null, nyuukinn double default '0' not null, shukkinn double default '0' not null, gennkinnaridaka double default '0' not null, regiaridaka double default '0' not null, gennkinnkabusoku double 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 primary key auto_increment, kakinngaku double default '0' not null, ryougaekaisuu double default '0' not null, registerno varchar(50), memo varchar(255), seisannno integer default '0' not null ); CREATE TABLE shainn ( shainnid int primary key auto_increment, shainnmei varchar(50), shainnmeikana varchar(50), barcodeno varchar(50), password varchar(50) ); CREATE TABLE shiiresaki ( shiiresakiid int primary key auto_increment, 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 primary key auto_increment, shouhinnmei varchar(100), zaikokijyunn double default '0' not null, shiirekakaku double default '0' not null, shouhinnmeikana varchar(100), memo varchar(50), barcodeno varchar(50), shortcutkey smallint default '0' not null, hannbaikakaku double 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 longblob, picturename varchar(50) );