sqlite
数据库
con.Execute(string.Format(@"CREATE TABLE Category (
Id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
Name VARCHAR (50) NOT NULL,
Pid INTEGER, CreationTime datetime,
Sort INT,
LastModificationTime datetime
);"));
con.Execute(string.Format(@"CREATE TABLE TableInfo (
Id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
Name VARCHAR (50) UNIQUE NOT NULL)
;"));
con.Execute(string.Format(@"CREATE TABLE Column (
Id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
Name VARCHAR (50) ,
Text VARCHAR (50) ,
TableId INTEGER)
;"));
con.Execute(string.Format(@"CREATE TABLE NumberInfo (
Id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
Number VARCHAR (50) UNIQUE NOT NULL,
OldPass VARCHAR (50) ,
NewPass VARCHAR (50) ,
Phone VARCHAR (50),
MobileToken VARCHAR (50),
FullName VARCHAR (50),
IdCard VARCHAR (50),
CommonIp VARCHAR (50),
Mark VARCHAR (50),
CategoryId INTEGER,
Status INT,
Sell BOOLEAN,
Rank INT,
CreationTime datetime,
LastModificationTime datetime,
Dnf VARCHAR (500),
IsSearchDnf BOOLEAN DEFAULT 0,
IsDeleteFriend BOOLEAN DEFAULT 0
);"));
con.Execute(string.Format(@"CREATE TABLE PhoneInfo (
Id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
PhoneNumber VARCHAR (50) UNIQUE NOT NULL,
ImSi VARCHAR (50) ,
CcId VARCHAR (50) ,
Pass VARCHAR (50) ,
Balance VARCHAR (50) ,
Type INT,
State INT,
DirectoryId INTEGER,
Mark VARCHAR (50),
CreationTime datetime,
LastModificationTime datetime
);"));
con.Execute(string.Format(@"CREATE TABLE Directory (
Id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
Name VARCHAR (50) NOT NULL,
Pid INTEGER, CreationTime datetime,
Sort INT,
LastModificationTime datetime
);"));
作者:银龙
-------------------------------------------
个性签名:独学而无友,则孤陋而寡闻。做一个灵魂有趣的人!
如果觉得这篇文章对你有小小的帮助的话,记得在右下角点个“推荐”哦,博主在此感谢!
万水千山总是情,打赏一分行不行,所以如果你心情还比较高兴,也是可以扫码打赏博主,哈哈哈(っ•̀ω•́)っ✎⁾⁾!