5 replies

SQL multiple table same unique id

Hello,
How can I create same unique id in multiple tables.

CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
        username TEXT    NOT NULL,
        email TEXT)

CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
        username TEXT    NOT NULL,
        email TEXT)

CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
        username TEXT    NOT NULL,
        email TEXT)

CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
        username TEXT    NOT NULL,
        email TEXT)

CREATE TABLE IF NOT EXISTS order (
        id FROM users(id),
        address TEXT)

CREATE TABLE IF NOT EXISTS order (
        id FROM users(id),
        address TEXT)

CREATE TABLE IF NOT EXISTS order (
        id FROM users(id),
        address TEXT)

CREATE TABLE IF NOT EXISTS order (
        id FROM users(id),
        address TEXT)