def crtTbl():
Db.createTable("accountGroups", (
"`id` INTEGER PRIMARY KEY UNIQUE",
"`ownerId` INTEGER NOT NULL",
"`name` VARCHAR(48) NOT NULL",
"`description` VARCHAR(255) DEFAULT ''",
))
def crtTbl(): Db.createTable(table, ( "`id` INTEGER PRIMARY KEY UNIQUE", "`firstName` VARCHAR(48) NOT NULL", "`lastName` VARCHAR(48) NOT NULL", "`tags` VARCHAR(1024) NOT NULL", "`description` VARCHAR(255) DEFAULT ''", ))
def crtTbl(): Db.createTable(table, ( "`network` CHAR(18) PRIMARY KEY UNIQUE", "`gateway` CHAR(15) NOT NULL", "`name` VARCHAR(48) NOT NULL", "`disabled` INTEGER DEFAULT 0", "`description` VARCHAR(255) DEFAULT ''", ))
def crtTbl():
Db.createTable(table, (
"`id` VARCHAR(48) NOT NULL UNIQUE",
"`name` VARCHAR(48)",
"`os` VARCHAR(12)",
"`osName` VARCHAR(48)",
"`auth` CHAR(6)",
"`agent` VARCHAR(24)",
"`addresses` VARCHAR(255)",
"`description` VARCHAR(255) DEFAULT ''",
))
def crtTbl():
Db.createTable(
table,
("`id` INTEGER PRIMARY KEY UNIQUE",
"`ownerId` INTEGER NOT NULL", "`login` VARCHAR(24) NOT NULL",
"`password` VARCHAR(64) NOT NULL",
"`tags` VARCHAR(1024) NOT NULL",
"`lastChange` CHAR(19) NOT NULL", "`expired` CHAR(19)",
"`publicKey` VARCHAR(1548) NOT NULL",
"`secretKey` VARCHAR(3048) NOT NULL",
"`description` VARCHAR(255) DEFAULT ''"))
def crtTbl():
Db.createTable("user_group", (
"`userId` INTEGER NOT NULL",
"`groupId` INTEGER NOT NULL",
))
def crtTbl():
Db.createTable("account_group", (
"`accountId` INTEGER NOT NULL",
"`groupId` INTEGER NOT NULL",
))
def crtTbl(): Db.createTable(table, ( "`id` CHAR(36) NOT NULL UNIQUE", "`created` CHAR(19) NOT NULL", "`userId` INTEGER" ))