Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Last revisionBoth sides next revision | ||
| 11_26_2018 [2018/11/26 21:26] – cynthia.kahn | 11_26_2018 [2018/11/26 21:27] – cynthia.kahn | ||
|---|---|---|---|
| Line 16: | Line 16: | ||
| \\ | \\ | ||
| CREATE TABLE users_info( \\ | CREATE TABLE users_info( \\ | ||
| - | userID BIGINT, | + | userID BIGINT, |
| - | userName TEXT, \\ | + | userName TEXT, |
| - | screenName TEXT, \\ | + | screenName TEXT, |
| - | userLocation TEXT, \\ | + | userLocation TEXT, |
| - | url TEXT, \\ | + | url TEXT, |
| - | description TEXT, \\ | + | description TEXT, |
| - | translatorType TEXT, \\ | + | translatorType TEXT, |
| - | protected TEXT, \\ | + | protected TEXT, |
| - | verified TEXT, \\ | + | verified TEXT, |
| - | followersCount INTEGER, | + | followersCount INTEGER, |
| - | friendsCount INTEGER, | + | friendsCount INTEGER, |
| - | listedCount INTEGER, | + | listedCount INTEGER, |
| - | favouritesCount INTEGER, | + | favouritesCount INTEGER, |
| - | statusesCount INTEGER, | + | statusesCount INTEGER, |
| - | userCreated VARCHAR(50), | + | userCreated VARCHAR(50), |
| - | | + | |
| - | userTimeZone VARCHAR(50), | + | userTimeZone VARCHAR(50), |
| - | geoEnabled TEXT, \\ | + | geoEnabled TEXT, |
| - | lang TEXT, \\ | + | lang TEXT, |
| - | contributorsEnabled TEXT, \\ | + | contributorsEnabled TEXT, |
| - | isTranslator TEXT, \\ | + | isTranslator TEXT, |
| - | profileBackgroundColor TEXT, \\ | + | profileBackgroundColor TEXT, |
| - | profileBackgroundImageURL TEXT, \\ | + | profileBackgroundImageURL TEXT, |
| - | profileBackgroundTile TEXT, \\ | + | profileBackgroundTile TEXT, |
| - | profileLinkColor TEXT, \\ | + | profileLinkColor TEXT, |
| - | profileSidebarBorderColor TEXT, \\ | + | profileSidebarBorderColor TEXT, |
| - | profileSidebarFillColor TEXT, \\ | + | profileSidebarFillColor TEXT, |
| - | profileTextColor TEXT, \\ | + | profileTextColor TEXT, |
| - | profileUseBackgroundImage TEXT, \\ | + | profileUseBackgroundImage TEXT, |
| - | profileImageURL TEXT, \\ | + | profileImageURL TEXT, |
| - | defaultProfile TEXT, \\ | + | defaultProfile TEXT, |
| - | defaultProfileImage TEXT, \\ | + | defaultProfileImage TEXT, |
| - | userFollowing TEXT, \\ | + | userFollowing TEXT, |
| - | followRequestSent TEXT, \\ | + | followRequestSent TEXT, |
| - | notifications TEXT \\ | + | notifications TEXT |
| ); | ); | ||
| - | |||