CREATE TABLE address_book_folder (
ID int NOT NULL ,
path text NOT NULL,
Name varchar(45) NOT NULL default '',
[ User] varchar(45) NOT NULL default '',
updateDate datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ID)
)--select * from address_book_folderINSERT INTO address_book_folder (ID,path,[Name],[User],updateDate) VALUES (1,'','test','jack','2008-12-30 11:15:09')--drop table address_book_folder
ID int NOT NULL ,
path text NOT NULL,
Name varchar(45) NOT NULL default '',
[ User] varchar(45) NOT NULL default '',
updateDate datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ID)
)--select * from address_book_folderINSERT INTO address_book_folder (ID,path,[Name],[User],updateDate) VALUES (1,'','test','jack','2008-12-30 11:15:09')--drop table address_book_folder
ID int NOT NULL ,
path text NOT NULL,
Name varchar(45) NOT NULL default '',
[ User] varchar(45) NOT NULL default '', 改成 [user]
updateDate datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ID)
)--select * from address_book_folderINSERT INTO address_book_folder (ID,path,[Name],[User],updateDate) VALUES (1,'','test','jack','2008-12-30 11:15:09')--drop table address_book_folder
ID int NOT NULL ,
path text NOT NULL,
Name varchar(45) NOT NULL default '',
[User] varchar(45) NOT NULL default '',
updateDate datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ID)
)--select * from address_book_folderINSERT INTO address_book_folder (ID,path,[Name],[User],updateDate) VALUES (1,'','test','jack','2008-12-30 11:15:09')--drop table address_book_folder
ID int NOT NULL ,
path text NOT NULL,
Name varchar(45) NOT NULL default '',
[User] varchar(45) NOT NULL default '',
updateDate datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ID)
)--select * from address_book_folderINSERT INTO address_book_folder (ID,path,[Name],[User],updateDate) VALUES (1,'','test','jack','2008-12-30 11:15:09')--drop table address_book_folder
ID int NOT NULL ,
path text NOT NULL,
Name varchar(45) NOT NULL default '',
[ User] varchar(45) NOT NULL default '',
updateDate datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ID)
)
要写标准了
要不然这样
CREATE TABLE address_book_folder (
id2 int NOT NULL ,
path text NOT NULL,
names varchar(45) NOT NULL default '',
users varchar(45) NOT NULL default '',
updateDate datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id2)
)--select * from address_book_folderINSERT INTO address_book_folder (id2,path,names,users,updateDate) VALUES (1,'','test','jack','2008-12-30 11:15:09')--drop table address_book_folder