2005-07-06 PyAccess
{{{发件人: mahongquan <[email protected]> 回复: [email protected] 收件人: [email protected] 日期: 2005-7-6 上午10:08 }}}[wiki:PyCNmail/2005-July/012419.html from access extract sql, isql for access]
cmds=[ """CREATE TABLE [CaliHis] ( [id] integer not null , [mdate] datetime null , [methodid] integer null , [ele] varchar(2.0) null , [useXiaoZheng] smallint null , [dxielv] float null , [djieju] float null ) """, """Alter TABLE [CaliHis] ADD Primary Key([id] ) [PK_CaliHis]""", """CREATE TABLE [chanel] ( [ele] varchar(50.0) null , [id] integer not null , [chanel] smallint null ) """, """Alter TABLE [chanel] ADD Primary Key([id] ) [PK_chanel]""", """CREATE TABLE [curveData] ( [methodid] integer null , [standardid] integer null , [eleArea] float null , [eleInt] float null , [ele] varchar(2.0) null , [weight] float null , [id] integer not null , [calcconc] float null , [sampleid] integer null , [quan] float null , [wlweight] float null ) """, """Alter TABLE [curveData] ADD Primary Key([id] ) [PK_curveData]""", """CREATE TABLE [CurveHis] ( [id] integer not null , [methodid] integer null , [mdate] datetime null , [x0] float null , [x1] float null , [x2] float null , [x3] float null , [ele] varchar(2.0) null , [r] float null , [cishu] integer null , [stderr] float null , [LINExishu] real null , [min] float null , [max] float null ) """, """Alter TABLE [CurveHis] ADD Primary Key([id] ) [PK_CurveHis]""", """CREATE TABLE [curveXishu] ( [methodid] integer not null , [x0] float null , [x1] float null , [x2] float null , [x3] float null , [ele] varchar(2.0) not null , [xadd] float null , [r] float null , [fitMode] integer null , [cishu] integer null , [stderr] float null , [LINExishu] real null , [calcmode] smallint null , [useXiaoZheng] smallint null , [dxielv] float null , [djieju] float null , [UseInt] bit not null , [min] float null , [max] float null , [blankarea] float null , [must00] bit not null ) """, """Alter TABLE [curveXishu] ADD Primary Key([methodid] ,[ele] ) [PK_curveXishu]""", """CREATE TABLE [doChanel] ( [cname] varchar(50.0) null , [id] integer not null , [chanel] smallint null ) """, """Alter TABLE [doChanel] ADD Primary Key([id] ) [PK_doChanel]""", """CREATE TABLE [doublestandard] ( [ID] integer not null , [standardid] integer not null , [methodid] integer not null , [ele] varchar(2.0) not null , [calcConc] float null , [high] bit not null , [eleArea] float null , [weight] float null ) """, """Alter TABLE [doublestandard] ADD Primary Key([standardid] ,[methodid] ,[ele] ) [PK_doublestandard]""", """CREATE TABLE [method] ( [ID] integer not null , [user] varchar(50.0) not null , [name] varchar(50.0) not null , [power] integer null , [zerovalue] real null , [useJiaozheng] bit not null , [cswitch] float null , [sswitch] float null , [smoothnum] smallint null , [sampletime] integer null , [flushtime] integer null ) """, """Alter TABLE [method] ADD Primary Key([user] ,[name] ) [PK_method]""", """CREATE TABLE [muser] ( [ID] integer not null , [mname] varchar(50.0) not null , [autoweight] bit not null , [mpassword] varchar(10.0) null , [method] varchar(50.0) null , [methodid] integer null ) """, """Alter TABLE [muser] ADD Primary Key([mname] ) [PK_muser]""", """CREATE TABLE [mytmp] ( [methodid] integer null , [standardid] integer null , [eleArea] float null , [eleInt] float null , [ele] varchar(2.0) null , [weight] float null , [calcconc] float null , [sampleid] integer null ) """, """CREATE INDEX [] on [mytmp]() """, """CREATE TABLE [netSet] ( [ip] varchar(50.0) null , [port] integer null , [prot] bit not null , [id] integer not null ) """, """Alter TABLE [netSet] ADD Primary Key([id] ) [PK_netSet]""", """CREATE TABLE [program] ( [tablehead1] varchar(50.0) null , [tablehead2] varchar(50.0) null , [id] integer not null , [sampleId] integer null , [isON] bit not null , [xuhao] smallint null , [sessionid] integer null , [lastUser] varchar(50.0) null , [autoLogon] bit not null ) """, """Alter TABLE [program] ADD Primary Key([id] ) [PK_program]""", """CREATE TABLE [sample] ( [ID] integer not null , [name] varchar(50.0) null , [cArea] float null , [c] real null , [sArea] float null , [s] real null , [mdate] datetime null , [user] varchar(50.0) null , [weight] float null , [method] varchar(50.0) null , [methodid] integer null , [isHc] bit not null , [isHs] bit not null , [sessionid] integer null , [sampleid] integer null , [anaxuhao] integer null , [cInt] float null , [sInt] float null , [sIndex] integer null , [cIndex] integer null , [standardid] integer null , [sIndex2] integer null , [cIndex2] integer null , [wlweight] float null ) """, """Alter TABLE [sample] ADD Primary Key([ID] ) [PK_sample]""", """CREATE TABLE [SampleAve] ( [sessionid] integer null , [sampleid] integer not null , [c] real null , [s] real null , [mdate] datetime null , [name] varchar(255.0) null , [user] varchar(20.0) null , [methodid] integer null , [num] smallint null , [cstd] float null , [sstd] float null ) """, """Alter TABLE [SampleAve] ADD Primary Key([sampleid] ) [PK_SampleAve]""", """CREATE TABLE [SingleStandard] ( [ID] integer not null , [standardid] integer null , [eleArea] float null , [weight] float null , [methodid] integer null , [ele] varchar(2.0) null , [IsBlank] bit not null , [xishu] float null , [calcConc] float null ) """, """Alter TABLE [SingleStandard] ADD Primary Key([ID] ) [PK_SingleStandard]""", """CREATE TABLE [standard] ( [ID] integer not null , [name] varchar(50.0) null , [cconc] real null , [sconc] real null , [description] varchar(50.0) null , [userid] integer null ) """, """Alter TABLE [standard] ADD Primary Key([ID] ) [PK_standard]""", """CREATE TABLE [tmp] ( [methodid] integer null , [standardid] integer null , [sampleid] integer null , [ele] varchar(2.0) null , [elearea] float null , [weight] float null , [quan] float null ) """, """CREATE INDEX [] on [tmp]() """, """CREATE TABLE [tmpid] ( [sampleid] integer not null ) """, """Alter TABLE [tmpid] ADD Primary Key([sampleid] ) [PK_tmpid]""", """CREATE TABLE [tmpReport] ( [id] integer not null , [sessionid] integer null , [sampleid] integer null , [c] real null , [s] real null , [mdate] datetime null , [name] varchar(255.0) null , [user] varchar(20.0) null , [methodid] integer null , [num] smallint null , [cstd] float null , [sstd] float null ) """, """Alter TABLE [tmpReport] ADD Primary Key([id] ) [PK_tmpReport]""", """CREATE TABLE [usehistory] ( [ID] integer not null , [user] varchar(50.0) null , [starttime] datetime null , [endtime] datetime null ) """, """Alter TABLE [usehistory] ADD Primary Key([ID] ) [PK_usehistory]""", """CREATE TABLE [volt] ( [mtime] float null , [cvolt] float null , [svolt] float null , [sampleid] integer null , [id] integer not null , [c2volt] float null , [s2volt] float null ) """, """CREATE Unique INDEX [id1] on [volt]([id] ) """, """CREATE TABLE [VoltNew] ( [sampleid] integer not null , [mtimeArr] text null , [cvoltArr] text null , [svoltArr] text null , [c2voltArr] text null , [s2voltArr] text null , [xn] integer null , [yn0] integer null , [yn1] integer null , [yn2] integer null , [yn3] integer null ) """, """Alter TABLE [VoltNew] ADD Primary Key([sampleid] ) [PK_VoltNew]""", """CREATE TABLE [weight] ( [id] integer not null , [time] datetime null , [name] varchar(50.0) null , [weight] float null ) """, """Alter TABLE [weight] ADD Primary Key([id] ) [PK_weight]""", ]